HomeОбразованиеRelated VideosMore From: Praveen Biyyapu

HOW TO INCREASE DECREASE MEMORY TARGET IN ORACLE 11G

11 ratings | 4902 views
How to increase/decrease memory_target in 11g ====================================================== oracle 10g --sga_target (parameter new in 10g) oracle 11g --memory_target (parameter new in 11g) How to check whether the parameter is static or dynamic? ========================================================= select name, value, issys_modifiable from v$parameter where name like '%&parameter%' ; if issys_modifiable=false --- parameter is static (database bounce required) if issys_modifiable=immediate --- parameter is dynamic (database bounce not required) (note: consider using spfile) sql commands ================ show parameter memory; alter system set memory_target=350m scope=spfile; alter system set memory_max_target=350m scope=spfile;
Html code for embedding videos on your blog
Text Comments (1)
John Miller (1 year ago)
This was so what I needed thanks for sharing.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.