Home » RDBMS Server » Server Administration » tablespace location on hard disk
tablespace location on hard disk [message #271542] Tue, 02 October 2007 00:26 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
Is it possible to place a tablespace on particular part of disk,
e.g I want to place one particular tablespace on outer part of disk and other on inner tracks of hard disk.
Re: tablespace location on hard disk [message #271548 is a reply to message #271542] Tue, 02 October 2007 00:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
outer part of disk and other on inner tracks of hard disk

What does it mean?

OS control in which track. You can't .
Re: tablespace location on hard disk [message #271559 is a reply to message #271542] Tue, 02 October 2007 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a volume group/logical volume/file system on the part of the disk you want.

Regards
Michel
Re: tablespace location on hard disk [message #271670 is a reply to message #271542] Tue, 02 October 2007 08:03 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
vijaychauhan wrote on Tue, 02 October 2007 01:26

e.g I want to place one particular tablespace on outer part of disk and other on inner tracks of hard disk.


I'd love to hear the reason to do this.
Re: tablespace location on hard disk [message #271674 is a reply to message #271670] Tue, 02 October 2007 08:18 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Maybe some of the data is better at taking corners?
Re: tablespace location on hard disk [message #271675 is a reply to message #271674] Tue, 02 October 2007 08:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
disk corner?! Laughing

Regards
Michel
Re: tablespace location on hard disk [message #271779 is a reply to message #271542] Tue, 02 October 2007 21:49 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

From corner data can jumps faster to oracle memory! Laughing
Previous Topic: Instance failure with Session and Process parameter
Next Topic: DB Admin-UTL_MAIL.SEND execution
Goto Forum:
  


Current Time: Sat Dec 03 06:08:37 CST 2016

Total time taken to generate the page: 0.09873 seconds