16.09.13 10:00:14 -- Optimizer for Oracle bases console version 4.10 16.09.13 10:00:14 -- e:\optimizer4 16.09.13 10:00:14 -- Master server: olegon.no-ip.org 16.09.13 10:00:14 -- DB server: srv-smp 16.09.13 10:00:14 -- DB name: vmarket 16.09.13 10:00:14 -- Requested commands:o 16.09.13 10:00:14 -- Commands accepted 16.09.13 10:00:15 -- | 16.09.13 10:00:15 -- |||||||||||||||||||||||||||||||| 16.09.13 10:00:15 -- ||||||||| Start server ||||||||| 16.09.13 10:00:15 -- |||||||||||||||||||||||||||||||| 16.09.13 10:00:15 -- DB status : OPEN 16.09.13 10:00:15 -- Client ID : VMARKET.SRV-SMP.24563282691422002 16.09.13 10:00:16 -- Check program status... 16.09.13 10:00:16 -- Validation check... 16.09.13 10:00:17 -- Client number: 541 16.09.13 10:00:17 -- Program status: Nonclient mode 16.09.13 10:00:17 -- Registered version. Registration will expire at 2013-09-30 07:38:21.0 16.09.13 10:00:17 -- ............................................................................. 16.09.13 10:00:18 -- Archivelog enabled... Good. 16.09.13 10:00:18 -- Optimizer parameters check... 16.09.13 10:00:26 -- Orders optimization disabled because of Supermag version... 16.09.13 10:00:26 -- Allowed message sending (user configuration)... 16.09.13 10:00:26 -- Alert emails : newteh72@yandex.ru/-/- 16.09.13 10:00:26 -- Alert jabbers : -/- 16.09.13 10:00:27 -- Arch : amd64 16.09.13 10:00:27 -- OS : Windows Server 2008 R2 16.09.13 10:00:28 -- Java : 1.7.0_17 16.09.13 10:00:28 -- pwd : e:\optimizer4 16.09.13 10:00:29 -- IP : 80.71.214.35 16.09.13 10:00:30 -- PATH : C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\ORA\ORACLI\bin;E:\ORACLE\ORA11\bin;C:\orant\bin;C:\SM2000\Bin; 16.09.13 10:00:30 -- ORACLE_SID : null 16.09.13 10:00:31 -- DB name : VMARKET 16.09.13 10:00:31 -- DB size : 2Gb 16.09.13 10:00:34 -- Not maintenance time... 16.09.13 10:00:34 -- RDBMS version : 11 16.09.13 10:00:34 -- Detected Oracle 11g, some features disabled.. 16.09.13 10:00:34 -- Small SGA. Stupid machine or admin detected... 16.09.13 10:00:34 -- trying cmd:o 16.09.13 10:00:34 -- Requested full regular optimization... I suppose, that you'll run it at least every 29 minutes. 16.09.13 10:00:34 -- Host name : SRV-SMP 16.09.13 10:00:35 -- Startup time : 2013-09-12 09:58:51.0 16.09.13 10:00:35 -- DB time : 16.09.2013 10:00:35 16.09.13 10:00:35 -- DBID : 2691422002 16.09.13 10:00:36 -- Database encoding : CL8MSWIN1251 16.09.13 10:00:36 -- Redo groups count : 3 16.09.13 10:00:37 -- Standart edtion database detected... Some features is not available. 16.09.13 10:00:37 -- Checking free space in tablespaces: 16.09.13 10:00:37 -- INDX:12Gb 16.09.13 10:00:38 -- UNDOTBS1:31Gb 16.09.13 10:00:38 -- SYSTEM:31Gb 16.09.13 10:00:38 -- SYSAUX:31Gb 16.09.13 10:00:38 -- USERS:31Gb 16.09.13 10:00:39 -- Checking database parameters... 16.09.13 10:00:39 -- CPU cores: 4 16.09.13 10:00:40 -- *********************** Obsolete parameters *********************** 16.09.13 10:00:40 -- Set database parameters 16.09.13 10:00:41 -- Checking system statistic values... 16.09.13 10:00:41 -- Check supermag grants 16.09.13 10:00:44 -- ************************************************************** 16.09.13 10:00:44 -- Gathering constraint list (1st stage)... 16.09.13 10:00:45 -- ************************************************************** 16.09.13 10:00:45 -- Gathering constraint list (2nd stage)... 16.09.13 10:00:45 -- ************************************************************** 16.09.13 10:00:45 -- Gathering list of invalid indexes 16.09.13 10:00:46 -- Index rebuild completed... 16.09.13 10:00:46 -- ************************************************************** 16.09.13 10:00:46 -- ************************************************************** 16.09.13 10:00:46 -- Gathering ff-tables list... 16.09.13 10:00:46 -- Not configured... 16.09.13 10:00:46 -- List of invalid views 16.09.13 10:00:46 -- Invalid view count: 0 16.09.13 10:00:47 -- Impossible to compile : 0 views 16.09.13 10:00:47 -- Views compilation finished... 16.09.13 10:00:47 -- ************************************************************** 16.09.13 10:00:47 -- List of invalid procedures and functions 16.09.13 10:00:47 -- Invalid procedures and functions count: 0 16.09.13 10:00:48 -- Impossible to compile : 0 procedures and functions 16.09.13 10:00:48 -- Procedures and functions compilation finished... 16.09.13 10:00:48 -- ************************************************************** 16.09.13 10:00:48 -- List of invalid packages 16.09.13 10:00:48 -- Invalid packages count: 0 16.09.13 10:00:48 -- Impossible to compile : 0 packages 16.09.13 10:00:49 -- Package compilation finished... 16.09.13 10:00:49 -- ************************************************************** 16.09.13 10:00:49 -- List of invalid package bodies 16.09.13 10:00:49 -- Invalid package bodies count: 0 16.09.13 10:00:49 -- Impossible to compile : 0 package bodies 16.09.13 10:00:49 -- Package bodies compilation finished... 16.09.13 10:00:49 -- ************************************************************** 16.09.13 10:00:49 -- List of invalid triggers 16.09.13 10:00:50 -- Invalid triggers count: 0 16.09.13 10:00:50 -- Impossible to compile : 0 packages 16.09.13 10:00:50 -- Trigger compilation finished... 16.09.13 10:00:50 -- ************************************************************** 16.09.13 10:00:50 -- List of invalid object owners 16.09.13 10:00:50 -- Invalid schema count: 0 16.09.13 10:00:51 -- Impossible to compile : 0 16.09.13 10:00:51 -- Schema compilation finished... 16.09.13 10:00:51 -- Validate triggers. Gathering triggers list... 16.09.13 10:00:51 -- ************************************************************** 16.09.13 10:00:52 -- RMAN procedures... 11 16.09.13 10:00:52 -- RMAN delayed... 16.09.13 10:00:52 -- Summary additions: 16.09.13 10:00:52 -- Orders optimization disabled. 16.09.13 10:00:53 -- ******************************************* 16.09.13 10:00:53 -- Eventlog : 16.09.13 10:00:54 -- ******************************************* 16.09.13 10:00:54 -- Doclog : 16.09.13 10:00:55 -- Приходная накладная ПНм001026 БРАТЦЕВ 12.06.2013->2 16.09.13 10:00:55 -- Приходная накладная ПНм001026 БРАТЦЕВ 12.06.2013->1 16.09.13 10:00:55 -- Приходная накладная ПНм001026 БРАТЦЕВ 12.06.2013->-1 16.09.13 10:00:55 -- Приходная накладная ПНм001026 БРАТЦЕВ 12.06.2013->3 16.09.13 10:00:55 -- ********************** Report procedures... 16.09.13 10:00:55 -- We don't need this now... 16.09.13 10:00:56 -- ******************************************* 16.09.13 10:00:56 -- Checking free space : 16.09.13 10:00:57 -- E:\ : 54746 Mb 16.09.13 10:00:59 -- E:\ORACLE\ADMIN\VMARKET\ : 54746 Mb 16.09.13 10:01:00 -- E:\ORACLE\ORA11\DATABASE\ : 54746 Mb 16.09.13 10:01:02 -- E:\ORACLE\ORADATA\VMARKET\ : 54746 Mb 16.09.13 10:01:03 -- e:\oracle\diag\rdbms\vmarket\vmarket\ : 54746 Mb 16.09.13 10:01:03 -- ******************************************* 16.09.13 10:01:04 -- Checking system tablespace... 16.09.13 10:01:04 -- ************************************************************** 16.09.13 10:01:04 -- Alert log checking... 16.09.13 10:01:04 -- Log filename: e:\oracle\diag\rdbms\vmarket\vmarket\trace\alert_vmarket.log 16.09.13 10:01:05 -- Lines count : 57488 16.09.13 10:01:05 -- ****************** 16.09.13 10:01:06 -- Usage checks... 16.09.13 10:01:06 -- Update your info... newteh72@yandex.ru for VMARKET.SRV-SMP.24563282691422002 16.09.13 10:01:07 -- Detailed hash:TAB1963409240278:IND2473805440185:OBJ10375382848422:TRG642044142817:CNS5667178636647:COL26061981822791:ICL5075689415757 16.09.13 10:01:09 -- Idle sessions check... 2400:0 16.09.13 10:01:09 -- Client tasks 16.09.13 10:01:10 -- We don't need run tasks now.. 16.09.13 10:01:10 -- ***************** Summary VMARKET.SRV-SMP.24563282691422002 80.71.214.35 541 *** 713534318 16.09.13 10:01:12 -- Supermag : 1.029.3 SP2 OS : Windows Server 2008 R2 Java : 1.7.0_17 Jabbers : -/- Mail:newteh72@yandex.ru/- 16.09.13 10:01:12 -- Last full rman backup : 2013-09-12 04:02:33.0 16.09.13 10:01:13 -- Last backup checkpoint : 2013-09-12 04:01:27.0 (4) Corruption : marked:/media:/logic: