Skip to content

Home
About Me
Toggle search form
Search for:

Ports used by Oracle Software Oracle
Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
Distributed Transaction Troubleshooting. Oracle
findinfo.sql (SQL for getting CPU and Active session info) Oracle
create PLAN_TABLE command. Oracle
276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
All About Trace Fils Oracle
How to Make Trace Files Created by Oracle Readable by All Users ? Oracle
export import with parameter file. Oracle
ipcs -l Linux/Unix
Find Multiple levels of object dependencies : depen.sql Oracle
The most important Tuning Notes Oracle
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
Drop specific SQL plan baseline – spm Oracle
Very clear article about oracle dataguard Oracle

Index Range Scan

Posted on 01-Dec-2005 By Admin No Comments on Index Range Scan

If your index is NONUNIQUE, you cant enforce Index Unique Scan.

Oracle, SQL scripts

Post navigation

Previous Post: SQLPLUS COPY command Precautions.

Next Post: USE_NL and INDEX hints example

Related Posts

My Minimum Tuning Programs Oracle
Good RAC & Standby Notes Oracle
Specify the Rollback segment to use in Transaction Oracle
Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
Find Time Consuming SQL Statements in Oracle 10g Oracle
find_string_in_database.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)
Linux/Unix (149)
MYSQL (5)
Oracle (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (342)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

Trace a SQL session from another session using ORADEBUG30-Sep-2025
SQL Server Vs Oracle Architecture difference25-Jul-2025
SQL Server: How to see historical transactions25-Jul-2025
SQL Server: How to see current transactions or requests25-Jul-2025
T-SQL Vs PL/SQL Syntax25-Jul-2025
Check SQL Server edition25-Jul-2025
Checking SQL Server Version25-Jul-2025
Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
V$INSTANCE of Oracle in MYSQL24-Jul-2025
Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

To find explain plan for a statement that occurred in past. Oracle
oracle fast start failover best practice Oracle
How to analyze statspack or AWR report. Oracle
True Session Wait Activity in Oracle 10g Verygood Oracle
How to specify 2 arch location to avoid any kind of DB hanging. Oracle
Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
send email from unix mailx with attachment. Linux/Unix
CPU speed on solaris Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme