Articles tagged with: oracle magazine _ newsletter

Extract from the Oracle January 2014 Newsletter

on Monday, 03 February 2014. Posted in Blog

Extract from the Oracle January 2014 Newsletter



Here is an excerpt of the Oracle January 2014 Newsletter, different global experts share their knowledge and enthusiam on Oracle functional and technical topics and a list of new Oracle books currently available:

Tag Cloud

This post written by ACE Director Lucas Jellema explores Data Visualization with an HTML 5 Canvas based Tag Cloud powered by JSON.

Configure OHS mod_wl_ohs.conf

Oracle HTTP Server (OHS) is the Web server component for Oracle Fusion Middleware. It provides a HTTP listener for Oracle WebLogic Server and the framework for hosting static pages, dynamic pages, and applications over the Web. In his blog, Oracle ACE Osama Mustafa describes how to configure Oracle WebTier for Redirecting Purpose.

Best practices in solution architecture for Oracle EBS, OBI, Hyperion Planning

Oracle ACE Alex Antonatos shares his hands on tips for best practices when designing your Oracle financial footprint information using R12, Hyperion and OBI.

Adding Targets and Keeping it Clean

Here is a post describing ACE Director Kellyn Pot'Vin's client's environment that shows just how important it is to ensure your server environment is kept pristine.

"Which Way Do I Go?"

ACE Director Debra Lilley guest posts on the Oracle AppAdvantage Blog and talks about how people are transforming their businesses using Oracle Technology.

Twelve new DBA commands for Oracle 12c

ACE Director Julian Dontcheff share 12 new commands in Oracle 12c that will help DBA's with database administration, consolidation, security and availability features.

ACE Director Markus Eisele's latest posts from his German Heise Blog

- NetBeans and WildFly grow together
- JavaLand Highlights
- Influence Java EE 8 (Survey Part 2)

Seconds_behind_master vs. Absolute slave lag

Read this post by Oracle ACE Shlomi Noach to learn about getting the definite metrics your application can trust.

SOA Governance FAQ

What is SOA Governance? Why do I need it? What are the benefits of implementing SOA Governance and SOA the most common pitfalls? This and many other questions are answered in the SOA Governance FAQ by Oracle ACE Luis Weir.

Luis also describes the different components that build up the Oracle Foundation Pack (former AIA Foundation Pack) and also provide some useful architectural diagrams describing its key components.

Practical Example for ADF Active Data Service

ACE Director Andrejus Baranovskis describes in his post the practical approach to implement Active Data Service push update mechanism in ADF applications, leveraging Oracle DB offered notifications functionality over JDBC.

Oracle PL/SQL Code Execution from TimesTen

This post written by Oracle ACE Gennady Sigalaev describes the example of execution of Oracle PL/SQL code from TimesTen.

If you're not using Hugepages, you're doing it Wrong!

Read this brief discussion of hugepages and why they're important for Oracle database configuration provided by Oracle ACE Mark Bobak.

How to Check Broken Job for Oracle Scheduler (DBMS_SCHEDULER)?

Oracle ACE Surachart Opun blogs an example with Oracle Scheduler and how DBAs can check broken job for Oracle Job (dbms_job) at *_JOBS.BROKEN column. DBAs have changed the use from DBMS_JOB to DBMS_SCHEDULER.

Oracle 11g New Optimizer Hint: APPEND_VALUES for Improving Insert Performance

One of the most common ways to improve the performance of an INSERT operation is to use the optimizer hint called APPEND. Find out why in Oracle ACE Ami Aharonovich's latest guest post.

Look who's tweeting now - Sending OEM Notifications via Twitter

Oracle ACE Leighton Nelson shares detailed steps for sending Tweets from Oracle Enterprise Manager in his latest post.


Oracle PL/SQL Programming, 6th Edition by ACE Director Steven Feuerstein. Order a signed copy directly from Steven! It supports a good cause! (available now)

