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