The following queries can be used to find out how much space a table takes up. The first query gets the block size used in this database. The second one shows how many blocks are used for a table. select value from v$parameter where name = 'db_block_size'; select blocks, last_analyzed from all_tables where owner = 'X' and table_name = 'Y'; The blocks field will have a valid value if the table has been analyzed recently, that is why the last_analyzed field is selected as well.
You can also create Google Maps using XML : check out this article.
Caution : some serious ranting to be found in this post. I have some airmiles for TAP, the Portuguese airline. I got these when I was working in Brazil and Portugal some time ago. These miles expire after 3 years, which is reasonable. So I booked a flight to Athens from London to use these. TAP doesn’t fly this route directly or through Portugal, so you have to use one of their partner airlines, which is Lufthansa in this case.
This SQL, inspired by this, shows how full the tablespaces are : SELECT tablespace_name || ' is ' || TO_CHAR(ROUND(100-(free_bytes*100/total_bytes), 2)) || '% full.' T, total_bytes, free_bytes FROM (SELECT a.tablespace_name, a.total_bytes, b.free_bytes FROM (SELECT tablespace_name, NVL(SUM(bytes), 1) AS total_bytes FROM dba_data_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes) AS free_bytes FROM dba_free_space GROUP BY tablespace_name) b WHERE a.tablespace_name = b.tablespace_name ) ORDER BY tablespace_name; Another way of doing it is like this (courtesy of this site) : select a.
If you want to know if Java is installed, use the following SQL : select * from dba_registry; There should be an entry with comp_id equal to ‘JAVAVM’.
Copyright (c) 2025 Michel Hollands