我把init中关于回滚段的设直更改了。。。但是。。

显示全部楼层 · 2005-2-28 12:57:00

# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
我把前面的#去掉，但是运行select * from dba_rollback_segs
和以前的结果没有区别呀？！为什么？也都是public的呢？
1
SYSTEM
SYS
SYSTEM
0
1
2
57344
57344
2
505
0
ONLINE
1
2
RBS0
PUBLIC
RBS
1
3
2
524288
524288
8
4096
0
ONLINE
3
3
RBS1
PUBLIC
RBS
2
3
514
524288
524288
8
4096
0
ONLINE
3
4
RBS2
PUBLIC
RBS
3
3
1026
524288
524288
8
4096
0
ONLINE
3
5
RBS3
PUBLIC
RBS
4
3
1538
524288
524288
8
4096
0
ONLINE
3
6
RBS4
PUBLIC
RBS
5
3
2050
524288
524288
8
4096
0
ONLINE
3
7
RBS5
PUBLIC
RBS
6
3
2562
524288
524288
8
4096
0
ONLINE
3
8
RBS6
PUBLIC
RBS
7
3
3074
524288
524288
8
4096
0
ONLINE
3

千问 · 2005-2-28 12:57:00

你本来就只有这几个回滚段
#后面的是默认的要online的
注释与否都会自动启动的
只有自己新增加的回滚段才需要加进去

千问 · 2005-2-28 12:57:00

创建private rollback segment才要指定让其online
最初由 oracledba 发布
[B]# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
我把前面的#去掉，但是运行select * from dba_rollback_segs
和以前的结果没有区别呀？！为什么？也都是public的呢？
1
SYSTEM
SYS
SYSTEM
0
1
2
57344
57344
2
505
0
ONLINE
1
2
RBS0
PUBLIC
RBS
1
3
2
524288
524288
8
4096
0
ONLINE
3
3
RBS1
PUBLIC
RBS
2
3
514
524288
524288
8
4096
0
ONLINE
3
4
RBS2
PUBLIC
RBS
3
3
1026
524288
524288
8
4096
0
ONLINE
3
5
RBS3
PUBLIC
RBS
4
3
1538
524288
524288
8
4096
0
ONLINE
3
6
RBS4
PUBLIC
RBS
5
3
2050
524288
524288
8
4096
0
ONLINE
3
7
RBS5
PUBLIC
RBS
6
3
2562
524288
524288
8
4096
0
ONLINE
3
8
RBS6
PUBLIC
RBS
7
3
3074
524288
524288
8
4096
0
ONLINE
3 [/B]