Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • upload.html PHP/MYSQL/Wordpress
  • DBMS_Shared_pool pinning triggers Oracle
  • Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
  • find_cons.sql Oracle
  • Remove duplicate rows from table Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • SQL Server: How to see current transactions or requests SQL Server
  • Important Solaris Commands Linux/Unix
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • Kill a session dynanically using execute immediate Oracle
  • good linux notes Linux/Unix
  • Small sample shell program Linux/Unix
  • replacing ^M character when passing files from Windows to Unix Linux/Unix

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

  • dbms_job.submit example Oracle
  • v$event_name Oracle
  • Rename Oracle Instance Name Oracle
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • before_trunc.sql Before Truncate table needs to execute following: Oracle
  • Handling LOB data in Oracle 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 (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to know current SID Oracle
  • OEM-Commnds Oracle
  • Good links for x$ tables in oracle. Oracle
  • fuser to check who is using diretory Linux/Unix
  • Load SPM baseline from AWR Oracle
  • Jai Shree Ram Linux/Unix
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • DBMS_Shared_pool pinning triggers Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme