Oracle_Dba

If you need any script be it any script Please let me know. Leave your comment as per your requirement with your email address and location i will email  you the scripts Make sure you mention the description and requirement of your script Thanks Ghufran Ahmed Khan

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 group of shared me

 Job description and Role of Oracle DBA I found this Article long back hope sharing with you this is amazing work for the people who wants to know the job description and role of Oracle DBA How many of you began your IT career with a job where you (or you were a pmi of as mall team that) "designed" tables to hold data and wrote SQL statements to manipulate (Insert, Update or Delete) or query the data? Without reference to potential future needs for "enhancements"? Without considering how data integrity would be enforced? Without a strategy to backup and recover the data? Did you say "The DBA will handle schema changes? The DBA will enforce integrity. The DBA will guarantee that all the data can be restored (from backups he creates) at any time."? Introduction This paper is an attempt to define what the DBA does. And what he does not do. It will make for much better clarity when his Manager reviews the DBAs actions and value to the or

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 Support?              ANS - metalink.oracle.com or support.oracle.com 1.5          Q- What file will you use to establish Oracle connections from a remote client?           ANS - tnsnames.ora 1.6          Q- How can you check if the database is accepting connections?            ANS - lsnrctl status or lsnrctl services 1.7          Q- Which