P A G E S

▼
Friday, August 30, 2013

Database -- How to correct an unused corrupt block.

›
Normally, corruptions on unsued blocks can be ignored, as  Oracle will  create a new block image should the block need to be used.. On the ...
Friday, August 23, 2013

Oracle E-Business Suite Starting/Stopping/Controlling Notification Mailer with PLSQL

›
It is possible to stop/start/control Workflow Notification Mailer using sql/plsql.. Using this method to stop/start/control Workflow Mailer...
Thursday, August 22, 2013

Database 12c: -- A clear article about Oracle Multitenant Option

›
1. Why ? 2. What is it ? 3. How ? -- >             https://blogs.oracle.com/ou_trainers/entry/oracle_database_12c_oracle_multitenant
Wednesday, August 21, 2013

Database -- Index Block Corruption/ index recreation or index rebuild

›
It 's better to use drop and create an index to correct an index block corrution.. As Oracle Documentation says: ALTER INDEX ... RE...

Linux -- Process State Transition

›

Linux -- Process states and descriptions

›
TASK_RUNNING: The process is either running on CPU or waiting in a run queue to get scheduled. TASK_INTERRUPTIBLE: The process is sleeping...

Linux -- D state processes & TASK_KILLABLE state

›
The following figure show the process state transitions: D state is a special sleep mode.. In D state , the code can not be interrupt...
Tuesday, August 20, 2013

Linux -- Share and Mount NFS Linux to Linux

›
Click here to read the document
Friday, August 16, 2013

Database -- Finding Current Buffer Cache Size of the Database Objects

›
http://ermanarslan.blogspot.com/p/core-dba-scripts.html

Database -- Why we need the serial# to kill a session

›
SID ->Session identifier SERIAL# -> Session serial number. Used to identify uniquely a session's objects. Guarantees that sessi...