IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Need to have stats of what is happening.
Give me disk layout, types of connections, etc.

Run an "iostat -Mnx 5". Highlight the time frame
of the log roll.

Are you archiving?

Are you using Veritas?

Volume manager?

Database edition?

What type of file systems?

What are your mount options?

New That will take me a bit.
Give me disk layout, types of connections, etc.
Are there commands to run to find this out?

Run an "iostat -Mnx 5". Highlight the time frame of the log roll.
I'll do this tomorrow during more activity.

Are you archiving?
Are you using Veritas?
Volume manager?
What type of file systems?
Are there easy ways to find this out other than asking?

Database edition?
9i

What are your mount options?
read/write/setuid/intr/largefiles/logging/xattr/onerror=lock/dev=154006e

Thanks.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Expand Edited by admin Dec. 12, 2005, 08:36:10 PM EST
New Re: That will take me a bit.
df -a

This will show what disk devices are mounted on what directories.

We need to figure out where your tablespace data files are, and where your logs are, and if you are archiving, where your archivelog destination is. If you have many logs, you might have them placed on different file systems, which in turn might end up round robining the high IO points.

The key issue is to identify points of contention.

You might might be able to tell by querying some data dictionary tables. I can't give you the commands since I don't even have a login to an active Oracle 9i instance to check.

You DBA should be able to just tell you. You should then validate by looking in the dirs they tell yoy about.

Are you duplexing the logs? Again, a dba question.

I might be able to answer some of the other questions based on the output of the df command.

When I say database edition, I mean are you using the Veritas Oracle Accelerator, which is also known as Veritas Volume Manager Database Edition. Sorry for not being more specific.
New Sent you an email.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
New Email had no DB info, was address stuff only
New Was just making sure before I sent it; sent.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
     Oracle tuning question - (admin) - (23)
         Try doing it in JavaScript - (drewk) - (1)
             Attach the table to MS Access? -NT - (ChrisR)
         ln /dev/null /oradata/archive/redolog.log -NT - (boxley)
         Answers - (ben_tilly) - (13)
             Re: Answers - (admin) - (12)
                 I talked to a real DBA - (ben_tilly) - (11)
                     Re: I talked to a real DBA - (admin) - (10)
                         If the data isn't critical, then put it in MySQL. - (ben_tilly) - (9)
                             Ain't gonna happen... - (admin) - (8)
                                 You know that phonograph label? - (drewk) - (7)
                                     The RCA label? "The Masters Voice" -NT - (folkert)
                                     You know what that dog's thinking of, don't you? - (pwhysall) - (1)
                                         I fixed my permissions problem - (drewk)
                                     I'm not too surprised - (admin) - (3)
                                         I had to use that approach once, briefly - (ben_tilly) - (2)
                                             As it turns out... - (admin) - (1)
                                                 I see your point but... - (ben_tilly)
         Need to have stats of what is happening. - (broomberg) - (5)
             That will take me a bit. - (admin) - (4)
                 Re: That will take me a bit. - (broomberg) - (3)
                     Sent you an email. -NT - (admin) - (2)
                         Email had no DB info, was address stuff only -NT - (broomberg) - (1)
                             Was just making sure before I sent it; sent. -NT - (admin)

#include <stdlrpd.h>
260 ms