Re: Help with Win 2000 SGA and Performance Tuning

You need to look at :-

    the alert log to see how many times its switching its redo logs (how big and how many are they ?)

        select * from v$log;
        select * from v$logfile;

    the SQL that is being run by the vb app. Pick out the SQL from the application

    and explain plan/ trace it. When the app is running, look at v$session_wait and v$sess_io

    to see what the session is waiting on. Is the application using bind variables (:variable etc)

    How big are the tables involved? What indexes do they have?     Any foreign key constraints? Have the tables been analyzed?     What mode is the optimizer in?

    What version of Oracle?

    How much data is getting inserted? Large picture files (sizes)? What datatypes you using?

Alun

"Chuck" <ccarson_at_syrrx.com> wrote in message news:3CEE78B1.2070301_at_syrrx.com...
>
> We have a Compaq cluster (each node is 3x cpu and 8 gig RAM). I am the
> Unix guy and am no expert on Windows but have 3yrs as an Oracle DBA on
> Solaris and Linux. They are having performance problems with a VB
> application that updates a single column of a table which in turn fires
> three triggers that insert/update three other tables.
>
> The cpu's never get taxed, staying at about 15% util. Oracle's mem usage
> is stuck at 1.6 gig. The systems has a total of 6x4 gig pagefiles, 4 of
> which are on the same disk! (this was a brain stumper for me)
>
> I guess my questions are, what is the max memory usage for Oracle on
> this kind of config? Also, it makes sense to me that one 4 gig pagefile
> would be faster than thrashing accross 4 on the same disk? Also, it
> makes sense to me that a properly configured system/database/application
> should never use swap at all (is this far fetched)? The disk subsystem
> is hardware RAID 5 (I know another performance hit) split into 4 raid
> paritions. I am pretty sure that the datafiles being on Raid 5 is not
> the bottleneck in this case (although it should be which is why
> something else is defintely not right)
>
> Lastly, I noticed a large number of page faults for ALL processes
> runninig on the system, not just Oracle.
>
> The system is not doing a very large number of transactions it is taking
> data from two large robots that take pictures of biotech experiments
> (small 96 well trays), at most, it make get 2 requests per 2 seconds.
>
> Can anyone give this Unix guy some Oracle on Windows pointers?
>
> Thanks,
> Chuck
>
>
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Sun May 26 2002 - 05:34:50 CDT