Duplicate a Controlfile when ASM is Involved
Duplicating a control file into ASM when original control file is stored on ASM If using spfile: Step 1 Modify the spfile specifically the parameter…
Category: Managing Database
What to do with a query, if a query is generating more redo/archive log?
If a query is generating excessive redo/archive logs in Oracle, it is important to identify the root cause and address it. Here are some steps…
Managing UNDO, Temporary and Redo logs in RAC Environment
In the oracle RAC Environment, each instance store transaction undo data in its dedicated undo Tablespace. We can set the undo Tablespace for each instance…
Create Database manually for File System Storage Mechanism
Step 1: Create a initSID.ora (Example: initRWDB.ora) file in $ORACLE_HOME/dbs/ directory. Example: $ORACLE_HOME/dbs/initRWDB.ora Put following entry in initTEST.ora file *.audit_sys_operations=TRUE *.audit_trail=’db’ *.compatible=’19.3.0.0.0′ *.control_files=’/oracle/DATA/control01.ctl’,’/oracle/DATA/control02.ctl’ *.db_block_size=8192 *.db_name=’RWDB’…
Managing an Oracle Instance
When Oracle engine starts an instance, it reads the initialization parameter file to determine the values of initialization parameters. Then, it allocates an SGA and…
Query Related to Tablespace
How to retrieve tablespace default storage Parameters? SELECT TABLESPACE_NAME “TABLESPACE”, INITIAL_EXTENT “INITIAL_EXT”, NEXT_EXTENT “NEXT_EXT”, MIN_EXTENTS “MIN_EXT”, MAX_EXTENTS “MAX_EXT”, PCT_INCREASE FROM DBA_TABLESPACES; TABLESPACE INITIAL_EXT NEXT_EXT MIN_EXT…
Managing Tablespace
What is Tablespace? A tablespace is a logical storage unit. Why we are say logical because a tablespace is not visible in the file system.…
Important Query related to Tablesapce
How to retrieve tablespace default storage Parameters? SELECT TABLESPACE_NAME "TABLESPACE", INITIAL_EXTENT "INITIAL_EXT", NEXT_EXTENT "NEXT_EXT", MIN_EXTENTS "MIN_EXT", MAX_EXTENTS "MAX_EXT", PCT_INCREASE FROM DBA_TABLESPACES;TABLESPACE INITIAL_EXT NEXT_EXT MIN_EXT MAX_EXT…
Managing Tablespace
A tablespace is a logical storage unit. Why we are say logical because a tablespace is not visible in the file system. Oracle store data…
Managing UNDO TABLESPACE
Before commit, Oracle Database keeps records of actions of transaction because Oracle needs this information to rollback or Undo the Changes. What is the main…