Re: Optimizing table_cache - Open files?
Thanks paul ernest for the reply.
Finally, I have set table_cache value to 600, based on below calculation.
(Connections * N) - where N is max number of join(tables) you perform in your queries. In my case it never cross beyond 6 and max_connections is 100. This gave me total 100*6=600 (which is for table_cache).
I made these changes, and observing how the server affects with this.
Any one correct me pls, if I am wrong
Subject
Views
Written By
Posted
9538
August 04, 2011 05:08AM
3493
August 04, 2011 09:04AM
Re: Optimizing table_cache - Open files?
2009
August 05, 2011 02:28AM
1849
August 05, 2011 07:31AM
1984
August 05, 2011 11:17PM
2170
August 05, 2011 11:37PM
2096
August 06, 2011 07:15AM
1893
August 06, 2011 08:13AM
1781
August 06, 2011 09:02AM
2059
August 10, 2011 08:04PM
1431
August 23, 2011 11:41PM
1754
August 24, 2011 09:21PM
2251
August 25, 2011 01:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.