| Multiple Tablespace in a Application [message #146423] |
Thu, 10 November 2005 06:18  |
sriha
Messages: 2
Registered: November 2005
|
Junior Member |
|
|
Hi,
We are developing an application which is transaction intensive. I heard if we create multiple tablespace we would have a better performance. Is this true?
Also, If i have different tablespace for Masters, transactions etc., Will i have problem in accessing it? Should i prefix the username while accessing the tables in another tablespace.
Thanks!
Sriha
|
|
|
|
| Re: Multiple Tablespace in a Application [message #146430 is a reply to message #146423] |
Thu, 10 November 2005 06:48  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Should i prefix the username while accessing the tables in another tablespace.
Not while accessing ( as long as the same user owns them).
You would create different objects in different tablespaces.
>>We are developing an application which is transaction intensive
How intensive?
several thousand concurrent transactions?
>>I heard if we create multiple tablespace we would have a better performance. Is this true?
Better performance, No.
Ease of administration/maintenance, yes.
Are you talking about separating tables and indexes too?
Table data and index data are accessed in serial. NOT in parallel.
If those tablespaces are placed in separate mount points, you may achieve I/O distribution to some extent. Still you cannot completely avoid it.
Use Locally Managed tablespaces with uniform extent size.
[Updated on: Thu, 10 November 2005 06:49] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
