• Home
  • Linux
  • UNIX
  • Website Development
  • SAP Basis
  • SAP Solution Manager
  • SAP PI/XI
  • SLD

/sdf/rsoradld_new TIMEOUT and oracle dictionary statistics

We have long runtimes of the program /sdf/rsoradld_new during the data collection for the EarlyWatch Alert. This results in a timeout.
Read Note 1247198 – /SDF/RSORADLD_NEW timeout
In our case timeout occured on V$VIEW.
Solution:
Note 984955 – Timeout with selection of V$-Views
Note 838725 – Oracle dictionary statistics and system statistics

BRCONNECT command to create Oracle dictionary statistics:
OS> brconnect -u / -c -f stats -t oradict_stats
When you use this call, BRCONNECT internally calls the two procedures GATHER_DICTIONARY_STATS and GATHER_FIXEC_OBJECTS_STATS.

Creating Oracle system statistics (NOWORKLOAD) using brconnect
$ brconnect -u / -c -f stats -t system_stats

Creating Oracle system statistics (WORKLOAD) using brconnect
$ brconnect -u / -c -f stats -t system_stats -i <minutes>

« Unable to log on to system xxx in language yyy with user PIRWBUSER
Не работает st03 »
Еще по теме:
This entry was posted in SAP Basis and tagged EarlyWatch Alert, ORACLE.
Оставить Ответ
Click here to cancel reply.

  • Курсы валют

    RUB/USD - 69,1263

    RUB/EUR - 75,3348

  • Tags
    ABAP AIX AI_RUNTIME_JCOSERVER Arch Linux awk BPE brtools CHARM client copy cp CUA dd dev_w logs download basket download or upload files drivers EarlyWatch Alert epson ESR file system find firefox FTP GRUB HA systems hot keys HTTPS ibus icm Internet Explorer iso Java kernel keyboard language Linux Linux Mint logs Managed System Configuration mount mpv NWA ORACLE pacman PI Cache READ_USER RFC authorization robots.txt roles RWB RZ20 rz21 SAPCAR sapgui saposcol SAP Web Dispatcher SAP по русски Secure store Service Desk shared memory Shutter SLD sm21 sm59 SMD agent SOLAR_PROJECT_ADMIN spam ST03 STAD STMS STZAC Super L SUSE swap terminal text editors timezone tp Unix client Upgrade USB UTF-8 viber waterfox wordpress xterm YouTube youtube-dl zoom Альтернатива Windows Горячие клавиши Зависания Клавиша Win Кодировка Отмена перехода на зимнее время Температура процессора загрузка Excel минимальные требования к аппаратному обеспечению
  • Posts with most comments
    • SAP Solution Manager не работает отправка сообщения в SAP (4)
    • Error: Remote access to the NetWeaver Administrator is forbidden. See SAP Note 1451753 for details. (4)
    • AI_RUNTIME_JCOSERVER – Timeout while waiting for a connection to be established (2)
    • Script for UnSAPCAR Multiple SAR files in single shot (2)
    • Problem with stop/start saposcol (2)

© 2011 - 2023 30 years in IT. All Rights Reserved.