Practical Oracle Database Appliance by Oracle ACE Bobby Curtis, ACE Director Yury Velikanov, et al. (available now)

Oracle SOA Governance 11g Implementation by Oracle ACE Luis Weir and Andrew Bell. (available now)

ebook: Securing Oracle Database 12c: A Technical Primer by ACE Director Michelle Malcher,Paul Needham, Scott Rotondo, and James Spooner (available now)

Oracle Database 12c PL/SQL Programming by Oracle ACE Michael McLaughlin (available now)

JRuby Rails Web Application Development (SpringerBriefs in Computer Science) authored by Oracle ACE Deepak Vohra (available now)

Like usual share your thoughts 

Extract from the Oracle June 2013 Newsletter - Various Global Experts share their Knowledge

on Tuesday, 16 July 2013. Posted in General - Misc. Tips, Blog

Extract from the Oracle June 2013 Newsletter - Various Global Experts share their Knowledge

Here is an excerpt of the Oracle June 2013 Newsletter, different global experts share their knowledge and enthusiam on Oracle functional and technical topics:


Primary Keys Guarantee Uniqueness? Think Again!


ACE Director Arup Nanda provides a great explanation and examples of primary keys and table constraints. And, if you ever wondered about Big Data and what exactly it means, you'll want to read Arup's post "Demystifying Big Data for Oracle Professionals".


Practical Cutover Tips for Your Enterprise Project


Provided by Oracle ACE Alex Antonatos are tips and tricks on the critical last 6 weeks before going live in the areas of testing, data conversion, training and cutover validation.


Java EE 7 is Final!


Thoughtful summary of insights and pointers from ACE Director Markus Eisele regarding Java EE7. Find a list of articles from Markus about the Java EE 7 launch here.


Additional posts by Markus:


- Java SE 7 Update 25 - Release-Notes explained
- GlassFish 4 brings Java EE 7
- Interview with German iJUG e.V. (JUG Umbrella) in Java Magazine (Free subscription required to Access article)


Health Check of Oracle eBusiness Inventory by using the Inventory Analyzer


In this post written by Oracle ACE Kashif Manzoor, he covers the use of Inventory Analyzer tool to evaluate Inventory setup, patch levels, runtime tables, profiles, settings, and configurations with recommendations. This script delivered by eBusiness suite for quick health checkup of most common Inventory issues usually facing by different customers.


Capture Workload using Database Replay in 11g


Satishbabu Gunukula, Oracle ACE, talks about how to simulate actual production load for performance as well as functionality test and how to adopt changes quickly in an easy and cost effective way. Read more here.


MySQL Plugin for New Relic

The popular SaaS Monitoring product New Relic has added support for monitoring of existing data store products. ACE Director Ronald Bradford has written the open source MySQL plugin that gives developers additional insights to monitoring the entire stack.


Common Causes Resulting in ORA-01115 ErrorACE Director Syed Jaffar Hussein provides a list of common causes of an 'ORA-01115ORA-01115: IO error reading block from file (block # ).


He also shares a learning experience about how to rejoin a node to a 2 node cluster on a Windows Platform.


Deploy Agent In Enterprise Manager 12c


Enterprise Manager 12c provides very useful tools for all DBA and developers. In this post written by Oracle ACE Osama Mustafa, he explains how to deploy agent in EM 12c to monitor or host a database.


Part 3 – Getting started with Statistics for Oracle Data Science Projects


ACE Director Brendan Tierney shares part 3 on getting started with Statistics for Oracle Data Science projects which provides a summary of the other statistical functions that exist in the database.


Brendan also blogs about The DBMS_PREDICTIVE_ANALYTICS package & Predict procedure and The DBMS_PREDICTIVE_ANALYTICS package & Explain procedure


Productivity Tips for using SQL Developer Data Modeler (SDDM)Kent Graziano, ACE Director, has two recent tips on his blog for SQL Developer Data Modeler. The 1st tip is free: Oracle SQL Developer Data Modeler . And another free tip for SQL Developer Data Modeler (and a Challenge) .


