Re: RollbackSegments

From: Guy ZIMMER <gzimmer_at_pt.lu>
Date: Tue, 21 Aug 2001 12:42:45 +0200
Message-ID: <3b823ae9$1_1@news.vo.lu>

Hello,

The only one settings that I have in the initxxx.ora is : unlimited_rollback_segments=true
Do I need something else ?

Here my completly initxxx.ora :
db_name = PRD

db_files = 100                         # 21.12.2000 debis mre

control_files = (C:\DATABASE\PRD\Ctrl\ctl1PRD.ora, D:\DATABASE\PRD\Ctrl\ctl2PRD.ora, W:\DATABASE\PRD\Ctrl\ctl3PRD.ora)

compatible = 7.3.4.5.0

db_file_multiblock_read_count = 32 # 21.12.2000 debis mre

db_block_buffers = 6400 # 21.12.2000 debis mre: 6400 * 8192 B = 50 MB fuer Datenblöcke in der SGA

shared_pool_size = 157286400 # 21.12.2000 debis mre: 150 MB fuer Library Cache, Data Dictionary Cache und Stored Objects

log_checkpoint_interval = 100000
log_checkpoint_timeout = 1800 # 21.12.2000 debis mre: Alle 30 Minuten ein Checkpoint ist OK!
checkpoint_process = true # 21.12.2000 debis mre: separater Prozess fuer die Durchfuehrung von Checkpoints log_checkpoints_to_alert=yes # 21.12.2000 debis mre: analog zu INITPRD.ORA in Hilden

processes   = 200                      # LARGE

dml_locks   = 1500                     # 21.12.2000 debis mre

log_buffer   = 1048576                 # 21.12.2000 debis mre


sequence_cache_entries = 100           # LARGE

sequence_cache_hash_buckets = 89       # LARGE

max_dump_file_size = 20480

log_archive_start = true                # if you want automatic archiving

log_archive_dest = W:\database\PRD\ArchivLogs log_archive_format = PRD_%t.%s

# define directories to store trace and alert files background_dump_dest=d:\database\PRD\trace user_dump_dest=d:\database\PRD\udump

db_block_size = 8192

snapshot_refresh_processes = 1

remote_login_passwordfile = shared

# open_cursors = 255

open_cursors   = 750                    # 21.12.2000 debis mre: analog zu
INITPRD.ORA in Hilden
enqueue_resources=2048                  # 21.12.2000 debis mre: analog zu
INITPRD.ORA in Hilden
optimizer_mode=choose                   # 21.12.2000 debis mre: analog zu

INITPRD.ORA in Hilden

sort_area_size=393216                   # 21.12.2000 debis mre: analog zu
INITPRD.ORA in Hilden
sort_area_retained_size= 393216         # 21.12.2000 debis mre: analog zu

INITPRD.ORA in Hilden

unlimited_rollback_segments=true        # 21.12.2000 debis mre
utl_file_dir=d:\database\PRD\udump      # 21.12.2000 debis mre

Regards
Guy

"Gerard H. Pille" <ghp_at_skynet.be> schrieb im Newsbeitrag news:3B823884.5CA98960_at_skynet.be...
> Guy ZIMMER wrote:
> >
> > Hi Folks..
> >
> > I have a large phenomenon in my data base
> >
> > While restarting the database the rollback-segments are turned to
offline
> > mode ?
> > I need always to turn it online manualy.
> >
> > I have 8 Segments with 256MB
> > The Tablespaces is 2128MB big (4 files with 532MB)
> >
> > The Database works fine. It was only while restarting the database ...
> >
> > Does someone know the problem?
> >
> > Best Regards
> > Guy ZIMMER
>
> This would be normal if these segments are not specified in init.ora.
> --
>
> Gerard H. Pille
Received on Tue Aug 21 2001 - 05:42:45 CDT