ESRI SDE Oracle DB - System tables

Oracle SDE tables and SQL queries to find Versions / Session conflicts and GDBM sessions

 Top n versions

select * from (
SELECT v.owner||'.'||v.name "VERSION NAME", COUNT(sl.lineage_id) "LINEAGE LENGTH"
FROM sde.states s, sde.state_lineages sl, sde.versions v
WHERE s.lineage_name = sl.lineage_name
AND sl.lineage_id <= s.state_id
AND v.state_id = s.state_id
GROUP BY v.owner, v.name, sl.lineage_name
ORDER BY "LINEAGE LENGTH") where rownum <= 20;