Tuesday, November 08, 2005

Looking for suggestions

I’ve got lots of material I use to talk – however, it is time for an update.  I’m looking for some suggestions for 1 to 2 hour talks.  I’ve got a lot of ideas but I’m always interested in what the people on the other side of the podium want to hear.  I know what I want to say (it’s all about binds… one of my current favorites), but I would like to hear what you would like to hear – what topics about Oracle do you think are “not covered as well as they could be”

Topics like “tuning SQL” or “performance” – too vague.  The topics would have to be much more focused than that.

Any feedback – or just discussion points – appreciated.      

Just realized, based on the first two comments I got – I should have listed the material I already have:

  • All about binds

  • Some SQL Techniques

  • Tools I use (like autotrace, tkprof, statspack and so on)

  • Efficient schema design (IOT’s, clusters, function based indexing, compression)

  • Analytics

  • To hint or not to hint

  • Read and Write consistency

  • Versioning of Data (workspace manager)

  • Top 5 things done wrong.

  • Building test cases

  • PLSQL or Java for stored procedures

  • So, it tuning dead?

  • Flashback

  • Oracle 10g R1/R2 new features
POST A COMMENT

68 Comments:

Anonymous Martin Hrivnak said....

Tom, Analytic SQL is definitely one of those topics. I believe that people in the branch cannot use it and it can save a lot of effort.

Tue Nov 08, 06:39:00 PM EST  

Blogger scubajim said....

Suggested topic, talk about being a scientist. How does one approuch a problem? How does one make hypotheses, design a test, eveluate the results and stop or refine the hypothesis. Of course, give it an Oracle flavor.

Include how to look up the information, learn about the underpinnings. (eg Concepts guide, using the documentation) Include the idea that a failure of a test is not a failure, but gives you important information. Dr.'s use tests that people don't pass all the time to confirm that Johnny doesn't have XYZ disease. Too often people get emotional about what will happen if a test fails. Don't despair, rejoice you know now more than you knew before!

I know this isa broad topic, but you could still sneak binds in there.(smirk)

Tue Nov 08, 06:41:00 PM EST  

Anonymous Bob B said....

1) Creative (and standard) ways to use Oracle object types to write better/faster queries.

2) How best to use XML in Oracle. Many people are jumping on the XML and Oracle bandwagon, but there isn't necessarily enough information on good and bad ways to combine them.

Tue Nov 08, 06:41:00 PM EST  

Blogger Doug Burns said....

Tom,

Something I'd been thinking about myself which I think would be perfect for you is to take a *single* query written in the most basic style and then to show how you could improve it using different approaches and techniques. So instead of showing 'this is probably the best way to do this' you would show that many approaches *could* be taken and *why* you chose one approach over another. Then people would have more insight into how you approach the problem, not just see the solution.

It's a bit like what I tried to do with the DECODE paper but you could use much more complex examples.

Hope that makes sense. Cheers,

Doug

Tue Nov 08, 06:47:00 PM EST  

Anonymous Anonymous said....

I would second the suggestion from bob b on object types. Types and collections in 8i and above are powerful features that in my experience are underutilized by PL/SQL developers.

You’ve presented some good examples of appropriate uses in Expert One-on-One and AskTom.

Tue Nov 08, 06:54:00 PM EST  

Blogger smartDBA said....

One thing I always buffled is this:

Imagine, recently I assumed a proudction database. I thought to make the best out of that database. Now, how to methodically approach for improvement, where to start from - Statspack, Wait Events, SQL area or what? Too many options, which one to pick, who is right, who is wrong? Sounds very trivial, right?

Tue Nov 08, 06:58:00 PM EST  

Anonymous Anonymous said....

I'd like to know exactly how archiving works, what makes it decide to start up more processes, can processes split the work of a given redo file, etc.

Tue Nov 08, 07:26:00 PM EST  

Anonymous Anonymous said....

The topics you listed are good and still worth repeating (there are still many that fail to grasp these). One of the most important topics I think that most overlook is security. Specifically, risk factors of certain packages, proxy users, and auditing. While there is some information Oracle is putting out and some good blogs/websites, they do not have the "reach" or audience that you do.

Tue Nov 08, 07:59:00 PM EST  

Blogger Gary Myers said....

Instrumentation -
1)Dbms_application_info so the DBAs can see where the session is
2)dbms_pipe/dbms_output/utl_file/autonomous transactions to log how the session got there
any other concepts in this field I don't know about

Tue Nov 08, 08:00:00 PM EST  

Anonymous Bob B said....

I was thinking about this some more and then recalled some sage advice from a much older and wiser gentleman than I: "Never stop practicing the basics."

As nice as it is from the speaker's end to come up with new topics, it is critical to revisit the critical basics over and over.

Some time spent on new topics would be good for advanced users, but I think equal time should be spent keeping the basic critical talks (like on binds) fresh for both newbies and experts.

If one person starts using binds (and knows when/why to do it or not), then that seminar was priceless to the Oracle community at large :-)

Tue Nov 08, 08:26:00 PM EST  

Anonymous Colin said....

You could have a page on your website for audio recordings (with say an MP3 recorder) and any slides and examples from any of your presentations. Also, you could have a forum thread somewhere to allow further discussion when you run out fo time during Questions and Answers.

I cannot attend any of the events where you present, so this would be really useful.

Tue Nov 08, 08:36:00 PM EST  

Anonymous Gabe said....

“How to build complex, powerful database applications … simply”

There is that slide with a database at the center of the universe, which I very much subscribe to. A seminar maybe on the “Why” and “How” does one go about implementing that vision with Oracle. Maybe complete with a real test case … AskTom? ... open source ever crossed your mind?

I wish there were more done by Oracle to really push HTMLDB into the application space (particularly Intranet applications) … I know, there is the Express Edition now, so maybe it is coming … for now though, I’m looking at OTN and between the Howto’s (click here then there) and the promised potential there isn’t much.

Tue Nov 08, 09:26:00 PM EST  

Anonymous Tom R said....

I would love to see a talk on Oracle's wait interface. I'd love to hear you speak at our local Oracle Users Group here in Tampa. Love your books.

Keep doing what you do, we really appreciate al the hard work and effort you put into making our lives easier.

Tue Nov 08, 10:54:00 PM EST  

Blogger Mike Barrs said....

Tom,
It would nice to hear about Web Services. Specifically, how Oracle customers are utilizing WS as part of their operations (both internally & externally) using the Oracle Technology stack (DB, App Server). Also, what features of the DB & App server are being utilizing in these implementations.

I’m not sure if this is your area if expertise, but I thought you would have some insight on what some of Oracle’s customers are doing. If this sounds like a good topic, could you include this in your presentation in for the SLOUG in December?

A nice preview of Raptor would be nice too.

Wed Nov 09, 12:26:00 AM EST  

Anonymous Glen said....

hmmm, how about index rebuilding, when/if/should/should not/don't/maybe if..
There is lots of conflicting info out there, perhaps you could clear it up a bit?

Wed Nov 09, 01:29:00 AM EST  

Anonymous Wim said....

The inner workings of the Cost Based Optimizer.

Sometimes it's really difficult to grasp why a certain access path was choosen. If you look at the questions at Oracle support sites (asktom, dba-village, cdo, ...) a lot of people have problems with it (why is my index not used, why does this do a full table scan, ...)

I'm eagerly waiting for the book of Jonathan Lewis.
I know it will be very difficult to fit this in a 2 hour presentation, but you might want to create a trimmed down presentation based on the book.

One of the pages could be the different parameters that influence the behaviour of the CBO: optimizer_features_enabled, db_file_multiblock_read_count, optimizer_index_cost_adj, pga_aggregate_target, ...
Another one the different kinds of join operations: nested loops, hash joins, ...

Wed Nov 09, 02:18:00 AM EST  

Blogger Robert said....

If the audience is "newbish":
Oracle Server architecture (maybe a bit on SQLNet)
And Oracle's implementation of ACID.

Wed Nov 09, 02:42:00 AM EST  

Anonymous sbkumar said....

"So, it tuning dead ?" Thats something I would like hear from an authentic source like you. The direction in which general RDBMSs are moving raises doubt on the value of existing skills in such areas.

Wed Nov 09, 03:54:00 AM EST  

Anonymous Pete Finnigan said....

Hi Tom,

bet you cannot guess that i will suggest security..:-)

How about effective database audit. i.e. the core audit features and how to use them effectively without hitting performance issues. How to interpret results. Using OS based audit effectively. syslog.

or FGA - Martin Jensen does some good stuff on this already though..

Log Miner for security analysis

OLS - I have never seen a goo talk on OLS.

...

cheers

Pete

Wed Nov 09, 04:38:00 AM EST  

Blogger Connor McDonald said....

Easy really...something that I've been meaning to do as well.

It all starts with "Why do people not use a feature ?"

Because they (a) don't know it exists or (b) don't really know what it does.

So for presentation topics... its easy. Namely, pick *any* v10 or v10.2 new feature, or an existing feature that's been evolved in 10 or 10.2, and do it to death. End up with the good, bad and the ugly of that feature.

Plenty of topics there...as much as I expouse people to do this themselves, let face it - not many do.

eg,

dbms_epg
dbms_scheduler
resource manager
rman backup
rman recovery
ASM
ASH
ADDM
AWR
dbms_stats
streams
replication
AQ
expression filter
regular expressions
O-R
LOB's
Dataguard
partitioning
materialized views
CDC
query rewrite
model clause
spatial
data pump
dbms_redefinition
*the list goes on and on and on*

Let me know when you're done... it will save me writing some :-)

Cheers
Connor

Wed Nov 09, 05:36:00 AM EST  

Blogger Tony Andrews said....

PL/SQL exception handling. Almost everyone does it wrong (probably including me sometimes!) For example, the fact that work done in a procedure is not rolled back when an exception is raised, yet experimenting in SQL Plus might lead you to believe it is.

Wed Nov 09, 07:25:00 AM EST  

Anonymous Rob Zijlstra said....

Back to the very basics perhaps? Building a db with relational, normalized tables. (maybe with some remarks from Fabian Pascal in it to give some 'sparks')
It would be a good idea if you could give some examples of the consequences for sql statements if the db is not normalized / relational, and also if it is 'poisoned' by hosts of NULL's.

Wed Nov 09, 07:37:00 AM EST  

Anonymous Anonymous said....

How about "best practices". A set of things which should be done [or avoided] for most standard databases, for example

Security
--------
Locking default user accounts
Profiles to prevent brute forcing
Revoke public permissions on powerful packages
Password protect listener [if < 9i]

Physical Layout
---------------
Avoid RAID5 for write intensive files such as redo logs
Use tablespaces for admin not performance
Always use LMT [not so relevant now]
Whys and wherefores of ASSM.

Essentially a talk which started with no database and ended up with a relatively secure, available [ie multiplex redo, multiplex control files] and recoverable [archivelog mode] database would be such a help to newcomers to Oracle.

If you had time at the end you could run through backup / recovery through RMAN.

Wed Nov 09, 07:43:00 AM EST  

Anonymous Paul said....

Tom - how about :
(i) error trapping
(ii) nls session parameters

Wed Nov 09, 07:45:00 AM EST  

Blogger mattypenny said....

Hi,

I'm not sure whether this is an appropriate topic for a talk (maybe it would be better suited for a post to the blog, or maybe it's better covered elsewhere) but I would be interested to know what your thoughts are on what are Oracle's key technical advantages are over the 'other' databases.

I look after Oracle, Sybase and SQLserver.

If I'm honest, I 'like' Oracle best because:

a) its what I know best and
b) in my view, support in general, and Metalink in particular, are better than the competitors.

Personally, I don't yet know enough about the competitors to be able to effectively argue the case for Oracle, in terms of the nitty-gritty technical stuff (with some exceptions).

The difficulty with this as a topic for a talk (or anything else) might be that it would look like bashing the opposition, but the material I've seen in the past has been so high level, its difficult to relate it to the issues that matter.

Another difficulty is there might be quite a lot of material (!) - maybe a comparison between databases in one specific area might be a good topic. e.g. Performance management and daiagnostics

Cheers

Matt

Wed Nov 09, 08:08:00 AM EST  

Blogger melanie caffrey said....

Tom,

If you create more presentations on 10g "least-used" features, as Connor suggests, *particularly* expression filter, then, for obvious reasons, I'll be there.

:)

It's always good to know what mistakes one has made in one's own presentation.

And how to, of course, improve.

Melanie

Wed Nov 09, 08:27:00 AM EST  

Blogger Thomas Kyte said....

OLS - I have never seen a goo talk on OLS.

Then you have never seen David Knox present it!

Wed Nov 09, 08:40:00 AM EST  

Blogger Paul Moore said....

I agree with Connor's suggestions. There are lots of features that just don't get much press. I loved the section in your book on InterMedia for this reason - it was something I'd never really had the time to look into, so I was missing some good features just from lack of awareness.

My personal suggestions would be AQ and replication. Maybe spatial as well. And although I know you've said in the past that you're not really an "XML guy", something on the simple, but useful, bits of XML that might help those of us who aren't XML guys, would also be pretty good.

Wed Nov 09, 09:02:00 AM EST  

Blogger shrek said....

where to tune what and wen... SQL? database? what information you can get from what treace files. and how to tune when you can't chnage the 3rd party app.

can you tell what i've been tasked with?;-)

Wed Nov 09, 09:11:00 AM EST  

Anonymous Anonymous said....

There are lots of features that just don't get much press.

Hmmmm... features that no-ones heard of or uses... sounds like OCP.

Wed Nov 09, 09:13:00 AM EST  

Blogger Wally said....

Would it be possible to talk about the areas in which Oracle Database 10g Express Edition is going to or not going to compete with MySQL.

Wed Nov 09, 09:35:00 AM EST  

Blogger Thomas Kyte said....

is going to or not going to compete with MySQL.

that doesn't need a talk - the answer is

"well, of course it will, they currently go after a very similar space"

Wed Nov 09, 09:41:00 AM EST  

Anonymous Anonymous said....

> There is that slide with a database
> at the center of the universe, which
> I very much subscribe to. A seminar
> maybe on the “Why” and “How” does
> one go about implementing that
> vision with Oracle. Maybe complete
> with a real test case … AskTom? ...
> open source ever crossed your mind?

Second that: the whole philosophy of "the platform changes, the database changes, the data lives forever", why business applications should be heavily centered on the database, and the history/psychology of why developers resist that approach. Doesn't have to be Oracle-specific.

sPh

Wed Nov 09, 09:59:00 AM EST  

Anonymous Anonymous said....

How about some data warehouse related issues:

dimensional modelling
fact versus dimension tables
bitmap and bitmap-join indexes
materialised views and query rewrite
analytic functions
data mining
OLAP

Rgds,
P

Wed Nov 09, 10:04:00 AM EST  

Anonymous Andrew said....

Consider please, a talk on 'Database Adoption'. That is, taking on management of an existing database. When I do this, I like to get familiar with the operating characteristics of it, check out security, use patterns, log switch rate, etc. I would like to know how you would step through getting to know an existing database that you are going to take over as DBA. What first, second, third, good things to look at right away, what can usually wait. Including when to start getting to know the user community and their perceptions of the database/application and business needs.

Wed Nov 09, 10:04:00 AM EST  

Anonymous Anonymous said....

Summary and Next Steps to 10g RAC and Higher
Availability

1.Define requirements
2.Consider it early
3.Standardize HW/SW
4.Define and Implement Metrics
5.Do Regular Backups
6.Reduce the Amount of Change
7.Document Procedures
8.Build a Change Infrastructure
9.Improve Communication
10.Maximum Availability Architecture

Wed Nov 09, 10:19:00 AM EST  

Blogger David Aldridge said....

With the proliferation of automation in the architecture (all those incredibly similar sets of initials starting with "A") it would be useful to know when we can get advantages by _not_ using them.

For example, when (and what) to tweak to get around individual sessions' memory limitations in automatic PGA management, or what situations might benefit from manual segment space management instead of ASSM.

Wed Nov 09, 10:58:00 AM EST  

