| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Size of segment
Sorry that I was not explicit .. If you are experiencing high Transactions
You need to put the Tables and Indexes on Different Tablespaces [ again
Uniformly Sized]
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 ============================================Live to learn... forget... and learn again.
-----Original Message-----
Sent: Monday, April 29, 2002 6:23 PM
To: Multiple recipients of list ORACLE-L
On Mon, Apr 29, 2002 at 05:13:22AM -0800, Ganesh Raja wrote:
> My Suggestion would be to give Uniform sized Extents and move the
> table and Index into that tablespace.
-- You are taking a preformance hit having the indexes and tables in the same tablespace, are you not? =============================================================== Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: stellr_at_cns.vt.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: ganesh_at_gtfs-gulf.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Apr 29 2002 - 09:43:25 CDT
 |
 |