FW: Handling tables with very frequent inserts ....

Gurus, Pl. answer my query below.

Kamesh.

-----Original Message-----
From: Kamesh.J.Mantri [mailto:Kamesh.J.Mantri_at_citicorp.com] Sent: Monday,July 24, 2000 11:35 AM
To: ORACLE-L
Cc: Kamesh.J.Mantri
Subject: Handling tables with very frequent inserts ....

Hi Gurus,

   I have a table(audit log)which gets atleast 3inserts/sec with immediate
(Transaction Based)commits thru out the year 24/7.
The vsize of each record is around 8000 bytes.

One morething is that I need to purge rows every EOD which are older than 3 days from the current date & time with a procedure.

Now my questions :

1. How many rollback segments do I need to have and what is the size of each approx ?
2. What type of mechanism I should use to purge the rows in the procedure ? My present solution for deleteing the rows is to delete the rows is to split the whole set of rows in sets of 5 min in loop and then delete them with immediate commits to avoid rollback contention. Will this work ?

It would be great if anyone could give me suggestions in this regard.

Regards,
Kamesh.

-- 
Author: 
  INET: Kamesh.J.Mantri_at_citicorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).