Dear friend,

i have a very strange problem
my database was too slow ...
then i increased pga_aggregate_target from 24m to 100m and increased db_cache_size from 400m to 640m
**************************

alert.log
=========

Thu Sep 27 15:26:25 2007
ALTER SYSTEM SET pga_aggregate_target='100M' SCOPE=BOTH;
Thu Sep 27 15:31:11 2007
ALTER SYSTEM SET shared_pool_size='560M' SCOPE=BOTH;
Thu Sep 27 15:32:11 2007
ALTER SYSTEM SET db_cache_size='648M' SCOPE=BOTH;

**************************

but when i restart the database all parmeters reset to old values .

**********************

SQL> show parameter db_cache_size

NAME TYPE VALUE
----------------- ----------- -------------
db_cache_size big integer 400M

SQL> show parameter pga_aggregate_target

NAME TYPE VALUE
------------ ----------- -------------
pga_aggregate_target big integer 24M

i create pfile from spfile ... the new values found

pfile
======

*.db_cache_size=679477248
*.pga_aggregate_target=104857600

and i noticed that the v$spparameter has null values for all parameters

SQL> select name,value from v$spparameter;

NAME VALUE
------------------ ------------------------------
tracefile_identifier
lock_name_space
processes
sessions
timed_statistics
timed_os_statistics
resource_limit
license_max_sessions
license_sessions_warning
cpu_count
db_cache_size
db_2k_cache_size
db_4k_cache_size
db_8k_cache_size
.
.
.
.

what is this ??????
please help me?

you must Make synchronizing between pfile and spfile
and which you use pfile or spfile to know that
run
SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_$parameter WHERE name = 'spfile';

Hi,
SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
2 FROM sys.v_$parameter WHERE name = 'spfile';

Init F
------
PFILE

but how ?
i start without pfile option !!!!

any change you make in spfile must make it in pfile
so after alter system that change made in spfile
so you must make pfile as spfile
so create pf file from spfile