OracleDatabaseInstancesFeatures (System Machine Context)

OctoSAM Machine context system query

This query is an integral part of the OctoSAM application. OctoSAM starts the query to display tabular data within the application. The query can only be started from within the intended application system context.

List installed Oracle instances with their installed products and features.

Fields

Name	Type	Visible	Description
Db Id	numeric	true
Instance Name	string	true
Database Name	string	true
Version	string	true
Database Role	string	true
Open Mode	string	true
Banner	string	true
Instance Last Scan	date	true
Tuning Pack	bool	true
Diagnostics Pack	bool	true
Ddl Logging	bool	true
Pdb Database Name	string	true
Product	string	true
Feature	string	true
Currently Used	bool	true
Last Sample Date	date	true
Detected Usages	numeric	true
Total Samples	numeric	true
First Usage Date	date	true
Last Usage Date	date	true
Extra Feature Info	string	true
Current Date Time	date	false	Date and time the query was run. For reference if you use and save query results.

Query information

Property	Value	Description
Query Guid	1d12e66c-8642-4904-bf5b-44569b323b89	The internal id of the query. Must be unique
SupportsDesktop	true	If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb	true	If true, the query can be started from the OctoSAM Web UI
LastUpdate	2026-02-21 17:20:39	Last change to this document
Build	1.12.3.52	OctoSAM build that last changed this document