Feed aggregator

Cablenet Selects Oracle Communications to Modernize Infrastructure

Oracle Press Releases - Tue, 2017-02-14 21:14
Press Release
Cablenet Selects Oracle Communications to Modernize Infrastructure Cablenet will deploy Oracle Communications’ full suite of IMS and VoLTE capabilities to dramatically simplify network design, deployment and operations

Redwood Shores, Calif.—Feb 15, 2017

Cablenet Communications Systems, an alternative telecommunications provider that offers broadband services, fixed telephony and television, will use Oracle Communications technologies to modernize and future-proof its IMS network with Oracle Communications Unified Session Manager (OCUSM) and Oracle Communications Evolved Communications Application Server (OCECAS). OCUSM’s next-generation converged core supports a variety of value-added services, such as a virtualized NFV-capable network architecture. With Oracle, Cablenet will be able to improve service agility, accelerate time-to-market and streamline ongoing operations to gain a competitive advantage and boost business results.

“Oracle’s NFV-ready IMS solution will provide Cablenet true service agility with out-of-the-box service creation for VoLTE and VoWiFi,” explains Yiannos Michaelides, Management Information Systems Manager for Cablenet. “Our Oracle solutions will reduce our OPEX significantly and provide an excellent return on investment.”

Oracle Communications Unified Session Manager will provide Cablenet with a complete set of standard-compliant 3GPP IMS functions and interfaces in a single solution. As such, Cablenet will be able to accelerate its IMS rollout and converge its disparate fixed and mobile access networks, laying the foundation for advanced services that span devices and locations. The NFV-capable solution will also allow Cablenet to minimize upfront investments while closely aligning ongoing capital expenditures with evolving business demands.

In tandem, Oracle Communications Evolved Communications Application Server will enable Cablenet to accelerate its VoLTE rollout and will simplify the implementation of future services like VoWiFi and VoLTE. OCECAS simplifies application lifecycle management and provides carrier-grade performance and reliability for revenue-critical services.

“In today’s increasingly competitive marketplace, our customers are constantly seeking solutions that will help improve their agility, streamline operations and accelerate time-to-market,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “Oracle NFV enabled IMS solutions provide simplicity in design and operation, enabling a low cost of ownership and a faster and easier rollout of services such as VoLTE and VoWiFi. We’re pleased that Cablenet will be able to enjoy such positive return-on-investment with our OCUSM and OCECAS solutions.”

Contact Info
Katie Barron
Oracle
+1 202-904-1138
katie.barron@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Katie Barron

  • +1 202-904-1138

Kristin Reeves

  • +1.415.856.5145

Log Buffer #504: A Carnival of the Vanities for DBAs

Pythian Group - Tue, 2017-02-14 19:15

This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.

Oracle:

Data Pump or Data Pain Part02 – tablespace/user

Monday Spotlight: It’s About Security – Oracle Exadata SL6

0001_specify_date_format_mask.md copy

OGG Custom Adapters: How to include a unique identifier for every record in custom adapter?

One of the optimizer enhancements that appeared in 12.2 for SQL is the “band join” that makes certain types of merge join much more efficient.

Microsoft SQL Server:

How to import data to Azure SQL Data Warehouse using SSIS

Using Index-Organized Tables in Oracle

Query Performance Tuning – A Methodical Approach

SQL Server Temporal Tables: How-To Recipes

Fix Commvault Backup Failures After an Upgrade

MySQL:

MySQL may return results in non-deterministic order with ‘order by’

Shinguz: MySQL and MariaDB authentication against pam_unix

MySQL in the Cloud – Pros and Cons of Amazon RDS

With 500+ VividCortex Users, Shopify Eliminates High Latency Queries From Redis and MySQL

An Introduction to MariaDB’s Data at Rest Encryption (DARE)

Categories: DBA Blogs

node-oracledb Session at DeveloperWeek, San Francisco 2017

Christopher Jones - Tue, 2017-02-14 17:54

I just finished my session on node-oracledb at DeveloperWeek on Pier 27 in sunny, fantastic San Francisco. I'm in my old neighborhood, enjoying a familar view of the Bay Bridge from the speaker room window. There is a big hum around me from sessions and demo booths as developers are networking and learning.

If you missed my session you can check out the slides. (They should be available for a month or so). I've added some slides that didn't fit into the 40 minute session, but you'll just have to imagine all the cool, extra tips I verbalized during the presentation! Make sure to come and listen to me speak at a future conference.

PS Thanks to the Oracle Apps UX crew for the photographs (and for lunch afterwards). I'm looking forward to visiting their Oracle HQ lab to see all the cool stuff they do.

Christopher Jones presenting on node-oracledb at Developer Week in San Francisco on 14 February 2017 Christopher Jones presenting on node-oracledb at Developer Week in San Francisco on 14 February 2017

Oracle to Help Businesses Better Support Global Operations with Seamless Tax Reporting

Oracle Press Releases - Tue, 2017-02-14 17:00
Press Release
Oracle to Help Businesses Better Support Global Operations with Seamless Tax Reporting New cloud tax and reporting solution helps tax professionals, CFOs, and controllers manage complex country-specific tax reporting requirements through automation

Redwood Shores, Calif.—Feb 14, 2017

Oracle today announced a new finance cloud solution that helps companies, operating in multiple countries, meet complex taxation requirements and regulatory reporting standards imposed by each country. In our globalized economy, compliance with sophisticated tax and statutory laws around the world continues to be a constant challenge for finance professionals. Now these professionals can rely on Oracle Tax Reporting Cloud Service (TRCS), which streamlines tax reporting processes and manages complexity to ultimately enable compliance with new and existing tax regulations.

Oracle TRCS delivers an out-of-the-box cloud solution to help organizations automate their tax provision and country-by-country reporting (CbCR). TRCS enables seamless transparency between tax and finance to reduce risk and brings tax and finance functions together in a unified, secure, and scalable cloud platform. It also streamlines tax reporting processes, including data collection, workflow, data automation, and pre-built KPIs for audit flags.

“Tax reporting is a complicated process, especially for businesses operating in multiple countries, which needs automation to help keep up with the increasing demands,” said Hari Sankar, group vice president of enterprise performance management (EPM) at Oracle. “Oracle TRCS enables organizations to transparently unify tax and finance data in the cloud, with pre-built best practice tax reporting, and provides a platform to significantly improve the broader tax function.”

With a strong tax framework that includes workflow, dashboards, segregation of duties, and transparent calculations, Oracle TRCS allows tax departments to spend more time on analysis and planning instead of on data reconciliation, which can be a complex and time-consuming task in the ledger or stand-alone tax provision system. Oracle TRCS was built for the cloud with the business user in mind and introduces new capabilities and innovations built on best practices from Oracle’s on-premises offering—Oracle Hyperion Tax Provision. By efficiently planning, reporting, and automating tax—with transparency and auditability, regardless of country of operation—TRCS also enhances CbCR, US GAAP, IFRS, and statutory tax reporting.

Additional features include:

  • Task management and calendaring framework that is configurable and integrated with finance systems; businesses can automate the whole tax calendar including tax filing dates, tax provision, and audit management tasks
  • Supplemental data management tool that is configurable and provides a centralized repository for manual input
  • Pre-built dashboards and reports that deliver simple self-service reporting
  • Configurable dashboards that provide analysis across total tax, including direct, sales & VAT, fixed assets, property tax, and more
  • Oracle Smart View for Microsoft Office provides powerful ad hoc analysis for all tax reporting data
  • Direct data integration with source finance systems, including both cloud and on-premises applications

Oracle TRCS easily integrates with multiple Enterprise Resource Planning (ERP) systems, as well as Oracle Enterprise Performance Management (EPM) Cloud and on-premises offerings, and specifically enables the sharing of data, metadata, and processes with the finance function during the financial close cycle.

“Many companies have still managed their global tax reporting processes through Excel and struggle to make the step into applying technology,” said Bart Janssen, Partner, Deloitte Tax Lawyers. “I am certain that with TRCS, the threshold for making that leap for many clients will become lower.”

Oracle TRCS is available now for existing and new customers. Businesses can choose flexible deployment options to best fit their needs. For additional information, visit Oracle Cloud and connect with Oracle EPM Cloud on Twitter.

Contact Info
Joann Wardrip
Oracle
+1.650.607.1343
joann.wardrip@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Joann Wardrip

  • +1.650.607.1343

IP Telecom Implements Oracle’s Zero Data Loss Recovery Appliance to Boost Growth of its Data Protection & Recovery as a Service Business

Oracle Press Releases - Tue, 2017-02-14 12:56
Press Release
IP Telecom Implements Oracle’s Zero Data Loss Recovery Appliance to Boost Growth of its Data Protection & Recovery as a Service Business IP Telecom and Oracle worked together to implement this Cloud Business solution to ensure 100% data protection

Redwood Shores, Calif.—Feb 14, 2017

Oracle Portugal today announces that the telecommunications leader IP Telecom has selected Oracle’s Zero Data Loss Recovery Appliance (Recovery Appliance), the industry’s only solution to offer end-to-end data protection for Oracle databases, eliminate data loss exposure and maintain business availability, to ensure their national market customers have access to Data Protection & Recovery as a Service as a Cloud Solution.

IP Telecom is a company held by Infraestruturas de Portugal specialized in telecommunications, Corporate Cloud and Information Security solutions. Oracle’s Zero Data Loss Recovery Appliance was implemented jointly by Oracle Portugal and by IP Telecom and will be available in its Cloud Solutions portfolio.

Oracle’s Zero Data Loss Recovery Appliance is the first appliance ever to eliminate data loss exposure for critical Oracle Databases. When using traditional solutions to restore a database, businesses typically lose all data generated since the last backup—often hours to days of critical data. The Recovery Appliance also dramatically reduces the impact of backups on production servers and networks, virtually eliminating the need for lengthy backup windows. The cloud-scale architecture enables a single Recovery Appliance to manage the data protection requirements of thousands of databases, avoiding the cost and complexity of disparate backup systems.

The solution now available is a result of the partnership agreement signed in June 2016 between Oracle and IP Telecom, aiming to assure the availability of a proper and innovative offer, with customized scaling, based on Oracle’s recognized high-service levels offered by Infrastructure as a Service, which has competitive advantages of real value added.

According to Rui Ribeiro, General Manager of IP Telecom, "This first joint offer with Oracle means that we provide an unparalleled level of data protection to our Cloud national market customers. For us, the information of all our customers is critical, so we seek to create value-added and reliable offerings, ensuring that our customers focus only on their business, because they know that their data is safe and available with our Solutions.“.

Hugo Abreu, Country Manager at Oracle Portugal, said:

“Existing data protection solutions fail to meet the demands of critical databases because they treat databases as simply files to copy rather than as transactional systems with specific data integrity, performance, and availability requirements. With traditional backup solutions, business data is lost, end users and customers are impacted, and deployment and management are complex and fragmented. Oracle's Zero Data Loss Recovery Appliance tightly integrates advanced data protection technologies with Oracle Database to address these challenges head-on, enabling IP Telecom to offer its clients an efficient and effective protection and recovery service for one of their greatest asset: data."

Contact Info
Sarah Fraser
Oracle PR
+1.650.743.0660
sarah.fraser@oracle.com
About IP Telecom

IP Telecom is a telecommunications company and a specialized services operator in the areas of telecommunications, information systems and technologies.

Recognized as a benchmark in this area, the company has a qualified team able to design valuable solutions tailored to the needs of each client and which guarantees its "turnkey" implementation.

Operating in Portugal since 2000, it is led by the management of the Portuguese highway and railway infrastructure - Infraestruturas de Portugal, part of the IP Group.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Sarah Fraser

  • +1.650.743.0660

Customers Across Industries Adopt Oracle Management Cloud to Improve User Experience and Application Delivery

Oracle Press Releases - Tue, 2017-02-14 12:56
Press Release
Customers Across Industries Adopt Oracle Management Cloud to Improve User Experience and Application Delivery Customers use Oracle Management Cloud to increase performance and decrease cost of traditional systems-of-record and DevOps-oriented systems of innovation

Redwood Shores, Calif.—Feb 14, 2017

Oracle today announced that Oracle Management Cloud is experiencing exceptional growth with nearly 950 new customers and partners across the globe within its first year of availability.  FORS, IDEA Cellular, and Safexpress are among the many organizations around the world choosing Oracle Management Cloud to help improve IT resource utilization, increase DevOps productivity, and ensure that critical applications are up and running.

Part of the Oracle Cloud Platform, Oracle Management Cloud is a suite of next-generation integrated monitoring, management, and analytics cloud services that leverage machine learning and big data techniques against the full breadth of customers’ operational data. Oracle Management Cloud’s unified platform helps customers improve IT stability, prevent application outages, and increase DevOps agility, as well as assists in hardening security across their entire application and infrastructure portfolio.

“Across the globe, companies have embraced the new agility of cloud computing,” said Prakash Ramamurthy, senior vice president, Systems Management and Security, Oracle. “While this new environment is great for rapid innovation, it is extremely difficult for development and operations management and staff to keep pace with constant change. Oracle Management Cloud was developed to allow developers to focus more on coding and less on infrastructure while it helps operations staff to efficiently manage fast changing applications and infrastructure – whether customers bought the underlying technology from Oracle or any other vendor; without restrictions upon where it’s running.”

Oracle Management Cloud Revolutionizes Systems Management for Customers Around the World and Across Many Public and Private-Sector Verticals

Telecom:  “Idea is the third-largest telecom service provider in India,” said Prakash Paranjape, CIO, IDEA Cellular. “Given the digital revolution India is going through, we felt that business transformation needed a new management approach. Oracle Management Cloud has allowed us to use contemporary technologies to predict reasons behind a cause through its machine learning capabilities. It has helped us correlate sources of data and logs from multiple components which previously were not looked into.” 

Logistics: “With Oracle Management Cloud, we have been able to manage our IT more efficiently and detect problems before they impact users,” said Sanjay Bakshi, senior manager, IT, Safexpress. “For example, we are able to detect issues like slow transactions and resolve them proactively and faster, which is making a difference in our customer experience.” 

Value-Added Distributor:  “Using Oracle Management Cloud raises quality and expands the range of services available to our partners in their projects,” said Andrey Tambovsky, director of Technology, FORS Distribution. “Administrators use the next-generation analytical tools to improve the quality of services available in the hybrid cloud. We strongly recommend that our partners and their customers use Oracle Management Cloud for in-depth analysis and monitoring of infrastructure and equipment in their own data centers and are ready to assist them in the implementation of these projects.”

Recent Releases Demonstrate Commitment to Customer-Focused Innovation

Oracle Management Cloud’s frequent releases provide an ongoing stream of exciting new customer-centric features that are automatically available in the cloud service’s Software-as-a-Service management platform.  Top features released in the last few months include:

  • Better application performance monitoring through new synthetic end-user monitoring, native mobile application monitoring and APDEX end-user experience rating
  • More efficient log analytics with automatic outlier identification and trend correlation using machine learning-based clustering
  • Smarter IT analytics using improved visualizations and host resource instrumentation, as well as a new database performance tuning application
  • Deeper infrastructure monitoring for popular network devices, public cloud IaaS on Amazon and Oracle as well as monitoring for Oracle PaaS
  • Seamless cross-service navigation with topology-aware exploration for monitored applications that is shared across all Oracle Management Cloud services

Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data.  The Oracle Cloud delivers nearly 1,000 SaaS applications and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world and supports 55 billion transactions each day.

For more information, please visit us at http://cloud.oracle.com.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Kristin Reeves

  • +1.415.856.5145

Announcing eSignatures for WebCenter Content

WebCenter Team - Tue, 2017-02-14 11:21
Authored by: Sarah Gabot, Demand Generation Manager, HelloSign 

HelloSign, the innovative product leader in the eSignature space, has joined forces with TEAM Informatics to provide Oracle WebCenter Content (WCC) customers the ability to integrate the HelloSign API directly into the WCC interface

This means users can now start using eSignatures in WCC, making it easier to send, track, and manage documents that require signature such as contracts or agreements. Users can streamline their content management workflows, resulting in more accurate documents, improved tracking, better security, and faster document turnaround times. 

Users can quickly prepare documents for signature using an easy-to-use interface. This eliminates the time consuming, tiresome manual process of printing, signing, and scanning agreements or business contracts. 

“At TEAM we are always striving to provide our existing and potential customers with new and innovative products that solve everyday business needs,” said Doug Thompson, CEO of TEAM. “Our partnership with HelloSign allows us to integrate an electronic signing process into WebCenter Content, enabling enterprise customers to send, sign, and manage documents at any time from any device.

How does it work? 
In the WebCenter Content interface, users can start the signing process by clicking on the “action” menu. 


Then you’re able to prepare a document to send for eSignatures to the signer. Once it’s sent, you can track the status of the document at any time directly in WCC. 

As the sender, you also get email updates when a signer completes the document–you’ll always be in-the-know with your document statuses!  

Once the document is signed, you’ll be able to see the status in WCC. You’ll have full access to retrieve the document to store or download it to the repository. 

Benefits
When you start using HelloSign for WCC, you get to reap the following benefits: 
  • Easy-to-use integration into WebCenter Content UI
  • Bank-level security for legally binding agreements
  • Ease of use experience for signer and sender reduces turnaround time
  • Removes the need for signers to print, scan, and sign documents 
How to get started
To learn more about this integration, reach out to the TEAM Informatics sales team for a demo sales@teaminformatics.com. To learn more about HelloSign and our services, reach out to us oracle-sales@hellosign.com

Oracle Hospitality Research Identifies Drivers for Consumer Loyalty and Impact of Technology on Hotel and Restaurant Guest Experience

Oracle Press Releases - Tue, 2017-02-14 11:00
Press Release
Oracle Hospitality Research Identifies Drivers for Consumer Loyalty and Impact of Technology on Hotel and Restaurant Guest Experience Global Insights Offer Guidance for Global Food and Beverage and Hotel Industries as they Aim to Capture Repeat Business in 2017

Redwood Shores, Calif.—Feb 14, 2017

Today Oracle announced the findings of two research initiatives aimed at identifying the consumer drivers for loyalty in the food and beverage and hotel industries and the impact of technology in curating a unique hotel guest experience. Insights from both studies highlight a global demand for loyalty programs in the hospitality industry and the critical role of technology to inspire hotel staff to create memorable guest experiences.

Identifying Consumer Drivers for Loyalty

Loyalty programs are a critical driver of repeat business for both the food and beverage and hotel industries with their ability to identify consumer habits, demographics and personalization opportunities. With these insights the hospitality industry can more effectively create frictionless experiences that encourage repeat engagement. To better understand what makes loyalty programs most effective Oracle Hospitality recently conducted a survey of 6,500 global food and beverage consumers and 8,000 hotel travelers represented by the U.S., Brazil, Mexico, Australia, U.K., Germany, France and Japan.

Recipe for Engagement: Essential Ingredients for a Restaurant Loyalty Program

Key insights from the research for the food and beverage industry include:

  • Consumers around the world want to join loyalty programs. In the U.S., 65 percent of consumers are already members of one or more food and beverage programs. Even in Japan, where the lowest percentage of consumers were already members of a program from our survey, nearly one-third belonged to a loyalty program.
  • Plastic loyalty cards remain the preferred loyalty tool with mobile applications gaining popularity. At 62 percent overall, plastic swipe cards were the most preferred method across all generations. At a 56 percent preference, Millennials wanted to use apps for loyalty programs and 50 percent of Gen Xers also agreed that apps are a preferable method.
  • Perceived personal savings drive loyalty. Money off of every purchase (71 percent) and free products (63 percent) were the top two most attractive rewards to consumers.

“Loyalty programs provide restaurant operators with the opportunity to reward guests for repeat business, to create a marketing database for personalized promotions, and to guide the strategy for future programs ensuring their relevancy,” said Mike Webster, senior vice president and general manager, Oracle Hospitality and Oracle Retail. “Oracle Hospitality has a differentiated offering that leverages best-in-class, cloud POS with an integrated gift and loyalty solution and cloud analytics suite that minimizes the creation of disparate data silos which can create false perspectives of guest engagement.”

What Do Consumers Want from a Hotel Loyalty Program?

Key insights from the research for the hotel industry include:

  • Hoteliers still have a chance to create long-term relationships. Among all survey participants, 58.7 percent reported that they do not belong to a hotel loyalty program. A mere 3.2 percent stated that they belong to 5 or more.
  • Loyalty initiatives are “sticky” and encourage repeat stays. Globally a pattern of repeat business was evident among respondents, ranging from 33.6 percent of Australians to 53.8 percent of Mexicans who said they often stay in hotels that offer loyalty programs.
  • Consumers want control over how they redeem rewards. Globally a majority of consumers identified that they are interested in being able to choose how they redeem their rewards (61 percent) and 57 percent are interested or very interested in being able to customize their hotel guest experience (room choice, newspaper, late check out, etc.).
Creating the Coveted Hotel Guest Experience

Oracle Hospitality also polled more than 2,700 travelers from the U.S., U.K., France and Germany to better understand technology’s impact on the hotel-guest experience and gain insight into how technology investments can be a differentiator for winning consumer business. The study also adds perspectives of hoteliers, both chains and independents, to shed light on their technological pursuits and gauge alignment with consumer expectations.

Key insights from the study highlight opportunities to engage guests prior to and during their hotel stay:

  • Nearly two-thirds of U.S. guests said it was “very or extremely important” for hotels to continue investing in technology to enhance the guest experience.
  • Ninety-four percent of business travelers and 80 percent of leisure travelers value the ability to use their smartphones to request service and message hotel staff.
  • Guests are comfortable sharing with hoteliers a fair amount of personal information: 71 percent would share information about food preferences/allergies and 64 percent would share their entertainment preferences.
  • Sixty-two percent of guests used non-hotel sources such as the Internet for dinner reservations and activity recommendations, bypassing the concierge from whom guests say they would prefer to get such assistance.

The full findings of the report can be accessed here and point to a critical opportunity for hoteliers. Once travelers arrive in the lobby, their notion of a memorable experience can be shaped entirely by the deeds and words of hotel staff which can be informed and augmented by technology investments.

“Rather than worry that greater reliance on technology will erode the human aspect of hospitality, hoteliers need to embrace it for what it can be – an invaluable tool to better understand their guests and orchestrate stays that they will long remember,” said Mike Webster, senior vice president and general manager, Oracle Hospitality and Oracle Retail. “Technology can address the industry’s dual challenge of operating efficiently at scale and simultaneously providing individualized service.”

Join Oracle Hospitality at Oracle Industry Connect

Oracle Hospitality will be presenting new product releases, market insights and customer case studies at Oracle Industry Connect in Orlando, FL from March 20-22, 2017. For more information on attendance please visit http://www.oracleindustryconnect.com to register.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

How to add years to a timestamp without losing fractions

Tom Kyte - Tue, 2017-02-14 10:46
Hi, I have a column of type <code>TIMESTAMP</code> t in which I safe timestamps with 6 digit precision e.g. 03-FEB-17 04.45.01.909000 PM Due to the way they have ben added to the table they are missing two things: 1. The time zone information ...
Categories: DBA Blogs

Flashback Archive, create_temp_history_table and import_history

Tom Kyte - Tue, 2017-02-14 10:46
<b>Hi Tom, I'm trying to understand how it works Flashback Archive. I have problem with commands create_temp_history_table and import_history This is the script: </b> create table prueba_fb2 (c_cadena varchar2(1000), n_numero numbe...
Categories: DBA Blogs

How to find long running queries in a database

