If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the …
Read More »ORACLE
Who Uses Temp Tablespace in Oracle
When you see that there is intense use of temp in a running database, it is necessary to determine who is using a temp …
Read More »How To Gather Statistics of a Table Partition(Update Partition Statistics)
When the table is large in Partitioned tables, the statistical update process is very long. Although the information we query will take place in …
Read More »How To Report Exadata Disk Topology
Simply run the following script from any database server to query the physical disk, celldisk, griddisk, and flash disks on the cell nodes in …
Read More »How To Restore RAC Database From rman backup
When a database completely crashes, you need to do is to setup from scratch and return from backup. If you have a Rman backup …
Read More »Oracle Exadata Default Passwords
Exadata installation is done with standard user name and password unless you specify otherwise. All standard passwords must be changed. The standard user name …
Read More »DBA_TAB_MODIFICATIONS table does not return any record
In the DBA_TAB_MODIFICATIONS table, change statistics for all changed tables in the database are stored. The same information can also be accessed from the …
Read More »How To Recover Dropped Tables with Oracle Recyclebin
In this article I will tell you about Recyclebin which is one of the beautiful features announced with Oracle 10g version. With the Recyclebin …
Read More »ORA-00245: control file backup failed; target is likely on a local file system
When backup is taken with Rman, it creates the snapshot of the control file and uses it as backup file. The name of the …
Read More »Data Pump Export process waiting with the message “wait for unread message on broadcast channel”
During the DataPump export process, if the relevant session is waiting for the following message, you can resolve this issue by doing the following …
Read More »