Home 2021 December

Monthly Archives: December 2021

Password File management in 12C/19C

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...
woman showing measuring tape for checking body forms

Determining the Size of Oracle database tables and indexes

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. set lines 200 col index_name from a30 col column_name for a30 select index_name...
assorted floppy disks

Oracle Instance and Database Shutdown Sequence

In a typical use case, you manually shut down the database, making it unavailable for users while you perform maintenance or other administrative tasks....