Hi All
There was a deployment done recently in a Spatial GIS Oracle database, after which server utilization just got doubled, and users started experiencing delayed response time wrt queries (Select/DML both).
They did Model changes (specific to Spatial DB) and few update statements too.
SGA of database is 22 GB.
I noticed that ADDM gave some recommendations like host paging problem, suggestion to increase memory to 28 GB from 22 GB, sql tuning.
AWR didn't show any alarming issue.
1) Can you suggest me which things to look for getting cause of problem ? I have heard that Spatial DBs need more resources, so adding more RAM on host and SGA in DB, will help ?
2) Can you tell me the scripts I can use for DB monitoring during peak hours ? I will appreciate more info about what to look via the DB monitoring.
3) Also, how can I monitor (and what things to look for) the instance process on AIX ?
Thanks.