Oracle Wait Events |

[@shahidkhan-iq3gb]

What is the scope of oracle dba in future?

[@shineshvv]

For ORA 1555 Run the undo advisor increase the undo retention and if needed add undo data files to Undo

[@santoshmishra-my2gc]

I would say 16kb for warehouse, that will be useful for read operation and reduce I/O,as in one I/O it will read 16KB of data so more data will be read.

[@santoshmishra-my2gc]

Tune the query,ask application team to have implicit commit,if not possible then autoextend undo tablespace ,let the query complete once complete turn off autoextend to off,shrink undo tablespace

[@shehbazphulmamdi3655]

First of all need to check the query duration...if the query duration is more than undo retention then definately there will be a issue with query plan. If the query duration is less than the undo retention then need to check what else causing the undo blocks to be overwritten..

[@aravindhreturns]

16:06 : Like a boss 🤴

[@dbagenesis]

Like a DBA! ;)

[@bashaakku2074]

#dbaChallenge we can increase undo_rentention paramerter

[@sachintiwari9172]

In 4th question,8.56 min, if we use 'delete input' in backup archivelog than it will delete all the archivelog from production, and if we have DR server which might be not sync with Production, than we use delete input or Not ?? Please reply

[@hello2441139]

If standby server is not sync, in this case these archivelog will not deleted from production by RMAN command like 'delete input' or 'delete archivelog until time ........ ' etc. You will get this error. RMAN-08120: warning: archived log not deleted, not yet applied by standby archived log file name=/fra/ABCD/archivelog/2020_09_10/o1_mf_1_30459_homttpz7_.arc thread=1 sequence=30459......

[@Aubd417]

Set the archive log deletion policy in primary Delete archive log shipped/applied to all standby will prevent the deletion of un sync/un applied archeves..

[@govardhanindian]

Sir ,i want to join in oracle.....

[@vidmayur]

Based on max querylen change the undo retention

[@saifuddinsyed946]

dbms_stats.export_table_stats

[@matheenahamed2692]

What is looping chain of synonyms? ORA-01775: looping chain of synonyms. How to resolve this?

[@bharathkumar-ds8cd]

Hi Team, BEGIN DBMS_STATS.CREATE_STAT_TABLE ( ownname => 'dba1' , stattab => 'opt_stats' ); END; / -- generate representative workload EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SH'); BEGIN DBMS_STATS.EXPORT_SCHEMA_STATS ( ownname => 'dba1' , stattab => 'opt_stats' ); END; / BEGIN DBMS_STATS.IMPORT_SCHEMA_STATS( ownname => 'dba1' , stattab => 'opt_stats' ); END; /