About oxya_oxya2

oxya_oxya2 · 06-29-2009

Hello,We are experiencing troubles with online reorganization of tables on our BI7 with oracle 10.2.0.4 with brspace since the size of our tables after the reorganization is bigger than before.Our SAP system is at the following level:Software compone...

oxya_oxya2 · 03-27-2009

Dear Support,According to DB02 u201Ctablespace global viewu201D, the size of an Index tablespace is 60 GB and the free space is 10 GB. The u201Cdba_segmentu201D view of this tablespace (in DB02) shows us that the sum of the index sizes is less than 1...

oxya_oxya2 · 06-29-2009

Hello,There's nothing into the log about the drop table step. Nevertheless, as the reorganization has been performed with a move into another tablespace, the drop of the table into the old one does impact the size of the table into the new tablespace...

oxya_oxya2 · 06-29-2009

Hello,The SAP note 48180 is related to an oracle release 7 to 9. Currently we have oracle 10.2.0.4 and compared to the note we perform the reorganization with brtools (brspace) and not with sapdba.Our table in exemple at the beginning of this thread ...

oxya_oxya2 · 03-30-2009

Dear Support,As requested here are the details out of sql request :SQL> select round(sum(bytes)/1024) KB, count(*) nro, status from dba_data_files where tablespace_name = 'PSAPB3TABI' group by status; KB NRO STATUS- - - 61605520 ...

oxya_oxya2 · 03-27-2009

Hello,As requested here are the details out of DB02Sample :<h4>Tablespace Size (kb) Free (kb) Used (%) Tab/ind Extents AutoExt (kb) Used (%) Status ...

User Statistics

User Activity

Table increase with reorganization

Free space in Index Tablespace

Re: Table increase with reorganization

Re: Table increase with reorganization

Re: Free space in Index Tablespace

Re: Free space in Index Tablespace