MYR
AboutExpertiseArticlesScriptsContact
Get in touch
← All scripts// SCRIPTS

Oracle

Monitoring

12

Sessions, waits, blocking, and health checks.

Performance

26

AWR, ASH, SQL tuning, and plan analysis.

RAC

13

Cluster, CRS, and node management.

Data Guard

11

Standby, gap, and switchover checks.

Backup & Recovery

6

RMAN, restore, and validation.

Space Management

32

Tablespaces, segments, and growth.

Users & Privileges

14

Accounts, roles, and grants.

Security

15

Auditing, encryption, and access control.

Patching & Upgrade

12

Opatch, datapatch, and upgrades.

Redo & Archive Logs

11

Redo logs, archiving, and generation rates.

ASM & Storage

7

Disk groups, disks, and rebalance operations.

Sessions & Locks

19

Blocking, locks, active sessions, and killing sessions.

Statistics

8

Optimizer statistics: gathering, staleness, and history.

PDB & Multitenant

12

Pluggable databases: status, open, close, and create.

Scheduler & Jobs

9

DBMS_SCHEDULER jobs, runs, and status.

MYRSolution Architect
EmailLinkedInArticlesScriptsPrivacy
© 2026 Mohammad Yoga Rimaldo