Re: Open Table Cache (1024 limit vs. 100 mil. opened tables)
Posted by: Kim Waldorff Østergaard
Date: March 19, 2019 02:14AM

Hi Peter,

Thanks for you reply, and inputs for optimizations.

There are several areas to go at, I will start with Memory RAM settings and SQL-version I think, also from a security perspective.
And then begin doing indexes and query optimizations.

You write that "Opening 54 files/sec, need a bigger table_open cache", how big would you think the tables_open cache should be?


Options: ReplyQuote

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.