Search Discussions
-
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 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, 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 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, 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 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 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 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, 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 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, 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 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 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, 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 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 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 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 Latham
May 29, 2014 at 4:15 am
Jun 1, 2014 at 4:45 am -
Ahh. okay.. i get it now.. thanks all!
Chris 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 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 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 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. 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 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, 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 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 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 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 Jesse
May 26, 2014 at 4:45 am
May 26, 2014 at 4:45 am -
SET ESCAPE OFF
Chris 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 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, 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 ...
Anton
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 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. 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 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, 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 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 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 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 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 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 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 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 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 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 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, 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 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 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 Mishra
May 15, 2014 at 6:55 pm
May 16, 2014 at 5:38 pm
Group Overview
group | oracle-l |
categories | oracle |
discussions | 49,700 |
posts | 225,295 |
users | 6,918 |
website | oracle.com |
Top users
Archives
- June 2014 (35)
- May 2014 (401)
- April 2014 (496)
- March 2014 (524)
- February 2014 (610)
- January 2014 (547)
- December 2013 (404)
- November 2013 (387)
- October 2013 (456)
- September 2013 (311)
- August 2013 (255)
- July 2013 (446)
- June 2013 (515)
- May 2013 (396)
- April 2013 (568)
- March 2013 (694)
- February 2013 (558)
- January 2013 (655)
- December 2012 (309)
- November 2012 (394)
- October 2012 (438)
- September 2012 (499)
- August 2012 (560)
- July 2012 (471)
- June 2012 (427)
- May 2012 (519)
- April 2012 (440)
- March 2012 (522)
- February 2012 (419)
- January 2012 (441)
- December 2011 (366)
- November 2011 (699)
- October 2011 (718)
- September 2011 (530)
- August 2011 (778)
- July 2011 (541)
- June 2011 (642)
- May 2011 (482)
- April 2011 (593)
- March 2011 (704)
- February 2011 (687)
- January 2011 (253)
- December 2010 (212)
- November 2010 (290)
- October 2010 (272)
- September 2010 (202)
- August 2010 (162)
- July 2010 (180)
- June 2010 (228)
- May 2010 (170)
- April 2010 (171)
- March 2010 (534)
- February 2010 (878)
- January 2010 (864)
- December 2009 (719)
- November 2009 (695)
- October 2009 (703)
- September 2009 (614)
- August 2009 (560)
- July 2009 (780)
- June 2009 (647)
- May 2009 (670)
- April 2009 (801)
- March 2009 (862)
- February 2009 (826)
- January 2009 (595)
- December 2008 (551)
- November 2008 (832)
- October 2008 (856)
- September 2008 (751)
- August 2008 (657)
- July 2008 (644)
- June 2008 (717)
- May 2008 (760)
- April 2008 (1,019)
- March 2008 (807)
- February 2008 (735)
- January 2008 (979)
- December 2007 (549)
- November 2007 (819)
- October 2007 (785)
- September 2007 (848)
- August 2007 (1,000)
- July 2007 (995)
- June 2007 (897)
- May 2007 (963)
- April 2007 (1,096)
- March 2007 (1,142)
- February 2007 (1,193)
- January 2007 (1,159)
- December 2006 (1,146)
- November 2006 (1,257)
- October 2006 (1,179)
- September 2006 (1,336)
- August 2006 (1,222)
- July 2006 (871)
- June 2006 (1,315)
- May 2006 (1,385)
- April 2006 (1,169)
- March 2006 (1,142)
- February 2006 (1,062)
- January 2006 (464)
- December 2005 (403)
- November 2005 (930)
- October 2005 (1,617)
- September 2005 (1,304)
- August 2005 (1,748)
- July 2005 (1,129)
- June 2005 (1,453)
- May 2005 (1,260)
- April 2005 (1,364)
- March 2005 (1,332)
- February 2005 (1,251)
- January 2005 (1,179)
- December 2004 (1,353)
- November 2004 (1,205)
- October 2004 (1,201)
- September 2004 (1,709)
- August 2004 (2,223)
- July 2004 (2,436)
- June 2004 (2,462)
- May 2004 (2,074)
- April 2004 (1,893)
- March 2004 (3,145)
- February 2004 (2,979)
- January 2004 (2,392)
- December 2003 (2,095)
- November 2003 (2,016)
- October 2003 (2,800)
- September 2003 (2,022)
- August 2003 (2,415)
- July 2003 (2,725)
- June 2003 (2,173)
- May 2003 (2,891)
- April 2003 (2,460)
- March 2003 (2,334)
- February 2003 (2,928)
- January 2003 (2,931)
- December 2002 (2,049)
- November 2002 (2,199)
- October 2002 (2,708)
- September 2002 (2,101)
- August 2002 (3,028)
- July 2002 (2,862)
- June 2002 (2,654)
- May 2002 (3,081)
- April 2002 (3,066)
- March 2002 (2,777)
- February 2002 (2,084)
- January 2002 (3,044)
- December 2001 (1,868)
- November 2001 (2,132)
- October 2001 (1,975)
- September 2001 (2,990)
- August 2001 (4,066)
- July 2001 (3,124)
- June 2001 (4,424)
- May 2001 (3,422)
- April 2001 (2,325)
- March 2001 (2,846)
- February 2001 (2,522)
- January 2001 (2,565)
- December 2000 (2,091)
- November 2000 (2,549)
- October 2000 (2,454)
- September 2000 (2,266)
- August 2000 (2,561)
- July 2000 (2,360)
- June 2000 (3,655)
- May 2000 (2,787)
- April 2000 (357)
- March 2000 (8)
- September 1998 (1)
- February 1997 (1)
- January 1997 (1)
- March 1996 (147)
- February 1996 (275)
- January 1996 (686)
- December 1995 (105)
- March 1995 (183)