Please comments This Tablespace Setup
From: Johnson <syner_at_pd.jaring.my>
Date: 2000/07/19
Message-ID: <8l3o2p$bg2$1_at_news5.jaring.my>#1/1
Date: 2000/07/19
Message-ID: <8l3o2p$bg2$1_at_news5.jaring.my>#1/1
[Quoted] Hello DBA,
Please comment on this tablespace (Mydata) setup, running in NT, with db_block_size = 8k. Do I need to fine tuning or rezise it? Since I put the autoextent = ON.
[Quoted] Tablespace storage statistic
-Total block : 284160
-Used Block : 283526
-Free : 634
[Quoted] This tablespace is having 5 datafiles :
- Data1 - 75520 Blocks
- Data2 - 20480 Blocks
- Data3 - 12800 Blocks
- Data4 - 12800 Blocks
- Data5 - 162560 Blocks
The default storage
- Initial - 40960
- next - 40960
- Min Ext - 1
- Max Ext - 505
- Pct increase - 50
Thanks for you comment. Received on Wed Jul 19 2000 - 00:00:00 CEST