Difference between revisions of "Administrative-Tasks"
Jump to navigation
Jump to search
(Created page with " Scripts to monitor database is up Check Database UpTime in Unix Check Undo Tablespace Usage | C...") |
|||
Line 34: | Line 34: | ||
[[DBLinks not in Use | DBLinks not in Use]] | [[DBLinks not in Use | DBLinks not in Use]] | ||
+ | |||
+ | |||
+ | |||
+ | === ASM === | ||
+ | [[ Check Disk Groups | Check Disk Groups ]] | ||
+ | |||
+ | [[ High Level Steps to Migrate Datafiles (Disk Groups) | High Level Steps to Migrate Datafiles (Disk Groups) ]] | ||
+ | |||
+ | |||
+ | |||
+ | ===OEM Hints and Tips=== | ||
+ | |||
+ | [[UDM Collection Interval|UDM Collection Interval]] | ||
+ | |||
+ | |||
+ | |||
+ | === OEM Repository Scripts (run as SYSMAN user on 10g) === | ||
+ | |||
+ | Note: Some of the Metric Names used in these scripts may be specific to my environment. You should be able to find similar ones in yours! | ||
+ | |||
+ | |||
+ | [[ Database Size (1) | Database Size (1) ]] | ||
+ | |||
+ | [[ Database Size (2) | Database Size (2) ]] | ||
+ | |||
+ | [[ Datafile Size | Datafile Size ]] | ||
+ | |||
+ | [[ Tablespace Allocated and Used | Tablespace Allocated and Used ]] | ||
+ | |||
+ | [[ Clearing Alerts | Clearing Alerts ]] | ||
+ | |||
+ | [[ User Defined Metrics | User Defined Metrics ]] | ||
+ | |||
+ | [[ List_DBs_on_AIX | List Databases Hosted on AIX ]] |
Latest revision as of 23:03, 8 November 2019
Scripts to monitor database is up
Check Oracle Open Cursors by Session
Check Generated Archivelog Sizes
Dynamically Create/Drop Restore Points
Trigger to Startup Pluggable Databases and Services
ASM
High Level Steps to Migrate Datafiles (Disk Groups)
OEM Hints and Tips
OEM Repository Scripts (run as SYSMAN user on 10g)
Note: Some of the Metric Names used in these scripts may be specific to my environment. You should be able to find similar ones in yours!