Try SQL> select banner from v$version where BANNER like '%Edition%'; If it shows Enterprise means Oracle EE is running If it returns nothing we need to assume Oracle SE is running.
The use of the following init.ora parameter is licensed as part of the Oracle Change Management Pack when set to TRUE: ENABLE_DDL_LOGGING The default is FALSE.