Understand Performance of Oracle Database using AWR Report


http://learntestingtools.com/understand-performance-of-oracle-database-using-awr-report/ There are plenty of articles, blogs and write ups available to explain what Automatic Workload Repository aka AWR report is and what information does it provide. I have read a few and found very useful. AWR is an ocean of information and may be quite overwhelming sometime. If you are trying to find out... Continue Reading →

Advertisements

Audit Trail Management


http://www.oracle.com/technetwork/issue-archive/2010/10-nov/o60security-17606... TECHNOLOGY: Security As Published In November/December 2010 Managing Audit Trails By Arup Nanda Relocate the audit trail to a different tablespace and set up an automatic purge process to keep its size under control. One of the most significant aspects of database security involves setting up auditing to record user activities. The very knowledge... Continue Reading →

alter any table


/* Formatted on 05.05.2011 10:58:34 (QP5 v5.163.1008.3004) */ DECLARE the_list VARCHAR2 (4000) := ' alter table user.tab drop part x'; in_str VARCHAR (4000); TYPE EventType IS TABLE OF VARCHAR2 (4000); v_EventType EventType := EventType (); TYPE nestedSql IS TABLE OF VARCHAR2 (4000); v_nested_sql NestedSQL := NestedSQL (); is_member BOOLEAN := FALSE; v_cn number := 1;... Continue Reading →

Oracle: Backupset keep until


  -- get backup handle and backup pieces select d.name,        b.bs_key,S.HANDLE,        decode(b.incremental_level,null,decode(b.backup_type,'D','Ctrl','I','Inc','L','Arch','n/k'),         'Inc'||b.incremental_level) backup_type,        decode(b.status,'A','Avail.','O','Obsolete',b.status) status,        b.pieces,        b.start_time,        decode(b.controlfile_included,'NONE','No','BACKUP','Yes','STANDBY','Standby','n/k') controlfile_included,        b.keep,b.keep_options,        b.keep_until from rc_database d,      rc_backup_set b,      rc_backup_piece s where d.db_key=b.db_key and d.db_key=s.db_key       and B.SET_COUNT=S.SET_COUNT and B.SET_STAMP=S.SET_STAMP       and upper(d.name) like upper('ADMP01')      ... Continue Reading →

How to use Oracle Logminer to analysis Logfile


http://arjudba.blogspot.com/2008/08/how-to-use-oracle-logminer-to-analysis.html How to use Oracle Logminer to analysis Logfile ------------------------------------------------We know that any changes to database is recored in online redo logfiles. If your database archival mode on then online redo log files are archived which contains the database changes. With these logfile we can analysis any changes in database. In simple we can say... Continue Reading →

How to install XDB for 11g


Applies to: Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later   [Release: 11.1 and later ]Oracle Server - Personal Edition - Version: 11.1.0.6 and later    [Release: 11.1 and later]Information in this document applies to any platform. Checked for relevance on 12-Nov-2010 PurposeThis script will provide output to show which features of XML Database (XDB)... Continue Reading →

Create a free website or blog at WordPress.com.

Up ↑