| increase Cache size [message #385551] |
Tue, 10 February 2009 02:18  |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
Hi all,
I want to check the check size to my database and I want to increase the cache size to my database.
What is the procedure to implement the above case?
Please suggest.
|
|
|
|
|
|
| Re: increase Cache size [message #385568 is a reply to message #385551] |
Tue, 10 February 2009 02:44  |
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
|
Senior Member |
|
|
In our project we are connecting to database from application(java). I am not able to connect to database through application but i am able to connect to database through linux.
This is production database and transactions are going on.
They send the report like this.
CLASS COUNT TIME
--------------- ---------- ----------
data block 1109836 2423958
sort block 0 0
save undo block 0 0
segment header 3 1
save undo header 0 0
free list 0 0
extent map 0 0
1st level bmb 6 14
2nd level bmb 0 0
3rd level bmb 0 0
bitmap block 0 0
bitmap index block 0 0
file header block 0 0
unused 0 0
system undo header 0 0
system undo block 0 0
undo header 11 18
undo block 2637 1195
I am not finding anything what is the problem exactly?
How should I find the problem and How should I rectify?
So I thought If I increase cache size I/O reads are more.It will improve the performance.
Please help?
[code formatted]
[Updated on: Tue, 10 February 2009 04:16] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: increase Cache size [message #385605 is a reply to message #385568] |
Tue, 10 February 2009 04:18 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
What is this report from?
In your shoes, I'd run a Statspack report for a couple of 5 minute intervals while the application is in use, and have a look at that.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
