1

Topic: To look at plans of all requests in a packet

Hello.
There is a packet with requests.
It is necessary to launch it so that to receive a file (or it is simple on the screen) with plans of all requests in a packet.
To open a packet, to take request and to fulfill it, looking at the plan, it is impossible. Only the whole packet. Without a climbing in a packet.
Can eat any function DBMS?

2

Re: To look at plans of all requests in a packet

IMNO wrote:

it is impossible

and you secretly spy.

3

Re: To look at plans of all requests in a packet

IMNO wrote:

Hello.
There is a packet with requests.
It is necessary to launch it so that to receive a file (or it is simple on the screen) with plans of all requests in a packet.
To open a packet, to take request and to fulfill it, looking at the plan, it is impossible. Only the whole packet. Without a climbing in a packet.
Can eat any function DBMS?

did not understand in what complexity... And suddenly helps.
To open session.
To launch trace of this session.
In this session to fulfill all procedures of a packet by turns.
To ungear trace.
To process a route-making file the program tkprof.
As a result receive a file with all requests and with their plans, and with a heap of the helpful information.

4

Re: To look at plans of all requests in a packet

Aliona wrote:

As a result receive a file with all requests and with their plans, and with a heap of the helpful information.

if, case...

5

Re: To look at plans of all requests in a packet

ORA __ SQL wrote:

it is passed...

if, case...

if procedure uses if or case, trace does not turn on, or the plan is not shown?
How much qualitatively you will ask a question, so distinct you will receive council.
I fairly wrote that did not understand a question, therefore my council can be "bad shot".
And request plans can be different, even if if, case... Are not used.

6

Re: To look at plans of all requests in a packet

Aliona wrote:

if procedure uses if or case, trace does not turn on, or the plan is not shown?

If procedure uses if or case procedure start at random loses any meaning.
And to compose tests for testing of productivity occupation the extremely fascinating.

7

Re: To look at plans of all requests in a packet

IMNO;

where v$sql.program_id in (select object_id from dba_objects where object_name = '... ' and object_type = ' PACKAGE BODY ')

?

8

Re: To look at plans of all requests in a packet

Solved.
In general tried to make session trace through pl/sql developer.
But it appeared that the route-making file lays down on the server. Access to the server at me is not present. I not the administrator.
Thought that it is possible to change somehow a way to a file, but alas. Did not find as.
Made so. Opened Toad. Fulfilled a script. In  there is a menu item which goes on that way that I could not open.
Route-making file already disassembled for convenient reading opens.

9

Re: To look at plans of all requests in a packet

dbms_photoshop,
Not so understood. Whence ? From what representation?

10

Re: To look at plans of all requests in a packet

IMNO wrote:

dbms_photoshop,
Not so understood. Whence ? From what representation?

v$sql_plan_statistics_all, v$sql

11

Re: To look at plans of all requests in a packet

IMNO wrote:

In  there is a menu item which goes on that way that I could not open.

- type magic, yes?