Oracle SQL to Show Free Space In Tablespaces

Here is a nifty bit of SQL that will show you the used space and free space for all the tablespaces in an Oracle database.

1. #This SQL can only be ran as SYSDBA or with a database user with "SELECT ANY DICTIONARY" privilege: 2. 3. SELECT df.tablespace_name , 4. df.total_space_mb TOTAL_SPACE_MB, 5. (df.total_space_mb - fs.free_space_mb) USED_SPACE_MB, 6. fs.free_space_mb FREE_SPACE_MB, 7. ROUND(100 * ((df.total_space_mb - fs.free_space_mb) / df.total_space_mb),2) PCT_USED 8. FROM (SELECT tablespace_name, SUM(bytes) TOTAL_SPACE, 9. ROUND(SUM(bytes) / 1048576,2) TOTAL_SPACE_MB 10. FROM dba_data_files 11. GROUP BY tablespace_name) df, 12. (SELECT tablespace_name, SUM(bytes) FREE_SPACE, 13. ROUND(SUM(bytes) / 1048576,2) FREE_SPACE_MB 14. FROM dba_free_space 15. GROUP BY tablespace_name) fs 16. WHERE df.tablespace_name = fs.tablespace_name(+) 17. ORDER BY fs.tablespace_name; Hide line numbers

SOAP - Acronyms

SOAP is usually full of acronyms. You know what it is, but you forgot what the acronym stands for. Here are some of the more popular acronyms.

SOAP Simple Object Protocol Access Protocol

JAXB - Java Api for Xml Binding
xml --unmarshall-> class
xml <--marshall--- class

JAXP Java Api for Xml Processing
DOM Document Object Model
SAX Simple Api for Xml
StaX Streaming Api

JAXM Java Api for Xml Messaging
|-> JAXM 1.1
|-> SAAJ 1.1 Soap with Attachments Api for Java (send, recieve soap messages)
JAXR - Java Api for Xml Registries
JAX-RPC - Java Api for Xml based RPC
JAX-WS - Now replacing JAX-RPC. Available with JWSDP2

UDDI - Universal Description, Discovery and Integration.

Patching With RCS

Patch your source files ahd header files. Generate a patch and then apply it.

diff -u old.c new.c > my.patch
patch < my.patch

Reverse a patch
patch -R < my.patch

:)

Object Oriented Design and Principles

This article has moved over here at our new Design Diaries Site.