Ошибка в 11.2.0.2

wurdu
Дата: 22.03.2011 09:26:50
Добрый день.
11.2.0.2, HP-UX, это только у меня так?
CREATE TABLE tst
    (
    dat date 
    )
    PARTITION BY RANGE (dat)
    (  
      PARTITION dat1 VALUES LESS THAN (to_date('22.03.2011', 'dd.mm.yyyy'))
    );

Table created.

insert into tst values(to_date('21.03.2011', 'dd.mm.yyyy'));

1 row created.

commit;

Commit complete.

select max(dat) from tst
    union all
    select max(dat) from tst;

MAX(DAT)
---------
21-MAR-11
21-MAR-11
21-MAR-11
Brass
Дата: 22.03.2011 09:38:30
wurdu,

11.2.0.2 HP-UX 11.31

MAX(DAT)
----------
21.03.2011
21.03.2011
wurdu
Дата: 22.03.2011 09:44:10
Brass
wurdu,

11.2.0.2 HP-UX 11.31

MAX(DAT)
----------
21.03.2011
21.03.2011
Мда... Собака где-то глубоко порылась...
pravednik
Дата: 22.03.2011 09:45:57
wurdu,
SunOS 5.10, 11.2.0.2 EE
SQL> select max(dat) from tst
    union all
    select max(dat) from tst;  2    3

MAX(DAT)
---------
21-MAR-11
21-MAR-11
21-MAR-11


=====================
PARSING IN CURSOR #18446744071459307848 len=67 dep=0 uid=0 oct=3 lid=0 tim=7741363822831 hv=2249476301 ad='3bbf95748' sqlid='4w7fu9a318k6d'
select max(dat) from tst
    union all
    select max(dat) from tst
END OF STMT
PARSE #18446744071459307848:c=10000,e=10525,p=0,cr=8,cu=0,mis=1,r=0,dep=0,og=1,plh=2145758605,tim=7741363822827
EXEC #18446744071459307848:c=0,e=86,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2145758605,tim=7741363823139
WAIT #18446744071459307848: nam='SQL*Net message to client' ela= 5 driver id=1650815232 #bytes=1 p3=0 obj#=523 tim=7741363823241
FETCH #18446744071459307848:c=0,e=126,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=1,plh=2145758605,tim=7741363823454
WAIT #18446744071459307848: nam='SQL*Net message from client' ela= 509 driver id=1650815232 #bytes=1 p3=0 obj#=523 tim=7741363824098
WAIT #18446744071459307848: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=523 tim=7741363824187
FETCH #18446744071459307848:c=0,e=183,p=0,cr=3,cu=0,mis=0,r=2,dep=0,og=1,plh=2145758605,tim=7741363824348
STAT #18446744071459307848 id=1 cnt=3 pid=0 pos=1 obj=0 op='UNION-ALL  (cr=6 pr=0 pw=0 time=120 us)'
STAT #18446744071459307848 id=2 cnt=2 pid=1 pos=1 obj=0 op='PARTITION RANGE SINGLE PARTITION: 1 1 (cr=3 pr=0 pw=0 time=102 us)'
STAT #18446744071459307848 id=3 cnt=1 pid=2 pos=1 obj=0 op='SORT AGGREGATE (cr=3 pr=0 pw=0 time=92 us)'
STAT #18446744071459307848 id=4 cnt=1 pid=3 pos=1 obj=80358 op='TABLE ACCESS FULL TST PARTITION: 1 1 (cr=3 pr=0 pw=0 time=73 us cost=2 size=9 card=1)'
STAT #18446744071459307848 id=5 cnt=1 pid=1 pos=2 obj=0 op='PARTITION RANGE SINGLE PARTITION: 1 1 (cr=3 pr=0 pw=0 time=95 us)'
STAT #18446744071459307848 id=6 cnt=1 pid=5 pos=1 obj=0 op='SORT AGGREGATE (cr=3 pr=0 pw=0 time=88 us)'
STAT #18446744071459307848 id=7 cnt=1 pid=6 pos=1 obj=80358 op='TABLE ACCESS FULL TST PARTITION: 1 1 (cr=3 pr=0 pw=0 time=65 us cost=2 size=9 card=1)'
Brass
Дата: 22.03.2011 09:50:03
wurdu
Brass
wurdu,

11.2.0.2 HP-UX 11.31

MAX(DAT)
----------
21.03.2011
21.03.2011
Мда... Собака где-то глубоко порылась...

у меня там правда и Jan PSU стоит
pravednik
Дата: 22.03.2011 09:58:31
+
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  4w7fu9a318k6d, child number 2
-------------------------------------
select max(dat) from tst     union all     select max(dat) from tst

Plan hash value: 2145758605

------------------------------------------------------------------------------------------
| Id  | Operation               | Name | Starts | E-Rows | A-Rows |   A-Time   | Buffers |
------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |      |      1 |        |      3 |00:00:00.01 |       6 |
|   1 |  UNION-ALL              |      |      1 |        |      3 |00:00:00.01 |       6 |
|   2 |   PARTITION RANGE SINGLE|      |      1 |      1 |      2 |00:00:00.01 |       3 |
|   3 |    SORT AGGREGATE       |      |      1 |      1 |      1 |00:00:00.01 |       3 |
|   4 |     TABLE ACCESS FULL   | TST  |      1 |      1 |      1 |00:00:00.01 |       3 |
|   5 |   PARTITION RANGE SINGLE|      |      1 |      1 |      1 |00:00:00.01 |       3 |
|   6 |    SORT AGGREGATE       |      |      1 |      1 |      1 |00:00:00.01 |       3 |
|   7 |     TABLE ACCESS FULL   | TST  |      1 |      1 |      1 |00:00:00.01 |       3 |
------------------------------------------------------------------------------------------
и без all
select max(dat) from tst     union     select max(dat) from tst

Plan hash value: 2940061658

----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                | Name | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT         |      |      1 |        |      1 |00:00:00.01 |       6 |       |       |          |
|   1 |  SORT UNIQUE             |      |      1 |      2 |      1 |00:00:00.01 |       6 |  2048 |  2048 | 2048  (0)|
|   2 |   UNION-ALL              |      |      1 |        |      2 |00:00:00.01 |       6 |       |       |          |
|   3 |    PARTITION RANGE SINGLE|      |      1 |      1 |      1 |00:00:00.01 |       3 |       |       |          |
|   4 |     SORT AGGREGATE       |      |      1 |      1 |      1 |00:00:00.01 |       3 |       |       |          |
|   5 |      TABLE ACCESS FULL   | TST  |      1 |      1 |      1 |00:00:00.01 |       3 |       |       |          |
|   6 |    PARTITION RANGE SINGLE|      |      1 |      1 |      1 |00:00:00.01 |       3 |       |       |          |
|   7 |     SORT AGGREGATE       |      |      1 |      1 |      1 |00:00:00.01 |       3 |       |       |          |
|   8 |      TABLE ACCESS FULL   | TST  |      1 |      1 |      1 |00:00:00.01 |       3 |       |       |          |
----------------------------------------------------------------------------------------------------------------------

интересненько )
AlexFF__|
Дата: 22.03.2011 10:18:33
11.2.0.2.0 - 64bit
RH 5.5

MAX(DAT)
----------
21.03.2011
21.03.2011
PaulEr
Дата: 22.03.2011 10:26:17
SUSE Linux Enterprise Server 10 (64-bit)

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Data Mining and Real Application Testing options

select max(dat) from tst
    union all
      select max(dat) from tst;

MAX(DAT)
---------------
21-MAR-11
21-MAR-11
21-MAR-11

Elapsed: 00:00:00.15
SQL> 
amir_rabinovich
Дата: 22.03.2011 12:12:20
MAX(DAT)
-----------
21.03.2011
21.03.2011

Oracle 11.2.0.2 без патчей
+ HP-UX список патчей
$/usr/contrib/bin/show_patches

