Cartesian query in OID logs
I am running OID 11G on Linux server. The following query showed up in the backend DB logs. I am not able to find out the filter that sent generated this DB SQL. When executed, it filled up the temp space in DB and chocked the DB. The only solution was to restart the DB and OID. If any of you have seen this SQL and figured the origin, please let me know.
Product: Oracle Internet Directory 11G on Linux
SELECT /*+ USE_NL(store) INDEX(store EI_ATTRSTORE) INDEX(dn RP_DN) LEADING(dn) */ store.entryid, store.attrname, NVL(store.attrval,' '), NVL(store.attrstype, ' ')
FROM ct_dn dn, ds_attrstore store
WHERE dn.entryid in
((SELECT /*+ INDEX(at1 VA_objectclass) */ at1.entryid
FROM ct_objectclass at1
WHERE ( at1.attrvalue = 'inetorgperson' ) ) ) AND ( dn.parentdn like :bdn ESCAPE '\' OR (dn.rdn = :rdn and
dn.parentdn = :pdn) ) AND dn.entryid = store.entryid AND dn.entryid >= :entryThreshold AND store.attrkind IN ('u','o')
order by store.entryid
One answer
This question does not mention any product from the list: https://jazz.net/products that are discussed here.
- Please retag your question with a product of that list.
- Provide information about the context and the environment you work in
-
If the post is not relevant, comment here and I will get it closed
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 26 '14, 10:18 a.m.I would consider to ask on an Oracle forum or get in contact with their support.
LDAP is only discussed here in the context of the products listed here: https://jazz.net/products
Unless any of these products are involved, I'd consider this off-topic. Even if there was a relationship to these products, this seems to be an issue within Oracle Internet Directory 11G on Linux and not any of the products discussed in this forum.