Another story of Oracle Support frustration
### Problem Description and its duration: ###
dbsnmp process is consuming gigs of memory and swap and eventually froze the database after filling the files system. The swap was 4 gig at it's highest. A trace file in network/trace was continually being written to and is 10gig by the time i stopped the agent. when i stopped the agent (agentctl stop agent) all the memory was release and the database freed.
### Oracle support response:
Database and application (query) tuning is an interactive process that requires a complete understanding of the environment where the database resides (database, operating system, application, etc). Standard product support services provides solutions to bugs that may affect the performance of the database and its components. Support may also provide general recommendations to start the tuning process.
Click Here to Expand Forum to Full Width