Home » RDBMS Server » Performance Tuning » What are the keep tables and indexes in Oracle HRMS, Oracle Financials and Oracle Payroll
What are the keep tables and indexes in Oracle HRMS, Oracle Financials and Oracle Payroll [message #272949] Mon, 08 October 2007 06:00 Go to next message
ish_bhatia
Messages: 5
Registered: August 2007
Location: India
Junior Member
Hi,

What are the keep tables and indexes in Oracle HRMS, Oracle Financials and Oracle Payroll which if keep in specific Keep Pool will increase application performance significantly.

Could anybody help me regarding this. I shall be very thanfull.


Thanks & Regards,
Ish
Re: What are the keep tables and indexes in Oracle HRMS, Oracle Financials and Oracle Payroll [message #272961 is a reply to message #272949] Mon, 08 October 2007 06:34 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Your underlying assumption seems to be that such tables exist and for some reason they are not set to use the KEEP pool by default.

Why do you believe this?
Previous Topic: How to make table scan faster
Next Topic: SQL Query for tuning
Goto Forum:
  


Current Time: Wed Aug 23 05:14:06 CDT 2017

Total time taken to generate the page: 0.01848 seconds