×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Automatically setting Rollback segments online...

Automatically setting Rollback segments online...

Automatically setting Rollback segments online...

(OP)
I know this is probably a simple thing.   I installed Oracle 7.3.4 on an NT Server selecting all of the defaults.   It automatically creates a lot of tiny rollback segments and put them online.   The application I installed required larger segments, so I created a couple of larger rollback segments and deleted the default smaller segments.   These work great for the application, but when the machine gets its weekly reboot, those new segments default to offline.   

Using Oracle OEM, how do I set those segments to automatically go online?

Thanks in advance...

Terry M. Hoey
th3856@txmail.sbc.com

RE: Automatically setting Rollback segments online...

(OP)
Mike,

First of all, thanks for your reply to my rollback question.   I have copied my init.ora file below.   I don't see the line you mentioned, so I will add it in at the end.   Is that a good spot for it?   

Also, I am pretty new at installing Oracle.   How do I know if the other settings in this file are set right for my database?   I know that is a very broad question and you may not have the time to answer it.   Maybe you could point me towards a book or web page that might enlighten me.

Thanks again...


#
# $Header: init.ora 1.2 94/10/18 16:12:36 gdudey Osd<desktop/netware> $ init.ora Copyr (c) 1991 Oracle
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site.  Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE.  Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
#                     -------Installation/Database Size------
#                      SMALL           MEDIUM           LARGE
#  Block         2K    4500K            6800K           17000K
#  Size          4K    5500K            8800K           21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances.  This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own.  Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
###############################################################################

db_name = oracle
db_files = 20
control_files = (D:\ORANT\DATABASE\ctl1orcl.ora, D:\ORANT\DATABASE\ctl2orcl.ora)

compatible = 7.3.0.0.0

db_file_multiblock_read_count =  8 # INITIAL
# db_file_multiblock_read_count = 8                                   # SMALL
# db_file_multiblock_read_count = 16                                  # MEDIUM
# db_file_multiblock_read_count = 32                                  # LARGE

db_block_buffers =  200                           # INITIAL
# db_block_buffers = 200                                              # SMALL
# db_block_buffers = 550                                              # MEDIUM
# db_block_buffers = 3200                                             # LARGE

shared_pool_size =  6500000                           # INITIAL
# shared_pool_size = 3500000                                          # SMALL
# shared_pool_size = 6000000                                          # MEDIUM
# shared_pool_size = 9000000                                          # LARGE

log_checkpoint_interval = 10000

processes =  50                                         # INITIAL
# processes = 50                                                      # SMALL
# processes = 100                                                     # MEDIUM
# processes = 200                                                     # LARGE

dml_locks =  100                                         # INITIAL
# dml_locks = 100                                                     # SMALL
# dml_locks = 200                                                     # MEDIUM
# dml_locks = 500                                                     # LARGE

log_buffer =  8192                                       # INITIAL
# log_buffer = 8192                                                   # SMALL
# log_buffer = 32768                                                  # MEDIUM
# log_buffer = 163840                                                 # LARGE

sequence_cache_entries =  10               # INITIAL
# sequence_cache_entries = 10                                         # SMALL
# sequence_cache_entries = 30                                         # MEDIUM
# sequence_cache_entries = 100                                        # LARGE

sequence_cache_hash_buckets =  10     # INITIAL
# sequence_cache_hash_buckets = 10                                    # SMALL
# sequence_cache_hash_buckets = 23                                    # MEDIUM
# sequence_cache_hash_buckets = 89                                    # LARGE

# audit_trail = true            # if you want auditing
# timed_statistics = true       # if you want timed statistics
max_dump_file_size = 10240      # limit trace file size to 5 Meg each

# log_archive_start = true      # if you want automatic archiving

# define directories to store trace and alert files
background_dump_dest=%RDBMS73%\trace
user_dump_dest=%RDBMS73%\trace

db_block_size = 2048

snapshot_refresh_processes = 1

remote_login_passwordfile = shared

text_enable = true
unlimited_rollback_segments = true


Terry M. Hoey
th3856@txmail.sbc.com

RE: Automatically setting Rollback segments online...

Try adding a line similar to the following to your initialization file:

ROLLBACK_SEGMENTS=(R1,R2,R3,R4,R5,R6,R7,R8,R9,R10,R11,R12,R13,R14,R15)

The rollback segments in the list will automatically be brought online at instance startup.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close