|
||||
|
Situation: Application not able to connect and including sysdba sessions. Complete DB hung due to large number of session spike in very less time. Error:-ORA-00020: maximum number of processes exceeded Dependent parameters sessions = 825 processes = 800 Action taken, We have killed some backups jobs and other local sessions and get a slot of […] Getting this error, RMAN-00571: ====================================================== RMAN-00569: ========= ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===================================================== RMAN-03009: failure of backup command on ch02 channel at 10/08/2012 18:18:35 ORA-19566: exceeded limit of 0 corrupt blocks for file /testdb/dev/oradata/test13.dbf Get the file id of the above file using select file_id from dba_data_files where file_name=’/testdb/dev/oradata/test13.dbf’; File_id —— […] Series: Part 1, Part 2, Part3 Typical Oracle physical corruptions may pose are, (a) ORA-01578 – This error explains physical structural damage with a particular block. (b) ORA-08103 – This error is a logical corruption error for a particular data block. (c) ORA-00600 [2662] – This error is related to block corruption , and occurs […] Series: Part 1, Part 2, Part3 Oracle will have two types of corruptions , Physical & Logical corruptions. Physical Block Corruptions This kind of block corruptions are normally reported by Oracle with error ORA-1578 and the detailed corruption description is printed in the alert log. Corruption Examples are: Bad header – the beginning of the […] Ofcourse you will have a manual that states about your environment. But how to get it from the database. In otherwords if you have given a database to check your tablespaces that is running in exadata storage and you want to uae hybrid columnar compression (possible only with exadata) Humor; dont say you run create […] My friend has an issue yesterday which took sometime to figure out in important time during a release. Hooe this may help you too. ORA-01031: insufficient privileges , while creating DB Link SQL> select * from dba_sys_privs; USERNAME PRIVILEGE ADM —————————— —————————————- — TEST321 ALTER ANY PROCEDURE NO TEST321 CREATE DATABASE LINK NO TEST321 CREATE […] What is a Checkpoint? A synchronization event at a specific point in time Causes some or all dirty block images to be written to the database thereby guaranteeing that blocks dirtied prior to that point in time get written Brings administration up to date Several types of checkpoint exist Types of Checkpoints? Full Checkpoint Thread […] Log file sync event can appear in any busiest system or the environment that configured badly or might be due to some bugs. But log file sync is an accumulated time taken of other aspects which is not alone a foreground process that is waiting for commit post/poll acknowledgement from LGWR. The log file sync […] Hi How to track the password change for a user in Oracle? A) Oracle only tracks the date that the password will expire based on when it was latest changed. So by looking at the DBA_USERS.EXPIRY_DATE and subtracting PASSWORD_LIFE_TIME you can determine when password was last changed. The last password change time can also directly […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!