500 likes | 562 Views
Oracle 11g R1 Top Features for Developers & DBA’s. August 2008. Agenda. This is mean to be more of an open discussion No set time per topic - each topic has just enough info to spur questions and/or open a dialog – so talk Feel free to ask questions about other topics
E N D
Oracle 11g R1 Top Features for Developers & DBA’s August 2008
Agenda • This is mean to be more of an open discussion • No set time per topic - each topic has just enough info to spur questions and/or open a dialog – so talk • Feel free to ask questions about other topics • No cell phones with ringer turned on (use vibrate) • Email only during breaks under penalty of death • 11g adoption may have been slow – but: • 11g R1 is now over one year old • 11G R2 beta will be starting soon
Focus • 11g has huge growth in functionality (install size, resource consumption, time to create database, etc) • Too many features to cover them all in few hours!!! • Will concentrate on key ones you may encounter • Don’t underestimate Oracle (don’t drink our cool aid) • MS SQL Server 2008 (coming soon) is real threat • Oracle may have to adjust to compete (lower price)
Oracle vs. Toad Timeline 9iR2 Original Toad Freeware Dec ‘00 Oct ‘98 June ‘99 April ‘01 Dec ‘01 Feb ’00 Apr ‘02 Oct ‘02 May ‘03 v5Initial Quest release.Yahoo! Groups and Toadsoft.com established. V6.1 Already has 70 distinct screens. V6.3 Debugger, SQL Modeler, Oracle 8 object support. v6.5DBA Module. v7.2Script Manager, SQL*Loader Wizard. v7.0Toad Reports. v7.3HTML Schema Generator, CMD Line Support. v7.4Project Manager, QSR. v7.5Team Coding,Data Grid support foradvanced data types. 9.2.0.8 10gR2 10.2.0.4 11gR1 Toad for Oracle Freeware Update July ‘05 Nov ’07 Apr ’08 Jun ’07 Nov ‘03 July ‘04 June ‘05 Oct ’05 Oct ’06 v9.5Integration with SQL Optimizer 7.2 Debugger, Profiler, Code Xpert enhancements. StatsPack Browser Oracle 11g support. v9.6Debugger into Standard, Schema Browser merged with DB Browser, integration with QCTO and TDM, Vulnerability Assessment in Health Check v9.1Policy Manager. Action Recall. Toad Tips Vista support. v7.6Session Browser,new toolbars. v8.0XML Support,CodeXpert,Script Debugger.Rebranded –Toad for Oracle v8.5JIT Debugging,Citrix, RAC, enhanced 10gsupport. v8.6Re-designedModeler, M/D Brower,New Reporting Engine. v9.0Single Merged Editor. Improved CodeXpert integration. ASM, ADDM, AWR Mgt
Oracle Tech Net Opinion: www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/index.html
Real Application Testing (RAT) Look familiar? Essentially Asynchronous Shareplex
Flash Back Transaction SQL> select xid, start_scn, operation, table_name, undo_sql from flashback_transaction_query where start_timestamp>=sysdate-1 and username='BERT' and table_owner='BERT'; XID START_SCN OPERATION TABLE_NAME UNDO_SQL ---------------- ---------- ---------- ------------ -------------------------------------------------------------- 0200030052030000 475697 DELETE JUNK insert into "BERT"."JUNK"("C1","C2") values ('5','6'); 0200030052030000 475697 DELETE JUNK insert into "BERT"."JUNK"("C1","C2") values ('3','4'); 0200030052030000 475697 INSERT JUNK delete from "BERT"."JUNK" where ROWID = 'AAAD94AAAAAAChOAAD'; 0200030052030000 475697 INSERT JUNK delete from "BERT"."JUNK" where ROWID = 'AAAD94AAAAAAChOAAC'; 0200030052030000 475697 INSERT JUNK delete from "BERT"."JUNK" where ROWID = 'AAAD94AAAAAAChOAAB'; 0200030052030000 475697 INSERT JUNK delete from "BERT"."JUNK" where ROWID = 'AAAD94AAAAAAChOAAA'; SQL> select * from bert.junk; C1 C2 ---------- ---------- 1 2 7 8 SQL> declare trans_arr XID_ARRAY; begin trans_arr := xid_array('0200030052030000','0200030052030000'); dbms_flashback.transaction_backout (numtxns => 1, xids => trans_arr, options => dbms_flashback.cascade); end; / SQL> select * from bert.junk; C1 C2 ---------- ---------- 1 2 3 4 5 6 7 8
Flash Back Data Archive This new feature offers the ability to retain the reciprocal UNDO information for critical data significantly beyond the point in time that it would be flushed out of the UNDO tablespace. Therefore, it’s now possible to hold onto these reciprocal transactions essentially indefinitely. Once this feature is enabled, all retained transaction history can be viewed, and this eliminates the cumbersome task of creating corresponding history tracking tables for critical transactional tables. SQL> create tablespace flash_archive datafile 'c:\oracle\oradata\ordb1\flash_archive.dbf' size 50M; Tablespace created SQL> create flashback archive default flash_archive tablespace flash_archive retention 30 day; Flashback archive created. SQL> create table bert.junk (c1 int, c2 int) flashback archive flash_archive; Table created.
SQL Query Result Cache The SQL query result cache is an area of memory in the Shared Global Area (SGA) that can retain the result sets that a query generates.