Feed aggregator

Database Links and LOBs

Tom Kyte - Thu, 2017-06-29 13:46
Tom: I have two dbs running 8.1.6. I created a DB link from one DB to other and when I tried to do a select on a table where I have CLOB data and it's giving me error. How do I remotely copy the lob data from one db to the other? ...
Categories: DBA Blogs

Benefit of Dashboard Reporting for Government Operations

Nilesh Jethwa - Thu, 2017-06-29 12:45

Dashboard reporting has never been more important to the government. Considering the humungous streams of data collected through government agencies and programs, the challenge is how to make sense of these data in a way that they will benefit the organization and perhaps save large amounts of money as a result. The use of this type of reporting has been exalted by the US.

In the US

The US administration flaunted the advantages of using dashboards during the presidency of Barack Obama. They said that using a dashboard is an effective way of collating and filtering data so that these data become useful to decision makers. They credited the dashboard for being able to make them see better the implications of data and act on them appropriately.

One example cited by the government is how a dashboard helped them see the status of their investments, particular in pursuing the advance of technology.

The claim from the administration of Obama was that they were able to make better decisions using the data presented by the dashboard. According to them, this led to billions of dollars in savings and cutting delivery time for technological projects.

The US Congress has communicated a positive sentiment on the matter of using a government dashboard for federal decision-making and operations. It expressed interest in increasing the use of transparency tools, such as dashboards, across federal spending programs.

It is expected that more efforts will be exerted towards this goal and the use of dashboards may even be continued to be implemented after Obama relinquishes his office.

Other governments

Read more at http://www.infocaptor.com/dashboard/dashboard-reporting-for-government-and-how-it-can-benefit-government-operations

APEX applications that run without Javascript just got harder

Tony Andrews - Thu, 2017-06-29 06:46
Long ago in 2009 I wrote a blog post called Accessible APEX and in it there is a link to an application on apex.oracle.com that would work even when Javascript was disabled in the browser.  However, since APEX 5.1 changes the way page items are mapped, that old application no longer works when Javascript is disabled. Oh dear , never mind, who cares?  Why would anyone in 2017 want to disabled Tony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.com0http://tonyandrews.blogspot.com/2017/06/apex-applications-that-run-without.html

Is It Possible to Link to Specific EBS Pages?

Steven Chan - Thu, 2017-06-29 02:00

This question comes up periodically:  Is it possible to bookmark a specific EBS OA Framework page and then successfully open that page even if the user is not logged in?

The answer is a qualified yes.  This is technically possible, but the page must be built to support that by an OA Framework developer.  It is not possible for EBS end-users to change an OAF page's definition.

Developers can make pages bookmarkable by following the instructions described in the OA Framework Developer's Guide, Chapter 6: Advanced OA Framework Development Topics > Security > Accelerated Validation > Bookmarkable Pages. Here's a link to the latest version:

The main requirement is that the page be self-secured with some associated supporting code.  The same requirement applies to EBS links included in Workflow email notifications, too.

Related Articles

Categories: APPS Blogs


Wim Coekaerts - Thu, 2017-06-29 02:00

As I am sure many of you have heard/read about CVE-2017-1000364.

If not, you can find some information here:




An issue was discovered in the size of the stack guard page on Linux, specifically a 4k stack guard page is not sufficiently large and can be "jumped" over (the stack guard page is bypassed), this affects Linux Kernel versions 4.11.5 and earlier (the stackguard page was introduced in 2010).

This CVE has a very high CVSS score of 9.8.

There are a number of packages release for Oracle Linux to deal with this CVE.

An updated glibc: https://linux.oracle.com/cve/CVE-2017-1000366.html

An updated kernel:  https://linux.oracle.com/cve/CVE-2017-1000364.html

A very important additional detail is that we also have an online fix available through Ksplice. So for Oracle Linux users/customers with a support subscription, you can simply run uptrack-upgrade on a running kernel. No reboot required.

# uptrack-upgrade
The following steps will be taken:
Install [8cpcuyra] CVE-2017-1000364: Increase stack guard size to 1 MiB.

Go ahead [y/N]? y
Installing [8cpcuyra] CVE-2017-1000364: Increase stack guard size to 1 MiB.
Your kernel is fully up to date.
Effective kernel version is 4.1.12-94.3.7.el7uek



