Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


find physical partition to move tablespace

find physical partition to move tablespace

hi everybody.
i don't know my question conserns to this forum but i must share my opinion with you
i have installed el6 Oracle 10g
all proccess went in urgent time ,i didn't had time to split it in seperate vol groups
(6 physical disk joined one vol group)

After restoring cold backup productivity of database didn't increased
all vol group 1.6 Tb.
but database size max 20 gb.
analysing of database(tunning) i came to conclusion that many tablespace or datafiles are in one or max 2 physical hdd(it's my opinion)
(cuz one hdd 146gb database sie 20g)
1) find the tablespace or datafile in which physical hdd allocated
2)move tablespace to different physical hdd inside one vol group

RE: find physical partition to move tablespace



SELECT Tablespace_Name, File_Name 
  FROM Dba_Data_Files; 

The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

RE: find physical partition to move tablespace

it shows me the path in vol group.i want to know the place of files on system level(in which scsi disk)

RE: find physical partition to move tablespace

for filesystem information like that you need to post on the correct forum - and as you didn't specify OS used we can't direct you to it.

Now my opinion. if with a 20GB database you have performance issues then I would look better at how the Oracle instance is set and what else uses that machine. Such a tiny database on these days of cheap memory should be all held in memory so real constraints should be Memory allocated and number of processors allocated.


Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: find physical partition to move tablespace

Try something like this:


SELECT F.Group_Number
     , D.Name Disk_Name
     , D.PATH
     , G.Name Group_Name
     , Dbf.File#
     , Dbf.Name
  FROM V$asm_File F
     , V$asm_Disk D
     , V$asm_Diskgroup G
     , V$datafile Dbf
 WHERE D.Group_Number = F.Group_Number
   AND G.Group_Number = F.Group_Number
   AND G.Name = 'DATA1'
   AND Dbf.Name LIKE '+' || G.Name || '%'

The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close