25.11.12 19:00:01 -- Optimizer for Oracle bases console version 4.10 25.11.12 19:00:01 -- D:\optimazer\optimizer4 25.11.12 19:00:01 -- Master server: olegon.no-ip.org 25.11.12 19:00:01 -- DB server: h3sbd01 25.11.12 19:00:01 -- DB name: chizh1 25.11.12 19:00:01 -- Requested commands:o 25.11.12 19:00:01 -- Commands accepted 25.11.12 19:00:03 -- | 25.11.12 19:00:03 -- |||||||||||||||||||||||||||||||| 25.11.12 19:00:03 -- ||||||||| Start server ||||||||| 25.11.12 19:00:03 -- |||||||||||||||||||||||||||||||| 25.11.12 19:00:04 -- DB status : OPEN 25.11.12 19:00:04 -- Client ID : CHIZH1.H3SBD01.2456181845525725 25.11.12 19:00:08 -- Check program status... 25.11.12 19:00:11 -- Validation check... 25.11.12 19:00:17 -- Client number: 25.11.12 19:00:18 -- Program status: Nonclient mode 25.11.12 19:00:18 -- Unregistered version 25.11.12 19:00:18 -- ............................................................................. 25.11.12 19:00:20 -- Archivelog disabled... May be you forget backup too? 25.11.12 19:00:22 -- Optimizer parameters check... 25.11.12 19:01:38 -- Allowed message sending (user configuration)... 25.11.12 19:01:38 -- Alert emails : zotovby@gmail.com/zotovby@gmail.com/zotovby@gmail.com 25.11.12 19:01:38 -- Alert jabbers : -/- 25.11.12 19:01:38 -- Arch : x86 25.11.12 19:01:39 -- OS : Windows XP 25.11.12 19:01:39 -- Java : 1.7.0_09 25.11.12 19:01:40 -- pwd : D:\optimizer4 25.11.12 19:01:41 -- IP : 212.98.178.143 25.11.12 19:01:41 -- PATH : C:\orant\bin;C:\oracle\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\android-sdk-windows\tools;c:\PROGRA~1\COMMON~1\BORLAN~1\BDE;C:\SM2000\Bin;D:\optimazer\optimizer4 25.11.12 19:01:42 -- ORACLE_SID : null 25.11.12 19:01:43 -- DB name : CHIZH1 25.11.12 19:01:44 -- DB size : 34Gb 25.11.12 19:01:47 -- Big database detected.. Ooops... ;-) 25.11.12 19:01:51 -- Not maintenance time... 25.11.12 19:01:51 -- RDBMS version : 10 25.11.12 19:01:51 -- Good choice.. 25.11.12 19:01:52 -- Small SGA. Stupid machine or admin detected... 25.11.12 19:01:52 -- trying cmd:o 25.11.12 19:01:52 -- Requested full regular optimization... I suppose, that you'll run it at least every 29 minutes. 25.11.12 19:01:54 -- Host name : H3SBD01 25.11.12 19:01:55 -- Startup time : 2012-11-21 02:35:18.0 25.11.12 19:01:56 -- DB time : 25.11.2012 19:01:56 25.11.12 19:01:57 -- DBID : 845525725 25.11.12 19:01:58 -- Database encoding : CL8MSWIN1251 25.11.12 19:01:59 -- Redo groups count : 3 25.11.12 19:02:00 -- Enterprise Edition features detected... Cool. 25.11.12 19:02:03 -- Checking free space in tablespaces: 25.11.12 19:02:04 -- INDX:11Gb 25.11.12 19:02:05 -- USERS:16Gb 25.11.12 19:02:06 -- SYSAUX:30Gb 25.11.12 19:02:07 -- UNDOTBS1:30Gb 25.11.12 19:02:08 -- SYSTEM:31Gb 25.11.12 19:02:10 -- Check system statistics... COMPLETED 25.11.12 19:02:13 -- System statistics collected... 25.11.12 19:02:14 -- Checking database parameters... 25.11.12 19:02:16 -- CPU cores: 4 25.11.12 19:02:16 -- *********************** Obsolete parameters *********************** 25.11.12 19:02:18 -- Set database parameters 25.11.12 19:02:47 -- Checking system statistic values... 25.11.12 19:02:49 -- Check supermag grants 25.11.12 19:03:14 -- ************************************************************** 25.11.12 19:03:14 -- Gathering constraint list (1st stage)... 25.11.12 19:03:16 -- ************************************************************** 25.11.12 19:03:16 -- Gathering constraint list (2nd stage)... 25.11.12 19:03:17 -- ************************************************************** 25.11.12 19:03:18 -- Gathering list of invalid indexes 25.11.12 19:03:19 -- ************************************************************** 25.11.12 19:03:19 -- Partitions and subpartitions state check 25.11.12 19:03:20 -- ************************************************************** 25.11.12 19:03:20 -- Gathering list of invalid index partitions 25.11.12 19:03:21 -- ************************************************************** 25.11.12 19:03:21 -- Gathering list of invalid index subpartitions 25.11.12 19:03:22 -- Index rebuilding completed... 25.11.12 19:03:22 -- ************************************************************** 25.11.12 19:03:23 -- ************************************************************** 25.11.12 19:03:23 -- Gathering ff-tables list... 25.11.12 19:03:23 -- Not configured... 25.11.12 19:03:24 -- List of invalid views 25.11.12 19:03:24 -- Invalid view count: 0 25.11.12 19:03:25 -- Impossible to compile : 0 views 25.11.12 19:03:25 -- Views compilation finished... 25.11.12 19:03:25 -- ************************************************************** 25.11.12 19:03:25 -- List of invalid procedures and functions 25.11.12 19:03:26 -- Invalid procedures and functions count: 0 25.11.12 19:03:27 -- Impossible to compile : 0 procedures and functions 25.11.12 19:03:27 -- Procedures and functions compilation finished... 25.11.12 19:03:27 -- ************************************************************** 25.11.12 19:03:28 -- List of invalid packages 25.11.12 19:03:28 -- Invalid packages count: 0 25.11.12 19:03:32 -- Impossible to compile : 0 packages 25.11.12 19:03:32 -- Package compilation finished... 25.11.12 19:03:32 -- ************************************************************** 25.11.12 19:03:32 -- List of invalid package bodies 25.11.12 19:03:34 -- Invalid package bodies count: 1 25.11.12 19:03:34 -- Recompiling package body SYS."YZ" 25.11.12 19:03:36 -- ***************************** Errors ***************************** 25.11.12 19:03:37 -- SYS YZ PACKAGE BODY 1 1 14 PLS-00201: identifier 'YZ' must be declared ERROR 201 25.11.12 19:03:37 -- SYS YZ PACKAGE BODY 2 1 14 PLS-00304: cannot compile body of 'YZ' without its specification ERROR 304 25.11.12 19:03:37 -- SYS YZ PACKAGE BODY 3 0 0 PL/SQL: Compilation unit analysis terminated ERROR 0 25.11.12 19:03:38 -- Impossible to compile : 1 package bodies 25.11.12 19:03:38 -- Package bodies compilation finished... 25.11.12 19:03:38 -- ************************************************************** 25.11.12 19:03:38 -- List of invalid triggers 25.11.12 19:03:40 -- Invalid triggers count: 0 25.11.12 19:03:41 -- Impossible to compile : 0 packages 25.11.12 19:03:41 -- Trigger compilation finished... 25.11.12 19:03:41 -- ************************************************************** 25.11.12 19:03:41 -- List of invalid object owners 25.11.12 19:03:42 -- Invalid schema count: 0 25.11.12 19:03:43 -- Impossible to compile : 1 25.11.12 19:03:43 -- Schema compilation finished... 25.11.12 19:03:43 -- Validate triggers. Gathering triggers list... 25.11.12 19:03:44 -- ************************************************************** 25.11.12 19:03:44 -- Summary additions: 25.11.12 19:03:47 -- Orders refreshing... 25.11.12 19:06:00 -- Orders index... 25.11.12 19:06:02 -- Orders stats... 25.11.12 19:06:11 -- ******************************************* 25.11.12 19:06:11 -- Eventlog : 25.11.12 19:06:13 -- ******************************************* 25.11.12 19:06:14 -- Doclog : 25.11.12 19:06:24 -- ********************** Report procedures... 25.11.12 19:06:25 -- We don't need this now... 25.11.12 19:06:27 -- ******************************************* 25.11.12 19:06:27 -- Checking free space : 25.11.12 19:06:30 -- D:\ : 17453 Mb 25.11.12 19:06:31 -- D:\ADMIN\CHIZH1\ : 0 Mb 25.11.12 19:06:33 -- D:\ORACLE\DATABASE\ : 0 Mb 25.11.12 19:06:35 -- D:\ORADATA\CHIZH1\ : 0 Mb 25.11.12 19:06:37 -- ******************************************* 25.11.12 19:06:37 -- Checking system tablespace... 25.11.12 19:06:38 -- ************************************************************** 25.11.12 19:06:38 -- Alert log checking... 25.11.12 04:00:00 -- D:\optimazer\optimizer4 25.11.12 04:00:00 -- Master server: olegon.no-ip.org 25.11.12 04:00:00 -- DB server: h3sbd01 25.11.12 04:00:00 -- DB name: chizh1 25.11.12 04:00:01 -- Requested commands:o 25.11.12 04:00:01 -- Commands accepted 25.11.12 04:00:02 -- | 25.11.12 04:00:02 -- |||||||||||||||||||||||||||||||| 25.11.12 04:00:02 -- ||||||||| Start server ||||||||| 25.11.12 04:00:02 -- |||||||||||||||||||||||||||||||| 25.11.12 04:00:03 -- DB status : OPEN 25.11.12 04:00:03 -- Client ID : CHIZH1.H3SBD01.2456181845525725 25.11.12 04:00:07 -- Check program status... 25.11.12 04:00:09 -- Validation check... 25.11.12 04:00:13 -- Client number: 25.11.12 04:00:14 -- Program status: Nonclient mode 25.11.12 04:00:14 -- Unregistered version 25.11.12 04:00:15 -- ............................................................................. 25.11.12 04:00:16 -- Archivelog disabled... May be you forget backup too? 25.11.12 04:00:17 -- Optimizer parameters check... 25.11.12 04:01:22 -- Allowed message sending (user configuration)... 25.11.12 04:01:22 -- Alert emails : zotovby@gmail.com/zotovby@gmail.com/zotovby@gmail.com 25.11.12 04:01:22 -- Alert jabbers : -/- 25.11.12 04:01:22 -- Arch : x86 25.11.12 04:01:23 -- OS : Windows XP 25.11.12 04:01:23 -- Java : 1.7.0_09 25.11.12 04:01:24 -- pwd : D:\optimazer\optimizer4 25.11.12 04:01:25 -- IP : 212.98.178.143 25.11.12 04:01:25 -- PATH : C:\orant\bin;C:\oracle\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\android-sdk-windows\tools;c:\PROGRA~1\COMMON~1\BORLAN~1\BDE;C:\SM2000\Bin;D:\optimazer\optimizer4 25.11.12 04:01:26 -- ORACLE_SID : null 25.11.12 04:01:27 -- DB name : CHIZH1 25.11.12 04:01:28 -- DB size : 33Gb 25.11.12 04:01:29 -- Big database detected.. Ooops... ;-) 25.11.12 04:01:33 -- Not maintenance time... 25.11.12 04:01:33 -- RDBMS version : 10 25.11.12 04:01:33 -- Good choice.. 25.11.12 04:01:34 -- Small SGA. Stupid machine or admin detected... 25.11.12 04:01:34 -- trying cmd:o 25.11.12 04:01:34 -- Requested full regular optimization... I suppose, that you'll run it at least every 29 minutes. 25.11.12 04:01:36 -- Host name : H3SBD01 25.11.12 04:01:37 -- Startup time : 2012-11-21 02:35:18.0 25.11.12 04:01:38 -- DB time : 25.11.2012 04:01:38 25.11.12 04:01:39 -- DBID : 845525725 25.11.12 04:01:40 -- Database encoding : CL8MSWIN1251 25.11.12 04:01:41 -- Redo groups count : 3 25.11.12 04:01:42 -- Enterprise Edition features detected... Cool. 25.11.12 04:01:45 -- Checking free space in tablespaces: 25.11.12 04:01:46 -- INDX:11Gb 25.11.12 04:01:46 -- USERS:17Gb 25.11.12 04:01:47 -- SYSAUX:30Gb 25.11.12 04:01:48 -- SYSTEM:31Gb 25.11.12 04:01:49 -- UNDOTBS1:31Gb 25.11.12 04:01:51 -- Check system statistics... COMPLETED 25.11.12 04:01:54 -- System statistics collected... 25.11.12 04:01:55 -- Checking database parameters... 25.11.12 04:01:56 -- CPU cores: 4 25.11.12 04:01:56 -- *********************** Obsolete parameters *********************** 25.11.12 04:01:58 -- Set database parameters 25.11.12 04:02:22 -- Checking system statistic values... 25.11.12 04:02:24 -- Check supermag grants 25.11.12 04:02:45 -- ************************************************************** 25.11.12 04:02:45 -- Gathering constraint list (1st stage)... 25.11.12 04:02:46 -- ************************************************************** 25.11.12 04:02:46 -- Gathering constraint list (2nd stage)... 25.11.12 04:02:47 -- ************************************************************** 25.11.12 04:02:48 -- Gathering list of invalid indexes 25.11.12 04:02:49 -- ************************************************************** 25.11.12 04:02:49 -- Partitions and subpartitions state check 25.11.12 04:02:50 -- ************************************************************** 25.11.12 04:02:50 -- Gathering list of invalid index partitions 25.11.12 04:02:51 -- ************************************************************** 25.11.12 04:02:51 -- Gathering list of invalid index subpartitions 25.11.12 04:02:52 -- Index rebuilding completed... 25.11.12 04:02:52 -- ************************************************************** 25.11.12 04:02:52 -- ************************************************************** 25.11.12 04:02:52 -- Gathering ff-tables list... 25.11.12 04:02:53 -- Not configured... 25.11.12 04:02:53 -- List of invalid views 25.11.12 04:02:54 -- Invalid view count: 0 25.11.12 04:02:55 -- Impossible to compile : 0 views 25.11.12 04:02:55 -- Views compilation finished... 25.11.12 04:02:55 -- ************************************************************** 25.11.12 04:02:55 -- List of invalid procedures and functions 25.11.12 04:02:56 -- Invalid procedures and functions count: 0 25.11.12 04:02:57 -- Impossible to compile : 0 procedures and functions 25.11.12 04:02:57 -- Procedures and functions compilation finished... 25.11.12 04:02:57 -- ************************************************************** 25.11.12 04:02:57 -- List of invalid packages 25.11.12 04:02:58 -- Invalid packages count: 0 25.11.12 04:02:59 -- Impossible to compile : 0 packages 25.11.12 04:02:59 -- Package compilation finished... 25.11.12 04:02:59 -- ************************************************************** 25.11.12 04:02:59 -- List of invalid package bodies 25.11.12 04:03:00 -- Invalid package bodies count: 1 25.11.12 04:03:00 -- Recompiling package body SYS."YZ" 25.11.12 04:03:01 -- ***************************** Errors ***************************** 25.11.12 04:03:02 -- SYS YZ PACKAGE BODY 1 1 14 PLS-00201: identifier 'YZ' must be declared ERROR 201 25.11.12 04:03:02 -- SYS YZ PACKAGE BODY 2 1 14 PLS-00304: cannot compile body of 'YZ' without its specification ERROR 304 25.11.12 04:03:02 -- SYS YZ PACKAGE BODY 3 0 0 PL/SQL: Compilation unit analysis terminated ERROR 0 25.11.12 04:03:03 -- Impossible to compile : 1 package bodies 25.11.12 04:03:03 -- Package bodies compilation finished... 25.11.12 04:03:03 -- ************************************************************** 25.11.12 04:03:03 -- List of invalid triggers 25.11.12 04:03:04 -- Invalid triggers count: 0 25.11.12 04:03:05 -- Impossible to compile : 0 packages 25.11.12 04:03:05 -- Trigger compilation finished... 25.11.12 04:03:05 -- ************************************************************** 25.11.12 04:03:05 -- List of invalid object owners 25.11.12 04:03:06 -- Invalid schema count: 0 25.11.12 04:03:07 -- Impossible to compile : 1 25.11.12 04:03:07 -- Schema compilation finished... 25.11.12 04:03:07 -- Validate triggers. Gathering triggers list... 25.11.12 04:03:08 -- ************************************************************** 25.11.12 04:03:08 -- Summary additions: 25.11.12 04:03:11 -- Orders refreshing... 25.11.12 04:04:45 -- Orders index... 25.11.12 04:04:47 -- Orders stats... 25.11.12 04:04:53 -- ******************************************* 25.11.12 04:04:53 -- Eventlog : 25.11.12 04:04:55 -- ******************************************* 25.11.12 04:04:55 -- Doclog : 25.11.12 04:05:03 -- ********************** Report procedures... 25.11.12 04:05:06 -- Report delayed... 25.11.12 04:05:08 -- ******************************************* 25.11.12 04:05:08 -- Checking free space : 25.11.12 04:05:10 -- D:\ : 17453 Mb 25.11.12 04:05:12 -- D:\ADMIN\CHIZH1\ : 0 Mb 25.11.12 04:05:14 -- D:\ORACLE\DATABASE\ : 0 Mb 25.11.12 04:05:16 -- D:\ORADATA\CHIZH1\ : 0 Mb 25.11.12 04:05:17 -- ******************************************* 25.11.12 04:05:18 -- Checking system tablespace... 25.11.12 04:05:18 -- ************************************************************** 25.11.12 04:05:19 -- Alert log checking... 25.11.12 04:33:01 -- Optimizer for Oracle bases console version 4.10