/
ksminfo.sql
20 lines (18 loc) · 936 Bytes
/
ksminfo.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
-- 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
"AREA NAME" -- VARCHAR2(32)
, "NUMAPG" -- NUMBER
, "PAGESIZE" / 1024 mempage_kb -- NUMBER
, ROUND("SEGMENT SIZE" / 1048576) segsize_mb -- NUMBER
, ROUND("SIZE" / 1048576) area_size_mb -- NUMBER
, ROUND("REMAINING ALLOC SIZE" / 1048576) remain_mb -- NUMBER
, "SHMID" -- NUMBER
, "SEGMENT DISTRIBUTED" -- VARCHAR2(20)
, "AREA FLAGS" -- NUMBER
, "SEGMENT DEFERRED" -- VARCHAR2(20)
, "SEG_START ADDR" -- RAW(8)
, "START ADDR" -- RAW(8)
FROM
x$ksmssinfo
/