26 lines
478 B
SQL
26 lines
478 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
SELECT
|
|
addr
|
|
, indx
|
|
, inst_id
|
|
, name
|
|
, DECODE(BITAND(flags,1),1,'DYN ','') flags
|
|
, elements_chunk
|
|
, items_pt
|
|
, initentries
|
|
, numentries
|
|
, curentries
|
|
, numchunks
|
|
, elemsize
|
|
, heap
|
|
, secondary
|
|
FROM
|
|
X$KSMDD
|
|
WHERE
|
|
LOWER(name) LIKE LOWER('%&1%')
|
|
ORDER BY
|
|
addr
|
|
/
|