Below are the list of additional privileged user in 12c apart from the privileged user SYSOPER, SYSDBA, SYSASM. SYSBACKUP : It will be used to perform all backup and recovery related operations either via RMAN or SQL*PLUS. SYSDG : It is in place to separate the Data Guard related operations from other activities. SYSKM : It will be responsible for all TDE (Transparent Data … Read more
Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a Table in Oracle. Find the list of top index size corresponding to a table. Check Index Column on a Table in Oracle. Find total index size of respective tables in a schema. Find the list … Read more
In a typical use case, you manually shut down the database, making it unavailable for users while you perform maintenance or other administrative tasks. You can use the SQL*Plus SHUTDOWN command or Enterprise Manager to perform these steps. Phase Mount Stage Description 1 Database closed The database is mounted, but online data files and redo … Read more
Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions every second (waiting for non-idle events, or on the CPU working) from v$sessions (inactive sessions are not captured). You can run ASH reports to analyze transient performance problems with the database that only occur during specific times. This technique is … Read more
The database buffer cache, also called the buffer cache, is the memory area that stores copies of data blocks read from data files. A buffer is a main memory address in which the buffer manager temporarily caches a currently or recently used data block. All users concurrently connected to a database instance share access to the buffer cache. It … Read more
Oracle can store different kind of files under FRA: – backupset: for RMAN regular backups. – datafile: for RMAN image copies. – autobackup: for control file autobackups. – flashback: If your database runs in flashback mode, you will see flashback logs in this subdirectory. – archivelog: for Archived redo logs – controlfile: The control file, … Read more
The pattern-matching conditions compare character data. LIKE Condition * The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another. * The LIKE conditions match a portion of one character value to another by searching the first value for the pattern specified by the second. … Read more
The database control file is a small binary file associated with only one database. Each database has one unique control file, although multiple identical copies are permitted. Use of Control Files Oracle Database uses the control file to locate database files and to manage the state of the database generally. A control file contains information … Read more
If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush the bad SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID So if you want a SQL query to do hard parsing, then you can flush the particular … Read more