http://www.datadisk.co.uk/html_docs/oracle/memory.htm copy to my blog Oracle Memory Architecture Oracle uses three kinds of memory structures SGA (System Global Area) is a large part of memory that all the oracle background processes access. PGA (Process Global Area) This is memory that is private to a single process or thread and is not accessible by … Читать далее
replace dba_hist_active_sess_history with v$active_session_history to get ash info
CDB and PDB View • CDB_xxx: All of the objects in the CDB across all PDBs • DBA_xxx: All of the objects in a container or PDB • CDB_pdbs: All PDBs within CDB • CDB_tablespaces: All tablespaces within CDB • CDB_users: All users within CDB (common and local) • V$PDBS: Displays information about PDBs associated … Читать далее
A database operation is: • One or more SQL or PL/SQL statements • A series of statements done from on or more sessions A database operation can: • Be monitored • Produce active reports A DB operation is an operation that the database server runs to accomplish tasks. It can be either simple or composite. … Читать далее
Available Redaction Methods Type Description None No redaction is performed. Full Columns are redacted to constant values based on the column data type. Partial User-specified positions are replaced by a user-specified character. Random Data type is preserved and different values are output each time. Regular Expression A “match and replace” based on parameters is performed. … Читать далее
Oracle Database 12c offers a new package to analyze used privileges. Privilege Analysis requires Oracle Database Vault, which is a licensed option. good tutorial: Privilege Analysis Types and Conditions When creating an analysis, you first define the targeted objects to be analyzed in used privileges. You do that by setting the type of analysis: • … Читать далее
An Online Move data file operation is not compatible when: • The data file is an OFFLINE data file • A concurrent flashback database operation is executing • A media recovery is completing • A file shrink operation or tablespace offline/drop operation involving the same file is performing But it is compatible with: • Block … Читать далее
Heat Map and Automatic Data Optimization Heat Map and Automatic Data Optimization: Heat Map and Automatic Data Optimization (ADO) can be used to implement your Information Lifecycle Management (ILM) strategy, along with Partitioning, Advanced Compression, and Hybrid Columnar Compression. usefull links: *youtube Manage Automatic Data Optimization (ADO) with Enterprise Manager Cloud Control 12c Exploring Oracle … Читать далее
Flashback CDB Enable flashback: If the CDB is in ARCHIVELOG mode, there is no need to restart it. Restrictions: • You cannot flash back the root alone without flashing back the entire CDB. • Flashback Database operations on a CDB may not be permitted if point-in-time recovery has been performed on any of its PDBs. … Читать далее
Media Failure CDB Temporary File Recovery • Automatic re-creation of temporary files at CDB opening • Manual re-creation also possible The CDB instance can start up with a missing temporary file. If any of the temporary files do not exist when the CDB instance is started, they are created automatically and the CDB opens normally. … Читать далее