Performance

Performance

Post by Pons » Thu, 30 Jan 2003 16:07:02



Greetings,

Our Server will be soon in production.
I want to monitor the Oracle DB performance
on AIX5.1 5L ML02, Which tools should I use
to do the above, and is there any recommendation
from Oracle to tune the AIX OS in order to get the
best out of it (from your own experience)?
Any input really appreciated.

-Pons

 
 
 

Performance

Post by Pons » Sun, 02 Feb 2003 18:23:36


.... I know vmstat and iostat are used to monitor
system resources. I want to identify throu them any
(Processor -, Disk-, Memory-, IO-) bottlenecks
Can you tell me how?

-Pons

Quote:

> Our Server will be soon in production.
> I want to monitor the Oracle DB performance
> on AIX5.1 5L ML02, Which tools should I use
> to do the above, and is there any recommendation
> from Oracle to tune the AIX OS in order to get the
> best out of it (from your own experience)?
> Any input really appreciated.


 
 
 

Performance

Post by Nicholas Drone » Sun, 02 Feb 2003 19:57:17


P> .... I know vmstat and iostat are used to monitor
P> system resources. I want to identify throu them any
P> (Processor -, Disk-, Memory-, IO-) bottlenecks
P> Can you tell me how?

That's a tall order to fill.  I suggest you educate
yourself:

        http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae...

Regards,

Nicholas

--
"Why shouldn't I top-post?"    http://www.aglami.com/tpfaq.html
"Meanings are another story."  http://www.ifas.org/wa/glossolalia.html

 
 
 

Performance

Post by Pons » Mon, 03 Feb 2003 14:50:15


">
http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae...
f/112a096c7e01aecf86256a3400622a7a?OpenDocument

I ll check the link.

-Pons

 
 
 

1. X-Performance = Ram ?, report YOUR performance after upgrade.

I run a 486DX4-100mhz, 256kb cache, 8mb ram, 540 mb harddisk 13ms,
with linux...and I would really like to know _how_ strongly preformance
depends on the amount of ram...if it's really worth it to put money on lots
of ram ?
I think primarly on the performance in X-windows...
Or maybe it's better to buy a faster harddisk for those money ?

Please don't post things like "get 36 megs and you'll be happy",
that's not my point anyway...the question is when the increase in performance
is greatest at say an addition of 4 mb..and _how_ big difference it is...
so maybe we could get a neat list of reports for reference for different
machines...then anyone can judge for themselves wether it's worth the
money or not ?

Suppose I upgrade to 12mb, roughly how much faster will X go ?
..or if I uppgrade to 16 mb or 20mb ? is it like the difference
between 8 and 12 is significantly bigger than between 12 and 16 ?

...post what happened to your system!

All of you linux users who have upgraded your ram, you _can_ answer
these questions, please do !

Any reports are velcome, please post it either here or by email to me,
although I'm sure a lot of people would be interested in this...
Please specify your system in any post...

If there is any documents or faq's on this question, please forgive me
..and then maybe someone could give me hint were to find them ?

 /Fredrik

2. Wimbledon AIX -> Linux

3. X graphics performance vs. Windows performance

4. PLEASE PLEASE HELP ME TODAY

5. Vax 11/780 performance vs Sun 4/280 performance

6. Shared Library on Solaris

7. performance tools for analyzing java performance

8. routing and netscape problem

9. Xfree Performance vs. Accelerated-X Performance

10. Ide performance (was RAID0 Performance problems)

11. X graphics performance vs. Windows performance

12. Fwd: [Lse-tech] Block IO write performance (ext2 data) WAS : Ext3 performance bottleneck as the number of spindles gets large

13. Samba vs NT, which gives best PCs / Server Performance?