Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • ext#.sql Oracle
  • Find Stale DR Physical Standby Oracle
  • Locktree.sql Oracle
  • RAC 11g with vmware Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • My FTP Job Scheduling for www.pvmehta.com PHP/MYSQL/Wordpress
  • UTL_FILE test program Oracle
  • Oracle 10g for solaris 10 Oracle
  • good note for shared pool tunnig Oracle
  • find checksum of a file. Linux/Unix
  • Linux CPU info. Linux/Unix
  • Implementation of key based authentications Linux/Unix
  • Creating never expiring DB user accounts in Oracle Oracle
  • Index Range Scan Oracle
  • More info about /proc folder and its relation with processes. 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

  • proc.sql Oracle
  • All About oracle password and security from metalink Oracle
  • How can I tell if ASO is installed ? Oracle
  • perf_today.sql Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • Renaming Global Name GLOBAL_NAME Oracle

Leave a Reply Cancel reply

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

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • VIvek Encryption Package and Its Usage Oracle
  • Implementing Listener Security Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • rm_backup_arch_file.ksh Linux/Unix
  • online_ts_bkup.sql Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • SAN Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme