Find Communities by: Category | Product

1 2 Previous Next

Everything Oracle at Dell EMC

18 Posts authored by: WBGaynor

Folks,

What better way to kick off Bastille Day July 14 2016 than attending an EMC sponsored Oracle DBA Day. Vive la France!

 

Charlotte Oracle Solutions Day

 

Event Details
Thursday, July 14, 2016
8:30AM - 3:00PM


Breakfast & Lunch Provided


Hilton Garden Inn Charlotte/Ayrsley
1920 Ayrsley Town Blvd
Charlotte, NC 28273

Customers expect instantaneous response to the dozens of transactions, searches, uploads, downloads, and queries from the applications they depend on every day. Business leaders and developers require immediate access to data and zero delay in application performance. They also demand the most cost-effective ways to make these experiences a reality.


EMC’s All Flash Portfolio can help Oracle professionals maintain application consistency by offering solutions to a gamut of DBA challenges.  EMC helps embrace the modern data center with new dimensions in Flash technology that empower today and tomorrows performance-sensitive and data-intensive workloads.

With exclusive Oracle Days hosted by EMC, Oracle professionals will see how the agile, all flash data center can revolutionize business and why All-Flash Arrays like XtremIO and newly released DSSD are at the top, leading the industry in the era of all flash.


Hear from EMC Oracle experts on the latest flash innovations to revolutionize the data center, discover how an all flash data center is now more affordable than ever before and explore how advanced flash technologies can accelerate application response times by delivering 5M+ IOPs, over 100 GB/sec bandwidth and response times of <100μs.

Agenda:

8:30 – 9:30

Arrival & Registration

9:30 – 10:15

Welcome & Keynote: Redefine Oracle Infrastructure w/Flash

10:15 – 11:00

Increasing Oracle Database Performance

11:00 – 11:15

Break

11:15 – 12:15

Protecting Your Oracle Environment

12:15 – 1:15

Networking Lunch/Demos

1:15 – 2:00

Optimizing Oracle Environments & Accelerating Your Time to Market

2:00 – 2:45

The Future of Business Intelligence

2:45 – 3:00

Wrap Up & Next Steps

To register follow one of these links:

https://emcinformation.com/433102/SI/00000000-0000-0000-0000-000000000000.ashx?reg_src=SA

http://e01.ams11.com/OutboundMessage.aspx?M=1345.2b31f5ff-4f68-4be4-bd41-4c91e08169f4

 

For additional information, please contact Tena Black by e-mail or at 508-497-1621.

EMC Advisory Systems Engineer

Job Location: US - Massachusetts - Hopkinton, US - New Jersey - Berkeley Heights, US - New York - New York City, US - Texas - Dallas, US - Virginia - McLean


Accelerate your career as you help reinvent the value and impact of information for business everywhere. At EMC, we are leading customers on their journey to cloud computing by enabling them to store, manage, protect and analyze their information assets in a more agile, trusted and cost-effective way. If you are passionate about technology and want to be part of the information management revolution, join more than 50,000+ EMC’ers around the world who are leading the journey to the cloud.

 

GENERAL SUMMARY

Provides technical leadership and direction to customers and internal staff in the development of fully integrated technology solutions in support of pre-sales activities in the assigned market. Assists in the analysis, design and development of fully integrated technology solutions. Acts as technical expert and consultant to develop and propose solutions that meet the technology and business requirements of assigned customers. Technical emphasis is on hardware capabilities, software requirements and systems integration. Makes technical and sales presentations to customer's technical staff and senior management. Understands EMC and competitive technology and business applications within the assigned market. Assists in the development of responses to customer requests and proposals as required. Conducts research, answers questions and removes objections that arise in a sales campaign. Serves as a trusted technology advisor to customers and serves as an internal resource on technical issues or specific business applications within an assigned market segment. Makes technical and sales presentations to technical staff and top management. Applicable markets: Enterprise, Commercial, Partner, Specialist/Practice

PRINCIPAL DUTIES AND RESPONSIBILITIES Works with Sales Team to develop and implement specific account penetration strategies, produce account specific product and service and sales plans. Maintains knowledge of competitive solutions to effectively address and dispel customer objections to EMC solutions, and train the account team. Anticipates technology and/or market trends and provides guidance on their application to external customers and feedback of business requirements back into EMC's engineering and marketing organizations. Successfully builds relationships with the account team, partners and customers in support of sales team objectives and engages and leverages corporate resources, abilities, budgets and personnel as appropriate. Leads technical sales calls Configures and documents EMC software, hardware and service solutions to meet customer and sales objectives. Completes required presales documentation quickly and accurately. Qualifies sales opportunities in the terms of customer technical requirements, competition, decision making process and funding. Assumes leadership role in District Sales and Services Leadership Meetings. Presents and markets the design and value of proposed EMC solution and business case to customers, prospects and EMC management. Participates in mentorship of more junior TC family members. Possesses strong, detailed product/technology/industry knowledge. Knowledge of job associated software and applications. EMC Proven Professional Certification desired.


SKILLS:@ !
Leadership Skills.
Cross-Functional skill.
Results driven.
Communication skills.
Organizational skills.
Customer focused.
Consultative skills.


When you choose EMC, you join a diverse world of innovative thought leaders. At our core is a commitment to workplace diversity, the sustainability of our planet, and community corporate involvement. We offer highly competitive salaries, bonus programs, world-class benefits, and unparalleled growth and development opportunities-all to create a compelling and rewarding work environment. EMC will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants except in very limited circumstances identified by law.

 

We are an Equal Employment Opportunity employer that values the strength diversity brings to the workplace. All qualified applicants, regardless of race, color, religion, gender, sexual orientation, marital status, gender identity or expression, national origin, genetics, age, disability status, protected veteran status, or any other characteristic protected by applicable law, are strongly encouraged to apply.

More can be found here:

https://jobs.emc.com/job/hopkinton/emc-advisory-systems-engineer/414/1643753

 

Or here:


https://sjobs.brassring.com/tgwebhost/jobdetails.aspx?partnerid=20085&siteid=5109&jobid=513020

Job ID: 161913BR

If you are heading to Oracle Open World you will want to check in at the EMC Rocks VIP Event at the Elan Event Center 839 Howard St, San Francisco, CA 94103. Right around the corner from the Moscone Center West.


The EMC Rocks VIP Event will feature EMC technologies and their integration with Oracle technologies. We will feature technical sessions, expert presentations, demos, and hands-on labs.  There will also be food, drinks, a networking event, and a customer appreciation party.


Some of the technical sessions to be covered are:

  • High Performance Oracle Infrastructure with FLASH Optimized Storage
  • Protecting Your Oracle Environment – Backup, High Availability & Continuous Availability
  • Next Generation Enterprise Storage for Oracle Databases
  • Powering Oracle E-Business Suite with Cisco & VNX
  • Reducing Oracle License Costs with Converged Infrastructure
  • Building an Oracle Database-as-a-Service Infrastructure

 

The scheduled hours are from 8 am to 6 pm Monday October 26th through Wednesday October 28th.  Also join EMC for a special networking event between 7-9pm on Monday October 26th and a Customer Appreciation party from 6pm to 9pm on Tuesday October 27th.  

 

Check out the entire event schedule here: http://thecoreblog.emc.com/emc-rocks-oracle-openworld-vip-event/

Again at:

Elan Event Center 839 Howard St, San Francisco, CA 94103

 

The event is first come first serve.  Pre registering for this event is encouraged.  Click here to register: https://emcinformation.com/367405/SI/.ashx?reg_src=SA


Please stop by and meet members of the EMC Oracle Specialists Team.

Please Join Us

Seattle Oracle

Solutions Day


Event Details

Tuesday, August 18th, 2015 9:00am – 4:00pm


Breakfast & Lunch will be provided

Reception to follow

4:00pm – 5:30pm


Maritime Event Center

2211 Alaskan Way

Seattle, WA 98121



 

Why Should You Attend?

 

The Oracle Solutions Day is designed to be an interactive session to help you and your staff learn about solutions and strategies to optimize your Oracle environments. Please join our EMC, Oracle experts and your peers as we talk about how we can help you along your journey to optimize your Oracle environments.

 

This session will share best practices and experience to leverage Oracle software and features in combination with technologies such as all-flash-arrays, hybrid-cloud computing, backup, data protection and database-as-a-service. We will also discuss advanced topics such as database licensing strategies.


 

Agenda


9:00 – 9:15

 

 


Arrival & Breakfast

 

 

9:15 – 9:30

 

Welcome & Agenda Review

 

 

9:30 – 11:00

 

Redefining Oracle Database Infrastructure with Flash

 

 

11:00 – 11:45

 

Optimizing and Deploying Oracle “As-A-Service”

 

 

11:45 – 12:30

 

Oracle Licensing Optimization – House of Brick

 

 

12:30 – 1:00

 

Lunch

 

 

1:00 – 2:00

 

Oracle Continuous Data Protection with RAC

 

 

2:00 – 3:30

 

Faster and More Efficient Backups with De-duplication

 

 

3:30 – 4:00

 

Wrap-Up & Next Steps

 

 

4:00 – 5:30

 

Reception

 

 


 

 



 

 

Invitation is attached below with registration link.

Or register here: https://www.eventbrite.com/e/seattle-oracle-solutions-day-tickets-17430454960

Please Join Us
Boston Oracle Solutions Day

Tuesday, July 21, 2015 from 9:00 AM to 4:00 PM (EDT)

Gillette Stadium
1 Patriot Place
Foxborough, MA 02035

 

Why Should You Attend?

The Oracle Solutions Day is designed to be an interactive session to help you and your staff learn about solutions and strategies to optimize your Oracle environments. Please join our EMC, Oracle experts and your peers as we talk about how we can help you along your journey to optimize your Oracle environments.

 

This session will share best practices and experience to leverage Oracle software and features in combination with technologies such as all-flash-arrays, hybrid-cloud computing, backup, data protection and database-as-a-service. We will also discuss advanced topics such as database licensing strategies.

 

Agenda

9:00 - 9:15

Arrival & Breakfast

9:15 – 9:30

Welcome & Agenda Review

9:30 – 11:00

Redefining Oracle Database Infrastructure with Flash

11:00 – 11:45

Optimizing and Deploying Oracle “As-A-Service”

11:45 – 12:30

Oracle Licensing Optimization – House of Brick

12:30 – 1:00

Lunch

1:00 – 2:00

Oracle Continuous Data Protection with RAC

2:00 – 3:30

Faster and More Efficient Backups with De-duplication

3:30 – 4:00

Wrap-Up & Next Steps

4:00 – 5:30

Stadium Tour & Reception

To register go here: https://www.eventbrite.com/e/boston-oracle-solutions-day-tickets-17412886412

Please Join Us
Philly Oracle

Solutions Day

 

Event Details
Thursday, September 16th, 2015
9:00am – 4:00pm

Breakfast & Lunch will be provided

Reception to follow

4:00pm – 5:30pm

 

Philadelphia Marriott Downtown

1201 Market Street

Philadelphia, PA 19107

 

Why Should You Attend?

The Oracle Solutions Day is designed to be an interactive session to help you and your staff learn about solutions and strategies to optimize your Oracle environments. Please join our EMC, Oracle experts and your peers as we talk about how we can help you along your journey to optimize your Oracle environments.

 

This session will share best practices and experience to leverage Oracle software and features in combination with technologies such as all-flash-arrays, hybrid-cloud computing, backup, data protection and database-as-a-service. We will also discuss advanced topics such as database licensing strategies.

 

Agenda

9:00 – 9:15

Arrival & Breakfast

9:15 – 9:30

Welcome & Agenda Review

9:30 – 11:00

Redefining Oracle Database Infrastructure with Flash

11:00 – 11:45

Optimizing and Deploying Oracle “As-A-Service”

11:45 – 12:30

Oracle Licensing Optimization – House of Brick

12:30 – 1:00

Lunch

1:00 – 2:00

Oracle Continuous Data Protection with RAC

2:00 – 3:30

Faster and More Efficient Backups with De-duplication

3:30 – 4:00

Wrap-Up & Next Steps

4:00 – 5:30

Reception

 

 

To register go to https://www.eventbrite.com/e/philly-oracle-solutions-day-tickets-17690641184

Invite is attached, please pass it on.

A recent conversation with an Oracle ERP customer led to some interesting use-cases for EMC XtremIO.

 

When running Oracle databases on XtremIO it is typical to see 2:1 database compression, so, for example, a ten TB database sitting on XtremIO will only require five TB of storage. Slightly higher and slightly lower ratios have been reported.

 

There is about a 25% storage overhead with XtremIO, used for XtremIO’s XDP RAID (8%), metadata destaging and vault space giving 75% usable capacity. Certainly much lower than the 67% overhead on Exadata three-way RAID mirroring giving 33% usable capacity.

 

