0

A schema grows daily, more then data is added. According to table sizes the data in the tables is 2750.

The tables spaces are as follows: enter image description here

In storage management is see:

Name#Size#Available#Percentage_used

schema_name#12239#1363078#0.01

enter image description here

As the backup of the schema grows we have also noticed performance slowing down (not really significant).

Compressed backup size = 3.7 gb

How can I reduce the space used and are the tbsp_page_sizes to large?

I need commands/steps to reduce the backup sizes and stop performance degradation over time.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.