How can you enable a trace for a session?

Answer Posted / anji

to enable the trace in anther session

EXECUTE dbms_support.start_trace_in_session (sid,serial#);

To stop the trace in anther session

EXECUTE dbms_support.start_trace_in_session (sid,serial#);

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16356


What is the difference between oracle media recovery and crash recovery?

671


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1610


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1646


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

1795






PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1700


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

712


i want to know about the javaBean.what is its purpose and how it can use in Forms.

1833


Explain prerequisites and post activities of oracle database installation

1616


Explain about party and customer in ar : oracle accounts receivable

724


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1843


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1839


What is supporting issues GL AP and AR?

1985


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

646


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

668