Tom Kyte - Tue, 2017-02-14 10:46
Hi, I'm trying to get the long running queries for my database. I need the start and end time of those queries also. These long running query is causing issues in releases. Please help me to find out the sql text and start & end time of the q...
Categories: DBA Blogs

Shell Script to load data

Tom Kyte - Tue, 2017-02-14 10:46
<code>Hi, we work on oracle apps and using 12c Data Base in Back end. We Are using a concurrent program(shell script) to load data into staging table from front End.in data file we have data like below col 1 Col2 Col3 1025-1'...
Categories: DBA Blogs

Check valid SQL syntax without executing and when objects are not present in the schema

Tom Kyte - Tue, 2017-02-14 10:46
Can I validate SQL syntax without having the objects created in database? I have a free text where users are supposed to enter valid SQL text. I have to determine which are valid and which are invalid entries. create table metadata (data_src_name...
Categories: DBA Blogs

Relation Between two tables

Tom Kyte - Tue, 2017-02-14 10:46
Hi, I have two tables emp,grades without any constraints like primary and Foreign keys.My requirement is to give the grades to employees based on the grades given for salary range in grades tables. i written a Join query for that but getting p...
Categories: DBA Blogs

How to get PIN CODE from latitude and longitude in PLSQL Procedure.

Tom Kyte - Tue, 2017-02-14 10:46
Hi Tom, I have latitude and longitude for a particular location or person as my input parameter and I want to get PIN CODE for the same in PLSQL proc. Could you please help Thanks, Rajnish Malik
Categories: DBA Blogs

Histograms

Tom Kyte - Tue, 2017-02-14 10:46
Hello Tom, One question, in 10g and 11g versions, what are the impacts in a busy system of manually gathering the whole database statistics without updating histograms? I mean the impacts from the following points of view: 1- How long it wil...
Categories: DBA Blogs

Goldengate 12c runInstaller UNIX_GROUP_NAME | INVENTORY_LOCATION

Michael Dinh - Tue, 2017-02-14 08:20

I keep finding ways to break things because the environments are not consistent.

UNIX_GROUP_NAME
This parameter is the UNIX group name to be set for the inventory on UNIX platforms.
Note: The UNIX group name is used for first-time installations only.

Details for oraInventory

$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall

Notice the group is dba while /etc/oraInst.loc has oinstall.
Probably because I specified UNIX_GROUP_NAME=dba?
Don’t remembered since this environment is really old.

$ ls -ld /u01/app/oracle/oraInventory
drwxrwx---. 6 oracle dba 4096 Feb 14 04:50 /u01/app/oracle/oraInventory

What happens when INVENTORY_LOCATION is not the same as /etc/oraInst.loc ?

oracle@arrow1:HAWKA:/media/sf_OracleSoftware/GoldenGate_12.2.0.1/fbo_ggs_Linux_x64_shiphome/Disk1
$ ./runInstaller -silent -showProgress -waitforcompletion INSTALL_OPTION=ORA11g SOFTWARE_LOCATION=/u01/app/12.2.0.1/ggs03 UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory

++++++++++

oracle@arrow1:HAWKA:/home/oracle
$ ls -ld /u01/app/oraInventory
drwxrwx---. 5 oracle oinstall 4096 Feb 14 05:18 /u01/app/oraInventory
oracle@arrow1:HAWKA:/home/oracle
$

++++++++++

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03
$ cd /u01/app/12.2.0.1/ggs03/OPatch/

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$ env|grep HOME
GG_HOME=/u01/app/12.2.0.1/ggs01
HOME=/home/oracle

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$ export GG_HOME=/u01/app/12.2.0.1/ggs03

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$ ./opatch lsinventory -details
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/12.2.0.1/ggs03
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /u01/app/12.2.0.1/ggs03/cfgtoollogs/opatch/opatch2017-02-14_05-21-32AM.log

List of Homes on this system:

Home name= OraGI12Home1, Location= "/u01/app/12.1.0.2/grid"
Home name= OraDB12Home1, Location= "/u01/app/oracle/product/12.1.0.2/db_1"
Home name= OraDb11g_home1, Location= "/u01/app/oracle/product/11.2.0.4/db_1"
Home name= OraHome1, Location= "/u01/app/12.2.0.1/ggs01"
Home name= OraHome2, Location= "/u01/app/12.2.0.1/ggs02"
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73
oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$

When INVENTORY_LOCATION is different from /etc/oraInst.loc, use -invPtrLoc.

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$ ./opatch lsinventory -details -invPtrLoc /u01/app/oraInventory/oraInst.loc
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.2.0.1/ggs03
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oraInventory/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /u01/app/12.2.0.1/ggs03/cfgtoollogs/opatch/opatch2017-02-14_05-44-55AM.log

Lsinventory Output file location : /u01/app/12.2.0.1/ggs03/cfgtoollogs/opatch/lsinv/lsinventory2017-02-14_05-44-55AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle GoldenGate Core                                               12.2.0.0.0
There are 1 products installed in this Oracle Home.


Installed Products (6):

Installer SDK Component                                              11.2.0.3.0
Java Development Kit                                                 1.6.0.65.0
Oracle GoldenGate Core                                               12.2.0.0.0
Oracle GoldenGate for Oracle 11g                                     12.2.0.0.0
Oracle One-Off Patch Installer                                       11.2.0.1.7
Oracle Universal Installer                                           11.2.0.3.0
There are 6 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.
oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$

Just out of curiosity, what’s the difference between ORA11g|ORA12c?

oracle@arrow1:HAWKA:/media/sf_OracleSoftware/GoldenGate_12.2.0.1/fbo_ggs_Linux_x64_shiphome/Disk1
$ ./runInstaller -silent -showProgress -waitforcompletion INSTALL_OPTION=ORA12c SOFTWARE_LOCATION=/u01/app/12.2.0.1/ggs03 UNIX_GROUP_NAME=dba INVENTORY_LOCATION=/u01/app/oraInventory2
Starting Oracle Universal Installer...

++++++++++

oracle@arrow1:HAWKA:/home/oracle
$ cd /u01/app/12.2.0.1/ggs03/OPatch/

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$ cat /u01/app/oraInventory2/oraInst.loc
inventory_loc=/u01/app/oraInventory2
inst_group=dba

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$ ls -ld /u01/app/oraInventory2/
drwxrwx---. 5 oracle dba 4096 Feb 14 06:08 /u01/app/oraInventory2/

++++++++++

oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$ ./opatch lsinventory -details -invPtrLoc /u01/app/oraInventory2/oraInst.loc
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.2.0.1/ggs03
Central Inventory : /u01/app/oraInventory2
   from           : /u01/app/oraInventory2/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /u01/app/12.2.0.1/ggs03/cfgtoollogs/opatch/opatch2017-02-14_06-09-42AM.log

Lsinventory Output file location : /u01/app/12.2.0.1/ggs03/cfgtoollogs/opatch/lsinv/lsinventory2017-02-14_06-09-42AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle GoldenGate Core                                               12.2.0.0.0
There are 1 products installed in this Oracle Home.


Installed Products (6):

Installer SDK Component                                              11.2.0.3.0
Java Development Kit                                                 1.6.0.65.0
Oracle GoldenGate Core                                               12.2.0.0.0
Oracle GoldenGate for Oracle 12c                                     12.2.0.0.0
Oracle One-Off Patch Installer                                       11.2.0.1.7
Oracle Universal Installer                                           11.2.0.3.0
There are 6 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.
oracle@arrow1:HAWKA:/u01/app/12.2.0.1/ggs03/OPatch
$

Updated: Database Partitioning with EBS Whitepaper

Steven Chan - Tue, 2017-02-14 02:05

Partitioning allows a single database table and its associated indexes to be broken into smaller components depending on the table and choice of index partitioning methods.  This can sometimes improve performance of large EBS databases significantly. Several E-Business Suite modules take advantage of database partitioning right out of the box, and custom partitioning is also possible.

Our Applications Performance Group has just released a major update to their best-practices white paper on EBS database partitioning:

Partitioning diagram

The new white paper covers:

  • Partitioning fundamentals and references to key partitioning resources
  • Relationship between partitioning and compression
  • Principles for effective partitioning of EBS tables
  • Definitions of seeded vs. custom partitioning
  • Benefits of partitioning
  • Considerations when evaluating partition designs
  • Identifying objects that might be good candidates for partitioning
  • Implementing and testing partitioning
  • And most useful: lots of concrete examples with benchmarks!

Over 90% of this whitepaper has been rewritten, so you should check out this new edition even if you've downloaded an earlier version.

Related Articles

Categories: APPS Blogs

Data Pump or Data Pain Part02 – tablespace/user

Michael Dinh - Mon, 2017-02-13 21:38

This is still all WIP and if you stay with me, I will provide all the sequences for export and import.

Too much info put in one post.

EXP-10 Usernames Which Cannot Be Exported (Doc ID 217135.1)
Did you know from $ORACLE_HOME/rdbms/admin/catexp.sql there is view EXU8USR providing which schemas will not be in full export?

This looks rather similar to column oracle_maintained from dba_users for 12c database.

Schema bold red will not be exported. Trust but verify.

oracle@arrow1:HAWKA:/media/sf_working/datapump
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 13 18:28:51 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Testing options

ARROW1:(SYS@HAWKA):PRIMARY> set lines 120 tab off trimsp on pages 1000
ARROW1:(SYS@HAWKA):PRIMARY> col name for a55
ARROW1:(SYS@HAWKA):PRIMARY> select username from dba_users order by 1;

USERNAME
------------------------------
APPQOSSYS
DBSNMP
DEMO
DIP
GGS_ADMIN
ORACLE_OCM
OUTLN
SYS
SYSTEM

9 rows selected.

ARROW1:(SYS@HAWKA):PRIMARY> select name from exu8usr order by 1;

NAME
-------------------------------------------------------
DEMO
GGS_ADMIN
OUTLN
SYS
SYSTEM

ARROW1:(SYS@HAWKA):PRIMARY> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Testing options
oracle@arrow1:HAWKA:/media/sf_working/datapump
$

First step is to pre-create tablespaces.

$ cat impdp_full01_tbs.par

directory=DATA_PUMP_DIR
userid="/ as sysdba"
metrics=Y
dumpfile=full.dmp
logfile=impdp_full_tbs.log
include=TABLESPACE
sqlfile=tbs.sql

$ impdp parfile=impdp_full01_tbs.par

Import: Release 11.2.0.4.0 - Production on Mon Feb 13 18:46:56 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Testing options
Startup took 0 seconds
Master table "SYS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_SQL_FILE_FULL_01":  /******** AS SYSDBA parfile=impdp_full01_tbs.par
Processing object type DATABASE_EXPORT/TABLESPACE
     Completed 4 TABLESPACE objects in 0 seconds
Job "SYS"."SYS_SQL_FILE_FULL_01" successfully completed at Mon Feb 13 18:46:57 2017 elapsed 0 00:00:01

$ cat /u01/app/oracle/product/11.2.0.4/db_1/rdbms/log/tbs.sql

See how the filename is hard coded even when OMF is being used.

-- CONNECT SYS
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: DATABASE_EXPORT/TABLESPACE
CREATE UNDO TABLESPACE "UNDOTBS" DATAFILE
  SIZE 268435456
  AUTOEXTEND ON NEXT 268435456 MAXSIZE 8192M
  BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE
  SIZE 1610612736
  AUTOEXTEND ON NEXT 268435456 MAXSIZE 8192M
  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576;
CREATE TABLESPACE "USERS" DATAFILE
  SIZE 135266304
  AUTOEXTEND ON NEXT 134217728 MAXSIZE 8193M,
  SIZE 16777216,
  SIZE 10485760
  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
 NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO;

   ALTER DATABASE DATAFILE
  '/oradata/HAWKA/datafile/o1_mf_users_d4gohzod_.dbf' RESIZE 16785408;

CREATE TABLESPACE "GGS_DATA" DATAFILE
  SIZE 269484032
  AUTOEXTEND ON NEXT 268435456 MAXSIZE 16385M
  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 DEFAULT
 NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO;

Basically datafile 5 was created with 16777216 and resized to 16785408.
Why did datapump not use the current size vs original size?
I know what you are probably thinking, why not just create SQL script to do the work.
True but it’s like buying a Mercedes-Benz and having to roll down the windows by hand. (Dating myself).

ARROW1:(SYS@HAWKA):PRIMARY> select file#,name,bytes from v$datafile where name like '%user%';

     FILE# NAME                                                         BYTES
---------- ------------------------------------------------------- ----------
         4 /oradata/HAWKA/datafile/o1_mf_users_d3q5b4gw_.dbf        135266304
         5 /oradata/HAWKA/datafile/o1_mf_users_d4gohzod_.dbf         16785408
         7 /oradata/HAWKA/datafile/o1_mf_users_db4vw289_.dbf         10485760

ARROW1:(SYS@HAWKA):PRIMARY>

SYSTEM and SYSAUX tablespaces are not exported while UNDO and TEMP are.
Hopefully, the following was performed to get all the details from DB creation.
alter database backup controlfile to trace as ‘/tmp/cf_@.sql’ reuse resetlogs;
select property_name,property_value from DATABASE_PROPERTIES;

Processing object type DATABASE_EXPORT/TABLESPACE
     Completed 4 TABLESPACE objects in 1 seconds

+++++++++
     
ARROW1:(SYS@HAWKA):PRIMARY> select name from v$tablespace order by 1;

NAME
-------------------------------------------------------
GGS_DATA
SYSAUX
SYSTEM
TEMP
UNDOTBS
USERS

6 rows selected.

ARROW1:(SYS@HAWKA):PRIMARY>     

Last but not least, did you know you can create database in achivelog mode to begin with versus having to enable ARCHIVELOG mode after the fact?

Take a look at my post below.
OTN Appreciation Day : Create Database Using SQL | Thinking Out Loud Blog

ARCHIVELOG
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
SET TIME_ZONE=’US/Mountain’


How to print row value involved in merge statement

Tom Kyte - Mon, 2017-02-13 16:26
Hi, By using dbms_output.put_line( sql%rowcount) we can get the number of rows affected by merge statement. Is it possible to print value of those rows during merge using PL/sql? thanks, Amiya.
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator