Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Querying TMP$TRANSACTIONS table


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Jul 5, 2017 2:40 PM Last Post By: Dale Gunter Threads: [ Previous | Next ]
Dale Gunter

Posts: 2
Registered: 10/11/09
Querying TMP$TRANSACTIONS table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 5, 2017 12:01 PM
We were attempting to track down transaction usage. I had written code to query the TMP$TRANSACTIONS table.
(Purpose being to look at which attachment was causing the Oldest Active Transaction.)

Query runs for a long, long time ... (over 5 minutes at which point I kill the attempt.)
Tried to see if IBConsole was different but it displays the same behavior.

Are there special considerations for querying the TMP$TRANSACTIONS vs. the other TMP tables?
(The others all seem to work fine/as expected.)

We are running XE3 (Update 3) 64-bit.
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Querying TMP$TRANSACTIONS table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 5, 2017 1:05 PM   in response to: Dale Gunter in response to: Dale Gunter
Dale Gunter wrote:
We were attempting to track down transaction usage. I had written code to query the TMP$TRANSACTIONS table.
(Purpose being to look at which attachment was causing the Oldest Active Transaction.)

Query runs for a long, long time ... (over 5 minutes at which point I kill the attempt.)
Tried to see if IBConsole was different but it displays the same behavior.

Are there special considerations for querying the TMP$TRANSACTIONS vs. the other TMP tables?
(The others all seem to work fine/as expected.)

We are running XE3 (Update 3) 64-bit.

No those queries should be almost immediate (first one might take a second after
that very fast).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Dale Gunter

Posts: 2
Registered: 10/11/09
Re: Querying TMP$TRANSACTIONS table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 5, 2017 2:40 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Just FYI, the exact query I ran was:

Select * from TMP$TRANSACTIONS

Also, when I query the TMP$DATABASE I get numbers like this:
Transactions = 138
NextTransID = 47864397
OATrans. = 39735098
OITrans. = 23736

[I'm trying to narrow down where/why the gap between the NextTransID - OAT is what it is.]

Anything specific I can/should look at as far as why querying TMP$TRANSACTIONS is taking so long?

Jeff Overcash (TeamB) wrote:
Dale Gunter wrote:
We were attempting to track down transaction usage. I had written code to query the TMP$TRANSACTIONS table.
(Purpose being to look at which attachment was causing the Oldest Active Transaction.)

Query runs for a long, long time ... (over 5 minutes at which point I kill the attempt.)
Tried to see if IBConsole was different but it displays the same behavior.

Are there special considerations for querying the TMP$TRANSACTIONS vs. the other TMP tables?
(The others all seem to work fine/as expected.)

We are running XE3 (Update 3) 64-bit.

No those queries should be almost immediate (first one might take a second after
that very fast).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02