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).
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.