Hi all,
I have question below here .. (Solaris 7 Oracle 8.1.6)
I startup my database with this parameter
db_name = "MyDB"
instance_name = MyDB
service_names = MyDB
control_files = ("/export/home/basic/MyDB/ctl/control01.ctl",
"/export/home/basic/MyDB/ctl/control02.ctl",
"/export/home/basic/MyDB/ctl/control03.ctl")
open_cursors = 100
max_enabled_roles = 30
db_block_buffers = 9280
shared_pool_size = 12670976
large_pool_size = 614400
java_pool_size = 0
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 50
log_buffer = 163840
background_dump_dest = /export/home/basic/MyDB/dump/bdump
core_dump_dest = /export/home/basic/MyDB/dump/cdump
user_dump_dest = /export/home/basic/MyDB/dump/udump
db_block_size = 4096
remote_login_passwordfile = none
os_authent_prefix = ""
compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536
SQL> select name from v$rollname;
NAME
-------------------------------
SYSTEM
RBS0
RBS1
RBS2
Where are these RBS* rollback segments come from ?
Because I am not include the
ROLLBACK_SEGMENTS = ( RBS0, RBS1, RBS2 )
parameters
Thank you,
Regards
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
