oracle session statistics
Solutions on MaxInterview for oracle session statistics by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle session statistics"
Isra
15 Feb 2018
1SELECT sn.NAME, ss.VALUE
2FROM V$SESSTAT ss,
3 V$STATNAME sn,
4 V$SESSION s
5WHERE ss.STATISTIC# = sn.STATISTIC#
6 AND s.SID = ss.SID
7 AND s.AUDSID = sys_context('USERENV', 'SESSIONID');similar questions
oracle table privilegesoracle tablespace usageoracle show proceduresoracle table statisticsoracle undo usage by sessionoracle job historyoracle user quota on tablespaceoracle trace sessionhow to check last gather stats on table in oracleoracle session parametersoracle active transactionsoracle list grants on procedureoracle table statistics last analyzedoracle undo usage per sessionprocedure excute monthly oracleoracle session variables listoracle user tablesoracle kill sessionoracle gather table statisticsoracle nls sessionoracle job sessionoracle list proceduresoracle v 24sessionoracle current session detailsoracle show running proceduresoracle session date formatquery saurce oracle your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful