The today’s first session was a round table session with Andrew Bullock, Director of Application and systems management at Oracle. The main result of this session was that the main people using Enterprise Manager Cloud Control 12c were DBA and not so much system or Weblogic Administrators.
It's the final day of Tech13, less sessions but still good topics. Mainly about the Oracle's optimizer: looking at the execution plans and a debate about hinting SQL statements. I will focus on the hint topic in this blog.
UKOUG conference day 2 opened up with Tom Kyte talking about 5 PL/SQL things you probably didn’t know. It did have 12c in the title but I think 4 out of the 5 were pre 12C. Implicit conversions are EVIL is my main take-away and he made me aware of the power of the PL/SQL warning framework to highlight any implicit conversions and other no-nos. Another important warning was when you code a WHEN OTHERS statement but do not follow it with a RAISE statement. Overall, an interesting discussion which I enjoyed despite only having ever written about 200 lines of code in my whole life.
During this last day I also decided to follow Middleware stream.
I have continued to learn about future Oracle product strategies. In the web tier layer, they will continue to support I planet web server but without adding new added value features inside. They insisted in the fact that OHS (Oracle HTTP Server) is still, and will be the preferred Oracle product as a web server.
When the Smart Flash Cache was introduced in Exadata, it was caching reads only. So there were only read “optimization” statistics like cell flash cache read hits and physical read requests/bytes optimized in V$SESSTAT and V$SYSSTAT (the former accounted for the read IO requests that got its data from the flash cache and the latter ones accounted the disk IOs avoided both thanks to the flash cache and storage indexes). So if you wanted to measure the benefit of flash cache only, you’d have to use the cell flash cache read hits metric.
A week back I have faced an error related to datapump export and would like to present my findings here. When I executed datapump export (expdp) job on a 10.2.0.4 database, it got failed with below error message ORA-31626: job does not exist ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYS ORA-06512: at “SYS.DBMS_SYS_ERROR”, line […]
The development of the cloud has changed the way IT managers handle corporate infrastructures. The integration of scaling storage and remote access features have made it easier for organizations to save on operational expenses by providing increased flexible memory requirements that are not possible with legacy equipment. As more enterprises shift away from on-premises storage, the growth of traditional methods is fading, reported InfoWorld.