闂傚倸鍊峰ù鍥Υ閳ь剟鏌涚€n偅宕岄柡宀€鍠栭、娑樷堪閸愮偓姣夋俊鐐€戦崕濠氬箯閿燂拷 (0) +1 闂傚倷娴囧畷鍨叏瀹ュ拋鍚嬮柛鈩冾殢娴硷拷 (0) +1 闂傚倸鍊搁崐鎼併偑鐎涙ḿ顩查柣鎴f缁狀垶鏌ㄩ悤鍌涘 (0) +1
闂傚倸鍊峰ù鍥Υ閳ь剟鏌涚€n偅宕岄柡宀€鍠栭、娑樷堪閸愮偓姣夋俊鐐€戦崕鏌ュ垂閸ф钃熼柣鏃囥€€閸嬫挸鈽夊▍顓т簼閹便劑宕惰閺€鑺ャ亜閺囩偞顥為悗姘炬嫹闂傚倸鍊风粈渚€骞栭銈嗗仏妞ゆ劧绠戠壕鍧楁煕閹邦垼鍤嬮柤鏉挎健閺屾稑鈽夊▎鎰▏缂傚倷璁查弲鐘诲蓟閻旂⒈鏁嶆繝濠傚枤閺嗩厼顪冮妶鍐ㄥ姷闁瑰嚖鎷�>>
0

正在阅读:提高ORACLE数据库的查询统计速度(2)提高ORACLE数据库的查询统计速度(2)

2004-04-01 13:26 出处:搜狐IT 作者:刘亚波 责任编辑:huangpeidan
1. 设置五个回滚段的SQL语句如下:      SELECT SEGMENT_NAME FROM DBA_ROLLBACK_SEGS WHERE INITIAL_EXTENT < 512000 AND   UPPPER(OWNER) = 'PUBLIC';   SELECT UPPER(STATUS) FROM DBA_ROLLBACK_SEGS WHERE UPPER(SEGMENT_NAME) = ''      ALTER ROLLBACK SEGMENT RB1 OFFLINE;   ALTER ROLLBACK SEGMENT RB2 OFFLINE;   ALTER ROLLBACK SEGMENT RB3 OFFLINE;   ALTER ROLLBACK SEGMENT RB4 OFFLINE;   ALTER ROLLBACK SEGMENT RB5 OFFLINE;      DROP ROLLBACK SEGMENT RB1;   DROP ROLLBACK SEGMENT RB2;   DROP ROLLBACK SEGMENT RB3;   DROP ROLLBACK SEGMENT RB4;   DROP ROLLBACK SEGMENT RB5;      CREATE PUBLIC ROLLBACK SEGMENT RB1 TABLESPACE ROLLBACK_DATA    STORAGE (INITIAL 512000 NEXT 512000 MAXEXTENTS 121);   CREATE PUBLIC ROLLBACK SEGMENT RB2 TABLESPACE ROLLBACK_DATA    STORAGE (INITIAL 512000 NEXT 512000 MAXEXTENTS 121);   CREATE PUBLIC ROLLBACK SEGMENT RB3 TABLESPACE ROLLBACK_DATA    STORAGE (INITIAL 512000 NEXT 512000 MAXEXTENTS 121);   CREATE PUBLIC ROLLBACK SEGMENT RB4 TABLESPACE ROLLBACK_DATA    STORAGE (INITIAL 512000 NEXT 512000 MAXEXTENTS 121);   CREATE PUBLIC ROLLBACK SEGMENT RB5 TABLESPACE ROLLBACK_DATA    STORAGE (INITIAL 512000 NEXT 512000 MAXEXTENTS 121);      ALTER ROLLBACK SEGMENT RB1 ONLINE;   ALTER ROLLBACK SEGMENT RB2 ONLINE;   ALTER ROLLBACK SEGMENT RB3 ONLINE;   ALTER ROLLBACK SEGMENT RB4 ONLINE;   ALTER ROLLBACK SEGMENT RB5 ONLINE;      COMMIT;
键盘也能翻页,试试“← →”键

关注我们

最新资讯离线随时看 聊天吐槽赢奖品
闂傚倸鍊风粈浣虹礊婵犲倴缂氱憸鏃堛€侀弽顓炲耿婵$偟绮弫鐘绘⒑闁偛鑻晶鎾煙椤旀娼愰柟宄版嚇瀹曘劍绻濋崒娆愭▕濠电姷顣藉Σ鍛村磻閹捐绠柨鐕傛嫹闂傚倸鍊烽悞锕傚箖閸洖纾块柟鎯版绾剧粯绻涢幋娆忕仼闁哄嫨鍎甸幃姗€鎮欓弶鍨彑婵炲瓨绮嶇划鎾诲蓟濞戙埄鏁冮柨婵嗘椤︺儵姊洪崨濠冾棖闁瑰嚖鎷