search

k2v-academy / K2View-Academy

Other
0 stars 0 forks source link

Does Fabric use "select 1 from dual" query for internal ops on Oracle interface? #453

Closed pWIqmFHmGnqqlIyFDwZIlw1JWRHoo8AgicH1IWD closed 2 years ago

pWIqmFHmGnqqlIyFDwZIlw1JWRHoo8AgicH1IWD commented 2 years ago

Hi, Does Fabric use "select 1 from dual" query anywhere internally in the product for Oracle interfaces? If so, where and can it be disabled/reduced? The DBAs have reported it as one of the top queries in the AWR reports.

i7QC2njzxHCc0LYBqCh0HQf30xF2DYuJjqtFbNe commented 2 years ago

Hi,

Yes, we use this query in order to validate the connection when establishing the first connect and when reusing connection from the pool.

It is defined on the DataBase Type. if you want to change it to a different query you need to define a new DataBase Type From Template, follow print screen as an example

image

and refer your Oracle interface to the new DB type that you defined.

More details can be found in the following article:

https://support.k2view.com/Academy_6.5/articles/05_DB_interfaces/10_database_types.html