COMMIT without changes in database
Hi,
We are tuning a database, and we have seen the application (java) does commit when user move to another page regardless of whether it´ve run a DML or not. If user only has execute a SELECT and advance to another page in application, it runs a COMMIT too.
We run AWR and we see wait event "log file sync".
Now, we need to know how a lot of COMMITs without change can induce a bad performance, or we need know if theses COMMITs doesn´t penalize.
Can you help us?
Thanks,
Laura.
We are tuning a database, and we have seen the application (java) does commit when user move to another page regardless of whether it´ve run a DML or not. If user only has execute a SELECT and advance to another page in application, it runs a COMMIT too.
We run AWR and we see wait event "log file sync".
Now, we need to know how a lot of COMMITs without change can induce a bad performance, or we need know if theses COMMITs doesn´t penalize.
Can you help us?
Thanks,
Laura.
0