Rollback Segments

Hello all you Oracle Guhrus,

I am an Oracle Application Developer. Here is are current configuration:

Tools:

SqlForms3.0
Sql ReportWriter 1.1
Oracle DMBS 6.036

The front end is a Sun IPC
and the database is on an HP755.

Their are about 6-10 different applications running on the HP at any given time. Usually about 200 users are logged onto the database during the day. (all remote via two_task).

We have encountered two problems:

1. The rollback segment gets filled up by other users and our application's batch processing sometimes.

   We have set transaction to the biggest rollback - 100 megs and still have    this problem. Can we assign a specific rollback exclusively to our application?

2. We also use a table that we insert and delete data from than cannot be dropped.

   Each batch run deletes and inserts 200 records in this table - 100 TIMES.    Eventualy the table extents are exceeded even though the table has no records.    Oracle is not re-using the extents somehow. Maybe because of defragmentation?

   Do you have any ideas or solutions to these problems

   Thanks in advance,

  ___       ___       ___  ___   ___      | Mark Levinson                  
 /_ /|     /_ /|     /_ /\/_ /| /_ /|     | Lawrence Livermore National Lab 
 | | |     | | |     | \  | | | | | |     | 
 | | |___  | | |___  |  \ | | | | | |___  | Internet:   markl_at_llnl.gov
 | |/__ /| | |/__ /| | \ \| | / | |/__ /| | Fax:        (510) 422-3396
 |_____|/  |_____|/  |_|\___|/  |_____|/  | Voice:      (510) 422-1794


----------------------------------------------------------------------------

                                 _____..---========+^+=========---.._____
    ______________________ __,-='=====____  ================== _____=====`=
   (._____________________I__) - _-=_/    `--------=+=--------'
       /      /__...---===='---+---_'
      '------'---.___ -  _ =   _.-'    "Make it so..."
                     `--------'                - Captain Jean-Luc Picard
                                                 USS Enterprise, NCC-1701D