Infrastructure at your Service

Tag

Pluggable Databases Archives - Page 9 of 12 - Blog dbi services

Oracle Team

12c Multitenant: PDB spfile parameters for standby database

By | Database Administration & Monitoring | 9 Comments

By Franck Pachot . In multitenant, the spfile parameters at pluggable database level are not stored in the spfile but in the CDB$ROOT table SYS.PDB_SPFILE$ If you open the standby database in read only for reporting, which is one reason to get Active Data Guard option, you may want different optimizer settings suited for reporting. In non-CDB it’s easy: the standby has its own spfile where parameters can be changed. But for a pluggable database,…

Read More
Oracle Team

12c multitenant: Cursor sharing in CDB

By | Database Administration & Monitoring | 4 Comments

By Franck Pachot . In multitenant, there are two goals: consolidation within the same container database and isolation of pluggable databases. I see multitenant consolidation as an extension of schema consolidation. What is not possible in schema consolidation, such as public objects name collision, is now possible with pluggable databases. 10 years ago I administrated on a database with high level of consolidation: 3000 schemas with same structure and different data. The big scalability issue…

Read More
Oracle Team

awrrpt and spreport in multitenant

By | Database Administration & Monitoring | 3 Comments

By Franck Pachot . Yesterday I was giving my ‘Interpreting AWR Reports’ Prezi at Oracle Midlands. There is a point where I explain that I always check the ‘Captured SQL account for …% of Total DB Time (s)’ in order to know whether I’ll get all details in the report or not. There are two main reasons why the most important statements are not captured: report covering a time window too short, or lot of…

Read More
Oracle Team

PDB snapshot copy for continuous integration testing

By | Database Administration & Monitoring | 5 Comments

By Franck Pachot . How do you manage your continuous integration tests on the database? You need to restart at the same state for probably a hundred of tests. Recreating the schema and test data takes too long. Oracle is not optimized for DDL. Restoring the database takes too long. Even if you data is small, there is those SYSTEM, SYSAUX tablespaces. Flashback database can help, but it still takes time because it requires to…

Read More