☰
  • Home
  • About Us
  • Contact Us
  • Privacy Policy

DBAtricksWorld.com

Sharing Knowledge is ultimate key to Gaining knowledge…

  • Home
  • About Us
  • Contact Us
  • Privacy Policy

Oracle Scripts

Query to find out progress of transaction recovery by SMON

Query to find out progress of transaction recovery by SMON

Script to find out total number of oracle schema objects and its size

Script to find out total number of oracle schema objects and its size

Script to find out datafiles with highest Input-Output activity

Script to find out datafiles with highest Input-Output activity

Script to extract size of Oracle tablespaces & associated datafiles

Script to extract size of Oracle tablespaces & associated datafiles

Script to extract total objects & size of all Schemas

Script to extract total objects & size of all Schemas

Script to extract Up time of Oracle database

Script to extract Up time of Oracle database

Script to figure out total number of log switch occurred

Script to figure out total number of log switch occurred

Script to find fragmentation in Oracle tablespaces

Script to find fragmentation in Oracle tablespaces

How to check RMAN backup status and timings

How to check RMAN backup status and timings

Sixteen Theme by InkHive