Oracle ACEs and Oracle ACE Directors are known for their strong credentials as Oracle community enthusiasts and advocates, with candidates nominated by anyone in the Oracle Technology and Applications communities. The baseline requirements are the same for both designations; however, Oracle ACE Directors work more closely and formally with Oracle in terms of their community activity.
Na SIOUG 2009 nam bodo predavali naslednji "Oraclovi asi":
Piet de Visser, Belgija, Oracle ACE
Piet de Visser is an experienced Database Consultant and DBA. He has been in IT since 1987, and specializes in Oracle and Database-related technology since 1994. Piet combines technical database knowledge with extensive experience in global organizations. His energetic personality and language-skills makes him ideal for pioneering and ground-breaking projects in a multi-national environment. Piet also invests a lot of effort in maintaining a network of Like-Minded Oracle specialists worldwide and is a regular speaker at international usergroup events and symposia. Piet likes to travel, speaks various languages more or less fluently, and is alway interested in learning how to say "Hello" and "Thank You" in a few more languages, provided he can learn it in-situ. Piet specializes in Oracle databases and High-Availability, deployment and performance. His philosophy is that Simple systems are easier to maintain and to run and therefore offer better Availability.
Predavanja na SIOUG 2009:
Good Indexing : Show CBO where to go.
So how can we make this database thing work for us instead of the other way round? This presentation will generally look for the simplest, and the laziest road to to Efficient systems.
Common Joke: The Best way to fix inefficient queries is to not have them.
The next best way is to present them the most efficient path into the data, which is why I first want to cover some indexing basics and a few lesser used techniques like IOT and Clusters. The presentation involves some demos of things we already know, and possibly a few neat but simple tricks to get more out of your indexes.
Then, once we have really efficient access-paths, we must still tell the CBO workhorse where to go, but that is a different presentation.
Level: Beginner and Intermediate.
Get your stats right: Guide CBO to go where you want it.
If you still depend on the early-morning DBA to kill the inefficient queries: Welcome to the club.
We are doing it wrong, but we don't know how to do it any better, or do we? This presentation does not offer the be-all end-all to indexing, CBO and statistics, but it will try to put some hard learned guidelines together. It has been stated before: There are no silver bullets to CBO problems. But it wont hurt to look. As long as we realize that we are using "tricks", and realize our risks and limitations. We might get lucky.
How to prevent doulbe work
Subtitle : Exploring clustered- and Index-Organized tables.
A specific (business-) problem involved the prevention of double work, de-duplication.
The easiest way to prevent doubles is of course a Primary Key or an Unique Constraint. But if Performance-demands become Extreme, and Maintenance-windows disappear, the maintenance of large "to-do" and "already done" lists becomes a problem. We investigate the use of Single-Table-Hash-Clusters and Index-Organized tables to squeeze the extra little bit of capacity out of any oracle database.
Anjo Kolk, Nizozemska, Oracle ACE Director
Anjo Kolk has been working for Oracle from 1985 to 2001 in Holland, Ireland, Japan and the USA. He is recognized as the father of the Oracle Response Time Tuning methodology (YAPP) which was first documented in the YAPP white paper in 1998 and publicly used in his website oraperf.com. He has been speaking at several Oracle conferences all over the world and nowadays he specializes in troubleshooting Performance problems in large scale Oracle based systems.
Predavanja na SIOUG 2009:
7 Levels of Application Efficiency
Tuning databases are the norm even when the applications are responsible for the problems. Obvious problems are SQL statements that need to be optimized, but scalability of an application is also limited by the implementation. This presentation will show four programs that solve the same problem with a difference in efficiency (almost by a factor of 50). It will explain how to implement scalable and efficient programs.
Why the middle tier is slowing down the database?
In Multi Tier Systems performance problems are quite often traced to the database. This presentation will have a look at these problems and show that most of these problems actually originated in the Middle Tier and that some times with very simple settings one can dramatically improve the performance.
Randolph Geist, Nemčija, Oracle ACE
Randolf Geist has been working with Oracle software for 15 years now, since 2000 as freelance database consultant, focusing primarily on performance related issues, in particular helping people to understand and unleash the power of the Oracle cost based optimizer (CBO). He is writing on his blog about CBO related issues and also regularly contributing to the OTN forums. Randolf is an Oracle Certified Professional DBA (OCP DBA) for Oracle Version 8i, 9i and 10g. He is also maintaining SQLTools++, an open-source Oracle GUI for Windows (tm) which is available from Sourceforge.net and his homepage.
Predavanja na SIOUG 2009:
CBO fundamentals: Understanding the different modes of System Statistics
Understanding the different modes of System statistics aka. CPU costing and the effects of multiple blocksizes. One of the most important components of the Oracle database is still the optimizer, since everything the database does is SQL. This presentation explains what System Statistics mean to the cost based optimizer. It covers in-depth the different available System Statistics modes along with explanations and samples about the formulas and arithmetics used. Finally the effects of multiple non-standard block sizes are shown and why it is a bad idea in general to use them for "tuning" purposes.
Target audience are DBAs and developers who are looking for a deeper understanding how the cost-based optimizer works.
Frits Hoogland, Nizozemska, Oracle ACE
Frits Hoogland has working with Oracle products since 1996 (Oracle 7.0.16). and possesses strong expertise in the area's of networking, operating systems, application servers and technical security. Other specialties are consulting and helping to resolve problems and restore performance. He is a frequent speaker at Oracle and industry conferences, and writer of articles for technical magazines and whitepapers..
Frits's Expertise: Database Management & Performance. Frits's Proficiency: Linux, Scripting, and Open Source, Middleware & SOA and Security
Predavanja na SIOUG 2009:
Oracle Security Done Right
Oracle database security on the operating system level for linux and unix. Security is an important part of modern database administration, and is getting even more important with security audits because of SOX, HIPAA and/or ISO27001, among others. ost databases are installed using the oracle provided installation guide. Few people realise the purpose of that guide is to install the database software in the most simple way with most flexibility, not in a secure way. This presentation discusses this common setup, and provides a method for installing a database in a secure way. Learn about operating system and datatabase security, and securing the database on the operating system level, and getting it in line with security policies!
Automatic Storage Management
Automatic Storage Management is Oracle's way of simplifying and tuning storage. How does it work? What are the benefits of using it, and are there any drawbacks? How does it help with database consolidation? In this session, learn how to successfully deploy and use Automatic Storage Management in your environment.
