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