testing memory parameters

From: <mr..._at_gmail.com>
Date: Sun, 16 Mar 2008 10:45:51 -0700 (PDT)
Message-ID: <62772aa8-fdbd-42b7-a8a0-da91957e30e9@e6g2000prf.googlegroups.com>

I'm trying to test how size of the SGA parameters affects the database's performace.
I'm going to test shared_pool_size, db_cache_size and db_nk_cache_size parameters.
I would like to do it properly because these tests will be part of my master's thesis.
I don't have ability to use real database with real users so I must simulate test workload.
I am running Oracle 10g on linux.
Actually I have written testing program in python using cx_Oracle module.
Program creates several threads, each thread represents one user. Users connects to Oracle and execute some SQL queries. I compare execution time for analyzed parameter's values. I think that I should consider buffer and library cache hit ratios. Is this a good way?

These two ways measures only time and physical reads. What other issues should I examine?
Can you give me some hints how can I do it well?

Thanks for all comments and suggestions.

Adam Received on Sun Mar 16 2008 - 12:45:51 CDT

Original text of this message