Controls whether table and column descriptions are returned via the platform metadata APIs and sys_tables / sys_views / sys_tablecolumns.

Data Type

bool

Default Value

false

Remarks

By default, table and column descriptions are not shown in the system tables of the server, since the Oracle OCI service is designed such that the server must internally perform time-consuming additional join operations to retrieve this metadata.

When this connection property is set to True, the server returns table and column descriptions in system tables, but the join operations required to return these results leads to reduced performance for metadata operations on large datasets.