FilesExpand file tree

master

/

vlibrary_cache_stats.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

26 lines (23 loc) · 654 Bytes

master

/

vlibrary_cache_stats.sql

Copy path

Top

File metadata and controls

• Code
• Blame

26 lines (23 loc) · 654 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

SET LINESIZE 500

SET PAGESIZE 1000

COLUMN namespace FORMAT A20

COLUMN gethitratio FORMAT A10

COLUMN pinhitratio FORMAT A10

COLUMN gets FORMAT 99999999999

COLUMN gethits FORMAT 99999999999

COLUMN pins FORMAT 99999999999

COLUMN pinhits FORMAT 99999999999

COLUMN gethits FORMAT 9999999

COLUMN invalidations FORMAT 9999999

SELECT c.namespace,

c.gets,

c.gethits,

to_char(Round(c.gethitratio,2) * 100) ||'%' gethitratio,

c.pins ,

c.pinhits ,

to_char(Round(c.pinhitratio,2) *100) ||'%' pinhitratio,

c.reloads,

c.invalidations

FROM v$librarycache c

ORDER BY c.pins desc,

c.pinhitratio asc;