Re: RollbackSegments

add ...
rollback_segments = ( RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8 )

in your initxxx.ora.

• RBS1 ... 8 are the names of the rollback segments.

"Guy ZIMMER" <gzimmer_at_pt.lu> wrote in message news:<3b823ae9$1_1_at_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 - 08:47:25 CDT