If we are trying to drop the redo log group created for a thread that is active and if the drop operation of redo …
Read More »ORACLE
Querying information about Exadata cellnode
We can query all the information about the cellnodes on Exadata from any database. It is possible to query information from v$cell_config. With this view, …
Read More »How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle
Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has managed instances on the basis of server pools for the effective use …
Read More »How To Export Tables to csv in Oracle
It is possible to export the data in tables in the database in csv format depending on a specific condition. We can use the …
Read More »How To List RMAN Jobs
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 »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 »