Hi,
I came across one interview question.
The interviewer asked me why do SQL query run slow first time. Explain in detail.
From what I know its because of CACHING.
Any suggestions?
ta
Arvin
Search found 195 matches
- Sun Jul 17, 2011 8:43 pm
- Forum: Oracle Forms & Reports
- Topic: Why do SQL query run slow first time?
- Replies: 0
- Views: 4530
- Tue Nov 16, 2010 11:37 pm
- Forum: Application DBA & System Administration
- Topic: versions of EBS
- Replies: 0
- Views: 3441
versions of EBS
Hi
Can anyone please tell me what are all versions in R12
is 12.1.1 latest?
cheers,
Arvin
Can anyone please tell me what are all versions in R12
is 12.1.1 latest?
cheers,
Arvin
- Thu Oct 21, 2010 8:34 pm
- Forum: General / Others
- Topic: middleware and web servies
- Replies: 0
- Views: 3900
middleware and web servies
hi,
Can anyone please explain me the difference between oracle middleware and web services?
ta
Arvin
Can anyone please explain me the difference between oracle middleware and web services?
ta
Arvin
- Wed Oct 13, 2010 12:49 am
- Forum: General / Others
- Topic: weblogic and oracle apps
- Replies: 0
- Views: 3557
weblogic and oracle apps
hi
I am bit confused on the difference between Weblogic and Oracle Apps..?
Can anyone please tell me what is the role of Weblogic and Oracle Apps (eg 11.5.10.2)..
when both are deployed..
ta
Arvin
I am bit confused on the difference between Weblogic and Oracle Apps..?
Can anyone please tell me what is the role of Weblogic and Oracle Apps (eg 11.5.10.2)..
when both are deployed..
ta
Arvin
- Wed Oct 13, 2010 12:37 am
- Forum: Operating System
- Topic: Sun Sparc Question
- Replies: 1
- Views: 4347
Sun Sparc Question
Can anyone please tell me the name of widely used Sun Sparc machines on which oracle application is installed?
thanks
ta
Arvin
thanks
ta
Arvin
- Thu Oct 07, 2010 11:48 pm
- Forum: Oracle Databases
- Topic: cursor question help needed
- Replies: 0
- Views: 4701
cursor question help needed
Which line in the following statement will produce an error?
cursor action_cursor is
select name, rate, action
into action_record
from action_table;
There are no errors in this statement.
cursor action_cursor is
select name, rate, action
into action_record
from action_table;
There are no errors in this statement.
- Fri Aug 13, 2010 11:52 pm
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Derivatives (bonds and swaps)
- Replies: 4
- Views: 2067
Derivatives (bonds and swaps)
Hi
Can anyone please explain me in simple words what does Bonds and Swaps means?
and how does we implement it in Oracle ERP?
ta
Arvin
Can anyone please explain me in simple words what does Bonds and Swaps means?
and how does we implement it in Oracle ERP?
ta
Arvin
- Mon Jul 26, 2010 10:07 am
- Forum: Oracle Forms & Reports
- Topic: scalar, reference, composite, and large object (LO
- Replies: 0
- Views: 4901
scalar, reference, composite, and large object (LO
hi
Can anyone please give me example of
scalar, reference, composite, and large object (LOB) data types
ta,
Arvin
Can anyone please give me example of
scalar, reference, composite, and large object (LOB) data types
ta,
Arvin
- Tue Apr 27, 2010 10:25 am
- Forum: HCM (Human Capital Management)
- Topic: What is Element?
- Replies: 1
- Views: 1709
What is Element?
Hi,
Can anyone explain me what is the purpose of Element in Payroll? and where else it is used?
thanks in advance
ta
Arvin
Can anyone explain me what is the purpose of Element in Payroll? and where else it is used?
thanks in advance
ta
Arvin
- Sun Apr 11, 2010 9:43 am
- Forum: HCM (Human Capital Management)
- Topic: diff between oracle HRMS and peoplesoft HRMS
- Replies: 0
- Views: 1760
diff between oracle HRMS and peoplesoft HRMS
Hi,
What is the difference between oracle HRMS and peoplesoft HRMS?
ta
Arvin
What is the difference between oracle HRMS and peoplesoft HRMS?
ta
Arvin
- Sun Apr 11, 2010 9:34 am
- Forum: HCM (Human Capital Management)
- Topic: Oracle HRMS in Budgeting and Costing?
- Replies: 1
- Views: 2202
Oracle HRMS in Budgeting and Costing?
hi,
How does Oracle HRMS helps in Budgeting and Costing?
ta
Arvin
How does Oracle HRMS helps in Budgeting and Costing?
ta
Arvin
- Sun Apr 11, 2010 9:30 am
- Forum: HCM (Human Capital Management)
- Topic: Standard Benefits, Advanced Benefits, CWB
- Replies: 0
- Views: 1418
Standard Benefits, Advanced Benefits, CWB
Hi,
Can anyone please explain me the purpose of
Standard Benefits
Advanced Benefits and
Compensation Workbench
in HRMS suite?
ta
Arvin
Can anyone please explain me the purpose of
Standard Benefits
Advanced Benefits and
Compensation Workbench
in HRMS suite?
ta
Arvin
- Sun Apr 11, 2010 7:39 am
- Forum: HCM (Human Capital Management)
- Topic: call pl/sql package function from FastFormula
- Replies: 1
- Views: 1775
call pl/sql package function from FastFormula
Hi,
How to call pl/sql package functions from within a Fast Formula?
ta
Arvin
How to call pl/sql package functions from within a Fast Formula?
ta
Arvin
- Sun Apr 11, 2010 7:32 am
- Forum: HCM (Human Capital Management)
- Topic: Difference between EIT and SIT
- Replies: 3
- Views: 3341
Difference between EIT and SIT
Hi
What is the difference between EIT and SIT?
ta
Arvin
What is the difference between EIT and SIT?
ta
Arvin
- Wed Apr 07, 2010 7:56 am
- Forum: HCM (Human Capital Management)
- Topic: Fastformula to prepare records format for tape wri
- Replies: 3
- Views: 2081