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

Hi Nuno

That's impressive. How did you manage to run it so fast the first time :) Why Oracle moved on from 8.0.6 I'll never know ;)

Richard
"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3d183555$0$28008$afc38c87_at_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:30:02 CDT