Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
information on transactions being rolled back?
So I did some investigation, and I came up with a kludge. set your nls_date_format to display minutes and seconds, then run: select sysdate, log_io, phy_io, used_ublk, used_urec from v$transaction; wait a while, and run it again. It seems that when rolling back a transaction, used_urec (the...- braxton
- Post #2
- Forum: Oracle: All versions
-
information on transactions being rolled back?
I'm using OEM to monitor running processes and transactions, but I'm wondering how to get status on transactions that are currently being rolled back? For example: 1) user submits massive query inserting millions of rows 2) I view the session from OEM, observe that the estimated time of...- braxton
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Stored Procedure to Return data in Oracle
I think you need to return a reference cursor or an array type from oracle. I use JDBC, not ODBC, but the fundamentals are similar. 1) create an array type in oracle: create or replace TYPE char_varray as VARRAY(1000) OF CHAR(30); 2) prepare the statement, set the output parameter, and...- braxton
- Post #5
- Forum: Oracle: All versions
