Multicast routers should not forwardĪny multicast datagram with destination addresses in this range, Topology discovery or maintenance protocols, such as gateway discoveryĪnd group membership reporting. Is reserved for the use of routing protocols and other low-level Required of a host implementation of the Internet Protocol (IP) to The above list of SQL statements are gist to help you achieve your result, You may alter them as per your requirement.IPv4 Multicast Address Space Registry Last Updated Expert(s) Stig Venaas Note Host Extensions for IP Multicasting specifies the extensions WHERE df.tablespace_name = fs.tablespace_name(+) (SELECT tablespace_name, SUM(bytes) FREE_SPACE, ROUND(100 * (fs.free_space / df.total_space),2) PCT_FREEįROM (SELECT tablespace_name, SUM(bytes) TOTAL_SPACE, (df.total_space_mb - fs.free_space_mb) USED_SPACE_MB, SELECT df.tablespace_name TABLESPACE, df.total_space TOTAL_SPACE,įs.free_space FREE_SPACE, df.total_space_mb TOTAL_SPACE_MB, SELECT tablespace_name, SUM(bytes)/1024/1024 "Used in MB", SUM(maxbytes)/1024/1024 "Max in MB" FROM dba_temp_files WHERE tablespace_name='SYS_TEMP' GROUP BY tablespace_name SELECT tablespace_name, SUM(bytes)/1024/1024 "Used in MB", SUM(maxbytes)/1024/1024 "Max in MB" FROM dba_temp_files GROUP BY tablespace_name SELECT tablespace_name, SUM(bytes)/1024/1024 "Used in MB", SUM(maxbytes)/1024/1024 "Max in MB" FROM dba_data_files WHERE tablespace_name='SYSAUX' GROUP BY tablespace_name SELECT tablespace_name, SUM(bytes)/1024/1024 "Used in MB", SUM(maxbytes)/1024/1024 "Max in MB" FROM dba_data_files GROUP BY tablespace_name # Size of physical and temporary tablespace with calculated details -Physical tablespace Select owner, (sum(space)*512)/1024/1024 "Size in MB" from dba_recyclebin where owner='SYSMAN' group by owner order by sum(space) Select owner, (sum(space)*512)/1024/1024 "Size in MB" from dba_recyclebin group by owner order by sum(space) Select owner, type, count(*) from dba_recyclebin group by owner, type # Space occupied by dba_recyclebin for all DB and users -Fyi, SHOW PARAMETERS db_block_size Select username, tablespace_name, sum(bytes)/1024/1024 "Size in MB" from dba_ts_quotas where username in ('SYSMAN') group by username, tablespace_name Select segment_name, segment_type, bytes/1024/1024 "Size in MB" from dba_segments where segment_type='MATERIALIZED VIEW' and segment_name='MPC_TIME_WRITING_ALL_MV' Select owner, sum(bytes)/1024/1024 "Size in MB" from dba_segments where owner='SYSMAN' group by owner Select owner, sum(bytes)/1024/1024 "Size in MB" from dba_segments group by owner select sum(bytes)/1024/1024/1024 "Size in GB" from dba_segments # Actual space used by complete DB, all schemas, specific user, objects and quota space. select sum(bytes / (1024*1024)) "DB Size in MB" from dba_data_files # Complete Size of Database on a physical disk (unless you are using ASM).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |