Feed aggregator

Golden Gate moving from Classic to Integrated

Senthil Rajendran - Thu, 2018-10-11 05:07
Golden Gate moving from Classic to Integrated was an option taken in one of our project to have better performance. A lot of effort was put to convert all the extract and replicate to Integrated mode and some optimization parameters were used but still there were not a significant performance improvement.

Then I took a different route to examine the AWR and ASH for the replicate processes. Wow our friend INDEXES. Since we were dealing with build load , some of the unwanted indexes were dropped and Golgen Gate was super fast. Both Integrated and Classic was having better performance. Post the build load we rebuild the indexes.

Better consult a Dr.DBA always.

ODC Appreciation Day: Oracle Cloud PSM Cli

Rittman Mead Consulting - Thu, 2018-10-11 03:11
 Oracle Cloud PSM Cli

Oracle Developer Community (ODC) Appreciation Day (previously know as OTN Appreciation Day) is a day, started from an initiative of Tim Hall, where everyone can share their Thanks to the Oracle community by writing about a favourite product, an experience, a story related to Oracle technology.

 Oracle Cloud PSM Cli

Last year I wrote about OBIEE Time Hierarchies and how they are very useful to perform time comparison, shifts, and aggregations.

This year I want to write about Oracle Paas Service Manager (PSM) Client!
I've already written a blog post about it in detail, basically Oracle PSM allows Oracle cloud administrators to manage their instances via command line instead of forcing them to use the Web-UI.

 Oracle Cloud PSM Cli

PSM Cli allows you to create an Oracle Analytics Cloud instance by just calling

psm analytics create-service -c <CONFIG_FILE> -of <OUTPUT_FORMAT>

and passing a JSON <CONFIG_FILE> which can easily be downloaded after following the creation process in the Web-UI, a bit like the response file in on-premises OBIEE can be saved and customised for future reuse after the first UI installation. Examples of the PSM JSON payloads can be found here.

OAC Instances can also easily be started/stopped/restarted with the command

psm analytics start/stop/restart -s <INSTANCE_NAME>

And the status of each command tracked with

psm analytics operation-status -j <JOB_ID>

As mentioned in my previous post, PSM Cli opens also the doors for instance management automation which is a requirement for providing cost-effective fully isolated feature-related OAC instances useful when thinking about DevOps practices. The fact that PSM Cli is command line, means that it can be integrated in any automation tool like Jenkins and thus integrated in any DevOps flow being designed in any company.

So Thank you, Oracle, for enabling such automation with PSM Cli!

Follow the #ThanksODC hashtag on Twitter to check which post have been published on the same theme!

Categories: BI & Warehousing

procedure having out parameter of clob type, how we will see the value of it?

