ze blog of simon

select a.TABLESPACE_NAME,
a.BYTES bytes_used,
b.BYTES bytes_free,
b.largest,
round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used
from
(
select TABLESPACE_NAME,
sum(BYTES) BYTES
from dba_data_files
group by TABLESPACE_NAME
)
a,
(
select TABLESPACE_NAME,
sum(BYTES) BYTES ,
max(BYTES) largest
from dba_free_space
group by TABLESPACE_NAME
)
b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME
order by ((a.BYTES-b.BYTES)/a.BYTES) desc;

Produces something like this:

from http://vsbabu.org/oracle/sect03.html

1 Comment »

http://www.impactlab.com/modules.php?name=News&file=article&sid=7567

No Comments yet »

Every now & then I’m forced to deal with databases in Access, the worst case of this is when the database started life in something else, ‘cos that when Dates usually get really screwy.

I recently had one with dates stored as 3 seperate fileds, I know I should have transformed the data, but I didn’t, so I came up witha few queries that tried to munge the data into something usable, my first attempt was this:

PurchaseDate: LTrim(RTrim(day))+’/'+LTrim(RTrim(month))+’/'+LTrim(RTrim(year))

But then I found a better way:

PDate: DateFromDMY([day],[month],[year])

Where DateFromDMY is a VB function, something akin to:

Public Function DateFromDMY(a_Day As Integer, a_Month As Integer, a_Year As Integer) As Date

If (a_Day = 0) Then
a_Day = 1
End If

If (a_Month = 0) Then
a_Month = 1
End If

If (a_Month > 12) Then
a_Month = 12
End If

DateFromDMY = CDate(CStr(a_Day) + “/” + CStr(a_Month) + “/” + CStr(a_Year))

End Function

Now that’s a crude function, but you get the idea, you can fix up data easily.

Thank you Martin Green for his pointers here.

No Comments yet »

If you use firefox, you need Tab Mix Plus. The site is here, and you can install it from here. I used to use Session Saver .2 & some japanese fellow’s Tabbed Browsing Extensions, but this does it all, it’s much slicker & I’m very happy

Update: 14th July 2006
I’m considering adding Bookmarks Synchronizer 3 to this list..

No Comments yet »

I’ve just discovered that my auntie has a blog! It’s part of the website for their B&B, Carno House, how cool is that!

Great work Auntie Hilda!

No Comments yet »

http://home.eunet.no/~pnordahl/ntpasswd/

It’s just one of those tools you can’t live with out.

No Comments yet »

Here is a list of some of the most frequently used SQL*Plus commands:
• ACCEPT – Get input from the user
• DEFINE – Declare a variable (short: DEF)
• DESCRIBE – Lists the attributes of tables and other objects (short: DESC)
• EDIT – Places you in an editor so you can edit a SQL command (short: ED)
• EXIT or QUIT – Disconnect from the database and terminate SQL*Plus
• GET – Retrieves a SQL file and places it into the SQL buffer
• HOST – Issue an operating system command (short: !)
• LIST – Displays the last command executed/ command in the SQL buffer (short: L)
• PROMPT – Display a text string on the screen. Eg prompt Hello World!!!
• RUN – List and Run the command stored in the SQL buffer (short: /)
• SAVE – Saves command in the SQL buffer to a file. Eg “save x” will create a script file called x.sql
• SET – Modify the SQL*Plus environment eg. SET PAGESIZE 23
• SHOW – Show environment settings (short: SHO). Eg SHOW ALL, SHO PAGESIZE etc.
• SPOOL – Send output to a file. Eg “spool x” will save STDOUT to a file called x.lst
• START – Run a SQL script file (short: @)

No Comments yet »