What do you do for a job?

**Cajun** · 10th May 2004, 20:25

Originally Posted by matthewt

I'm a Oracle dba mainly (95%) but have done the others in my previous IT life (used to do heaps of Novell Netware, general PC stuff and the odd bit of c++).

How big is your Oracle DB ?? I've spent the last 6 years at a very large govt site looking after various DB's there.

hmmm not to sure how big it is, got it at work, i work for the port of tauranga. we are running oracle 9i,

db beer yucky yucky stuff

**Jinx3d** · 10th May 2004, 20:38

Originally Posted by wkid_one

I work in finance......but you know what they say about the 'mechanics car'.

hahaha, yeah, I'm an ex mechanic, my cars always were heaps!
Why waste money on a car when it will buy new sticky tyres and silly motorcycle baubles!

4 years and $20,000 turned me into an engineer so no more lying on the concrete for me

:-)

Jinx3d

**wkid_one** · 10th May 2004, 21:04

Yeah - LOL.....my finances resemble that car.

I forgot to add - I have done lending for most things you could consider buying - from planes to helicopters, from bikes to cars, from Beach Houses to Corporate Head Offices.....from $1000 to $30m - and everything in the middle. So if you want a hand let me know.

**SPman** · 10th May 2004, 21:22

Originally Posted by bikerboy

I'm an architect, but obviously not a very good one as I seem to have plenty of time to ride my bike.

You must be a good one - you've obviously got your work-life balance right and a garage full of Porsche and MV's......

**matthewt** · 10th May 2004, 22:45

Originally Posted by Cajun

hmmm not to sure how big it is, got it at work, i work for the port of tauranga. we are running oracle 9i,

I did some Pro*C work for Port of Wellington a few years ago, mainly to create EDI documents.

For the DB size you could try:

set pages
set lines 10000
set trimspool on
select file_name||'|'||substr(file_name,instr(file_name,'/',-1,1)+1)||'|'||bytes from dba_data_files
UNION
select file_name||'|'||substr(file_name,instr(file_name,'/',-1,1)+1)||'|'||bytes from dba_temp_files
UNION
select member||'|'||substr(member,instr(member,'/',-1,1)+1)||'|'||bytes from v$logfile f,v$log l where f.group# = l.group#
UNION
select name||'|'||substr(name,instr(name,'/',-1,1)+1)||'|' from v$controlfile;

Spool it out to a file and open it in excel. The | is the delimter. It'll give you the locations/sizes of all your datafiles, tempfiles, controlfiles and redo logs.

**marty** · 10th May 2004, 22:59

i tried that matt, but i just couldn't get it to run.

**matthewt** · 10th May 2004, 23:12

Originally Posted by marty

i tried that matt, but i just couldn't get it to run.

Marty, either you're taking the piss or you're logged as someone that doesn't have access to the DBA or V$ views. I suspect the first reason

No wait, you're using MS-Access

**marty** · 10th May 2004, 23:38

your suspicions would be well founded matt dude

**Holy Roller** · 11th May 2004, 05:16

Originally Posted by sAsLEX

Signed my life to the puss for a few years. Interesting who will know this term..

Not often one hears that term...
They were the best of years , they were the worst of years....

LB · 11th May 2004, 06:12

Originally Posted by sAsLEX

Signed my life to the puss for a few years. Interesting who will know this term..

eerrr - have been waiting for someone else to ask so's I didn't have to. But no-one else has. So let me fess up: I don't know what you mean.

I am but a humble Executive Assistant to a Chief Executive in a Government Department. (that really means I get to run the place and have all the minions terrified of me!!)

**sAsLEX** · 11th May 2004, 07:11

Originally Posted by SPman

Thats why you live in Devonport?

Correct SP

**Cajun** · 11th May 2004, 07:57

i spend half of my day dealing with EDI's and what so have you.

**ching_ching** · 11th May 2004, 08:40

Originally Posted by maybe

I work for the government but don't hold that against me.....am a senior corrections officer.........so unless you come to jail i'm not much help either....

Howzit Boss,

I'm on the floor at Rangipo Camps. May I say that business is somewhat "booming" at the moment.

the ching

**matthewt** · 11th May 2004, 09:27

Originally Posted by Cajun

i spend half of my day dealing with EDI's and what so have you.

I mainly did a bit of reporting and then wrote some c to extract out the data they wanted into some EDI templates for them.

Haven't heard from them for years.

**Cajun** · 11th May 2004, 09:55

Originally Posted by matthewt

I mainly did a bit of reporting and then wrote some c to extract out the data they wanted into some EDI templates for them.

Haven't heard from them for years.

Yeah our system makes the edi, i just use perl to massage it a bit, so shipping lines can read what we sent, and we can read what they sent.

**pete376403** · 11th May 2004, 10:00

Originally Posted by Lynda Blair

eerrr - have been waiting for someone else to ask so's I didn't have to. But no-one else has. So let me fess up: I don't know what you mean.

I am but a humble Executive Assistant to a Chief Executive in a Government Department. (that really means I get to run the place and have all the minions terrified of me!!)

A hint could be...http://www.pussers.com/ and The Village People did a song, too

**FROSTY:Me** · 11th May 2004, 10:09

hmm--My dad was a pusser but in his day it was called a matalo.
I grew up in a pusser town in the UK --portsmouth

**Kiwi** · 11th May 2004, 10:33

I lived in Germany, where I used to work as an engineer and manager. Since I have been in New Zealand, I have a new job: I am a tour guide for New Zealand Motorcycle Rentals and also I have a small shop for MC parts.
see ya
Kiwi