Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • DB Console Mainenance. Oracle
  • Removing Blank lines from file using grep Linux/Unix
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • logminer and my_lbu Oracle
  • To Find Orphan OS processes. Linux/Unix
  • DBA_HIST_SQLSTAT contents Oracle
  • Roles and Stored Object behaviour Oracle
  • Check SQL Server edition SQL Server
  • TNSNAMES entries details Oracle
  • Jai Shree Ram Oracle
  • catting.sh Linux/Unix
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • SQL Server Vs Oracle Architecture difference SQL Server
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle

The most important Tuning Notes

Posted on 18-Aug-2005 By Admin No Comments on The most important Tuning Notes

Note:61552.1

Database Is Slow.

(*) Any recent upgrade/degrade activities???

(2)Check Alert.log and trace files for any cause.

(2) Check # of sessions, # of processes.

(3) Check event init.ora parameter to see whether any event is set or not.

(4) check # of log switching.

(5) check archive log destinations space problem or ARCH may have stopped working so all online redolog files are in active stage and they dont have any logfile available to switch over.

(6)

Oracle, SQL scripts

Post navigation

Previous Post: Oracle 10g Wait Model
Next Post: lck.sql

Related Posts

  • Oracle Connections expire_time and firewall Oracle
  • login.sql Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • Virtual Indexes in Oracle Oracle
  • Alter procedure auditing Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle

Leave a Reply Cancel reply

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

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (400)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (348)
  • SQL Server (6)
  • Uncategorized (3)
  • Videos (0)

Recent Posts

  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026
  • Creating a Container Database using dbaascli08-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026
  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • Flowers Resize datafiles Oracle
  • perf_today.sql Oracle
  • Histogram information Oracle
  • OEM-Commnds Oracle
  • New Latest Param.sql for finding all hidden parameters also Oracle
  • how to find OS block size Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme