16.10.20 12:24:15 -- UTC+3
16.10.20 12:24:17 -- Current sysdate : 2020-10-16 12:24:17.0
16.10.20 12:24:17 -- ClientID: KAMAVTO.SERVER.***
16.10.20 12:24:17 -- HostName : ***
16.10.20 12:24:17 -- Local IP : ***
16.10.20 12:24:17 -- External IP : ***
16.10.20 12:24:17 -- DB names : KAMAVTO - KAMAVTO - KAMAVTO
16.10.20 12:24:17 -- ClientNum : 339
16.10.20 12:24:17 -- Oracle version: 10.2.0.4.0
16.10.20 12:24:17 -- Last optimizer run : 10:56:42 16.10.2020
16.10.20 12:24:17 -- Registered version. License will expired at : 24.11.20
16.10.20 12:24:18 -- Home : D:\oracle\ora10
16.10.20 12:24:18 -- Hosts : KAMA\SERVER-22; SERVER-18; KAMA\ADMIN_DVOR-3; TOVAROVED1\TOVAROVED1-3; ADMIN_DVOR\ADMIN_DVOR-3; ZAPASKA\ZAPASKA-3; KAMA\PROVIZORDVOR-3; KAMA\ZAPASKA-3; Zamsis_Smol\ZAMSIS_SMOL-3; PROVIZORDVOR\PROVIZORDVOR-2; BUH-1-3\BUH-1-3-2; KAMA\ZAPASKA
16.10.20 12:24:18 -- Modules : Sm.Main.exe-25; Sm.AppServer.exe-8; Sm.Post.Server.exe-7; Sm.Cash.Server.exe-3; rman.exe-2; backup full datafile-1; Optimizer
https://olegon.ru-1; sqlplus.exe-1
16.10.20 12:24:18 -- Statuses : ACTIVE-20; INACTIVE-47
16.10.20 12:24:18 -- Types : USER-50; BACKGROUND-17
16.10.20 12:24:18 -- Server : DEDICATED-67
16.10.20 12:24:18 -- Database size : 71Gb / 155Gb
16.10.20 12:24:19 -- Locked objects .......
16.10.20 12:24:19 -- Кассовый модуль-SUPERMAG-KAMA\SERVER-NT AUTHORITY\SYSTEM
16.10.20 12:24:19 -- Критическая секция-SUPERMAG-KAMA\SERVER-SYSTEM
16.10.20 12:24:19 -- Расходная накладная-KUZMINA-KAMA\ZAPASKA-SERVER\Гость
16.10.20 12:24:19 -- Сервер приложений-SUPERMAG-KAMA\SERVER-SYSTEM
16.10.20 12:24:19 -- Locked objects ^^^^^^^
16.10.20 12:24:19 -- 39 days until the optimizer licence expiration
16.10.20 12:24:20 -- Current SQL queries .......
16.10.20 12:24:20 -- 189-50-7nca6wzydq8nr-09:52 16.10-SUPERMAG-3-pipe get-3-0-Sm.AppServer.exe-SYSTEM-KAMA\SERVER-Sm.AppServer.exe-DEDICATED-Begin Supermag.Core.NextMessage(rq=>:v0, rqData=>:v1, err_code=>:v2, rqResult=>:v3, replyAddress=>:v4); End;-SELECT SID FROM DBMS_ALERT_INFO WHERE NAME = UPPER(:B1 )
16.10.20 12:24:20 -- 141-19315--12:23 16.10--57-jobq slave wait-57-0--SYSTEM-SERVER-ORACLE.EXE (J000)-DEDICATED--
16.10.20 12:24:20 -- Current SQL queries ^^^^^^^
16.10.20 12:24:20 -- SQL queries by count .......
16.10.20 12:24:20 -- 4gd6b1r53yt88 - 2
16.10.20 12:24:20 -- g2dv0x53pp5gs - 1
16.10.20 12:24:20 -- 7nca6wzydq8nr - 1
16.10.20 12:24:20 -- SQL queries by count ^^^^^^^
16.10.20 12:24:20 -- Resource limits .......
16.10.20 12:24:20 -- name : processes - curr : 68, max : 303, limit : 400
16.10.20 12:24:20 -- name : sessions - curr : 75, max : 319, limit : 445
16.10.20 12:24:20 -- name : parallel_max_servers - curr : 0, max : 64, limit : 3600
16.10.20 12:24:20 -- name : enqueue_locks - curr : 62, max : 366, limit : 6110
16.10.20 12:24:20 -- name : max_rollback_segments - curr : 38, max : 38, limit : 65535
16.10.20 12:24:20 -- Resource limits ^^^^^^^
16.10.20 12:24:21 -- Tablespaces usage .......
16.10.20 12:24:21 -- USERS : 47181Mb
16.10.20 12:24:21 -- INDX : 19307Mb
16.10.20 12:24:21 -- SYSAUX : 5591Mb
16.10.20 12:24:21 -- UNDOTBS2 : 2557Mb
16.10.20 12:24:21 -- SYSTEM : 749Mb
16.10.20 12:24:21 -- OLAP_TBS : 4Mb
16.10.20 12:24:21 -- Tablespaces usage ^^^^^^^
16.10.20 12:24:21 -- Top buffer segments .......
16.10.20 12:24:21 -- TABLE : SUPERMAG.SMDOCUMENTS - 7%
16.10.20 12:24:21 -- INDEX : SUPERMAG.SMCASHQUEUE_LOCIDX - 1%
16.10.20 12:24:21 -- INDEX : SUPERMAG.SMCASHQUEUE_ARTIDX - 1%
16.10.20 12:24:21 -- Top buffer segments ^^^^^^^
16.10.20 12:24:26 -- Top statistics .......
16.10.20 12:24:26 -- SUPERMAG.SSLOCKS - logical reads=163436480
16.10.20 12:24:26 -- SUPERMAG.SMCDOCUMENTS_PK - logical reads=132300128
16.10.20 12:24:26 -- SUPERMAG.SMDOCUMENTS - logical reads=67053120
16.10.20 12:24:26 -- SUPERMAG.SMCARD - logical reads=8857152
16.10.20 12:24:26 -- SUPERMAG.SMCARD_PK - logical reads=3230784
16.10.20 12:24:26 -- SUPERMAG.SACCARDCLASS_PK - logical reads=3159328
16.10.20 12:24:26 -- SUPERMAG.SMSTAFF - logical reads=2494768
16.10.20 12:24:26 -- SUPERMAG.SMSTAFF_LOGIN - logical reads=2267088
16.10.20 12:24:26 -- SUPERMAG.SMSPEC_ART - logical reads=1645600
16.10.20 12:24:26 -- Top statistics ^^^^^^^
16.10.20 12:24:27 -- Sysaux segments (MB) .......
16.10.20 12:24:27 -- Server Manageability - Optimizer Statistics History - 5002,25
16.10.20 12:24:27 -- Server Manageability - Automatic Workload Repository - 339,625
16.10.20 12:24:27 -- Enterprise Manager Repository - 50,0625
16.10.20 12:24:27 -- XDB - 48,125
16.10.20 12:24:27 -- Server Manageability - Advisor Framework - 35,9375
16.10.20 12:24:27 -- Oracle Spatial - 32,875
16.10.20 12:24:27 -- OLAP API History Tables - 26,0625
16.10.20 12:24:27 -- Analytical Workspace Object Table - 26,0625
16.10.20 12:24:27 -- OLAP Catalog - 15,5625
16.10.20 12:24:27 -- Workspace Manager - 7,125
16.10.20 12:24:27 -- LogMiner - 5,9375
16.10.20 12:24:27 -- Server Manageability - Other Components - 5,5
16.10.20 12:24:27 -- Oracle Text - 4,625
16.10.20 12:24:27 -- Expression Filter System - 3,625
16.10.20 12:24:27 -- Enterprise Manager Monitoring User - 1,5625
16.10.20 12:24:27 -- Logical Standby - ,875
16.10.20 12:24:27 -- Unified Job Scheduler - ,75
16.10.20 12:24:27 -- Oracle Streams - ,5
16.10.20 12:24:27 -- Oracle interMedia ORDSYS Components - ,5
16.10.20 12:24:27 -- Oracle Data Mining - ,25
16.10.20 12:24:27 -- Oracle Transparent Session Migration User - ,25
16.10.20 12:24:27 -- Sysaux segments (MB) ^^^^^^^
16.10.20 12:24:27 -- Wait events .......
16.10.20 12:24:27 -- ON CPU - 124
16.10.20 12:24:27 -- db file parallel read - 38
16.10.20 12:24:27 -- direct path read temp - 30
16.10.20 12:24:27 -- log file sequential read - 26
16.10.20 12:24:28 -- db file sequential read - 12
16.10.20 12:24:28 -- db file parallel write - 4
16.10.20 12:24:28 -- db file scattered read - 4
16.10.20 12:24:28 -- enq: TM - contention - 3
16.10.20 12:24:28 -- direct path write temp - 1
16.10.20 12:24:28 -- log file sync - 1
16.10.20 12:24:28 -- log file parallel write - 1
16.10.20 12:24:28 -- Wait events ^^^^^^^
16.10.20 12:24:28 -- SGA dynamic components .......
16.10.20 12:24:28 -- shared pool - Current: 2048Mb (STATIC), Spfile: 2048Mb, Min: 2048Mb
16.10.20 12:24:28 -- DEFAULT buffer cache - Current: 2048Mb (INITIALIZING), Spfile: 2048Mb, Min: 2048Mb
16.10.20 12:24:28 -- java pool - Current: 2048Mb (STATIC), Spfile: 2048Mb, Min: 2048Mb
16.10.20 12:24:28 -- large pool - Current: 2048Mb (STATIC), Spfile: 2048Mb, Min: 2048Mb
16.10.20 12:24:28 -- SGA dynamic components ^^^^^^^
16.10.20 12:24:28 -- Check disk freespace
16.10.20 12:24:28 -- Free space check .......
16.10.20 12:24:28 -- D:\ORACLE\ADMIN\KAMAVTO : 82004 Mb
16.10.20 12:24:28 -- D:\ORACLE\ORA10\DATABASE : 82004 Mb
16.10.20 12:24:28 -- D:\ORACLE\ORADATA\KAMAVTO : 82004 Mb
16.10.20 12:24:28 -- E: : 211668 Mb
16.10.20 12:24:28 -- E:\ORACLE\ORADATA\KAMAVTO : 211668 Mb
16.10.20 12:24:29 -- Free space check ^^^^^^^
16.10.20 12:24:29 -- Running backup detected
16.10.20 12:24:29 -- Free space in tablespaces .......
16.10.20 12:24:30 -- SYSAUX:26Gb
16.10.20 12:24:30 -- USERS:25Gb
16.10.20 12:24:30 -- SYSTEM:31Gb
16.10.20 12:24:30 -- INDX:43Gb
16.10.20 12:24:30 -- TOOLS:13Gb
16.10.20 12:24:30 -- OLAP_TBS:31Gb
16.10.20 12:24:30 -- Free space in tablespaces ^^^^^^^
16.10.20 12:24:30 -- Log filename: D:\ORACLE\ADMIN\KAMAVTO\BDUMP/alert_kamavto.log 0Mb
OLEGON-ERROR! 16.10.20 12:24:30 -- Fri Oct 16 12:20:54 2020 ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
OLEGON-ERROR! 16.10.20 12:24:33 -- Database invalids : (1) PACKAGE_BODY:SYS.DBMS_SQLPA
16.10.20 12:24:33 -- Wasted space .......
16.10.20 12:24:33 -- SUPERMAG.FFMAPREP_ Total : 3Gb Allocated : ,9Gb Wasted : 2,1Gb
16.10.20 12:24:33 -- SUPERMAG.SMEGAISPOSTLOG Total : 3,9Gb Allocated : 2Gb Wasted : 1,9Gb
16.10.20 12:24:34 -- SUPERMAG.SMCASHCHECKSLOG Total : 2,1Gb Allocated : ,5Gb Wasted : 1,6Gb
16.10.20 12:24:34 -- SYS.WRI$_OPTSTAT_HISTGRM_HISTORY Total : 1,4Gb Allocated : 0Gb Wasted : 1,4Gb
16.10.20 12:24:34 -- SUPERMAG.SMSPECTAX Total : 1,7Gb Allocated : 1,2Gb Wasted : ,5Gb
16.10.20 12:24:34 -- SUPERMAG.FFREMINCOME_ Total : ,5Gb Allocated : ,1Gb Wasted : ,4Gb
16.10.20 12:24:34 -- SUPERMAG.SMCASHDISC Total : 1,3Gb Allocated : ,9Gb Wasted : ,4Gb
16.10.20 12:24:34 -- SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY Total : ,3Gb Allocated : 0Gb Wasted : ,3Gb
16.10.20 12:24:34 -- SYS.IDL_UB1$ Total : ,2Gb Allocated : 0Gb Wasted : ,2Gb
16.10.20 12:24:34 -- SUPERMAG.SMSPECCASHDISC Total : ,7Gb Allocated : ,5Gb Wasted : ,2Gb
16.10.20 12:24:34 -- Wasted space ^^^^^^^
16.10.20 12:24:34 -- Set table logging
16.10.20 12:24:34 -- Set index logging
16.10.20 12:24:34 -- WRI$ stats date : 2020-10-09 02:39:06.828 +3:00 Retention : 7
16.10.20 12:24:35 -- WRI$ stats size : 0.283203125Gb
16.10.20 12:24:45 -- Close editable period
16.10.20 12:24:45 -- FFMAPREP checks
16.10.20 12:24:45 -- Audit checks
16.10.20 12:24:46 -- Garbage checks
16.10.20 12:25:25 -- Purge Recycle bin
16.10.20 12:25:26 -- Bad blocks check
16.10.20 12:25:26 -- Drop OCM
16.10.20 12:25:26 -- Gather statistics
16.10.20 12:52:55 -- Segments size .......
16.10.20 12:52:55 -- INDEX SUPERMAG.SMCCASHQUEUE_PK - 4 G, USERS
16.10.20 12:52:55 -- TABLE SUPERMAG.SMCASHCHECKITEMS - 4 G, USERS
16.10.20 12:52:55 -- TABLE SUPERMAG.SMEGAISPOSTLOG - 3 G, USERS
16.10.20 12:52:55 -- TABLE SUPERMAG.SMTIMESPANSALE - 3 G, USERS
16.10.20 12:52:55 -- TABLE SUPERMAG.FFMAPREP_ - 3 G, USERS
16.10.20 12:52:55 -- TABLE SUPERMAG.SMCASHCHECKSLOG - 2 G, USERS
16.10.20 12:52:55 -- TABLE SUPERMAG.FFSPEC - 2 G, USERS
16.10.20 12:52:55 -- TABLE SUPERMAG.SMSPEC - 2 G, USERS
16.10.20 12:52:55 -- TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY - 1 G, SYSAUX
16.10.20 12:52:55 -- INDEX SUPERMAG.SMSPEC_ART - 1 G, INDX
16.10.20 12:52:55 -- Segments size ^^^^^^^
16.10.20 12:52:56 -- LOBs size .......
16.10.20 12:52:56 -- SYS.WRH$_SQL_PLAN.OTHER_XML : SYS_LOB0000009001C00038$$ - 0G, SYSAUX
16.10.20 12:52:56 -- MDSYS.SDO_COORD_OP_PARAM_VALS.PARAM_VALUE_FILE : SYS_LOB0000046451C00006$$ - 0G, SYSAUX
16.10.20 12:52:56 -- SYS.AW$AWXML.AWLOB : SYS_LOB0000046940C00004$$ - 0G, SYSAUX
16.10.20 12:52:56 -- SYS.AW$AWMD.AWLOB : SYS_LOB0000046922C00004$$ - 0G, SYSAUX
16.10.20 12:52:56 -- SUPERMAG.SMCARDIMAGE.THEIMAGE : SYS_LOB0000052050C00002$$ - 0G, USERS
16.10.20 12:52:56 -- SYS.WRI$_ADV_OBJECTS.ATTR4 : SYS_LOB0000003717C00007$$ - 0G, SYSAUX
16.10.20 12:52:56 -- SUPERMAG.SMCARDIMAGE.DRAWINGIMAGE : SYS_LOB0000052050C00004$$ - 0G, USERS
16.10.20 12:52:56 -- SYS.AW$AWCREATE.AWLOB : SYS_LOB0000046928C00004$$ - 0G, SYSAUX
16.10.20 12:52:56 -- SYS.WRH$_SQLTEXT.SQL_TEXT : SYS_LOB0000008995C00004$$ - 0G, SYSAUX
16.10.20 12:52:56 -- SUPERMAG.SMDOCBLOBFILES.THECONTENTS : SYS_LOB0000052276C00007$$ - 0G, USERS
16.10.20 12:52:56 -- LOBs size ^^^^^^^
16.10.20 12:52:57 -- Delete old audit files
16.10.20 12:52:57 -- Audit directory D:\ORACLE\ADMIN\KAMAVTO\ADUMP/
16.10.20 12:52:57 -- Delete old traces
16.10.20 12:52:57 -- Background traces directory D:\ORACLE\ADMIN\KAMAVTO\BDUMP/
16.10.20 12:53:23 -- User traces directory D:\ORACLE\ADMIN\KAMAVTO\UDUMP/
16.10.20 12:53:27 -- Java 32-bit on amd64 installed!!!!
16.10.20 12:53:29 -- Top 10 tables with old statistics .......
16.10.20 12:53:29 -- SUPERMAG.SMCASHLOADDISCCARD
16.10.20 12:53:29 -- SUPERMAG.SMPOSTQUEUE
16.10.20 12:53:29 -- SUPERMAG.SMCASHQUEUE
16.10.20 12:53:29 -- SUPERMAG.SMPOSTQUEUEINPROCESSING
16.10.20 12:53:29 -- Top 10 tables with old statistics ^^^^^^^
16.10.20 12:53:29 -- Table statistics problem.
16.10.20 12:53:29 -- Fixing table stats on SUPERMAG.SMCASHLOADDISCCARD
16.10.20 12:53:29 -- Standby not configured
16.10.20 12:53:29 -- …
16.10.20 12:53:29 -- Oracle : 10.2.0.4.0/64bit * Java : 1.7.0_67 * Optimizer : 7.2008092214
16.10.20 12:53:29 -- SMID : 8CF7E7E778994776890B087A3050E708
16.10.20 12:53:29 -- Supermag : 1.041 SP2 * TD : / * Rating : 4.6
16.10.20 12:53:29 -- Changed documents : 302/2618
16.10.20 12:53:30 -- Archivelogs (last hour) : 1
16.10.20 12:53:30 -- Sysdate : 2020-10-16 12:53:30.0 * MT : 12:00,1
16.10.20 12:53:30 -- Startup time : 2020-10-16 09:51:07.0
16.10.20 12:53:30 -- Last full RMAN backup : * Files : 21 (Gb)
16.10.20 12:53:30 -- EMails : (с. Новые алкаши, главпочтамт, представителю клуба сексуальных меньшинств, до востребования)
16.10.20 12:53:30 -- Runs : 62 * Errors : 9418
16.10.20 12:53:30 -- …
OLEGON-ERROR! 16.10.20 12:56:07 -- Unhandled error : java.sql.SQLException: ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [] * Oracle : 10.2.0.4.0 * Java : 1.7.0_67 * OS : Windows 2003