Feed aggregator

#OOW16: What You Must Add to Your Agenda

WebCenter Team - Fri, 2016-09-16 09:42

We can't believe that OpenWorld is just days away. As you can tell from the past month, we've been working hard on getting sessions, demos, hands on labs and a slough of various other things ready in preparation for the event. We are excited to see familiar faces next week and meet new contacts as well! We wanted to highlight some of the "must add" things to your agenda.

Must Attend Sessions:
Don’t miss the Strategy and Vision sessions for the overall Content and Experience Management portfolio and each of the respective solution and cloud technologies. Attendees will also get an opportunity to hear from customer organizations on implementation successes.

Monday, Sep 19

  • Content and Experience Management: Roadmap and Vision  [CON7256]
    • 11:00 a.m. - 11:45 a.m. | Moscone West—2014
  • Oracle Process Cloud Service: Digital Process Apps Made Simple [HOL7613]
    • 11:00 a.m. - 12:00 p.m. | Hotel Nikko—Nikko Ballroom III (3rd Floor)
  • Content Management in the Cloud: Strategy & Roadmap [CON7257]
    • 12:30 p.m. - 1:15 p.m. | Moscone West—2014
  • Digital Experience in the Cloud: Strategy & Roadmap [CON7258] 
    • 1:45 p.m. - 2:30 p.m. | Moscone West—3000
  • Create an Employee Portal Using Oracle Documents Cloud Service/Oracle Sites Cloud Service [HOL7607]
    • 2:30 p.m. - 3:30 p.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)

Tuesday, Sep 20

  • Drive Productivity in Your Enterprise with Oracle Documents Cloud Service [HOL7611]
    • 8:00 a.m. - 9:00 a.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)
  • WebCenter Content, Imaging, Capture & Forms Recognition: Roadmap & Strategy [CON7259]
    • 4:00 p.m. - 4:45 p.m. | Moscone West—2014
  • Oracle WebCenter Digital Experience: Sites & Portal Strategy and Roadmap [CON7260]
    • 5:15 p.m. - 6:00 p.m. | Moscone West—2014

    Wednesday, Sep 21

    • Deep Dive into Oracle's Content and Experience Cloud Platform [HOL7612]
      • 11:30 a.m. - 12:30 p.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)
    • Cox Enterprises Reimagines the Digital Workplace with Oracle WebCenter [CAS4789] 
      • 3:00 p.m. - 3:45 p.m. | Marriott Marquis—Golden Gate C3

    Thursday, Sep 22

    • Create Rich Solution Templates with Oracle's Content and Experience Cloud Platform [HOL7616]
      • 9:45 a.m. - 10:45 a.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)

    There are PaaS General Sessions and many more sessions highlighting customer successes, product deep dives, partner discussions, persona and/or industry based discussions, Cloud/PaaS lessons, live product demonstrations and Hands-On-Labs (HOL) sessions so do bookmark the following links for a complete, up to date listing:

    My Schedule is available for Oracle OpenWorld! Customer and partner attendees can use My Schedule to plan and optimize their time during the conferences by building personalized conference schedules beforehand. We recommend adding the sessions mentioned above and the others of interest from the Focus on Documents listed above.

    Content and Experience Management Auxiliary Events at OOW
    In addition to regularly scheduled programs of sessions, hands-on labs and demos, we have planned additional events for our customers and partners to network with their peers. These auxiliary events include:

    • Innovation Awards Ceremony | Tuesday 9/20 | 4:00pm – 6:00pm | YBCA Theater | Event Contact | OOW Registration Required
    • Oracle Appreciation Event at OOW16 with Billy Joel, Sting & Gwen Steffani | Wednesday 9/21 | 7:00pm – 11:00pm | Event Information

    Oracle OpenWorld Content and Experience Management Website
    At this year’s Oracle OpenWorld, you will have a much more simplified and engaging experience, from any device – web, phone, tablet! The Oracle OpenWorld Content and Experience Management website is the ONLY link you will need to keep tabs on all things Digital Experience at Oracle OpenWorld 2016. You will find information on the upcoming sessions, the day’s agenda, ready information on Hands-on-Labs, Demo locations and hours, and more. Live twitter feed and pictures will allow you to experience the conference in real time. The site is mobile-first so you can enjoy a rich, dynamic mobile experience. They say…you have to experience it to believe it, and @ #OOW16 you will get your chance! Please bookmark this website to stay in the know of all things #OracleDX at #OOW16. https://sites.oracle.com/oowdx

    Mobile Challenge App Game
    The #OOW16 Mobile Experience will include an interactive, Pokémon Go-styled, mobile app that was built using Oracle Mobile Cloud Service, through which you can win prizes. More details can be found here!

    Social Media Communications
    We will be highlighting our key sessions and other important information on the Oracle DX blog periodically. In addition, please use the following hashtags to discuss OOW on your respective channels!

    • #OOW16 | #OracleDX 

    And we are asking you to please follow along and join the conversations on our social media channels.

    We are looking forward to a successful #OOW16!

    Wait event

    Tom Kyte - Fri, 2016-09-16 07:46
    Hi team, Can you pls brief me regarding this wait event because i have continuously and every time getting this event. So pls let me know what is the meaning of this event and how to resolve this what is the solution of this event. EVENT ...
    Categories: DBA Blogs

    how to recover table with out backup

    Tom Kyte - Fri, 2016-09-16 07:46
    Hi Tom, one table is dropped, there is no backup and no flashback enable, then how can we restore the table. thanks.
    Categories: DBA Blogs

    Audit commit delay

    Tom Kyte - Fri, 2016-09-16 07:46
    Hi team, Every day we got some alert like - AUD: Audit Commit Delay exceeded, written a copy to OS Audit Trail Could you pls let us know what is this and how to resolve this ? thanks
    Categories: DBA Blogs

    The dbi Open Infrastructure Technology Division

    Yann Neuhaus - Fri, 2016-09-16 07:37

    As you already might know dbi (on a technical level) is organized into several technology divisions. Traditionally there is one for Oracle, one for Microsoft and one for Middleware products. Almost a year ago a new technology division was born to reflect the new requirements we see on the market. This does not mean that we did not provide expertise in these areas before but the goal was to more clearly organize ourself for being able to rapidly adopt new technologies and provide the best expertise for our current and future customers. In this post I’ll take a look at our Open Infrastructure Technology Division. What is it about, what do we believe in and what you can expect now and in the future.

    To start with: What do we call a technology division? As the name already adumbrates it is all about technology. You could also say: The technology division are the heart of dbi. This is where people work on the different technologies, organize technical events, do researching, define and plan new workshops, adopt new products and have lots of fun. Each of these technology divisions is led by a so called technology leader who is responsible for his technology division. Currently dbi supports four of these divisions which reflect the areas we work in:

    to-organization-overview

    On the top there is Hervé who is our CTO and then we have the four technology divisions:

    • We have Franck who is responsible for all aspects around the Oracle database
    • We have Stéphane who is responsible for the Microsoft stuff
    • We have Gérard who is responsible for everything around the middleware products we support
    • And finally we have the Open Infrastructure Technology Division which I am happy to represent

    A very important point to notice here is that each of these divisions is cross connected to every other. We are not working in isolated silos but do work together wherever we can. Nowadays you can never be sure what happens and things have recently happened you never thought would be possible in the past, e.g.

    … just to name a few. Do you know if you need a SQL Server expert on Linux tomorrow? Are you running Oracle on Windows? Are you planning to run Docker on Windows? These are just a few examples where you might need expertise which goes beyond the traditional “I only do Windows” or “I only do Oracle” way of working. This is what the technology divisions are there for: Build expertise inside the divisions but even more important build a kind of “backbone” where everyone can get help from others (inside and outside of dbi). Share what you learned, be open, be communicative, be mindful and have an open eye on what is going on around you. No matter which technology division you take: All of them share their knowledge by writing blogs, attending, organizing and speaking at events (e.g. DOAG 2016, Oracle Open World 2016, IT-Tage 2016, SWISS PGDay, PASS SQLSaturdays and many more), writing articles, creating hands-on workshops and even come together twice a year for exchanging knowledge across the technology divisions.

    So far for the overview (which is far longer that it intended to be, sorry). Lets focus on the Open Infrastructure Division from now on. Probably the most important point in any division is what it stands for, so what do we stand for? As you can see from the name the word “Open” plays a central role. We do not only believe in open source software but even more important believe that being and thinking open is key to success. There are plenty of wonderful open source projects out there, each of them having an active community and each of them supporting business critical applications. Our idea is not to favor one over another but rather selecting the right technology for the right requirement. This might range from one specific product to a whole set of products. This could even result in extending (or interfacing) a proprietary solution by open source solutions when it makes sense (remember the cross connected divisions described above).

    On the other hand we can not support the whole open source world because this is just not possible so we have to select a kind of technology set we want to focus on (more on that later). This set is and will be changing over time, we are absolutely aware of that. New technologies will come in, others will go out and some will stay. That’s the way of life. Important for us is the “Open Infrastructure” because when things change you need to adopt. When you keep your infrastructure open it is much more easy to adopt than when you have to adopt your closed systems. When you focus on real open standards, open formats and open software you are free to decide in which direction you want to go and even if it was the wrong decision you are not on a …

    traffic-sign-6727_960_720

    … you are free to adjust the direction :) This is more or less what we believe in and work on every day: Making infrastructures more open, easier to maintain, easier to adapt, faster to profit from and more fun to work with. Yes, work can be fun when you have the right tools and the right people to work with.

    Going deeper into our division what do we actually provide? We had various internal discussion about that and it was not easy to come to a final conclusion. Indeed there is no final set or conclusion but we do provide what we call a “core” set. This are our core technologies we currently work on, provide best practices, provide trainings for (some), provide consulting (all), provide SLAs (some), implement (all) and do reviews or feasibility studies (all). So, finally here they are (bottom up):

    On the Linux level:

    logo_redhat logo_centos logo_suse logo_debian logo_ubuntu

    On the rdbms level:

    logo_mariadb logo_postgresql logo_mysql

    On the NoSQL level:

    logo_mongodb logo_cassandra

    On the provisioning and deployment level:

    logo_ansible

    On the monitoring level:

    logo_nagios

    On the DevOps and OpenStack level:

    logo_atomichost logo_docker logo_mirantis

    This are quite a few but not too much technologies. As already stated somewhere above we do not provide everything for every product but we are constantly extending our knowledge and best practices so that products might be fully supported by us in the future which are not today. Other products we are working on are not even listed above (e.g. the E(astic search) L(ogstash) K(ibana) stack). Believe me: It is really hard to select the right tools for the right job: This is what we are here for.

     

    Cet article The dbi Open Infrastructure Technology Division est apparu en premier sur Blog dbi services.

    Oracle OpenWorld 2016 Delivers the Ultimate Cloud Experience

    Oracle Press Releases - Fri, 2016-09-16 07:00
    Press Release
    Oracle OpenWorld 2016 Delivers the Ultimate Cloud Experience Conference marks 20th year with a positive economic impact totaling $3.2 billion for the City of San Francisco

    ORACLE OPENWORLD, San Francisco, Calif.—Sep 16, 2016

    This weekend, Oracle welcomes thousands of customers, hundreds of partners, and millions of online attendees from more than 141 countries to Oracle OpenWorld 2016. This year’s ultimate cloud experience, which runs through September 22, brings together top technologists, world leaders, and innovators to share ideas about the future of technology and its impact on the way we live and work. A dynamic line-up of visionaries headline the event, spanning today’s brightest thinkers like best-selling author and educator Adam Grant; renowned economists including Moody’s Mark Zandi; and key political strategists Stephanie Cutter and Mike Murphy. At Oracle’s Customer Appreciation event, record-breaking performance artists Gwen Stefani and Sting take the stage at AT&T Park for an exclusive concert. Top-charting band American Authors kick off Oracle OpenWorld in a special performance at Oracle Cloud Plaza on Howard Street.

    On Sunday night, Oracle Executive Chairman of the Board and Chief Technology Officer Larry Ellison opens main stage conversations in a keynote about how Oracle innovations are transforming enterprise cloud computing and outlines his vision for the future of IT. Throughout the week, Ellison, Oracle CEO Safra Catz, Oracle CEO Mark Hurd and Oracle President of Product Development Thomas Kurian, will discuss today’s most critical topics, alongside some of the most powerful names in the world of technology and business.

    “Oracle OpenWorld 2016 focuses on the success of our customers,” said Judy Sim, Oracle’s Chief Marketing Officer. “Our approach is always to put our attendees first, and in doing so, we ensure that every aspect of the conference sparks learning, fosters networking, promotes innovation, and unites our customers and partners.”

    To Learn and Explore:
    • Sessions: choose from 2,240 sessions presented by 2,054 customer and partner speakers, 400 Oracle demos, as well as hundreds of partner and customer exhibitions.
    • Oracle Keynotes:
      • Sunday, 5:00 p.m. – Oracle Executive Chairman and Chief Technology Officer Larry Ellison leads with the future of Oracle Cloud.
      • Monday, 9:15 a.m. – Oracle CEO Mark Hurd shares his perspective on the future of technology and the world ahead, and speaks with leaders from top Oracle customers including Joanna Fielding, Chief Financial Officer, HSBC Technology and Services and Patrick Benson, Chief Information Officer, ClubCorp.
      • Tuesday, 8:30 a.m. – Oracle President of Product Development Thomas Kurian showcases new innovations across Oracle infrastructure, platform, applications and data.
      • Tuesday, 1:30 p.m. – Larry Ellison returns to the mainstage to discuss the future of cloud database and infrastructure.
      • Wednesday, 9:15 a.m. – John Fowler, Oracle Executive Vice President of Systems, leads an engaging session on database platforms of the future, featuring Juan Loaiza, Senior Vice President, Oracle Systems Technology, and Oracle Executive Vice President David Donatelli.
    • Oracle Partner Keynotes:
      • Sunday, 5:15 p.m. – 6:00 p.m. – Diane Bryant, Executive Vice President and General Manager of Intel’s Data Center Group, shares the technology innovations that Intel, Oracle, and Oracle partners are creating to deliver the next wave of enterprise opportunity.
      • Tuesday, 8:30 a.m. – 9:15 a.m. – Bhanu Murthy B.M., President and Chief Operating Officer, Wipro, outlines how cloud-powered enterprises are creating value and gaining competitive advantage in the new digital economy.
      • Tuesday, 1:30 p.m. – 2:15 p.m. – Dr. Vishal Sikka, Chief Executive Officer, Infosys, offers his thoughts on how business leaders can leverage artificial intelligence to drive agility and deliver new kinds of value for their companies and stakeholders.
    • Oracle Leader’s Circle: Learn from today’s top educators, economists, political scientists and industry thought leaders at this empowering two-day executive program hosted by Oracle CEOs Safra Catz and Mark Hurd.
    • Inclusive Leadership Summit: Hear from executives and thought leaders on the cutting edge, including social justice pioneer Billie Jean King, as they connect and share personal perspectives on how inclusive leadership advances employee engagement and increases innovation.
    • Collective Learning Pilot: Experience interactive sessions redesigned by Harvard Graduate School of Education’s Project Zero, which uses discussion, personal reflection and information sharing to solve attendees’ business challenges as a community.
    • Oracle Education Foundation’s Design Realization Garage: Get creative in hands-on, student-led innovation sessions and watch Design Tech High School (d.tech) students demo their technology prototypes created in Oracle Education Foundation workshops.
    To Support the Community and Environment:
    • Sustainability and Giving: Uncover a fresh take on food and beverage while enjoying local, organic, healthy food options. Eighty percent of the food at Oracle OpenWorld is sustainably sourced and prepared within 100 miles of Howard Street. Throughout the week of the event, Oracle will donate 7,275 meals to charities in San Francisco.
    • Plant a Billion Trees: Learn how The Nature Conservancy and Oracle save forests through donations to plant trees in the United States, Brazil and China that will sequester 290K metric tons of carbon. Oracle will donate $1 million over the next four years.
    • JavaOne4Kids: Take part in a one-of-a-kind children’s workshop to inspire the next generation of coders and developers, hosted by Oracle Academy.
    • Education: Participate in one of the many education-themed attractions and activities happening at the event. Learn more about Oracle’s $4 billion annual commitment to education and its positive impact on more than 3 million students in 110 countries annually through Oracle Academy, Oracle Giving, and Oracle Education Foundation.
    To Connect and Play:
    • ORACLE TEAM USA: Meet the America’s Cup champion sailors at Oracle Cloud Plaza on Howard Street and learn how Oracle technology is helping the team defend its title for a second time at the 35th America’s Cup in Bermuda.
    • The Café on Howard: Reserve seats for meetings, relaxation, networking and reflection.
    • Concerts: See best-selling recording artists, Gwen Stefani and Sting, and celebrate with Oracle customers and partners at the Oracle Appreciation Event in AT&T Park. Also, watch American Authors kick off Oracle OpenWorld in a special performance at the welcome reception on Howard Street.

    Following Oracle OpenWorld, Oracle Cloud Days will launch a three-month, 60-city tour showcasing the power of data-driven innovation and digital transformation.

      • Download Oracle OpenWorld (Android | Apple) and JavaOne (Android | Apple) mobile applications
      • Live Stream keynotes live from Oracle OpenWorld
      • Like Oracle OpenWorld on Facebook
      • Follow @OracleOpenWorld on Twitter for the latest #oow16
    Contact Info
    Julie Sugishita
    Oracle Corporate Communications
    1.650.506.0076
    julie.sugishita@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.

    About Oracle OpenWorld

    Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18–September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

    About JavaOne

    The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

    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. 

    Talk to a Press Contact

    Julie Sugishita

    • 1.650.506.0076

    Stats collection time

    Jonathan Lewis - Fri, 2016-09-16 06:58

    Yesterday I posted a note about querying dba_optstat_operations to get a quick report of how long calls to dbms_stats had been taking but said I had another script that helped to fill some of the gaps it left. One of my readers points out fairly promptely that 12c enhances the feature considerably, with a view dba_optstat_operation_tasks that (for example) lists all the tables processed during a single call to gather_schema_stats.

    Well, I wrote my script years (if not decades) before 12c came out, so I’m going to publish it anyway.

    It definitely falls into the quick and dirty category. It’s not trying to be clever, makes a critical assumption about the recent past, and isn’t a generally useful tool, but I’ve found it a quick way to highlight a possible problem with expensive stats collection routines (especially those written by 3rd parties who have disabled Oracle’s automatic job.)

    The concept is very simple: list all the tables in the order they were last analyzed and assume that for any “obviously continuous” stretch of time the start of stats collections for one table coincided with the end of stats collection for the previous one. A little fiddling with the lag() function then allows you to report the time spent on gathering the stats.

    rem
    rem     stats_check.sql
    rem
    rem     Quick and dirty to get an idea of
    rem     where the time went on the most
    rem     recent stats collection job.
    rem
    rem     Weakness: It assumes that the start
    rem     of stats collection of a table is the
    rem     end of stats collection for the previous
    rem     table.  This may be far from true.
    rem
    
    define m_schema = '&1'
    
    set linesize 144
    set pagesize 60
    set trimspool on
    
    column a_date format a20
    
    spool stats_check
    
    select
            table_name,
            blocks, num_rows, sample_size,
            round(100 * sample_size/nullif(num_rows,0),2)   sample_pct,
            to_char(last_analyzed,'dd-mon-yyyy hh24:mi:ss') a_date,
            to_char(
                    round(1440 *
                            (
                            last_analyzed -
                            lag(last_analyzed, 1) over (order by last_analyzed)
                            ), 2
                    ),'9,999.00'
            )                        a_time
    from
            dba_tables
    where
            owner = upper('&m_schema')
    order by
            last_analyzed
    ;
    
    spool off
    
    

    It’s a very simple script – one detail that’s quite useful is the presence of the data about table size and sample size. But that’s really only the starting point. If you’re gathering stats on a table then most of the time might be spent on gathering stats for histograms or indexes, so there’s plenty of scope to add bits to the script to report number of histograms per table, number of indexes per table, and so on. Personally I tend to do “incremental” trouble-shooting and keep my scripts (and their run time) short, so I’d only worry about specific details if I saw a headline figure that seemed worth a little more effort.

    Here’s some (camouflaged) output – which happens to highlight one of the weaknesses of the approach:

    TABLE_NAME              BLOCKS   NUM_ROWS SAMPLE_SIZE SAMPLE_PCT A_DATE                  A_TIME
    --------------------- --------  --------- ----------- ---------- --------------------  --------
    TABLE_AAA                    0          0           0            14-jul-2016 01:27:55       .00
    TABLE_BBB              6320666  540356865   108071373         20 14-jul-2016 02:30:45     62.83
    TABLE_CCC              9587372  930770535   186154107         20 14-jul-2016 03:36:13     65.47
    TABLE_DDD              2272319  104698080    20939616         20 14-jul-2016 04:19:45     43.53
    TABLE_EEE              4413696  258746720    51749344         20 14-jul-2016 04:49:13     29.47
    TABLE_FFF                    0          0           0            14-jul-2016 05:02:28     13.25
    TABLE_GGG              4377656  258740995    51748199         20 14-jul-2016 05:02:28       .00
    TABLE_HHH                    0          0           0            14-jul-2016 05:02:28       .00
    TABLE_III                   60         52          52        100 14-jul-2016 05:02:29       .02
    TABLE_JJJ                   60        170         170        100 14-jul-2016 05:02:30       .02
    TABLE_KKK                   60        100         100        100 14-jul-2016 05:02:30       .00
    TABLE_LLL                   60       5548        5021       90.5 14-jul-2016 05:02:31       .02
    TABLE_MMM                 4660     686575      137315         20 14-jul-2016 05:02:32       .02
    ...
    TABLE_TTT                    0          0           0            14-jul-2016 05:02:38       .00
    TABLE_UUU                   60        659         659        100 14-jul-2016 05:02:38       .00
    TABLE_VVV               325324   18618685     3723737         20 14-jul-2016 05:04:14      1.60
    TABLE_WWW                   60       1106        1106        100 14-jul-2016 05:06:01      1.78
    TABLE_XXX                24001    2534810      506962         20 14-jul-2016 05:06:13       .20
    TABLE_YYY                    0          0           0            14-jul-2016 05:06:20       .12
    TABLE_ZZZ                    0          0           0            14-jul-2016 05:06:20       .00
    
    

    You’ll notice that the zero row FFF table is reported to have taken 13.25 minutes for stats gathering, while the 4.3M row GGG table table took no time at all. That’s the problem of sorting by the last_analyzed time when it’s accurate only to the second and some tables take less than a second to gather stats. Clearly these two time estimates are the wrong way round. (WWW and XXX look fairly suspect too, but their timestamps are different so there must be some other explanation – but the time is too small to worry about at the moment.)

    Tables BBB and CCC are also an example of how variable the results are when you compare cost with time. Although the table and sample had twice the rows table CCC has fewer histograms and indexes. The same variation shows up clearly between EEE and GGG (after allowing for the order error), and slightly less immediately between DDD and all the other large tables.

    That brings me to one more threat of mis-interpretation (and a reason why I’m not terribly keen on publishing scripts that I’ve hacked together). If you see Oracle claiming (through this script) that it took no more than a couple of minutes to gather stats on a 5 billion row table it may be true – but maybe that stats collection was only related to gathering stats for a single, fairly new, partition in a partitioned table. There are, no doubt, several boundary cases that a simple script like this will have overlooked – and when I run it I’ll be at a client site with knowledge of the client database and I’ll spot the anomalies and omissions.


    Partner Webcast – Oracle Streams Analytics platform - Is it time to reverse traditional analytics?

    Real Time, Live, Immediate or Instant are all big keywords in everyday business. Oracle Stream Analytics (OSA) is a new tool, provided as a part of Oracle Event Processing technology platform. OSA is...

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

    Looking inside #OOW16 session: Empower the Mobile Workforce using Oracle Content and Experience Cloud (CON7271)

    WebCenter Team - Thu, 2016-09-15 16:00
    Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

    Mobile is transforming every facet of modern society. As a result, companies are finding that with the changing digital landscape, user’s expectations have changed, not just as a consumers but as employees too. The pervasiveness of digital technology and the convenience of it has permeated into our work world making line of business users more technology savvy, expecting digital convenience in the workplace as well.

    Along with this powerful trend Cloud is transforming every facet of the IT infrastructure so in a world where work is no longer dictated by location and spans not just geography but our ecosystem – employees, partners, suppliers and customers, as well as channels – web, mobile, social, how can you empower your users to drive effective mobile collaboration?

    At Oracle OpenWorld this year, Oracle executive and the product management lead for Oracle solutions for Digital Experience, David le Strat, would be discussing mobile collaboration in his overarching product strategy session on Monday, September 19 at 11 a.m. in Moscone W 2014. Learn more about his session here.

    From there, in this session, we will get into the detail roadmap and strategy on how we are focusing on empowering our millennial, mobile workforce with our content management and experience management solutions.

    So, if you are heading to Oracle OpenWorld next week, don’t miss:

    Empower the Mobile Workforce using Oracle Content and Experience Cloud [CON7271]

    Wednesday, September 21, 3 pm
    Moscone West—2018

    We’ll discuss how the Oracle Content and Experience Cloud can help companies empower their mobile workforce.

    Learn how Oracle Documents Cloud Service and Oracle Sites Cloud Service are providing you with a single platform to drive mobile content collaboration. We’ll be covering how our mobile features allow workers to carry out effective mobile collaboration and design mobile optimized experiences. The session will also cover our longer term roadmap and vison where our focus is on being a best-in-class Mobile App for all things related to Content Collaboration – ease of access, edit & review workflow and messaging.

    You will also hear from one of our partners, Jason Stortz, Principal Consultant, from Redstone Content Solution who have been busy further extending the mobile collaborative capabilities of the Oracle Content and Experience Cloud. They will show you how to secure signatures on a contract right from your mobile device and discuss how they can help you build mobile optimized experiences using the Oracle Content and Experience Cloud.

    And catch the live demos of the solution and engage with us on solution, roadmap, use cases discussions - this is your opportunity to connect with us and get your questions answered live.

    Add to your My Schedule today:

    Empower the Mobile Workforce using Oracle Content and Experience Cloud [CON7271]

    Wednesday, September 21, 3 pm
    Moscone West—2018

    For a complete listing of all things Digital Experience don’t miss our recently launched website, https://sites.oracle.com/oowdx/, Btw, the site is built on Oracle Sites Cloud Service with Oracle Documents Cloud Service as its underlying content repository! Works great on mobile devices as well!

    And join the conversation on twitter using #OOW16 and #OracleDX. Tweet along and you will see your tweets show up on the site too!

    See you at OOW16 then!

    HelloSign Now Integrates With Oracle Documents Cloud!

    WebCenter Team - Thu, 2016-09-15 15:12

    Just in time for Oracle OpenWorld, we recently announced that HelloSign now integrates with Oracle Documents Cloud!

    You can integrate HelloSign with Oracle Documents Cloud to request signatures for your contracts, agreements, and waivers. You can check the signature status in real time, and the signed document is automatically saved in Documents Cloud for easy access. 

    Want to learn more? Check out this blog post to learn how you can have a paperless future with Oracle Documents Cloud. Heading to Oracle OpenWorld? Be sure to add this session to My Schedule so you can see a demonstration and learn how you can now access important documents and agreements from the Documents Cloud interface and send them out for signature with a few clicks.

    Deep-Dive into Content, Collaboration and Digital Signatures in the Cloud [CON7266] 
    Thursday, Sep 22, 12:00 p.m. | Moscone West - 2014

    For a complete listing of all things Digital Experience don’t miss our recently launched #OOW16 website: Content and Experience at Oracle Open World 2016.

    And please follow along and join the conversations on our social media channels! #OOW16 and #OracleDX

    Q1 FY17 GAAP SAAS AND PAAS REVENUES WERE UP 77%, AND UP 79% IN CONSTANT CURRENCY

    Oracle Press Releases - Thu, 2016-09-15 15:05
    Press Release
    Q1 FY17 GAAP SAAS AND PAAS REVENUES WERE UP 77%, AND UP 79% IN CONSTANT CURRENCY Q1 FY17 Non-GAAP SaaS and PaaS Revenues grew 82% in Constant Currency

    Redwood Shores, Calif.—Sep 15, 2016

    Oracle Corporation (NYSE: ORCL) today announced fiscal 2017 Q1 results. Total Revenues were $8.6 billion, up 2% in U.S. dollars and up 3% in constant currency. Cloud plus On-Premise Software Revenues were $6.8 billion, up 5% in U.S. dollars and up 6% in constant currency. Cloud software as a service (SaaS) and platform as a service (PaaS) revenues were $798 million, up 77% in U.S. dollars and up 79% in constant currency. Total Cloud Revenues, including infrastructure as a service (IaaS), were $969 million, up 59% in U.S. dollars and up 61% in constant currency. Operating Income was $2.6 billion and Operating Margin was 31%. Non-GAAP Operating Income was $3.4 billion and non-GAAP Operating Margin was 39%. Net Income was $1.8 billion while non-GAAP Net Income was $2.3 billion. Earnings Per Share was up 10% to $0.43, while non-GAAP Earnings Per Share was up 4% to $0.55. GAAP and non-GAAP Earnings Per Share was negatively impacted by three factors: 1 cent because of a higher tax rate due to more cloud sales being in the U.S, half of one cent because of borrowing, and 1 cent due to strengthening of the U.S. dollar.

    Short-term deferred revenues were $9.5 billion, up 4% in U.S. dollars and up 5% in constant currency compared with a year ago. Operating cash flow on a trailing twelve-month basis was $13.7 billion.

    “Our Cloud business plus our On-Premise Software business grew 7% in constant currency in the first quarter, on a non-GAAP basis,” said Oracle CEO, Safra Catz. “The overall top-line growth of our two strategic businesses was driven by non-GAAP SaaS and PaaS revenue growing 82% in constant currency, substantially outperforming our guidance. As our SaaS and PaaS business continues its rapid growth, we expect its gross margins to climb from 62% this quarter toward our 80% target.”

    “This year we are on track to sell more than $2 billion of SaaS and PaaS annually recurring revenue,” said Oracle CEO, Mark Hurd. “We believe this will be the second year in a row that Oracle has sold more SaaS and PaaS than any cloud services provider. In the first quarter alone, we added more than 750 new SaaS customers including 344 new SaaS Fusion ERP customers—that’s more ERP customers than Workday has sold in the history of their company.”

    “Next week at Oracle OpenWorld, we will introduce the second generation of our Infrastructure as a Service,” said Larry Ellison, Oracle Chairman and CTO. “Our Generation2 IaaS delivers twice the compute, twice the memory, four times the storage and ten times more I/O at a 20% lower price than Amazon Web Services. IaaS represents a huge new cloud opportunity for Oracle to layer on top of our rapidly growing SaaS and PaaS businesses.”

    The Board of Directors also declared a quarterly cash dividend of $0.15 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on October 12, 2016, with a payment date of October 26, 2016.

    Q1 Fiscal 2017 Earnings Conference Call and Webcast

    Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast of this event, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q1 results and Fiscal 2017 financial tables are available on the Oracle Investor Relations website.

    A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Passcode: 77971381.

    Contact Info
    Ken Bond
    Oracle Investor Relations
    +1.650.607.0349
    ken.bond@oracle.com
    Deborah Hellinger
    Oracle Corporate Communciations
    +1.212.508.7935
    deborah.hellinger@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 or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.

    Trademarks

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

    "Safe Harbor" Statement

    Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding our expectations of future growth in our SaaS and PaaS gross margins and recurring revenues; our introduction of new products; and the opportunities to grow the IaaS business are all "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Our cloud computing strategy, including our Oracle Cloud SaaS, PaaS, IaaS and data as a service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (3) If the security measures for our software, hardware, services or Oracle Cloud offerings are compromised or if such offerings contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and financial exposure. (4) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) Economic, geopolitical and market conditions, including the continued slow economic recovery in the U.S. and other parts of the world, can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (7) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our U.S. Securities and Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of September 15, 2016. Oracle undertakes no duty to update any statement in light of new information or future events. 

    Talk to a Press Contact

    Ken Bond

    • +1.650.607.0349

    Deborah Hellinger

    • +1.212.508.7935

    Purpose of Unique constraint

    Tom Kyte - Thu, 2016-09-15 13:26
    Hi Tom, I am totally confused about unique constraint. I was reading Oracle Database Concepts 11g Release 2 (11.2), where its written about unique constraint that: <i> A unique key constraint requires that every value in a column or set of co...
    Categories: DBA Blogs

    divide data in database with specific login id

    Tom Kyte - Thu, 2016-09-15 13:26
    Hi we have five projects that their all data saved in some tables in database, is there any way so that each project end user should only be able to access only their own project data, and must not able able access any other projects data.
    Categories: DBA Blogs

    difference of update with rownum without rownum

    Tom Kyte - Thu, 2016-09-15 13:26
    Hi tom, I have some doubts with below update statement <code>1. UPDATE emp SET empno = rownum; 2. UPDATE emp SET empno = 1;</code> question no 1-- first one executing with out errors and populating column with unique values while s...
    Categories: DBA Blogs

    Oracle E-Business Suite 12.2.6 Now Available

    Steven Chan - Thu, 2016-09-15 10:40
    We are pleased to announce that Oracle E-Business Suite Release 12.2.6 is now available.


    Instructions for downloading and applying this latest release update pack (RUP) for the EBS 12.2 codeline can be found here:

    What Does Release 12.2.6 Include?

    As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security.

    Release 12.2.6 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases.

    For a complete list of new features, refer to:

    Common Questions and Answers About Upgrading

    • Q: Is there a direct upgrade path from Release 11i to Release 12.2.6?
      A: No. Release 11i customers must first upgrade to Release 12.2 before applying 12.2.6.
    • Q: Is there a direct upgrade path from EBS 12.0 to 12.2.6?
      A: No. Release 12.0 customers must first upgrade to Release 12.2 before applying 12.2.6.
    • Q: Is there a direct upgrade path from EBS 12.2 to 12.2.6?
    • A: Yes. Release 12.2 customers can apply 12.2.6 directly to their environments. EBS 12.2.6 is an online patch, so it can be applied while an existing Release 12.2 system is running.
    Additional References Related Articles
    Categories: APPS Blogs

    Oracle DECOMPOSE Function with Examples

    Complete IT Professional - Thu, 2016-09-15 06:00
    The DECOMPOSE function is a handy string manipulation function. Learn more about it and find out what it does in this article. Purpose of the Oracle DECOMPOSE Function The DECOMPOSE function is used to transform a string into a Unicode string. It will split a character with an accent into two separate characters. For example, […]
    Categories: Development

    #OOW16 Session: Oracle WebCenter Content, Imaging, Capture, and Forms Recognition: Strategy and Roadmap [CON7259]

    WebCenter Team - Thu, 2016-09-15 05:00
    Normal 0 false false false EN-US X-NONE X-NONE

    Enterprise content is a core component of any organization’s infrastructure. As an Oracle WebCenter customer or a stakeholder you know that Oracle WebCenter Content is a proven unified repository to house unstructured content, enabling organizations to deliver it to business users in the proper format and within the context of familiar applications that fit the way they work. Its document imaging and capture product capabilities provide a streamlined platform for business solutions, leveraging image enablement, application extension, and long-term archiving.

    If you are an existing Oracle WebCenter Content and Imaging customer, work with content or are looking at content management and cloud solutions then this is a session you definitely don’t want to miss:

    Oracle WebCenter Content, Imaging, Capture, and Forms Recognition: Strategy and Roadmap [CON7259]

    Tuesday, September 20, 2016 | 4:00 p.m. – 4:45 p.m.

    Moscone West—2014

    Get a complete 360-degree view of the Oracle WebCenter Content product portfolio roadmap, covering content, imaging, capture, and forms recognition and hear directly from the subject matter experts. Learn about the latest releases and product roadmap plans to see how you can leverage those to influence your enterprise strategy. Find out about key application, process and productivity suite integration that can help you drive work agility.

    You will have a unique opportunity to hear from a customer organization, McKesson on how they use Oracle WebCenter Imaging product line to help automate their account payables and ordering processes.

    This session also provides a great opportunity for you to learn from your peers, hear from experts and get your questions answered about Oracle enterprise content management & imaging suite of products.

    Don’t miss:

    Oracle WebCenter Content, Imaging, Capture, and Forms Recognition: Strategy and Roadmap [CON7259]

    Tuesday, September 20, 2016 | 4:00 p.m. – 4:45 p.m.

    Moscone West—2014

    And, get all the latest info on all things Content and Experience at #OOW16 directly on your mobile devices from https://sites.oracle.com/oowdx. While there, check out Oracle Mobile Challenge! You may even get “rewarded” to attend this session!!!

    And use #OOW16 and #OracleDX to tweet about your session experiences. See you there!

    /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

    What’s the difference between SEMI-JOIN and ANTI-JOIN?

    Bar Solutions - Thu, 2016-09-15 04:15

    Dear Patrick,

    What is an ANTI-JOIN? And what is the difference between the SEMI-JOIN and the ANTI-JOIN?

    Lillian Sturdey

    Dear Lillian,

    First of all, both SEMI-JOIN and ANTI-JOIN are not in the SQL syntax but they are more a pattern. You might expect to be able to write something like:

    [PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
                   FROM dept d
                   SEMI JOIN emp e ON (e.deptno = d.deptno)
                 /

    to get all the departments that have at least one employee.
    Or:

    [PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
                   FROM dept d
                   ANTI JOIN emp e ON (e.deptno = d.deptno)
                 /

    to get the departments with no employees. But all you get is an error saying your command is not properly ended, which can be read as a syntax error.

    ERROR at line 3:
    ORA-00933: ORA-00933 SQL command not properly ended.

    Maybe your first idea would be to use a normal join to get all the departments with at least one employee:

    [PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
                   FROM dept d
                   JOIN emp e ON (e.deptno = d.deptno)
                 /

    But this results in a record for every row in the EMP table. And we only wanted every unique department.

        DEPTNO DNAME          LOC
    ---------- -------------- -------------
            20 RESEARCH       DALLAS
            30 SALES          CHICAGO
            30 SALES          CHICAGO
            20 RESEARCH       DALLAS
            30 SALES          CHICAGO
            30 SALES          CHICAGO
            10 ACCOUNTING     NEW YORK
            20 RESEARCH       DALLAS
            10 ACCOUNTING     NEW YORK
            30 SALES          CHICAGO
            20 RESEARCH       DALLAS
    
        DEPTNO DNAME          LOC
    ---------- -------------- -------------
            30 SALES          CHICAGO
            20 RESEARCH       DALLAS
            10 ACCOUNTING     NEW YORK
    
    14 rows selected.

    Well, that’s easy enough, you think, just add a DISTINCT to the statement:

    [PATRICK]SQL>SELECT DISTINCT d.deptno, d.dname, d.loc
                   FROM dept d
                   JOIN emp e ON (e.deptno = d.deptno) 
                 /

    Exactly the result we are looking for:

        DEPTNO DNAME          LOC
    ---------- -------------- -------------
            20 RESEARCH       DALLAS
            10 ACCOUNTING     NEW YORK
            30 SALES          CHICAGO

    But what if the EMP table contains hundreds, thousands or maybe millions of rows. That would mean the database has to do a lot of work to filter out the distinct values.
    A different, and probably better, approach would be to use the SEMI-JOIN pattern. You can use the IN operator like this:

    [PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
                  FROM dept d
                  WHERE d.deptno IN (SELECT e.deptno
                                       FROM emp e)
                 /
        DEPTNO DNAME          LOC
    ---------- -------------- -------------
            20 RESEARCH       DALLAS
            30 SALES          CHICAGO
            10 ACCOUNTING     NEW YORK

    This is exactly what we want to see but for big tables this is not the correct way to go. For every record in the dept table all the records in the EMP table are checked. Again, if we have a lot of employees, this means a lot of work for the database.
    A better SEMI-JOIN to use is the EXISTS operator:

    [PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
                   FROM dept d
                  WHERE EXISTS (SELECT 1
                                  FROM emp e
                                 WHERE e.deptno = d.deptno)
                 /

    Please note that with the current optimizer in the database Oracle will rewrite your query to use the best approach for the task. If the inner table (in our example EMP) is rather small, then the IN approach might be the best, in other cases it might be better to use the EXISTS approach. Where in earlier versions you had to think about which way to go (IN is better for small tables, EXISTS is better for big ones), you can now rely on the optimizer to make the correct choice.
    If you would want to see exactly the opposite of this query, i.e. all departments with no employees, you use an ANTI-JOIN pattern, which is pretty much the same but in this case you use NOT IN or NOT EXISTS. A different approach, which I think is pretty nice is to use an OUTER JOIN and check for the non-existence of values in column for the OUTER JOINED table.

    [PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
                   FROM dept d
                   LEFT OUTER JOIN emp e ON (e.deptno = d.deptno)
                  WHERE e.empno IS NULL
                 /
        DEPTNO DNAME          LOC
    ---------- -------------- -------------
            40 OPERATIONS     BOSTON

    Hope this gives you a bit more insight in this subject and gives you a better understanding of the wonders of the SQL language. Notice there are many ways to reach the same result, but one approach might be more economical than the other.

    Happy Oracle’ing,
    Patrick Barel

    Hope this answers your question.
    Happy Oracle’ing,
    Patrick Barel

    If you have any comments on this subject or you have a question you want answered, please send an email to patrick[at]bar-solutions[dot]com. If I know the answer, or can find it for you, maybe I can help.

    This question has been published in OTech Magazine of Winter 2014.

    Upgrade yourself from DBA to DMA

    Syed Jaffar - Thu, 2016-09-15 04:09
    Be it any profession, learning never ends. From my very own personal perspective and exprience, I strongly beleinv in one who upgrade his skills always stays a step ahead from the rest. To stay competitive, it is necessary to upgrade our skills according to the market demand.

    For DBA folks who aim and dream to learn and upgrade their knwoledge with Oracle Exadata technologies, I wrote a 5 series article to Toad, below are the links to the articles:


    Below are few more Exadata related stuff.

    Managing & Troubleshooting Exadata - Upgrading & Patching ExadataShrink/Grow Exadata diskgroups

    Pass on the knolwedge to the community.

    Happy reading.

    Pages

    Subscribe to Oracle FAQ aggregator