Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL help for a beginner
You might even try this infamous process; Create an On Insert trigger on 2 tables -( Table 1 and Table 2) In table 1 have it insert a copy of that record into Table 2 In Table 2 have it insert a copy of that record into table 1
Batch Insert a bunch of records into Table 1 and watch the fun...
( Please do not try this at home..only skilled professionals on a closed course used in this demo)
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
>"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
>news:amec6h$37i$2_at_ctb-nnrp2.saix.net...
>> steve wrote:
>>
>> > I need to "hammer" on the database, causing tremendous amounts of I/O.
>> > I have one program that I submit about 30 processes of to a batch queue,
>> > and it does 50K inserts to the table (per process), but the machine is
>> > still loafing.
>>
>> Try using full table scans (not using any indexes). This can be done via a
>> hint in your SQL SELECT statement, e.g.
>> SELECT /*+ FULL(tablename) */ * FROM tablename
>>
>> Use cartesian joins, e.g.
>> SELECT * FROM table1, table2, table3
>>
>> Combine these with a CREATE TABLE AS SELECT.
>>
>> In fact, being a newbie you have all the qualifications you need or
>> hammering Oracle. :-)
>
>Also forgot to mention, don't forget to size your redo buffer at the default
>32k and the redo logs at say 128k so as to checkpoint as often as possible.
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Sep 20 2002 - 10:13:45 CDT