Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Goldengate Tutorial Oracle
  • online_ts_bkup.sql Oracle
  • Zip and unzip with tar Linux/Unix
  • Pending Distributed Transations Oracle
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • newupload.html PHP/MYSQL/Wordpress
  • Jai Shree Ram Oracle
  • Validating ORACLE_SID againt oratab file. Linux/Unix
  • Proc code Oracle
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • Specify the Rollback segment to use in Transaction Oracle
  • currwait.sql Oracle
  • How to find password change date for user Oracle
  • Database link password in user_db_links Oracle
  • proc.sql 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

  • New Latest Param.sql for finding all hidden parameters also Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • My Test Case On 21-OCT-2005 Oracle
  • get_vmstat.ksh for Solaris Oracle
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • Jai Shree Ram 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • backspace in SQL Plus not working then..? Linux/Unix
  • Find all users who have DML privileges Oracle
  • metalink all dynamic view reference notes. Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • create trigger syntax Oracle
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • DBMS_JOB all example Oracle
  • Sample WW22 listener.ora Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme