Posted by Mir Sayeed Hassan on December 24th, 2017
To set up Autotrace by using the PLUSTRACE ROLE in Oracle Database
Follow the step by step procedure as shown below:
SQL> conn sys/sys as sysdba
Connected.
SQL> set autotrace traceonly;
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611:...
Read more..
Posted in DBA Administration | Comments Off on To set up Autotrace by using the PLUSTRACE ROLE in Oracle Database
Posted by Mir Sayeed Hassan on December 23rd, 2017
Real time Auditing in Oracle Database 11gR2
There are major 4 types of auditing:
1 – Statement level auditing
2 – Object level auditing
3 – Privilege level auditing
4 – Fine granined auditing
Posted in Performance Tuning(PT) | Comments Off on Real time Auditing in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on December 23rd, 2017
Auditing at Schema Level in Oracle Database 11gR2
DDL Auditing at Schema Level
Try to perform the below tested & verified auditing at schema level in Oracle Database 11gr2
A DDL event occurs when a DDL statement is run in specific schema level such as...
Read more..
Posted in Performance Tuning(PT) | Comments Off on Auditing at Schema Level in Oracle Database 11gR2
Posted by Mir Sayeed Hassan on December 3rd, 2017
Performance tuning test for Wait Event enq: TX – row lock contention.
Simulate step by step procedure for Wait Event enq: TX – row lock contention, by updated (locking) row in 1st session & while trying to update the 2nd...
Read more..
Posted in Performance Tuning(PT) | Comments Off on Performance tuning test for Wait Event enq: TX – row lock contention.
Posted by Mir Sayeed Hassan on November 28th, 2017
Reorganizing or Shrink table/index in Oracle 11gR2 DB
A Simple demonstration to perform shrinking the object in Oracle Database 11gR2
[oracle@testdb ~]$ !sq
SQL> conn mir/****
Connected.
SQL> create table shrink_test as select 'Oracle_shrink_method' as product, mod(rownum,5) as...
Read more..
Posted in DBA Administration | Comments Off on Reorganizing or Shrink table/index in Oracle 11gR2 DB
Posted by Mir Sayeed Hassan on November 26th, 2017
Clear old alert in Enterprise Manager (EM) in Oracle Database
Given alert shows the old alert which is not require to be present in database, Hence need to clear manually as shown below:
Read more..
Posted in EM (Enterprise Manager) | Comments Off on Clear old alert in Enterprise Manager (EM) manually from database
