Tuesday, September 28, 2010

Oracle Open World 2010: Day 5

Started day 5 with some quality time in Oracle Certification lounge...Took couple of kaplan self tests.

Two interesting sessions of today are :

Session 1:  XML DB Case study
Speakers: Mihaela Lupu, Waters Corporation and Geetha Arora, Oracle

Mihaela started the presentation with a high-level overview about the Waters Corporation.  Its a global leader in providing complimentary analytical technologies based on Milford,MA

Challenge:

getting a generic catalog db for the different structures, different architectures and different user interface of their products

large structures over 10 million rows.

larger than 100mb in size

unstructured data about 40gb in size

25mb/sec to 100mb/sec ...storage data rate

real time support for read and write at the same time.

content management system ..central repository

save, load, delete and search operations using api

storage -- unified format..common info, xml data and binary data

created relation tables (catalog info) with xpath and xnamespaces info as columns as a  solution to search related issues.  An Engine automatically generates this catalog (relational table) by reading the xml data.

Application retrieves the xpath and namespace info from this catalog table before reading the actual xml data.

created  views as a solution to ... build sql statement generically, join data from xml and relational tables, clean and better performance..

xml index creation for most searchable xml data.

XML use cases...


structured ... data centric
unstructured... doc centric

doc centric:

unstructured:  binary xml + unstructured xml index
structured: hybrid storage /obj relational + clob

data centric:

unstructured: binary xml + structured xml index
structured: structured storage + btree index

why index xml?

improves xpath based fragment extraction
good for path and value based predicates
good dml performance
datatype aware

unstructured xml index:

doc is unstructured
xpaths not known in advance
allows async maintenance
peicewise index updates possible

structure..
rid | path | order key | locator | value

path subsetting.. nodes that will be used in common queries, better ddl and dml performance

hybrid index possible for 1 column

structured index:

provides  relational view over xml data
index size is small and light weight
xpaths known in advance

xml with structured component

structure...
rowid | col1 | col2

2nd index on structured xml index can be manually created.. It can also be a text index, btree or bitmap
for unstructured xml index, oracle automatically creates the 2nd index (btree )
choice of index determined by query paradigm.. xpath known or unknown



Session 2:  Reduce problem resolution time with Oracle  database 11g diagnostic framework
Speakers: Marcus Fallen, Principal member of technical staff, Oracle

Impacts of poor diagnostics:

loss of availability
loss of productivity

solution offered by 11g diag framework:

organized
catalogued
first failure capture
managed
constrained

current product coverage:

databases...
rdbms server
oci
net
asm

fusion middleware 11g....
soa
web server
weblogic server

exadata...
storage cells

fusion apps

concepts .. incident and problem

components... adr (automatic diagnostic repository) and IPS (incident packaging service)

solutions... health monitor, repair advisors, sql test case builder

interfaces... enterprise manager support work bench, adrci (adr command line utility) and v$diag_info, v$diag_%, v$hm_%

Configuration and enabling of OCM required for auto push

metalink note 411.1 talks about packaging in detail


OOW  2010 conference  is over.. but a lot of things to catch up. Next year's conference will be in October.





Oracle Open World 2010: Day 4

Pick of the session for day 4 was Larry's keynote..Although it appeared as an action replay of Sunday's keynote.

This keynote was started with an intro for Kris Gopalakrishnan (CEO,Infosys) by Mark Hurd. There were series of speakers from Infosys.. Highlight being Ming's presentation. His presentation started with a series of absorbing photographs and a video to cover their "3 screen convergence". The other products of Infosys that were described were ... iEngage (Chandrasekhar), shopping trip 360  (Jackie, Infosys Australia), iSmart power strip (Prasad)


Important annnouncement that was made was the opening of new infosys/Oracle innovation center.

Larry's speech.. almost an action replay to his sunday's speech.

Innovation: More technology than ever before

Exalogic elastic cloud ... cloud in a box
Exadata x2-8
Fusion App
Oracle Linux unbreakable enterprise  kernel
Solaris 11 next generation world's number 1 unix
Sparc next generation of high performance chip
java roadmap .. vector graphics 2d/3d
mysql 5.5
4 billion dollars per annum for R &D

Management: More experience than ever before:

Mark Hurd.. President
Joannne Olsen ..Cloud
Chuck Rozwat -- Support





The other noteworthy session to be mentioned here  is ...

Session: Maximizing database performance using DB Time
Speakers: Kurt,Oracle Product Manager and other two

DB Time is the fundamental measure of oracle performance
AWR, ASH,ADDM and EM Performance pages are all about db time.

Why DB Time tuning ?
Helps tune exactly what affects users.

DB Time tuning method...

Identify performance issue
scope the issue
set goals
data capture ( automatic using the awr reports)
investigate db time distribution/identify largest potential improvement
modify system/database for largest gain
evaluate against goals.

The appreciation event at the treasure island was awesome..Black Eyed Peas and Steve Miller rocked the stage! Here are some mobile pictures...





Monday, September 27, 2010

Oracle Open World 2010: Day 3

Unlike day 1 and day 2, I am not going to write about all my sessions. Here is my pick of today's session...

Session: using oracle database resource manager for database consolidation
Speaker: Sue Lee , oracle senior development manager

Themes of this session: Why consolidate?, Server consolidation and Database consolidation

Server consolidation: ( consolidating multiple databases on a server)

Instance caging... This oracle feature limits the number of oracle processes running at any moment in time.

There are two approaches in this approach..
Over provisioning approach.. CPU_count is greater than the sum of CPUs
Partitioning approach.. CPU_count is equal or less than the sum of CPUs

How to set instance caging..
Set CPU_count and set res manager plan

CPU restricted using instance caging is not applicable for licensing counts.

Metalink note 1208064.1 talks about best practices for instance caging and it's known issues.

How to monitor instance caging characteristics.. Using awr reports.. Look for resmgr: CPU quantum wait event

This instance caging is dynamic and no outages required.

Overhead.. To reduce the overhead limit the instance caging config changes to one per hour

IO consolidation.. Using exadata io resource manager ..controls the order of IOs issued

In 11202, res mgr can specify hard limit

Dfns clone db... 11202 new feature, using ifs storage, instantaneously replicate prod db for test and dev. Metalink note: 1210656.1

If an os tool available for server consolidation, prefer that to instance caging


Database consolidation: ( consolidating multiple databases into one database)

CPU resource manager:
Consumer group definition
Create Resource plan for consumer group
Set res mgr plan for consumer group

Different types of plans are.. Ratio plan, priority plan and hybrid plan

Using jobs, day time plan and off-hours plan can be automatically configured

Oracle enterprise manager has a user friendly interface for this

Parallel execution of queries

Use parallel_degree_policy ... In 11.2.0.2 , separate queue per consumer group is possible... Res plan specifies which queues are issued next!

Interesting pictures from Moscone North...











- Posted using BlogPress from my iPad

Oracle Open World 2010: Day 2

Day 2 started with a visit to OTN lounge. New place this year moscone west versus mason street tent.

Thanks to Justin's blog http://blogs.oracle.com/otn/2010/09/you_want_flair.html

I collected couple of cool flairs.

Video shoot for OTN live streaming was going on and Justin was facing the camera










Session 1: Database General Session
Speaker: Andy Mendolson
Moscone north Hall D
11am - 12pm

Andy started his speech by listing the new stuff since last open world:

Sep 2009: secure backup version 10.3

Oct 2009: golden gate + active data guard bundle ( interesting to note is golden gate will get tightly integrated with oracle streams in the future release)

Nov 2009 Audit vault 10.2.3.3

Dec 2009 SQL developer 2.1

March 2010 Berkeley db 11g R2

Jun 2010 apex 4.0

Aug 2010 development tools for visual studio 11.2.0.1.2

He continued the speech in building on the following questions..

Where are we today ?

New quarterly PSU patch

11.2.0.2.0 patch set

X2-2 oracle

All oracle applications certified for 11g r2

What are the upgrade paths?

SQL plan management .. To maintain the performance

Real application testing.. To reduce time and risk of change. Perfect for testing db/os upgrades, migrations, db config changes and server and storage changes

Why customers are upgrading to 11g r2?

Improve performance
Consolidate
Optimize
Complete
Reduce mgmt overhead


Customer examples were shown using video ...Turkcell and softbank

Turkcell reduced their data volume from 250TB to 27 TB using oracle compression

Softbank reduced their 36 racks to just 3 racks by switching from terra data to oracle exadata


Bioware's star wars the old replublic was the other interesting video that was shown.

Exadata and exalogic can serve as the best platform for doing database as a service models in private cloud. Commonwealth bank of Australia was quoted as an example

Family of exadata machines..

X2-2 ... Quarter, half, full and multiple-racks
X2-8.... Full and multiple-racks only...

Worried about security?

Config management
Audit vault
Total recall
Db vault
Label security
Advanced security
Oracle db firewall

Worried about management?

Provisioning software to private cloud
Standard reference config
Rapid db configuration
Downloadable spreadsheet provisioning profile template
(Interesting demo on 8 node rac configuration)
Automatic patching.. Fully integrated with myoraclesupport
Automatic service requests creation for exadata issues
Automatic pro-active alerting from oracle support for known issues

Session 2: upgrade RAC to 11gr2 keeping it simple
Speaker: Jeff Brannan, TDS

Speaker started the session with the history of RAC at TDS:

1 production rac cluster - 5 nodes
1 dev rac cluster - 5 nodes
2 standalone nonrac servers

RAC configuration helped them consolidate their servers from 57 servers to just 12 servers

Since 2006...
80% increase in production databases
180% increase in non prod databases
No dba staff increase

Issues with 10gr2 rac:

Switch port config change. ... Human error
San disk failure ... Storage frame emc firmware bug
Storage monopolized by single db causing performance issues

Upgrade path..

Create new db as 11g rac
Move data
Leave 10g db untouched

Why move versus upgrade?

5 reasons as per the speaker..

Lower risk.. Rollback simple

Testing requirements.. He failure, db management, management tools, adding and removing as per capacity needs

Documentation requirements

Hardware support ..hw support date aligned with oracle support date

Db size.. Only 2 databases above 150gb and all others are less than 500gb in size


Current configuration...

Hp dl 380 / 2 quad core CPU / 36gb ram
Distance between two clusters in their extended rac configuration... 100 ft

Making scan work in 11g was an issue

102030 can't be started in 11g ( bug 8833280)
Metalink note 948456.1 for full details

Modes used for data transfer..

Exp/imp
Datapump
Datagaurd


Session 3: cut your costs, not your potential (Cap Gemini)

I got lost in tracking novellus theatre and was 10 minutes late to this session.

This was a very short session and the speaker ended the session with the following question!

What is the role of technology within the enterprise and not what is the role of IT.

Session 4: RAC best practices at AT&T

Session started with their architecture highlights.
They improved purchase power by combining accounts with it's vendor and saved 500 million dollars!

DB cluster - 416 CPU cores and 1.7 tb memory
Database size- txn db 14 tb and archive db 3 tb in size
Clusterware - verities cluster ware + oracle cluster ware
4 nodes sun e25k domain 104 CPU cores each and 416 gb memory each
Storage : HDS 9990v
Use hitachi shadow image to create clone db in approximately 2 hrs every week
Generates stats on clone db and gets it imported to the production db
Use of net app deduplication tools for creating dev db copies
6 data centers overall to support bcp
Use of tiered storage

Obtained the services of oracle solution services/ advanced customer services..for the following..
Quarterly doc for AT&T environments with latest recommendations on patches
Participation on AT&T it meetings to clarify recommendations
Detailed patch analysis on adhoc basis
Performance improvement
Rac CRS config
Db upgrade
As per the speaker, they are estimating 2-3 years of work to perform enterprise business suite reel 12i upgrade 11g database upgrade. The way they explained the upgrade process it appeared very discouraging

Team size ... About 25 DBA and 6-7 dedicated OSS staff


Session 5: oracle db 11g internals : five key high availability innovations
Speaker: Wei Hu, Sr. director of development, high availability technologies

This session was short and sweet with lot of good information .. The 5 features covered were:

Active data guard - DR site can now be actively used for reading, configuration of unto 30 standby databases, automatic block repair, synchronization of in-memory structures with on-disk changes resulting in unique combination of real time data, consistency and performance

Optimized data protection ( oracle is the only database that protects from all the five types of corruptions.. Latent sector error, corruption, lost write, torn write and misdirected write)

Flashback db ( continuous data protect , fast point in time recovery strategy, easy single command restore, engineered for low overhead)

Data recovery advisor ( built as specialized rules engine, automates db failure investigation and repair planning)

Powerful availability through integration ( maximum availability architecture .. RAC for server ha, flashback for human error correction, edition based redefinition, data guard for minimum downtime upgrades, rman/FRA for backup to disk, asm for volume management, oracle secure backup for backup to cloud and tape and active datagaurd for dr, data protection and queries)

Quote of the day: hardware improves, software improves and humans? ( Wei Hu)




- Posted using BlogPress from my iPad


Location:San Francisco, CA

Monday, September 20, 2010

Oracle Open World 2010: Day 1

Registration was simple but due to long lines it took about 30 minutes. 20 minutes to get the badge in the level 1 Moscone west and 10 minutes in the level 3 for the bag and alumni jacket.

The first session was scheduled for 12:30pm ..we had a good 2 hours..utilized it to the fullest extent by roaming around the market street and taking an early lunch in a Mexican restaurant.

I managed to attend several sessions today.. Here is the snapshots of the sessions that I attended today...

Session 1: Field report: Extended distance RAC 11g on sparc technology
12:30p to 1pm

Speakers: Andreas Ellerhoff, Deutche Messe and Mike Dietrich, Oracle Corp

Interestingly the first session that I attended was in room 2010! Agenda sounded great but the session ended up a little disappointment as the session and slides contained only the technical specifications and not more details.

Extended distance RAC, the speaker explained was of three data centers each 0.7 miles apart with 2 nodes (node 1 and 3) in the data center 1 , 1 node (node 2) in the data center 2 and the centric storage backup server in the data center 3.

The 8 reasons as per the speaker that triggered 11g upgrade are:
~ Harmonization
~ Security
~ Reorg (reduced the emc disk storage by half)
~ technological improvements
~ grid control for easy monitoring
~ significant performance improvements
~ use of further new feature
~ low cost for the upgrade (?!?)

No time was given for Q & A as the session was allotted only 30 minutes. Kudos to the speaker for accepting to do this session in 30 minutes!


Session 2: Centralized HA database on 8 node RAC cluster using 11gr2
1pm to 1:30pm
Speaker: Christian Trieb, Paragon data systems

The speaker laid out high availability, good performance and short time frame for migration as goals for their upgrade.

Their migration plan sounded very simple based on the high level steps that speaker shared in the session...
~ export .. 2 hrs
~ import ...with parallel 32, data plus index and no stats
~ gather stats .. 3 hours

Speaker was honest in saying that they were able to perform migration only on their 5th attempt.. 1st and 2nd attempt got cancelled due to lack of time for app testing, 3rd attempt was cancelled due to delay in getting bug fix for an oracle internal error (kjmsendscq:timeout) and 4th attempt was cancelled due to problems with backup.

Btw three bugs were referenced for their ORA-00600 internal errors. I jotted down the bug numbers but not sure whether I got it right or not giving it here any way.. 9831998, 9696187 and 987053

Here is the comparison of their pre-mig and post migration configuration..

6 nodes rac+dg versus 8 nodes rac+dg
10203 versus 112010 plus 9778840 patch for grid infra home
32 gb ram versus 96 gb ram
12g sga versus 20g sga
Linux 2.6.9(4 nodes) and 2.6.18(2 nodes) versus 2.6.18(8 nodes)

Issue with netapp backup snap mgr post migration.. As they are seeing performance issue if integrated with rman. With rman they are getting done in 40 minutes and without rman integration they are getting done in 10 minutes.

Similar to session1, no time was there for Q & A as the session was scheduled only for 30 minutes


Session 3: IOUG: DBA Fusion --- an introduction to oracle enterprise manager 11g
1:30p to 2:30p

Speaker: Ray Smith, Portland General Electric

At the start of the session itself the speaker set the expectation that this session is about oracle management server installation and configuration and not about the OEM console or database.

It was interesting to know from the speaker that there are about 60 sessions pertaining to OEM in this year's open world.

The high level steps for the install were explained as listed below:

Step 1: gather documentation ...( he also recommended oracle-wiki.net for a step by step documentation on install) middleware home, inventory home and grid infrastructure directly under oracle base folder.
OMS home, agent home and config file under middleware home.

Step 2: Install and patch fusion middleware (tip suggested was to use the jdk that get shipped from the product instead of the existing jdk.

Step 3: create repository db (compatibility as per note 412431.1)

Step 4: install oms

Other interesting info from the speaker to share are.. Setup communication between your oms server with oracle support and put oms and repository db on separate servers due to excessive java memory usage by middleware home

Unlike the session 1 and 2 above, time was given for Q & A.


Session 4: Resolving free buffer waits event
3p-4p
Speaker: Craig A Shallahamer, orapub

Craig is doing 4 sessions this year, two of them regular sessions and two of them unconference sessions.

He also utilized this session for a little marketing of his books .. 1: oracle performance firefighting and 2: forecasting oracle performance.
There was a raffle for two books in this session.

Craig's explanation of the buffer cache, buffer cache header, cache buffer chains, lru, lru-write was excellent. His style of lecture was impressive. The sad part was this session was forced to stop 5 minutes before the schedule to allow the next session to start on time and was warned 12 minutes before the end of the session. There was no time reserved for Q & A but during the lecture itself, Craig encouraged questions from the audience.

After explaining the reasons for free buffer wait with great detail and animation, He summed up the solution as follows:
Increase buffer cache
Tune SQL to reduce physical I/0
Review application design/logic to find the DML to check it's work load balancing issue
Analyze SQL statements with hi consistent reads
Decrease _db_large_dirty_queue
Increase _db_writer_max_time ( not sure I got this right or not!)


Session 5: Oracle RAC expert panel
4p-5p
Panel: serge del rio (moderator), Markus (Product mgr), Sri Subramaniam, Nitin vengulekar (Product strategy), Phil Newman and Krishnadev Telikicherla

This is a great session as it was purely based on questions and answers format. The scheduler builder had this session as customer panel instead of experts panel. At the start a request was made to keep the questions unrelated to any SRs opened and/or bug specific.

Oracle RAC SIG election results were announced prior to the session. Alex gorbachev is the new president of the RAC SIG.

Questions started very dry and picked up momentum in the middle.

Application readiness document/guidelines to identify how application will perform in rac or nonrac... Panel's answer was.. if it scales well as single instance, it will scale well as rac. The main concern mentioned was regarding the sequences and the index on sequence.

Regarding my question of rac-aware connectivity details for jdbc thin drivers, the behavior is same in 11.2 as 10.2 and a white paper on universal connection pooling was suggested for reading.

Regarding the question on parallel queries within the instance and across the instances... The answer given was it depends and test it before you use it!

Recommendations given for the number of nodes in a rac environment.. Minimum is more than 2 (i.e three nodes) and max is 100 nodes. But 100 nodes in reality is a complex thing if your app is scaling upto 100 nodes, chances are it may need more and you can. Not go beyond 100 nodes.
Panel suggested 36 nodes as a realistic upper limit?

Here is the most interesting information that was told by the panel...

11.2.0.2 changes:

Lot of Bug fixes
Quality of service management new feature to be announced in this open world.
ASM enhancements.. Power limit upper limit increase from 11 to 64, Asynchronous rebalance and Enhanced cp command.
Here is my favorite... Clusertware will not reboot the node for interconnect issues or any other os issues, instead it will only stop the clusterware stack.

This is based on customer demand as several customers have requested availability for non cluster resources running on the same node.

Side bar: we were in the same shoes, we had app servers running on local zones and global zone dedicated for oracle rac.. But rac reboots caused outages to our app servers running on the same hardware in the local zones. We migrated the app servers to a different hardware and removed all the local zones from the rac nodes leaving just the global zone for cluster ware and it's resources.

Key note session:

Speakers: HP ( Ann Livermore and Dave Donatelli) and Larry Ellison

Hp's agenda was focused on datacenter solutions for today and tomorrow: App modernization and converged infrastructure.

Other facts that was interesting to note : this year's open world is the biggest in history in terms of attendance .... 41 thousand attendees.













Larry started his speech by defining the cloud computing by differentiating the amazon ec2 and salesforce.com saas.

Major announcement that he made was the availability of exalogic elastic cloud ...cloud in a box.

Quote of the day: spend less if you want better performance.

Exalogic machine is 4 times lower cost compared to ibm's powerful power 795. The price quoted in the slide.. $107500 for exalogic machine and 4440000 for power 795
Exalogic machine key features summary..

Fastest java performance
Elastic capacity on demand
Fault tolerant
Scalable
Secure
Easily Maintained.. One patch / one file for all software components in the machine
No single point of failure.. Redundancy all layers
Standard configuration of all customers..helps oracle deliver and test better..discover the issues faster and fix bugs
Internet application - 1 million http requests per second
Messaging application - 1.8 million Messages per second
30 computing servers
360 cores
2.8 tb dram
460 gb solid state disk
1.2 microseconds latency
4 tb read cache
Clustered for ha
40gb infiniband, Eliminate buffer copies, use large pkt size
Transaction affinity to db node
New tagline .. Hardware and software engineered to work together


The second announcement made was the announcement of oracle unbreakable enterprise kernel ... Much faster than red hat, gets community and oracle enhancements much faster. Oracle remains committed to red had compatibility

The availability of the new exadata top of the line oltp database machine will be announced later this week.

The final portion of larry's keynote was the preview of fusion app 5 year development and a demo by Steve Miranda.









- Posted using BlogPress from my iPad



Location:San francisco, CA

Friday, September 17, 2010

Oracle Open World 2010: Here I come!

Fourth time in the last five years! Excited about the same. Work kept me busy until last hour and was not able to plan or prep ahead. From now on to Thursday night the focus will be on OOW 2010. This time added fun as no red eye flights! In addition to that a half dozen people from our company will be attending with me this year!


I just downloaded the OOW 2010 app and it's a great aid for last minute prep. Looks great and user friendly! Here is a sneak peek..










I missed out blogging last year.. Similar to 2006 and 2007, I am planning to blog my OOW experiences this year.. Check this space for the next 1 week..




- Posted using BlogPress from my iPad


Location:Hartford, CT

Friday, November 16, 2007

Oracle Open World 2007 - Day5

Compared to the last four days, todays attendance was relatively smaller in number. First time for this week, un-occupied bean bags were visible!



However, the sessions appeared to be full house though. I was able to attend four sessions today and I also spent some time at the demo grounds this morning.

'RAC (High availability grid) management made easy with Oracle Enterprise Manager' : Jegan and Venkat of Oracle and Julian Dontcheff of Nokia were the presenters. Overall presentation was good due to the demonstrations. Manage as one, Diagnose as many was the theme for the demo. The customer example (Nokia) was not effective just the known stuff key stuffs like their challenges, etc were skipped.


'Oracle database integration with Active Directory and Windows security': Santanu Datta and two others were the presenters. I expected a lot from this session as we are about to start the process of implementing OID here at our organization. Unfortunately I did not get too much from this session. Either I am dull or the speakers were way too fast.

'11g - The perfection of a master piece': Christo Kutrovsky was the presenter. This session is my pick of the day. The presenter really knew what he was presenting and we were able to see his passion for 11g the way he presented the stuff. His presentation material was also unique as instead of covering the well known new features, he presented the small and invisible new features mining from the syntaxes. Very useful presentation.


'RDBMS industry and technology trends' : Guy Harrison of Quest software was the presenter. He provided some interesting facts regarding rdbms marketshare, marketshare by Operating system sourcing Gartner's reports. Presentation did not carry any surprise information. However, the presentation contents were neatly paced and nicely presented.


It's a wrap party started around 5pm at the Howard street tent. It was full of music, dancing, food and drinks! It was a miniature form of yesterday's party. In the middle of the party the sweepstakes winners for Hitachi 50 inch plasma TV and subaru impreza car were announced !






Thursday, November 15, 2007

Oracle Open World 2007 - Day4

Without any doubts, Appreciation event (held at Cow Palace) stands tall as the highlight of the day4. It was a massive and well organized event featuring big names like Billy Joel, Lenny Kravitz, Smithereens and Stevie Nikcs. I believe there was more crowd for the Billy's stage compared to the other two stages (Stevie and Lenny).



Earlier in the day, the Keynotes of Michael Dell and Larry Ellison were of much of interests. Especially Dell's keynote was great with awesome demonstrations. He focused mainly on Dell's IT simplification glories. Mark Sunday (CIO of Oracle) show cased his Austin Data Center in the middle of Dell's keynote. Larry in his CEO keynote mainly focused on Oracle VM and Fusion applications. Very short time was dedicated to the Q&A session. The question regarding Oracle's next acquisition brought in a big humor.



In terms of technical sessions, my pick of the day was Oracle Enterprise Manager Deployment and Best Practices for Oracle IT (by Campbell Webb, VP Oracle Development IT). Fifty percent of this presentation was real demo comprising some really impressive custom dashboards and reports. The post session Q and A with the presenter (Campbell Webb) and Preeti Somal (VP, Oracle Applications and Systems Management) was also very interesting and useful.



The quote of the day came during the Lunch Time. When asked for the availability of vegetarian lunch, we got an instant reply as below...

"The only vegetarian lunch available is over there but it has meat in it"





Tuesday, November 13, 2007

Oracle Open World 2007 - Day3

Tom Kyte's session (The top 11 new features of 11g) was the pick of my sessions for the day3. It was short and sweet. Tom's new features' list included the following --

1. Encrypted Tablespace, 2. Cache More (Client side caching, server results cache, Pl/SQL function results cache), 3. standby database enhancements, 4. Real Application Testing/Database Replay, 5. Secure and smaller dump files ( datapump compression, encryption, dumpfile reuse and partition options), 6. virtual columns, 7. partitioning enhancements ( composite partitioning, virtual column partitioning and interval partitioning, 8. pivot table, 9. flashback data archive (Total Data recall), 10. Finer grain dependency tracking and 11. OLTP table compression.



'Oracle RAC Special Interests Group Expert Panel ' was also of good interest. Rich Niemiec was the moderator for this session and the panel experts included Nitin Vengurlekar (Oracle Server technologies), Barb Lundhild (Oracle Product Manager RAC), Philip Newlan, Roland Knapp and Saar Moaz. Answers for some of the questions did not appear as a real expert answer. However, overall it was an useful and interesting session.



In an another session, Llorence (Gas Natual) categorically stated running Oracle clusterware on top of a third party clusterware as a bad practise. This session was titled "using oracle clusterware to create a highly available consolidation platform". Markus Michalewicz (product manager, oracle clusterware) was the presenter for the most of the session and the customer example (Gas Natural) was narrated by Llorence.



I also managed to squeeze in for Ed Abbo's Oracle Applications keynote. More than the keynote the slides displayed prior to the keynote address (during the waiting time) was more interesting! The following question was put up in the slide with a requests for response from the audience... How could Oracle make more complete meeting your needs? The responses included few legitimate answers like keeping the licensing metric simple and also many funny answers like comfy shoes, more bean bags, etc.


Oracle Open World 2007 - Day2

Very long day ... but no complaints as I managed to win the Oracle Jeopardy at the OTN Night. Nintendo Wii was the prize I won for that! 11g new features, 10g DBA, 10g AS and SQL were the categories I was quizzed on.






Apart from the Oracle-Jeopardy, the other two things which I really enjoyed was Tom Kyte's Q and A in the OTN lounge and Andy Mendelsohn's keynote (Innovate faster with Oracle Database 11g). Mark Townsend's case studies and demonstrations made this keynote very interesting. The keynote also included the live interviews of five customers. It was good to see Arup again today as he was the fifth customer (startwood hotels) interviewed by Andy.





My pick for today's best session is "Implementing Oracle Maximum Availability Architecture at AllState Insurance, Using Oracle 10g RAC, ASM, Data Guard and Grid Control" by Michael Hughes. This session was very detail oriented explaining the various available options with its merits and demerits. For the second spot, I would vote "Oracle 11g: Next-Generation High availability" by Juan Loiza.


I also spent a good 90 minutes in the exhibition hall. Was not lucky enough with the wheel of fortune...It was amazing to note that few booths had car ( lexus!) as raffle prices! Not sure who that lucky winner will be.