EE or SE, to enterprise or not to enterprise

To determine if your oracle DB is enterprise or not, run the following SQL:

select product, version from product_component_version;

Standard will reveal:

Oracle Database 10g enterprise edition for EE

Oracle Database 10g for SE

you can do a select from DBA_FEATURE_USAGE_STATISTICS to see how much people have been using things they should not be using.