DBAPack/getsqls.sql at master · flvani/DBAPack · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
SET TERMOUT OFF FEEDBACK OFF VERIFY OFF PAGES 500 LINES 200 UNDERLINE '~'

DEFINE P1=&1.
DEFINE P_HASH='0'
DEFINE P_ADDR='0'
DEFINE P_CHILD_ADDR='0'
DEFINE P_QTCOPIAS='-1'
DEFINE P_VERSAO=''
DEFINE P_WHERE_CURSOR=''
DEFINE P_SQL_ID=''
DEFINE P_SQL_PATCH=''
DEFINE P_SQL_PROFILE=''
DEFINE P_SQL_PLAN_BASELINE=''
DEFINE P_OUTLINE_CATEGORY=''

@detalhesql &P1 true

SET VERIFY OFF FEED OFF

REM @fillplan&p_versao. &p_hash. &p_addr. &p_child_num.
REM @do.expplan.sql &p_hash.

ROLLBACK;

--retorna sempre zero - desabilitei
SELECT
  ROUND(SHARABLE_MEM/POWER(1024,2),0) SHARABLE_MEM_MB
 ,ROUND(PERSISTENT_MEM/POWER(1024,2),0) PERSISTENT_MEM_MB
 ,ROUND(RUNTIME_MEM/POWER(1024,2),0) RUNTIME_MEM_MB
FROM V$SQL
WHERE SQL_ID = '&P_SQL_ID.'
.

PROMPT

UNDEFINE P_SQL_ID P_HASH P_ADDR P_VERSAO

SET PAGES 100 FEEDBACK 6 VERIFY ON UNDERLINE '-'