[
https://issues.jboss.org/browse/JBTM-2716?page=com.atlassian.jira.plugin....
]
Michael Musgrove resolved JBTM-2716.
------------------------------------
Fix Version/s: 5.next
Resolution: Done
[quote] A couple of releases back oracle added a feature to automatically calculate
statistics for all tables, to aid the query planner in optimizing. These histograms live
in the system tablespace. And they continue to exist as long as the table does, even if
the table is in the recyclebin. So now the metadata about a table ain't quite so
small anymore, and we suddenly have a LOT of tables, on account of how they never go away
properly."
The command 'purge dba_recyclebin' command is the fix.
Oracle db is out of space
-------------------------
Key: JBTM-2716
URL:
https://issues.jboss.org/browse/JBTM-2716
Project: JBoss Transaction Manager
Issue Type: Task
Components: Testing
Affects Versions: 5.3.3.Final
Reporter: Michael Musgrove
Assignee: Jonathan Halliday
Fix For: 5.next
The jdbc tests that use our oracle db on the jenkins CI are failing with:
bq. unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
We need to clear up some space. An example of the problem is:
http://albany.eng.hst.ams2.redhat.com/job/narayana/PROFILE=QA_JTA,jdk=jdk...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)