Active Patch
Patch Description
---------- -----------------------------------------
PHCO_36032 killall(1M) cumulative patch
PHCO_36038 esmd(1M) cumulative patch
PHCO_36075 documentation change needed for stat(5)
PHCO_36132 awk(1) cumulative patch
PHCO_36254 uptime(1) cumulative patch
PHCO_36309 diskinfo(1M) patch
PHCO_36447 aries(5) man page patch
PHCO_36480 userdb cumulative patch
PHCO_36505 localedef(1M) cumulative patch
PHCO_36555 idisk(1M) cumulative patch
PHCO_36569 Firmware/software compatibility check
PHCO_36666 find(1) cumulative patch
PHCO_36944 fold(1) cumulative patch
PHCO_36945 more(1) cumulative patch
PHCO_37250 English math manpages patch
PHCO_37267 fwtmp(1m) cumulative patch
PHCO_37394 VxFS mkfs(1M) cumulative patch
PHCO_37482 ioinitrc cumulative patch
PHCO_37556 rtsched cumulative patch
PHCO_37620 pwgrd(1M) cumulative patch
PHCO_37645 fs_wrapper(5) patch
PHCO_37696 pwck(1M) cumulative patch
PHCO_37697 tsconvert cumulative patch
PHCO_37744 ptree(1) cumulative patch
PHCO_37756 Unicode iconv method patch
PHCO_37783 prot.h cumulative patch
PHCO_37784 /sbin/passwd cumulative patch
PHCO_37785 pwunconv(1M) cumulative patch
PHCO_37794 man(1) cumulative patch
PHCO_37807 Cumulative Patch for bcheckrc
PHCO_37811 logins(1M) cumulative patch
PHCO_37880 bdiff(1) cumulative patch
PHCO_37886 cp(1) cumulative patch
PHCO_37913 HFS mkfs(1M) cumulative patch
PHCO_37914 edquota(1M) cumulative patch
PHCO_37921 iconv cumulative patch
PHCO_38058 mpsched(1) cumulative patch
PHCO_38066 libIO(3X) cumulative patch
PHCO_38071 iobind patch
PHCO_38113 swapctl(2) manpage change to delete a swap device
PHCO_38160 id(1) cumulative patch
PHCO_38161 groups(1) cumulative patch
PHCO_38164 getaccess(1) cumulative patch
PHCO_38189 livedump man page patch
PHCO_38248 chgrp cumulative patch
PHCO_38249 chown cumulative patch
PHCO_38255 mkfs_hfs(1M) man page patch
PHCO_38256 edquota(1M) man page patch
PHCO_38257 quota(1) man page patch
PHCO_38263 sed(1) cumulative patch
PHCO_38268 cumulative SAM patch
PHCO_38312 uucpd(1M) cumulative patch
PHCO_38388 ENG manpages for decimal floating point functions
PHCO_38461 vtdaemon(1M) cumulative patch
PHCO_38482 chmod(1M) cumulative patch
PHCO_38483 acctcom(1M) cumulative patch
PHCO_38507 compartments cumulative patch
PHCO_38545 Eastern European locales cumulative patch
PHCO_38547 ugm cumulative patch
PHCO_38586 csh(1) cumulative patch
PHCO_38590 sort(1) cumulative patch
PHCO_38591 swapon(1M) cumulative patch
PHCO_38597 cumulative cpio(1) patch
PHCO_38608 auto_parms/set_parms/dhcpdb2conf cumulative patch
PHCO_38658 libc cumulative patch
PHCO_38669 Dynamic P-states power savings
PHCO_38682 lpspool cumulative patch
PHCO_38683 ksh(1) cumulative patch
PHCO_38752 umount(1m) patch
PHCO_38773 European and Indic TrueType Fonts Cumulative Patch
PHCO_38806 libc manpage cumulative patch
PHCO_38821 audcmnds cumulative patch
PHCO_38823 libpam cumulative patch
PHCO_38832 libc cumulative header file patch
PHCO_38847 psrset(1M) cumulative patch
PHCO_38858 quota(1) cumulative patch
PHCO_38927 intctl(1M) and intrbald(1M) cumulative patch
PHCO_38958 crashconf(1M) cumulative patch
PHCO_38982 syslogd(1M) cumulative patch
PHCO_38992 ps(1) cumulative patch
PHCO_39038 mount(1m) manpage patch
PHCO_39039 fstab(4) manpage patch
PHCO_39040 compress (1) cumulative patch
PHCO_39041 compact (1) cumulative patch
PHCO_39042 cron(1M) cumulative patch
PHCO_39051 libsys cumulative patch
PHCO_39062 iofind(1M) and io_redirect_dsf(1M) cumulative patch
PHCO_39064 FirstBoot sysinfo.4 manpage patch
PHCO_39115 Linker/Compiler/Unwind ENG Manpage Patch
PHCO_39121 loratune(1M) cumulative patch
PHCO_39137 pmap(1) cumulative patch
PHCO_39174 tztab(4) cumulative patch
PHCO_39214 sar(1M) cumulative patch
PHCO_39226 tee(1) cumulative patch
PHCO_39261 pstatectl man page
PHCO_39365 login(1) cumulative patch
PHCO_39366 libpam_unix cumulative patch
PHCO_39367 passwd(1) cumulative patch
PHCO_39368 hpsecurity.h cumulative patch
PHCO_39369 libsec cumulative patch
PHCO_39370 su cumulative patch
PHCO_39371 /sbin/initcond cumulative patch
PHCO_39410 Complex Scripts PostScript printing patch
PHCO_39418 mediainit(1) cumulative patch
PHCO_39485 sfd cumulative patch
PHCO_39608 vi(1)/ex(1) cumulative patch
PHCO_39672 CDFS mount(1M) cumulative patch
PHCO_39673 mount(1m) patch
PHCO_39674 umount(1M) cumulative patch
PHCO_39675 mount_cdfs(1M) man page patch
PHCO_39682 crashutil(1M) support to control libcrash cache
PHCO_39690 reboot(1M), shutdown(1M) cumulative patch
PHCO_39713 security manpages cumulative patch
PHCO_39716 getconf(1) cumulative patch
PHCO_39739 mkboot(1M) cumulative patch
PHCO_39881 pax(1) cumulative patch
PHCO_39889 vxdump(1m) cumulative patch
PHCO_39927 fsdaemon(1m) cumulative patch
PHCO_40072 libpam_hpsec cumulative patch
PHCO_40087 Event Management (EVM) cumulative patch
PHCO_40123 sh-posix(1) cumulative patch
PHCO_40174 Cumulative defect fix, 64-bit savecrash(1M)
PHCO_40198 rc cumulative patch
PHCO_40220 olrad(1M) cumulative patch
PHCO_40238 VxFS4.1 setext(1M) cumulative patch
PHCO_40290 VRTS 5.0 GARP6 VRTSfsman Command Patch
PHCO_40291 IOTreeModule Provider Patch
PHCO_40362 rbac cumulative patch
PHCO_40381 diskowner(1M) cumulative patch
PHCO_40404 machinfo cumulative patch
PHCO_40446 mksf(1M) cumulative patch
PHCO_40460 frecover(1M)/fbackup(1M) cumulative patch
PHCO_40553 kernel configuration commands patch
PHCO_40554 Mass Storage CRA Cumulative Patch
PHCO_40590 localmount cumulative patch
PHCO_40677 setboot(1M) cumulative patch
PHCO_40899 iocdsfd(1M) and io_cdsf_config(1M) patch
PHCO_40921 scsimgr cumulative patch
PHCO_40925 ioinit(1M) cumulative patch
PHCO_40926 ioscan(1M) cumulative patch
PHCO_40927 cumulative libipmimsg patch
PHCO_41072 VRTS 5.0 MP1 VRTSvxfs Command Patch
PHCO_41092 pthread library cumulative patch
PHCO_41202 Software Distributor Cumulative Patch
PHKL_36261 Integrity Virtual Machine Capabilities Interface
PHKL_36324 maxrsessiz(5) man page
PHKL_36326 reading kernel memory using /dev/mem can cause panic
PHKL_36389 Firmware interface support for MCA recovery
PHKL_36443 PCI Error Recovery,Dynamic NPartitions
PHKL_36534 Man page for mca_recovery_on tunable
PHKL_36779 MSI/MSI-X interrupt migration performance fix
PHKL_36790 Fibre Channel Mass Storage Patch
PHKL_37247 IDE/ATAPI cumulative patch
PHKL_37405 OSC Byte swap _OSC arguments and return data
PHKL_37441 Enable HP internal firmware logging support tools
PHKL_37473 timer cumulative patch
PHKL_37511 English fcntl(2) manpage patch
PHKL_37849 DynsysVsem man page patch
PHKL_37870 USB setboot, Cumulative setboot
PHKL_38056 thread level signal enhancements manpage patch
PHKL_38081 timer manpage patch
PHKL_38089 intr_disp cumulative patch
PHKL_38093 wsio.h header file patch
PHKL_38095 ngroups_max(5) cumulative patch
PHKL_38193 credentials cumulative patch
PHKL_38207 dump_tune manpages patch
PHKL_38290 idds cumulative patch
PHKL_38369 kevm cumulative patch
PHKL_38389 AIO Patch
PHKL_38396 lofs cumulative patch
PHKL_38612 Fix for DNLC hang
PHKL_38653 perfmon cumulative patch
PHKL_38681 Power mgmt and Dynamic P-states support
PHKL_38686 unistd_h cumulative patch
PHKL_38687 sysconf(2) cumulative patch
PHKL_38688 sysconf_man cumulative patch
PHKL_38691 pm clock cumulative patch
PHKL_38693 time accounting cumulative patch
PHKL_38734 gio_pub.h header file patch
PHKL_38746 kernel tunables infrastructure cumulative patch
PHKL_38772 vPars PSM component for vPars A.05.05 release
PHKL_38776 nbp cumulative patch
PHKL_38778 vm_vasm_shlib cumulative patch
PHKL_38800 Process-Specific Data cumulative patch
PHKL_38857 livedump cumulative patch
PHKL_38925 Platform Interface Support, module unload
PHKL_38929 ivt cumulative patch
PHKL_38933 Support for PCI Express MCA error records
PHKL_38936 fs_spec cumulative patch
PHKL_38937 fs_util cumulative patch
PHKL_38980 loratune cumulative patch
PHKL_38994 thread level signal enhancements patch
PHKL_39032 sec cumulative patch
PHKL_39034 diskaudit cumulative patch
PHKL_39036 vnode.h cumulative patch
PHKL_39037 vfs.h cumulative patch
PHKL_39050 pm_usync_man cumulative patch
PHKL_39061 rwlock cumulative patch
PHKL_39328 PCI ER, greater than 4K page size, I/O Chassis OLA
PHKL_39353 Cumulative performance tools patch
PHKL_39398 ACPI cumulative patch
PHKL_39399 SMBIOS cumulative patch
PHKL_39434 PCI bridge support for hotplug,PCIe ER,Graphics
PHKL_39435 PCIe support for Slots,OLRAD,PCIe ER,USB
PHKL_39470 ACPI changes for PCIe OLRAD support
PHKL_39476 olstar cumulative patch
PHKL_39478 PCIe IO slots, CPU and memory OLAD support
PHKL_39589 asyncdsk cumulative patch
PHKL_39590 scheduler power management cumulative patch
PHKL_39594 vfs_bio QoS patch
PHKL_39596 conf.h header file patch
PHKL_39599 fs_pstat cumulative patch
PHKL_39606 PRM/FSS cumulative patch with LVM enhancement
PHKL_39622 callouts cumulative patch
PHKL_39641 Incorrect displayed number of CPUs
PHKL_39646 SCSI cumulative I/O patch
PHKL_39656 override_umask tunable man page
PHKL_39694 cumulative gvid patch
PHKL_39695 I/O Port Space and PCIe Graphics gvid driver
PHKL_39705 accounting cumulative patch
PHKL_39757 mtio.h header file patch
PHKL_39814 Kernel Signals Infrastructure cumulative patch
PHKL_39842 Cumulative diag2 driver defect fixes
PHKL_39851 eschgr driver patch
PHKL_39859 vfs_scalls override_umask,cumulative patch
PHKL_40105 sec_net_rules cumulative patch
PHKL_40132 Ptov Alias Chains
PHKL_40136 vm page table mgmt cumulative patch
PHKL_40155 Platform error handling patch
PHKL_40160 Kernel debugger cumulative patch
PHKL_40166 boot loader cumulative patch
PHKL_40167 vfs cumulative patch
PHKL_40204 kernel access infrastructure cumulative patch
PHKL_40205 diagnostic memory driver cumulative patch
PHKL_40209 CPU and memory OLAD support
PHKL_40210 Integrity Processor Migration Performance
PHKL_40226 USB 2.0, DVD Write, Cumulative USB Patch
PHKL_40236 shutdown cumulative patch
PHKL_40273 TLB,MCA Recovery,HPVM,NUMA,P-State,IPMI Events,OsName
PHKL_40281 Fabric Services cumulative patch
PHKL_40282 Cumulative IPMI defect patch
PHKL_40293 pm pstat cumulative patch
PHKL_40297 CMC Records, PCIe Error Recovery
PHKL_40316 Kernel Memory Migration (KMM) support
PHKL_40317 Claim new system PCI devices
PHKL_40351 Numa Advisor, resource selection support
PHKL_40352 iomem driver patch
PHKL_40369 Recognize TPM v1.2
PHKL_40372 dev_config cumulative patch
PHKL_40377 hfs cumulative patch
PHKL_40378 Error record support for MCA recovery, PCI Express
PHKL_40386 EFI support for MCA recovery, Pwr Mgmt, TLB, OsName
PHKL_40389 estape cumulative patch
PHKL_40390 HPVM Fix RID length, plus 1 pre-enablement
PHKL_40395 process management cumulative patch
PHKL_40427 Local Memory, PCIe Error Records, OLAD support
PHKL_40431 ACPI CA cumulative patch
PHKL_40434 pm misc cumulative patch
PHKL_40435 kernel threads cumulative patch
PHKL_40450 DLKM Infrastructure cumulative patch
PHKL_40459 Audio Driver fix, TLB transactions, memory table fix
PHKL_40506 sec_file_rules cumulative patch
PHKL_40523 kconfig cumulative patch
PHKL_40524 krs cumulative patch
PHKL_40531 cdfs cumulative patch
PHKL_40604 Interrupt Migration Fixes, Root Port OLAD
PHKL_40608 vfs_vnops cumulative patch
PHKL_40627 Buffer cache cumulative patch
PHKL_40640 vxfs4.1 cumulative patch
PHKL_40682 ttrace(2) cumulative patch
PHKL_40845 audit cumulative patch
PHKL_40910 Low level serial console increase output rate
PHKL_40922 esctl cumulative patch
PHKL_40938 Local Memory, CPU and memory OLAD support,IPMI Events
PHKL_40939 DynamicNPars, Power Mgmt, Partition ID, OLAD support
PHKL_40940 CEC Common Service Layer, and OLAD Support
PHKL_40944 fs_filedscrp cumulative patch
PHKL_40963 scheduler cumulative patch
PHKL_40994 dump cumulative patch
PHKL_41000 Cumulative spin,ktracer,KI patch
PHKL_41006 esdisk cumulative patch
PHKL_41008 system call infrastructure cumulative patch
PHKL_41036 USB devices, setboot cumulative patch
PHKL_41083 share_header cumulative patch
PHKL_41084 OLA/R/D subsystem cumulative patch
PHKL_41085 GIO cumulative patch
PHKL_41086 vfs_lock cumulative patch
PHKL_41087 fcntl header file patch
PHKL_41093 io cumulative patch
PHKL_41107 pm_usync cumulative patch
PHKL_41205 WSIO subsystem cumulative patch
PHKL_41227 clock cumulative patch
PHKL_41229 VRTS 5.0 MP1P1 VRTSvxfs Kernel Patch
PHKL_41301 PCI cumulative patch
PHKL_41302 PCIe ER, and virtualization support
PHKL_41355 vm cumulative patch
PHNE_37726 identd(1M) manpage patch
PHNE_38419 r-commands cumulative mega-patch
PHNE_38495 100BT unified driver cumulative patch
PHNE_38934 inetd(1M) cumulative patch
PHNE_39717 Networking commands cumulative patch
PHNE_39873 NTP timeservices upgrade plus utilities
PHNE_40215 LAN cumulative patch
PHNE_40406 nettl(1M), netfmt(1M) and nettladm(1M) patch
PHNE_40428 STREAMS Cumulative Patch
PHNE_40516 Cumulative Console and BSD Pty Patch
PHNE_41004 cumulative ARPA Transport patch
PHSS_36604 X11 Font Library Patch
PHSS_37042 hppac
PHSS_37226 X Font Server Patch
PHSS_37902 FORTRAN I/O Library [libIO77]
PHSS_38155 bundled PA C compiler on IPF
PHSS_39122 HP DCE 2.0 client cumulative patch
PHSS_39266 WDB and PXDB Patch
PHSS_39650 3.2.3 cumulative patch
PHSS_40007 X/Motif Runtime Patch
PHSS_40540 Math Library Cumulative Patch
PHSS_40542 Integrity Unwind Library
PHSS_40544 aC++ Runtime (IA: A.06.25, PA: A.03.85)
PHSS_40546 assembler patch
PHSS_40799 FORTRAN Intrinsics libF90
PHSS_40804 LIBCL patch
PHSS_41099 Aries cumulative patch
PHSS_41106 Xserver cumulative patch
PHSS_41168 KRB5-Client Version 1.3.5.03 Cumulative patch
PHSS_41179 linker + fdp cumulative patch
$
env
Дата: 22.03.2011 13:11:42
wurdu,

