Revision [3500]

Last edited on 2009-08-23 23:22:39 by WikiAdmin
Additions:
In 11g,memory are managed by the ** memory_target and memory_max_target** parameters.

Revision [3499]

Edited on 2009-08-23 23:20:53 by WikiAdmin
Additions:
FROM sys.v_$parameter WHERE name = 'spfile';
==Change SGA==
SYS@etest> startup nomount
ORACLE instance started.
Total System Global Area 264241152 bytes
Fixed Size 1301408 bytes
Variable Size 216540256 bytes
Database Buffers 46137344 bytes
Redo Buffers 262144 bytes
SYS@etest> alter system set sga_target=250M scope=both;
System altered.
SYS@etest> alter database mount;
Database altered.
SYS@etest> alter database open;
Database altered.
Deletions:
FROM sys.v_$parameter WHERE name = 'spfile';

Revision [134]

Edited on 2007-04-14 21:30:24 by WikiAdmin
Additions:
{{parent page="Oracle"}}

Revision [76]

Edited on 2007-04-14 09:24:29 by WikiAdmin
Additions:
== pfile or spfile? ==
Deletions:
++ pfile or spfile?

Revision [75]

The oldest known version of this page was created on 2007-04-14 09:24:18 by WikiAdmin
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki