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: This is the parameter which specify in percent that a block can only used for insert or come in the freelist(list of blocks in segment ready for insert operation) when used space in a block is less than PCTUSED.Suppose value of pctused is 40% and pctfree ...
What is dump destination? What are bdump, cdump and udump? Explain in detail.
Latest Answer: The dump destination is: Oracle_home/admin/The UDUMP specifies user dump directory where all the user related information is stored in the form of trace file.The BDUMP specifies background dump directory where background processes information ...
What are four performance bottlenecks that can occur in a database server and How are they detected?
Latest Answer: What smruti11 mentioned is absolutely right, That is why I rated his answer as good.
I am just gonna brief about the troubleshooting steps though. Four major steps:-
Analyzing Optimizer Statistics
Analyzing an Execution Plan
Using Hints to ...
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: I personally feel that more error we come across, more stronger our roots become.
Errors are not gonna ruin the DBA's apettite. Both my pals above forgot the most notable 'ORA-00600 (Internal Error)'. They occur more than the most. :) And of course ...
Can you perform DML operations when the standby database is in read only in Standby Database?
Latest Answer: In a nutshell, One can do SELECTS only on a Physical/Logical Standby database. The basic principle behind Oracle Standby database is to provide protection against media failures. So no DMLs are allowed on the standby database and the most important things ...
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
