Discussion Locked

Oracle tuning: Monitoring hardware with UNIX tools

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

6 replies

by cachifox

Hi....

Read some important information about oracle, however, I found out that Oracle is just for UNIX tools, my question is it possible that, how about if my PC or my Monitoring hardware is not UNIX or what so ever. Could you please give me someother information about it. Thanks.

by rajugeor

Hi
I am Rajesh George and Working as a DBS in a multinational company, Bombay, India.
As you asked the Oracel id not only for Unix. There are versions for NT Server also. If you are asking the specific tools you want to monitor, or do the work, there are. But just tell me your resources and configuration of the server as well as your pc.

Regards
Rajesh George

by rajugeor

Hi
I am Rajesh George and Working as a DBS in a multinational company, Bombay, India.
As you asked the Oracel id not only for Unix. There are versions for NT Server also. If you are asking the specific tools you want to monitor, or do the work, there are. But just tell me your resources and configuration of the server as well as your pc.

Regards
Rajesh George

by shanghai sam

Is it possible that other rdbms might run on unix too? Is vmstat only available on unix boxes running Oracle? Although they hold over 60% of market share, Oracle still has a ways to go to be considered the ONLY dbms. Ok so we're migrating 1 application off Sybase to another DB - but it's still not Oracle and I've heard there are even current Oracle customers dropping their Oracle 'instances' for the up & coming SQL Server 2000. But if I didn't know better I would think that we must have theLAST SYBASE server on this planet... Give those of us not using Oracle, (and doing just fine...) a small morsel of information. After reading this article, I could be misled into thinking that only Oracle runs on only unix and unix is only made for running Oracle - so please, at least take 1 sentence to say: vmstat can be used to monitor hardware, (unix) regardless which database platform you use. If you say that then you should include that vmstat will work on unix even if you're not running any rdbms at all. This article belongs on 'Oracle Republic'. Besides I prefer 'glance', 'top' & 'sar'

by Member 35314497

I disagree that the page-in rate is an indication of a memory bottleneck. At least it is not an indicator of such across all unix platforms. In particular, HP-UX is a demand page loaded system. That means that as code pages are required, they arepaged in. Page-in is a normal part of the kernel's function. However, when memory is tight and more is demanded, some memory is paged out. This is the initial warning sign of a possible memory bottleneck. This activity may only appear when an applicaiton first starts and eventually stop. This is normal operation too. However, if the page-out rate remains greater than 0 for a sustained time, then you have a memory bottleneck.

This discussion is closed to new replies.