I am getting following error in alert log
ORA-01575: timeout waiting for space management resource
I just restarted the database it has goen away but I am not able to run any .sql files also I am, able to run query from sqlplus.
THIS IS ONE OF OUR PRODUCTION SERVER
Please help me
I am using oracle 126.96.36.199 on sun spark...
See Note:33567.1 at Metalink.
Are you using LMT or DMT?
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
1.Check out usage of Temporary Tablespace.
All the used temp segments have been cleared or not. If not check out parameter pctincrease value of the temporary tablespace.Check if the Temporary tablespace is temporary of not ?
Give the below parameter in your ini file
and start the db again
event = "10269 trace name context forever, level 1"
Click Here to Expand Forum to Full Width