Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • Display the top 5 salaries for each department using single SQL Oracle
  • Implementation of key based authentications Linux/Unix
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • import-export with multiple files Oracle
  • Directory wise folder wise space usage Linux/Unix
  • tblwopk.sql tablewopk.sql Oracle
  • pvm_pre_change.sql Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • oracle_env_10g_CADEV Linux/Unix
  • SQL_PROFILE – I explaination Oracle
  • Find nth max and min. Oracle
  • TRUNCATE table and disabling referential constraints. Oracle
  • Single character replacement in Unix Linux/Unix
  • Find Stale DR Physical Standby Oracle

Oracle Data Direct to TAPE

Posted on 23-Aug-2005 By Admin No Comments on Oracle Data Direct to TAPE

Can one export directly to a tape drive? —————————————– One can use a tape device name instead of a normal file name. When using a device, one also needs to specify the VOLSIZE= parameter. Look at this example: exp userid/password file=/dev/rmt0 table=emp volsize=1.2G Note: The volume size is a number ending with a “m”, “k”,…

Read More “Oracle Data Direct to TAPE” »

Oracle, SQL scripts

Export Oracle data and Compress at same time

Posted on 23-Aug-2005 By Admin No Comments on Export Oracle data and Compress at same time

If one cannot afford to buy extra disk space one can run the export and compress utilities simultaneously. This will prevent the need to get enough space for both the export file AND the compressed export file. Eg: # Make a pipe mknod expdat.dmp p # or mkfifo pipe # Start compress sucking on the…

Read More “Export Oracle data and Compress at same time” »

Oracle, SQL scripts

How does one overcome the Unix 2 Gig file limit?

Posted on 23-Aug-2005 By Admin No Comments on How does one overcome the Unix 2 Gig file limit?

This example uses the Unix split command to create multiple files, each smaller than the Unix (and imp/exp) 2 Gigabyte file size limit. This method can typically be used for import, export and SQL*Loader operations. cd /tmp/data rm exp.dmp mknod exp.dmp p # mkfifo on certain Unix flavours split -b2047m /tmp/data/exp.dmp & imp scott/tiger file=/tmp/data/exp.dmp…

Read More “How does one overcome the Unix 2 Gig file limit?” »

Linux/Unix, shell

How does one SELECT a value from a table into a Unix variable? From SQL to Shell

Posted on 23-Aug-2005 By Admin No Comments on How does one SELECT a value from a table into a Unix variable? From SQL to Shell

One can select a value from a database column directly into a Unix environment variable. Look at the following shell script examples: #!/bin/sh VALUE=`sqlplus -silent user/password@instance

Linux/Unix, shell

Good Link from metalink 1

Posted on 19-Aug-2005 By Admin No Comments on Good Link from metalink 1

Metalink Performance Library Index

Oracle, SQL scripts

Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT)

Posted on 19-Aug-2005 By Admin No Comments on Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT)

BENEFITS of Locally Managed Tablespaces ————————————— Locally managed tablespaces track all extent information in the tablespace itself, using bitmaps, resulting in the following benefits: * Improved concurrency and speed of space operations, because space allocations and deallocations predominantly modify locally managed resources (bitmaps stored in header files) rather than requiring centrally managed resources such as…

Read More “Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT)” »

Oracle, SQL scripts

True Session Wait Activity in Oracle 10g Verygood

Posted on 19-Aug-2005 By Admin No Comments on True Session Wait Activity in Oracle 10g Verygood

True Session Wait Activity in Oracle 10g ======================================== Catching a session waiting on a resource used to be hit or miss. Let’s take a look at how Oracle has helped give us a better mousetrap for seeing the waits experienced by sessions. It used to be that a DBA would sit in front of the…

Read More “True Session Wait Activity in Oracle 10g Verygood” »

Oracle, SQL scripts

Absolute file number and relative file number

Posted on 19-Aug-2005 By Admin No Comments on Absolute file number and relative file number

Interpreting Wait Event “file#” and “block#” parameters ======================================================= This reference note describes how to interpret file# and block# parameters from wait events (eg: obtained from or from the WAIT trace lines in trace files). The text uses: &AFN to represent the absolute file number (file#) &BLOCKNO to represent the block number (block#) IMPORTANT: The details…

Read More “Absolute file number and relative file number” »

Oracle, SQL scripts

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

lck.sql

Posted on 19-Aug-2005 By Admin No Comments on lck.sql

select c.sid, c.serial#, c.username, a.object_id, b.object_name, c.program, c.status, d.name, c.osuser, e.sql_text, DBMS_ROWID.ROWID_CREATE(1, c.ROW_WAIT_OBJ#, c.ROW_WAIT_FILE#, c.ROW_WAIT_BLOCK#, c.ROW_WAIT_ROW# ) locked_rowid from v$Locked_object a, All_objects b, v$session c, audit_actions d, v$sqlarea e where a.object_id=b.object_id and a.session_id =c.sid(+) and c.command=d.action and c.row_wait_obj# != -1 and c.sql_id=e.sql_id;

Oracle, SQL scripts

Posts pagination

Previous 1 … 47 48 49 … 56 Next

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
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • How to analyze statspack or AWR report. Oracle
  • Load SPM baseline from AWR Oracle
  • Jai Shree Ram Oracle
  • SQL_PROFILE – I explaination Oracle
  • Finding locked objects Oracle
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme