topic System slow when ...... in Operating System - HP-UX

System slow when ......

N.S. WARGHADE — Sun, 17 Feb 2002 12:20:42 GMT

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

Re: System slow when ......

T. M. Louah — Sun, 17 Feb 2002 12:55:09 GMT

..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+-

Re: System slow when ......

Thierry Poels_1 — Sun, 17 Feb 2002 13:11:37 GMT

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.

Re: System slow when ......

Bill Hassell — Sun, 17 Feb 2002 18:08:37 GMT

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

Re: System slow when ......

harry d brown jr — Mon, 18 Feb 2002 03:01:00 GMT

NS,

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

live free or die
harry

Re: System slow when ......

Dennis J Robinson — Mon, 18 Feb 2002 16:53:16 GMT

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.