cancel
Showing results for 
Search instead for 
Did you mean: 

System Import Sgen

Former Member
0 Kudos

Just did a system import, doing my post steps, ran stats/optimizer on my db, but my SGEN continues to fill my table space and fail, keep giving it tablespace and it continues to run out. What am i missing?

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

Check whether there is sufficient free space in the PSAPSR7NN tablespace.

If not extend it and repeat SGEN.

This is normal. Also watch out for the archived logs as well (assuming you have an Oracle database).

Regards

RB

Former Member
0 Kudos

Hi,

What is the error log..

Thanks

Rishi Abrol

Former Member
0 Kudos

Turned off Archive mode added some tablespace, resolved it no issues.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Joshua,

SGEN will require DB Space depending on your system. Running/Updating Optimizer stats will not have any effect on DB Size increasing due to SGEN.

I suggest you to extend ample space in your DB for SGEN & other activities.

Regards,

Mudasir.

manish_singh13
Active Contributor
0 Kudos

Which tablespace you are getting error for? Did you tried extending that tablespace?

Thanks,

Manish Singh

Former Member
0 Kudos

Hi Joshoua,

Please check your Archive log folder, that might be filling up.

Thanks

Adil