[sap-basis] DB02, Alerts Database Check
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Maverick on Jul 31 at 3:23 PM |
DB02, Alerts Database Check
I got the following messages:
CRITICAL_FILE
File: /oracle/<sid>/sapdata1/sr3_1/sr3.data1, value: (max_extn) 7639040 KB (> 4358592 KB) # File autoextend can cause file system
I have to change the max_extn or turn off autoextend for data file. I want to turn off autoextend for all the datafiles, but just keep the last one datafile with autoextend, what do you think?
CRITICAL_TABLESPACE
Tablespace: PSAPSR3 # Tablespace files autoextend can cause file system overflow
I think I should turn off autoextend in all tablespaces to have a better control, but the problem I have is when I add a new datafile the space used in filesystem is increased and I don?t have a lot of space. I?m not sure if I should reduce the new datafile size or keep autoextend on.
Regards,
Mav
__.____._ I got the following messages:
CRITICAL_FILE
File: /oracle/<sid>/sapdata1/sr3_1/sr3.data1, value: (max_extn) 7639040 KB (> 4358592 KB) # File autoextend can cause file system
I have to change the max_extn or turn off autoextend for data file. I want to turn off autoextend for all the datafiles, but just keep the last one datafile with autoextend, what do you think?
CRITICAL_TABLESPACE
Tablespace: PSAPSR3 # Tablespace files autoextend can cause file system overflow
I think I should turn off autoextend in all tablespaces to have a better control, but the problem I have is when I add a new datafile the space used in filesystem is increased and I don?t have a lot of space. I?m not sure if I should reduce the new datafile size or keep autoextend on.
Regards,
Mav
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
How Can Predictive Analytics Drive Competitive Advantage? Find out here
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
