I’m now a certified expert in Oracle. Just cleared the 1z0-048 exam for Oracle RAC 10g Cluster. The exam tests…
The size of the database is the total size of the datafiles that make up the tablespaces of the database.…
SQL> select * from v$flashback_database_log; SQL> show parameter db_file SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=2g; System altered. SQL> alter system set…
1. Turn on block checking REASON: The aim is to detect, very early the presence of corrupt blocks in the…
Copy Table to a new table with some condition ______________________________________________ SQL> CREATE TABLE newTable AS (SELECT * FROM emp WHERE…
Oracle Apps 11i is divided into : Database Tier ( Database & DB Listener ) and Application Tier ( WebServer,…
Oracle Database philosophy is Data Recover-ability. This is the reason if you have a huge table with more than 100…
**************** Cloning of the Oracle Database ******************** On production 1) Make sure controlfile autobackup is on and take the incremental…
A small shell script to check instance status of oracle database. $vi instanceup.sh #!/bin/sh SERVICE=’ora_pmon_orcl’ #replace ‘orcl’ with your sid…