Skip to content

Home
About Me
Toggle search form
Search for:

Find long Running Transaction Linux/Unix
Linux CPU info. Linux/Unix
get_vmstat.ksh for Solaris Oracle
scripts to take listener.log backup Linux/Unix
Very Good Oralce Internal Tuning Book Oracle
sbind.sql Find Bind variable from sql_id sqlid Oracle
Rename Oracle Instance Name Oracle
DBMS_JOB all example Oracle
Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
Very clear article about oracle dataguard Oracle
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
Exadata Basics Oracle
SYSOPER Mystery Oracle
To Find Orphan OS processes. Linux/Unix
Display the top 5 salaries for each department using single SQL Oracle

Important Script Method for tuning

Posted on 19-Aug-2005 By Admin No Comments on Important Script Method for tuning

wait.sql

enqueue_type.sql

lck.sql

Oracle, SQL scripts

Post navigation

Previous Post: lck.sql

Next Post: Absolute file number and relative file number

Related Posts

usnsql.sql Displays information about UNDO segments with sql statements Oracle
DBMS_STATS Metalinks Notes Oracle
reset Sequence Oracle
10g oem configuration Oracle
SYSOPER Mystery Oracle
eplan9i.sql Oracle

Leave a Reply Cancel reply

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

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Categories

Ansible (0)
AWS (2)
Azure (1)
Django (0)
GIT (1)
Linux/Unix (149)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (350)
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.sql23-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

Pending Transaction Neighbors Script Oracle
V$ROLLSTAT status is Full Oracle
oracle fast start failover best practice Oracle
DBMS_PROFILER for tuning PLSQL programs. Oracle
Find Stale DR Physical Standby Oracle
sid_wise_sql.sql Further explaination Oracle
avail.sh ( find filesystem spae usage) Linux/Unix
TNSNAMES entries details Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme