Home » RDBMS Server » Performance Tuning » increase Cache size (10g)
increase Cache size [message #385551] Tue, 10 February 2009 02:18 Go to next message
grpatwari
Messages: 257
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 #385557 is a reply to message #385551] Tue, 10 February 2009 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to increase the cache size to my database.

Why?

Regards
Michel
Re: increase Cache size [message #385568 is a reply to message #385551] Tue, 10 February 2009 02:44 Go to previous messageGo to next message
grpatwari
Messages: 257
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 #385580 is a reply to message #385568] Tue, 10 February 2009 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
They send the report like this.

Do you think what you posted is readable in any way?

Regards
Michel
Re: increase Cache size [message #385605 is a reply to message #385568] Tue, 10 February 2009 04:18 Go to previous message
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.
Previous Topic: slowness
Next Topic: Using Index hint (merged)
Goto Forum:
  


Current Time: Sun Dec 04 00:42:51 CST 2016

Total time taken to generate the page: 0.08351 seconds