Archive for May, 2007

How to enable auditing in oracle database?

Hi,
Following are steps to enable auditing in oracle database
1) In the initialization parameter file add an entry
audit_trail=db
2) Shutdown the database.
3) startup the database using the init […]

Why one should not use prstat -a command on solaris to find resource consuming process?

Hi,
For e.g If we have 2 databases on a solaris Intel x86 system each with sga 2gb and 1 gb respectively.
Then if we use prstat -a command to determine most CPU Or Memory consuming process we get the following output.
NPROC USERNAME SIZE RSS MEMORY TIME CPU
[…]


Close
E-mail It