- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: performance problem after the moving the data...
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
тАО12-15-2003 12:40 AM
тАО12-15-2003 12:40 AM
performance problem after the moving the database on another server hp
I come from to move my database of data oracle 8.0.5 of
a old HP 10.20 towards another new HP 11.0. on the level of the parameters will init.ora, I did only change size of db_block_size
where I passed from 2k to 8k. on the level operating system,
the old system HP with a bay of disc scsi to 40 mb/s, 4Go of memory
and 2X552 megahertz of processor on the other hand, the new server with
a bay of disc fiber channel to 1000 mb/s with
2X650 megahertz of processor and 2Go of memory. when the database was on the old system,
the execution of my batch made 1/4 hour ,now on the new system, the batch lasts 5 hours .what can explain that?.
how can I make to diagnose the problem?.
thank you for your assistance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 12:43 AM
тАО12-15-2003 12:43 AM
Re: performance problem after the moving the database on another server hp
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 12:47 AM
тАО12-15-2003 12:47 AM
Re: performance problem after the moving the database on another server hp
Could you check next command to determine the filesystem blocksize ?
# echo "8192B.p S" | fsdb -F vxfs /dev/vgXX/rlvolX
Change X to your VG and LV
Please return the bsize value.
Regards,
Robert-Jan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 12:50 AM
тАО12-15-2003 12:50 AM
Re: performance problem after the moving the database on another server hp
What's dbc_max_pct set to? If default, (50%), then try dropping to 10% - that will free up ram for Oracle.
Here's some other parameters that I use:
MAXFILES 2048 Soft limit on how many files a single process can have opened or locked at any given time.
NFILE 4096 Maximum number of files that can be open simultaneously on the system at any given time.
NINODE 20000 Maximum number of open inodes that can be in memory.
MSGSEG 4096 Maximum number of message segments that can exist on the system.
NPROC 1024 Defines the maximum number of processes that can be running simultaneously on the entire system, including remote execution processes initiated by other systems via remsh or other networking commands.
SHMMAX 1073741824 Maximum allowable shared memory segment size (in bytes).
SHMMNI 100 Maximum number of shared memory segments allowed on the system at any given time.
SEMMNS 500 Maximum number of individual IPC semaphores available to system users, system-wide.
SHMSEG 10 Maximum number of shared memory segments that can be attached simultaneously to any given process.
DBC_MAX_PCT 10 Maximum percentage of memory for dynamic buffer cache
NPTY 256 Pseudo terminals
NSTRPTY 256 Max Number of Streams-Based PTYs
Check your sar data - see if there is I/O waits...and how busy the cpu is during your batch job...
How are the disks laid out on the Storage Array? For Oracle, they should be striped as wide as possible and mirrored.
Rgds...Geoff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 01:22 AM
тАО12-15-2003 01:22 AM
Re: performance problem after the moving the database on another server hp
# echo "8192B.p S"|fsdb - F vxfs /dev/vg***** de Robert-jan,
I obtain the following result: 8192.
here my parameters system:
dbc_max_pct=50%
maxfiles=200
nfile=10000
ninode=1660
nproc=980
shmmax=734/003/200
shmmni=200
semmns=2000
shmeg=120
dbc_max_pct=50%
npty=256
nstrpty=256
this the result for sar -d:
/home/dbaora8/ora/network/log >> sar -d 5 10
HP-UX djerba B.11.00 U 9000/800 12/15/03
15:20:22 device %busy avque r+w/s blks/s avwait avserv
15:20:27 c1t15d0 1.39 0.50 4 15 4.62 3.71
c6t0d1 4.38 0.64 29 544 5.85 3.62
15:20:32 c1t15d0 0.40 0.50 1 11 1.50 8.50
c6t0d1 30.40 1.04 110 1953 6.64 8.03
15:20:37 c1t15d0 0.20 0.50 1 3 0.15 8.45
c6t0d1 2.00 0.50 7 120 1.93 3.64
15:20:42 c6t0d1 0.80 0.50 5 83 1.91 2.28
15:20:47 c6t0d1 0.20 0.50 4 71 1.24 1.72
15:20:52 c1t15d0 0.40 0.50 1 4 0.14 9.18
c6t0d1 0.40 0.50 5 86 1.02 1.32
15:20:57
15:21:02 c1t15d0 0.20 0.50 1 8 2.01 6.92
15:21:07 c1t15d0 0.40 0.50 2 7 0.14 9.34
c6t0d1 2.80 0.50 8 132 3.51 3.86
15:21:12 c1t15d0 0.40 0.50 1 4 0.16 9.84
c6t0d1 5.01 1.26 32 681 6.64 6.74
Average c1t15d0 0.34 0.50 1 5 2.20 6.84
Average c6t0d1 4.60 0.94 20 367 5.84 6.40
thank for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 03:10 AM
тАО12-15-2003 03:10 AM
Re: performance problem after the moving the database on another server hp
Your dbc_max_pct=50% is too high, I would set at 20% (aim for circa 400 mbyte) and dbc_min_pct 4% (aim for approx 80mbyte).
Paula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 03:17 AM
тАО12-15-2003 03:17 AM
Re: performance problem after the moving the database on another server hp
if you change the dbc_max_pct you will need to rebuild the kernel and reboot.default is 50 as already stated and minimum is 2 max 90.
John.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 03:30 AM
тАО12-15-2003 03:30 AM
Re: performance problem after the moving the database on another server hp
If this is 64-bit Oracle then it definitely likes to have bigger SGA's than the 32-bit versions. In almost all cases, databases are I/O and memory bound long before they are CPU bound so that you might actually find that you are better off running 11.0 on the old box.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 04:24 AM
тАО12-15-2003 04:24 AM
Re: performance problem after the moving the database on another server hp
A memory purchase is also recommended here.
If your system is 64 bit and you installed 64 bit oracle you must do a word size conversion on the database to obtain reliable operation on the new platform.
I'm attaching a performance data collection script that you should run while your batch job is running. It will help you spot areas of adjustment that you will want to attend to.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-15-2003 04:36 AM
тАО12-15-2003 04:36 AM
Re: performance problem after the moving the database on another server hp
think also about the Cost based optimizer and statistics...
can you post a statspack report?
regards
Yogeeraj