Find a lot of methods are not online, have who can know?

CodePudding user response:

I tried to use Toad this software to track, but the web version of the program opens at operation error

CodePudding user response:

The landlord is going to track the SQL, not very understand the specific needs of the building Lord,

CodePudding user response:

How long is the SQL real-time tracking progress forecast is done?

CodePudding user response:

refer to the second floor lhdz_bj response:

the landlord is going to track the SQL, is not very understand the specific needs of the building Lord,

is the SQL server and SQL server Profiler the same function, I'm going to docking, third-party applications can enter their database and program page, want to know their application page query data is correspond to the background of the table

CodePudding user response:

The

reference 3 floor riven2011 response:

how long is the SQL real-time tracking progress forecast is done?

is not, is the program page of the query data, for example, tracing the query SQL for the background

CodePudding user response:

Well, I see, it is the function of the front desk to run the program, the background to intercept corresponding SQL?
1, can pass the v $session and v $SQL system view associated query;
2, start by tracking, generated in the trace file will have the details of the SQL statement,

CodePudding user response:

refer to 6th floor lhdz_bj response:

well, I see, is the function of the front desk to run the program, the background to intercept corresponding SQL?
1, can pass the v $session and v $SQL system view associated query;
2, start by tracking, generated in the trace file will have the details of the SQL statement,

yes, yes, yes, can you point in detail, I will find out a lot of baidu method couldn't track it,,

CodePudding user response:

Search the oracle SQL trace can be found,

CodePudding user response:

10046 what you need,

CodePudding user response:

refer to the eighth floor lhdz_bj response:

search oracle SQL trace can be found,

ok, thanks a lot

CodePudding user response:

references 9 floor selling fruit net reply:

10046 is exactly what you need,

well, and oracle bar to start with, don't quite understand,,

CodePudding user response:

references 9 floor selling fruit net reply:

10046 is exactly what you need,

System level of 10046, the production of libraries calculate, session level can have a try, research and development testing library doesn't matter.

CodePudding user response:

11 references, broke a sunshine reply:

Quote: selling fruits, 9/f, reference net reply:

10046 what you need,

well, and oracle bar to start with, don't quite understand,,

Search the oracle 10046, slowly to see,

CodePudding user response:

reference 13 floor lhdz_bj reply:

Quote: reference 11 floor broken a sunshine reply:

Quote: selling fruits, 9/f, reference net reply:

10046 what you need,

well, and oracle bar to start with, don't quite understand,,

Search 10046 oracle, slowly see,

good

CodePudding user response:

Refer to this article:
http://blog.itpub.net/29812844/viewspace-1988820/

CodePudding user response:

reference 15 floor freedom and responsibility of reply:

may refer to this article:
http://blog.itpub.net/29812844/viewspace-1988820/

, I couldn't according to this method to track the browser application background SQL query,,

CodePudding user response:

on the 14th floor broken references a sunshine reply:

Quote: refer to the 13th floor lhdz_bj response:

Quote: refer to the 11 floor broken a sunshine reply:

Quote: selling fruits, 9/f, reference net reply:

10046 what you need,

well, and oracle bar to start with, don't quite understand,,

Search oracle 10046, slowly see,

good

, I couldn't according to this method to track the browser application background SQL query,,

CodePudding user response:

10046 it is too difficult for beginners, with v $session directly, v $SQL connections several table to see the background SQL, online a lot of script