It is often time consuming job to gather detailed information about the backups of Oracle databases with RMAN. You need to collect information from …
Read More »ORACLE
How To Calculate Actual Size of All Tables in a Schema in Oracle
When calculating the size of a table in an Oracle database, it is incorrect to just look at the data size. It is necessary …
Read More »How To Find Database Query From the Linux PID
In Oracle databases running on Linux, you can access the relevant session information from each user processes. In most cases, it is necessary to …
Read More »Exadata cellnode RS-7445 [Serv CELLSRV hang detected] [It will be restarted]
On Exadata cellnodes, the RS-7445 error can be received due to the inability to send heartbeat under overload. This error appears in versions 11.2.2.4.0 …
Read More »RMAN ORA-19566 exceeded limit
When we get a backup with Rman, if there is a damaged block on a datafile, the ORA-19566 error will be received and the backup …
Read More »Chained Row Analysis
A chained row is called a row that does not fit into a single database block. For example, when you try to add a …
Read More »Data Pump, expdp ORA-39127, ORA-01031, ORA-06512 Errors
When you are backing up with Data Pump (expdp), it may indicate that the privileges are insufficient and may end with errors such as ORA-39127, …
Read More »ADR Command Interpreter(ADRCI)
ADR Command Interpreter (ADRCI) is a command-line tool in the fault detection infrastructure of Oracle databases. With ADRCI; We can see the diagnostic data in …
Read More »Oracle Flashback Query
Oracle Flashback Query allows us to query as much as possible of the past committed data. We can query the data in the past …
Read More »ORA-00600 qcisSetPlsqlCtx
Depending on the timezone differences ORA-00600 error can be occured when opening the database. The argument for this error is [qcisSetPlsqlCtx: tzi init], which …
Read More »