- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- System slow when ......
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-17-2002 04:20 AM
тАО02-17-2002 04:20 AM
System slow when ......
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-17-2002 04:55 AM
тАО02-17-2002 04:55 AM
Re: System slow when ......
# 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+-
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-17-2002 05:11 AM
тАО02-17-2002 05:11 AM
Re: System slow when ......
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-17-2002 10:08 AM
тАО02-17-2002 10:08 AM
Re: System slow when ......
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
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-17-2002 07:01 PM
тАО02-17-2002 07:01 PM
Re: System slow when ......
As you can see, oracle is a pig. Have your dba's thought about raw device IO?
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-18-2002 08:53 AM
тАО02-18-2002 08:53 AM
Re: System slow when ......
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.