| anderl |
Posted: Jan 24, 2007 05:52:28 AM |
Total Post: 7
Joined: Jan, 2007
|
Hallo, i have to increase the perfomance of a 9i databse.
First of all i want to check out the SGA size.
There 90 % inserts on the database and only 10 % data reading.
Thanks for any help |
|
|
 Jayanta |
| Posted: Jan 24, 2007 12:00:10 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
sga is sized by sga_max_size initialization parameter.
u can use show sga command to view sga memory allocations.
regards
jayanta
|
|
|
|
|
| anderl |
| Posted: Jan 25, 2007 04:33:56 AM | |
|
Total Post: 7
Joined: Jan, 2007
|
Hallo jayanta
thank your for your answer, but i think it's a misunderstanding.
I know how to "show sga", i wanted to know how to get the best SGA size for the system i described.
regards
anderl
|
|
|
|
|
| Vigyan |
| Posted: Jan 25, 2007 06:35:47 AM | |
|
Total Post: 386
Joined: May, 2001
|
You can generate AWR report by using awrrpt.sql script from $ORACLE_HOME/rdbms/admin to see how your database is performing. Based on the memory allocation, you can decide if you need more SGA.
Vigyan
|
|
|
|
|
| anderl |
| Posted: Jan 25, 2007 08:19:27 AM | |
|
Total Post: 7
Joined: Jan, 2007
|
Hi Vigyan,
i can't find the awrrpt.sql script in $ORACLE_HOME/rdbms/admin ???
anderl
|
|
|
|
|
| kh |
| Posted: Jan 25, 2007 12:36:47 PM | |
|
Total Post: 3
Joined: Jan, 2007
|
oracle 9i...you can use statspack to get the statistics you need.
1. oracle_home\rdbms\admin\spcreate
2. execute statspack.snap
3. oracle_home\rdbms\admin\spreport
**replace the oracle_home with ur own oracle home.
hope it can help you.
|
|
|
|
|
| anderl |
| Posted: Jan 26, 2007 05:50:37 AM | |
|
Total Post: 7
Joined: Jan, 2007
|
hi kh,
thank you, it works !
anderl
|
|
|
|
|
| Vigyan |
| Posted: Jan 26, 2007 07:01:24 AM | |
|
Total Post: 386
Joined: May, 2001
|
Sorry, I didn't notice 9i. AWR report is available from 10g onward.
For 9i, please use statstpack.
Thanks,
Vigyan
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
