December 2021 - ASRblogger

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 all backup and recovery related operations either…

asrblogger December 30, 2021No Comments

Oracle Scripts

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…

asrblogger December 23, 2021No Comments

Oracle

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. You can use the SQL*Plus SHUTDOWN…

asrblogger December 12, 2021No Comments

Password File management in 12C/19C

Determining the Size of Oracle database tables and indexes

Oracle Instance and Database Shutdown Sequence

Trending Topics.

Get the Latest Blogging Tips Straight to Your Inbox!