Skip to Main Content

Is it possible to query information about the runtime execution plan ?

gerardnicoApr 1 2016 — edited Apr 1 2016

Hallo,

I have a analytical query (from OBIEE) that performs badly.

The index advisor didn't give any advice (ie we have already added all index).

Now, I want to have a little bit  more information on how much time the query spends for each operation and I didn't find any clue in the documentation:

Only global performance statistics may be collected

https://docs.oracle.com/cd/E21901_01/timesten.1122/e21633/perform.htm#TTOPR453

Is it possible to trace a query in Timesten ?

Thanks

Nico

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Apr 29 2016
Added on Apr 1 2016
1 comment
656 views