You a great god, and ask the recent database slow, I/O waiting time is very long, addm analysis always prompt db_cache_size is not big enough, but the big db_cache_size database outofmemery, 1.5 T libraries, 256 gb of memory machine, sga_max_size168G, db_cache_size 110 g, pga25G, how to optimize?

CodePudding user response:

Actually can try automatic memory management mode

CodePudding user response:

Database optimization, in most cases is SQL optimization, parameters of a little pot, who runs AWR ~ day time

CodePudding user response:

Who runs awr report access database under the slow time

CodePudding user response:

From the point of your presentation, this seemingly has not problem, database level configuration is high enough, should be the problem of disk, IO have bottleneck, with SSD estimates will be better

CodePudding user response:

Too general description, does not help solve the problem

CodePudding user response:

Basically determine your situation is: after + small memory
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Tuning:
1. Optimize the database layer calls, ensure db_cache size for hot cache data, but seems more difficult to implement
2. Simple and effective way: memory now. The server will be cheaper, and memory!!!!!!!!!!!!!!!!!!!! 256 g, it should not ah, we this 512 gb of memory are standard configuration