FAQ

Search Discussions

16 discussions - 35 posts

  • Dear Experts, Below are few sections from AWR report. The server is running Linux x86 64 bit, 11.2.0.3.0 with 24 CPUs, 12 Cores and 2 Sockets.Physical Memory is 22GB. The AWR reports is for 3 hours ...
    Vijay sehgalVijay sehgal
    Jun 1, 2014 at 4:16 am
    Jun 1, 2014 at 5:45 am
  • Hi Prabhu, in my opinion 60+ million rows does not warrant 70 or 58 hours for the update. I’m concerned at that amount of time and wonder if the update is being performed with full scans. I know this ...
    Cunningham, MikeCunningham, Mike
    Jun 1, 2014 at 4:23 am
    Jun 1, 2014 at 5:15 am
  • I would be very surprised to hear of a storage admin that can't provide RAID 1 volumes as raw disk - then you can add each RAID 1 volume as an externally redundant ASM disk, and then stripe across ...
    Adam MuschAdam Musch
    Jun 1, 2014 at 4:46 am
    Jun 1, 2014 at 4:46 am
  • Oracle EE 11.2.0.2 We are planning to change a production application to read from a physical standby database to offload read activity from the primary. One of the requirements is up-to-the-minute ...
    Sandra BeckerSandra Becker
    Jun 1, 2014 at 4:46 am
    Jun 1, 2014 at 4:46 am
  • No change in 12c. There is a special case (in all versions) for pl/sql blocks - if the first modification of the pl/sql block is the first modification of a transaction, and the savepoint is created ...
    Jonathan LewisJonathan Lewis
    Jun 1, 2014 at 4:45 am
    Jun 1, 2014 at 4:45 am
  • If you are collecting statistics for the Optimizer, you should be using DBMS_STATS. See the notes on the ANALYZE command at http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_4005.ht ...
    Chitale, Hemant KChitale, Hemant K
    Jun 1, 2014 at 5:15 am
    Jun 1, 2014 at 5:15 am
  • It's not surprising for the example you've given. The basic principle is that the cost of a single table access via a bitmap index is likely to be different from the cost of access via the equivalent ...
    Jonathan LewisJonathan Lewis
    Jun 1, 2014 at 5:15 am
    Jun 1, 2014 at 5:15 am
  • Thank you very much for the valuable comments, Pete! I thought that the installation order could have been important. Thanks again! Best regards, Dimitre Il 30/mag/2014 18:41 "Peter Sharman" <<span ...
    Radoulov, DimitreRadoulov, Dimitre
    Jun 1, 2014 at 5:15 am
    Jun 1, 2014 at 5:15 am
  • Hello Freek, thanks for the step-by-step action plan suggestions! The customer is using GC 11g and the upgrade decision is up to them. Some years ago, when I set up this cluster, I installed and ...
    Radoulov, DimitreRadoulov, Dimitre
    Jun 1, 2014 at 4:46 am
    Jun 1, 2014 at 4:46 am
  • Is this a RAC database? I've seen this on a RAC when the dump directory isn't shared across the nodes.
    David BarbourDavid Barbour
    Jun 1, 2014 at 4:46 am
    Jun 1, 2014 at 4:46 am
  • List, Hoping someone has run through this before and can provide some of their experiences. We had a contractor (no longer with us) who performed an install of GI 11.2.0.3 on a Red Hat Linux 6.4 ...
    Deas, ScottDeas, Scott
    Jun 1, 2014 at 4:46 am
    Jun 1, 2014 at 4:46 am
  • List I saw a 11.2 production DB with a job_queue_processes setting at 1000. Is that derived as cpu_count*parallel_threads_percpu. our cpu count is 10. Is 1000 a mistake or is it ok to set it at such ...
    C PC P
    Jun 1, 2014 at 4:45 am
    Jun 1, 2014 at 4:45 am
  • Hi CP, 1000 is the default for job_queue_processes in 11g. Michael Cunningham Senior Database Administrator The Doctors' Company 707.226.0221 - desk 707.337.0184 - cell From: <span ...
    Cunningham, MikeCunningham, Mike
    Jun 1, 2014 at 4:45 am
    Jun 1, 2014 at 4:45 am
  • Hello, I have a view that run in a Oracle 11g with RAC and when I create the view and run the first time, the time is : 30 seg The at the second, third ... the time go to 2m:30seg Why does it happen ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Jun 1, 2014 at 4:45 am
    Jun 1, 2014 at 4:45 am
  • I concur Kenney suggestion. Executed same approach for 1.5 terabytes compressed partitioned table with 1.4 terabytes history data. Did build table with all history data offline. Final day insert ...
    Karth PanchanKarth Panchan
    Jun 1, 2014 at 4:16 am
    Jun 1, 2014 at 4:16 am
  • It uses it the same way any query would use it when reconstructing the data 'image' at the time the query started. expdp creates a consistent 'image' of the table data for each table exported; as ...
    David FitzjarrellDavid Fitzjarrell
    Jun 1, 2014 at 4:15 am
    Jun 1, 2014 at 4:15 am
Group Navigation
period‹ prev | Jun 2014 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions16
posts35
users27
websiteoracle.com

27 users for June 2014

Cunningham, Mike: 3 posts Jonathan Lewis: 3 posts Iggy Fernandez: 2 posts Kenny Payton: 2 posts Prabhu Krishnaswamy: 2 posts Radoulov, Dimitre: 2 posts Hostetter Jay: 1 post Coskan: 1 post Adam Musch: 1 post Adric Norris: 1 post Chitale, Hemant K: 1 post C P: 1 post David Barbour: 1 post David Fitzjarrell: 1 post Deas, Scott: 1 post Eriovaldo Andrietta: 1 post Howard Latham: 1 post Justin Mungal: 1 post Karth Panchan: 1 post kyle Hailey: 1 post
show more
Archives