Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
  • dbinv.sql Oracle
  • reset Sequence Oracle
  • Finding Oracle Patches with opatch Oracle
  • Find all users who have DML privileges Oracle
  • Facts about SCN and Rollback Segment Oracle
  • CPU speed on solaris Linux/Unix
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • online_bkup.sql Oracle
  • checking redhat linux version Linux/Unix
  • run this before doing any dbchange pvm_pre_change.sql Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • VIvek Encryption Package and Its Usage Oracle

standard Monitoring – 1

Posted on 04-Jun-2008 By Admin No Comments on standard Monitoring – 1

ALL DB = Primary + DR databases.

-> Implement checkfile concept so script will not page for planned maitenance.

(1) Connect and update all Primary db for hang check.

(2) Check for pmon for all db.

(3) Check Alert log for ORA error for Primary database.

(4) Purge Alert log of Primary and keep backup for last 15 days.

(5) Nullify listener.log of Primary every Month/15days/week.

(6) Switch logfile for each Primary for every 15 mins.

(7) Purge old archlog file that is 1 week old. ( This needs to check for the logs must be applied on all DR boxes, Else Page Immediately)

(8) Purge old acrhfile based on threshold. ( This needs to check for the logs must be applied on all DR boxes, Else Page Immediately)

(9) Check for space on all segments in the databases.

(10) Check for MAXEXTENTS reached in all databases.

(11) Copy the listener.ora / tnsnames.ora from Primary to its DRs whenever any changes done.

(12) Do tnsping on all database link from Primary and its DRs.

(13) Run Autorecovery for all DRs.

(14) Check recovery for all DRs.

(15) Purge all tracefiles for every week.

(16) Check all .err files in $SCRIPTS/log folder for any kind of Errors and page if that box is production.

(17) Copy arch files from Primary to DR.

(18) Copy all crontabs for all production server.

(19) Implement checkfile concept. So this scripts will not page when there will be a planned maintenance.

(20) Preserve the backup of all monitoring scripts. (Weekly or manually).

(21) Check for consistent locks in the databases and email it periodically of locks are held for some threshold time.

(22) Query on vmstat output to see if there is any CPY hike that crossed certain thereshold.

(23) For JDBC based applications, monitor open_cursors count from V$sysstat for databases.

(24) Validate standby for any NOLOGGING operations done on Priduction.

For statistics gathering:

(1) Run vmstat on each server to collect stats for every 5 mins.

(2) Check statspack/awr is running for 9i/10g instances.

Other periodic tasks

(1) Analyze weekly.

Thanks & Regards

Paresh Mehta

Oracle, SQL scripts

Post navigation

Previous Post: Zip and unzip with tar
Next Post: ORA-00064: object is too large to allocate on this O/S during startup

Related Posts

  • Composite Index creation tip from Vivek Oracle
  • Rman Notes -1 Oracle
  • Flowers Resize datafiles Oracle
  • Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • Good Oracle Architecture In Short and point to point Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • ext#.sql Oracle
  • Jai Shree Ram Oracle
  • pvm_pre_change.sql Oracle
  • send email from unix mailx with attachment. Linux/Unix
  • Oracle Material from OTN Oracle
  • sess_server.sql Oracle
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme