oracle active transactions
Solutions on MaxInterview for oracle active transactions by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle active transactions"
Joséphine
11 Nov 2018
1-- Active transactions (generating UNDO)
2SELECT s.SID, s.SERIAL#, s.CLIENT_INFO, t.ADDR, sum(t.USED_UBLK)
3FROM V$TRANSACTION t,
4 V$SESSION s
5WHERE t.ADDR = s.TADDR
6GROUP BY s.SID, s.SERIAL#, s.CLIENT_INFO, t.ADDR;similar questions
oracle table privilegesoracle trigger after logon on databaseoracle transaction commit rollback exampleoracle force indexes dblinkoracle role useroracle rolling back transactionsoracle activate joboracle check table lockoracle dependencies tableoracle trace sessionhow to check last gather stats on table in oracleoracle session statisticsoracle last connectionview acl table oracleoracle table statistics last analyzedoracle grant roleoracle transaction rollback not workingoracle sql transactionoracle identify sql holding lockoracle user last connection dateoracle job sessionoracle show grants on tableopen transactions sqlskillsoracle current session detailshow to check table lock in oracle sql developer 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