Certification Completion

I have completed my OCA 10g Certification. Working on OCP now....

Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

Oracle Dba Jobs Interview Question and Answers. PART-2

Continued from: http://ghufranahmedkhan.blogspot.com/2015/06/oracle-dba-jobs-interview-question-and.html 1. How many memory layers are in the shared pool? Ans:  The shared pool portion of the SGA contains three major areas: library cache(contains parsed sql statements,cursor information,execution plans), dictionary cache (contains cache -user account information,privileges information,data file,segment and extent information), buffers for parallel execution messages, and control structure. 2. How do you find out from the RMAN catalog if a particular archive log has been backed-up? Ans:  list archivelog all; 3. How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up? Ans: df -kh and du-sh 4. Define the SGA and: i)  How you would configure SGA for a mid-sized OLTP environment? ii) What is involved in tuning the SGA? Ans: SGA: The System Global Area (SGA) is a grou...
Read more

Oracle Dba Jobs Interview Question and Answers. PART-1

Salam, These are the Oracle DBA Interview Questions, these are compiled together at one place so that at the last movement you can have a look and go for the Interview. 1.  Basic  Level 1.1          Q- Which are the default passwords of SYSTEM/SYS?               ANS- MANAGER / CHANGE_ON_INSTALL 1.2          Q- How can you execute a script file in SQLPLUS?               ANS - To execute a script file in SQLPlus, type @ and then the file name. 1.3          Q- Where can you find official Oracle documentation?              ANS - tahiti.oracle.com 1.4          Q- What is the address of the Official Oracle Suppo...
Read more

how to find database is running on PFILE or SPFILE

Below script will tells us if the database is running on PFILE or SPFILE  SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile'; OR SQL> show parameter spfile; NAME TYPE VALUE —— —— ———————————————— spfile string /u01/apps/oracle/10g/dbs/spfileorclkhan.ora parameter will tell you the location where the SPFILE is present as well.
Read more