Tuesday, September 20, 2005

OOW - presentation day

Today I have my session - Cary Millsap and I will be co-presenting. Our topic is the top ten things about Oracle 10gR2 - but we couldn't decide on just ten so it is really eleven plus some honorable mentions.

The topics we'll be hitting with discussion and demonstration will be: 

  • Conditional Compilation in PLSQL
  • Better trace file information (in the raw trace file, timestamps on wait event records)
  • Full Database Transports
  • XQuery
  • Asynchronous Commit
  • SGA Direct Attach
  • Transparent Data Encryption
  • Transporting AWR data
  • LOG ERRORS clause
  • Audit trail in XML format
  • Online Tablespace Transport

The honorable mentions include - autotrace using dbms_xplan (much better output), dbms_output limitations removed (unlimited output and 32k line widths), restore points, automatic failover with standbys, datapump metadata compression and secure backup.

Nervous. Big big room. Little sleep last night, up very early this morning. Normal life resumes at noon west coast time (after the presentation)

POST A COMMENT

12 Comments:

Anonymous oraboy said....

Good luck to both of you.
I cant wait for this see this presentation posted online..(too bad, I am one of those unfortunates who cant make it to OracleWorld)

Neverthless, each bulleted item in your list interests me and makes me curious to know more..(more than what is that feature about, I am really interested to know on what factors you two have picked these features)..

Tue Sep 20, 10:31:00 AM EDT  

Blogger Thomas Kyte said....

really interested to know on what factors

simply because they are things that impact us immediate.

conditional compilation - I always had it in C, some developers won't put debug code in (afraid to "slow" down production code - very misguided of them) so this will be the tool I can use to MAKE them put debug code in as we can "compile it out" later and turn it on when we need it.

better trace file data was Carys, he was pretty excited about it (nothing in the documentation, just stumbled upon it). It will break some custom tools that parse trace files - but it is worth it.

full database transports -- the ability to move an entire database from platform X to Y - no rebuild, no dump and load (have to be same byte order though). Much asked for feature.

Async commits - to finally remove the performance issue the people that INSIST on committing every stupid row in a data load (or every 100 rows or whatever).....

XQuery - Cary is very much into this one (but he likes perl too so....)

SGA direct attach - obvious, hung database, need to know what is going on.

Tranparent data encryption -- we'll just read this

Transporting AWR data - you can give it to me and let me work on it (when I'm office bound and not on site with you). You can consolidate it, you can analyze it on another system instead of hitting a production system that is already apparently having a problem.

LOG ERRORS - well, I wrote some blog entries about that. Wow, that is cool.

Tue Sep 20, 10:41:00 AM EDT  

Blogger Mathew Butler said....

Good luck.

Will the slides be available for general viewing?

Tue Sep 20, 10:42:00 AM EDT  

Blogger Marcio said....

Is this presentation going to be available online later?

Regards,
Marcio Portes

Tue Sep 20, 10:50:00 AM EDT  

Blogger Thomas Kyte said....

Is this presentation going to be available online later?

sure, i have to incorporate a couple of comments on the white paper that goes with it and I'll put them on asktom soon for download.

they'll be on OTN as well.

Tue Sep 20, 10:56:00 AM EDT  

Blogger Peter K said....

Sounds like fun.

Oh, on Brian Duffy's aggregator, this entry was displayed as:

Today I have my session - Cary Millsap and I will be co-presenting. Our topic is the top ten things about Oracle 10gR2 - but we couldn't decide on just ten so it is really eleven plus some honorable mentions.The topics we'll be hitting with discussion and demonstration will be:Big big room. Little sleep last night, up very early this morning. Normal life resumes at noon west coast time


I thought "Big, big room", "Little sleep last night", "up very early this morning", and "Normal life resumes at noon west coast time" are all very nice Oracle 10g features :)

Tue Sep 20, 12:57:00 PM EDT  

Blogger Laurent Schneider said....

Great great great presentation!
I read the new features online doc before, but I just missed this GREAT enhancement that you do not need to make tablespace readonly before transport. This is a life-saver!!! I also like your favorite feature, logging sql errors. DBMS_DDL.WRAP was not in the top 10. But ok, there was so much valuable in your presentation :-)

congrats tom!

Tue Sep 20, 03:26:00 PM EDT  

Anonymous Rob H said....

You're nervous. You're asktom!
(human after all...)

Tue Sep 20, 03:53:00 PM EDT  

Blogger Niall said....

Tom wrote

Async commits - to finally remove the performance issue the people that INSIST on committing every stupid row in a data load (or every 100 rows or whatever).....


[rant]
This is about the only real use I can see for this feature. Speed up badly designed batch processes where you can tolerate dataloss anyway. And doesn't PL/SQL actually already do this anyway? And what are the implementation details, get your badly performing code out of your version control repository, carefully rewrite the bad bits (but not rewrite them exactly just reword the commit statements) check them back in and upgrade live. So you visit the bad code and band-aid it rather than fix it. Yuck. I'd much rather go with Cary's feature where you rewrite known good code to get better results from new features than where you sort of pay half-hearted attention to known bad code.
[/rant]

Ok so what I really hate is the changing of the meaning of the word commit from
'make my changes permanent' to 'attempt to make my changes permanent please'. Its like nologging operations or running in noarchivelog mode - both have their place, but both lose people data and jobs. this will too.

Tue Sep 20, 04:50:00 PM EDT  

Blogger Gary Myers said....

"Async commits -"
Another use for them. I've got a debug type procedure that uses an autonomous transaction to log messages to a table. That way I get to see what the program was doing just before it fell over and rolled back or gets stuck or whatever.
An async commit in the autonomous transaction should make this quicker meaning less performance impact on the overall process.
Now all I need is a 10GR2 setup to test it and see whether there is a practical performance improvement.

Tue Sep 20, 06:56:00 PM EDT  

Anonymous Anonymous said....

"Our topic is the top ten things about Oracle 10gR2 - but we couldn't decide on just ten so it is really eleven plus some honorable mentions."

Wow, you found another great way to show everyone you're full of it.

Tue Sep 20, 11:20:00 PM EDT  

Blogger Thomas Kyte said....

Anonymous said...

Hi mr obvious, welcome back via your anonymous proxy server 203.112.194.81, India this time. Italy, India, you get around.

Remember how to spell "Hypocrisy", you already know the definition.

It would be funny, if it weren't so very very sad.

but hey, thanks for playing!

Wed Sep 21, 02:45:00 AM EDT  

POST A COMMENT

<< Home