Why increase shared pool size

You can unsubscribe at any time. Hi, increase it in the init. Note that the number given there is in bytes. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account.

Learn more. Oracle 11g increasing shared pool size and java pool size Ask Question. Asked 8 years ago. Active 7 years, 7 months ago. Viewed 15k times. Thanks for the help. Improve this question. Shann Shann 1 1 gold badge 1 1 silver badge 4 4 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Would be grateful to get your opinion on my issue here dba. Finland Posts 3, I tried to increase the size also.

It prompts the same error. Could U help me. How much are those values? Could you please post the init. Could u please post the shared pool size parameter of ur database from init. DB is Oracle 9. Hi Julian, This is my Init.