SQL LIbrary

SQL

ASH

• List Distinct SQL IDs for a Given Session

• List SQL Run Dates for a Given Plan Hash Value

Automatic Storage Management (ASM)

• List ASM Disk Groups

• List ASM Disk Groups Attached to a DB

• List ASM Disk Groups and Files

Data

• Display the Time a Row was Updated

• Check the Number of Rows per Block

• Check How Much Table data has Changed Since the Last Analyze

• Find out what NLS settings are in place

• How to Run a Parallel Datapump Table Only Export

• List all Tables with Supporting Information

• List the Size and Quantity of Extents for a given Segment

• List Fragmentation in a Segment

Flashback

• List Earliest Flashback Database Time and SCN

• List Flashback Database Restore Points

• List the Flashback Logging Size

• List Flashback Log Details

• Flashback Database Commands

IO

• Show Total IO for Each Datafile

• Show the Number of Redo Log Switches per Hour

• Show Disk File Operations

• Show Historical Redo Usage

Jobs and Scheduling

• Shows Scheduler Job Credentials

• List Job Schedules

• List Running Jobs

• Show Scheduler Information

• Show Scheduled Windows

• Show Information About Scheduler Windows

• Show Job Class Information

• List Job Information

• List Information for All Jobs Currently Running

Memory

• Buffer Cache Hit Ratio

• SGA Resize Operations

• Show SGA Pool Info

• Show SGA Buffer Info

• Shows Memory Target Advice

• Show Memory Allocations for Database Sessions

• Show Object Cache Information

Miscellaneous

• List Installed RDBMS Components

• Show RDBMS Feature Usage

• List Service Info

• List High Water Mark Stats for Database Components.

• List All Database Parameters

• List All Hidden Database Parameters

• List Database Parameter History

• List of PL/SQL Code Blocks that Contain a Specified Word

• Check to see if a Data Pump Job is Hung

• Read Information from the Alert Log via SQL

• Read the Alert Logs via SQL on RAC

• Find the Cause of Invalid Objects

• Useful Date Manipulation SQL

• Show the First Day of the Month

• Show the Last Day of the Month

• Show the Number of Days in this Month

• Show the Remaining Days this Month

• Show the First Day of the Year

• Show the Number of Seconds So Far Today

• Show the Number of Seconds Left Today

• Show the Start Date and End Date of the Month

• Show Number of Months Between Two Dates

• Show the Last Day of the Year

RAC

• Lists all locked objects for the whole RAC Cluster

• Show Undo Information for RAC

• List Long Operations for RAC

• List Session Waits for RAC

• List Memory Allocations for RAC Sessions

• List RAC Sessions

Resource Manager

• List Active Resource Plan

• List Consumer Groups

• List Resource Plans

• List Information on Consumer Groups Usage

• List Plan Directives

RMAN

• List RMAN Jobs

Rollback, Undo & Redo

• Rollback Monitor

• Show Rollback Stats

• Show REDO Information

• Display Archive Log Generation by Day

Published 

31st May 2022