From: John F Riordan (jriorda2@CSC.COM)
Date: Fri Aug 16 2002 - 14:05:28 EDT
Hi John
Thanks for responding. To answer your question, yes I am looking to find
the free space in the tablespace. I get reports on the filesystem space
once a week with scripts I wrote and nmon. But most of the filesystems
that the tables are on, report at 100% . When the dba's created the tables
they used the complete filesystem space.
I appreciate you looking for the script. I am trying my hand at writing an
sql statement that might get the information but it is not going very well.
Thanks again
John
John Riordan
Unix Systems Administrator
CSC/BIW DD(X)
Brunswick, ME 04011
207.442.1094 jriorda2@csc.com
John Jolet
<john.jolet To: aix-l@Princeton.EDU
@MISYSHEALTHC cc:
ARE.COM> Subject: Re: Oracle Table Space vs JFS Space
Sent by: IBM
AIX
Discussion
List <aix-l
08/16/2002
12:10 PM
Please
respond to
IBM AIX
Discussion
List
are you needing to find out how much free space is in the tablespace, or on
the filesystem? There IS query you can run to find the free space in a
table space. If the tablespace is set up to autoallocate, it should never
fill up. You can't extend the filesystem?
I'll try to find the script I had a year or so ago to find out the free
space in the tablespace.
At 11:12 AM 8/16/2002 -0400, you wrote:
>Hi All,
>
>I'm looking to see if any of you have had to monitor data in a defined
>table space residing on a filesystem. I know our Oracle dba can do this.
>But they are off site and most of the table spaces have been created to
the
>full capacity of the filesystems. We had a full filesystem this morning
>and I have been asked to include actual data size in the tables with my
>weekly disk statistics. I would assume using sqlplus could extract the
>data and create a text file that I could import into excel. But I don't
>know enough about sqlplus. I have tried to get in touch with our Oracle
>dba's but as of yet no luck. I have also looked through the list archives
>but did not really find anything. We have six Oracle servers three
>H-50's, an H-80, and two B80's.
>
>Hope I did not ramble, any help would be greatly appreciated.
>
>Thanks in advance
>John
>
>
>
>John Riordan
>Unix Systems Administrator
>CSC/BIW DD(X)
>Brunswick, ME 04011
>207.442.1094 jriorda2@csc.com
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:09 EDT