Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • export import with parameter file. Oracle
  • Find total file sizes Linux/Unix
  • Jai Shree Ram Oracle
  • fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
  • To see mem usage and CPU usage system wide. Linux/Unix
  • get_vmstat_solaris Oracle
  • age_alert.ksh aging out alert.log Linux/Unix
  • Optimizer_Index init.ora parameter explaination. Oracle
  • Good Site for Oracle Internals Oracle
  • How to analyze statspack or AWR report. Oracle
  • Handling LOB data in Oracle Oracle
  • Alter procedure auditing Oracle
  • Difference between SYNC and AFFIRM Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • dbms_job.submit example 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

  • SQL_PROFILE – I explaination Oracle
  • How can I tell if ASO is installed ? Oracle
  • create PLAN_TABLE command. Oracle
  • Jai Shree Ram Oracle
  • SQLPLUS COPY command Precautions. Oracle
  • Rownum with Order by 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
  • oracle fast start failover best practice Oracle
  • import-export with multiple files Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • Find Stale DR Physical Standby Oracle
  • Alter procedure auditing Oracle
  • oradebug ipcrm ipcs Oracle
  • send email from unix mailx with attachment. Linux/Unix
  • Check Oracle installed products using one command Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme