I have been using this SQL*Plus command for a while now:
SQL> show spparameter service_names SID NAME TYPE VALUE
-------- ------------- ----------- ---------* service_names string REDX
And guess what ?
- The right syntax is actually
show spparameters(with a “s” at the end of it).
- It’s an 11g New Feature!
It doesn’t work with 10g:
SQL> show spparameters service_names SP2-0735: unknown SHOW option beginning "spparamete..." SP2-0735: unknown SHOW option beginning "service_na..."
I thought MySQL was trying to become as big as Oracle but it could be that Oracle is trying to become as cool as MySQL — it has had something like this for a long time! Now Oracle should add
SHOW TABLES too.
Anyway, this is really 11g’s most useful feature so far, though.
Interested in working with Grégory? Schedule a tech call.