Oracle Database – ’spfile‘ in einem Single-Instance-System & für einen Parameter mehrere Einträge
DEMODB@> select sid,name,value from v$spparameter where name=’optimizer_index_cost_adj‘
2 ;
SID NAME VALUE
———- —————————— ——————————
* optimizer_index_cost_adj 100
DEMODB optimizer_index_cost_adj 110
2 rows selected.
This entry was posted on Montag, Februar 8th, 2021 at 20:45 and is filed under Administration, ORACLE Database. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.