The third book will be the supplied packages (breaking Expert One on One Oracle into three books as it was just getting way too long). But that is later.
Anyway, I want feedback on my proposed topics. If you’ve read Expert One on One, you can see what has been dropped namely:
- plan stability
- autonomous transactions (briefly covered in the new Architecture book)
- dynamic sql
And external procedures will be significantly – much – smaller. Lots of new stuff and all updated. Feedback will not only be gratefully accepted, it will be used when I think it makes sense (and I’ll post a new outline later as it evolves).
Short light and fluffy section to get going – why you have to design if you want to have any of the following three items…
Design to perform
Design to scale
Design to secure
Performance & Scalability
Very much like the existing work in Expert One on One but redone to cover the new tools, new options. Statistics is all new, I ignore that in the first book. All about binding covers everything – performance, scaling, memory utilization, SECURITY, peeking, cursor sharing exact, force and similar.
All About Binding
I had FGAC the first time (but a LOT has changed), and a preliminary N-Tier (to be totally redone). Grants, roles and the like – new. Auditing – new. Invokers and Definers rights will be perhaps the least changed of all chapters…
Grants, Roles and the like
Fine Grained Access Control
N-Tier Proxy Authentication
Advanced SQL Features
Lots to add to analytics! Materialized views, much to add. Practical Partitioning – in the Architecture book I described “how” they work, here I’d like to look at practical use cases. So, it’ll be different from the Architecture.
Spatial will be new… External procedures will be much de-emphasized, as they have been in real life with the advent of java stored procedures over time. Object Relational will be from the perspective of “using them in PLSQL to make PLSQL a better language”, not using them to store data in the database…
External & Java stored procedures
Object Relational Features
NOTE: I've disabled comments on this entry, if you have any - please see Next Book, Part II