Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • To find explain plan for a statement that occurred in past. Oracle
  • process id based files and processes Linux/Unix
  • Read CSV File using Python Python/PySpark
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • shr1.sql for MTS or Shared server configuration Oracle
  • move_arch_files.ksh Linux/Unix
  • Oracle 11g Environment Setup Oracle
  • oradebug ipcrm ipcs Oracle
  • export import with parameter file. Oracle
  • scripts to take listener.log backup Linux/Unix
  • Pending Distributed Transations Oracle
  • EXTPROC Oracle
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • Kernel Parameters for Solaris Linux/Unix
  • Temporary tablespace explaination 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

  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • v$backup.status information Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • Find Stale DR Physical Standby Oracle
  • Good notes on Oracle Events 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 (387)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (336)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Add new columns in dataframe30-Sep-2023

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Unix split command to split files Linux/Unix
  • Logic to chech # of parameters command line parameters Linux/Unix
  • Good RAC & Standby Notes Oracle
  • Nice notes on wait events Oracle
  • plan10g.sql Oracle
  • Rownum with Order by Oracle
  • create database link syntax Oracle
  • Rman Notes -1 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme