Update for anyone with a similar issue.
jFrog support had me run a query, select sum(length) from ds_DATASTORE;, to
determine if the garbage collector was running. The result was around 300GB
which is what we expect the size to be.
They then claimed that it was probably an Oracle fragmentation issue and
that I should tell our DBA "that the natural order of all tables in
Artifactory is irrelevant and so he can reclaim all tablespaces free space
at will."
The DBA responded that he ran alter table {our user schema}.DS_DATASTORE
modify lob (DATA) (shrink space cascade) which brought the total size from
800GB to 400GB.
Thanks for the help jFrog.
--
View this message in context:
http://forums.jfrog.org/Oracle-10g-database-for-Artifactory-using-3x-more-space-than-it-should-tp7206795p7243686.html
Sent from the Artifactory - Users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Artifactory-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/artifactory-users
