Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Purge of the log table not releasing space #253

Open
KevinWalz opened this issue Aug 31, 2021 · 1 comment
Open

Purge of the log table not releasing space #253

KevinWalz opened this issue Aug 31, 2021 · 1 comment

Comments

@KevinWalz
Copy link

We have had an increase in the logged activity for the process we have written which has caused concerns with our DBA's concerning the amount of space being consumed in our production environment. I have made sure that we are only recording errors and warnings (this had been reset to defaults earlier in the week), We are also only retaining back one week, To clean up as much as possible I ran a purge of all records except warnings and errors. While it did remove a large number of records the space was not released. Is there a recommended process to free the space used by the logger table when a purge has been completed?

Below are the counts of records before and after the purge

Before

<style> </style>
TRUNC(TIME_STAMP) COUNT(*)
05/28/2020 00:00:00 1
08/23/2021 00:00:00 800,792
08/24/2021 00:00:00 880,383
08/25/2021 00:00:00 965,858
08/26/2021 00:00:00 3,446,552
08/27/2021 00:00:00 4,580,283
08/28/2021 00:00:00 4,742,126
08/29/2021 00:00:00 4,829,186
08/30/2021 00:00:00 1,390,725

After the purge

<style> </style>
TRUNC(TIME_STAMP) COUNT(*)
05/28/2020 00:00:00 1
08/24/2021 00:00:00 99,219
08/25/2021 00:00:00 111,753
08/26/2021 00:00:00 306,347
08/27/2021 00:00:00 701,502
08/28/2021 00:00:00 858,699
08/29/2021 00:00:00 897,930
08/30/2021 00:00:00 1,044,552
08/31/2021 00:00:00 416,667
@jeffreykemp
Copy link

I usually do an alter table shrink space: https://oracle-base.com/articles/misc/alter-table-shrink-space-online

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants