128 pages found, pages 1 to 10
http://oracledba.ru/fv8i/gv$sort_usage.html    Similar Pages
... BLOCKS NUMBER ktssorfno -- SEGRFNO# NUMBER from x$ktsso, v$session where ktssoses = v$session.saddr and ... 8i / www.oracledba.ru GV$SORT_USAGE select x$ktsso.inst_id, -- INST_ID NUMBER username, -- USER ...
http://www.perfvision.com/sql/ash/sortinfo.txt    Similar Pages
... ktssorfno -- SEGRFNO# NUMBER from x$ktsso, v$session where ktssoses = v$session.saddr and ... ktssorfno -- SEGRFNO# NUMBER from x$ktsso, v$session where ktssoses = v$session.saddr and ... direct path reads are found GV$SORT_USAGE select x$ktsso.inst_id, -- INST_ID NUMBER username ...
http://comments.gmane.org/gmane.comp.db.oracle.general/28551    Similar Pages
... of first. v$sort_usage sits on top of x$ktsso - and in x$ktsso the column ktssoobjn is the object number ... of first. v$sort_usage sits on top of x$ktsso - and in x$ktsso the column ktssoobjn is the object number ...          1 And large values for ktssoobjn in x$ktsso:   KTSSOBNO  KTSSOEXTS  KTSSOBLKS  KTSSORFNO  KTSSOOBJD ...
http://comments.gmane.org/gmane.comp.db.oracle.general/28553    Similar Pages
... of first. v$sort_usage sits on top of x$ktsso - and in x$ktsso the column ktssoobjn is the object number ... Koehler who's pointed out that Oracle enhanced x$ktsso in 11.2.0.3 to include the SQL_ID (column ktssosqlid) ...          1 And large values for ktssoobjn in x$ktsso:   KTSSOBNO  KTSSOEXTS  KTSSOBLKS  KTSSORFNO  KTSSOOBJD ...
http://permalink.gmane.org/gmane.comp.db.oracle.general/28553    Similar Pages
... of first. v$sort_usage sits on top of x$ktsso - and in x$ktsso the column ktssoobjn is the object number ... Koehler who's pointed out that Oracle enhanced x$ktsso in 11.2.0.3 to include the SQL_ID (column ktssosqlid) ...          1 And large values for ktssoobjn in x$ktsso:   KTSSOBNO  KTSSOEXTS  KTSSOBLKS  KTSSORFNO  KTSSOOBJD ...
http://sites.google.com/site/vadasovi/icon_holders-1/v_parameterviewplanwitherrors.txt?attredirects%3D0%26d%3D1    Similar Pages
... FIXED TABLE FULL | X$KTSSO | 1 | 29 | 0 (0)| 00:00:01 | |* 10 | FIXED TABLE FULL | X$KSPPCV | 75 | 1350 ... 9 - SEL$D0431F08 / X$KTSSO@SEL$7 10 - SEL$D0431F08 / Y@SEL$15 11 - SEL$D0431F08 / X@SEL$15 12 - SEL$D0431F08 ... 431F08" "X"@"SEL$15") USE_NL(@"SEL$D0431F08" "Y"@"SEL$15") LEADING(@"SEL$D0431F08" "X$KTSSO"@"SEL$7" ...
http://yong321.freeshell.org/oranotes/v$sort_usage.txt    Similar Pages
... usage [Update 2014-03] In Oracle 11.2.0.2 and up, x$ktsso has a new column ktssosqlid, pointing to the SQL ... v$sort_usage (or v$tempseg_usage), you have to query x$ktsso directly. /* It's a well-known query that joins ... prev_sql_addr, prev_hash_value, prev_sql_id,... from x$ktsso, v$session where ktssoses = v$session.saddr and ...
http://permalink.gmane.org/gmane.comp.db.oracle.general/28551    Similar Pages
... of first. v$sort_usage sits on top of x$ktsso - and in x$ktsso the column ktssoobjn is the object number ...          1 And large values for ktssoobjn in x$ktsso:   KTSSOBNO  KTSSOEXTS  KTSSOBLKS  KTSSORFNO  KTSSOOBJD ... can look for it (for the relevant session) in x$ktsso. For things like sorts we can check v$sql_work ...
http://sites.google.com/site/vadasovi/icon_holders-1/v_parameterviewplanwithnoerrors.txt?attredirects%3D0%26d%3D1    Similar Pages
... "Y"@"SEL$15" "X"@"SEL$15" "X$KTSSO"@"SEL$7" "S"@"SEL$9" "W"@"SEL$9" "E"@"SEL$9" "S"@"SEL$4" "X$KSUPR"@"SEL$12" ... | FIXED TABLE FULL | X$KTSSO | |* 23 | SORT JOIN | | |* 24 | FIXED TABLE FULL | X$KSUSE | |* 25 | SORT ... / Y@SEL$15 21 - SEL$D0431F08 / X@SEL$15 22 - SEL$D0431F08 / X$KTSSO@SEL$7 24 - SEL$D0431F08 / S@SEL$9 ...
http://grokbase.com/p/freelists.org/oracle-l/143d5cs4xw/mapping-a-gtt-to-space-usage-in-the-temp-tablespace    Similar Pages
... of first. v$sort_usage sits on top of x$ktsso - and in x$ktsso the column ktssoobjn is the object number ... -40016260 1 And large values for ktssoobjn in x$ktsso:    KTSSOBNO KTSSOEXTS KTSSOBLKS KTSSORFNO KTSSOOBJD ... can look for it (for the relevant session) in x$ktsso. For things like sorts we can check v$sql_work ...
Next Results