| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Fragmented System Tablespace
A copy of this was sent to "Michael Krall" <mike_krall_at_email.msn.com>
(if that email address didn't require changing)
On Sun, 20 Sep 1998 03:00:45 -0400, you wrote:
>I have a question about the system tablespace. I have 5 or 6 tables with
>more then 15 extents. Can I export / import the tables within the system
no. it won't matter anyway -- having 1, 100, 1000 extents does not affect performance, especially with indexed reads (it may affect performance of a full scan if your extents are not multiples of your multi block read count).
don't do it.
>tablespace without damaging the instance ? If I can would a new analyze of
>my production data & indexes be in order ?
>
no -- even if you could do this, reorging a table in the system tablespace would have no affect on the statistics collected on a table in another tablespace (or even another table in the same tablespace).
>Any help would be greatly appreciated.
>
>Thanks
>Michael Krall
>Senior Systems Engineer
>Safety 1st
>mkrall_at_safety1st.com
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Sep 20 1998 - 09:25:08 CDT
 |
 |