Home » RDBMS Server » Server Administration » Business Objects Repository TableSpace issue
Business Objects Repository TableSpace issue [message #185207] Mon, 31 July 2006 09:02 Go to next message
mglynn
Messages: 4
Registered: July 2006
Location: London UK
Junior Member
Hi , bit new to this place but wondered if anyone had any ideas on the following.

Using oracle 9i as the Business Objects Repository, the disk space usage was getting rather high (14 Gig). The exports of the database were 14 gig at this point.
The BO Admin then removed about 50% of the reports and the export went down to 7gig and about 50% of the rows were removed from the documents table in the schema.
Here comes the problem, the tablespace for the Repository hasn't shrunk , even though the reports are gone and that the export file has shrunk.

Its as though the reports are orphaned off someone else (somewhere secret perhaps ) in the tablespace.



Re: Business Objects Repository TableSpace issue [message #185209 is a reply to message #185207] Mon, 31 July 2006 09:37 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
use alter table to move the obj_m_documents table. this will release the space used and allow you to resize the datafile using the alter database command.
Not, you will have to rebuild the indexes on the obj_m_documents table.


Jim
Re: Business Objects Repository TableSpace issue [message #185211 is a reply to message #185207] Mon, 31 July 2006 10:04 Go to previous messageGo to next message
mglynn
Messages: 4
Registered: July 2006
Location: London UK
Junior Member
I believe its the obj_x_table, still I've reindexed the indexes on both the _m_ and the _x_ , no improvement.

so moving the table will release space used ?
I didn't know that I will give it a try.

is this a known issue with BO ?
Re: Business Objects Repository TableSpace issue [message #185212 is a reply to message #185211] Mon, 31 July 2006 10:06 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
This has absolutely nothing to do with BO. and it's not an issue. This is how Oracle works. BO simply happens to be the application that is performing DML on the Oracle tables.

Jim

PS, when you export a document to corporate docs, the doc is stored in OBJ_M_DOCUMENTS AS WELL AS obj_x_DOCUMENT, YOU'LL NEED TO MOVE BOTH. Reindexing will do very little for you, untill you perform a Move.

[Updated on: Mon, 31 July 2006 10:11]

Report message to a moderator

Re: Business Objects Repository TableSpace issue [message #185216 is a reply to message #185207] Mon, 31 July 2006 10:26 Go to previous messageGo to next message
mglynn
Messages: 4
Registered: July 2006
Location: London UK
Junior Member
think I being a bit stupid here ,didnt explain myself properly excuse me please,

what I mean is that the used space in the tablespace hasn't shrunk, I dont expect the actual tablespace space size to shrink , but after removing 50% of the reports I would expect the used size to decrease. that is my issue.
or would the used space not decrease until I move the table

does that change anything ?

sorry
Re: Business Objects Repository TableSpace issue [message #185218 is a reply to message #185216] Mon, 31 July 2006 10:29 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Show me the sql you are using to find the used space.

Jim
Re: Business Objects Repository TableSpace issue [message #185334 is a reply to message #185207] Tue, 01 August 2006 04:40 Go to previous messageGo to next message
mglynn
Messages: 4
Registered: July 2006
Location: London UK
Junior Member
I'm using enterprise manager console to view the space used.

I think I am going to have to export the user , drop the user then re-import. unless there is an easier way ????????/

thanks for your help
Re: Business Objects Repository TableSpace issue [message #185354 is a reply to message #185334] Tue, 01 August 2006 05:35 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
alter table tablename move.
In all honesty, the space will be re-used anyway, so I would worry about it too much.
Previous Topic: Finding 32/64 bit?
Next Topic: Can't activate resource plan
Goto Forum:
  


Current Time: Thu Dec 08 16:41:09 CST 2016

Total time taken to generate the page: 0.06977 seconds