1-What is Minimum Value of Database Block Size? Answer-2048 bytes (2 KB) (Must be a multiple of operating system physical block size) 2- What is Maximum Value of Database Block Size? Answer-32 KB 3- How many Database Blocks will be allocated in an initial extent of a segment? Answer-2 blocks 4- Read more…
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…
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…
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…