Oracle tablespace stores the data in the Oracle database and as the data grows, we often need to add space to the tablespace. We can add space in two ways. we can either resize the existing data file or add the new data file to the tablespace. We will check out adding datafile to tablespace […]
How to add datafile to tablespace in Oracle Read More »
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 »
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
Parallel Concurrent Processing 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 »
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 use sed to remove comments and blank lines 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
How to Restore and Recover database using RMAN Read More »
