Oracle_Dba

How to create a bootable USB flash drive Insert a USB flash drive into a running computer. Open a Command Prompt window as an administrator. Type  diskpart . In the new command line window that opens, to determine the USB flash drive number or drive letter, at the command prompt, type  list disk , and then click ENTER. Then list disk command displays all the disks on the computer. Note the drive number or drive letter of the USB flash drive. At the command prompt, type  select disk , where X is the drive number or drive letter of the USB flash drive , and then click ENTER. Type  clean , and the click ENTER. This command deletes all data from the USB flash drive. To create a new primary partition on the USB flash drive, type  create part pri , and then click ENTER. To select the partition that you just created, type  select part 1 , and then click ENTER. T...

Difference between Physical Standby and Logical Standby DB Physical standby: ============ 1. Physical standby schema matches exactly the source database. 2. Archived redo logs and FTP’ed directly to the standby database which is always running in “recover” mode. Upon arrival, the archived redo logs are applied directly to the standby database. Logical standby: =========== 1. Logical standby database does not have to match the schema structure of the source database. 2. Logical standby uses LogMiner techniques to transform the archived redo logs into native DML statements (insert, update, delete). This DML is transported and applied to the standby database. 3. Logical standby tables can be open for SQL queries (read only), and all other standby tables can be open for updates. 4. Logical standby database can have additional materialized views and indexes added for faster performance. DIFFERENCE ========= The difference between physical and logical standby is in t...

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 grou...

 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...