on 06-11-2013 10:06 PM
Hi All,
Has anybody faced this situation - we are using MDO table in our application and found behind the scene it is firing lot's of "Select count(*) from MDO*****". This count(*) query not used in the application. DBA found it( which SQL query has been executed so far) using SQLPLUS. Is there anything inside the MDO code which implicitly call the count(*) query ?
Anyone experienced anything like this ever?
Thanks!
Prahlad
Hi Prahlad,
The select count(*) statement is executed internally by the MDO objects when ever they are loaded, copied or any operation is done on/in them. These logs are also visible in the Open SQL monitor screen in NWA.
Which MII version are you on? If you are 14.0 SP1 or above, these calls have been minimized to a great extent.
Regards,
Tufale Ashai.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.