Explain what are Oracle Catalog and Oracle Archive log?
Latest Answer: Oracle System Catalog :System Created Tables Which Contain Statistics and Useful Data Collected Automatically by the Database Engine to Help the Administrator or the regular users.There Are Several Kinds Of Catalogs :V$_Catalogdba_CatalogUser_Catalog
RMAN ...
What is PCT Free and PCT Used?What is PCT increase parameter in segment?What is growth factor?
Latest Answer: PCT Used :Equals 100 - PCT Free , Also It states the used space in the data file by records,
If PCT used was set to 60 this means If the data inside the block is 60, it
is FULLIf data inside the block is 59, it is Empty ...
What is dump destination? What are bdump, cdump and udump? Explain in detail.
Latest Answer: In 11g, this concept has been replaced with diagnostic test! ...
What are four performance bottlenecks that can occur in a database server and How are they detected?
Latest Answer: CPU bottlenecksUndersized memory structuresInefficient or high-load SQL statementsDatabase configuration issues ...
What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?
Latest Answer: Deadlock ErrorsOracle Internal errorsBackup and recovery errorsSnapshot too old error ...
Can you perform DML operations when the standby database is in read only in Standby Database?
Latest Answer: Standby can be of two types, physical standby and logical standby.Physical standby database is exactly the same in structure as primary database. When it is in read-only mode, SQL queries can be run on it. The other mode is redo-apply mode and database ...
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
Latest Answer: We need to find where in the complilation the error is occuring.We have to divide the code. and check for correctness of the code part-by-part..this is called debugging. Keep checking the code untill you find the code which is wrong.hope this answer helps.Raghu. ...
What are the different scenarios for rebuilding indexes...
Latest Answer: Actually you need to rebuild the indexes for 2 main scenarios.1)deleted entries represents 20% or more of the current entries2)the index depth is more than 4 levelsOracle index nodes are not deleted physically when the rows of tables deleted nor the entries ...
Latest Answer: Local to Dictionary managed tablespcaes:exec dbms_space_admin.Tablespace_Migrate_FROM_Local('tablespace');Dictionary to locally managed tablespaces:exec dbms_space_admin.Tablespace_Migrate_to_Local('tablespace'); ...
As a Oracle DBA what are all the UNIX file you should be familar with?
Latest Answer: To check the process useps -ef |grep pmonps -efTo check the alert log filetail -f alert.log To check the cpu usagetopvmstat 2 5 ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
