Current waiting events  Summary The first and most important script about OWI, is where current sessions waiting SELECT a.SID, b.serial#, b.status, p.spid, b.logon_time, a.event, l.NAME latch_name, a.SECONDS_IN_WAIT SEC, b.sql_hash_value, b.osuser, b.username, b.module, b.action, b.program, a.p1,a.p1raw, a.p2, a.p3, –, b.row_wait_obj#, b.row_wait_file#,…

Db file sequential read                                                 Summary The db file sequential read wait event means that Oracle is waiting while doing a single-block I/O read. This is the case when reading an index. Like all wait events the columns P1, P2, P3…

 Failed Jobs can be verified by using the following sql: sql > select owner_name,job_name,operation,job_mode,state,attached_sessions from dba_datapump_jobs;   Check the state (status ) of the Jobs all the failed Jobs,they will show as not running for failed once. DROP MASTER TABLE…

Nice and easiest way to to extract the DDL for all tablepaces..  Generate the DDL using the below query and you can re create the table spaces in any environment with any changes you want to make. set heading off;set…

Upgrading Opatch to Latest Version : It is so simple to upgrade th Opatch version for your database. I will check my current version of Opatch [oracle@linux5 OPatch]$ opatch version Invoking OPatch 10.2.0.4.2 OPatch Version: 10.2.0.4.2 OPatch succeeded. Now download…

Linux OS is a virtual memory system like any other modern operating system. The Virtual Memory Management system of Linux includes: Paging Swapping HugePages Slab allocator Shared memory When almost all of the available physical memory (RAM) is started to…

will start the post soon with all installation steps & snapshots ………

Description This script all table and system privileges granted to a user.  The scripts also takes into acount those privileges assigned via  roles granted via roles Parameters username – The username to display privileges for SQL Source REM Copyright (C)…

Password Verification : Enforcing Password Complexity Password complexity is enforced using a verification function. Oracle provide an example password verification function in the “$ORACLE_HOME/rdbms/admin/utlpwdmg.sql” file, but you can code a custom one if you prefer. The function must accept three…