19 pages found, pages 1 to 10
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 ...
SQL
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 ...
Next Results