General discussion

Locked

Oracle tuning: Monitoring hardware with UNIX tools

By cachifox ·

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Questions

by cachifox In reply to Oracle tuning: Monitoring ...

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.

Collapse -

From Rajesh George

by rajugeor In reply to Questions

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

Collapse -

From Rajesh George

by rajugeor In reply to Questions

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

Collapse -

Event Tuning

by Shanghai Sam In reply to Questions
Collapse -

Sybase Tuning: Monitor Hardware with ?

by Shanghai Sam In reply to Questions

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'

Collapse -

Memory Bottleneck

by Pete@Bobcat In reply to Oracle tuning: Monitoring ...

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.

Back to IT Employment Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums