Application Containers
Lab 9: DBA Views
Overview
In Lab 9 we introduce some of the DBA Views which are
relevant to Application Containers.
Execution
- Open a terminal window
- Change directory to /u01/HOL/app_containers/
- source the environment. At command prompt execute source cdb1.env
- sqlplus /nolog
- At the SQL prompt execute SQL>09.DBA_Views.sql
Review of Application Container Lab7:
Several DBA views are provided, which can help both application developers and application administrators with their work.
Detailed Steps
DBA_PDBs
There are lots of columns in DBA_PDBs, but those shown are among the most relevant to work with Application Containers.
DBA_Applications
wmStore is defined here of course. The more cryptically-named application is the "default application". Any "application action" – essentially DDL or DML – in Application Root is associated with an Application. If one is not explicitly specified in a "begin / end" block, then these application actions are associated with the default Application.
DBA_App_Versions
Besides the default application, described above, we see three rows for application wmStore here – one each for versions 1.0, 2.0 and 3.0.
DBA_App_Patches
Similarly, we see the definition of Patch 301.
DBA_App_PDB_Status
DBA_App_PDB_Status shows us which versions and patches have been applied to which PDBs, with the status in each case.
DBA_App_Statements
DBA_App_Statements shows the various SQL statements that have been "captured" in Application Root, in various Application Actions. These can then be replayed to sync the various Application PDBs.
DBA_App_Errors
DBA_App_Errors will record which statements have failed during a sync. It only makes sense to run this from within an Application PDB.
Click Here to Go to Lab 10