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 […]
Parallel Concurrent Processing
Why Concurrent Processing? what is the Business Need for Concurrent Processing We all use Concurrent Manager in Ebuiness Suite. I am reiterating the uses of it here 1) It Facilitates User Interaction2) Long running jobs are performed in the background to avoid interference with interactive operations3) Improve the efficiency of Applications4) All background processing is […]
Shared Pool in Oracle and Shared pool flush in Oracle database
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 […]
How to use sed to remove comments and blank lines
As an administrator on the Unix system, we may encounter situations where we must remove the blank lines from many files. Similar is the case comments also, we may need to remove from a lot of files. Doing this using vi or nano editor is going to be lengthy and very tedious. This is also […]
How to recover database using RMAN
Recover database is an important part of Oracle database administration. Here in this post,I will try to cover scenario’s on How to recover database using RMAN Case 1: Loss of a datafile We often get the scenario where we lost the data file because of a hard disk crash and we get to restore the […]
How to check Stale statistics
Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: Parameter setting required to Track the table changes […]