How to Enable Fast Recovery Area (FRA)
Fast Recovery Area (FRA) Fast Recovery Area (FRA) is a very convenient feature for DBA to backup and restore database. You may set the FRA… Read More »How to Enable Fast Recovery Area (FRA)
How to Check Free Memory in SGA Pools
The dynamic view gv$sga can tell you how much memory he occupied from OS. They won't change very often. The real available memory of SGA… Read More »How to Check Free Memory in SGA Pools
How to Check SGA Components Memory Distribution on Database 9i
SGA Components For database 9i, there is no dynamic view gv$sgainfo like 10g or 11g that can represent current memory distribution of every component. Another… Read More »How to Check SGA Components Memory Distribution on Database 9i
How to Check Tablespace Size in Oracle
After having the whole picture about the size of the database, we can further check Oracle tablespace usage solely by SQL. Oracle Tablespace Usage Of… Read More »How to Check Tablespace Size in Oracle
How to Startup a Misconfigured Database ORA-00837
A misconfigured database is a database which was set with wrong values of initialization parameters in SPFILE, it will prevent the database from startup. Let's… Read More »How to Startup a Misconfigured Database ORA-00837
How to Write Control File into Raw Device
Control File in Raw Device? Since raw devices cannot be read/write as a normal file operation, you cannot write a controlfile directly into a raw… Read More »How to Write Control File into Raw Device
How to Map Timestamp to SCN or Vice Versa
If you are trying to do an incomplete recovery (also called Point-In-Time Recovery, PITR), you may want to know a System Change Number (SCN) using… Read More »How to Map Timestamp to SCN or Vice Versa
How to Check Current System Change Number (SCN)
System Change Number Some DBAs will schedule a cron job to capture System Change Number (SCN) periodically to save as a Timestamp/SCN mapping reference. To… Read More »How to Check Current System Change Number (SCN)
How to Resolve ORA-19809 Limit Exceeded for Recovery Files
ORA-19809 We usually watch the space usage of log archive destination very closely because the database will be suspended if the space is full. Particularly,… Read More »How to Resolve ORA-19809 Limit Exceeded for Recovery Files
How to Set Client-Side Transparent Application Failover (TAF)
Transparent Application Failover (TAF) Besides connect-time failover to the standby database, there is a function called Transparent Application Failover (TAF) can do run-time failover to… Read More »How to Set Client-Side Transparent Application Failover (TAF)