Prev: utl_file.frename against utl_file.fcopy
Next: Strange ODBC error
From: G Quesnel on 13 Sep 2006 22:56
Who are you connecting as - try "show user"
What do you mean by "raw data"
Where is the database - do you have access to the "server".
Are you saying that you can not issue a OS command to determine the
size of all database files (Windows: right click + properties of
folders where all data+temp+log+control files - Unix df -k <folder
name>).
Can you connect to the database as a user who has dba privileges (SYS
or SYSTEM)?

Did you try the Alternate views USER_ and ALL_ on the views Vista has
suggested (ie USER_DATA_FILES I think works on tablespace you have been
granted quota on)

Please learn to communicate - Vista is telling you that in this
newsgroup we don't read backward (bottom up). If you include the
previous post in your message, make sure it stays at the top, so the
flow of the message makes sense. If you don't know how to do this, then
the next best thing is to not include any text from previous messages
in your reply. Ignoring this basic standard will reduce your chances at
a prompt assistance.

From: Brian Peasland on 13 Sep 2006 22:57
rwking(a)gmail.com wrote:
> Hi everyone,
>
> I have a project due in about an hour... one of the questions I have to
> answer is determining the physical size of the database. It's an
> Oracle 10 database. Actually, it's a small datawarehouse with 5 tables
> of raw data. I only have a SQL Plus interface, so some commands don't
> work. I can't find a query to get me the physical size anywhere on the
> net. If you have any ideas or input, PLEASE send me an email or
> respond to this post. I would greatly appreciate it. I hope someone
> is out there.
>
> Regards,
>
> Rich
>

The "size" of a database can mean different things to different people.

If you want to know how much space the database uses on the server's
disk system, you can issue the following query:

SELECT SUM(bytes) AS bytes FROM dba_data_files;

However, the datafiles could be a little empty, mostly empty or
somewhere in between. So many people look at the amount of space
occupied by the tables and indexes in the database. Any object that
allocates space in the database is called a segment, so a different
query is used:

SELECT SUM(bytes) AS bytes FROM dba_segments;

Hopefully this answer gets to you in time for you to turn in your
homework......

Cheers,
Brian

--
===================================================================

Brian Peasland
dba(a)nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
From: rwking on 13 Sep 2006 23:06

G Quesnel wrote:
> Who are you connecting as - try "show user"
> What do you mean by "raw data"
> Where is the database - do you have access to the "server".
> Are you saying that you can not issue a OS command to determine the
> size of all database files (Windows: right click + properties of
> folders where all data+temp+log+control files - Unix df -k <folder
> name>).
> Can you connect to the database as a user who has dba privileges (SYS
> or SYSTEM)?
>
> Did you try the Alternate views USER_ and ALL_ on the views Vista has
> suggested (ie USER_DATA_FILES I think works on tablespace you have been
> granted quota on)
>


- My username is ISM61018
- Forgive my terminology... raw data may not be the correct term. The
database is just five tables of grocery store data over the past 2
years.
- The database is on a server at my university (I do not have access to
this) and I am connecting via a web-based ISQL*PLUS interface

Is this the correct format? Thank you for your response... I did try
the query you suggested, but my response was:

ERROR:
ORA-04043: object USER_DATA_FILES does not exist

And the same was true with ALL_

When I tried using ISM61018, I recieved this message:

ERROR:
ORA-04043: object ism61018_data_files does not exist

I do not have DBA privileges on this database as the entire class was
granted a username/password. Does this mean I will not be able to
execute a query of this type?

Regards,

Rich

From: rwking on 13 Sep 2006 23:10

> The "size" of a database can mean different things to different people.
>
> If you want to know how much space the database uses on the server's
> disk system, you can issue the following query:
>
> SELECT SUM(bytes) AS bytes FROM dba_data_files;
>
> However, the datafiles could be a little empty, mostly empty or
> somewhere in between. So many people look at the amount of space
> occupied by the tables and indexes in the database. Any object that
> allocates space in the database is called a segment, so a different
> query is used:
>
> SELECT SUM(bytes) AS bytes FROM dba_segments;
>
> Hopefully this answer gets to you in time for you to turn in your
> homework......
>
> Cheers,
> Brian
>


Brian,

Thank you so much for your input. Unfortunately, when I try to run
these queries, I recieve the message "table or view does not exist."
I'm beginning to think that my meak username does not have the ability
to perform such queries. Could that be the case?

Thanks,

Rich

From: G Quesnel on 13 Sep 2006 23:19
1. You will be able to on the USER_SEGMENTS view (to see your tables
and indexes)
or 2. on the USER_ or ALL_TABLES and ALL_INDEXES
just remember to Select owner first and group by owner if you use the
ALL_ views, as it will include objects from SYS, SYSTEM ... if you have
been granted some access to those objects.

hth.

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: utl_file.frename against utl_file.fcopy
Next: Strange ODBC error