-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
On AIX – nmon on AIX can be used to monitoring a machine (CPU, Memory, Network traffic, I/O, top processes,… READ MORE
The following article by Cary Milsap talks about “Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok” by… READ MORE
RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0… READ MORE
Below are the steps on how to add a new online redo-group. It could be of the same size as… READ MORE
We had an issue the other day when one of the Sharepoint database logs became extremely large as the server… READ MORE
If for some reason the online redo log were lost or when cloning the copy of shutdown database you don’t… READ MORE
-- Step 1) set up environment variables needed (ORACLE_HOME, ORACLE_SID and add ORACLE_HOME\bin to PATH) set ORACLE_HOME=e:\oracle\11g\product\11.2.0.1 set PATH=%ORACLE_HOME%\bin;%PATH% set… READ MORE
|
To create a baseline of performance of the system, one create a baseline and used for later comparisons. If a… READ MORE
-- drop snapshot, it will not generate an error if the snap id is out of range SQL> EXEC dbms_workload_repository.drop_snapshot_range(low_snap_id=>1,… READ MORE
|
-- Shows SQL statements currently in shared pool with high physical I/O, it sorts by the high I/O first SELECT… READ MORE
declare task_id number; name varchar2(100); descr varchar2(100); obj_id number; -- get the min and max snap id from AWR CURSOR… READ MORE
One can make Oracle suspend a session if it runs out a free space by enabling resumable timeout. This can… READ MORE
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect… READ MORE
The following shows how exceptions can be captured. — Create exceptions table SQL> @?/rdbms/admin/utlexcpt.sql Table created. SQL> desc exceptions; Name… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 