what is trace file? what is the use of that?
Answers were Sorted based on User's Feedback
Answer / uday
trace file is a log of SQL run in a particular session or
sesesions
focused on selects, inserts, updates, and deletes.
A trace file can be used in many circumstances including
reviewing performance,
finding tables and views referenced, or finding the root of
an error.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / phani kumar
Trace file contains executions steps of a any event.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ram
Trace file will have the complete log of a particular
program based on which we can tune the program.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santhi
The main use of enabling trace for a concurrent program comes during performance tuning.
By examining a trace file, we come to know which query/queries is/are taking longest time to execute.
Is This Answer Correct ? | 1 Yes | 0 No |
what is aim methodolozy
What is request group
PL/SQL stored procedure parameters?
What do you understand by soa?
Can u define DFF with in the DFF,How?
Which is the best website to learn Oracle Apps?
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
what is the use of placeholer column?
for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?
What r the validation done in ap inbound ?