Oracle Standby Recovery Rate Monitoring
Why standby periodically lags during the day?
The script reports the time it took to apply the log, the size of the log, and the redo apply rate for that log.
Oracle Data Pump
- Data Pump runs only on the server side.
- You may initiate the export from a client but the job(s) themselves will run inside an Oracle server.
- There are no dump files (expdat.dmp) or log files that will be created on your local machine
All clients making use of this ASM Instance
– +—————————————————————————-+
– | Jeffrey M. Hunter |
– |—————————————————————————-|
– | PURPOSE : Provide a summary report of all clients making use of this ASM instance. |
– | NOTE : As with any code, ensure to test this script in a development environment before attempting to run it in production. |
– +—————————————————————————-+
Summary report of ASM disk groups and Space Utilised
PURPOSE : Provide a summary report of all disk groups.
SET LINESIZE 145
SET PAGESIZE 9999
SET VERIFY off
Performance summary report of all disks contained within all ASM DiskGroups
– +—————————————————————————-+
– | Jeffrey M. Hunter |
– |—————————————————————————-|
– | PURPOSE : Provide a summary report of all disks contained within all ASM |
– | disk groups along with their performance metrics. |
– | NOTE : As with any code, ensure to test this script in a development |
– | environment before attempting to run it in production. |
– +—————————————————————————-+
Summary report of all disks contained within all disk Groups
– +—————————————————————————-+
– | From : Jeffrey M. Hunter |
– | PURPOSE : Provide a summary report of all disks contained within all disk |
– | groups. This script is also responsible for queriing all |
– | candidate disks – those that are not assigned to any disk |
– | group. |
– +—————————————————————————-+
Mastering ASMCMD
cd Changes the current directory to the specified directory.
Display tablespace usage
column tsname format a30 heading ‘Tablespace Name’
column tbs_size_mb format 99999,999 heading ‘Size|(MB)’
column used format 99999,999 heading ‘Used|(MB)’
column avail format 99999,999 heading ‘Free|(MB)’
column used_visual format a11 heading ‘Used’
column pct_used format 999 heading ‘% Used’
Tweet