Plus a snapshot of a source database taken on the same XtremIO cluster is initially simply a set of in-memory metadata pointers requiring no storage space, only generating storage usage as deltas are generated against the read/write snapshot. (OK, the metadata has to be stored somewhere and is part of the 25% overhead mentioned above.)

 

So this customer is facing two challenges with their 15TB Oracle R12 ERP environment.

 

  1. They are in the middle of an upgrade to the system integrating new business units after some M&A activities.
  2. They are looking for a more robust DR strategy.

 

The upgrade is generating the multiple environments for dev/test/QA/patch/training typical of ERP upgrades and implementations. But here note with a 15 TB database source database that is three-way mirrored on Exadata each environment is consuming 45 TB of storage on Exadata. Not pretty.

 

What is proposed is to deploy a few appropriately sized commodity servers for their Oracle RAC hosts and run a Dataguard physical standby residing on XtremIO from their prod R12 ERP residing on Exadata. Immediately they reduce the footprint from 15 TB (45 TB) to about 7.5 TB with XtremIO’s compression had they used another Exadata appliance for DR. But here is the kicker: once on XtremIO snapshots can be taken off the Dataguard standby to provision the dev/test/QA/patch/training environments requested by the implementation team. And they are “free” from a storage footprint perspective except for the deltas generated on the read/write snapshots and some additional metadata. But even the deltas and metadata are compressed. Pretty.

 

And should they need to failover to DR, with an IOPs sizing and design exercise based off their prod implementation, they are assured the XtremIO storage subsystem will support the IOPs requested with production usage. Pretty Polly.

EMC, Cisco and VCE are sponsoring an Oracle DBA Day in Santa Clara CA with a parallel agenda on July 24th and July 25th 2014. Pick the day that is best for you.

 

The location is EMC Corporation Executive Briefing Center at 2831 Mission College Blvd, Santa Clara CA 95054.

 

Register for this event.

 

Why Should You Attend?

 

The Oracle Solutions Day is designed to be an interactive showcase of Solutions and Strategies providing customers the opportunity to leverage a Hybrid Cloud with true Application Portability. Any application, any time, any place…

We will discuss the following with our experts and help you to incorporate solutions that fit to your environment:

 

  • E-Business Suite Best Practices
  • Deploying “As-A-Service”
  • Avoiding Oracle Disasters
  • Maximizing Flash Performance
  • 12c Performance and Scalability


Please join the experts and your peers as we talk about how we can help you along your journey.

 

Agenda

 

8:00 – 8:30

Arrival & Breakfast

8:30 – 8:45

Welcome, Introductions & Agenda Review

8:45 – 9:30

Cisco on Solving Your Business Challenge

9:30 – 9:45

Break

9:45 – 10:45Maximizing Flash Performance
10:45 – 11:45Cisco on E-Business Suite Best Practices
11:45 – 12:30Break & Lunch
12:30 – 1:30Deploying Oracle “As-A-Service”
1:30 – 1:45Break
1:45 – 2:45Avoiding Oracle Disasters
2:45 – 3:45Oracle on 12c Performance and Scalability
3:45 – 4:00Wrap-Up & Next Steps
4:00 – 6:00Social Event

EMC, Cisco and VCE are sponsoring an Oracle DBA Day in Charlotte NC with a parallel agenda on July 30th and July 31st 2014. Pick the day that is best for you.

 

The location is the Harris Conference Center, 3216 CPCC Harris Campus Drive, Charlotte NC 28208

 

Register for this event.


Why Should You Attend?

 

The Oracle Solutions Day is designed to be an interactive showcase of Solutions and Strategies providing customers the opportunity to leverage a Hybrid Cloud with true Application Portability. Any application, any time, any place…

We will discuss the following with our experts and help you to incorporate solutions that fit to your environment:

 

  • E-Business Suite Best Practices
  • Deploying “As-A-Service”
  • Avoiding Oracle Disasters
  • Maximizing Flash Performance
  • 12c Performance and Scalability


Please join the experts and your peers as we talk about how we can help you along your journey.

 

Agenda

 

8:00 – 8:30

Arrival & Breakfast

8:30 – 8:45

Welcome, Introductions & Agenda Review

8:45 – 9:30

Cisco on Solving Your Business Challenge

9:30 – 9:45

Break

9:45 – 10:45Maximizing Flash Performance
10:45 – 11:45Cisco on E-Business Suite Best Practices
11:45 – 12:30Break & Lunch
12:30 – 1:30Deploying Oracle “As-A-Service”
1:30 – 1:45Break
1:45 – 2:45Avoiding Oracle Disasters
2:45 – 3:45Cisco on 12c Performance and Scalability
3:45 – 4:00Wrap-Up & Next Steps
4:00 – 6:00Social Event

EMC, Cisco and VCE are sponsoring an Oracle DBA Day in New York CIty with a parallel agenda on August 13th and August 14th 2014. Pick the day that is best for you.

 

The location is the EMC office at 2 Penn Plaza, 26th Floor, NYC NY 10121.

 

Register for this event.

 

Why Should You Attend?

 

The Oracle Solutions Day is designed to be an interactive showcase of Solutions and Strategies providing customers the opportunity to leverage a Hybrid Cloud with true Application Portability. Any application, any time, any place…

We will discuss the following with our experts and help you to incorporate solutions that fit to your environment:

 

  • E-Business Suite Best Practices
  • Deploying “As-A-Service”
  • Avoiding Oracle Disasters
  • Maximizing Flash Performance
  • 12c Performance and Scalability


Please join the experts and your peers as we talk about how we can help you along your journey.

 

Agenda

 

8:00 – 8:30

Arrival & Breakfast

8:30 – 8:45

Welcome, Introductions & Agenda Review

8:45 – 9:30

Cisco on Solving Your Business Challenge

9:30 – 9:45

Break

9:45 – 10:45 Maximizing Flash Performance
10:45 – 11:45 Cisco on E-Business Suite Best Practices
11:45 – 12:30 Break & Lunch
12:30 – 1:30 Deploying Oracle “As-A-Service”
1:30 – 1:45 Break
1:45 – 2:45 Avoiding Oracle Disasters
2:45 – 3:45 Cisco on 12c Performance and Scalability
3:45 – 4:00 Wrap-Up & Next Steps
4:00 – 6:00 Social Event

AppSync is a GUI driven management interface to EMC array-based cloning, snapshot, and remote replication technologies and RecoverPoint local and remote replication technologies. With release 2.0 of AppSync intelligence around Oracle databases has been added. For those of you familiar with EMC Replication Manager (RM) and its use for Oracle databases AppSync now supports similar functionality.

 

Some GUI-driven scenarios:

1) For Oracle backups and restores users can subscribe their databases to a customizable service plan that say i. creates both local and remote clones, ii. creates only a local clone or iii. creates only a remote clone. The service plans can operate through AppSync's scheduler where the database is placed in hot backup mode before the clone is snapped off, and possibly mounted to a backup host from which to run a RMAN backup job. Alternatively the clone can be mounted to the production host and registered with the RMAN catalog to be used for RMAN restore operations at the level of granularity that RMAN supports.

 

2) Repurposing copies of a production source or copies off copies can be used for life cycle management of test, development, training, patching, reporting, etc environments. Mounting of these copies can be scheduled, mounted on alternative hosts, with changes, for examples, to the database name and SID. On-demand refreshes of the copies are also possible, so that control of the refresh can be passed to the relevant teams using the clones or snaps.

 

At the more general level AppSync allows for:

  • Mounting copies to alternative hosts
  • Mounting a copy with a new database name and SID, for example renaming from prod to test
  • Mounting to alternative mount points or renamed ASM disks
  • Making clones or snaps where the database is either placed in hot backup mode or shutdown first, or created as a write-ordered restartable image
  • Running pre- or post-clone/snap scripts, for example post-clone RMAN scripts
  • Scheduling clone and snapshot jobs

 

Supports Oracle database.

  • Oracle 11.2.x, Oracle 12c (does not include new 12c container features)
  • Supported on Linux - physical, virtual (pRDM, vDisk)
  • Supported on AIX- physical, NPiV
  • Supported with VMAX, VNX, RecoverPoint
  • Standalone, RAC, ASM

 

Support for VMAX

  • Oracle, File-Systems, Microsoft Exchange, Microsoft SQL Server, VMware DataStores
  • Local snaps, clones
  • Remote snaps, clones
  • Local/remote snaps of clones, clones of clones

 

