![]() |
|
#1
|
|||
|
|||
![]()
Performance Views
Configuration Advice
Statistics
Buffer Cache and subset pools
__________________
Телеграм чат Последний раз редактировалось Marley; 12.03.2010 в 09:19. |
#2
|
|||
|
|||
![]()
Tuning the Database Buffer Cache
Database read buffer cache hit ratio
--------------- PGA cache hit ratio -- PGA cache hit ratio = (bytes processed / (bytes processed + extra bytes read/written))*100 -----------------------------
![]() ----------------- -- buffer busy a free buffer waits ![]() ----------------- SELECT event "Event", total_waits "Waits", time_waited "Total"
__________________
Телеграм чат Последний раз редактировалось Marley; 21.09.2015 в 10:17. |
#3
|
|||
|
|||
![]()
Analyzing Sorting
select 'Sorts in Memory' "Ration", -- find SQL statements with high sorting amounts --heaviest impact
__________________
Телеграм чат |
#4
|
|||
|
|||
![]() select fs.phyrds "Reads" , fs.phywrts "Writes" , fs.avgiotim "Average I/O Time", df.name "Datafile" select fs.phyrds "Reads" , fs.phywrts "Writes" , fs.avgiotim "Average I/O Time", df.name "Datafile" SELECT ts.name AS ts, fs.phyrds "Reads" , fs.phywrts "Writes",
__________________
Телеграм чат Последний раз редактировалось Marley; 12.03.2010 в 10:02. |
#5
|
|||
|
|||
![]()
Locking
__________________
Телеграм чат Последний раз редактировалось Marley; 12.03.2010 в 10:27. |