Feed aggregator
New SWOT Report: Running Mission-Critical Workloads In Multi-Cloud Environments Is Oracle’s Super Power
By Sasha Banks-Louie, Oracle—Jun 2, 2020
Multi-cloud environments are becoming the de-facto cloud strategy among a majority of US businesses that have moved their applications to the cloud, but managing these complex infrastructures is creating new challenges that many companies are struggling to surmount—if they decide to move to the cloud at all.
These are among the key conclusions from a new report by Omdia Consulting, which analyzes the strengths, weaknesses, opportunities, and threats of running workloads in Oracle Cloud Infrastructure.
Key findings from the Omdia SWOT report include:
- More than 52% of businesses report the inability to move workloads between clouds is slowing their adoption of cloud computing
- The alliance between Oracle Cloud Infrastructure and Microsoft Azure plans to speed up cloud adoption, by offering businesses direct interconnection between these two clouds, integrating identity management, and honoring a collaborative support agreement
- Oracle’s open, enterprise-grade cloud architecture not only provides businesses with near zero downtime and no cost to onboard and offboard users, it also offers the most comprehensive sets of security standards and customer support services compared to competing cloud vendors
While most cloud infrastructure vendors offer companies an environment on which to run their mission-critical applications without having to manage a data center, invest in hardware, or install and update software, those vendors’ service, pricing, and support plans can vary widely.
In its recently published SWOT Assessment of Oracle Cloud Infrastructure, Omdia Consulting offers new insight into why companies should consider running their mission-critical workloads in the Oracle Cloud.
Because Oracle Cloud Infrastructure has built a reputation for reliability, companies are guaranteed more than 99.99% availability uptime, and fewer than four minutes per month for maintenance work, the report says.
Such high availability is particularly important, because banks that can’t process high-speed financial transactions or retailers who aren’t able to synchronize their ecommerce websites with their on-hand inventories and point-of-sale data, can lose revenue, frustrate customers, and damage their brands.
Mastering Multi-Cloud EnvironmentsAs an increasing number of businesses today live in a multi-cloud world, it’s important for cloud vendors to integrate their offerings with those of their competitors.
The Oracle and Microsoft alliance announced in June 2019 enables joint customers to deploy mission-critical enterprise workloads that span both Microsoft Azure and Oracle Cloud Infrastructure environments.
Such customers can run Azure analytics and AI, for example with Oracle Autonomous Database on the same workload. This not only makes it easier for companies to have a backup cloud to aid in disaster recovery, but also to split up workloads so that data architects and application developers can choose their preferred environments and tools.
The Oracle and Microsoft alliance also removes the burden of managing multiple service orders, networking configurations, and data transfers from different clouds across workloads.
Raising The Bar For Security StandardsThe range of standards that Oracle provides compliance with is one of the most comprehensive among the leading cloud providers, according to Omdia’s SWOT report.
While currently compliant with ISO 27001, SOC1, SOC2, PCI DSS, HIPAA/HITECH, FedRAMP Medium, and FedRAMP High, Oracle Cloud Infrastructure also follows a media destruction process adhering to NIST SP 800-88r1 and DoD emergency destruction and secret classification standards.
A new feature in Oracle’s Gen 2 Cloud is Isolated Network Virtualization, which isolates physical network interfaces and cards from each other, isolating an attacker who has gained unauthorized access to the network. Through this process, Oracle helps companies protect against bad actors from attacking their networks when an instance, bare-metal, virtual-machine, or container, has been compromised.
Gaining Share Through Human Customer SupportWhile all cloud infrastructure vendors let their customers access online documentation and community forums for free, many of those vendors charge hefty fees for hands-on, expert support—like the kind you’ll need to fix a latency problem or network outage.
But companies running their workloads on Oracle Cloud Infrastructure Free Tier, can get an enterprise-level support package, which includes two Oracle Autonomous Databases with powerful tools like Oracle Application Express (APEX) and Oracle SQL Developer, two Oracle Cloud Infrastructure Compute virtual machines, block, object, and archive storage, load balancer and data egress, and monitoring and modifications—for free.
It’s this kind of human customer care that has driven approximately 80% of Oracle’s customers to stay in the Oracle Cloud for between one and three years, and 21% of them committing to three-year subscriptions, according to Omdia’s SWOT analysis. The report also shows more than 50% of Oracle’s customers increase their spend once they have moved to Oracle Cloud Infrastructure, and the rate of new customers moving to Oracle Cloud is more than 150% year on year.
This level premium support, including zero fees for onboarding or offboarding customers to its eponymous Cloud Infrastructure, demonstrates Oracle’s strong commitment to be an open enterprise-grade cloud—earning its position as a top-five cloud provider in the world.
We live in a multi-cloud world and customers expect cloud providers to excel at interconnecting various platforms, applications, and workloads. Omdia’s report highlights several critical elements that make Oracle uniquely qualified to provide this interconnectivity, while offering exceptional performance, pricing, and support.
Click here for more Industry Analyst Research.
Oracle Cloud Infra [1Z0-1072] Certification For Architects
Hear us when we say Oracle Cloud (OCI) is everywhere whether it is Zoom, 8×8, Air Asia, Michelin, Vodafone, Xerox, Airtel, Netflix & many more. Things are moving from On-Premise to Cloud and so are DBAs, Apps DBAs, System Administrators, Network, Storage & Security Admins & Architects, and everyone working On-Premise. The 1Z0-1072- Oracle Cloud […]
The post Oracle Cloud Infra [1Z0-1072] Certification For Architects appeared first on Oracle Trainings for Apps & Fusion DBA.
Automating External Table load
ORA-06530: Reference to uninitialized composite
ORA-02070: database DBLINK does not support subqueries in this context when updating SQL Server via gateway
Order By
This is a brief note with an odd history – and the history is more significant than the note.
While searching my library for an example of an odd costing effect for the “order by” clause I discovered a script that looked as if I’d written for 11.1.0.6 in 2008 to demonstrate a redundant sort operation appearing in an execution plan; and then I discovered a second script written for 11.2.0.4 in 2014 demonstrating a variant of the same thing (presumably because I’d not found the original script in 2014) and the second script referenced a MOS bug number
Bug 18701129 : SORT ORDER BY ISN’T AVOIDED WHEN ROWID IS ADDED TO ORDER BY CLAUSE
Whenever I “discover” an old bug test I tend to re-run it to check whether or not the bug has been fixed. So that’s what I did, and found that the anomaly was still present in 19.3.0.0. The really odd thing, though, was that the bug note no longer existed – and even after I’d done a few searches involving the text in the description I couldn’t manage to find it!
For the record, here’s the original 2008 script (with a couple of minor edits)
rem
rem Script: order_by_anomaly.sql
rem Author: Jonathan Lewis
rem Dated: June 2008
rem Purpose:
rem
rem Last tested
rem 19.3.0.0 Still sorting
rem 12.2.0.1
rem 11.1.0.6
rem
set linesize 180
set pagesize 60
create table test
as
select *
from all_objects
where rownum <= 10000 -- > comment to avoid wordpress format issue
;
alter table test modify object_name not null;
create index i_test_1 on test(object_name);
analyze table test compute statistics;
set serveroutput off
alter session set statistics_level = all;
select *
from (select * from test order by object_name)
where
rownum < 11 -- > comment to avoid wordpress format issue
;
select * from table(dbms_xplan.display_cursor(null,null,'allstats last'));
select *
from (select /*+ index(test) */ * from test order by object_name,rowid)
where
rownum < 11 -- > comment to avoid wordpress format issue
;
select * from table(dbms_xplan.display_cursor(null,null,'allstats last'));
alter session set statistics_level = typical;
set serveroutput on
Yes, that is an analyze command – it’s a pretty old script and I must have been a bit lazy about writing it. (Or, possibly, it’s a script from an Oracle-l or Oracle forum posting and I hadn’t re-engineered it.)
I’ve run two queries – the first uses an inline view to impose an order on some data and then selects the first 10 rows. The second query does nearly the same thing but adds an extra column to the “order by” clause – except it’s not a real column it’s the rowid pseudo-column. Conveniently there’s an index on the table that is a perfect match for the “order by” clause and it’s on a non-null column so the optimizer can walk the index in order and stop after 10 rows.
Adding the rowid to the “order by” clause shouldn’t make any difference to the plan as the index Oracle is using is a single column non-unique index, which means that the internal representation makes it a two-column index where the rowid is (quite literally) stored as the second column. But here are the two execution plans:
---------------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | ---------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | | 10 |00:00:00.01 | 7 | |* 1 | COUNT STOPKEY | | 1 | | 10 |00:00:00.01 | 7 | | 2 | VIEW | | 1 | 10 | 10 |00:00:00.01 | 7 | | 3 | TABLE ACCESS BY INDEX ROWID| TEST | 1 | 10000 | 10 |00:00:00.01 | 7 | | 4 | INDEX FULL SCAN | I_TEST_1 | 1 | 10 | 10 |00:00:00.01 | 3 | ---------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<11) ---------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem | ---------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | | 10 |00:00:00.01 | 4717 | | | | |* 1 | COUNT STOPKEY | | 1 | | 10 |00:00:00.01 | 4717 | | | | | 2 | VIEW | | 1 | 10000 | 10 |00:00:00.01 | 4717 | | | | |* 3 | SORT ORDER BY STOPKEY | | 1 | 10000 | 10 |00:00:00.01 | 4717 | 4096 | 4096 | 4096 (0)| | 4 | TABLE ACCESS BY INDEX ROWID BATCHED| TEST | 1 | 10000 | 10000 |00:00:00.01 | 4717 | | | | | 5 | INDEX FULL SCAN | I_TEST_1 | 1 | 10000 | 10000 |00:00:00.01 | 44 | | | | ---------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<11) 3 - filter(ROWNUM<11)
When I add the rowid to the “order by” clause the optimizer no longer sees walking the index as an option for avoiding work; it wants to collect all the rows from the table, sort them, and then report the first 10. In fact walking the index became such an expensive option that I had to hint the index usage (hence the non-null declaration) to make the optimizer choose it, the default plan for 19.3 was a full tablescan and sort.
It’s just a little example of an edge case, of course. It’s a pity that the code doesn’t recognise the rowid as (effectively) a no-op addition to the ordering when the rest of the “order by” clause matches the index declaration, but in those circumstances the rowid needn’t be there at all and you wouldn’t expect anyone to include it.
As I said at the start – the interesting thing about this behaviour is that it was once described in a bug note that has since disappeared from public view.
[AZ-300] Microsoft Azure Architect Training: Step By Step Activity Guides/Hands-On Lab Exercise
The Azure Architect should have advanced experience and knowledge across various aspects of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data management, budgeting, and governance. Check out k21academy’s blog post at https://k21academy.com/az30005 to find out all about our Hands-On Lab exercises that help you prepare for the certification course as well […]
The post [AZ-300] Microsoft Azure Architect Training: Step By Step Activity Guides/Hands-On Lab Exercise appeared first on Oracle Trainings for Apps & Fusion DBA.
Targeting specific namespaces with kubectl
$ eval 'kubectl --namespace='{cf-system,kpack,istio-system}' get pod;'
OR (get all) if you want to see all resources
$ eval 'kubectl --namespace='{cf-system,kpack,istio-system}' get all;'
$ eval 'kubectl --namespace='{cf-system,kpack,istio-system}' get pod;'
NAME READY STATUS RESTARTS AGE
ccdb-migrate-995n7 0/2 Completed 1 3d23h
cf-api-clock-7595b76c78-94trp 2/2 Running 2 3d23h
cf-api-deployment-updater-758f646489-k5498 2/2 Running 2 3d23h
cf-api-kpack-watcher-6fb8f7b4bf-xh2mg 2/2 Running 0 3d23h
cf-api-server-5dc58fb9d-8d2nc 5/5 Running 5 3d23h
cf-api-server-5dc58fb9d-ghwkn 5/5 Running 4 3d23h
cf-api-worker-7fffdbcdc7-fqpnc 2/2 Running 2 3d23h
cfroutesync-75dff99567-kc8qt 2/2 Running 0 3d23h
eirini-5cddc6d89b-57dgc 2/2 Running 0 3d23h
fluentd-4fsp8 2/2 Running 2 3d23h
fluentd-5vfnv 2/2 Running 1 3d23h
fluentd-gq2kr 2/2 Running 2 3d23h
fluentd-hnjgm 2/2 Running 2 3d23h
fluentd-j6d5n 2/2 Running 1 3d23h
fluentd-wbzcj 2/2 Running 2 3d23h
log-cache-7fd48cd767-fj9k8 5/5 Running 5 3d23h
metric-proxy-695797b958-j7tns 2/2 Running 0 3d23h
uaa-67bd4bfb7d-v72v6 2/2 Running 2 3d23h
NAME READY STATUS RESTARTS AGE
kpack-controller-595b8c5fd-x4kgf 1/1 Running 0 3d23h
kpack-webhook-6fdffdf676-g8v9q 1/1 Running 0 3d23h
NAME READY STATUS RESTARTS AGE
istio-citadel-589c85d7dc-677fz 1/1 Running 0 3d23h
istio-galley-6c7b88477-fk9km 2/2 Running 0 3d23h
istio-ingressgateway-25g8s 2/2 Running 0 3d23h
istio-ingressgateway-49txj 2/2 Running 0 3d23h
istio-ingressgateway-9qsqj 2/2 Running 0 3d23h
istio-ingressgateway-dlbcr 2/2 Running 0 3d23h
istio-ingressgateway-jdn42 2/2 Running 0 3d23h
istio-ingressgateway-jnx2m 2/2 Running 0 3d23h
istio-pilot-767fc6d466-8bzt8 2/2 Running 0 3d23h
istio-policy-66f4f99b44-qhw92 2/2 Running 1 3d23h
istio-sidecar-injector-6985796b87-2hvxw 1/1 Running 0 3d23h
istio-telemetry-d6599c76f-ps6xd 2/2 Running 1 3d23h
Custom ROMs: Installing via TWRP (e.g. Prometheus ROM)
- Boot in to recovery (Samsung: Home Button + Power + Volume Up)
- Copy the ROM.zip to the SD card of the smartphone
- and then follow this screenshots
[Solved]Upgrading Oracle Apps (EBS) To 12.2 ? ORA-29283: Invalid File Operation
While running an American English Upgrade patch driver, when upgrading to Oracle EBS R12.2, if you are facing the error: ORA-29283: Invalid File Operation Then check out our post at http://k21academy.com/ebsupgrade14 in which we cover: · ISSUE of the Error while running the American English update patch driver · Root Cause of the Error · […]
The post [Solved]Upgrading Oracle Apps (EBS) To 12.2 ? ORA-29283: Invalid File Operation appeared first on Oracle Trainings for Apps & Fusion DBA.
EBS R12.2 Upgrade High Level Overview/Steps
Oracle has announced on October 18, 2019, they were moving to a Continuous Innovation support model for Oracle E-Business Suite 12.2 and that there will be no 12.3 release. At the Moment Only EBS R12.1.3 & R12.2.3+ Is Supported To know more check out our post at https://k21academy.com/ebsupgrade12 This post covers a high-level overview of […]
The post EBS R12.2 Upgrade High Level Overview/Steps appeared first on Oracle Trainings for Apps & Fusion DBA.
19c Database In Oracle EBS R12: Everything You Must Know
Oracle has recently announced the release of Oracle E-Business Suite 19c Database. With the Database 19c certification, EBS 12.2 on-premises databases are now certified with the CDB architecture (multitenant architecture). Check out K21 Academy post at https://k21academy.com/ebsupgrade11 which covers: • Overview Oracle Database 19c • What’s New for EBS with Oracle Database 19c • R12.x […]
The post 19c Database In Oracle EBS R12: Everything You Must Know appeared first on Oracle Trainings for Apps & Fusion DBA.
ORA-06512 - PL/SQL: numeric or value error%s
[Solved]Upgrade Oracle Apps (EBS) to 12.2 ? ORA-01804: Failure To Initialize Timezone Information – Issue While Running AutoConfig
While running Autoconfig on DB Tier after upgrading the database, if you are facing the error ORA-01804: failure to initialize timezone information. Then check out our post at http://k21academy.com/ebsupgrade13 in which we cover: · Issue While running Autoconfig · Error messages in AutoConfig logs · FIX of the Error Begin your journey towards becoming an Oracle EBS Upgrade R12.2 by […]
The post [Solved]Upgrade Oracle Apps (EBS) to 12.2 ? ORA-01804: Failure To Initialize Timezone Information – Issue While Running AutoConfig appeared first on Oracle Trainings for Apps & Fusion DBA.
Oracle EBS Cloud Manager: New Release (20.1.1) Is Now Available
Oracle has announced the latest release of Oracle EBS for Oracle Cloud Infrastructure i.e 20.1.1. with DB 19c. The main highlight of this new release is its support to Database 19c. To know more about this, check our blog post at https://k21academy.com/ebscloud34, which covers: • EBS Cloud Manager Overview • De-supported Features in Oracle EBS […]
The post Oracle EBS Cloud Manager: New Release (20.1.1) Is Now Available appeared first on Oracle Trainings for Apps & Fusion DBA.
Days since last login
Guidance on table design for batch processing
Bloom filters
OATUG Forum Online (or, the 2020 Version of Collaborate Las Vegas)
Hi everyone!
It’s been a very busy year for me, so I haven’t had much time to blog. But, here we go!
This isn’t a technical post, but more of an opinion piece. I’ve split this post into two parts. Part one was written before I spoke at the OATUG (Oracle Applications and Technology Users Group) Forum online. Part two was written after I spoke.
Part 1: Before…The global pandemic has disrupted virtually everything in our world. The same goes for the world of IT, including one of the best things about our industry: Conferences and live events.
I was supposed to attend two major conferences in the first quarter of 2020. One was cancelled and the other became an online event. Aborting major events like these is no trivial undertaking. Not only for the organizers themselves but also for all the sponsors and attendees (customers and vendors included).
Huge events like Oracle Open World, Google Next, or the one that will be the focus of most of this post, Collaborate, have a long-lasting impact that extends throughout the year. At these events, a casual meeting or a chat during a coffee break can kickstart a relationship. It might develop into a large services agreement, a partnership, or a whole new successful startup.
You have to agree that these events are important, if not crucial, for our industry.
CollaborateAs for Collaborate, well, I was very excited to not only attend but also speak at the event. After attending DOAG, BIWA, and UKOUG the previous years, Collaborate is the next big Oracle-related event in which I’d be participating. Then, of course, came COVID-19.
However, Collaborate isn’t cancelled. Instead, it’s now a fully virtual event. Here I’d like to give a massive KUDOS to the event organizers for their commitment to the event and the attendees. It certainly couldn’t have been easy to make the initial decision to proceed with Collaborate. Nor could it have been easy to completely undo and transform months and months of planning and logistics into a fully virtual conference in a matter of weeks.
I was very pleased to still be selected to speak at the (now) online conference. And, a big thanks to Pythian for their speaker program. It enables me to attend these gatherings, virtual or otherwise.
So, here I am, a few hours prior to my first big online presentation to an unknown number of people, and crossing my fingers that everything works as expected. This is basically how I feel before any “typical” presentation. The main difference? Well, the presentation won’t be quite the same. Interaction with the listening public is close to zero, and there is little practical opportunity for people to reach out to you with questions afterwards.
My Thoughts…I know, I know… there’s always social media, and so on. However, it’s not the same, and you know it. There’s no immediate feedback from the attendees, and you can’t really tell if they find the content interesting or boring. Nor is it easy to tell whether you should slow down, or speed up. It definitely feels more impersonal.
This is my opinion from a “presenter” standpoint. As an “attendee,” there are two major issues for me: One is that it’s no longer a live in-person event, it’s awkward to ask your manager for time to attend it. The second big issue for me is the time zone. I’m in the Eastern time zone, and the event is based in Las Vegas, so sessions can go all the way from 4:30 PM to 10:30 PM EDT. This, on top of my regular eight-hour workday, is simply too much.
So, I might be able to attend a session or two and watch saved sessions at a later time. This takes me back to my previous point about lost face-to-face interactions with people.
Anyway, I’m really interested to see how this plays out. I really hope the event is a big success because, unfortunately, our current “situation” might last a long time. We need to prepare for that possibility.
Part 2: After…And… the event is over. Unfortunately, it wasn’t very satisfactory, which makes me a little sad. You see, Collaborate is one of the biggest Oracle events that I know of with a great many attendees, but only four showed up to my live presentation. Yes, the feedback was very good, and surely those people who attended were very interested in the topic I was speaking about. I thank each and every one of them.
A few days later, I checked my presentation statistics and there were a few views and downloads. But overall, the number is far below the 20 to 50 people that attended this same presentation at other on-site conferences.
Of course, I’m not a renowned speaker and the subject matter might not be of broader interest. However, the online experience is just “not the same,” and that takes a toll on the number of attendees.
Regardless, it was a good overall experience. I give my sincere congratulations to the organizers for the huge effort they clearly put into the entire event.
Hopefully, we can all meet in person soon and enjoy a truly magnificent Collaborate.
Service Level Agreement (SLA) In Oracle Cloud (OCI)
Before deploying an application in Oracle Cloud, a customer may want to know what services will be offered by the Oracle Cloud. For this, an Agreement has been done between provider and customer called SLA. To know more about this check our blog post at https://k21academy.com/1z0108514, which covers: • Overview of SLA in Oracle Cloud […]
The post Service Level Agreement (SLA) In Oracle Cloud (OCI) appeared first on Oracle Trainings for Apps & Fusion DBA.
Pages
