Help: have a warrior encountered this kind of situation? In the face of the other fields or all of the fields in Oracle queries are soon, but particularly slow to a field queries, two field type is the same, no such things as index





Two fields are NUMBER type, the length of the precision of 0
There is no index

In code query also is such,

CodePudding user response:

Is quite strange, what wait for event monitoring look down then analysis,

CodePudding user response:

CodePudding user response:

CodePudding user response:

Can be monitored,
Select the sid from v $mystat where rownum<2;
The session id such as a 6399

And then execute the slow SQL,

To open a session monitoring,
The select s.E VENT, s.S QL_ID, a.s ql_text from v $session s, v $sqlarea where sid=6399 and s.S QL_ID=a.s QL_ID;
Look at what is waiting for the event

CodePudding user response:

Event is the SQL * Net message to the client, is not very good, is baidu

CodePudding user response:

Not ah, you monitor the wrong session, to monitor the session more than four seconds, not himself, that sql_text to show that more than 4 seconds of SQL

CodePudding user response:

refer to 6th floor liuzhijian2008x response:

not ah, you monitor the wrong session, to monitor the session more than four seconds, not himself, that sql_text to show that more than 4 seconds of SQL

Just four seconds, see his final check of the event, it could have been run over to check, let him collect better ~ 10046

CodePudding user response:

refer to 7th floor minsic78 response:

Quote: refer to the sixth floor liuzhijian2008x response:

Not ah, you monitor the wrong session, to monitor the session more than four seconds, not himself, that sql_text to show that more than 4 seconds of SQL

Just four seconds, see his final check of the event, it could have been run over to check, let him collect 10046 better ~

You see the output of his sql_text knew is the session that she was running, actually already have what waiting for event monitoring to 4 seconds,
Also can do 10046, but this simple, 10046 he estimates that won't do not see,

CodePudding user response:

Feel wrong, mentally force


Nothing is detected,,,

CodePudding user response:

references 9 f loveyou388i response:

feel wrong, mentally force


Nothing is detected,,,

Do you want to run in 168 that the same session that slow SQL, rather than the other a,