xiaohuajoke.blogspot.com

jurongport.blogspot.com

Oracle: ADDM

http://jurongport.blogspot.com/2009/06/addm.html

Monday, June 15, 2009. ADDM (Automatic Database Diagnostic Monitor) is used to diagnose database performance issues. Its analysis can be performed across any two AWR snapshots. Three ways to run ADDM analysis:. Option 1 , Running ADDM Using addmrpt.sql. SQL @$ORACLE HOME/rdbms/admin/addmrpt.sql. Listing the last 3 days of Completed Snapshots. Instance DB Name Snap Id Snap Started Level. Ctgbu2 CTGBU2 6611 14 Jun 2009 00:00 1. 6612 14 Jun 2009 01:00 1. 6613 14 Jun 2009 02:00 1. 6614 14 Jun 2009 03:00 1.

jurongport.blogspot.com

Oracle: Killing DBMS_JOB

http://jurongport.blogspot.com/2009/07/killing-dbmsjob.html

Thursday, July 30, 2009. To check scheduled job:. Scheduled dbms jobs.sql. Set line 200 pages 200. Col log user for a10. Col job for 9999999 head 'Job'. Col broken for a1 head 'B'. Col failures for 99 head "fail". Col last date for a18 head 'LastDate'. Col this date for a18 head 'ThisDate'. Col next date for a18 head 'NextDate'. Col interval for 9999999.000 head 'RunInterval'. Col what for a60. From dba jobs dj) j;. What Jobs are Actually Running. Select * from dba jobs running;. Col log user for a10.

jurongport.blogspot.com

Oracle: test

http://jurongport.blogspot.com/2009/09/test.html

Thursday, September 3, 2009. Subscribe to: Post Comments (Atom). View my complete profile.

jurongport.blogspot.com

Oracle: June 2009

http://jurongport.blogspot.com/2009_06_01_archive.html

Tuesday, June 16, 2009. Basically, AWR (Automatic Workload Repository) is an Oracle built-in tool that collects performance related statistics and derives performance metrics from them to track a potential problem. Unlike Statspack, snapshots are collected automatically every hour by a new background process called MMON and its slave processes. Be default, the collected data is automatically purged after 7 days. Col SNAP INTERVAL format a30;. Col RETENTION format a30;. Select * from dba hist wr control;.

jurongport.blogspot.com

Oracle: April 2009

http://jurongport.blogspot.com/2009_04_01_archive.html

Wednesday, April 1, 2009. The Oracle Password File ($ORACLE HOME/dbs/ orapw. Stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect. Follow this procedure to create a new password file:. Log in as the Oracle software owner. Run command on OS level:. Orapwd file=$ORACLE HOME/dbs/orapw$ORACLE SID password=. Shutdown the database (SQLPLUS SHUTDOWN IMMEDIATE). Adding users to Password File:.

jurongport.blogspot.com

Oracle: July 2009

http://jurongport.blogspot.com/2009_07_01_archive.html

Thursday, July 30, 2009. To check scheduled job:. Scheduled dbms jobs.sql. Set line 200 pages 200. Col log user for a10. Col job for 9999999 head 'Job'. Col broken for a1 head 'B'. Col failures for 99 head "fail". Col last date for a18 head 'LastDate'. Col this date for a18 head 'ThisDate'. Col next date for a18 head 'NextDate'. Col interval for 9999999.000 head 'RunInterval'. Col what for a60. From dba jobs dj) j;. What Jobs are Actually Running. Select * from dba jobs running;. Col log user for a10.

jurongport.blogspot.com

Oracle: May 2009

http://jurongport.blogspot.com/2009_05_01_archive.html

Friday, May 8, 2009. Audit sys operations = TRUE. SYSDBA Audit report daily. ORACLE HOME=/u01/oracle/product/10.1.0. D=`date %Y %m %d`. Ls -lrt $auditdir2awk '{print $9}' $auditdir/cplist.txt. For name1 in `cat $auditdir/cplist.txt`. Cnt=`ls -lrt $auditdir1 wc -l`. Echo "* * * * * * * * * * * * * " $auditdir/AuditLogC.txt. Echo "Report Date : " $yesterday $auditdir/AuditLogC.txt. Echo "Server/DB : " `hostname`/$ORACLE SID $auditdir/AuditLogC.txt. Echo " " $auditdir/AuditLogC.txt. View my complete profile.

jurongport.blogspot.com

Oracle: AWR

http://jurongport.blogspot.com/2009/06/awr.html

Tuesday, June 16, 2009. Basically, AWR (Automatic Workload Repository) is an Oracle built-in tool that collects performance related statistics and derives performance metrics from them to track a potential problem. Unlike Statspack, snapshots are collected automatically every hour by a new background process called MMON and its slave processes. Be default, the collected data is automatically purged after 7 days. Col SNAP INTERVAL format a30;. Col RETENTION format a30;. Select * from dba hist wr control;.