Anonymous Anonymous said....

Minimum requirements for adequate Backup and Restores.

I'm still amazed how people I meet are still not doing any backups. When I ask my clients about their backup and restore policy, I hear a long winded explanation on how they will get some data from this tape and some data from this other database, etc.

My rule is this: if any DBA on your staff cannot start a restore/recovery in less than 30 seconds, YOU DO NOT HAVE ADAQUATE BACKUP PROCEDURES.

Wed Nov 09, 11:00:00 AM EST  

Blogger R Menon said....

Tom
The topics would be:
1. code instrumentation
2. PL/sQL exception handling
3. Analytics - your most interesting cases and what your thinking is when arriving at the solution.

TO Wim who wrote
"I'm eagerly waiting for the book of Jonathan Lewis.
I know it will be very difficult to fit this in a 2 hour presentation, but you might want to create a trimmed down presentation based on the book."

Yesterday I ordered it from amazon (in the used section, I was able to get a copy shipping in 1 or 2 days even though amazon said it ships in one or 2 months...

Wed Nov 09, 11:16:00 AM EST  

Anonymous Anonymous said....

1) I would like to see good information on thr 10053 event so that I can look at it and and explain to my management why the CBO isn't as smart as they think it ought to be given what they have paid for it and we need to add hints to make queries run efficiently ( their words - not mine ).
2) Studies on the varying partitioning methods when used in ASM and Non-ASM environments.

Wed Nov 09, 11:51:00 AM EST  

Anonymous Bob B said....

To combine what Connor wrote with a presentation that I believe you do ...

Presentations on new or evolved features that you don't see enough people using. Get more people out of the "Not knowing that they don't know" stage for some of the features that only work in 9i or only work in 10g.

As seen in the past, the more people using the new features, the more new and exciting ways the features will be used. Sometimes they'll be used poorly, but sometimes they'll be used awesomely (think "Select rownum rn from dual connect by level <= :x").

Wed Nov 09, 11:51:00 AM EST  

Anonymous tobias said....

I agree with most of the proposed content here. I think Connor's list and approach is a good starting point.
But, for those of us who can't get to the presentations, how about podcasts (audio and/or video (maybe just with slides)?

I've enjoyed the current ones from otn, but adding more, and specifically your presentations would be great.

Wed Nov 09, 02:58:00 PM EST  

Anonymous Anonymous said....

Put your developer hat on and talk about testing techniques and oracle

- writing test harnesses
- instrumentation
- concurrency
- load testing

Wed Nov 09, 03:08:00 PM EST  

Anonymous Anonymous said....

Tom,
I'd very much like to hear best practices for managing data (for performance) within a RAC setup. When is partitioning necessary? How does one go about optimizing services/mts? The complexities of the global cache, and considerations of blocking and latency.
Thanks

Wed Nov 09, 03:20:00 PM EST  

Blogger Niall said....

well it seems to me that stuff you have demonstrably done well, and is rarely talked about might include.

mentoring.
thinking in sets.
bet you didn't know you could do that in sql.
building test cases.

Wed Nov 09, 03:33:00 PM EST  

Anonymous Anonymous said....

The internal differences between Oracle and all other databases ... specifically SQL/Server ... something you can hand to a manager to say 'No, we can not write generic code that will run effeciently on DBs' ... I'm tire of being told we should be build systems so we can pull out the database layer and replace it with any other DB like the flip of a switch.

Wed Nov 09, 05:40:00 PM EST  

Anonymous jonas said....

Tom,
Some suggestions:
-How to design to perform, with an EJB based application.
-Look on common misstake when non-dbaware "java pepole" make the schema design e.g. using few tables storing generic data.
- comparing using PL/SQL vs. java classes to manipulate data (insert/update/delete/qry).
- PL/SQL vs. java in the database.

Wed Nov 09, 06:10:00 PM EST  

Anonymous Bob B said....

"Everything you wanted to know about AskTom (and a few things you didn't)"

You can cover how you set up:
Security
Auditing
Instrumentation
Table/API Design
Scalability
Etc

Wed Nov 09, 06:27:00 PM EST  

Anonymous Anonymous said....

I would like to see you present complete examples (non_trivial) on using dbms_job to simulate multi-threading, and also parallel pipeline functions.

Wed Nov 09, 07:25:00 PM EST  

Anonymous Anonymous said....

A couple of items I've recently tangled with (something for you at 3am with jet-lag :-)

1) Standby databases for Disaster Recovery. Outline the two methods -oracle controlling the log transfer & application - manual transfer and application. Especially the pros & cons for DR tests. How you cover a DR scenario if it occurs during a DR test. And restoring standby DB after the DR test. (Yup - I need a life ;)

2) Tablespace organisation. Given a large DB with 100s of tables. Some small ( < Mb) some large (> Gb). Suggested ways of placing disparate table sizes into tablespaces, given uniform extents in locally managed T/S. eg. T/S with 32K exents for tables < 5 Mb. T/S with 1Mb extents for tables up to 100Mb ... etc ... Are tables with many extents are issue with locally managed T/S? Or do you have better ideas? Do I worrying about splitting out static tables from high update from high insert?
Is there such a thing as too many T/S?

Thu Nov 10, 04:58:00 AM EST  

Anonymous Anonymous said....

New content for presentations is great, but if I can't attend your presentations then they don't do as much for me. (Yes, I read the slides.)

I agree with the others that mentioned making your presentaions available via audio and/or video would be the most useful thing for the most people...

-LC

Thu Nov 10, 08:05:00 AM EST  

Anonymous Robert Lockard said....

Why do you want a lazy DBA.

I have been in too many shops where the dba's are running around putting out fires all day. In this shop I manage 6 production databases and an slew of test and development databases. And I normally get enough time everyday to read the latest Tom Kyte thriller at while at work.

-Rob

Thu Nov 10, 08:42:00 AM EST  

Anonymous Anonymous said....

Tuning with DB Links

Thu Nov 10, 09:56:00 AM EST  

Anonymous JulesLt said....

Another vote for :

Analytic functions - they look very powerful, but the syntax is so off-putting. I went to a presentation at the UKOUG and didn't come away a lot wiser - I think something more example led may be better.

Oh, and Oracle AQ. I mean that's a book in itself - I've found some of it's idiosyncracies through using it, and that's really been little more than a persistent pipe.

I know that in theory I should be able to set it up to take a JMS message containing an XML payload then use a PL/SQL callback to do something with that XML. A case study on how to do that would be great.

Thu Nov 10, 10:11:00 AM EST  

Blogger Alberto Dell'Era said....

10gR2 LOG ERRORS !

Thu Nov 10, 04:30:00 PM EST  

Blogger Robert said....

hmmm is this the largest number of comments you ever got for a post ?

Thu Nov 10, 09:43:00 PM EST  

Anonymous doug c said....

How about a talk called "Things are Slow". I'll say speaking from my own experience, and it isn't necessarily everyone else's, that the most annoying call I get is "Things are slow.. can you check it out?".. or "This query is slow.. why?". Usually this query is made under duress and is attempt to deflect attention to the DBA, or at least it seems that way to me. So then comes my standard series of initial questions - 1) Where are you running it? (what db and server - yes... people leave that out). 2)What makes you say it is slow? The answer is usually - well it was fine this morning, all last week, or whatever. 3) Are you running the same thing you ran this morning?
You get the idea. 7x out of 10 the developer just dissapears after a few hours because they figured something out and they were just trying to tell their superior that "the DBA is looking at it". But, 3x out of 10 it can get quite involved, traces and so forth, somtimes tars, sometimes questions to you :-) I think this would make a cool talk, what to do when you get that call at 9pm and your trying to eat dinner.

Fri Nov 11, 02:03:00 AM EST  

Blogger Rich said....

Hello there Tom,

My first vote: The Oracle Application Server now has a rules engine, how about a PL/SQL integration with the rules engine presentation.

2nd: Analytic functions with tons of good examples.

Finally: You might consider a getting started/newbies presentation. If you go with this one it should only assume that the person knows very basic SQL (presenting everything from a simple install of a test database on a desktop, starting up and using sql in sql*plus, running annonymous blocks, compiling pl/sql objects and executing them in sql*plus, other development tools, etc.. I know it's been done before, but I'd love to see it done by the best.

Best regards...Rich Murnane

Fri Nov 11, 07:26:00 AM EST  

Anonymous Anonymous said....

Oracle XE:
Where do you see it going?
-
Database Technology
Keep up? How do we do it? There's only 24 hrs in my day. What about yours.
--

Fri Nov 11, 08:27:00 AM EST  

Anonymous Carl said....

Always a pleasure to here you go on about binding again :)
Apart from that - making best use of oracle functionality i.e not having to always use third party software or refusing to use any functionality newer than 7.3....
Code instrumentation definitely, then maybe I'll start picking up the hint and get better at using it myself.
Also a full walkthrough of how you would approach an example performance problem - recognising the problem, finding it and resolving it in a 'scientific' fashion using oracle tools (plus common sense and experience!) not guesswork and rules of thumb.

Fri Nov 11, 10:17:00 AM EST  

Anonymous Tim said....

I will be prototyping a database application for a Doctors office using Oracle XE. It is my intention of making it very scalable. Future versions may be integrated with Collaboration Suite. Is there a good way to design a schema which will mesh well for appointment scheduling?
In other words a topic on designing for future use with enterprise solutions would be good.

Fri Nov 11, 11:32:00 AM EST  

Blogger David Aldridge said....

>> In other words a topic on designing for future use with enterprise solutions would be good <<

Ah, synthetic keys!

:D

Fri Nov 11, 03:00:00 PM EST  

Blogger oracos said....

Tom,
how about anything that:
--has not been discussed in any of your 3 tuning books;
--has not been discussed in Jonathan's Ora 8i book;
--has not been discussed in Cary Millsap's book;

particularly:
--some performance tools/clauses/interfaces/improvements in the upcoming/unreleased Ora version (something like a goodies/Christmas bag -- that we can't touch -- but are lucky to have you for a preview "handover" ;-)

.... maybe, related to OLAP, analytics, bulk processing.... anything that eliminates (ha!) or more correct minimizes wait states in processing. After all, Oracle development is all about minimizing waits!!!

Fri Nov 11, 03:38:00 PM EST  

Blogger Peter Lewis said....

Rich wrote: "Finally: You might consider a getting started/newbies presentation... I know it's been done before, but I'd love to see it done by the best"

Well I thought Lisa had that all well wrapped up at UKOUG...

I'd certainly welcome a talk that addresses the close teamworking and working relationships that are so necessary between DBAs, developers, and over-keen (micro) managers; this would go down a treat (well, for the DBAs and developers at least). You cover much of this stuff nicely in the first chapter of your new book. Highly-effective teamwork really is ever so important and yet sometimes ever so difficult to achieve.

Pete

Fri Nov 11, 04:14:00 PM EST  

Anonymous Bob B said....

How about a presentation on the _fast=true setting?

*smiles*

Fri Nov 11, 09:48:00 PM EST  

Anonymous Marco Cunha said....

Tom,
A topic about Versioning of Data(workspace manager) would be great.

Could talk about Temporal Database (if it applies to workspace manager).

Sat Nov 12, 07:17:00 AM EST  

Anonymous Markku Uttula said....

Well, since you asked; I'd be dieing to hear "Oracle Object Types as used by Tom Kyte - and a view on other possible approaches".

Mostly I'm interested in this for the very selfish reason that the pros and cons of using object types are not too easy to find amongst all the material there is. For example; many books that out there seem to only scracth the surface of the subject (if they touch it at all).

They've been around a while now ... why don't we still know more about them :)

Sat Nov 12, 06:11:00 PM EST  

Anonymous Mike said....

Discussing the tools you use would be helpful. In particular, how you structure your laptop for PPT presentations and linux-based Oracle demos or experimentation. Are you using VMWare Workstation to accomplish this? Other? Other ideas or tools you load and travel with for Oracle environments on your laptop. You get the idea -- I think this would be interesting and helpful. Thanks for asking.

Sun Nov 13, 01:18:00 AM EST  

POST A COMMENT

<< Home