Sign up
Log in
My Platform
Tools
Tools
Go back
Downloads
IPP
Licensing
Learn
Learn
Go back
Training
Welcome
Guided Paths
Training Planner
Courses
Tech Talks
Classroom
Certifications
Documentation
Overview
OutSystems 11
Best Practices
How-to Guides
Community
Community
Go back
Home
Jobs
Forums
Forge
Ideas
Members
Badges
Support
OutSystems.com
Sign up
Log in
Community
›
Ideas
›
Database Housekeeping
Advanced Search
2
Followers
31
Likes
Database Housekeeping
Pedro Matias
Pedro Matias
Outsystems Factory Manager - Tech Lead
at
NOS
+ 2
#23 482
in Community Rank
Database
Implemented
on 27 Apr 2015
OutSystems 9
After some years of development, the OutSystems database that supports a DEV environment have a lot of unused tables, attributes, system data, and also the process to remove the unused espaces doesn't shrink the CLOB's data (ORACLE) and neither remove the spaces that are producers to another unused espaces.
Regarding the CLOB's, it's necessary to execute a manual process to shrink the tablespace.
To maintain the database healthy and tuned, I think that a processes to housekeeping the database will be a nice to have on OutSystems Platform.
Regards,
Pedro Matias
Created on 9 Mar 2012
Comments (1
)
Gonçalo Borrêga
27 Apr 2015
Gonçalo Borrêga
Sr. Director, Product Management
at
OutSystems
+ 3
#0
in Community Rank
The new DbCleaner API was designed for this purpose. Check
the documentation
to understand the required privileges when using it.
As a lot of you mentioned, this is a very sensitive operation that we must ensure is only performed by the right person and under the right conditions. Therefore we will not make it available from the Studio.
This component
at the Forge shows a small example of how to use the API. You can use it to adapt to your own security restrictions and policies.
Regarding shrinking and other database maintenance tasks, we'll leave that for your DBA's defined maintenance plans, or, in the cloud, do it automatically for you!
views
1015
Followers
2
Loading...
Loading
(hidden) New Badge Popup