FAQ

Oracle > oracle-l

Search Discussions

49,700 discussions - 225,295 posts

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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 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
  • 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
  • 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
  • I have a linux shell script that used to run fine I had imp \'userid=sys/easyeasy as sysdba\' it used to work but now I get a too many parameters error. any ideas? rhat linux 4 Oracle 11.2 -- Howard ...
    Howard LathamHoward Latham
    May 29, 2014 at 4:15 am
    Jun 1, 2014 at 4:45 am
  • Ahh. okay.. i get it now.. thanks all!
    Chris KingChris King
    May 29, 2014 at 3:45 am
    May 29, 2014 at 3:45 am
  • Scott: I've never done the Grid Home Move below, but I have removed then reinstalled Grid into a new directory before. It was my test cluster so I don't know what kind of downtime you'd experience, ...
    Tyfanie WineriterTyfanie Wineriter
    May 29, 2014 at 3:45 am
    May 29, 2014 at 3:45 am
  • I am encountering the following errors during the use of data pump to migrate an EBS instance following instructions in "Export/import process for 12.0 or 12.1 using 11gR1 or 11gR2 (Doc ID 741818.1)" ...
    Rajesh AialavajjalaRajesh Aialavajjala
    May 29, 2014 at 3:15 am
    Jun 1, 2014 at 4:45 am
  • Are DBAs' actually allowed to go on vacation??? -- mohammed
    Mohammed bhattiMohammed bhatti
    May 26, 2014 at 7:15 am
    May 26, 2014 at 7:15 am
  • http://www.freelists.org/wiki/faq/vacation_mode Should be of help. (You can do this by email, as in email to <span class="m_body_email_addr" title="d1e012d22dc9946530cd6b5aea735fea" ...
    Mark W. FarnhamMark W. Farnham
    May 26, 2014 at 5:45 am
    May 26, 2014 at 5:45 am
  • Here's the discussion : https://www.linkedin.com/groups/Has-anyone-implemented-Flash-storage-779 41.S.5861561750310125568 Hemant K Chitale This email and any attachments are confidential and may also ...
    Chitale, Hemant KChitale, Hemant K
    May 26, 2014 at 5:45 am
    May 26, 2014 at 5:45 am
  • Cluster details: GI 11.2.0.3 DB 11.2.0.3 2 node cluster on OEL with RH compatible kernel. 2 owner install: grid owns GI, oracle owns DB Question: When the DB software is installed, running root.sh ...
    Ruel, ChrisRuel, Chris
    May 26, 2014 at 5:45 am
    May 26, 2014 at 7:15 am
  • I am looking for recommendations from those of you that also support MS Sql Server as to good vendors for training classes. Please reply privately. Jeffrey Beckstrom Database Administrator ...
    Jeffrey BeckstromJeffrey Beckstrom
    May 26, 2014 at 5:45 am
    May 26, 2014 at 5:45 am
  • Hello, This list is not appropriate for such requests. Cheers, Phil -- http://www.freelists.org/webpage/oracle-l
    Phil JonesPhil Jones
    May 26, 2014 at 4:45 am
    May 26, 2014 at 4:45 am
  • If a database server process is in a "spin loop" on CPU waiting for a latch, does ASH show status='ON CPU' or status='WAITING' with the event being the latch wait. Just wondering..... I can't create ...
    Chitale, Hemant KChitale, Hemant K
    May 26, 2014 at 4:45 am
    May 26, 2014 at 4:45 am
  • Folks here like saving on Oracle ebooks, so I'm just passing along the message. Use code MDS14 through 2014/5/26 for 50% off ebooks at apress.com Enjoy! Rich -- ...
    Rich JesseRich Jesse
    May 26, 2014 at 4:45 am
    May 26, 2014 at 4:45 am
  • SET ESCAPE OFF
    Chris TaylorChris Taylor
    May 26, 2014 at 3:45 am
    May 26, 2014 at 4:45 am
  • Hello, I have a materialized view that I'm creating and I wanted to delay the actual refresh until the night, so I used the following statement: create materialized view my_mview build deferred ...
    Thomas KellererThomas Kellerer
    May 26, 2014 at 3:45 am
    May 26, 2014 at 3:45 am
  • The original request was to respond privately, but I appreciate the fact that Michael did not as I am looking for same thing. Thanks! From: <span class="m_body_email_addr" ...
    Coll-Barth, MichaelColl-Barth, Michael
    May 26, 2014 at 3:45 am
    May 26, 2014 at 3:45 am
  • Hi all, it is possoble to rollback such issue without recreating standby database ? "recover managed standby database *finish*" database was open in read only mode. ps: database is not in flashback ...
    AntonAnton
    May 26, 2014 at 3:15 am
    May 26, 2014 at 3:15 am
  • Sanjay, The difference between DB Control/DB Express and Grid Control/Cloud Control for monitoring Data Guard is huge. Can you specify which setup(s) you are using? Seth Miller
    Seth MillerSeth Miller
    May 23, 2014 at 5:45 am
    May 23, 2014 at 5:45 am
  • In addition to what Hans mentioned, you can apparently install a full new stack of an upgraded and/or patched container database and test the upgrade by unplugging from the older release and plugging ...
    Mark W. FarnhamMark W. Farnham
    May 23, 2014 at 5:45 am
    May 23, 2014 at 5:45 am
  • We were originally given 90 GB LUNS. As part of storage migration to another vendor, we are being provisioned with 500 GB LUNS. From a migration point of view, is it ok to move the data from 90 GB ...
    Kumar MadduriKumar Madduri
    May 23, 2014 at 5:45 am
    May 26, 2014 at 6:15 am
  • Rich, I used a similar process during a migration to 11g. The parallel importing of the tables went fine since impdp will spawn several processes (parallel=##) and each process will import one table ...
    Cunningham, MikeCunningham, Mike
    May 23, 2014 at 5:15 am
    May 29, 2014 at 4:15 am
  • Hi Does anyone run Solaris x86 virtualized in Oracle VM v3.x? If so can you send a private mail? Thanks a lot
    Ls ChengLs Cheng
    May 23, 2014 at 5:15 am
    May 23, 2014 at 5:15 am
  • If it's actually in its "spincount" for the latch it's on the CPU (or waiting in the runqueue) and ASH will record "ON CPU". It's hard to prove this point because a spin takes a very short time and ...
    Jonathan LewisJonathan Lewis
    May 23, 2014 at 4:45 am
    May 23, 2014 at 4:45 am
  • Hi, We currently have our main production database running on HP-UX with a standby database, also HP-UX, at our DR site. It's possible that we will lose funding for the DR site at some point in the ...
    Maureen EnglishMaureen English
    May 23, 2014 at 4:45 am
    May 26, 2014 at 5:45 am
  • To add to this, my company also offers video and in person training: http://www.brentozar.com/training/ We have one training coming up this fall in Philadelphia. All of the in-person presenters are ...
    Jeremiah PeschkaJeremiah Peschka
    May 23, 2014 at 4:45 am
    May 23, 2014 at 5:15 am
  • Also remember that another benefit is for those that don't have ability to create pl/sql objects in a particular database - they can still use that code in their SQL statements now... -----Original ...
    Jeff SmithJeff Smith
    May 23, 2014 at 4:45 am
    May 26, 2014 at 5:45 am
  • Hi Can someone share the architecture or document or URL to manage Grid/Cloud control for Primary and DR side ? What I am looking is how to to keep sync OMS repository and can use DR Grid/Cloud ...
    Sanjay MishraSanjay Mishra
    May 23, 2014 at 4:45 am
    May 26, 2014 at 7:15 am
  • Hi friends, I had a temporary tablespace TEMP02 in the instance. I ran: $ df -h . Filesystem Size Used Avail Use% Mounted on /dev/f1/fold1 493G 154G 339G 32% /l/disk67 After it I ran : select * from ...
    Eriovaldo AndriettaEriovaldo Andrietta
    May 18, 2014 at 10:19 am
    May 18, 2014 at 7:42 pm
  • Hi List, I am working with 12c and was able to use the new large data type for VARCHAR2 etc. I am now using a VARCHAR2(32767) and NVARCHAR2(16383) Now I noticed at the Data Dict that tables and other ...
    Hanan HitHanan Hit
    May 17, 2014 at 2:18 pm
    May 18, 2014 at 12:29 am
  • List, I wish I could use a pollster. How many of you who backup to tapes which are stored offsite or at a third party location use rman encryption, given that there are other security mechanisms that ...
    Ram KRam K
    May 16, 2014 at 7:09 pm
    May 16, 2014 at 7:09 pm
  • First, thanks everyone for all your assistance with my many newbee RAC questions. You've been a huge help! I just did my first failover test, and everything looked fine. When I brought the failed rac ...
    Chris KingChris King
    May 16, 2014 at 4:05 pm
    May 16, 2014 at 6:17 pm
  • Hi all, RAC 11.2.0.3.5 on RHEL 5.7 with RHEL kernel CVE-2012-1675/COST workaround implemented (SSL communication between listeners and instances) The customer wants to upgrade the OS and the HW. The ...
    Radoulov, DimitreRadoulov, Dimitre
    May 16, 2014 at 3:34 pm
    May 26, 2014 at 3:45 am
  • Hello guys need help here... We have recently migrated from a Hp-UX superdome (PARISC) to hp-ux itanium with the same configuration at the db side. Oracle 9.2.0.8 Disks were unmounted and mounted on ...
    Veerabasaiah CVeerabasaiah C
    May 15, 2014 at 11:17 pm
    May 15, 2014 at 11:28 pm
  • Hello: Environment is 11.2.0.2.6 2 node rac Plan is to move from EMC storage to Pure storage OCR and Voting disk is on ASM. Our sys admin says they would not be able to discover both the storage at ...
    Kumar MadduriKumar Madduri
    May 15, 2014 at 8:55 pm
    May 15, 2014 at 8:55 pm
  • Hi Can someone shared the script to map as what Oracle Database segment is located on particular ASM Disk in the Diskgroup ? We have 5 disk out of 40 disk in a diskgroup that are reported as high ...
    Sanjay MishraSanjay Mishra
    May 15, 2014 at 6:55 pm
    May 16, 2014 at 5:38 pm
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouporacle-l @
categoriesoracle
discussions49,700
posts225,295
users6,918
websiteoracle.com

Top users

Dgoulet_at_vicr.com: 2826 posts Jared Still: 2674 posts DENNIS WILLIAMS: 2569 posts Jared.still_at_radisys.com: 2531 posts Niall Litchfield: 2172 posts Jamadagni, Rajendra: 1985 posts Jared Still: 1763 posts Jonathan: 1630 posts Rachel Carmichael: 1629 posts Tanel P+APU-der: 1545 posts BoivinP_at_mar.dfo-mpo.gc.ca: 1334 posts Mark W. Farnham: 1317 posts Mladen Gogala: 1305 posts Allen, Brandon: 1286 posts Ron Rogers: 1219 posts Rachel Carmichael: 1193 posts Mercadante, Thomas F: 1182 posts Ruth Gramolini: 1147 posts Jesse, Rich: 1104 posts Mohanr_at_stars-smi.com: 1074 posts
show more
Archives