Below section I have tried to present all the important features in Oracle Database management
Oracle Database administrator has to prepare for the possibility of hardware, software, network, process, or system failure. If such a failure affects the operation of a database system, he must usually recover the database and return to normal operation as quickly as possible.So database recovery is very important for the organization Oracle Database Recovery should …
Oracle Database Recovery various cases and solution Read More »
A shared pool is an important memory structure in Oracle database system global area(SGA) What is Shared Pool in Oracle The shared pool in the Oracle database is the place where Oracle caches the SQL, PL/SQL and dictionary data. Whenever we parse a query, the parsed representation is cached there and it is shared also. Oracle …
Shared Pool in Oracle and Shared pool flush in Oracle database Read More »
Recover database is an important part of Oracle database administration. Here in this post, I will try to cover scenarios on How to restore and recover a database using RMAN Case 1: How to Restore and recover database using RMAN from Loss of a datafile We often get the scenario where we lost the data …
We often come across a situation where a sql statement is giving issues. SQL monitor report is a very useful tool to analyze the various operation done by the sql, wait events, bind variables, and memory details. The below statement can be used to monitor any active sql or done sql in the database SET …
Many operations take time in the Database like full table scan, backup, full index scan, and joins. We can estimate the % completion or monitor the session using the v$session_longops view in Oracle. This is a very useful view and provides quite an accurate estimate. How to find the %completion for the long operation for …
How to find the long running (longops session) in Oracle Read More »
The Flash recovery area(FRA) is an important location in the Oracle database. It stores archivelog, flashback logs, backups etc. Here in this post, we will see how to check fra size in Oracle, flash recovery area usage query, and how to increase fra size in Oracle how to check fra size in oracle The above …
how to check fra size in oracle: Location, usage, change size Read More »
