All entries for Thursday 16 November 2006

November 16, 2006

UKOUG 2006 Day 2–3

There are several benefits to attend a conference: communicate with experts and peers,gain useful knowledge and spare time to reflection.

I should use grid control

I have a misconception that grid control is only applied to Oracle instances within a RAC. This is totally wrong. Oracle people boast that a grid control can monitor and manage several hundreds of irrelevant databases.

Data guard can do major rolling upgrade

I know data guard can support minor upgrade. I asked an expert from Oracle and apparently you can now do rolling upgrade from 10gR1 to 10gR2,or even from 10g to 11g. The minimum version is 10.1.0.3 to 11g.

Practical database monitoring

This presentation is the best one so far. The presenter gave a clear explanation about a real-life performance tuning. He even invited audience do a test to verify their understanding.

What knowledge you expect from a developer

I attended one session “Oracle Optimization and Troubleshooting for developers”. The presenter talked about some oracle technologies such as SQL Trace, wait events. I felt the content might too deep for a developer, (might OK for PL/SQL developers, not for Java or C++).
One of the big selling point of Java, EJB, Hibernate, etc, is about database independent. Will developers is willing to invest time to lean deeper about a specific database?
I then ask myself what a good developer should know about Oracle:
  • Knowing creating index and avoid Full Table Scan
  • Knowledge about lock table or rows
  • can do explain plan use Toad or SQL developer.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXII