this 8.0.6 is gonna be the death of me!!!!

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Tue, 25 Jun 2002 19:12:03 +1000
Message-ID: <3d183555$0$28008$afc38c87@news.optusnet.com.au>

Yes Mastah?INSERT INTO PS_BI_BILL_LST_TMP   2 (PROCESS_INSTANCE, OPRID,
blah,blah,blah...
 11 PRT_CUST_LABEL, CUSTOM_LABEL,
 12 PRT_INVOICE_SORT , USE_CURRENT_ADDR)  13 SELECT /*+ FIRST_ROWS */
 14 641797.000000000000000, OPRID,
blah,blah,blah...
 23 PRT_CUST_LABEL, CUSTOM_LABEL,
 24 PRT_INVOICE_SORT , USE_CURRENT_ADDR  25 FROM PS_BI_BILL_LIST_VW
 26 WHERE OPRID = 'BATCH'
 27 AND RUN_CNTL_ID = 'DUNNING_SSYD1_PASS1'  28 /  

750 rows created.  

Elapsed: 00:00:16.29  

Statistics

---

          7  recursive calls
        155  db block gets
     573043  consistent gets
          0  physical reads
     269920  redo size
        407  bytes sent via SQL*Net to client
       1335  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
        750  rows processed
 

Yes Mastah?rollback;  

Rollback complete.
...... pause for deep breaths.....
......

Yes Mastah?INSERT INTO PS_BI_BILL_LST_TMP   2 (PROCESS_INSTANCE, OPRID,
blah,blah,blah...
 11 PRT_CUST_LABEL, CUSTOM_LABEL,
 12 PRT_INVOICE_SORT , USE_CURRENT_ADDR)  13 SELECT
 14 641797.000000000000000, OPRID,
blah,blah,blah
 23 PRT_CUST_LABEL, CUSTOM_LABEL,
 24 PRT_INVOICE_SORT , USE_CURRENT_ADDR  25 FROM PS_BI_BILL_LIST_VW
 26 WHERE OPRID = 'BATCH'
 27 AND RUN_CNTL_ID = 'DUNNING_SSYD1_PASS1'  28 /  

750 rows created.

!!!!!!!!!!!!!!!!!!!!!!! 

Elapsed: 04:45:23.54

!!!!!!!!!!!!!!!!!!!!!!!

Statistics

---

          7  recursive calls
          0  db block gets
     573043  consistent gets
          0  physical reads
     269920  redo size
        407  bytes sent via SQL*Net to client
       1335  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
        750  rows processed



............<pant pant>................

AAAAAARAARRRRRRRRARARAGGGHHHHH!!!!!!!!!!!!!!!!!!!!!!!!


............<pant pant>................

Bloody hell!!!!
sorry folks, just had to vent...

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam

Received on Tue Jun 25 2002 - 04:12:03 CDT