Saturday, May 27, 2006

Tips & Tricks

Q.: How to see installed options like Oracle Text,OLS etc.
A.: select * from v$option

Read more

On my XE the result was:
(54 rows returned)

Real Application ClustersFALSE
Advanced replicationFALSE
Bit-mapped indexesFALSE
Connection multiplexingTRUE
Connection poolingTRUE
Database queuingTRUE
Incremental backup and recoveryTRUE
Instead-of triggersTRUE

1 comment:

Pipirilo said...

Very nice!
I got SPATIAL = TRUE. That means I have ORACLE Spatial installed, right?