Oracle ASM Interview Questions

1. What init.ora parameters does a user need to configure for ASM instances? Oracle ASM offers these initialization parameters.  The main parameters for ASM include asm_diskgroups, asm_diskstring, asm_power_limit and asm_preferred_read_failure_groups. ...

Export Import Datapump Basic Commands

For more exciting blogs on Oracle, please click the LINK 1. EXCLUDING TABLE PARTITIONS JOB_NAME=INFRA_EXPORT DIRECTORY=DUMP_DIR DUMPFILE=Schema_%U.dmp LOGFILE=Schema.log SCHEMAS=INFRA EXCLUDE=table_data:”IN...

RMAN Basic Commands

For more exciting blogs on Oracle, please click the LINK 1. Crosscheck and delete expired archive logs RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all;   2. Delete archive logs keeping just a days...

Tablespace Commands

For more exciting blogs on Oracle, please click the LINK 1. Checking tablespace size col “Tablespace” for a22 col “Used MB” for 99,999,999 col “Free MB” for 99,999,999 col “Total MB” for 99,999,999 select...

Daily Commands in Oracle

For more exciting blogs on Oracle, please click the LINK 1. Kill Multiple Inactive sessions in Oracle BEGIN FOR r IN (select sid,serial# from v$session where username=’user’ and status’INACTIVE’) LOOP EXECUTE IMMEDIATE ‘alter system kill...