Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • online_bkup.sql Oracle
  • Drop database in Oracle 10g Oracle
  • To Find Orphan OS processes. Linux/Unix
  • Optimizer SORT Operations Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • fuser to check who is using diretory Linux/Unix
  • Create type and Grant on it. Oracle
  • Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
  • TNSNAMES entries details Oracle
  • find_longsql.sql Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • login.sql Oracle
  • Single character replacement in Unix Linux/Unix

Category: Oracle

Temporary Tablespsace Temp tablespace behaviour

Posted on 25-May-2010 By Admin No Comments on Temporary Tablespsace Temp tablespace behaviour

Description =========== When monitoring the size of the available free space in the TEMPORARY tablespace it does not increased once sorts are finished even with no client connections to the database. They may also be a large number of EXTENTS of type TEMPORARY in the temporary tablespace. Users may also experience ORA-1652 when running transactions….

Read More “Temporary Tablespsace Temp tablespace behaviour” »

Oracle, SQL scripts

Handling LOB data in Oracle

Posted on 24-May-2010 By Admin No Comments on Handling LOB data in Oracle

Here is another good example: You can initialize the LOBs by using the following SQL INSERT statement: INSERT INTO lob_table VALUES (1001, EMPTY_BLOB(), NULL, EMPTY_CLOB(), NULL); External LOBs: INSERT INTO lob_table VALUES (21, NULL, NULL, NULL, BFILENAME(‘IMG’, ‘image1.gif’)); INSERT INTO lob_table VALUES (22, NULL, NULL, NULL, BFILENAME(‘IMG’, ‘image2.gif’)); UPDATE lob_table SET f_lob = BFILENAME(‘IMG’, ‘image3.gif’)…

Read More “Handling LOB data in Oracle” »

Oracle, SQL scripts

oracle Dba site

Posted on 07-May-2010 By Admin No Comments on oracle Dba site

Oracle GoldenGate Tutorial 9 – Monitoring GoldenGate

Oracle, SQL scripts

Goldengate document from Porus

Posted on 07-May-2010 By Admin No Comments on Goldengate document from Porus

http://www.oracle.com/technology/pub/articles/havawala-goldengate.html

Oracle, SQL scripts

Goldengate Tutorial

Posted on 07-May-2010 By Admin No Comments on Goldengate Tutorial

GoldenGate Tutorial: Simplest

Oracle, SQL scripts

ORA-3136

Posted on 06-May-2010 By Admin No Comments on ORA-3136

Issue: Inbound connection timed out (ORA-3136) In 10gR2, SQLNET.INBOUND_CONNECT_TIMEOUT the parameters were set to have a default of 60 (seconds). Set the parameters SQLNET.INBOUND_CONNECT_TIMEOUT and INBOUND_CONNECT_TIMEOUT_listenername to 0 (indefinite). What the error is telling you is that a connection attempt was made, but the session authentication was not provided before SQLNET.INBOUND_CONNECT_TIMEOUT seconds. As far as…

Read More “ORA-3136” »

Oracle, SQL scripts

find_longsql.sql

Posted on 06-May-2010 By Admin No Comments on find_longsql.sql

–Ref: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1198012113596 column dur format a20 set lines 120 pages 200 select a.sid, a.serial#, a.username, to_char(sysdate-a.last_call_et/24/60/60,’hh24:mi:ss’) started, trunc(a.last_call_et/60) || ‘ mins, ‘ || mod(a.last_call_et,60) ||’ secs’ dur, b.sql_text from v$sql b, v$session a where a.username is not null and a.last_call_et > 10 and a.status = ‘ACTIVE’ and a.sql_address = b.address;

Oracle, SQL scripts

Display the top 5 salaries for each department using single SQL

Posted on 03-May-2010 By Admin No Comments on Display the top 5 salaries for each department using single SQL

Ok, given the clarification I can show you a way to get this in 815 and before (slow on a big table) and in 816 and up (fast with analytic functions!) ops$tkyte@ORA817.US.ORACLE.COM> select * from t; DEPTNO SAL ———- ———- 10 100 10 100 10 200 10 300 10 400 10 500 20 100 20…

Read More “Display the top 5 salaries for each department using single SQL” »

Oracle, SQL scripts

import-export with multiple files

Posted on 23-Apr-2010 By Admin No Comments on import-export with multiple files

exp userid=fdba file=dmp1.dmp,dmp2.dmp,dmp3.dmp log=myfinaldmp.log feedback=20000 filesize=1800M tables=Sp.SP_FLWS_ORDER_STATUS,Sp.SP_FLWS_ORDER_STATUS_DETAIL,sp.SP_MONITOR statistics=none Default: expdat.dmp Specifies the names of the export files to import. The default extension is .dmp. Because Export supports multiple export files (see the following description of the FILESIZE parameter), you may need to specify multiple filenames to be imported. For example: imp scott/tiger IGNORE=y FILE =…

Read More “import-export with multiple files” »

Oracle, SQL scripts

Oracle Statspack survival Guide

Posted on 13-Apr-2010 By Admin No Comments on Oracle Statspack survival Guide

http://www.akadia.com/services/ora_statspack_survival_guide.html

Oracle, SQL scripts

Posts pagination

Previous 1 … 3 4 5 … 39 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
  • Kill a session dynanically using execute immediate Oracle
  • When to rebuld B-tree index Oracle
  • Display the top 5 salaries for each department using single SQL Oracle
  • Small sample shell program Linux/Unix
  • oracle fast start failover best practice Oracle
  • chk_space_SID.ksh Linux/Unix
  • find_cons.sql Oracle
  • Gathering statistics with DBMS_STATS Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme