It is suggested to routine Oracle data source copy at non-pick hours. This thing cannot be done stringently to those companies or sites, which are running 24/7 and available worldwide. During the copy, the efficiency of data sources might lower. Performance effect will depend on size data source and number of contingency clauses. If the …
Continue reading Performance Tuning of Oracle Database Backup
Hi friends, Excellent resource of Oracle 11g technical articles, Oracle 10g technical articles, scripts is available on our website of dbametrix.com There are lot of remote dba tips, job searching tips also available in same site in Oracle DBA tips link. Kindly check daily because daily we are adding new article in same resource. Thanks …
Hi, Today We will try to see how to tune LATCH FREE wait event? Today I have checked statspack report of one of my client. In Top 5 Wait event as follows in statspack report. Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (s) Wt Time -------------------------------------------- ------------ ----------- ------- control file …
Myths-Mysteries-Memorable 