All entries for Thursday 16 November 2006
November 16, 2006
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 developerI 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.