[jbossts-issues] [JBoss JIRA] (JBTM-2716) Oracle db is out of space

[Michael Musgrove (JIRA)]

     [ https://issues.jboss.org/browse/JBTM-2716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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=jdk8.latest,label=linux/1125/



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)