Repurposing for Oracle databases residing on VMAX or VNX, AppSync supports the ad-hoc creation of Oracle database copies, followed by the creation of copies of those copies. This practice is referred to as Repurposing. The repurposed copies can serve many useful functions including test-dev, break-fix, data mining and reporting.

  • VMAX -- Local/remote snaps of clones, clones of clones
  • VNX -- Snap of snap

 

Support for generic filesystems includes:

  • Dynamic discovery of filesystems during Service Plan run
  • Protection, Mount and Restore
  • Supported on Windows, Linux, AIX


AppSync Backup Assistant - Backup and restore (rollback) the AppSync database.

AppSync host plug-in can coexist with NetWorker or Replication Manager agents.

Just a quick note to let all know that EMC is hosting a webinar on XtremIO for databases. Both are on Thursday June 12th, one at 8 am PST and the other at 7 pm PST. The webinar will be posted after for on-demand viewing.

 

To register go to http://xtremio.com/webinars

 

The posted description is:

 

Transform Your Database Infrastructure with EMC XtremIO

EMC XtremIO all-flash arrays are significantly changing the way database applications are deployed. This webinar will provide insight into how flash can be used beyond boosting performance- things like reducing over-provisioning and reducing overall costs. You will hear about different options to deploy streamlined, on-demand and virtualized data warehouse/analytics and test/dev infrastructure, all while maintaining OLTP/other production SLAs by harnessing the capabilities of an XtremIO all-flash array. Learn how our customers are accelerating and scaling databases while consolidating the broader database infrastructure to achieve efficiency, agility and flexibility- all with XtremIO.

Folks,

I would like to draw your attention to three pieces on XtremIO for Oracle.


All three point to better use of datacenter resources through deploying Oracle on XtremIO while reaping low latencies and better performance.

 

First, a great discussion by Kevin Closson of EMC Performance Engineering:

XtremIO for Database and Analytics Workloads  

http://youtu.be/kvOn6exiDes


Second, a customer reference revealing low latencies, cost savings, and ease of deployment of Oracle RAC on XtremIO:

CMA: Massive Oracle data warehouse performance with XtremIO

http://www.emc.com/collateral/customer-profiles/h12344-cma-oracle-xtremIO-cp.pdf

 

Third, a discussion of an energy-saving deployment of SAP/Oracle on XtremIO:

How to Go Green, Have Your Cake and Eat It Too

http://www.emc.com/collateral/analyst-reports/xtremio-green-enterprise-it-case-study.pdf

As many know by now the idea is one container database will hold multiple pluggable databases, where a pluggable database will be a self-contained application database, such as one for Oracle ERP, one for CRM, one for data warehousing, and then separate pluggable databases for dev and test databases, etc. In a cluster of database hosts the pluggable databases can be moved between nodes. Plus a container database has functionality to easily deploy new pluggable database based on a template pluggable database or by cloning existing pluggable databases. With 12.1.x 252 pluggable databases are the maximum per container.

 

Oracle is positioning their container database or multi-tenant database as a "Cloud" platform, but largely speak of it in terms of consolidation. Oracle contrasts it with other consolidation techniques and technologies including consolidating hosts via virtualization, consolidating databases via RAC clusters, and consolidating database schemas into a database.

 

The advantages are stated to be that:

 

  • There are fewer physical servers to maintain
  • There is better memory and CPU utilization
  • A container database and its pluggable databases are managed as one database
  • Backups can be done to the container including its pluggable databases – “one for all”
  • There is one Dataguard standby or DR implementation for all databases in the container – again “one for all”
  • Yet there is application database isolation

 

To my ears this does not sound much different than Oracle RAC and sounds similar to the messaging for consolidation of databases on an Oracle RAC cluster. Although backups and DR are possibly simplified with the container's “one for all” approach, this might not be ideal, particularly with DR, if all applications in the container are forced to failover together.

 

And like RAC there is much that is shared, though with differences. If a RAC database shares storage and global memory, and these at times limit its scalability, a container database is also sharing components.

 

The architecture of a multitenant database has the container database and all its pluggable databases:

 

  • Sharing common database SGA & PGA memory areas
  • Sharing the UNDO tablespace
  • Sharing the controlfiles and the spfile
  • Sharing redo log and archive log files
  • Possibly sharing RMAN backup files, the container and any pluggable database can be backed up separately and
  • Possibly sharing a Dataguard standby
  • By default they share the TEMP tablespace, but a PDB can have its own
  • And they share Oracle processes that manage these components

 

