What do you mean by normal start-up and Crash Recovery ?

When a database is shut down cleanly using shutdown immediate,Shutdown normal or shutdown Transnational (Mode of Oracle Database shutdown) a full checkpoint happens and, therefore, all the dirty blocks from the buffer cache are written to the data files. As a result, when the database starts, there is no need for any kind of recovery. … Continue reading What do you mean by normal start-up and Crash Recovery ?

Drop and recreate undo Tablespace in few steps …

1.. show parameter undo 2.. Check undo tablespace status ACTIVE,EXPIRED and UNEXPIRED  and size 3.. Check current undo tablespace and size 4.. Create new undo tablespace as APPS_UNDO 5.. Change to new undo tablespace 6.. Check for the active rollback segment in old undo tablespace 7.. Kill the session which are active 8.. Drop old … Continue reading Drop and recreate undo Tablespace in few steps …

Simple ways to find out CPU utilization in Linux

1.. TOP :- The  top  program provides a dynamic real-time view of a running system.  It can display system summary information as well as a list of tasks currently being managed by the Linux kernel.  The types of system summary information shown and the types, order and size of information displayed for tasks are all user … Continue reading Simple ways to find out CPU utilization in Linux

Installation of Oracle E-Business Suite 12.2.0 in Oracle Linux 6.4

Server Details: - Operating System:- Oracle Linux 6.4 RAM: - 16GB Processor: - Intel i3 Processor Note: - With given above information Oracle Linux was installed in Virtual Box to install Oracle EBS 12.2. /stage is location where Oracle EBS binaries are kept For more information: - Check 1330701.1 for prerequisite and certification matrix 1.. … Continue reading Installation of Oracle E-Business Suite 12.2.0 in Oracle Linux 6.4