powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / Oracle [игнор отключен] [закрыт для гостей] / For Your Notepad!
1 сообщений из 1, страница 1 из 1
For Your Notepad!
    #32133437
Фотография Oracle X-pert
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Following the recommendation we got.
In brief
What can be implemented:
move each redo group to a separate non raid5, faster disk
move user tables from dictionary to locally managed tablespaces
What should be implemented if possible
change the application to reduce the number of commits
Following the text of the recommendations from the tar

High recursive CPU usage due to PL/SQL.
-----------------------------------------------------------

Statements in the "Top SQL Statements by Buffer Gets" should be tuned .
obtain SQL Trace / TKProf data from typical user sessions and look for statements comsuming the highest CPU. The "sort=fchcpu" option of TKProf is usually helpful in finding the worst statements.


High recursive CPU usage due to Oracle system operations
------------------------------------------------------------------------------------

In the "Dictionary Cache Statistics" table we notice : indicate space management operations are occuring and locally managed tablespaces should be used).


Get Pct Scan Pct Mod Final Pct
Cache Requests Miss Requests Miss Req Usage SGA
---------------------- ------------ ------ -------- ----- -------- ------ ----
dc_free_extents 53 11.3 3 0.0 15 10 37
dc_used_extents 6 50.0 0 6 21 62

These statistics indicate that space management operations are occuring and locally managed tablespaces should be used

2/ log file sync

To reduce this wait , you can make tuning at 2 levels

Application level:
-------------------------

if the application commit after every INSERT, rather than batching COMMITs. Applications can reduce this wait by committing after inserting a number of rows, rather than every row.

System level
------------------

use dedicated disks.
Move the redolog files from RAID 5 devices. RAID 5 is not efficient for writes.
Alternate redo logs on different disks to minimize the effect of the archiver on the log writer
...
Рейтинг: 0 / 0
1 сообщений из 1, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / For Your Notepad!
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]