General
cancel
Showing results for 
Search instead for 
Did you mean: 

performance problem after the moving the database on another server hp

dngaya
Advisor

performance problem after the moving the database on another server hp

hello to all,
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.







10 REPLIES
Pete Randall
Outstanding Contributor

Re: performance problem after the moving the database on another server hp

The first thing that jumps out at me is the reduction in memory from 4GB on the old server to 2GB on the new one. Oracle has a reputation for being memory hungry. I would think you would want to have at LEAST 4GB on the new server.


Pete

Pete
Robert-Jan Goossens
Honored Contributor

Re: performance problem after the moving the database on another server hp

Hi dngaya,

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
Geoff Wild
Honored Contributor

Re: performance problem after the moving the database on another server hp

I see you dropped from 4GB to 2GB of ram - that's pretty significant.

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
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
dngaya
Advisor

Re: performance problem after the moving the database on another server hp

hello, by executant order
# 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.


Paula J Frazer-Campbell
Honored Contributor

Re: performance problem after the moving the database on another server hp

Hi

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

If you can spell SysAdmin then you is one - anon
John Carr_2
Honored Contributor

Re: performance problem after the moving the database on another server hp

Hi

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.
A. Clay Stephenson
Acclaimed Contributor

Re: performance problem after the moving the database on another server hp

The best advice I can give you is compare your old 10.20 settings to your 11.0 settings and match them as closely as possible. Since you were running 32-bit code on your 10.20 box, it had to live with memory restrictions so that the reduction in memory MIGHT not be as bad as it would seem.

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.
If it ain't broke, I can fix that.
Steven E. Protter
Exalted Contributor

Re: performance problem after the moving the database on another server hp

A complete kernel analysis is called for.

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: performance problem after the moving the database on another server hp

hi,

think also about the Cost based optimizer and statistics...

can you post a statspack report?

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
dngaya
Advisor

Re: performance problem after the moving the database on another server hp

the optimized_mode is rule in init.ora file.
tomorrow, i will start STATSPACK.