WebEvery time your are qureying a view, the stored SQL is executed. And the data are taking from the underlined tables. The data amount retreive by the query is not stored inside the database. So, the view has not a size as the tables have. WebJan 1, 2024 · How to check tablespace in Oracle: Learn about How to Check Tablespace in Oracle, tablespace free space, tablespace growth information, tablespace size, …

query to find all the view name and their size in GB - oracle-tech

WebNov 18, 2014 · here is a query, you can run it in sql developer (or sql*plus): select ds.tablespace_name, segment_name, round(sum(ds.bytes) / (1024 * 1024)) as mb from … halo pointer

Find Table Size & Schema Size and Database Size in Oracle

WebNov 5, 2008 · Simple select that returns the raw sizes of the tables, based on the block size, also includes size with index. select table_name,(nvl (( select sum( blocks) from … WebMay 8, 2024 · create table new_emp as select * from emp where 1 = 0. create or replace type myScalarType as object ( empno number, ename varchar2(300) ) create or replace type myTableType as table of myScalarType --delete from emp--delete from new_emp. select * from new_emp. select * from emp. declare . l_data myTableType; l_limit number … WebJan 8, 2024 · To find biggest tables in a specific tablespace, you should add one more filter to the statement. SQL> select * from (select owner, segment_name table_name, bytes/1024/1024/1024 "SIZE (GB)" from dba_segments where segment_type = 'TABLE' and segment_name not like 'BIN%' and tablespace_name in ('ERP3TB1') order by 3 desc) … pn button keyboard