Monday, 16 February 2015

›
How To Check Tablespace Name and corresponding Size ? Answer> Execute the following statement. select file_name,status,tablespace_na...

›
To get the % useage of all available Open_cursors :  Answer > SELECT 'session_cached_cursors' parameter, LPAD(value, 5) value, ...

›
How To Set The Values For Open_Cursors ? Answer > Assuming that you are using a spfile to start the database ------------------ alter ...

›
How to set Open_Cursors ? Answer > Execute the following statement after connecting to your Oracle DB. select max(a.value) as highes...

›
How To Rename A REDO Log file ? Answer >  You can rename a REDO Log file by executing following command. ALTER DATABASE RENAME FILE...

›
How To Switch A REDO LogFile? Answer > Connect to the database with SYSDBA system privilege and execute the following command : alt...

›
How to Drop a Redo Log File ? Answer > Connect to the Oracle database and execute the following SQL statements : First, check that w...

›
How To Check Redo Logs And Their Size and Add Redo Logs to an Oracle Database ? Answer >  Connect to the Oracle Database and execute t...

›
Is privilege "SYSDBA" = "DBA" Role ? Answer > There's a big difference between them. For sysdba role, you can ...

›
How To Check Memory_Target ? Answer > Connect to the database with SYSDBA system privilege and execute the following command : show ...

›
How To Check SGA_MAX_SIZE ? Answer > Connect to the database with SYSDBA system privilege and execute the following command : show p...

›
How To Kill Multiple Sessions In Oracle 10G/11G ? Answer> Execute the  following steps in SQL Plus or CMD Window after connecting to t...

›
How To Take A RMAN Backup in Oracle 10G/11G? STEPS : SQL> shut immediate Database closed. Database dismounted. ORACLE instance shu...
Sunday, 15 February 2015

›
How to Import the tables from the DUMP into the Oracle Database when tables with same name already exist in the Database ? Answer > Some...