How true is the DBMS_UTILITY.GET_TIME function

Tom Kyte - Wed, 2017-06-28 19:26
I was trying to verify how true would be the values returned by the function DBMS_UTILITY.GET_TIME using the below code. <code>DECLARE curr_time1 DATE := SYSDATE; curr_time2 NUMBER := dbms_utility.get_time; BEGIN LOOP EXIT WHEN SYSD...
Categories: DBA Blogs

Oracle GoldenGate Cloud Service

Pakistan's First Oracle Blog - Wed, 2017-06-28 18:37
Even on Amazon AWS, for the migration of Oracle databases from on-prem to Cloud, my tool of choice is GoldenGate. The general steps I took for this migration was to create extract on source in on-prem, which sent data to replicat running in AWS Cloud in EC2 server, which in turn applied data to cloud database in RDS.

I was intrigued to see this new product from Oracle which is Oracle GoldenGate Cloud Service (GGCS).

So in this GGCS, we have extract, extract trail, and data pump running in the on-prem, which sends data to a Replication VM node in Oracle Cloud. This Replication VM node has a process called as Collector which collects incoming data from the on-prem. Collector then writes this data to a trail file from which data is consumed by a Replicat process and then applied to the cloud database.

This product looks good as it leverages existing robust technologies and should become default way to migrate or replicate data between oracle databases between on-prem and cloud.
Categories: DBA Blogs

ODA X6 installation: re-image

Yann Neuhaus - Wed, 2017-06-28 15:44

The Oracle Database Appliance is shipped with a bare-metal installation which may not be the latest version. You may want to have it virtualized, or get the latest version to avoid further upgrade, or install an earlier version to be in the same configuration as another ODA already in production. The easiest for all cases is to start with a re-image as soon as the ODA is plugged. This post is not a documentation, just a quick cheat sheet.

I don’t want to spend hours in the data center, so the first step, once the ODA is racked, cabled and plugged, is to get it accessible from the management network. Then all tasks can be done from a laptop, accessing the ILOM interface through a browser (Java required, and preferably 32-bits) before the public network is setup.


Here is the back of the server where you find the management network port.
This was an X5-2 but very similar to X6-2. You can look at the 3D view of X6-2 to get a better view.
There is also VGA and USB to plug a monitor and keyboard just for the time to setup the management network.

You can also use the serial port which is just next to it but I usually don’t have a serial adapter for my laptop.

First checks

You can plug a keyboard and monitor and log on the server: root password is welcome1 (no need to change it for the moment as we will re-image the machine)

In ODA X6-HA you have two nodes, numbered 0 and 1 and called oak1 and oak2 … be careful. You may wonder which server is node 0 and which one is node 1, because the servers are the same. Yes, that’s true. The nodes are identified from the storage port they are connected to. The node 0 is the one connected to the blue mini-SAS and the red ones are for node 1.

  • Blue cable – Node 0 – oak1
  • Red cable – Node 0 – oak2

Here I’m on node 0 and check hardware version

[root@oak1 ~]# /opt/oracle/oak/bin/oakcli show env_hw

This means Bare Metal X6-2 HA, a virtualized one would show VM-ODA_BASE ODA X6-2, and ODA X6-2S would show BM ODA_Lite X6-2 Small.

From storage topology, we confirm that this node has been recognized as node 0:

[root@oak1 ~]# /opt/oracle/oak/bin/oakcli validate -c StorageTopology
It may take a while. Please wait...
INFO : ODA Topology Verification
INFO : Running on Node0
INFO : Check hardware type
SUCCESS : Type of hardware found : X5-2
INFO : Check for Environment (Bare Metal or Virtual Machine)

And finally check the version because you may be lucky to get the version you want and then don’t need to re-image (I switched to node 1 here):


Of course, you don’t need to re-image when you want an higher version. You can upgrade it, but re-image is simple.

BMC Network

The management network interface can get an address from DHCP. But who runs DHCP on the management network? There are two ways to assign a static IP to the management network.

You may use the IPMI Tool commands:
ipmitool -I open sunoem cli
cd SP
cd Network
set pendingipadress=
set pendingnetmask=
set pendingipgateway=
set commitpending=true

