Feed aggregator

please help understanding this MERGE JOIN CARTESIAN

Tom Kyte - Wed, 2018-02-07 21:26
Hi Gurus, I have below query and exec plan. all tables E-rows are correct. as you can see table ACCT_STAT join to table ACCT and ACCT_DTL, but in plan, looks like MERGE JOIN CARTESIAN happened between table ACCT_STAT and ACCT_TYP table. Do I misunde...
Categories: DBA Blogs

Development DBA certificate

Tom Kyte - Wed, 2018-02-07 21:26
Hi Team, I am working as Development DBA and PLSQL developer. I wanted to complete Certificate in development DBA. didnt find any development certificate in Oracle website. Could you please advise which certificate is suitable for Oracle develo...
Categories: DBA Blogs

Help understanding SQL exec plan

Tom Kyte - Wed, 2018-02-07 21:26
Hi Gurus, I have a query it runs really long. after adding hint use_hash, it runs less than one minutes. data in table: det ---239968 bal -- -239968 inst -- 244713 PT_INST --168745 the query as below: below 3 plans are 1, using hash hint, t...
Categories: DBA Blogs

How do I Refresh a Region or Report after a Dialog is Closed?

Joel Kallman - Wed, 2018-02-07 20:57
I was going to write this blog post back in December 2017, as this question comes up frequently.  And even though there are numerous examples available in the Sample Database Application and other sample applications, and it's even in the documentation, the solution still isn't always readily apparent.

I received this question from an internal employee today:
"When I edit the page and update the row and save and close the modal page, existing report doesn't refresh the page with revised value.   It was working on another page, but not working on this new page (I built last week).  Couldn't find a way to refresh it as soon as I close the modal window with saved data."He has a report and a form in his application, and the form opens up in a modal dialog.  He simply wants the report on the parent page to refresh after the modal dialog is closed.  Simple, right?

For anyone well-versed in APEX, you'll find this blog post superfluous.  But for everyone else who is looking for the quick explanation, as I've received this question 3 times in the past couple months, here it is.

  1. On the report page, create a new Dynamic Action and enter the following attributes:
    • Name: <provide a meaningful name>
    • Event: Dialog Closed
    • Selection Type: Region
    • Region:<choose your report region>

  2. Select the True action of the Dynamic Action and enter the following attributes:
    • Action: Refresh
    • Selection Type: Region
    • Region: <choose your report region>

That's really all there is to it.  If you have multiple regions on the parent page, you could add multiple True actions for the dynamic action.  If the triggering event of the modal dialog is a button instead of a region, you could specify that as your Selection Type for the triggering event.  If there are multiple regions on the page which could open the modal dialog, you could even use a jQuery Selector and reference multiple elements as your Selection Type for the triggering event. 

For example, if you're converting a non-modal form and report to use a modal form, and you wish to refresh the report after the modal dialog is closed (after creating a new record), you'll need to associate the triggering event with the button.  The steps would be:
  1. On the report page, create a new Dynamic Action and enter the following attributes:
    • Name: <provide a meaningful name>
    • Event: Dialog Closed
    • Selection Type: Button
    • Region:<choose your button, for example, your Create button>

  2. Select the True action of the Dynamic Action and enter the following attributes:
    • Action: Refresh
    • Selection Type: Region
    • Region: <choose your report region>

You should get this behavior out of the box when creating an application with a report and form, or adding a report and form to your application.  But if you're manually adding components, then it's really quite easy and straightforward to add this functionality to your APEX app.

If you install the Sample Database Application, you'll find numerous examples of this dynamic action refresh operation after the close of a modal dialog.  And it is briefly documented in this tip.

Some things I think about politics

DBMS2 - Wed, 2018-02-07 20:04

When one tries to think comprehensively about politics these days, it quickly gets overwhelming. But I think I’ve got some pieces of the puzzle figured out. Here they are in extremely summarized form. I’ll flesh them out later as seems to make sense.

1. Most of what people are saying about modern tribalism is correct. But partisanship is not as absolute as some fear. In particular:

2. The threat from Trump and his Republican enablers is indeed as bad as people fear. He’s a major danger to do terrible, irreversible harm to the US and the rest of the world. To date the irreversible damage hasn’t been all that terrible, but if Trump and his enablers are given enough time, the oldest modern democracy will be no more.

All common interests notwithstanding, beating Trump’s supporters at the polls is of paramount importance.

3. I agree with those who claim that many of our problems stem from the shredding of trust. But few people seem to realize just how many different aspects of “trust” there are, nor how many degrees there can be of trustworthiness. It’s not just a binary choice between “honest servant of the people” and “lying, cheating crook”.

These observations have strong analogies in IT. What does it mean for a system to be “reliable” or to produce “accurate” results? There are many possible answers, each reasonable in different contexts.

4. I also agree with the view that much of what’s going on relates to lacks of empathy. But it’s not quite as simple as saying that liberals/Democrats/globalists have more empathy, while conservatives/Republicans/populists/nationalists have less. Populists and white nationalists likely have more empathy than I do for certain segments of the population, and anti-abortion zealots surely outshine me in empathy for fetal tissue.

Some say our troubles are due to a deliberate war on truth and democracy. Some say they’re just consequences of broad, long-running trends. I think both views are partially correct.

I’ll make a short post on that point soon, and slightly edit this one accordingly when I do.

5. Much is made these days of people’s penchant for irrationality, which generally takes the forms:

  • Irrational choices as to which factual claims to accept.
  • Irrational conclusions in light of their chosen “facts”.

I think that a lot of this irrationality can be explained as people not taking the trouble to gain all the facts, to think things through, etc. Indeed, perfect rationality takes so much effort that it would be … well, that it would be a highly irrational choice. So if we want people to be more rational, perhaps we should make it easier for them to be so.

That challenge has many different facets. I hope to have something useful to say about it later on.

6. Outright changing somebody’s mind is very, very hard. But making them less sure of their opinion? That’s a lot easier. Making them more sure of it? That’s a reasonable goal as well

This too will be spelled out in a future post.

7. Much of the prevailing irrationality can be modeled by describing which contradictions/doublethink people accept, and in which cases they think a contradiction actually proves that something is untrue. And people’s views are sometimes actually influenced by a pull to be more consistent. Real-life examples include:

  • Some traditionally “law and order”/authority-following right-wingers who believe the current allegations about the “Deep State” are more open to doubting FBI claims in general.
  • Similarly, the recent FISA legislation needed bipartisan support to pass, because some generally government-skeptical Republicans were in particular skeptical of the alleged national-security reasons for domestic snooping.
  • States-rights supporters (who usually are conservatives) can extend that to disapproving of Federal marijuana laws and crackdowns.
Categories: Other

Politics can be overwhelming

DBMS2 - Wed, 2018-02-07 20:03

Like many people, I’ve been shocked and saddened by recent political developments. What I’ve done about it includes (but is not limited to):

  • Vented, ranted and so on. That’s somewhat therapeutic, and also let me engage the other side and try to understand a little better how they think.
  • Tried to understand what’s happening. I probably have had more available time to do that than most people. I also have a variety of relevant experiences to bring to bear.
  • Neglected my work somewhat while doing all that. This neglect has now stopped. After all, the future is quite uncertain, so we should probably work hard in the present while business is still good.
  • Written up some of what I’ve figured out. Of course. That’s what I do. But it’s only “some”, because … well, the entirety of politics is overwhelming.
  • Tried to find specific, actionable ways to help. Stay tuned for more on that part.

As for those writings:

  • I just posted a very high-level overview of modern political complexities. Please read it.
  • I’m working on posts drilling down on various parts of that. Closest to readiness are ones on “Modifying beliefs” (which will include some technology marketing advice) and “The war on truth and democracy” (which will argue that part — and only part — of what’s going on is properly described by the “war” metaphor).
  • I recently posted that the tech industry is under broad political attack. That’s even more true than I realized. Two recent and indicative developments are:
    • Roger McNamee et al. have started an organization to combat the addictive evils they perceive the tech/internet industry as doing.
    • George Soros — whose organization was once my best-paying investment client — thundered at Davos that the tech/internet industry should and will be brought down by antitrust regulators.
  • I also posted recently about the chaotic politics of privacy. If anything, the ongoing FBI/FISA firestorm suggests that I understated the matter.
Categories: Other

12cR2 PDB archive

Yann Neuhaus - Wed, 2018-02-07 13:50

In 12.1 we had the possibility to unplug a PDB by closing it and generating a .xml file that describes the PDB metadata required to plug the datafiles into another CDB.
In 12.2 we got an additional possibility to have this .xml file zipped together with the datafiles, for an easy transport. But that was not working for ASM files.
The latest Release Update, Oct 17 includes the patch that fixes this issue and is the occasion to show PDB archive.

Here is Oracle with Oct 2017 (https://updates.oracle.com/download/26737266.html) applied (needs latest OPatch https://updates.oracle.com/download/6880880.html)
With a PDB1 pluggable database:

[oracle@VM106 ~]$ rman target /
Recovery Manager: Release - Production on Wed Oct 18 16:16:41 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=920040307)
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CDB1
List of Permanent Datafiles
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 810 SYSTEM YES /acfs/oradata/CDB1/datafile/o1_mf_system_dmrbv534_.dbf
3 540 SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrbxvds_.dbf
4 70 UNDOTBS1 YES /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrbz8mm_.dbf
5 250 PDB$SEED:SYSTEM NO /acfs/oradata/CDB1/datafile/o1_mf_system_dmrc52tm_.dbf
6 330 PDB$SEED:SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrc52t9_.dbf
7 5 USERS NO /acfs/oradata/CDB1/datafile/o1_mf_users_dygrpz79_.dbf
8 100 PDB$SEED:UNDOTBS1 NO /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrc52x0_.dbf
21 250 PDB1:SYSTEM YES /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_system_dygrqqq2_.dbf
22 350 PDB1:SYSAUX NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_sysaux_dygrqqs8_.dbf
23 100 PDB1:UNDOTBS1 YES +ASM1/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/DATAFILE/undotbs1.257.957719779
List of Temporary Files
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 33 TEMP 32767 /acfs/oradata/CDB1/datafile/o1_mf_temp_dmrc4wlh_.tmp
2 64 PDB$SEED:TEMP 32767 /acfs/oradata/CDB1/pdbseed/temp012017-06-10_19-17-38-745-PM.dbf
3 64 PDB1:TEMP 32767 /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_temp_dygrqqsh_.dbf

I have moved one file to ASM to show that it is now handled correctly.

The pluggable database is closed, we can unplug it. Nothing changes with the unplug syntax except the extension of the file. If the file mentioned is a .pdb instead of a .xml then it is a PDB archive:

RMAN> alter pluggable database PDB1 unplug into '/var/tmp/PDB1.pdb';
RMAN> alter pluggable database PDB1 close;
Statement processed
RMAN> alter pluggable database PDB1 unplug into '/var/tmp/PDB1.pdb'
2> ;
Statement processed
RMAN> exit

Actually it is just a zip file with the datafiles, without the full path:

[oracle@VM106 ~]$ unzip -t /var/tmp/PDB1.pdb
Archive: /var/tmp/PDB1.pdb
testing: o1_mf_system_dygrqqq2_.dbf OK
testing: o1_mf_sysaux_dygrqqs8_.dbf OK
testing: undotbs1.257.957719779 OK
testing: /var/tmp/PDB1.xml OK
No errors detected in compressed data of /var/tmp/PDB1.pdb.

You can see that the ASM file is not different from the others.

I drop the pluggable database

RMAN> drop pluggable database PDB1 including datafiles;
using target database control file instead of recovery catalog
Statement processed

And plug back the PDB1, as PDB2, using the zip file:

RMAN> create pluggable database PDB2 using '/var/tmp/PDB1.pdb';
Statement processed
RMAN> report schema;
Report of database schema for database with db_unique_name CDB1
List of Permanent Datafiles
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 810 SYSTEM YES /acfs/oradata/CDB1/datafile/o1_mf_system_dmrbv534_.dbf
3 540 SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrbxvds_.dbf
4 70 UNDOTBS1 YES /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrbz8mm_.dbf
5 250 PDB$SEED:SYSTEM NO /acfs/oradata/CDB1/datafile/o1_mf_system_dmrc52tm_.dbf
6 330 PDB$SEED:SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrc52t9_.dbf
7 5 USERS NO /acfs/oradata/CDB1/datafile/o1_mf_users_dygrpz79_.dbf
8 100 PDB$SEED:UNDOTBS1 NO /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrc52x0_.dbf
24 250 PDB2:SYSTEM NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_system_dygwt1lh_.dbf
25 350 PDB2:SYSAUX NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_sysaux_dygwt1lm_.dbf
26 100 PDB2:UNDOTBS1 NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_undotbs1_dygwt1lo_.dbf
List of Temporary Files
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 33 TEMP 32767 /acfs/oradata/CDB1/datafile/o1_mf_temp_dmrc4wlh_.tmp
2 64 PDB$SEED:TEMP 32767 /acfs/oradata/CDB1/pdbseed/temp012017-06-10_19-17-38-745-PM.dbf
4 64 PDB2:TEMP 32767 /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_temp_dygwt1lp_.dbf

Here all files are there, created in the db_create_file_dest.

File name convert

When you create a pluggable database and you are not in OMF you need to add a FILE_NAME_CONVERT to convert from the source file names to destination file names. When the files are referenced by a .xml file, the .xml file references the path to the files as they were in the source database. If you move then, you can update the .xml file, or you can use SOURCE_FILE_NAME_CONVERT to mention the new place. With a .pdb archive, the .xml inside contains the original path, but this is not what will be used. The path of the .pdb itself is used, as if the files were unzipped at that place.

If you use Oracle-Managed-Files, don’t care about the file names and then you don’t need all those file name converts.


Cet article 12cR2 PDB archive est apparu en premier sur Blog dbi services.

Using a BareMetal GPU shape in Oracle Cloud Infrastructure with Oracle Linux 7 and TensorFlow

Wim Coekaerts - Wed, 2018-02-07 13:32

A lot of developers are using TensorFlow for Machine Learning these days. In Oracle Cloud Infrastructure we provide some great GPU options. One of them is the BM.GPU2.2 shape which is an X7-based GPU system (contains 2 P100 Nvidia GPUs).

When you create an OCI instance using this shape with Oracle Linux 7, it comes pre-installed with the kernel modules to enable the GPUs. Ready to use.

Getting TensorFlow installed is very easy:

Install some prerequisite RPMs, some come from the EPEL yum repo which we provide as part of Oracle Linux and is enabled by default in your yum.repos file.

# sudo yum -y install python-pip python-devel atlas atlas-devel gcc-gfortran openssl-devel libffi-devel

# sudo pip install --upgrade virtualenv

# virtualenv --system-site-packages ~/venvs/tensorflow

# source ~/venvs/tensorflow/bin/activate

Now you can install TensorFlow using pip. use tensorflow-gpu if you want the GPU enabled version otherwise just use tensorflow.

(tensorflow) # pip install --upgrade tensorflow-gpu


(tensorflow) # pip install --upgrade tensorflow

To use tensorflow-gpu you have to install the Nvidia CUDA packages. This version of tensorflow depends on version 9.0

(tensorflow) # sudo yum -y install cuda-9-0

Run a TF example:

(tensorflow) #  pip install pandas

(tensorflow) # sudo yum -y install git

(tensorflow) # mkdir git

(tensorflow) # cd git

(tensorflow) # git clone https://github.com/tensorflow/models

(tensorflow) # cd models/samples/core/get_started/

(tensorflow) # python premade_estimator.py

and that's it. Super easy without any manual downloads.

this is a test

Talking about Microservices: A journey to Docker / Snap / CoreOS / Unbuntu Core / Docker-Swarm

Dietrich Schroff - Wed, 2018-02-07 13:11
A few months ago (13th august 2017) i started my personal journey into this new hype called microservices:

I thought the best way for me to get in touch was to begin with CoreOS. Within 2 weeks i got some first impressions:

But after these steps i realized, that next step on this road is kubernetes. It is clear that cluster scheduler like kubernetes can not be run on a single machine - so i tried to get another access to microservices: Snap and UbuntuCore:
In november 2017 it was clear, that both UbuntuCore and CoreOS are some building blocks for microservices, but i was not really on the right track.
Back to kubernetes? Kubernetes relies on containers. So i started with docker:
Nearly 3 months later i still did not get in touch with kubernetes - but i think docker swarm is a cluster scheduler, too. And it is really easy to run.

