this is not elegant, but works:
execute this is sqlplus:
host (srvinfo -od ) > disk_info.txt
host blat disk_info.txt -to [EMAIL PROTECTED]
which will provide you with output of the format:
-----Original Message-----
Sent: Wednesday, June 27, 2001 3:48 PM
To: log_files
C$,NTFS,2048,1890,158
D$,NTFS,3099,2758,341
E$,NTFS,4095,3849,246
F$,NTFS,8190,7684,506
This does require that you have the utility "blat.exe" installed and in your
path.
hth,
Paul
-------- Original Message --------
Subject: RE: OT RE: 24 x 7 on NT?
Date: Wed, 27 Jun 2001 09:50:28 -0800
From: Kimberly Smith <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Arn't you going to make sure you actually have the disk space to resize
that data file first? SomethingOEM does not do for you. Must go out to
the server and check.
-----Original Message-----
From: JOE TESTA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 7:22 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT RE: 24 x 7 on NT?
Mike, i'm with you there. alter database datafile
'/fill/in/name/here' resize 200m; or right click in OEM and
change the size. As long as you can do the previous then
might as well use the latter :) joe
>>> [EMAIL PROTECTED] 06/27/01 09:26AM >>>
More on the same vein. Sorry if this thread is developing a
"me too" feel.
I'm happy to use GUI tools when they save me time. I know what
they're doing and
how they achieve their results.
The availability of GUI tools is however a huge disincentive
for new DBAs to
find out how the database actually works and leads to a lack
of understanding of
the way the beast works as a whole.
If your goal is to be a knowledgeable and effective DBA then
you can't beat
starting from the command line and working your way towards
GUI when you find
your feet. That requires a long-term viewpoint though, and the
world is
focussing increasingly on the short term.
If I sound like a Luddite then I've given the wrong
impression; that;s just my 4
groats-worth.
Regards,
Mike
|--------+------------------------->
| | Peter McLarty |
| | <peter.mclarty@|
| | incts.com> |
| | |
| | 06/27/01 01:30 |
| | PM |
| | Please respond |
| | to ORACLE-L |
| | |
|--------+------------------------->
>-----------------------------------------------------------------|
|
|
| To: Multiple recipients of list
ORACLE-L |
|
<[EMAIL PROTECTED]> |
| cc: (bcc: Mike
Hately/ETECH) |
| Subject: Re: OT RE: 24 x 7 on
NT? |
>-----------------------------------------------------------------|
Oh I agree
As a newbie to the Oracle fold I found it oh so easy to dive
into
stuff with the DBA Studio, I suppose the thing that stops me
is some 7 or
more years hacking around Linux and Unix systems. Graphical
tools are great
for some things but you just cant beat the capabilities of a
good script
and Windows will be a lot better for it now it has a good
scripting system.
What i found DBA studio for thogh was the show SQL button I
could set up
some task to do and then have a look at the SQL that was going
to happen so
I could better understand it.
I am sure when we start seeing more Oracle up on Win2K we will
see a lot
more scripting on that side to do those mixed OS and SQLPlus
tasks.
Peter McLarty
[EMAIL PROTECTED]
04 0209 4238
System Administrator
L plate Oracle DBA
At 03:56 AM 27/06/2001 -0800, you wrote:
>On June 27, 2001 07:55 am, Mark Leith wrote:
> > slapping developers - what's the problem with them?
>
>No problem slapping developers.... rather enjoy it actually
....
>
>The issue I have with point & click is the increasing number
of
>database admins who can only use these tools. Put them in
front of a
>command line and they will sit and stare blankly. GUI tools
can be
>great (except when they're written in java :), but you should
>actually know what you are doing and the 'how & why' behind
it before
>you start clicking a database to death.
>
>Just my cynical $.02.
>Cheers,
>GC
>--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter McLarty
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
