السلام عليكم ورحمة الله وبركاته


انا وانا جالسة انزل الاوراكل 11g

وضعت ال حجم ال process 150

ونصحني احد الاخوة انا اضعها 600 فهل من طريقة لتعديل ال process دون اغلاق ال داتابيس


افيدونا
شكرا لكم


منى
مبتدئة dba

ALTER SYSTEM SET processes=600 SCOPE=SPFILE;

first , you must restart the database for the modification to take effect
ALTER SYSTEM SET processes=600 SCOPE=SPFILE;
shutdown immediate
startup

ok thanks

i have 2 Instance configure

mona1@xyzd
mona1@xyzdb

now when i meake this configure
i should inter to each instance and do it write

or inter sys as sysdba

thanks
mona

you must connect to each instance separately and write the command on it

point clear

thanks
mona