Database

Instance Architecture Enhancements In 12.2(12c R2)

Instance Architecture Enhancements In 12.2(12c R2) From Oracle Database 12c Release 2 (12.2), read-only and read/write instances can co-exist within a single database. It supports for read/write and read-only instances in the same database. As we know that every database instance is either read/write or read-only. Read-Only Instances Read-only instances Read more…

Database

Oracle Database Interview Questions Set-3

1-Maximum levels of Subqueries in a SQL statement we can write? Answer-Unlimited in the FROM clause & 255 Subqueries in the WHERE clause 2-Maximum length of linear partitioning key in Per Partition? Answer-4 KB (overhead) 3-Maximum number of columns in partition key in Per Partition? Answer-(1024K – 1) 4-Maximum number Read more…

Database

Oracle Database Interview Questions Set-2

 1-How many Shared Servers Maximum Per Instance we can Configure? Answer-Unlimited 2- How many Dispatchers Maximum Per Instance we can Configure? Answer-Unlimited 3-How many Parallel Execution Slaves Maximum Per Instance? Answer-Unlimited 4-How many Backup Sessions Maximum Per Instance? Answer-Unlimited 5-How many Services Maximum per Instance? Answer-8200 6-How many Indexes Maximum Read more…