Re: Open period Request Takes too long

Posted by ErmanArslansOracleBlog on Mar 06, 2017; 6:43am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Open-period-Request-Takes-too-long-tp2249p2265.html

Send me the following ->

1)Current wait of this session
2)Execution plan of the current statement.

Using Toad, you can gather both of it.

Note: There are bug records for performance of these posting programs, but I want to see the wait and the execution plan of this statement to filter these bugs.
Maybe we can find a patch using the index_name (if we see an excessive index wait)