Home » RDBMS Server » Performance Tuning » rdbms 12.2C performance issues sometimes (RDMS oracle 12C linux ODA HW)
rdbms 12.2C performance issues sometimes [message #687685] Fri, 05 May 2023 10:49 Go to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
hello all
we have a database 12c LINUX RAC on ODA, using the same job and same data over and over the performance varies from 30 seconds to hours,  i have looked a the plan and is the same but points to CPU which is high, I have a ticket open with Oracle they are telling me is the CPU which is slow, but why would work sometimes the host same data same everything.

Has anyone seen any issues with  ODA performance?


Time & Wait
Duration
6.98 h
Database Time
6.98 h
PL/SQL & Java
0 s
Wait Activity
100%
I/O
Buffer Gets
9,170 M
I/O Requests
3,328
I/O Byt
Re: rdbms 12.2C performance issues sometimes [message #687686 is a reply to message #687685] Fri, 05 May 2023 12:16 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You would need to look at the wait events, they should explain what is happening. If you have the AWR licence (most ODA environments do) generate reports that cover the fast and the slow runs and then SQL reports for the problem statements.
Re: rdbms 12.2C performance issues sometimes [message #687687 is a reply to message #687686] Fri, 05 May 2023 12:20 Go to previous messageGo to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
thank you, yes i have done that already,  oracle says is CPU but if is CPU why would the  job run sometimes good others not?  
I found this, however we have a higher version of ODA and db
Alert - ODA: Extreme Slow IO Performance including: Possible Hang, Poor Disk or Diskgroup Performance with Low IO but High CPU Utilitization (Doc ID 2189437.1)
Re: rdbms 12.2C performance issues sometimes [message #687688 is a reply to message #687687] Fri, 05 May 2023 12:26 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
If you post the reports here, perhaps someone can advise. For example, if it really is the same plan and the same data, then the answer would likely be run time variables: all the things that happen after the parse. Eg, the choice between serial and direct read; the adaptive features; and, of course, all the wait events that are related to runtime variables. The reports will make this clear.
Re: rdbms 12.2C performance issues sometimes [message #687697 is a reply to message #687688] Thu, 11 May 2023 08:58 Go to previous message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
thank you , found the problem its a disk problem
Previous Topic: Sql having performance issue
Next Topic: Cannot force indexing on alert log query
Goto Forum:
  


Current Time: Thu Mar 28 14:36:24 CDT 2024