Posted on 2011-10-19
I was assigned to assist a group with some 11gR2 issues.
They say they keep getting tablespace and segment errors.
I am not familiar with their database or the client they use.
The DB schema is created by an SAP metadata client application used to collect and analyze data.
What would be a good starting point to get familiar with the DB configuration and setup.
would you request a copy of the recent oracle alert log?
would you ask them to print the all the v$parameter to get familiarsized how things are configured?
would you check for system trace files to see if there are issues with backgroung processes?
Can you provide some steps on checking things out (more related to storage).