| Parameters | RDS | VDI |
| Each user gets a separate VM | No. Each user gets a session in the same VM | Yes |
| Creates complexity for the IT staff, wherein they have to manage multiple instances of the OS, updating and patching them. | Yes | Easy |
| Multiple users use the same VM and server OS | Yes | Multiple user uses different VM specific to them |
| Does not provide complete administrative rights, as resources have to be shared between multiple users | Yes. | Since it's a single user, you can get admin privilege |
| Cost and complexity is a concern | Yes | No |
| Managing and updating the software is easy | Yes | Yes |
| Less CPU and memory resources are utilized, which facilitates having more users per system | Yes | Obviously need more CPU and Memory in comparison to RDS |
| Local Computer | Need | No need to local computer. |
| Software Requirements | Same set of software used for all users | Different sets of software can be used for different set of users |
| Performance | One heavy user performance will impact other user's performance | Each will work independantly |
| Locally attached USB drives | Not accessible | Accssible. |
Logged operations are replicated. These include, but are not limited to: DDL DML Create/alter table space Create/alter storage group Create/alter buffer pool XML data. Logged LOBs Not logged operations are not replicated. These include, but are not limited to: Database configuration parameters (this allows primary and standby databases to be configured differently). "Not logged initially" tables Not logged LOBs UDF (User Defined Function) libraries. UDF DDL is replicated. But the libraries used by UDF (such as C or Java libraries) are not replicated, because they are not stored in the database. Users must manually copy the libraries to the standby. Note: You can use database configuration parameter BLOCKNONLOGGED to block not logged operations on the primary.
Comments