Re: Difference between alter system and alter database?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 11 Jun 2003 20:42:35 +0100
Message-ID: <3ee78c6b_3@mk-nntp-1.news.uk.worldonline.com>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:dj4kbv0d902to5qh0rd7inqri4tuauhgk1_at_4ax.com...
> What is the difference between alter system and alter database?
> When do you use one over the other?
>

Rule of thumb:
alter system to change the instance characteristics (instance is temporary; SGA + background processes)
alter database to change the database characteristics (database is permanent; the files on the disks)

So for example, one would
alter system set job_queue_processes = 0 to disable all job processing until next time the instance is restarted (9i: subject I suspect to scope)
or
alter database rename global_name to something_else_at_office.com for a change which 'sticks'.

Regards,
Paul Received on Wed Jun 11 2003 - 14:42:35 CDT