Tom Kyte - Thu, 2018-10-11 00:46
procedure having out parameter of clob type, how we will see the value of it,please advise? Hello Tom, we are having one procedure as below: PROCEDURE P1 ( p_dat_file_name out varchar2, p_zip_file_name out varchar2, p_metad...
Categories: DBA Blogs

Join me at Oracle OpenWorld

David Haimes - Wed, 2018-10-10 18:41

In under two weeks Oracle will have it’s annual conference here in San Francisco and it should be a very exciting time.  I will be talking about Blockchain technology and how it is applicable to Enterprise Applications and business processes, with a particular focus on ERP applications.

I will also be putting my faith in the conference WiFi and showing some demos of prototypes we are working on.

My session details are below, last year my session was full so I advise you to register (here) as soon as possible to be sure you get a spot.

Blockchain Applications Use Cases and Live Demos [PRO6215]

In this session learn where Blockchain can add real business value and how it fits into existing enterprise business applications ecosystems. See the types of patterns across multiple industries, including real-world examples. The session also includes live demos of a number of Blockchain applications.


David Haimes, Senior Director, Oracle

Wednesday, Oct 24, 11:15 a.m. – 12:00 p.m. | Moscone South – Room 154

Categories: APPS Blogs

Discover Oracle University Training at Oracle OpenWorld

Chris Warticki - Wed, 2018-10-10 17:25

Over 57%[1] of IT decision makers see training as important to mitigating the skills gaps they now face.

Technology is changing and skills gaps are widening. Are you ready for the challenge?

Oracle OpenWorld provides avenues for you to network and learn about new products and services. It also provides you with the opportunity to speak with Oracle product experts and to gain new skills or brush-up on the ones you already have.

As part of Oracle’s Support Services organization, Oracle University is excited to offer you a variety of ways to expand your product knowledge while at Oracle OpenWorld or Code One.

New this year:  Free “Deep Dive” training sessions! These sessions provide four hours of in-depth product training taught by our expert Oracle instructors.

Take a look at these FREE topic sessions offered to Oracle OpenWorld and Code One attendees:

Need something shorter? Visit the Oracle University theatre within the Exchange in Moscone South. We will be running a series of short “how to” product training sessions to help you advance your skill set.

Want to talk to Oracle University about your training and certification needs? Stop by the Oracle Support Stars Bar to talk to Oracle University and other support experts from across Oracle’s product portfolio.

Make the most of your OpenWorld trip with training at OpenWorld! Reserve your seat today at education.oracle.com/oow.

Find all the Oracle Support and Services sessions, activities and events on the Support and Services Oracle OpenWorld page.


One Click Access on the Shop Floor to Part Information with PTC ThingWorx® Navigate®

Shop floor technicians and operators involved in assembly and other processes are at the critical, final steps in the manufacturing process. Unfortunately, these workers are often at the mercy of out of date, less than accurate paper documentation, or they need to access multiple systems to find associated parts information. These issues create bottlenecks that can impact quality and on time shipments, as well as lead to employee frustration.

The following is a summary of the problems Fishbowl Solutions has seen at customers when it comes to accessing parts information needed for assembly:

  • Having the design engineers create manufacturing documentation, print it, and deliver physical copies to shop floor workers
  • Storing associated parts information on a network drive, making it hard to find for shop floor staff but especially new workers
  • Quality alerts and other processes are not integral with any systems
  • Parts information contained within PDFs requires excessive scrolling to get to the information needed
  • The MPMLink viewer requires multiple clicks to get to relevant parts information

To solve these problems, Fishbowl has worked with customers to leverage PTC ThingWorx to build shop floor viewing applications that can surface up relevant information to workers in one, simple view.

To read the rest of this blog post and see sample screenshots of the shop floor viewing application, please click over to the PTC LiveWorx 2019 blog.

The post One Click Access on the Shop Floor to Part Information with PTC ThingWorx® Navigate® appeared first on Fishbowl Solutions.

Categories: Fusion Middleware, Other

Hybrid Fake

Jonathan Lewis - Wed, 2018-10-10 09:12

Oracle 12c introduced the “Hybrid” histogram – a nice addition to the available options and one that (ignoring the bug for which a patch has been created) supplies the optimizer with better information about the data than the equivalent height-balanced histogram. There is still a problem, though, in the trade-off between accuracy and speed: just as it does with height-balanced histograms when using auto_sample_size Oracle samples (typically) about 5,500 rows to create a hybrid histogram, and the SQL it uses to generate the necessary summary is essentially an aggregation of the sample, so either you have a small sample with the risk of lower accuracy or a large sample with an increase in workload. This being the case it’s worth knowing how to create a hybrid histogram using the dbms_stats.set_column_stats() API.

It’s fairly easy to identify the cases where a hybrid histogram could be helpful.  You have a large volume of data spread over a large number (more than 2048) of distinct values, but a few values (typically less than 250) which are responsible for a significant fraction of the data. You would like to tell Oracle about the special “extreme” cases so that the optimizer can take defensive if you query for one of those values, but at the same time you would like to give Oracle a picture of the way the rest of the data is distributed. This is similar in some respects to the Top-N (a.k.a. Top-Frequency) histogram which says to Oracle “We have a small number of popular values, and some odds and ends on the side that are pretty ignorable”, the critical difference is that you need the hybrid histogram when it’s not safe to “ignore” the odds and ends.

Here’s an example of creating some data and then generating a completely artificial hybrid histogram. The code demonstrates 3 points – the principle feature of creating hybrid histograms and a couple of generic details about Oracle’s histograms:

  • The main point is that Oracle 12c introduces a new numeric array in the dbms_stats.statrec structure. This allows each row (bucket) in a histogram to hold a second statistic about the bucket so we can now store a frequency figure for the bucket as a whole, and a “repeat-count” figure for the highest value in the bucket. (Warning – there is a counter-intuitive conflict between the name of the new structure and the way it is used for hybrid histograms).
  • As side-point I’ve included a code variation that shows you the remarkable similarity between generating a Frequency histogram and a Hybrid histogram.
  • As a second side-point I have also highlighted the effect you see in the dba_tab_histograms view when your popular values are “too similar” to each other – i.e. when they match on the first 6 characters.

We start by creating a table as a copy of the view all_objects – then we’re going to create a hybrid histogram on the object_type column that looks nothing like the  data. The histogram will say:

  • for every 15,000 rows (where the column is not null)
    • 5,000 will have values less than or equal to ‘C’, of which 3,000 will have the value ‘C’
    • The next 2,000 (i.e. running total 7,000) will have values greater than ‘C’ and up to ‘PPPPPP1’, but ‘PPPPPP1’ itself is not a popular value
    • The next 2,000 (i.e. running total 9,000) will have values greater than ‘PPPPPP1’ and up to ‘PPPPPP2’, but ‘PPPPPP2’ itself is not a popular value
    • The next 2,000 (i.e. running total 11,000) will have values greater than ‘PPPPPP2’ and up to ‘PPPPPP3’, but ‘PPPPPP3’ itself is not a popular value
    • The last 4,000 (i.e. running total 15,000) will have values greater than ‘PPPPPP3’ and up to ‘X’ of which 3,000 will have the value ‘X’

Note particularly that the “how many rows hold the endpoint value” are stored in the statrec.bkvals array – just as they would be for a frequency histogram – and the cumulative count of rows is stored in the statrec.rpcnts structure. All we have to do to create a frequency histogram instead of a hybrid histogram is to store zeros in the statrec.rpcnts structure, or leave it uninitialized.

You’ll notice that since I’m creating a histogram on a character column I’ve used an array of type dbms_stats.chararray to hold the list of values (in ascending order) that I want the histogram to describe.

rem     Script:         12c_hybrid_histogram_2.sql
rem     Author:         Jonathan Lewis
rem     Dated:          June 2018

create table t1
select * from all_objects

                ownname         => null,
                tabname         => 't1',
                method_opt      => 'for all columns size 1'

                c_array         dbms_stats.chararray;
                m_rec           dbms_stats.statrec;
                m_distcnt       number;
                m_density       number;
                m_nullcnt       number;
                m_avgclen       number;

                ownname         => user,
                tabname         => 'T1',
                colname         => 'OBJECT_TYPE', 
                distcnt         => m_distcnt,
                density         => m_density,
                nullcnt         => m_nullcnt,
                srec            => m_rec,
                avgclen         => m_avgclen

        m_rec.epc    := 5;

        c_array      := dbms_stats.chararray( 'C',  'PPPPPP1',  'PPPPPP2',  'PPPPPP3',   'X');
        m_rec.bkvals := dbms_stats.numarray (3000,          1,          1,          1,  3000);

        m_rec.rpcnts := dbms_stats.numarray (5000,       7000,       9000,      11000, 15000);
--      m_rec.rpcnts := dbms_stats.numarray (0000,       0000,       0000,       0000, 00000);

        dbms_stats.prepare_column_values(m_rec, c_array);

                ownname         => user,
                tabname         => 'T1',
                colname         => 'OBJECT_TYPE', 
                distcnt         => m_distcnt,
                density         => m_density,
                nullcnt         => m_nullcnt,
                srec            => m_rec,
                avgclen         => m_avgclen

That’s it – it’s remarkably simple. To show the effect of running this code I can report the content of user_tab_histograms for the column. I’ve actually run the code and queried the results twice; first for the case where I created the hybrid histogram and then after modifying the PL/SQL block to set the rpcnts array to zeros to create a frequency histogram.

column endpoint_actual_value format a22
column endpoint_value        format 999,999,999,999,999,999,999,999,999,999,999,999

        endpoint_number, endpoint_value, endpoint_actual_value, endpoint_repeat_count
        table_name = 'T1'
and     column_name = 'OBJECT_TYPE'
order by

With non-zero rpcnts (hybrid histogram)
--------------- ------------------------------------------------ ---------------------- ---------------------
           3000  347,883,889,521,833,000,000,000,000,000,000,000 C                                       3000
           7000  417,012,704,559,973,000,000,000,000,000,000,000 PPPPPP1                                    1
           9000  417,012,704,559,973,000,000,000,000,000,000,000 PPPPPP2                                    1
          11000  417,012,704,559,973,000,000,000,000,000,000,000 PPPPPP3                                    1
          15000  456,922,123,551,065,000,000,000,000,000,000,000 X                                       3000

With rpcnts set to zero (frequency histogram)
--------------- ------------------------------------------------ ---------------------- ---------------------
           3000  347,883,889,521,833,000,000,000,000,000,000,000 C                                          0
           3001  417,012,704,559,973,000,000,000,000,000,000,000 PPPPPP1                                    0
           3002  417,012,704,559,973,000,000,000,000,000,000,000 PPPPPP2                                    0
           3003  417,012,704,559,973,000,000,000,000,000,000,000 PPPPPP3                                    0
           6003  456,922,123,551,065,000,000,000,000,000,000,000 X                                          0

I made a comment earlier on that the naming and use of the rpcnts structure was somewhat counter-intuitive. As you can see in the results above, when I created the hybrid histogram the values I stored in the rpcnts structure are not the values reported as the “repeat count”, the numbers reported as the “repeat count” are from the bkvals (bucket values).  As far as I’m concerned this means I have to go back to my basic examples every time I want to fake a histogram because I’m never too sure which arrays I should populate with what values – and whether I should use absolute or cumulative values.

One last minor point: you’ll see that the endpoint_actual_value has been populated in this example. This is because (with Oracle’s interesting transformation from character to numeric) the three ‘PPPPPPx’ character values turn into the same number – so Oracle stores the first 64 bytes (or 32 for versions of Oracle prior to 12c) of the actual value.


Oracle Offline Persistence Toolkit - Applying Server Changes

Andrejus Baranovski - Wed, 2018-10-10 09:00
This is my final post related to Oracle Offline Persistence Toolkit. I will show simple example, which explains how to apply server changes, if data conflict comes up. Read previous post about - Oracle Offline Persistence Toolkit - Submitting Client Changes.

To apply server changes is easier, than to apply client changes. You need to remove failed request from sync queue and fetch server data to client by key.

Example of data conflict during sync:

User decides to cancel his changes and bring data from the server. GET is executed to fetch latest data and push it to the client:

In JS code, first of all we remove request from sync queue, in promise we read key value for that request and then refetch data:

Download sample code from GitHub repository.

Eye, Eye, Cap’n

Jonathan Lewis - Wed, 2018-10-10 08:00

By the time you read this I will have had the lenses in both my eyes replaced, so I won’t be staring at a computer screen for a while – and that means, in particular, I won’t be doing any further investigation into join cardinality for a while.

For those who might otherwise feel deprived of my exquisite prose I have, however, prepared a couple of lightweight articles for automatic launching over the next few days. But please don’t expect any prompt follow-ups if you add comments or send email over the next couple of weeks.

Oracle and LinkedIn Collaborate to Improve Candidate and Employee Experience

Oracle Press Releases - Wed, 2018-10-10 07:00
Press Release
Oracle and LinkedIn Collaborate to Improve Candidate and Employee Experience Expanded relationship helps organizations address the challenges of today’s rapidly changing global talent marketplace

Redwood Shores, Calif.—Oct 10, 2018

Oracle and LinkedIn today announced that they are working together to help HR professionals meet the shifting demands of the talent economy. A series of new integrations between Oracle’s Human Capital Management Cloud (Oracle HCM Cloud) and Taleo Enterprise Edition, and LinkedIn, will help HR teams attract, engage and retain employees by growing their talent pool, improving the candidate experience, enhancing internal mobility and increasing career development opportunities.

“The world of work is rapidly changing, and this is creating new opportunities and challenges for talent leaders,” said Scott Roberts, Vice President of Business Development, LinkedIn. “We are excited to be working with Oracle to create better solutions to make hiring and developing talent as seamless and effective as possible.”

Technology continues to transform the global talent marketplace with the rise of automation and the shrinking shelf life of skills. To successfully manage these changes and address escalating recruitment costs and increasing employee turnover, HR teams need to swiftly evolve their strategies and technologies. The new integrations between LinkedIn and Oracle HCM Cloud and Taleo Enterprise Edition address this need by enabling HR teams to take a holistic view of their talent’s experience, skills and career aspirations in order to achieve a meaningful alignment between each employee’s job responsibilities and an organization’s overall business objectives. 

“The rapidly changing global talent market is forcing organizations across industries to rethink how they attract, engage and retain employees,” said Nagaraj Nadendla, Group Vice President, Product Development, Oracle. “Navigating these changes is one of the biggest challenges organizations face today and requires HR teams to take a holistic view of the candidate and employee experience. Working closely with LinkedIn, we are uniquely placed to help HR teams meet heightened candidate and employee expectations by combining future-proofed Oracle HCM Cloud and Taleo Enterprise platforms with one of the world’s largest talent marketplaces.”    

The new integrations between Oracle HCM Cloud and LinkedIn include:

  • Talent Profile Import: Helps organizations enhance internal talent mobility by enabling employees to choose to import key elements of their LinkedIn profiles into their Oracle HCM Cloud Talent Profile. 

  • Recommended Matches and Embedded Search: Helps organizations streamline recruitment by enabling LinkedIn Recruiter seat holders to search LinkedIn members and see those that best match a job requisition or project within Oracle Recruiting Cloud and Taleo Enterprise Edition.

  • Referral Recommendations: Improves the candidate experience by enabling candidates to apply for a job via Oracle Recruiting Cloud or Taleo Enterprise Edition and identify and contact (via InMail) their LinkedIn connections who can best refer them for that job.

  • Recruiter System Connect: Provides a seamless and efficient recruiter experience by surfacing transactional recruiting data, from both Oracle Recruiting Cloud and Taleo Enterprise Edition, as well as LinkedIn, in LinkedIn Recruiter.

  • Deeper Integration with Oracle Learning Cloud: Increases career development opportunities through access to LinkedIn Learning courses, automatic course catalog integrations, and up-to-date insight on learner engagement within Oracle Learning Cloud.

Part of Oracle Cloud Applications, Oracle HCM Cloud enables HR professionals to simplify the complex in order to meet the increasing expectations of an ever-changing workforce and business environment. By providing a complete and powerful platform that spans the entire employee life cycle, Oracle HCM Cloud helps HR professionals deliver superior employee experience, align people strategy to evolving business priorities, and cultivate a culture of continuous innovation.

Contact Info
Simon Jones
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.

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, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

Talk to a Press Contact

Simon Jones

  • +1.415.202.4574

Survey Highlights 5G Adoption as Catalyst for Advanced Digital Service Ecosystems

Oracle Press Releases - Wed, 2018-10-10 07:00
Press Release
Survey Highlights 5G Adoption as Catalyst for Advanced Digital Service Ecosystems Oracle Study Identifies Key Services Opportunities, Including Smart Cities and Connected and Autonomous Vehicles

Redwood Shores, Calif.—Oct 10, 2018

Digital services dominate the current and future strategies of telecoms and enterprise companies across industries, according to a new Oracle Communications survey. In the Digital Services: Disrupt or Be Disrupted report, Oracle found nearly all organizations surveyed (96 percent) have already implemented, or are planning to implement, digital services in the next 12 months. Almost half (45 percent) are looking to deploy digital customer engagement tools within their mobile apps and websites to further advance their digital transformation in the same timeframe.

In September 2018, Oracle surveyed 292 individuals with decision-making authority for IT and communications software in their companies. Seventy-three percent of respondents were at the President/CxO or Director/Department head level. A total of 18 industries, from 14 countries, were represented, with half of those surveyed from telecom and the other half from computer software/equipment, education, healthcare, and manufacturing.

“The digital opportunity is clearly recognized by companies across all industries,” said Doug Suriano, senior vice president, general manager, Oracle Communications. “While telecom companies have significant experience providing digital services, they face the challenge of delivering differentiated new revenue streams in an agile manner. Other industries, who in many cases are beginning to offer digital subscriptions and services enabled by physical products, also find they need more sophisticated and modern digital services monetization systems to capitalize on their digital opportunity.”

Racing to Deliver Improved Digital Experiences

5G will accelerate opportunities: When looking to the future of high-speed, real-time, sensor-enabled digital services, respondents indicated that sensor-driven services such as those for smart cities and connected and autonomous vehicles are the top two opportunities for digital service ecosystems enabled by 5G technology. The number of non-telecoms companies exploring smart cities opportunities will rise from 34 percent today to 50 percent when 5G is enabled. The connected and autonomous vehicle opportunity will rise from 29 percent today to 46 percent when 5G is enabled. This illustrates the cross-industry value for such digital service ecosystems enabled by 5G adoption.

Speed and agility are key: Ninety-one percent of respondents prioritize speed to market over a fully integrated IT environment, with 69 percent preferring a lightweight solution that can be deployed quickly over a fully featured solution that takes much longer to deploy. Speed to market is critical, with half believing that launching new digitally enabled services should take days – not weeks or months.

Not launching services reduces competitiveness and risks disruption: Almost two-thirds (65 percent) reported reduced revenue growth as the greatest concern of not launching digitally enabled services, followed by 55 percent who said they will be unable to competitively differentiate in the market. Half are concerned about loss of brand perception and relevance.

More sophisticated pricing models are essential: For companies to drive sustainable market differentiation and revenue growth, the survey indicated that more sophisticated pricing models for digital services beyond simple subscriptions will be essential. Companies recognized the importance of packaging and bundling multiple products and/or digital services to create more compelling propositions. Respondents also emphasized the importance of usage/consumption-based charging followed closely by outcome/performance-based charging for such propositions.

Contact Info
Katie Barron
Brent Curry
Hill+Knowlton Strategies
About Oracle Communications

Oracle Communications provides integrated communications and cloud solutions for Service Providers and Enterprises to accelerate their digital transformation journey in a communications-driven world from network evolution to digital business to customer experience. www.oracle.com/communications

To learn more about Oracle Communications industry solutions, visit: Oracle Communications LinkedIn, or join the conversation at Twitter @OracleComms.

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.

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Brent Curry

  • +1.312.255.9131

12c attribute clustering vs old index cluster

Tom Kyte - Wed, 2018-10-10 06:26
Hi, The attribute clustering works only for the direct path inserts? Will it support the normal inserts? If not whats the way to have the data in table stored in an ordered way especially for normal inserts (not direct path). Can you explain ...
Categories: DBA Blogs

SPACE GROWTH procedure for data volume calcualation for datawarehouse

Tom Kyte - Wed, 2018-10-10 06:26
Hi, I am currently working on the data sizing for each table to be loaded in a datawarehouse. Ref: https://docs.oracle.com/cd/E11882_01/doc.112/e26211/app_size.htm#DMAOG301 I have seen a procedure from https://docs.oracle.com/database/121/AR...
Categories: DBA Blogs


Tom Kyte - Wed, 2018-10-10 06:26
Hi, I am trying to use the script below to analyze the data consumed for a table since I am planning the storage capacity for a datawarehouse. Using this value(for every table), I will then be able to plan data for 18 months. I am writing a scrip...
Categories: DBA Blogs

Generate formatted excel and pdf report in apex

Tom Kyte - Wed, 2018-10-10 06:26
Please tell us the options for generating the formatted excel and pdf reports in apex. It is helpful if opensource option.
Categories: DBA Blogs

difference with blocks from DBA_SEGMENTS and Blocks From TSQ$

Tom Kyte - Wed, 2018-10-10 06:26
I have a schema and I look for the size by using the following <code> select segment_type,sum(blocks) from dba_segments where owner='W_GBA_000' group by segment_type; </code> SEGMENT_TYPE SUM(BLOCKS) ------------------ ----------- LOBIN...
Categories: DBA Blogs

How does insert and delete use space regarding to indexes?

Tom Kyte - Wed, 2018-10-10 06:26
Hello Tom I have such as test: SQL> create table t as select * from dba_objects; Table created. SQL> desc t Name OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP ...
Categories: DBA Blogs

Gather Index Stats ve Rebuild Index

Tom Kyte - Wed, 2018-10-10 06:26
Hi Team, We encountered production issue related 100% CPU usage. New script introduced that was rebuilding indexes on table having size 450GB with parallel degree 8. I read one arrival on asktom where they explained rebuild recreates the Ind...
Categories: DBA Blogs

Oracle and NVIDIA Bring the Power of the Cloud to the Next Generation of Analytics, Machine Learning and AI

Oracle Press Releases - Wed, 2018-10-10 05:00
Press Release
Oracle and NVIDIA Bring the Power of the Cloud to the Next Generation of Analytics, Machine Learning and AI First public cloud provider to support NVIDIA HGX-2 to give customers access to a unified data science, HPC and AI computing architecture

Munich, Germany – GPU Technology Conference—Oct 10, 2018

Oracle (NYSE:ORCL) and NVIDIA (NASDAQ: NVDA) today announced that Oracle is the first public cloud provider to support the NVIDIA HGX-2TM platform on Oracle Cloud Infrastructure, to meet the needs of the next generation of analytics, machine learning and AI. The companies are also announcing the general availability of support for GPU-accelerated deep learning and HPC containers from the NVIDIA GPU Cloud™ (NGC) container registry on Oracle Cloud Infrastructure.

From enabling autonomous vehicles to driving global climate simulations, rapid progress in AI and HPC has transformed entire industries while also demanding massive increases in complexity and compute power. HGX-2 is designed for multi-precision computing to accelerate the most demanding applications by unleashing 2 petaflops of computing power and half a terabyte (TB) of total GPU memory with 16 NVIDIA Tesla® V100 Tensor Core GPUs interconnected with NVSwitch™. Supporting HGX-2 on both Oracle Cloud Infrastructure bare-metal and virtual machine instances, Oracle and NVIDIA are helping customers solve the greatest AI and HPC challenges for the most complex workloads.

Oracle is also announcing support for RAPIDS™ open-source software introduced today by NVIDIA for executing end-to-end data science training pipelines accelerated on NVIDIA GPUs. RAPIDS is now generally available on Oracle Cloud Infrastructure via NGC. RAPIDS dramatically accelerates data science pipelines by moving workflows onto the GPU. This optimizes machine learning training with more iterations for better model accuracy. Data scientists can quickly integrate RAPIDS with hassle-free integration and minimal code changes, enabling them to significantly accelerate the Python data science toolchain. With this new offering and support for NGC containers, Oracle and NVIDIA are allowing customers to easily deploy containerized applications and frameworks for HPC, data science and AI and run them seamlessly on Oracle Cloud Infrastructure.

Oracle Cloud Infrastructure is also working with NVIDIA to support RAPIDS across its platform, including the Oracle Data Science Cloud, to further accelerate customers’ end to-end data science workflows. RAPIDS software runs seamlessly on the Oracle Cloud, allowing customers to support their HPC, AI and data science needs, all while taking advantage of the portfolio of GPU instances available on Oracle Cloud Infrastructure.

“We are very excited about this collaboration with NVIDIA. As the world of computing continues to push the boundaries of what’s possible, we are providing our customers with the software, tools and cloud infrastructure needed to solve the most complex challenges,” said Clay Magouyrk, senior vice president, software development, Oracle Cloud Infrastructure. “Whether you are an engineer, data scientist, researcher or developer, we are bringing the power of compute and cloud to your fingertips.

“This new collaboration with Oracle will help fuel incredible innovation across a wide range of industries,” said Ian Buck, vice president and general manager of Accelerated Computing at NVIDIA. “By taking advantage of NVIDIA’s latest technologies, Oracle is well positioned to meet surges in demand for GPU acceleration for deep learning, high-performance computing, data analytics and machine learning.”

Contact Info
Danielle Tarp
Kristin Bryson
About Oracle Cloud Infrastructure

Oracle Cloud Infrastructure is the enterprise Infrastructure as a Service (IaaS) platform. Companies of all sizes rely on Oracle Cloud to run enterprise and cloud native applications with mission-critical performance and core-to-edge security. By running both traditional and new workloads on a comprehensive cloud that includes compute, storage, networking, database, and containers, Oracle Cloud Infrastructure dramatically increases operational efficiency and lowers total cost of ownership. For more information, visit https://cloud.oracle.com/iaas

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.


NVIDIA’s (NASDAQ: NVDA) invention of the GPU in 1999 sparked the growth of the PC gaming market, redefined modern computer graphics and revolutionized parallel computing. More recently, GPU deep learning ignited modern AI—the next era of computing—with the GPU acting as the brain of computers, robots and self-driving cars that can perceive and understand the world. More information at http://nvidianews.nvidia.com/.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. NVIDIA and the NVIDIA logo are trademarks and/or registered trademarks of NVIDIA Corporation in the U.S. and other countries. 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, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

Certain statements in this press release including, but not limited to, statements as to: the benefits and impact of Oracle supporting the NVIDIA HGX-2 platform on Oracle Cloud Infrastructure and supporting RAPIDS; and the benefits, impact, and features of HGX-2 and RAPIDS software are forward-looking statements that are subject to risks and uncertainties that could cause results to be materially different than expectations. Important factors that could cause actual results to differ materially include: global economic conditions; our reliance on third parties to manufacture, assemble, package and test our products; the impact of technological development and competition; development of new products and technologies or enhancements to our existing product and technologies; market acceptance of our products or our partners’ products; design, manufacturing or software defects; changes in consumer preferences or demands; changes in industry standards and interfaces; unexpected loss of performance of our products or technologies when integrated into systems; as well as other factors detailed from time to time in the reports NVIDIA files with the Securities and Exchange Commission, or SEC, including its Form 10-Q for the fiscal period ended July 29, 2018. Copies of reports filed with the SEC are posted on the company’s website and are available from NVIDIA without charge. These forward-looking statements are not guarantees of future performance and speak only as of the date hereof, and, except as required by law, NVIDIA disclaims any obligation to update these forward-looking statements to reflect future events or circumstances.

Talk to a Press Contact

Danielle Tarp

  • +1.650.506.2905

Kristin Bryson

  • +

Few Exadata MOS Docs to review

Syed Jaffar - Wed, 2018-10-10 04:20
If you have MOS login credentials and managing Exadata database machines, below is the list of few MOS Doc which is worth reading:

  • 888828.1, "Exadata Database Machine and Exadata Storage Server Supported Versions"
  • 1070954.1, "Oracle Exadata Database Machine Exachk or HealthCheck"
  • 1353073.2, "Exadata Diagnostic Collection Guide"
  • 1500257.1, " Exadata Write-Back Flash Cache - FAQ"
  • 1553103.1, "dbnodeupdate.sh and dbserver.patch.zip: Updating Exadata Database Server Software using the DBNodeUpdate Utility and patchmgr"
  • 1589868.1, "Procedure to check for corrupted root file system on Exadata Storage Servers and Linux database servers"


Subscribe to Oracle FAQ aggregator