Here is an example:

Or you can go to BIOS. It goes fast but filming in slow motion shows that the key is F2:
Once you are in the BIOS interface, go to Advanced, then choose ‘BMC Network configuration’ to configure IPMI and enter the following BMC Lan information:
IPv4 IP Assignment [Static] IPv4 address
IPv4 Subnet Mask
IPv4 Default Gateway

Once you are in the BIOS you can choose to boot on the CD-ROM first because I sometimes have problems to set that from the ILOM Web interface.

Once you have validated that the ILOM IP address can be reached from your office, you can remove the keyboard and monitor and leave the datacenter. the hardware is ok. Now the software can be deployed from the ILOM Web interface. The password to connect to ILOM from the Web browser is ‘changeme’ and you should change it.


The latest ISO image for Bare Metal or Virtualized ODA can be found from Note 88888.1
You can also find the oldest versions:

From the ILOM you you get to the console of node 0:


From there, you can attach the ISO image: ILOM Remote Control / Devices / CD-ROM Images

and then reboot on the CD-ROM:

Reboot (Host Control / Next Boot Device / CD-ROM )


Do that for both nodes (you can run them at the same time) and prepare the information for the deployment and download the ‘End-User RDBMS Clone files’ for the database version you want.

You can download the Oracle Appliance Manager Configurator and take your time to setup and verify the configuration.

configure firstnet

Here is part of the information to prepare. First, you will configure the network to be able to scp the software (Grid Infrastructure and Database):

[root@oak1 ~]# /opt/oracle/oak/bin/oakcli configure firstnet
Configure the network for node(s) (local,global) [global]:
The network configuration for both nodes:
hostname: Hostname lookup failure
Domain Name: pachot.net
DNS Servers: Primary DNS Server:
Node Name Host Name
0 myserver1
1 myserver2
Choose the network interface to configure (net1,net2) [net1]:
Enter the IP address for net1 on Node 0:
Enter the IP address for net1 on Node 1:
Netmask for net1:
Gateway address for net1 []:

Note that this is a funny example. I hope you don’t use the 192.168.16/24 as you public network because this is used for the private interconnect where IP addresses and are hardcoded. But thanks to that the configure-network can be run fron one node only.


Now that you have access through the public network, you can copy (scp) the Oracle Home clones and the configuration file to /tmp, unpack the .zip (for i in *.zip ; do /opt/oracle/oak/bin/oakcli unpack -package $i ; done) and run deploy (ssh -X /opt/oracle/oak/bin/oakcli deploy), loading the configuration from your file or entering all information from there. Crossing the fingers, this should go to the end without any problem. On the opposite, My Oracle Support notes may help. The nice thing with ODA is that most of the configurations are similar so there a good chances that a problem was already encountered and documented.


Cet article ODA X6 installation: re-image est apparu en premier sur Blog dbi services.

Two New Articles on API Management and Microservices

OTN TechBlog - Wed, 2017-06-28 12:38

Oracle ACE Director Luis Weir and ACE Associate Phil Wilkins, both from Capgemini, already teamed up to present API Management and Microservices: A Match Made in Heaven at the recent Oracle Code event in London, captured in the video above. Now the dynamic duo has collaborated again on a pair of articles now available on OTN.

Luis's contribution, 3rd-Generation API Management: From Proxies to Micro-Gateways, examines the confluence of cloud adoption, ntegration platform as a service, and microservices.

Phil's contribution, Registries: Use Cases for API Management and Microservices, explores the role of registries in a microservices environment and their relationship to API Management.

Taken together the articles offer a detailed view of what's happening in the confluence of two very hot topics. So read them already!

Additional Resources





DOAG Red Stack Magazin Artikelreihe "Oracle Database Cloud Performance" (German)

Randolf Geist - Wed, 2017-06-28 11:03
In der aktuellen Ausgabe des für Mitglieder der DOAG, SOUG und AOUG kostenlosen DOAG Red Stack Magazins wurde der erste Teil meiner zweiteiligen Artikelserie "Oracle Database Cloud Performance" veröffentlicht.

Die Artikelserie basiert auf den hier bereits publizierten Erkenntnissen in diesem Bereich und führt diese weiter fort.

Der erste Teil geht auf die verschiedenen Aspekte der maximal erreichbare Performance ein (CPU, Storage etc.), der zweite Teil wird in der nächsten Ausgabe zu lesen sein und legt den Schwerpunkt auf die Konsistenz der Performance, also wie konsistent sich die Datenbanken in der Cloud in Bezug auf Performance während der Tests verhalten haben.

Oracle ERP Cloud Named Leader in 2017 Gartner Magic Quadrant for Cloud Core Financial Management Suites

Oracle Press Releases - Wed, 2017-06-28 10:00
Press Release
Oracle ERP Cloud Named Leader in 2017 Gartner Magic Quadrant for Cloud Core Financial Management Suites

Redwood Shores, Calif.—Jun 28, 2017

News Summary

Oracle today announced it has been named a Leader in Gartner’s 2017 “Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises” research report1. Out of 11 products evaluated, Oracle ERP Cloud is positioned the highest for both completeness of vision and ability to execute.

According to the report, “Leaders demonstrate a market-defining vision of how core financial management systems and processes can be supported and improved by moving them to the cloud. They couple this with a clear ability to execute this vision through products, services and go-to-market strategies. They have a strong presence in the market and are growing their revenues and market shares. In the cloud core financial management suites market, Leaders show a consistent ability to win deals in organizations of different sizes, and have a good depth of functionality across all areas of core financial management. They have multiple proof points of successful deployments by customers based in their home region and in other geographies. Their offerings are frequently used by system integrator partners to support finance transformation initiatives.”

“Transformation and innovation are top of mind for finance organizations. Customers are looking for best-in-class cloud solutions to help drive deep real time business insights, increase productivity, and lower costs,” said Rondy Ng, senior vice president, applications development at Oracle. “Oracle ERP Cloud is the only enterprise-grade solution on the market with the breadth, depth, security, scalability, and cutting-edge innovations to meet these demanding business needs. We consider our leader positioning by Gartner as validation of our product and service driven strategy and recognition of our commitment to our customers’ success.”

“When we started our finance transformation effort to modernize our systems infrastructure, we needed a flexible solution that reduced our cost profile, mandated standardized best practice processes, and accelerated our ability to uptake innovative technology,” said Matthew Trager, Head of Finance Business Architecture, Lloyds Banking Group. “Oracle ERP Cloud met these and all of our functional and security requirements, giving us the agility to react and grow in a hyper-competitive business environment.”

Oracle ERP Cloud is the industry’s most complete, modern, and proven financial platform delivered seamlessly through the Oracle Cloud. A modern user interface driven by the latest design innovations delivers embedded analytics, contextual social collaboration, and a device-independent mobile experience to make Oracle ERP Cloud familiar and easy to use.

Oracle ERP Cloud includes complete ERP capabilities across Financials, Procurement, and Project Portfolio Management (PPM), as well as Enterprise Performance Management (EPM), Governance Risk and Compliance (GRC) and Supply Chain Management (SCM). Native integration with the broader Oracle SaaS portfolio for Human Capital Management (HCM), and Customer Experience (CX) offer customers a practical, business-driven, rapid adoption path forward.

Download Gartner’s 2017 “Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises” research report”1.

For additional information on Oracle Cloud solutions for Finance, visit Oracle Enterprise Resource Planning (ERP) Cloud’s Facebook, Twitter, or the Modern Finance Leader blog.

Gartner Disclaimer
Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

1.Gartner, “Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises,” by Nigel Rayner, Robert P. Anderson, John E. Van Decker, June 2017.

Contact Info
Joann Wardrip
About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries and territories while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at http://cloud.oracle.com.


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

Talk to a Press Contact

Joann Wardrip

  • +1.650.607.1343

Benefits of Dashboards for IT

Nilesh Jethwa - Wed, 2017-06-28 09:54

The process of examining sets of data using specialized computer systems is called data analytics or data analysis. These computer systems make data easier to interpret by transforming, arranging, and modeling it to form patterns.

Data analytics tools guide businesspeople in coming up with better business decisions. Researchers and scientists also use these tools to evaluate scientific hypotheses, theories, and models.

