Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Find average Row Length and other table size calculation. metalink notes Oracle
  • Wait Based Tuning Step by step with SQL statement Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • metalink all dynamic view reference notes. Oracle
  • oradebug ipcrm ipcs Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • nfs mount command Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • More info about /proc folder and its relation with processes. Linux/Unix
  • Sequence Resetting Oracle
  • lck.sql Oracle
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle

Year: 2005

Virtual Indexes in Oracle

Posted on 29-Dec-2005 By Admin No Comments on Virtual Indexes in Oracle

Create virtual indexes 11:42:42 CS@UOCQA:-> create index index_1 on BSKT_SHOPPING_BASKET_ITEM (BASKET_RECIPIENT_ID, BASKET_ITEM_ID) nosegment; need to set a hidden parameter as following. 11:42:42 CS@UOCQA:-> alter session set “_use_nosegment_indexes”=true; Indexes created without any segment. cannot views with User_indexes. Can be viewed in USER_OBJECTS. Useful in producton environment where we cannot create any indexes. Existance of this index…

Read More “Virtual Indexes in Oracle” »

Oracle, SQL scripts

Optimizer SORT Operations

Posted on 28-Dec-2005 By Admin No Comments on Optimizer SORT Operations

(1) Operation : SORT UNIQUE Cause : DISTINCT Clause, and IN sub-query where subquery is independent meand no co-relation with parenst query. If for IN subquery, there is an unique index on selected columns then SORT UNIQUE can be avoided. (2) Operation : SORT AGGREGATE Cause : Whenever u use group functions. It does not…

Read More “Optimizer SORT Operations” »

Oracle, SQL scripts

Good Site for Oracle Internals

Posted on 23-Dec-2005 By Admin No Comments on Good Site for Oracle Internals

http://www.EvDBT.com/library.htm

Oracle, SQL scripts

Find All internal Parameters

Posted on 23-Dec-2005 By Admin No Comments on Find All internal Parameters

select a.ksppinm “Parameter”, b.ksppstvl “Session Value”, c.ksppstvl “Instance Value” from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and substr(ksppinm,1,1)=’_’ order by a.ksppinm;

Oracle, SQL scripts

Find Time Consuming SQL Statements in Oracle 10g

Posted on 22-Dec-2005 By Admin No Comments on Find Time Consuming SQL Statements in Oracle 10g

spool badsql5 set lines 132 set pages 300 col USR format a14 col PAR heading “Parsing ID” format 9999999 col ELA heading “ELP time(Sec)” format 9999999.0 col HASH heading “Hash Value” col USR heading “Parsing User” col T heading “SQL Text having Elapsed time > 1 sec” break on HASH on USR on ELA skip…

Read More “Find Time Consuming SQL Statements in Oracle 10g” »

Oracle, SQL scripts

Goog notes on X$ tables

Posted on 21-Dec-2005 By Admin No Comments on Goog notes on X$ tables

http://www.adp-gmbh.ch/ora/misc/x.html http://www.orafaq.com/faqdbain.htm

Oracle, SQL scripts

Histogram Overview

Posted on 20-Dec-2005 By Admin No Comments on Histogram Overview

Histograms ========== For uniformly distributed data, the cost-based approach makes fairly accurate guesses at the cost of executing a particular statement. However, when the data is not uniformly distributed, the optimizer cannot accurately estimate the selectivity of a query. Beginning in release 7.3, for columns which do not have uniform data distribution, Oracle will allow…

Read More “Histogram Overview” »

Oracle, SQL scripts

To see only files and/or folders using LS command

Posted on 20-Dec-2005 By Admin No Comments on To see only files and/or folders using LS command

To see only files use follwoing command. ls -l | grep -v “^d” To see only folders use follwoing command. ls -l | grep “^d”

Linux/Unix, shell

Process Map for CPU and Memory for OS processes

Posted on 20-Dec-2005 By Admin No Comments on Process Map for CPU and Memory for OS processes

Remember : 2 commands to see OS stats. (1) TOP : This command will provide following information. SIZE column display Memory allocated to this process. RES column display Actually allocated memory for the process. tuningdb21->AWRTEST@(/db1/home/oracle/paresh)top load averages: 0.17, 0.15, 0.14 10:51:36 120 processes: 119 sleeping, 1 on cpu CPU states: % idle, % user, %…

Read More “Process Map for CPU and Memory for OS processes” »

Linux/Unix, shell

DBMS_STATS Metalinks Notes

Posted on 15-Dec-2005 By Admin No Comments on DBMS_STATS Metalinks Notes

Note:102334.1 Subject: How to Automate Change Based Statistic Gathering – Monitoring Tables

Oracle, SQL scripts

Posts pagination

1 2 … 16 Next

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
  • Paste command syntax Linux/Unix
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • Debugging Shell FIles Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • EXTPROC Oracle
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • arch_configUOCIOTTO.ora Oracle
  • Implementation of key based authentications Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme