We're running into a random error that Oracle support (through some researching, not directly) indicated that we needed to increase the cursor_sharing, cached_cursor sizes and possiblly double the global shared area.
1. How do I check the current values for all of these?
2. How do I go about modifying these. I know the global shared area requires a restart.
Thanks in advance.