WebLogic on the Virtualized Oracle Database Appliance X3-2ACE Director Simon Haslam is currently working on a proof of concept for running Fusion Middleware, along with RAC, on an ODA and is writing a series of blog posts describing his findings: #1 Planning , #2 Unboxing, with more to follow over the next month. Middleware types may also like this post, and debate, around Admin Server location.


Why is Flashback Slow?


In this paper written by Oracle ACE Chris Lawson, it explains some interesting phenomenon regarding flashback queries.




Check out the interesting observations and discussions in ACE Director Randolf Geists post about how the Oracle database treats the TIMESTAMP WITH TIMEZONE datatype when performing aggregation.


More to SQL Joins than Meets the Eye


Oracle ACE Kyle Hailey discusses in his post surprising visualizations of SQL Joins that can be more complex than you think. He also discusses a new feature in DBaaS: OEM Snap Clone.


Oracle 12c RAC On your laptop, Step by Step Guide" or "Back to School Again


To get you up to speed with Oracle RAC 12c and let you focus on the important stuff (e.g. features research), ACE Director Yury Velikanov provides detailed step by step installation instructions.


Dude, Where is my Redo?


This blog entry written by ACE Director Riyaj Shamsudeen discusses a method to identify the objects inducing higher amount of redo. Separately, he disscusses Clusterware startup details here.


Lessons from Fusion HCM Implementations


At this years OHUG conference Oracle ACE Tim Warner had the opportunity to hear from some organizations who have been through the Fusion HCM implementation process. He shares some those experiences in his latest post.


Extract from the Oracle March 2013 Newsletter - Various Global Experts share their Knowledge

on Monday, 08 April 2013. Posted in General - Misc. Tips, Blog

Extract from the Oracle March 2013 Newsletter - Various Global Experts share their Knowledge


Here is an excerpt of the Oracle March 2013 Newsletter, different global experts share their enthusiasm on Oracle functional, technical ideas and concepts:

- UKOUG Magazine Oracle Scene: Database Virtualization and Instant Cloning (p26) written by Oracle ACE Kyle Hailey

- Professional Software Development using Oracle Application Express written by Oracle ACE Rob van Wijk

- Dutch IT magazine: A seven part series on the OTN Yathra Tour 2013 and IT in India written by ACE Director Lucas Jellema (in Dutch)


MySQL Stored Routines Debugger & Debugging API: Sneak Peek II created by Oracle ACE Shlomi Noach

Blog Post: How to Implement Fusion Applications

Oracle ACE Alex Antonatos shares his knowledge on Oracle Fusion by answering questions and providing a visual diagram on the steps required to implement an instance of fusion applications.

He also provides a whiteboard animation video discussing Fusion Financial and HCM Apps benefits.

Blog Post: ADF, Oracle SQL and more posts by ACE Director Lucas Jellema

- ADF: (re-)Introducing Contextual Events in several simple steps

- Oracle SQL – Finding free adjacent seats in an airplane, using Subquery Factoring, Analytical Functions (LISTAGG and LEAD), Outer Join, PIVOT and good old INSTR

- Out of the box usage of ADF DVT Scheduling Gantt Chart to report Database Query Results using stacked bar charts per time period

- Oracle SQL – spotting combinations that occur and those that do not – demonstrating Analytical Functions, Outer Join and SubQuery Factoring

- Oracle SQL: Using subquery factoring in an INSERT statement

- How Oracle Database uses internal locks to make statement level constraint validation robust at the transaction level

Blog Post: When 'FREE' costs more in the long run: Why WebCenter often costs less then SharePoint - despite the stunning license price difference

Are you clear on the Great and the Ugly of WebCenter and SharePoint - enough to recommend one over the other for an enterprise-wide deployment? Feeling that your company has made a mistake by picking the wrong product? Or simply wondering "what if... ?" Check out this 2 page mini-whitepaper written by Oracle ACE Dmitri Khanine for some answers. It’s a quick read, that may shock and excite you.

