oracle index size calculation

Solutions on MaxInterview for oracle index size calculation by the best coders in the world

Search
showing results for - "oracle index size calculation"
Fynn
17 Mar 2018
1SELECT SEGMENT_NAME, OWNER, round(sum(BYTES) / 1e6, 0) AS SIZE_MB
2FROM DBA_SEGMENTS
3WHERE TABLESPACE_NAME = 'tbs_name'
4GROUP BY SEGMENT_NAME, OWNER
5ORDER BY SIZE_MB DESC;
similar questions
oracle percentageoracle convert run duration to numberoracle calculate statistics on partitionoracle tablespace datafile max sizeoracle character indexhow to select an index in oracle sqloracle run duration averageget clob size oracleoracle schema sizevarchar2 length in oracleselect index table oracleoracle string lengthhow to increase the width of the screen in oracleoracle number to percentageforce using index oracleoracle show index columnsquery to find table size in oracle 12coracle index hintoracle table sizeoracle index partitionoracle control file sizeoracle create indexalter table column size oracleoracle tablespace size
queries leading to this page
orcale index sizeoracle index sizeindex size in oracleoracle index size calculationoracle index size calculation