ORA-00823: Specified value of sga_target greater than sga_max_size

ORA-00823: Specified value of sga_target greater than sga_max_size

Solution:

Shutdown the database and change the value in pfile (sga_target = 3G)

Otherwise change the value of sga_max_size

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)