- Business Opportunities with Oracle In-Database Analytics
- How do you manage data growth in your Oracle Environment?
- April Edition - Oracle Database Insider Newsletter
- Now Headlining in Vegas - COLLABORATE 14!
- Oracle NoSQL Database 3.0 Announced - Extends Security, Usability, and Performance.
- How to migrate from Microft SQL Server to an Oracle Database 12c centralized environment with ODP.NET
- Need best practices for deploying JD Edwards EnterpriseOne on Oracle Database Appliance?
- Oracle's Real-World Performance Tour - now comes to you!
- Tom Kyte writes about Oracle Database 12c Multitenant Option in Oracle Magazine
- Oracle and .NET session at San Francisco .NET Developer Meeting March 12
Wednesday Mar 13, 2013
Tuesday Feb 19, 2013
By Markus Weber on Feb 19, 2013
MetLife, a leading global provider of insurance, annuities and employee benefits, has been an Oracle customer and user for many years, and uses Oracle technology for many of its mission-critical applications. On top of the Oracle Database, they deployed business applications from Oracle such as PeopleSoft, Enterprise Performance Management solutions, and OBIEE.
For failover scenarios, MetLife deployed Oracle Data Guard a while back, and soon realized that with new capabilities introduced with Oracle Active Data Guard, internal global reporting functionality can easily be improved by generating reports from the open, and otherwise idle, standby database.
To increase internal resource utilization even more, MetLife made the decision to use Oracle Advanced Compression, that reduced disk space considerably for archiving requirements and production systems alike. In production environments, the savings were even multiplied as it also reduced the amount of data that gets shipped over the wire to, and stored at, every standby database.
Watch Margaret Maglione, Director of Oracle Implementation, explain how her team realized just that:
Tuesday Jan 15, 2013
By Markus Weber on Jan 15, 2013
Listen to this recently recorded podcast to
hear Nick Wagner from Oracle GoldenGate product management team, and Joe
Meeks from Oracle Database product management team discuss how to use
GoldenGate for maximum availability and the new features of GoldenGate
11gR2 that strengthen its high availability solutions.
This podcast is a little recap of the great live webcast we hosted back in December 2012. In case you missed it, make sure to watch it on demand, at your convenience.
Great questions were asked during that webcast, and our expert Joe Meeks was able to answer plenty of them. Here are some great examples of that:
Q: What is the difference between the logical standby and GoldenGate ?
Joe: Data Guard logical standby (SQL Apply) is an included feature of Oracle Enterprise Edition. It utilizes all of the same transport and role management features used by Data Guard Redo Apply (physical standby database), but it uses SQL to apply changes to a standby database that is open read-write (physical standby uses media recovery). The focus SQL Apply is as a feature of Data Guard for database rolling upgrades. The process begins with a primary and Data Guard physical standby. The standby is converted to a logical and upgraded. Production is then switched to the standby and the original primary (now a standby) is upgraded. From 11g onward we use the Transient Logical Rolling Upgrade Process - this results in the upgrade concluding with a primary and physical standby both at the new version. SQL Apply is only used for replication across version
GoldenGate is our comprehensive logical replication product. It is meant to address all advance replication needs and is the preferred solution for requirements such as reporting offload where the target database must be open read-write, bi-directional and multi-master replication, zero downtime upgrades/migrations, data integration, etc.
Q: What is it that Oracle Data Guard can do that Oracle GoldenGate can't ?
Joe: This is a backward way of asking this question . GoldenGate is a comprehensive, feature rich replication product. It can do many things Oracle Data Guard can't.
Data Guard is very focused - simple physical replication. Unlike GoldenGate, it maintains an exact physical replica of the primary (backups are interchangeable), it has no datatype or other restrictions to consider, it uses standard Oracle Media Recovery so has very high performance for all workkloads, it has advanced corruption protection - lost-write protection and automatic block repair. It offers both Synchronous (a guarantee of zero data loss) and Asynchronous replication.
Data Guard's primary goal is to provide the simplest, fastest, most complete data protection for Oracle Database, period.
GoldenGates primary goal is to provide the most feature-rich replication solution for the broadest possible range of requirements.
My recommendation is to first understand your requirements and preferences, then chose the right tool for that job.
Q: How can we use the new DBFS in conjunction with Oracle Data Guard and GoldenGate ?
Joe: DBFS is useful in a GoldenGate configuration to store the GoldenGate trail files and checkpoint files in DBFS to provide recoverability and failover capabilities in the event of a system failure. Using DBFS is fundamental to the continuing availability of the checkpoint and trail files in the event of a node failure. Ensuring the availability of the checkpoint files is essential to ensure that, after a failure occurs, the Extract process can continue mining from the last known archived redo log file position and Replicat processes can start applying from the same trail file position before a failure occurred. Using DBFS allows one of the surviving database instances to be the source of an Extract process or destination for the Replicat processes.
From a Data Guard perspective - anything that is in DBFS is protected just as any other database data is protected. So DBFS provides a way to have Data Guard protect file system content for you as well that would otherwise be external to the Oracle database.
Friday Dec 21, 2012
By margaret hamburger on Dec 21, 2012
You can reduce storage costs AND improve performance when you choose Oracle’s approach to managing data growth. Read how Information
Processing Center reduced their operational database resources by more than
400% using Oracle Advanced Compression. Likewise,
found that it increased the performance of its
PeopleSoft reporting environment by reducing the time to complete certain nightly
extracts from 12 hours to four. Deutsche
Börse AG used a combination of compression and partitioning to reduce their
storage requirements which had grown by 50% to 24 terabytes and achieve optimal performance by partitioning fact
tables with more than 1 terabyte. Health
Market Science also used this combination to manage data growth more cost effectively.
To learn how they did it, listen to Oracle Database expert Kevin Jernigan describe how to reduce your database storage footprint and costs.
Oracle's approach to managing data growth is just one of three compelling reasons to upgrade to Oracle Database 11g.
Have a happy and prosperous New Year!
Thursday Dec 20, 2012
By margaret hamburger on Dec 20, 2012
Because your data is a critical business asset, you depend on having it complete, accurate and available 24x7. Below, I’ve highlighted some key assets we've developed to help you ensure maximum availability.
In 2012, we introduced the Calmest IT guy in the world video series. Watch him to see what it takes to keep business systems available, protect business data from downtime, eliminate idle redundancy of standby servers and recover quickly from human errors.
If any of these situations look familiar you’ll appreciate how these customers addressed their high availability challenges with Oracle Database Solutions. First meet BarrièrePoker.fr who can now guarantee 24/7 availability for their online gaming platform thanks to their high-performance, scalable transactional platform with Oracle Real Application Clusters and Oracle Active Data Guard replication services that eliminated idle redundancy in their standby database environment to better serve their 10,000 players and responds 7x Faster. Or check out ForeSee who used Oracle Active Data Guard for disaster recovery across their data centers to support data growth with a high performance clustered solution or Hospital de Clínicas de Porto Alegre who created a complete contingency IT infrastructure to ensure security of their hospital records with Oracle Active Data Guard.
To learn how to deploy a highly available infrastructure in your environment, listen to Tom Kyte describe Oracle Maximum Availability Architecture best practices or Joe Meeks drill down on disaster recovery. Use can use these simple tools to help you assess your high availability infrastructure and calculate your cost of downtime.
However, to take advantage of many of these great capabilities you will need to upgrade to Oracle Database 11g. So let me end here to wish you a happy and prosperous new year with three compelling reasons to upgrade to Oracle Database 11g with Roy Swonger
Wednesday Sep 26, 2012
By margaret hamburger on Sep 26, 2012
Don't worry if you missed our LIVE webcast ' Three Compelling Reasons to Upgrade to Oracle Database 11g ' with Database Upgrade expert Roy Swonger. You can now register for the On-Demand version to learn about Oracle Database 11g
upgrade best practices with real customer examples. You'll get access to loads of great
upgrade resources for making database upgrades faster and easier. You can also download a copy of our webcast presentation, so register now.
Tuesday Sep 18, 2012
By margaret hamburger on Sep 18, 2012
Thanks for attending today's live webcast, 3 Compelling Reasons to Upgrade to Oracle Database 11g with Oracle Database Upgrade Expert Roy Swonger. We had an amazing turnout this morning and responded to more than 40 of your upgrade questions that I just couldn't wait to share with you.
Don't worry if you missed today's live webcast. You can register for the On-Demand version to learn about Oracle Database 11g upgrade best practices with real customer examples, plus loads of great upgrade resources for making database upgrades faster and easier. You can also download a copy of our webcast presentation.
Tuesday Sep 04, 2012
By Mandy Ho on Sep 04, 2012
September 5, 2012 – Denver, CO
Oracle 11g Database
Join Roy Swonger, Senior Director of software development at Oracle to learn about upgrading to Oracle Database 11g. Topics include:
- All the required preparatory steps
- Database upgrade strategies
- Post-upgrade performance analysis
- Helpful tips and common pitfalls to watch out for
September 6, 2012 – Salt Lake
Fall Symposium 2012
Plan to join us for our annual fall event on Sept 6. They day will be
filled with learning and networking with tracks focused on Applications, APEX,
BI, Development and DBA Topics. This event is free for UTOUG members to attend,
but please register.
September 6, 2012 – Portland, OR
Oracle’s Hands on Workshop Series focused on providing Defense-in-Depth Solutions to secure data at the source, reduce risk and simplify compliance
The Oracle Database Security Workshop is a one-day hands-on session for IT Managers, IT Security Architects and Oracle DBAs who are looking for solutions to address their information protection, privacy, and accountability challenges within their Oracle database environment.
Most security programs offered today fail toadequately address database security. Customers continue to be challenged tosecure information against loss and protect the integrity of sensitiveinformation like critical financial data, personally identifiable information(PII) and credit card data for PCI compliance.
September 11, 2012 – Montreal, QC
For APEX aficionados – join ODTUG in Montreal, September 11-12 for APEXposed!
Topics will include Dynamic Actions, Plug-ins, Tuning, and Building Mobile
Apps. The cost is $399 US and early registration ends August 15th.
For more information: http://www.odtugapextraining.com
September 11, 2012 – Philadelphia, PA
Big Data & What are we still doing wrong with Tom Kyte
Tom Kyte is a Senior Technical Architect in Oracle's Server Technology Division. Tom is the Tom behind the AskTom column in Oracle Magazine and is also the author of Expert Oracle Database Architecture (Apress, 2005/2009) among other books
Abstract: Big Data
The term "big data" draws a lot of attention, but behind the hype there's a simple story. For decades, companies have been making business decisions based on transactional data stored in relational databases. However, beyond that critical data is a potential treasure trove of less structured data: weblogs, social media, email, sensors, and photographs that can be mined for useful information. This presentation will take a look at what Big Data is and means - and Oracle's strategy for handling it
Abstract: What are we still doing wrong?
I've given many best practices presentations in the last 10 years. I've given many worst practices presentations in the last 10 years. I've seen some things change over the last ten years and many other things stay exactly the same. In this talk - we'll be taking a look at the good and the bad - what we do right and what we continue to do wrong over and over again. We'll look at why "Why" is probably the right initial answer to most any question. We'll look at how we get to "Know what we Know", and why that can be both a help and a hindrance. We'll peek at "Best Practices" and tie them into what I term "Worst Practices". In short, a talk on the good and the bad.
September 12, 2012- New York, NY
NYOUG Fall General Meeting
“Trends in Database Administration and Why the Future of Database Administration is the Vdba”
September 21, 2012 – Cleveland, OH
Oracle Database 11g for Developers: What You need to know or Oracle Database 11g New Features for Developers
Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements, pivot statements, JDBC improvements, and PL/SQL enhancements such as compound triggers.
September 24, 2012 – Ottawa, ON
Introduction to Oracle Spatial
The free Oracle Locator functionality, and the Oracle Spatial option which dramatically extends Locator, are very useful, but poorly understood capabilities of the database. In the afternoon we will extend into additional areas selected from: storage and performance; answering business problems with spatial queries; using Oracle Maps in OBIEE; an overview and capabilities of Oracle Topology; under the covers with GeoCoding.
September 25, 2012 – Portland, OR
NWOUG Lunch & Learn "Big Data -- Are you ready?"
"BigData- Are you ready?" The term "big data" is generating a lot of buzz throughout the IT industry, yet, many organizations are still unsure of how to unlock it's value. In this introductory session, we'll outline what big data is and we'll examine Oracle's strategy for turning big data into real business value. We'll review the latest additions to Oracle's product suite, including the newest Engineered Systems - the Oracle Big Data Appliance and Oracle Exalytics In-Memory Machine - and how they help address the challenges of big data.
Speaker Bio - David Segleau is the former VP of Engineering for Sleepycat Software (makers of Berkeley DB) and is now the Director of Product Management for several products at Oracle, including Oracle Berkeley DB and Oracle NoSQL Database. He has over 30 years of industry experience, leading and managing technical product teams.He has worked extensively with database technology as both a customer and a vendor. David has held management positions at many technology companies,including Britton-Lee, ShareBase, Teradata, Illustra, Informix, ANTs Software,Sleepycat Software and now Oracle. As Director of Product Management, David coordinates and communicates technical product features and functionality, both inbound to Engineering and outbound to Oracle Sales, Partners and Customers. He has broad experience with many NoSQL and Big Data use cases and application design challenges.
Monday Jun 18, 2012
By margaret hamburger on Jun 18, 2012
Recently I interviewed Land O'Lakes, Seniro DBA, Joe Cornell. Listen as he describes the circumstances that lead to their deployment of Oracle Advanced Compression in their OBIEE environment. Their general ledger query performance improved up to 14 times faster and they reduced their overall storage footprint by 50% with zero impact on their users.
Friday May 18, 2012
By margaret hamburger on May 18, 2012
The calmest IT guy in the world understands what it takes to recover quickly from human errors. Learn more about Oracle Flashback recovery features and Oracle Database 11g maximum availability solutions.
By margaret hamburger on May 18, 2012
The calmest IT guy in the world understands what it takes to keep business data protected from downtime and eliminate idle redundancy of standby servers. Learn more about Oracle Active Data Guard and Oracle Database 11g maximum availability.
By margaret hamburger on May 18, 2012
IT guy in the world understands what it takes to keep business
systems available. Learn how to increase server availability
with Oracle Real Application Clusters and Oracle Database 11g
maximum availability solutions.
Monday Feb 27, 2012
By margaret hamburger on Feb 27, 2012
This case study describes how BT Operate, the internal IT and network management division of British Telecommunications plc is consolidating their database infrastructure onto a Database as a Service (DaaS) private cloud using Oracle Database 11g.
If the complexity of managing thousands of databases that represent a mix of products, versions, operating systems, and hardware is making application deployment in your database environment too slow, operations too expensive, resource utilization too low, and the workload on your IT team too high, you'll gain the insight you'll need about Oracle Database 11g features and options that can help you achieve greater agility and innovation in your cloud environment.
BT Operate can now manage 30% more databases with 20% fewer
database administrators while reducing the deployment time for a
fully-tested, highly available (HA) database from two to three weeks
down to only 19 minutes or a 1000x improvement.
Read the full story here:
By margaret hamburger on Feb 27, 2012
Join this live webcast to learn about the business and operational improvements that save you time and money, and allow you to take advantage of a faster,
more reliable and secure database environment. Oracle Database 11g maximizes your investment in
Oracle application software including Oracle E-Business Suite, PeopleSoft
and Siebel CRM Applications.
Register for the February 28th Webcast now:
Wednesday Dec 28, 2011
By margaret hamburger on Dec 28, 2011
Technologist of the Year awards recognize individuals in key roles for
their extraordinary efforts and contributions to enterprise technology
solutions. Global winners are selected for early-adopter and
groundbreaking uses of Oracle technology and for defining their roles in
a way that makes the industry take notice. Check out all the Oracle Excellence Awards 2011
winners in the January/February 2012 online issue of Oracle Magazine.