OraFAQ Forum: Server Administration » Question about viewing "tree tablespace"

Home » RDBMS Server » Server Administration » Question about viewing "tree tablespace" (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question about viewing "tree tablespace" [message #458132]

Thu, 27 May 2010 09:46

Najdmr
Messages: 6
Registered: May 2010

Junior Member

Hi,

I am a university student and have an assignment, I solved all the questions but have one point I don't anything about it.

Here is the question:

Develop a system that allows a user to login and visualize various information on Oracle Server.

At a minimum the system should allow a user to:

...
...
...
4. Display the tree tablespaces and information about tablespaces and datafiles
...
...
..

Would appreciate if any one can help on that.

Thanks,

[Updated on: Thu, 27 May 2010 09:54] by Moderator

Report message to a moderator

Re: Question about viewing tree "tablespace" [message #458133 is a reply to message #458132]

Thu, 27 May 2010 09:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> desc dba_data_files
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME					    VARCHAR2(513)
 FILE_ID					    NUMBER
 TABLESPACE_NAME				    VARCHAR2(30)
 BYTES						    NUMBER
 BLOCKS 					    NUMBER
 STATUS 					    VARCHAR2(9)
 RELATIVE_FNO					    NUMBER
 AUTOEXTENSIBLE 				    VARCHAR2(3)
 MAXBYTES					    NUMBER
 MAXBLOCKS					    NUMBER
 INCREMENT_BY					    NUMBER
 USER_BYTES					    NUMBER
 USER_BLOCKS					    NUMBER
 ONLINE_STATUS					    VARCHAR2(7)

Report message to a moderator

Re: Question about viewing tree "tablespace" [message #458134 is a reply to message #458133]

Thu, 27 May 2010 09:52

Najdmr
Messages: 6
Registered: May 2010

Junior Member

Thanks for the prombt reply!!!

Are there any thing called "Tree tablespace"? what does he mean by it?

I searched alot but with no luck.

Report message to a moderator

Re: Question about viewing tree "tablespace" [message #458135 is a reply to message #458134]

Thu, 27 May 2010 09:56

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"Tree tablespace" is something that does not exist.
Now ask the one that assignes you this to explain you what he/she means.

Regards
Michel

Report message to a moderator

Re: Question about viewing tree "tablespace" [message #458136 is a reply to message #458134]

Thu, 27 May 2010 09:57

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Does it mean displaying the data in a tree structure?

Report message to a moderator

Re: Question about viewing "tree tablespace" [message #458137 is a reply to message #458132]

Thu, 27 May 2010 09:57

Najdmr
Messages: 6
Registered: May 2010

Junior Member

i want to list tree representation of tablespaces and i want to view the details of this tablespaces and datafiles
any suggestions please????
i know that i have to query dba_data_file
but how can i display the result as hirarical view of tablespaces
i didn't get the point of our instructor

Report message to a moderator

Re: Question about viewing tree "tablespace" [message #458138 is a reply to message #458134]

Thu, 27 May 2010 09:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Are there any thing called "Tree tablespace"? what does he mean by it?
I am just guessing that he wants something like the following;

TABLESPACE_NAME       FILE_NAME
USERS                 FILE1
                      FILE2
                      FILE3
APP_TS                FILE1
                      FILE2

Kind of like a directory TREE

Report message to a moderator

Re: Question about viewing tree "tablespace" [message #458139 is a reply to message #458134]

Thu, 27 May 2010 09:58

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

Are there any thing called "Tree tablespace"? what does he mean by it?

As per my understading; you whould have to check Hierarchical display of the tablespaces and datafiles (like Tablespace free/used space, status of tablespace , current size etc.. etc.. ). Once again check with your assigne.

Babu

Report message to a moderator

Re: Question about viewing "tree tablespace" [message #458140 is a reply to message #458137]

Thu, 27 May 2010 09:59

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

but how can i display the result as hirarical view of tablespaces

First explain WHAT you want then investigate HOW you can do it.
If you are not clear on the first point you cannot achieve the second one.

Regards
Michel

Report message to a moderator

Re: Question about viewing "tree tablespace" [message #458145 is a reply to message #458137]

Thu, 27 May 2010 10:10

Najdmr
Messages: 6
Registered: May 2010

Junior Member

sorry people i didn't see your posts ,,
i think the instructor point is that i should display them in Hierarchical display of the tablespaces and datafiles
i asked the instructor if he was mistaken with the name "Tree" but he said "no i ment tree !! :("

Report message to a moderator

Re: Question about viewing "tree tablespace" [message #458146 is a reply to message #458145]

Thu, 27 May 2010 10:16

Najdmr
Messages: 6
Registered: May 2010

Junior Member

Quote:

As per my understading; you whould have to check Hierarchical display of the tablespaces and datafiles (like Tablespace free/used space, status of tablespace , current size etc.. etc.. ). Once again check with your assigne.

Exactly ,, i wrote my post befor seeing yours,
you mean that hi have to make the following query:
col file_name format a50
col tablespace_name format a10

SELECT file_name, tablespace_name, ROUND(bytes/1024000) MB,status
FROM dba_data_files
ORDER BY 1;

Report message to a moderator