http://freelists.org/post/oracle-l/how-to-find-the-name-for-SQL-OPCODE,2
Similar Pages
... versions you can use: DBA_HIST_SQLCOMMAND_NAME or
V$SQLCOMMAND
In older versions read the manual :-)
--
Tanel ...
http://dba-oracle.com/t_11_2_new_v_dollar_views.htm
Similar Pages
... pendency v$sql_feature_hierarchy v$sql_hint v$sql_monitor v$sql_plan_monitor v$sqlcommand v$sqlfn_ar ... stat v$calltag v$cell v$cell_config v$cell_request_totals v$cell_state v$cell_thread_history v$corru ... ng v$hm_info v$hm_recommendation v$hm_run v$incmeter_config v$incmeter_info v$incmeter_summary v$io_ ...
http://blog.tanelpoder.com/2011/08/23/v8-bundled-exec-call-and-oracle-program-interface-opi-calls/
Similar Pages
... COUNT(*)
7 FROM
8 v$active_session_history a
9 , v$sqlcommand s
10 WHERE
11 a.t ... column) and also by the SQL command type (using V$SQLCOMMAND in 11.2): SQL> SELECT
2 a.top_level_call# ... see from v$toplevelcall (or its underlying x$orafn) in Oracle 11.2: SQL> SELECT * FROM v$toplevelcall; ...
http://blog.tanelpoder.com/2011/08/23/v8-bundled-exec-call-and-oracle-program-interface-opi-calls/#cancel
Similar Pages
... COUNT(*)
7 FROM
8 v$active_session_history a
9 , v$sqlcommand s
10 WHERE
11 a.t ... column) and also by the SQL command type (using V$SQLCOMMAND in 11.2): SQL> SELECT
2 a.top_level_call# ... see from v$toplevelcall (or its underlying x$orafn) in Oracle 11.2: SQL> SELECT * FROM v$toplevelcall; ...
http://permalink.gmane.org/gmane.comp.db.oracle.general/1333
Similar Pages
... and from Oracle 11.2 there's also a new view V$SQLCOMMAND which lists all commands and their types. -- ... defition, but all it does (from v$fixed_view_definition) is telling me that v$active_session_history references ... views, so they don't have view SQL hardcoded like V$ do. Also, you can use my x$ describe script (xde2 ...
http://blog.tanelpoder.com/files/scripts/exadata/exafriendly.sql
Similar Pages
... OVER () * 100, 1) pct FROM &ash, v$sqlcommand WHERE &ash..sql_opcode = v$sqlcommand.command_type GROUP BY ... UNT(*)) OVER () * 100, 1) pct FROM v$active_session_history a , v$sql_plan p WHERE a.sql_id = p.sql_id ... UNT(*)) OVER () * 100, 1) pct FROM v$active_session_history a , v$sql_plan p WHERE a.sql_id = p.sql_id ...
http://freelists.org/post/oracle-l/Is-it-possible-to-peek-at-the-definition-of-xtables,2
Similar Pages
... and from Oracle 11.2
there's also a new view V$SQLCOMMAND which lists all commands and their
types.
-- ... defition, but all it does
> (from v$fixed_view_definition) is telling me that
> v$active_session_history references ... views, so they
don't have view SQL hardcoded like V$ do.
Also, you can use my x$ describe script (xde2 ...
http://docs.oracle.com/database/121/RCMRF/rcmsynta2018.htm
Similar Pages
... Language Reference Prerequisites None Syntax sqlcommand::= Description of the illustration sqlcommand ... n allsqlkeywords.gif sqlKeyword::= Semantics sqlcommand::= Syntax Element Description SQL CATALOG Executes ... selects a column from the V$DATABASE dynamic performance view:
RMAN> SELECT dbid FROM v$database;
using target ...
http://comments.gmane.org/gmane.comp.db.oracle.general/1330
Similar Pages
... and from Oracle 11.2 there's also a new view V$SQLCOMMAND which lists all commands and their types. -- ... defition, but all it does
(from v$fixed_view_definition) is telling me that
v$active_session_history references ... defition, but all it does (from v$fixed_view_definition) is telling me that v$active_session_history references ...
http://comments.gmane.org/gmane.comp.db.oracle.general/1333
Similar Pages
... and from Oracle 11.2 there's also a new view V$SQLCOMMAND which lists all commands and their types. -- ... defition, but all it does (from v$fixed_view_definition) is telling me that v$active_session_history references ... views, so they don't have view SQL hardcoded like V$ do. Also, you can use my x$ describe script (xde2 ...