glide.db.oracle.ps.pool.size The glide.db.oracle.ps.pool.size property defines the size of the Oracle prepared statement cache for each database connection. Admins should consider adjusting this value to optimize performance based on application workload and database interactions.
5The answers below summarize the purpose, scope, default effect, and review scenarios for this property.
| What does it do? | This property sets the number of prepared statements that can be cached per Oracle database connection, impacting query performance and resource utilization. |
|---|---|
| What area does it affect? | Database connection management |
| What does the default mean? | The default value is "5", which sets the baseline numeric behavior for this property. |
| When should you review it? | Review this property when optimizing database performance or troubleshooting connection issues. |
Raw metadata from the property record.
| Property name | glide.db.oracle.ps.pool.size |
|---|---|
| Sys ID | 54d015970a0a0a650052a67fb4cc8178 |
| Type | integer |
| Application | Global |
| Default value | 5 |
| Description | Size of the Oracle prepared statement cache (per connection): |
| Updated | 2024-05-25 03:38:59 |
Official references and nearby text excerpts where this property appears.
glide.dbOther properties in the same namespace.
glide.db.foreign_suport
This property determines whether foreign database connections are supported in the ServiceNow instance, impact
glide.db.instant_alter.enabled
It allows the application to utilize faster database schema alterations, improving performance during updates.
glide.db.oracle.ps.delete
This property configures the system to utilize prepared statements for delete operations in Oracle, improving
glide.db.oracle.ps.insert
This property configures the system to utilize prepared statements for executing insert operations in Oracle d
glide.db.oracle.ps.query
This property configures the system to utilize prepared statements for executing queries against Oracle databa
glide.db.oracle.ps.update
This property configures the system to utilize prepared statements for updates in Oracle, improving efficiency
glide.db.passthrough.func.allowlist_default
It defines a default set of SQL functions that can be executed in passthrough mode, impacting database interac
glide.db.peripheral_table_fixer.table_list
This property defines a list of peripheral tables, such as sys_attachment, sys_journal_field, and sys_audit, t