Display the Oracle database chararter set information
Explore language and locale configurations that shape data interpretation and presentation for globalized applications and accurate data handling.
SQL Code
1select * from nls_database_parameters 2/
Sample Oracle Output:
11 22SQL>
Purpose:
- To retrieve and …
Read MoreShow all the Oracle database used or installed Oracle features using dba_feature_usage_statistics
Discover which database features have been actively used, providing insights for license management, optimization, and future planning.
Show all the Oracle database installed features for an instance
SQL Code
1select name …
Read MoreIdentify if Java is installed in the Oralce database using all_objects
Gain visibility into the quantity of Java objects owned by the SYS user, aiding in understanding database usage and potential security considerations.
This will return 9000'ish if it is...
SQL Code
1select count(*) 2from all_objects 3where …
Read More