Cool Windows tools for Oracle

I recently found a cool site that helps with Oracle on Windows.


Try using the pstools suite from sysinternals.
This will show the virtual memory allocated:

C:\> pslist -m oracle

That is what you are up against for a process limit, not the"committed" memory that appears in task manager.

Here is the link to the Pstools download site. Get is as soon as you can.

http://www.sysinternals.com/Utilities/PsTools.html

Enjoy!

Your brother in Christ,
RBT

Oracle Performance Tuning

Oracle performance tuning. What does this really mean?

Most consultants you hire will use the trial and error method for performance tuning.

• Here is a list of ratios, metrics and internal Oracle items.
• Here is something from that list that looks like it may solve your problem.
• Let's try this change and measure the results.
• If it fixes the problem, great. If not repeat.

There has got to be a better answer!

I think that measuring the impact to users as the real outcome, not that the cache hit ratio is now an optimal level.

How do we go about measuring the impact to the user? That is the tricky part. Oracle 9i did not come right out with that measurement. Enter 10g.

Over the next few Blogs, I hope to dive into the inner workings of Oracle 10g R1 and R2. Hopefully we can find what we are looking for.

-RBT