find physical partition to move tablespace

[oaliev04]

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)
Question.
1) find the tablespace or datafile in which physical hdd allocated
2)move tablespace to different physical hdd inside one vol group
thanx

 

[LKBrwnDBA]

Try:

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

 

[oaliev04]

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

 

[fredericofonseca]

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.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[LKBrwnDBA]

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