Real-time report of data about the performance of a company, a specific department, a project, or group of employees can be accessed through a so-called data analytics dashboard. This is an information management tool, which monitors a group or a company’s metrics, key data points, and key performance indicators (KPI).

A dashboard can be customized according to a department or a company’s needs. It connects to your attachments, services, files, and Application Program Interface (API).

IT Management Dashboards

Some of the available dashboards for IT include the following:


Read more at http://www.infocaptor.com/dashboard/data-analytics-and-benefits-of-dashboards-for-it

gnTel Selects Oracle Communications to Scale Cloud Based Hosted Services

Oracle Press Releases - Wed, 2017-06-28 09:00
Press Release
gnTel Selects Oracle Communications to Scale Cloud Based Hosted Services gnTel deploys Oracle Communications Session Border Controller to expand their SIP trunking and hosted unified communications services and to establish a clear path for evolution to NFV

Redwood Shores, Calif.—Jun 28, 2017

gnTel, a fast growing cloud-based telecom service provider to small and medium sized businesses in the Netherlands, has selected Oracle Communications technology to better scale their operations and lay the groundwork for the evolution of their network to NFV. Replacing their existing solution, gnTel will use Oracle Communications Session Border Controller (OCSBC) running on Acme Packet 4600 purpose-built hardware platforms to immediately create a new scalable access and peering infrastructure for their customers. This solution will allow gnTel to not only jumpstart their services but because of the close interworking between physical and virtualized OCSBC instances, and a flexible licensing scheme, also preserve this investment while they migrate to NFV.

Oracle Communications Session Border Controller is one of the industry’s leading border control solution that operates with most major IP-PBX, unified communications, and application server providers - reducing risks associated with commercial production level installations. Available on both purpose-built physical and commercial-off-the-shelf virtualized platforms, and coupled with a perpetual network-wide licensing scheme, OCSBC provides maximum flexibility to operators.

gnTel also chose NetAxis Solutions, an Oracle professional services partner, with deep technology competencies and experience, to design and implement their new service infrastructure.

“At gnTel, we recognize the fast pace of technology evolution in the telecom industry. We wanted to invest in a proven solution from a company that brings together expertise in cloud, virtualization, IT, and telecommunications,” said Onno Speekenbrink, gnTel. “Oracle’s solution and NetAxis Solution’s implementation will position us well for future growth.”

“Oracle’s cloud-ready session delivery solutions coupled with their extensive interoperability with third-party equipment and with our network monitoring software makes it simple for us to size, configure, deploy, and maintain the complex multi-vendor solution that gnTel requested,” said Bart van de Kar, NetAxis. “This project will further cement our expertise and relationship with Oracle.”

“In today’s marketplace, operators are looking for long-term, cost-effective and verified solutions that can improve their agility, streamline operations and accelerate time to market,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “Oracle Communications SBC provides CSPs, such as gnTel, the unconstrained flexibility that supports their efforts now and in the future.”

To learn more about Oracle Communications solutions, please connect on Twitter @OracleComms and at www.youtube.com/user/OracleCommunications, or visit oracle.com/communications.

To learn more about NetAxis Solutions, please visit http://www.netaxis.be/.

For further information about gnTel please visit http://www.gntel.nl/en.

Contact Info
Katie Barron
Kristin Reeves
Blanc & Otus
About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at http://cloud.oracle.com.


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

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.415.856.5145

State University of New York Selects Oracle Cloud at Customer to Modernize the Learning Experience for Students and Staff

Oracle Press Releases - Wed, 2017-06-28 09:00
Press Release
State University of New York Selects Oracle Cloud at Customer to Modernize the Learning Experience for Students and Staff Largest University System in the U.S. Looks to Oracle Cloud to Fuel Innovation, While Managing Stringent Regulatory Mandates

Redwood Shores, Calif.—Jun 28, 2017

News Summary

Oracle today announced that State University of New York is modernizing its infrastructure with Oracle Cloud. The State University of New York (SUNY) is the largest comprehensive university system in the United States, with 64 institutions serving more than 1.3 million students. Leveraging Oracle Cloud at Customer, SUNY aims to digitally transform its IT infrastructure, while meeting stringent regulatory data requirements and improving services to its constituents. The solution was selected in conjunction with Mythics, a Platinum-level partner in the Oracle PartnerNetwork.