Each pluggable database has own SYS and SYSAUX tablespaces.

 

These shared resources do raise the possibility of resource contention limiting scalability and calls into question Oracle’s statement of the isolation of application databases within the container database.

 

I’m imagining DBAs and application teams embracing multi-tenancy first for ease of cloning and provisioning new environments particularly for dev/test/patch/training.

 

The cloud message is not coming through to me, perhaps other see things differently. Coming from EMC, of course, cloud means virtualization to me. And of course there is nothing to keep shops from running their 12c databases on virtualized hosts and reaping the benefits of virtualization.

EMC's Sales Teams and EMC's Partner Sales Teams have access to an online tool that allows them to analyze the content of a set of AWR or Statspack reports producing an extensive PowerPoint revealing the analysis. We call the output an Oracle Workload Profile Assessment (WPA). The tool supports Oracle databases versions 10gR1 or higher with more complete results with 10gR2 or higher.

 

WPAs were originally designed to aid EMC in architecting storage solutions for its Oracle customers. The WPAs are free to EMC customers or potential customers and help to bridge possible communication gaps between DBA teams and the rest of your IT colleagues. Plus they allow EMC and its Partners to take a performance view of storage design and the potential usefulness of some of EMC's advance technologies, such as the fit for SSDs.

 

With a set of AWR or Statspack reports covering several days the WPA builds a time-series view of the database. The focus of a WPA is on the IO characteristics of the database. Things like read and write IOPs and MB/s, read and write IO sizes, read/write ratio, IO latencies including IO-related timed events, IOPS generated by core transactional database processing vs. IOPs generated by archive log, RMAN backup, restores, recoveries and Oracle utilities processing. The WPA RAID adjusts the IOPs and estimates the number of drives of various types to support the IOPs, here again taking a performance view of the database. All metrics are graph over time.


There is more in a WPA that a DBA may be interested in seeing: hard parsing, redo log switching, redo log writes and bytes per second, host CPU utilization by system, user, and IO wait, most active tablespaces over time and their read response times in milliseconds, a list of non-IO related timed events showing any latency and finally transactions, executions and commits per second. Again all metrics are graphed over time.

 

Let's have a look at some of the output.

 

Here are the estimated RAID-5 and RAID-10 IOPs for the core transactional components of a sample database graphed over time.

iops.png

 

Below we have a graph of the number of 15k rpm drives in RAID-5 and RAID-10 estimated to support the estimated IOPs for the transactional components.

drives.png


The WPA also show the peak and 95th percentile values for these estimates.

peak95th.png


Similarly below are the RAID-5 and RAID-6 IOPs for the archive log, RMAN backup, restores, & recoveries, and other Oracle utilities such as export/import, and SQLLoader (ABRU) processing.

ABRUIOPs.png

Some insight into the nature of the database is given by the percentage of single-block vs. multi-block read and write requests. 'Block' here refers to the default database block size determined when the database was created. A large percentage of single block read and write requests suggest an OLTP type database.

sbperc.png

Above we see a rather high percentage of single-block read requests with a less high percentage of single-block write request. How big are the reads and writes when multi-block? Remember SSDs have a sweet-spot for "small" random reads, say less than 64KB to 128KB.

mblocksize.png

As stated there is a good deal more in a WPA, the above are just some highlights.

 

If you would like to see a WPA run for one or more of your databases, please contact your EMC Sales Team or an EMC Partner Sales Team.

 

If you want to get a jump on the process, here is what they will ask for:

  • A set of 48 to 96 30-minute or 1-hour sample-interval Statspack or AWR reports capturing peak activity timeframes.
    • A shorter sample interval and more reports are fine
  • Make the best attempt to identify peak activity periods for the reports.
    • Including prime heavy usage business hours timeframes
    • Including batch processing timeframes
  • Scripts are supplied to ease the generation of reports in TXT format.
    • genawrs.sql for AWR reports & gensprpts.sql for Statspack reports
    • Only one script is used
    • The scripts are attached in a zip file to this blog post
  • If this is a RAC environment, then reports are requested for each instance in the RAC cluster.
  • Create an individual .ZIP file with the AWR/Statspack report files for each database and with RAC all instances of a database in one .ZIP file

Filter Blog

By date:
By tag: