| ALL Types of Table Partitioning ....
All Active Session (Session Which are Currently Active)
All RMAN Backup List.
All RMAN Backup Set
All Segment/Extends Size of Schema Objects
Archive log file status in Data Guard.
Archive log sequence in Primary and Standby DB In Data Guard
Archive log size calculation. Finding Archive Log Size.
Blocking Session Tree Using SQL Statements.
Blocking Session With Number Of Blocking Session, Module, OS User, Module.
Cancel running RMAN Jobs.
Compare Data Volume Between Two Schemas
DB Wait Event Finding
Database Cache Hit Ratio (Consistent gets, DB Block Gets, Physical Reads)
Database Memory Stats Colection
Database Time Model Statistic Collection
EOD SOD Time Calculation
Extend list with size for particular tablespace / datafile.
Find Out Lock Objects With Lock Mode.
Find and kill Locking Session who is locking another session.
Find log archive and log apply gap in Data Guard
Find out schema/user last login time in database.
Finding Actual Active Session In Oracle Database.
Finding All LOB Segments in oracle database.
Finding Lock In Oracle Database using SQL Statements.
Finding Long Running SQL Statements Using Session Long Ops Data Dictionary View
Finding Operating Process With Oracle Process across by Session ID.
Finding User TRACE File Location.
Finding Your Database Size
GAP Finding in Oracle Data Guard
Generate ADDM Report Manually Using Snapshot.
Generate User Scrip and replace some string from database object and compile using PL/SQL.
Last RMAN Backup Status
List of ASM Alias With Disk Group, File Number
Lob Segment Size For Specific Table
Long Running Query Finding
-- show have fast scan operations
-- (sorting / hashing / table scans / index scans)
-- provides a MB/second metric that can be used to compare different systems
-- has plenty of flaws yet still works great
-- also provides an expected end time for the operation
Memory (PGA) Currently used by session.
Object Size Finding (Table, Index) Last Statistic Gather Date, Number of Index finding.
Operating System Process ID Across By Session ID
Oracle objects exist in memory, total size in memory.
Partitioning Existing Table
Query execute by Current Session / Query running from TOAD.
RMAN Backup Piece With file Location.
RMAN Backup Summary (Backup Sets) Reports
RMAN Backup lists.
Reclaim Data File And Find User Extends Size.
Redo Apply Service Monitoring.
Redo Transport Parameter Value and Information In Oracle Data Guard.
SGA & PGA, Current Size, History, Parameter Value, Memory.
SQL Statement History.
SQL Statements Currently Running In Database.
Segment List Order By Physical Read
Segment/Extends Size
Session wise memory use, disk read/write statistic Information.
Single Tablespace Size , Free Space, Number of Extends.
Tablespace Size (Total,Free,Used) Calculation.
Temporary Tablespace Size Information (Total Usage, Total Free)
This query help to find the blocker session information from V$LOCK Views.
Total size of Table & Index
Total size of schema in database
V$SQLSTATS View contain SQL Execution Elapsed Time including CPU Time, Disk Read/Write.
|