Posts tagged 11gr2
Oracle RDBMS 11gR2 – goodbye Connect By or: the end of hierarchical querying as we know it
Many years ago, Oracle basically set the standard in SQL. Whatever was Oracle SQL could be seen as the standard. This has never been absolutely true – ANSIÂ SQL was different from Oracle SQL. In some respects the differences can be traced back to lack of functional richness in the standard. However, in certain areas, Oracle has walked its own path with certain functions and features with the rest of the RDBMS pack following another route. It seems to be as if starting with Oracle RDBMS 9iR2, Oracle has made several important steps towards embracing the ANSIÂ SQL standard syntax, usually while maintaining its own specific flavor of those same functions.
Some examples of Oracle specific syntax that are also available through their ANSIÂ SQLÂ counterpart – that in most instances has even more functionality – and that is almost always the preferred approach going forward:
- outer join syntax: in addition to Oracle’s (+) notation, 9iR2 introduced the left outer join, right outer join and full outer join (like (+) on both ends of the join condition, something that Oracle does not support)
- the Decode function that with 9iR2 can (and should) be replace by the CASE expression
- the to_char More >
Oracle RDBMS 11gR2 – Flash Cache
I noticed yesterday a new feature that could have the potential to be a small, by me unnoticed, gem called "Flash Cache". I hope someone on the internet, that has tested it, will post his or hers experiences on this…
While using DBMS_METADATA:
select dbms_metadata.get_ddl('TABLE','MYDATA', user) from dual;
DBMS_METADATA.GET_DDL(‘TABLE’,'MYDATA’,USER)
——————————————————————————–
CREATE TABLE "XMLDB_USER"."MYDATA"
( "ID" NUMBER(9,0),
"DOC" "SYS"."XMLTYPE"
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT)
TABLESPACE "XML_DATA"
XMLTYPE COLUMN "DOC" STORE AS SECUREFILE BINARY XML (
TABLESPACE "XML_DATA" ENABLE STORAGE IN ROW CHUNK 8192
NOCACHE NOLOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
))
XMLSCHEMA "http://www.myserver.com/MySchema.xsd" ELEMENT "ROOT"
DISALLOW More >
Oracle Open World 2008 – the show is about to begin – what are this year's stars?
It’s a very early Sunday morning in San Francisco. Over the past few days, thousands upon thousands of people arrived into the city – all connected to Oracle in some way – many of whom who were not in the least connected to Oracle only a short time ago (BEA comes to mind, among others). Today is the start of Oracle Open World 2008. With 45.000 or more attendees one of the biggest company parties in the world. A sea of red, flooding the city center.
Ever since I got on the plane with dozens of like minded souls and increasingly since I have arrived here in downtown Frisco, the big question was: what will be the major announcement of the show? Where is the spotlight going to shine? Not much gossip seems to have come out of Redwood Shores. And there are no obvious candidates really. 11gR2 is still on the drawing board it seems, the beta program not yet on its way. BEA was acquired some months ago and all plans with regard to BEA were announced in the beginnen of July. There could be another rabbit pulled out of a high hat – like Oracle Enterprise Linux in 2006 and Oracle VM in 2008. (more…)
Recent Comments