Hello folks,
We have two database hosted on one server. Oracle version is 11G release 3,Servers are having high I/O spikes, Total 4 cores is assign to server, Server have 16GB of memory. Please advise me the way to fix the problem of I/O, only oracle process is taking spikes, when we turn off database server then everything is fine. SGA size is 8GB.
Please suggest.