How to tell what's going on with complex queries on linked oracle tables

  • Thread starter Thread starter mat
  • Start date Start date
M

mat

What's the most informative manner of getting a good picture of what's
going on when a complex query is run against linked oracle tables? I
have been using oracle traces but perhaps because I'm not a wiz at
setting them up, I'm not getting all the detail out of them that I'd
like.

With Microsoft odbc drivers there is a way to have the driver output to
a text file, which can be useful. But here I'm using an oracle driver
and I don't see any such trace outpu offered.

The query runs too long and I know why; but I'd like to 'see' what
exactly takes so long to get done.
 
hi Mat,
What's the most informative manner of getting a good picture of what's
going on when a complex query is run against linked oracle tables?
Click to expand...
I've always used the EXPLAIN PLAN which outputs the used query plan
after executing the query.

I've used it in conjunction with sqltools.net Oracle development
frontend (it's free and sufficent as long as you're not an Oracle DBA :).


mfG
--> stefan <--
 
Back
Top