Because of regulatory concerns and state mandates, SUNY needed a cloud solution that would sit behind their firewall, while still offering all the modern capabilities of a public cloud offering. After a competitive review, SUNY chose the Oracle Cloud Machine and Oracle to lead its data center transformation. SUNY expects its individual institutions to adopt the Oracle Cloud Machine to run their public cloud initiatives while keeping sensitive data within their premises. Individual schools can leverage the Oracle Cloud Machine to provision virtual machines, replicate mission critical data for disaster recovery, and quickly stand-up development and test environments, which can help those schools to reduce their individual data center footprints and reduce operating costs.  

“SUNY is dedicated to continually innovating to deliver the best learning experiences for our students and modern, efficient services for our staff,” said, Mike Notarius, CIO of the State University of New York Information Technology Exchange Center (ITEC). “We are excited to stand up the Oracle Cloud at the State University of New York (SUNY) Information Technology Center (ITEC) and provide a public cloud experience within the SUNY Private Cloud.”

Leveraging Oracle’s Cloud PaaS and IaaS capabilities, Oracle Cloud Machine enables customers to innovate in the cloud, while keeping their data behind their firewall. With a comprehensive, integrated portfolio of platform services, the offering empowers users to innovate faster, increase productivity, and lower costs.

Contact Info
Katie Barron
Oracle PR
Kristin Reeves
Blanc & Otus
About Oracle

The Oracle Cloud delivers hundreds of SaaS applications and enterprise-class PaaS and IaaS services to customers in more than 195 countries while processing 55 billion transactions a day. For more information about Oracle (NYSE:ORCL), please visit us at http://cloud.oracle.com.


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

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.415.856.5145

Partner Webcast – The Rise of Chatbots: Oracle Intelligent Bot Service

"A chatbot is a computer program which attempts to maintain a conversation with a person". - Wikipedia Intelligent bots are computer programs that leverage artificial intelligence to...

We share our skills to maximize your revenue!
Categories: DBA Blogs

New CPADMIN Utility for Managing Concurrent Processing Now Available

Steven Chan - Wed, 2017-06-28 02:00

In Oracle E-Business Suite, concurrent processing simultaneously executes programs running in the background with online operations. When a user runs a report, a request to run the report is generated. The command to run the report is a concurrent request. The program that generates the report is a concurrent program. Concurrent programs are started by a concurrent manager.

A new CPADMIN command line utility for E-Business Suite 12.2 consolidates various utilities for concurrent processing into a single menu-based utility. This ADADMIN-style utility can be used for multiple tasks, including:

  • View Concurrent Manager status
  • Clean CP tables
  • Set Concurrent Manager diagnostics
  • Start, stop, or verify an individual Concurrent Manager
  • Rebuild Concurrent Manager views
  • Move request files
  • Analyze requests
  • Configure request log/out file directory locations

Complete details for running the new CPADMIN utility are published here:

Related Articles


Categories: APPS Blogs

Effects if WWV_FLOW_FILES table has the data cleared

Tom Kyte - Wed, 2017-06-28 01:06
Hello, This might be a simple question, but I wanted to be 100% sure that nothing will happen if the data is cleared from the WWV_FLOW_FILES table. Does this have any affect on anything major within Apex?
Categories: DBA Blogs

Autorestart a singleton database on Grid Infrastructure?

Tom Kyte - Wed, 2017-06-28 01:06
Good Afternoon, We have a grid infrastructure clustered environment that holds only singleton databases, so the instances are only active on one node. The instances are able to be started on other nodes, obviously. We have setup failover rules; ...
Categories: DBA Blogs

Delete a table from another schema after fetch cursor

Tom Kyte - Wed, 2017-06-28 01:06
Hi Guys, Iam fairly new to oracle and was asked a question in an interview about what happens when a table from another schema gets deleted by an user while the same table was used in a cursor by another user and the deletion happens before fet...
Categories: DBA Blogs

SQL Tuning Advisor- not really sure what it does

Tom Kyte - Wed, 2017-06-28 01:06
Good Morning, I am trying to understand what each of the three settings for the CBO really do. 1) There is the "normal", which allows the CBO to run as usual to create execution plans within a short time. 2) There is the Tuning Mode- Limit...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator