Here is my configuration:
DEC Alpha 4100
- Digital Unix 4.0d patch kit 3
- 4 CPUs 500MHz
- 4 GB RAM
- Swap at 8 GB in overcommit mode
- 300 GB disk (EMC fast-wide in RAID 5 config)
Filesystem
UFS
Using LSM to stripe fs's across 4 controllers
Kernel
maxusers 1024
max-proc-per-user = 2048
max-threads-per-user = 2048
max-per-proc-stack-size = 33554432
max-per-proc-data-size = 3221225472
max-per-proc-address-space = 3221225472
vm-maxvas = 2147483648
ubc-minpercent 30%
My problem:
Creating new oracle tablespaces is incredibly slow. This could be something
set inside oracle, but where else might I look on my side for an I/O
bottleneck? I run iostat and volstat, but don't find the results very
meaningful.
I keep thinking I must be missing something in the kernel, but I don't see
what it is.
Any ideas?
I will summarize. Thanks.
susrod_at_hbsi.com
> -----Original Message-----
> From: Carol Duncan
> Sent: Wednesday, October 06, 1999 7:59 PM
> To: Susan Rodriguez; Karson Cheung
> Cc: Carol Duncan
> Subject: ts status
>
> it took 1hr 8min to create datafiles with total size of 14G for 1
> tablespace
>
> fyi--
> carol
Received on Thu Oct 07 1999 - 15:39:55 NZDT