Skip to content
Saturday, May 04, 2024
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
Search for:
Stop job (<10g)
<br /> exec dbms_job.broken(jobid, TRUE);<br />
exec dbms_job.broken(jobid, TRUE);