Skip to content
Friday, May 27, 2022

Oracle Notes

A bunch of useful DB scripts

  • About
  • Administration
    • Export/Import
      • Data pump
      • Exp/Imp (<10g)
      • Transportable tablespaces
    • Jobs
      • 11g jobs
      • Change job (<10g)
      • Job details (10g+)
      • Job details (<=9i)
      • Stop job (<10g)
      • Submit job (<10g)
    • Security
      • All users
      • One user
      • Password generator
      • Roles
      • User privileges
      • User roles
    • SQL plus
  • Backup
    • Conventional backup
      • Hot backup
    • RMAN
      • Restore from backup
      • RMAN backups
      • RMAN progress
  • DB Structure
    • Datafiles
      • All datafiles
      • Flash recovery area
      • One tablespace datafiles
      • Resize datafile to HWM
      • Tempfiles
    • Indexes
      • Index fragmentation
      • Index partitions
    • Materializes views
      • Check mview status
      • Recompile mat. view
    • Objects
      • Dictionary objects
      • Invalid object summary
      • Invalid objects
      • Object source code
      • Objects info
      • Objects without stats
      • Schema size
    • Parameters
      • DB parameters
    • Tables
      • Columns
      • Constraints
      • Indexes
      • Partitions
      • Related child tables
      • Segment information
      • Table information
      • Top segments
      • Triggers
    • Tablespaces
      • All tablespaces
      • One tablespace
      • Temp tbs status
  • Misc
    • Powershell
    • Unix
      • Vi commands
  • MSSQL
    • AlwaysOn
      • Status
    • External resources
    • Jobs
      • Job history
    • Security
      • Account permissions
    • SQL Backup
      • Backup list
    • SQL Performance
      • CPU utilization
      • Sessions
    • Storage
      • Index/Table size
      • Space
  • Oracle notes
    • Exadata
    • Master notes
    • Performance notes
  • Performance
    • ADDM
      • Top queries
    • ASH
      • Blocking lock history
      • Resource intensive SQLs
      • Resource utilization
      • Sessions history
      • SQL history
    • AWR
      • AWR parameters
      • AWR snapshots
    • Locks
      • Blocking locks
      • DML locks – advanced
      • DML/DDL locks
    • Memory
      • SGA
    • Redo/archive logs
      • Log switch count
      • Log switch size
    • Sessions
      • Active sessions with SQL-text
      • Active user sessions
      • All user sessions
      • Long operations
      • Monitor import running
      • Open cursors
    • SQL plan
      • Explain plan
      • Show plan
    • Trace
    • Tuning
      • Query auto tune
    • Waits
      • Avg wait time
      • File waits
      • Oracle 10g enqueue waits
      • User waits
      • Wait event name
      • Waiter count
  • RAC/DataGuard
    • ASM
    • Exadata
    • Standby logs

Password generator

Strong password generator

Theme of Rigorous Themes