Boa tarde , você pode fazer um shrink dessa tabela
ALTER TABLE table_name SHRINK SPACE CASCADE;
Abs
espero ter ajudado.
--------------------------------------------
Em qua, 25/11/15, 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br]
<oracle_br@yahoogrupos.com.br> escreveu:
Assunto: RES: [oracle_br] Tabela Fragmentada
Para: oracle_br@yahoogrupos.com.br
Data: Quarta-feira, 25 de Novembro de 2015, 15:43
Boa Tarde
Emerson,A principio não tem
como particionar essa tabela, gostaria de fazer uma
manutenção nesta tabela antes. Fiz um ALTER TABLE
MOVE para outra tablespace, mas não consegui recuperar os
4GB, outra coisa seria recuperar os blocos
livres Grato,Ednilson De: oracle_br@yahoogrupos.com.br
[mailto:oracle_br@yahoogrupos.com.br]
Enviada em: quarta-feira, 25 de novembro
de 2015 15:07
Para:
oracle_br@yahoogrupos.com.br
Assunto:
Re: [oracle_br] Tabela Fragmentada Boa Tarde
Ednilson,
Existe
possibilidade de você particionar esta tabela em outros
tablespaces? Isso já ajudaria a leitura e escrita feita
pelo Oracle no SO. Segue abaixo, exemplo de
implementação:http://www.fabioprado.net/2011/02/criando-tabelas-particionadas-para.html
Att,Emerson S.
Gaudêncio 2015-11-25 13:44 GMT-03:00
'Ednilson Silva' ednilson.si...@jbs.com.br
[oracle_br] <oracle_br@yahoogrupos.com.br>:
Pessoal,Tenho uma tabela, que sofre muitos
Updates/Inserts/Deletes, e gostaria de saber como posso
estar fazendo uma manutenção nesta tabela afim de melhorar
o desempenho nela?
NUM_ROWS
TABLE_NAME size (mb) actual_data (mb)
wasted_space (mb)---------- ------------------
---------- ---------------- ----------------- 75886553 COM_NOTA_PRODUTO
22550
17948 4602 SQL> select blocks "Blocos
Usados", 2 empty_blocks "Blocos
Livres",
3 num_rows "Total de Linhas"
4 from
user_tables 5 where
table_name='COM_NOTA_PRODUTO'; Blocos Usados Blocos Livres Total
de Linhas------------- -------------
---------------
2886385 29
75886553 SQL> SELECT * FROM
DBA_TABLESPACES WHERE
TABLESPACE_NAME='COMD'; TABLESPACE_NAME
BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN
STATUS CONTENTS LOGGING FORCE_LOGGING
EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN
SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION
BIGFILE PREDICATE_EVALUATION ENCRYPTED
COMPRESS_FOR------------------------------
---------- -------------- ----------- -----------
----------- ---------- ------------ ---------- ---------
--------- --------- ------------- -----------------
--------------- ---------- ------------------------
------------------- ----------- ------- --------------------
--------- ------------COMD
8192
65536 1 2147483645 2147483645
65536 ONLINE PERMANENT LOGGING
NO LOCAL
SYSTEM NO
AUTO
DISABLED NOT APPLY NO
HOST NO
Oracle Database Enterprise 11g -
(Release 11.2.0.4) Grato,Ednilson
Silva
#yiv7143255445 #yiv7143255445 --
#yiv7143255445ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv7143255445 #yiv7143255445ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv7143255445 #yiv7143255445ygrp-mkp #yiv7143255445hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv7143255445 #yiv7143255445ygrp-mkp #yiv7143255445ads {
margin-bottom:10px;}
#yiv7143255445 #yiv7143255445ygrp-mkp .yiv7143255445ad {
padding:0 0;}
#yiv7143255445 #yiv7143255445ygrp-mkp .yiv7143255445ad p {
margin:0;}
#yiv7143255445 #yiv7143255445ygrp-mkp .yiv7143255445ad a {
color:#0000ff;text-decoration:none;}
#yiv7143255445 #yiv7143255445ygrp-sponsor
#yiv7143255445ygrp-lc {
font-family:Arial;}
#yiv7143255445 #yiv7143255445ygrp-sponsor
#yiv7143255445ygrp-lc #yiv7143255445hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv7143255445 #yiv7143255445ygrp-sponsor
#yiv7143255445ygrp-lc .yiv7143255445ad {
margin-bottom:10px;padding:0 0;}
#yiv7143255445 #yiv7143255445actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv7143255445 #yiv7143255445activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv7143255445 #yiv7143255445activity span {
font-weight:700;}
#yiv7143255445 #yiv7143255445activity span:first-child {
text-transform:uppercase;}
#yiv7143255445 #yiv7143255445activity span a {
color:#5085b6;text-decoration:none;}
#yiv7143255445 #yiv7143255445activity span span {
color:#ff7900;}
#yiv7143255445 #yiv7143255445activity span
.yiv7143255445underline {
text-decoration:underline;}
#yiv7143255445 .yiv7143255445attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv7143255445 .yiv7143255445attach div a {
text-decoration:none;}
#yiv7143255445 .yiv7143255445attach img {
border:none;padding-right:5px;}
#yiv7143255445 .yiv7143255445attach label {
display:block;margin-bottom:5px;}
#yiv7143255445 .yiv7143255445attach label a {
text-decoration:none;}
#yiv7143255445 blockquote {
margin:0 0 0 4px;}
#yiv7143255445 .yiv7143255445bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv7143255445 .yiv7143255445bold a {
text-decoration:none;}
#yiv7143255445 dd.yiv7143255445last p a {
font-family:Verdana;font-weight:700;}
#yiv7143255445 dd.yiv7143255445last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv7143255445 dd.yiv7143255445last p
span.yiv7143255445yshortcuts {
margin-right:0;}
#yiv7143255445 div.yiv7143255445attach-table div div a {
text-decoration:none;}
#yiv7143255445 div.yiv7143255445attach-table {
width:400px;}
#yiv7143255445 div.yiv7143255445file-title a, #yiv7143255445
div.yiv7143255445file-title a:active, #yiv7143255445
div.yiv7143255445file-title a:hover, #yiv7143255445
div.yiv7143255445file-title a:visited {
text-decoration:none;}
#yiv7143255445 div.yiv7143255445photo-title a,
#yiv7143255445 div.yiv7143255445photo-title a:active,
#yiv7143255445 div.yiv7143255445photo-title a:hover,
#yiv7143255445 div.yiv7143255445photo-title a:visited {
text-decoration:none;}
#yiv7143255445 div#yiv7143255445ygrp-mlmsg
#yiv7143255445ygrp-msg p a span.yiv7143255445yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv7143255445 .yiv7143255445green {
color:#628c2a;}
#yiv7143255445 .yiv7143255445MsoNormal {
margin:0 0 0 0;}
#yiv7143255445 o {
font-size:0;}
#yiv7143255445 #yiv7143255445photos div {
float:left;width:72px;}
#yiv7143255445 #yiv7143255445photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv7143255445 #yiv7143255445photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv7143255445 #yiv7143255445reco-category {
font-size:77%;}
#yiv7143255445 #yiv7143255445reco-desc {
font-size:77%;}
#yiv7143255445 .yiv7143255445replbq {
margin:4px;}
#yiv7143255445 #yiv7143255445ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv7143255445 #yiv7143255445ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv7143255445 #yiv7143255445ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv7143255445 #yiv7143255445ygrp-mlmsg select,
#yiv7143255445 input, #yiv7143255445 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv7143255445 #yiv7143255445ygrp-mlmsg pre, #yiv7143255445
code {
font:115% monospace;}
#yiv7143255445 #yiv7143255445ygrp-mlmsg * {
line-height:1.22em;}
#yiv7143255445 #yiv7143255445ygrp-mlmsg #yiv7143255445logo {
padding-bottom:10px;}
#yiv7143255445 #yiv7143255445ygrp-msg p a {
font-family:Verdana;}
#yiv7143255445 #yiv7143255445ygrp-msg
p#yiv7143255445attach-count span {
color:#1E66AE;font-weight:700;}
#yiv7143255445 #yiv7143255445ygrp-reco
#yiv7143255445reco-head {
color:#ff7900;font-weight:700;}
#yiv7143255445 #yiv7143255445ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv7143255445 #yiv7143255445ygrp-sponsor #yiv7143255445ov
li a {
font-size:130%;text-decoration:none;}
#yiv7143255445 #yiv7143255445ygrp-sponsor #yiv7143255445ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv7143255445 #yiv7143255445ygrp-sponsor #yiv7143255445ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv7143255445 #yiv7143255445ygrp-text {
font-family:Georgia;}
#yiv7143255445 #yiv7143255445ygrp-text p {
margin:0 0 1em 0;}
#yiv7143255445 #yiv7143255445ygrp-text tt {
font-size:120%;}
#yiv7143255445 #yiv7143255445ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7143255445
