SN System Properties Reference
Property reference

glide.db.oracle.ps.query

The glide.db.oracle.ps.query property enables the use of prepared statements for system-executed queries in Oracle databases. Admins should ensure this property is enabled to optimize performance and security during database interactions.

Default: true Type: boolean Application: Global

Key questions about this property

The answers below summarize the purpose, scope, default effect, and review scenarios for this property.

What does it do? This property configures the system to utilize prepared statements for executing queries against Oracle databases, enhancing efficiency and security.
What area does it affect? Database performance and security
What does the default mean? The default value is "true", which means this behavior is enabled by default.
When should you review it? Review this property when optimizing database interactions or troubleshooting query performance.

Out of the box property record

Raw metadata from the property record.

Property name glide.db.oracle.ps.query
Sys ID 54ceade80a0a0a6500ee68b1259eabfb
Type boolean
Application Global
Default value true
Description For Oracle, use prepared statements for system-executed queries.
Updated 2024-05-25 03:38:59

Sources

Official references and nearby text excerpts where this property appears.

Documentation excerpt View supporting context
Context preview Snippet 1
... time specified in milliseconds as ddd hh:mm:ss. • none: Disables automatic number formatting (for example, changes 2,500–2500). Note: This attribute applies only to display values and not user input values. glide.db.oracle.ps.query true/false any table If present and false, prevents the use of Oracle prepared queries on the table. global_visibility true/false any table with a sys_domain column If present or true, makes ...