Skip to content

Monthly Archives: June 2007

Ridiculous charges

Wednesday, June 13, 2007

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. [...]

Filed in Travel | | Comments (0)

Checking tablespace usage

Friday, June 8, 2007

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) [...]

Filed in Oracle | | Comments (0)

Check if Java is installed in Oracle

Wednesday, June 6, 2007

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’.

Filed in Java, Oracle | | Comments (0)

Creating Google maps with Python

Tuesday, June 5, 2007

I guess everybody knows Google maps. This allows you to zoom into any part of the world, and in the ‘My Maps’ part of the site you can create your own maps. These maps can be annotated, with markers and polylines. It’s also possible to create these maps programmatically. And I’ll show you how to [...]

Filed in Google maps, Python | | Comments (0)