(B)0[m[4mSHOW[m [4mSTORAGE[m [4mAREAS[m qqqqqqqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqj
mqwqqqqqqqqqqqqqq>qqqqqqqqqqqqqqwqqk
tqqqq> [4mALL[m qqqqqqqq>qqqqqqqqqqu x
mqqwq> storage-area-name qqwqqj x
mqqqqqq<qqqqq , <qqqqqqqj x
lqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqj
mqwqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqwqqq>
tqqq> [4mIN[m qqqqqqq> db-handle qqqu
mqqq> [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqqqj
Displays the names of all storage areas for the currently invoked
database, for a specific database, or for all invoked databases.
If you specify a storage area name, the statement displays the
following information about the storage area:
o Page format
o Identification of read-only areas
o Page size
o Storage file specification
o Storage file allocation, minimum extent, maximum extent, and
percent growth
o Snapshot file specification
o Snapshot file allocation, minimum extent, maximum extent, and
percent growth
You must have the Oracle Rdb READ privilege for a database to use
the SHOW STORAGE AREAS statement.