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)

Partitioning	FALSE
Objects	TRUE
Real Application Clusters	FALSE
Advanced replication	FALSE
Bit-mapped indexes	FALSE
Connection multiplexing	TRUE
Connection pooling	TRUE
Database queuing	TRUE
Incremental backup and recovery	TRUE
Instead-of triggers	TRUE
[...]	[...]