What will i do next? Some tests to failure/failover/failback scenarios. 

    6 Ways Automated Security Becomes A Developer’s Ally

    OTN TechBlog - Wed, 2018-02-07 09:46

    In a recent InfoWorld article, Siddhartha Agarwal, VP of Product Management at Oracle, outlined his top 10 predictions impacting application developers in 2018. In this blog, we’ll take a closer look at one of those predictions and how a cloud access security broker (CASB) service can help with it.

    #10. Highly automated security and compliance efforts become a new ally of developers

    Companies are increasingly adopting DevOps methodologies to accelerate their app development lifecycles in the cloud. Unfortunately, the common perception is that accelerating application lifecycles comes at the expense of security. That’s because, traditionally, security used to be a discrete step in application development lifecycles, taking weeks or months to certify an application for production use. There is no way such a delay can be incorporated into an agile CI/CD methodology. Security needs to be a continuous process linked to every step of DevOps.

    Fortunately, artificial intelligence and machine learning have matured to the point that they can be used to automate much of application security. Developers can ensure that their applications and data are continuously monitored using a CASB service, and any threats, compliance violations, or security incidents are automatically detected and remediated. This lets app developers maintain their development velocity, while conforming to security and compliance standards. Let’s look at some key areas that can be protected with continuous visibility and monitoring with Oracle CASB. 

    1. Enforcing Strong Application Configuration and Micro Segmentation

    CASB can monitor application configurations to detect any changes and revert those automatically to the “golden” configuration, as well as alert relevant administrators. This enforcement may include configurations for network segmentation, DNS resolution, usage of secure or insecure network ports, and encryption settings for folders containing application data.

    2. Enforcing Strong Access Control for Administrators

    CASB can continuously monitor and enforce strong access control policies for administrators, including multi-factor authentication, strong password policies, and SSH key rotation. Any changes to these can be reverted automatically and alerted to relevant administrators.

    3. Monitoring Admin Activity for Out-of-the-Ordinary Patterns

    CASB uses machine learning to automatically learn “normal” or regular patterns of administrative activity, such as the login/logout times of administrators, locations/IP addresses where they typically login from, and types of changes they usually perform to the application. It can then send an alert on any deviations from these normal patterns, such as an admin logging in from a location, IP address, or device type that they’ve never used before. In addition, customers can also configure CASB to look for admin changes to specific areas, such as lists of authorized users or groups, starting or stopping of app instances, or changes to encryption settings of folders. For example, if an infiltrator attempts to use valuable compute or storage resources for malicious usage, CASB will immediately raise an alert.

    4. Enforcing Data Security and Compliance
    CASB can continuously scan application data to detect any files that violate the company’s compliance policy. For example, it can be configured to look for sensitive or confidential information, such as credit card or Social Security numbers. If found, CASB can automatically alert administrators and take remedial action that prevent unauthorized access of the data.

    5. Monitoring User Activity for Out-of-the-Ordinary Patterns

    CASB uses machine learning to automatically detect unauthorized or malicious insider usage of the application. Similar to monitoring administrator activity, CASB uses machine learning to automatically learn normal patterns of regular user activity. Any deviations from these, such as users logging in from a location that they’ve never logged in from before, can automatically be alerted as being suspicious. On detecting suspicious activity, application access for the user can automatically be downgraded to prevent downloads, as an example, until the user has been able to prove their identity with further authentication.

    6. Monitoring for Misuse of Escalated Privileges

    Often times, developers gain access to production resources for troubleshooting purposes such as debugging, bug fixing, or other maintenance purposes. In many cases, those privileges are never revoked, thereby leaving those resources fully accessible by those developers even after those issues are resolved. CASB can help monitor resources in production so that any access or modifications is alerted to respective administrators, who can then respond accordingly. CASB can also help prevent or revert changes to the original state, thereby preventing unauthorized changes to production resources by such users.

    Oracle CASB offers all of the capabilities listed above, and it can also be integrated with other enterprise systems, such as SIEM, Identity-as-a-Service (IDaaS), or IT Service Management applications. This ensures that companies can tightly integrate CASB into their existing Security Operations Center (SOC) workflows and enable CASB to raise tickets automatically for remediation.

    Platform choice matters

    Oracle has spent the last several years building and assembling the set of security and management services in the Oracle Cloud that together enable customers to build the Identity-centric Security Operations Center (Identity SOC). The Identity SOC platform leverages purpose-built machine learning against the full breadth of operational and security telemetry — including activity and configuration information as well as identity and asset context — to provide real-time threat detection across heterogeneous, hybrid cloud environments.  When potential or active threats are detected, automated remediation can be invoked to eliminate those threats.


    Oracle Hospitality Sponsored Research Explores the State of the Central Reservation System Globally

    Oracle Press Releases - Wed, 2018-02-07 08:00
    Press Release
    Oracle Hospitality Sponsored Research Explores the State of the Central Reservation System Globally h2c Report “The Next Generation Central Reservation System” Audits 90 Chains Across Europe, The Middle East and Africa, the Americas and Asia Pacific

    Redwood Shores, Calif.—Feb 7, 2018

    Oracle Hospitality announced today the findings of a global research study – conducted by analyst firm h2c ­­– surveying more than 90 hotel chains to assess the state of central reservation systems (CRS) and the improvements needed to prioritize IT development and, ultimately, enhance guest service.

    Commissioned by Oracle Hospitality, h2c’s research scope focused on an online survey and expert interviews with hotel chains in Europe, the Middle East and Africa, the Americas and Asia Pacific – representing more than 11,000 properties and 1.7 million rooms worldwide. The primary objectives: determine chains’ satisfaction level with their current CRS solution, identify missing features and functionalities, and seek recommendations to achieve improvements.

    “Today’s guests increasingly demand a hassle-free journey. The findings of the h2c report clearly indicate that the hotel industry is challenged to meet such expectations,” said Laura Calin, vice president strategy and solutions management, Oracle Hospitality. “At Oracle, we’re working diligently with our customers to simplify and integrate solutions, making it easier to leverage technology to attract new guests and win the loyalty of existing ones.”

    Among the most significant findings: dissatisfaction with CRS is common among hotel operators, with one third of respondents reporting they are missing more than 30% of required functionality. Furthermore, half of all chains reported missing at least one key CRS functionality.

    Although respondents readily cited their CRS deficiencies, many struggled to identify means to remedy shortcomings. Such issues underscore the need for technology providers/CRS vendors to collaborate with clients to truly understand problems before driving innovation with new features.

    Based on the findings, h2c forecasts that PMS and CRS solutions will continue to merge in the future, either in the form of hybrid solutions or as entirely new hotel management platforms.

    The following are some of the key highlights from The Next Generation Central Reservation System – Implications for Future CRS Developments:

    • Customer Relationship Management (CRM) poses the largest demand for CRS integration. Small and medium-sized hotel groups, with or without full-fledged loyalty programs, are under intense pressure to improve their guest experience to better compete with the personalization capabilities of global chains. CRS integration is minimal and even non-existent in some regions, making it a critical priority for CRS vendors to address – either with a proprietary product or a third-party integration.

    • Internet booking engine (IBE) reservations are the greatest value driver, but underperforming. Though hotel chains are changing their online sales policy (including price disparity and/or offering free benefits) to compete against OTAs, the IBE needs to facilitate more sophisticated business rules. Such trends are mandating a reinvention of the IBE, which would enable more e-commerce functionality such as discounting packages.

    • Future distribution management tasks will shift to non-CRS systems. From the hoteliers’ perspective, some key CRS tasks such as availability and rates (ARI) management, will likely migrate to other systems in their IT portfolio or become part of a still-to-be-developed platform solution.

    A full copy of the report can be found here.

    Oracle will convene a global community of hospitality leadership at Oracle Industry Connect April 10-11, 2018 in New York, NY. Oracle Industry Connect provides attendees with intimate peer networking opportunities in addition to over 30 customer-led presentations with themes including how to move to the cloud to accelerate innovation and reduce IT complexity, mine data to gain insights and competitive advantages and capitalize on mobility to empower staff and serve guests. To learn more about Oracle Industry Connect 2018 and register to attend visit: www.oracle.com/oracleindustryconnect/

    Contact Info
    Matt Torres
    About Oracle

    The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.


    Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

    About Oracle Hospitality

    Oracle Hospitality brings 35 years of experience in providing technology solutions to food and beverage operators. We provide hardware, software, and services that allow our customers to deliver exceptional guest experiences while maximizing profitability. Our solutions include integrated point-of-sale, loyalty, reporting and analytics, inventory and labor management, all delivered from the cloud to lower IT cost and maximize business agility.

    For more information about Oracle Hospitality, please visit www.Oracle.com/Hospitality

    About h2c

    h2c’s services to the hospitality industry are unbiased and customer-focused. H2c’s clients benefit from B2B research, Content Marketing services, hospitality technology RFPs and CONTtest, a channel manager for static hotel content.

    Our Mission: H2c inspires success in hospitality commerce. Our passion to translate marketplace complexities into actionable strategies shapes our relationships. The goal: clients are confidently in control.” For more information, please visit our website.

    Talk to a Press Contact

    Matt Torres

    • 4155951584

    Oracle JET Composite Components - Manual for JET Coder

    Andrejus Baranovski - Wed, 2018-02-07 07:20
    JET Composite Components - are useful not only to build UI widgets, but also to group and simplify JET code. In this post, I will show how to wrap JET table into composite component and use all essential features, such as properties, methods, events and slots.

    Sample app code is available on GitHub. JET table is wrapped into composite component, it comes with slot for toolbar buttons:

    What is the benefit to wrap such components as JET table into your own composite? To name a few:

    1. Code encapsulation. Complex functionality, which requires multiple lines of HTML and JS code resides in the composite component
    2. Maintenance and migration. It is easier to fix JET specific changes in single place
    3. Faster development. There is less steps to repeat and less code to write for developer, when using shorter definition of the wrapper composite component

    Sample application implements table-redsam component, for the table UI you can see above. Here is component usage example, very short and clean:

    All the properties specific to given table are initialised in the module. Developer should provide REST endpoint, key values, pagination size and column structure. The rest is happening in the composite component and is hidden from the developer, who wants to implement a table:


    We should take a look into array type property. Such property allows to pass array into component. This can be useful either to pass array of data to be displayed or array of metadata to help with component rendering. In our case we pass array of metadata, which helps to render table columns. Array type property is based on two attributes - Header Text and Field. Properties are defined in composite component JSON file:

    Properties are retrieved from variable inside component and are assigned to local variables:

    This is table implementation inside component, columns are initialised from component property:


    Slot defines a placeholder, where developer who is using composite component can add additional elements. Slot is defined in component JSON definition file:

    To define slot, JET slot component should be defined inside composite. You can control layout and location where slot will be rendered:

    In our case, we use slot for table toolbar buttons. These buttons are added later, when developer is using composite. To place button into slot, put button inside composite component tag and assign defined slot name for the button. This will allow to render button in the slot:


    Method defined in composite component, can be called from outside. In example below, I call JS function from toolbar slot button:

    Function gets composite by ID and calls exposed method:

    Method should be defined in composite JSON definition:

    Method is implemented inside composite JS module:


    Events allows to implement external listeners. Basically this allows to override composite logic in external functions. Event is declared in composite JSON definition:

    Composite tag contains event property mapped with external JS function, which will be called when event happens inside composite:

    Function code in the module, it prints current row selection key:

    Table is defined with listener property inside composite:

    Listener inside composite initiates event, which will be distributed outside and handled by method defined in composite tag on-handle-selection property:

    Let's see how it works. Call Method button invokes method inside composite:

    Table row selection first triggers listener inside composite, then it initiates event and external listener is invoked too:

    I think this lists pretty much all of the essential functionality given by JET composite components. I hope you will find it useful in your development.

    discovering when plans change

    Tom Kyte - Wed, 2018-02-07 03:26
    hi , in my environment i found some of query plans often gets changed, i used 10053 to figure out for plan change , but which part to check and how to conclude what is causing plan change that i am not able to figure out can you please help h...
    Categories: DBA Blogs

    difference between Cardinality feedback and dynamic sampling

    Tom Kyte - Wed, 2018-02-07 03:26
    hi Team, i want to know difference between Cardinality feedback and dynamic sampling . additionally cardinality feedback is provides more near by accurate estimation of cardinality on basis of new plan is generated and used in next execution...
    Categories: DBA Blogs

    Debugging a PLSQL application

    Tom Kyte - Wed, 2018-02-07 03:26
    Help me bro..plaes...i didnt understand this requirement an exactly.... This code is located in the Account_Servicing_Fact_Load SSIS package. The final container contains the code components needed to run both aggregation data. You will have...
    Categories: DBA Blogs

    Range Partition on Virtual column - CTAS.. syntax is not working

    Tom Kyte - Wed, 2018-02-07 03:26
    Hi Tom, I have a requirement to create a range partition for an existing table. Lets say the table name is Orders. The table has Order_Date column of timestamp datatype and the data is in UTC timezone. [We get the data in UTC format in a ...
    Categories: DBA Blogs

    how can alter table

    Tom Kyte - Wed, 2018-02-07 03:26
    Can we add a new column between two columns.If yes,please tell me command
    Categories: DBA Blogs

    SELECT with WITH Clause(subfactoring) and ORA-4031 errors.

    Tom Kyte - Wed, 2018-02-07 03:26
    Tom, I want to validate following reasons to keep away from using "WITH CLAUSE" in the select statement: a) Each time the WITH query clause is run, a global temporary table is created and used in the query. Even if the SQL is using bind variabl...
    Categories: DBA Blogs

    PHP and Oracle DB: RPMs for Easy Install on Linux

    Christopher Jones - Tue, 2018-02-06 22:05

    The Oracle Linux team is now making updated PHP RPMs available on yum.oracle.com.  The good news: an RPM for the PHP OCI8 extension is included.  Yay!  My colleague, Sergio, has a blog post Connect PHP 7.2 to Oracle Database 12c using Oracle Linux Yum Server with the details.

    JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU

    Yann Neuhaus - Tue, 2018-02-06 15:32

    If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for only the PSU is displayed and not the Proactive Bundle Patch, which is highly recommended. And across releases, the names have changed and can be misleading: PSU for (no Proactive Bundle Patch except for Engineered Systems). can have SPU, PSU, or Proactive BP but the latest is highly recommended, especially now that it includes the adaptive statistics patches. introduce the new RUR and RU, the latest one being the one recommended.

    To get things clear, there’s also the Master Note for Database Proactive Patch Program, with reference to one note per release. This blog post is my master note to link directly to the recommended updates for Oracle Database.

    Master Note for Database Proactive Patch Program (Doc ID 756671.1)
    https://support.oracle.com/epmos/faces/DocContentDisplay?id=756671.1 – PSU

    Database Proactive Patch Information (Doc ID 2285559.1)
    Paragraph -> Database Patch Set Update

    Latest as of Q1 2018 -> 16-Jan-2018 (Jan 2018) Database Patch Set Update (DB PSU) 26925576 (Windows: 26925576)  – ProactiveBP

    Database Proactive Patch Information (Doc ID 2285558.1)
    Paragraph -> Database Proactive Bundle Patches (DBBP)

    Latest as of Q1 2018 -> 16-Jan-2018 Database Proactive Bundle Patch (Jan 2018) 27010930 – RU

    Database Proactive Patch Information (Doc ID 2285557.1)
    Paragraph -> Database Release Update (Update)

    Latest as of Q1 2018 -> 16-Jan-2018 (Jan 2018) Database Release Update 27105253 (Windows: WIN DB BP 27162931)

    Don’t forget SQL Developer

    In the 12c Oracle Home SQL Developer is installed, but you should update it to the latest version.
    Download the following from http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
    – The SQL Developer zip for ‘Other Platforms’, currently 17.4
    – The SQLcl zip for ‘All Platforms’, currently 17.4

    On the server, remove, or rename the original directory:
    mv $ORACLE_HOME/sqldeveloper $ORACLE_HOME/sqldeveloper.orig

    Unzip what you have downloaded:
    unzip -d $ORACLE_HOME/ sqldeveloper-*-no-jre.zip
    unzip -d $ORACLE_HOME/sqldeveloper sqlcl-*-no-jre.zip

    I suggest to have a login.sql which sets the beautiful ansiconsole for SQLcl:

    echo "set sqlformat ansiconsole" > $ORACLE_HOME/sqldeveloper/sqlcl/login.sql

    On 12.2 you can run SQLcl just with ‘sql’ (and same arguments as sqlplus: / as sysdba or /nolog,…) because this is what is defined in $ORACLE_HOME/bin.
    However, it sets the current working directory and i prefer to keep the current one as it is probably were I want to run scripts from.

    Then I add the following aliases in .bashrc

    alias sqlcl='JAVA_HOME=$ORACLE_HOME/jdk SQLPATH=$ORACLE_HOME/sqldeveloper/sqlcl bash $ORACLE_HOME/sqldeveloper/sqlcl/bin/sql'
    alias sqldev='$ORACLE_HOME/sqldeveloper/sqldeveloper.sh'

    When running SQL Developer for the first time you can create automatically a ‘/ as sysdba’ connection (but remember this is not a good practice to connect like this) and a connection for each user declared in the database: Right click on Connections and Create Local Connections


    Cet article JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU est apparu en premier sur Blog dbi services.


    Subscribe to Oracle FAQ aggregator