Martin Jensen
Martin Jensen is a senior database consultant in the Danish Tech Consulting group, and has been with Oracle since 1998. From 1981 to 1995 he was head of the Oracle porting team at Dansk Data Elektronics porting all Oracle versions between version 3.0.12 and 8.1.7.4. Martin have participated in many larger projects covering database design and architecture, performance and archiving, and is now concentrating on ILM, table partitioning techniques and performance. During his career Martin has instructed numerous courses and seminars, and for the last four years Martin has been a regular speaker at UK/OUG on various topics round FGA and table partitioning. He is also a member of the Oak Table Network.
|
Oracle University is proud to present:
Advanced Partitioning with Martin Jensen
20 November in Ballerup, Denmark
At first sight table-partitioning seems very simple, but when an actual table needs to be partitioned, a number of alternative strategies may be used, with different consequences on performance, availability, backup and restore. This seminar will discuss and show some of the more difficult aspects of partitioning - hard to locate in the manuals. We will show you how to change existing database tables to be partitioned, how read-consistency works together with exchange-partition, various special cases from new partition possibilities in 11g, block-compression, and how Materialized views may benefit from partitioning.
The seminar will also discuss how ILM (Information Life-cycle Management) may help to implement a cost-effective archival strategy, and include some known availability issues.
Seminar Topics:
- Partitioning external table using limited disk-space
- How current select-statements are affected when the datastructures being accessed is being exchanged
- Interesting special cases covering some of the new partitioning possibilities in 11g partitioning-option
- How Materialized Views may benefit from partitioning using PCT (Partition Change Tracking)
- How choosing older partitions may be subject to block-compression and save space and increase performance
- How an archiving strategy could be implemented using ILM (Information Lifecycle Management)
| Date & Time: |
Price: |
Location: |
Enroll: |
20 November, 2009
09:00AM - 16:00PM |
DKK 5625 |
Ballerup, Denmark |
Click here |
For more information on this seminar, click here.
Book now, as space is limited!
Oracle University Team
 |