Re: Double Underscore Sign In Parameters....
Date: Fri, 10 Oct 2008 05:51:09 +0200
Message-ID: <48eed12c$0$29830$426a74cc@news.free.fr>
"Aman Sharma" <amansharma1981_at_gmail.com> a écrit dans le message de news:
30135c20-c849-4d7c-b21a-7ebbfe3f210f_at_o4g2000pra.googlegroups.com...
| Hi there,
| DB: 11106
| OS: Win Xp Proff
| I understand that with the underscore prefixed , the parameters are
| called undocumented parameters. But I am seeing at times, parameters
| having 2 undrescores attached to it too. What's these parameters and
| why we have two underscores attached to them?
| For example,
| SQL> select ksppinm,ksppstvl,ksppstdvl
| 2 from x$ksppcv a,x$ksppi b
| 3 where a.indx=b.indx and b.ksppinm like '%shared_io%';
|
| KSPPINM KSPPSTVL
| KSPPSTDVL
| ------------------------------ ------------------------------
| ----------------
| __shared_io_pool_size 4194304 4M
| _shared_io_pool_size 4194304 4M
| _shared_iop_max_size 536870912 512M
| _shared_io_pool_buf_size 1048576 1M
| _shared_io_pool_debug_trc 0 0
| _shared_io_set_value FALSE FALSE
|
| 6 rows selected.
| You can see that the first one is having a double underscore attached.
| Similarly, in PGA also , there is __pga_aggregate_target parameter.
| If anyone can explain this, it would be really great.
| Thanks
| Aman....
They are dynamic values calculated by Oracle. You can see some of them in V$SGA_DYNAMIC_COMPONENTS.
Regards
Michel
Received on Thu Oct 09 2008 - 22:51:09 CDT