System slow when ......

[N.S. WARGHADE]

Hi all,
I'm using oracle 7.3.4.5 on hp-ux 11.0.
System becomes very while creating tablespace.
Even, bdf, cd command r not working during tablespace creation.
Is there any workaroung to solve this problem?

bye

[T. M. Louah]

..one of the first test I `d run is to sort all the proceses by memory size:
# UNIX95= ps -eo vsz,ruser,args | sort -rn | more
If any of the processes are pushing more than 50 megs, run SAM & change maxdsiz to double or even higher (requires a reboot).

.. HOW TO SET UP UNIX95 do:
# export UNIX95=""

g`d luck
t+-

[Thierry Poels_1]

Hi,

ain't this a little bit normal? Tablespace creation creates a (large) datafile on the server; and is extremely I/O consuming.
Also the autoexend option of oracle datafiles is a performance killer.
Maybe you could schedule tablespace creations and extends at off-peak hours.

regards,
Thierry.

[Bill Hassell]

First, is Oracle 7.3.4.5 actually supported on 11.0?

Also, it is NOT a good idea to set: export UNIX95="" as this environment variable will change the behavior of many other programs and libraries. Use it as shown on the same line as ps and it will not stay set.

As mentioned, table space is a very intense, serial I/O task, so random I/O like bdf or cd or even a login will be delayed. This is caused by the kernel's preference to process all serial requests first, but this sometimes delays other random commands (that look at disk files) for minutes.

If you plan on creating tablespaces all the time (?) or doing other serial-intensive disk reads or writes (such as a backup) during working hours, change the parameter disksort_seconds to 2 or 4 or 8 seconds. Check out this link:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xcb327b8d1de3d5118ff40090279cd0f9,00.html

[harry d brown jr]

NS,

As you can see, oracle is a pig. Have your dba's thought about raw device IO?

live free or die
harry

[Dennis J Robinson]

We need the following information:

System information:

Model:
# of CPU's:
Memory:
I/O cards:
Drive's:

Need to know where the Oracle datafiles live (local disk, EMC, etc).

Need to know how many SCSI and Fibre controllers you have.

Need to know how large dbc_max_pct is.

Creation of tablespaces should not slow an entire system down.

Now if we are talking about an HP workstation with one SCSI controller and tablespace is created on same disk as the system, then yes performance should suffer.

There are still some tuning that can be done to help alleviate this type of problem.