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: SQL Query for tuning
Next Topic: delete statement taking long time
Goto Forum:
  


Current Time: Sun Dec 04 02:40:53 CST 2016

Total time taken to generate the page: 0.04114 seconds