Author: Admin

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” »

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 GoldenGate Tutorial 9 – Monitoring GoldenGate

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

GoldenGate Tutorial: Simplest

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” »

–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;

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” »