Blog Post : Exadata Optimization Tips

Where do I start with Oracle if I want to be a DBA? written by Oracle ACE Kyle Hailey

Blog Post: Amazon EC2 - RDS quick comparison

Oracle ACE Marco Tusa provides a review of the real status about Amazon RDS in comparison with EC2.

Blog Post: Possible Data Corruption, ORA-600 on RAC Instances Shutdown

ACE Director Syed Jaffar Hussain discusses how a typical RAC instance shutdown sometimes can lead to data corruption and produces senescence of ORA-600 and what is the recommended RAC instance/database shutdown procedure to avoid the issue.

If you are planning a Database 11g upgrade with downgrade in mind, you will might find these tips provided by Syed helpful.

Blog Post: 5-Part Series on Oracle Clustering

ACE Director Brendan Tierney has published a series of 5 blog posts on how to do Clustering using the Oracle Data Miner Tool and how to do Clustering using the ODM SQL and PL/SQL functions. Part 1, 2, 3, 4, 5

Another post by Brendan will help determine whether you are a Type I or a Type II Data Scientist. Find out here.

Blog Post: Using Production Data for Testing

Daily DBA tasks, dealing with development environment and refresing using production data... is this a good idea? Production Data contains sensitive information and should not be shared with unauthorized people. Read this post, including data research on security, provided by Oracle ACE Osama Mustafa.

Blog Post: CBO 10053 Trace Files Series

A series of posts provided by ACE Director Doug Burns on what he thinks is the most important reason to use 10053 trace files.

Blog Post: Bash Script to Upload RMAN Backups via FTP

Oracle ACE Gokhan Atil shares a small bash script which calls an SQL script to queries RMAN backups and demonstrates some interesting methods such as handling arrays returned from SQLPLus.

Blog Post: Convert JSON to XML/SOAP (in Spanish)

A common occurance these days, Oracle ACE Rolando Carrasco provides a guide to converting JSON to XML/SOAP using Oracle Service Bus.

In a different post, he shares an introduction to Oracle ADF Mobile.

Blog Post: Debugging Data Pump session

While importing a dump file, it can sometimes be a long process. ACE Director, Kamran Agayev, shares his command solution he runs to import the dump file into the new database.

Blog Post: What is the Oracle Cloud Really?

If you ever wondered what is the big deal around Oracle Cloud Service, you'll want to read this post written by ACE Director Markus Eisele. He explains it well and also provides an example on how to use JAX-RS with Jersey on the Oracle Cloud Service

Another interesting post Markus shares is about Test driving Java API for Processing JSON with GlassFish 4.0.

Blog Post: Installing Oracle Business Transaction Monitoring

Oracle ACE Rob Zoeteweij created virtual Servers and describes the installation process of BTS in his latest post.

Rob continues to share his knowledge on EM 12c, this post describes how to setup Database as a Service using EM12c DB Plugin

Blog Post: Pseudo Cursors and Invisible SQL

Do you ever wonder why Oracle Enterprise Manager and AWR reports show the SQL text for some SQL IDs as not available? ACE Director Julian Dontcheff provides an explanation in his latest post.

Here's another good read by Julian on the definition of "The Oracle Platform Administrator".

Blog Post: Cost Free Joins

In this two-part post, ACE Director Randolf Geist first demonstrates an unexpected Nested Loop Join caused by an extreme data distribution. In the latter, he presents another case of an unexpected execution plan, this time about Merge Joins.

Blog Post: Oracle Background Process Killed

Oracle ACE Asif Momen demonstrates how to connect to the Oracle Database even if background processes are k.illed

Blog Post: Adding HINTS in ODI

Read this post written by Gurcan Orhan as he explains how to implement adding Oracle HINTS and Variable HINTS into ODI (static and dynamic).



Copyright 2015 All rights reserved.