SLES 11 x64
+ sqlplus,nls_lang=american_america
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL>
SQL> set autotrace on explain statistics;
SQL>
SQL> select max(dat) from tst
  2      union all
  3  select max(dat) from tst;

MAX(DAT)
---------
21-MAR-11
21-MAR-11
21-MAR-11


Execution Plan
----------------------------------------------------------
Plan hash value: 1399671151

------------------------------------------------------------------------------------------------
| Id  | Operation               | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |      |     2 |    18 |    48  (50)| 00:00:01 |       |       |
|   1 |  UNION-ALL              |      |       |       |            |          |       |       |
|   2 |   PARTITION RANGE SINGLE|      |     1 |     9 |            |          |     1 |     1 |
|   3 |    SORT AGGREGATE       |      |     1 |     9 |            |          |       |       |
|   4 |     TABLE ACCESS FULL   | TST  |     1 |     9 |    24   (0)| 00:00:01 |     1 |     1 |
|   5 |   PARTITION RANGE SINGLE|      |     1 |     9 |            |          |     1 |     1 |
|   6 |    SORT AGGREGATE       |      |     1 |     9 |            |          |       |       |
|   7 |     TABLE ACCESS FULL   | TST  |     1 |     9 |    24   (0)| 00:00:01 |     1 |     1 |
------------------------------------------------------------------------------------------------

Note
-----
   - dynamic sampling used for this statement (level=2)


Statistics
----------------------------------------------------------
         13  recursive calls
          0  db block gets
         94  consistent gets
          0  physical reads
          0  redo size
        387  bytes sent via SQL*Net to client
        476  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          3  rows processed

+ Sql Developer

BANNER                                                                           
-------------------------------------------------------------------------------- 
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production     
PL/SQL Release 11.2.0.2.0 - Production                                           
CORE	11.2.0.2.0	Production                                                         
TNS for Linux: Version 11.2.0.2.0 - Production                                   
NLSRTL Version 11.2.0.2.0 - Production                                           

Autotrace Enabled
Displays the execution plan only.
MAX(DAT)                  
------------------------- 
21.03.11 00:00:00         
21.03.11 00:00:00         

Plan hash value: 1399671151
 
------------------------------------------------------------------------------------------------
| Id  | Operation               | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |      |     2 |    18 |    48  (50)| 00:00:01 |       |       |
|   1 |  UNION-ALL              |      |       |       |            |          |       |       |
|   2 |   PARTITION RANGE SINGLE|      |     1 |     9 |            |          |     1 |     1 |
|   3 |    SORT AGGREGATE       |      |     1 |     9 |            |          |       |       |
|   4 |     TABLE ACCESS FULL   | TST  |     1 |     9 |    24   (0)| 00:00:01 |     1 |     1 |
|   5 |   PARTITION RANGE SINGLE|      |     1 |     9 |            |          |     1 |     1 |
|   6 |    SORT AGGREGATE       |      |     1 |     9 |            |          |       |       |
|   7 |     TABLE ACCESS FULL   | TST  |     1 |     9 |    24   (0)| 00:00:01 |     1 |     1 |
------------------------------------------------------------------------------------------------
 
Note
-----
   - dynamic sampling used for this statement (level=2)


Забавненько