FAQ

Oracle > oracle-l > June 2013

Search Discussions

84 discussions - 515 posts

  • List I was checking around on 12c grid control (or cloud control). I want to check to see if it is ready for prime time. Are the listers using it in their prod environments without any major issues ...
    Ram KRam K
    Jun 28, 2013 at 7:29 pm
    Jul 4, 2013 at 1:59 pm
  • Section 2.3.2 of this document indicates that data guard is not part of Standard Edition. http://docs.oracle.com/cd/E11882_01/server.112/e25608/standby.htm In your opinions, would my interpretation ...
    Patterson, JoelPatterson, Joel
    Jun 12, 2013 at 2:41 pm
    Jun 14, 2013 at 2:28 pm
  • Don't everybody hop on at once. chris CONFIDENTIALITY NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, ...
    Stephens, ChrisStephens, Chris
    Jun 25, 2013 at 3:26 pm
    Jun 26, 2013 at 2:43 pm
  • How is this done ? At 17:11, my sqlplus session was connected to instance 3 in the RAC cluster. At 17:53, the session is on instance 1. No explicit commands issued from the client. Disclaimer : In ...
    Hemant K ChitaleHemant K Chitale
    Jun 16, 2013 at 2:38 pm
    Jun 20, 2013 at 5:14 pm
  • One of our VP's yelled at me this morning and slammed my door when he left my office. He was angry because I didn't check my scripts into the change control they use for the application code so ...
    Sandra BeckerSandra Becker
    Jun 26, 2013 at 7:35 pm
    Jun 29, 2013 at 7:49 am
  • Howdy, In 11.2.0.3, we're archiving a good portion of data from Production ERP DB to Production Archive DB. All tables are in one tablespace, all indexes in another, as designed by 3rd party ERP. In ...
    Rich JesseRich Jesse
    Jun 20, 2013 at 4:26 pm
    Jun 24, 2013 at 6:18 pm
  • G'day, I am looking for a clear statement from Oracle to the effect that EMGC is free to use in combination with licensed database installations. It has been discussed on the list before, but I can't ...
    De DBADe DBA
    Jun 18, 2013 at 4:18 am
    Jun 20, 2013 at 3:46 am
  • Hi, we have an UPDATE statement that is run every night during the process of populating a test environment for our DWH. This is an automated build environment and therefor the tables are dropped and ...
    Thomas KellererThomas Kellerer
    Jun 5, 2013 at 7:24 am
    Jun 11, 2013 at 11:29 am
  • Does anyone know how to automatically startup an Oracle 11.2 Physical Standby database when a machine gets rebooted and put it into recovery mode? I guess I can add it to crs with the following ...
    Terrian, Thomas J DLA CTR TRANSACTION SERVICESTerrian, Thomas J DLA CTR TRANSACTION SERVICES
    Jun 6, 2013 at 12:07 pm
    Jun 11, 2013 at 11:21 am
  • Hi, does anybody know how the running time for index create or rebuilds inOracle changes withnumber of lines / table size? I would expect O(n log n)? We need a guesstimate for the time for a complete ...
    Ingrid VoigtIngrid Voigt
    Jun 5, 2013 at 2:57 pm
    Jun 6, 2013 at 12:51 am
  • I'm really getting confused on this data guard thing. I've followed several different people's steps and I cannot get it to work. This is the second time that I've ended up with the standby database ...
    Scott CanaanScott Canaan
    Jun 3, 2013 at 3:52 pm
    Jun 4, 2013 at 2:43 pm
  • Hey all, MOS has a new alert 1557478.1 that says "Because Transparent HugePages are known to cause unexpected node reboots and performance problems with RAC, Oracle strongly advises to disable the ...
    Rich JesseRich Jesse
    Jun 6, 2013 at 3:00 pm
    Jun 10, 2013 at 7:08 pm
  • Finally [after all these years of my whining] ... according to the Licensing guide for DB 12c Oracle Database Personal Edition is available on Linux. This is a BIG announcement. Personal Edition is ...
    Hans ForbrichHans Forbrich
    Jun 26, 2013 at 2:27 am
    Aug 6, 2013 at 5:13 pm
  • We implemented hugepages in production this weekend after running in dev and qa environments for over a month. Dev/QA environments do not have the connection load that production has. In all ...
    Christopher Taylor2Christopher Taylor2
    Jun 24, 2013 at 10:40 pm
    Jun 26, 2013 at 10:36 am
  • Hi, I'd like to ask for your advice debugging a shared pool latching problem. For background, let me state that in general, in the application concerned, shared pool fragmentation has been a ...
    Sigrid KeydanaSigrid Keydana
    Jun 11, 2013 at 8:13 am
    Jun 13, 2013 at 7:47 am
  • Gurus, Can we throttle the shipment of Archive logs to occur at different times (increase in offpeak hours, decrease shipment in peak hrs) standing up 11gR2 Datagaurd ? The goal is to being sensitive ...
    BalaBala
    Jun 12, 2013 at 3:16 pm
    Jun 13, 2013 at 5:32 am
  • 11.2.0.2 linux 64 bit. I have a problem with some parallel queries being serialized. I am trying to determine which queries where serialized after the fact. Short of catching the query in the act via ...
    Josh CollierJosh Collier
    Jun 22, 2013 at 3:14 am
    Jul 2, 2013 at 6:04 pm
  • I have to merge some tables that contain a long datatype. A simple insert into tableA (select * from tableB) will not work. I've tried Googling, but not having much success. Could someone enlighten ...
    Denise GwinnDenise Gwinn
    Jun 27, 2013 at 4:10 pm
    Jun 28, 2013 at 4:33 pm
  • All, We are coming up with a design for a newer system for one of our existing applications. We are trying to find out the IOPS of the existing system. I can get some information from the v$filestat, ...
    C PC P
    Jun 20, 2013 at 9:04 pm
    Jun 27, 2013 at 3:18 pm
  • hi, we support test env creation partially by making snapshots on the storage array level. One of the nice sides of this are storage savings. The algorithm behind snapshot is simple - modification of ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jun 28, 2013 at 8:25 am
    Jul 1, 2013 at 12:13 pm
  • Hi, I have a table, called travel, with columns (source,destination,distance) this is something like, New york to paris and distance between them. Logically New York to paris or Paris to New York ...
    Rajugaru VijRajugaru Vij
    Jun 28, 2013 at 8:07 am
    Jun 28, 2013 at 1:34 pm
  • Oracle 11gR2 on IBM mainframe, SUSE11 For most of my tenure at the company, production database performance has been mediocre at best and poor for several areas of the applications. Over the years, I ...
    Sandra BeckerSandra Becker
    Jun 20, 2013 at 8:00 pm
    Jun 20, 2013 at 8:51 pm
  • 11g on windows 2008. Oracle is running as an admin account. From sqlplus same account can spool a file successfully. Does anyone know what I am missing to set the parameter successfully? alter system ...
    Patterson, JoelPatterson, Joel
    Jun 19, 2013 at 7:34 pm
    Jun 20, 2013 at 2:23 pm
  • I was looking over v$sql and noticed it has disk_reads and physical_read_requests. I couldn't tell from the docs exactly what the difference is. I'm guessing disk_reads is the number of disk reads ...
    Walker, Jed SWalker, Jed S
    Jun 7, 2013 at 5:04 pm
    Jun 7, 2013 at 5:24 pm
  • Env: 10.2.0.4 RAC Linux 64-bit I've got an explain plan with Pstart/Pstop with "KEY" instead of partition numbers. I've been reading ...
    Christopher Taylor2Christopher Taylor2
    Jun 6, 2013 at 3:18 pm
    Jun 6, 2013 at 4:33 pm
  • This paper is 13 years old, is it still valid in the era of quad core processors? Batch Queue Management and the Magic of '2' Cary Millsap/Hotsos Enterprises, Ltd. -- ...
    Josh CollierJosh Collier
    Jun 14, 2013 at 7:09 pm
    Aug 29, 2013 at 3:34 pm
  • Hello, we have a situation where we are using NEXTVAL and CURRVAL in the same multi-table insert statement. Basically this is something like this: create sequence foo_seq; create table foo (id ...
    Thomas KellererThomas Kellerer
    Jun 26, 2013 at 9:36 am
    Jun 28, 2013 at 1:57 pm
  • Hello Gurus! We have 2 node RAC and redologs are configured in RAID 5 disk, Since we noticed the performance is slow we planned to move the redo logfiles to RAID 1 disk. We configured OGG from ...
    Nagaraj SNagaraj S
    Jun 26, 2013 at 7:49 am
    Jun 26, 2013 at 3:01 pm
  • Hello, we are going to install 11g RAC (expected to be 11.203 using asm) on AIX 6. Does anyone have step by step guide or any blog that has it, preferbly with problems encountered, settings, etc ...
    Orlando LOrlando L
    Jun 13, 2013 at 6:39 pm
    Jun 20, 2013 at 9:19 pm
  • Env: 10.2.0.4 3-node RAC. I've been reading a bit online about library cache lock waits and ran across a forum reply by Charles Hooper in discussion about session_cached_cursors and libary cache ...
    Christopher Taylor2Christopher Taylor2
    Jun 2, 2013 at 5:22 pm
    Jun 3, 2013 at 12:42 pm
  • Hi list, for me it's a mystery, but maybe somebody here can bring light into it. It's about cost calculation for two indexes in database version 11.2.0.3.0 (no interim patches) on Linux x86_64 ...
    Martin KlierMartin Klier
    Jun 26, 2013 at 8:24 pm
    Jul 16, 2013 at 11:58 am
  • Hi All, Almost all our Databases are affected with below errors , we suspect that its because of our distrubuted transactions . Rejected the attempt to advance SCN over limit by 212 hours worth to ...
    Bala KrishnaBala Krishna
    Jun 25, 2013 at 7:30 am
    Jun 25, 2013 at 3:45 pm
  • Hello, I'm working with a client to migrate off of HP-UX onto a virtual linux based platform. They have a very small window (< 6 hours) to do this in and large data volumes ( 3TB), so export/import ...
    Haroon QureshiHaroon Qureshi
    Jun 14, 2013 at 9:40 pm
    Jun 25, 2013 at 7:04 am
  • Just curious, does anyone know an easy way to detect what version a controlfile is? I'm writing a program that needs to restore from a backup, and the original source database could be one of several ...
    Jeremy SchneiderJeremy Schneider
    Jun 24, 2013 at 3:14 pm
    Jun 24, 2013 at 7:09 pm
  • For those of you who send your audit records to the OS, what tool(s) do you use to mine/monitor/parse the data? I've inherited some databases that send it to the syslog. The data is then loaded via a ...
    Jay HostetterJay Hostetter
    Jun 20, 2013 at 6:41 pm
    Jun 21, 2013 at 12:04 pm
  • Hi all, I am looking for tools able to reproduce basic sqldeveloepr functionalities through a web interface. The purpose is to remove direct users access to the database and leave this uses the ...
    Stefano CislaghiStefano Cislaghi
    Jun 19, 2013 at 8:54 am
    Jun 19, 2013 at 2:36 pm
  • Hi Does anyone know if it is possible to force during an goldengate initial direct load (I have to do some Transformation so this is the easiest way) the order of table to be replicated? I need to ...
    Ls ChengLs Cheng
    Jun 9, 2013 at 5:50 pm
    Jun 14, 2013 at 7:25 am
  • Hi, I am trying to validate the following statement for red hat linux 64bit 5.4, 11.2.0.2: It is a best practice to limit the number of operating system processes to no more than 8 times the number ...
    Josh CollierJosh Collier
    Jun 12, 2013 at 10:36 pm
    Jun 13, 2013 at 12:31 am
  • Our enterprise is going to standardize on OEL. All 11gR2 RAC servers are using RHEL 5.6. The systems guys believe that OEL is the exact same kernel as RHEL, and that the only required change is a RPM ...
    Jeff ThomasJeff Thomas
    Jun 4, 2013 at 11:26 pm
    Jun 5, 2013 at 1:07 pm
  • SQL select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME) order by 1; TIME SIZE_MB --------------- ---------- 14-JUN-13 ...
    Bala KrishnaBala Krishna
    Jun 21, 2013 at 11:22 am
    Jul 3, 2013 at 1:17 pm
  • Looking for some ideas around archiving 2 tables that we have, seem to be growing too fast than we had expected. Below are the 2 tables with columns of interest listed. event -- ev_id, ev_time, other ...
    Steven AndrewSteven Andrew
    Jun 24, 2013 at 8:11 pm
    Jul 2, 2013 at 3:03 pm
  • Hello: We are planning to ugrade to 11.2.0.3 and apply PSU6 after the upgrade. This will bring us to 11.2.0.3.6. I have found this note "11.2.0.3 Patch Set - Availability and Known Issues [ID ...
    Kumar MadduriKumar Madduri
    Jun 26, 2013 at 6:32 pm
    Jun 27, 2013 at 9:54 am
  • I have hit an air pocket with the steps in creating a standby old school. A bit embarrassing but I'm also under time preasure. I create the standby control file on the primary and bring it over.. ...
    Patterson, JoelPatterson, Joel
    Jun 19, 2013 at 3:07 pm
    Jun 19, 2013 at 3:46 pm
  • If you were going to upgrade your OS from redhat 5.4 to 6.1 what are some of the items/actions/tasks that you would test? Thanks for your time, Josh C. -- http://www.freelists.org/webpage/oracle-l
    Josh CollierJosh Collier
    Jun 18, 2013 at 6:16 pm
    Jun 18, 2013 at 7:02 pm
  • Hi all, I just found that set parameter NLS_LENGTH_SEMANTICS=CHAR at instance level does not make the default character length type to char when created table with char/varchar column in one of ...
    Lu JiangLu Jiang
    Jun 6, 2013 at 4:29 pm
    Jun 8, 2013 at 3:23 pm
  • So a colleague of mine just pointed me to a metalink document (after we had been discussing using AMM with hugepages) that 10g uses ASMM not AMM (not to be confused with ASSM). I was under the ...
    Christopher Taylor2Christopher Taylor2
    Jun 4, 2013 at 9:23 pm
    Jun 5, 2013 at 8:42 pm
  • Ok....need some assistance. Open SR with Oracle said to drop table, recreate and import the data. Corruption is still being reported. Ran DBV, same results. DBV-00201: Block, DBA 28211119, marked ...
    April SimsApril Sims
    Jun 5, 2013 at 1:25 pm
    Jun 5, 2013 at 3:59 pm
  • hi, is there a way to determine what was the setting of the ignorecase argument while creating a password file? Regards Remigiusz -- Pole na kazi ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jun 4, 2013 at 8:14 am
    Jun 4, 2013 at 12:53 pm
  • http://www.oracle.com/technetwork/database/enterprise-edition/documentation/ index.html Many thanks to Oracle's IOUG board liaison and a real friend of the Oracle User Community, Willie Hardie ...
    Mark W. FarnhamMark W. Farnham
    Jun 25, 2013 at 8:16 pm
    Jul 9, 2013 at 8:27 pm
  • Just a heads up that Oracle has released a HUGE set of demos and tutorials for the new Oracle Database 12c. http://otn.oracle.com/obe /Hans -- http://www.freelists.org/webpage/oracle-l
    Hans ForbrichHans Forbrich
    Jun 28, 2013 at 7:15 pm
    Jun 28, 2013 at 8:00 pm
Jun 2013
12
Group Navigation
period‹ prev | Jun 2013 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions84
posts515
users138
websiteoracle.com

138 users for June 2013

Patterson, Joel: 31 posts Hans Forbrich: 23 posts Christopher Taylor2: 20 posts Rjamya: 19 posts Jonathan Lewis: 17 posts Rich Jesse: 16 posts Mark W. Farnham: 15 posts Andrew Kerber: 13 posts Guillermo Alan Bort: 12 posts Ls Cheng: 11 posts David Fitzjarrell: 9 posts John Hurley: 9 posts Martin Klier: 9 posts Niall Litchfield: 9 posts De DBA: 8 posts Jeremy Schneider: 8 posts Don Seiler: 7 posts Kellyn Pot'vin: 7 posts Nuno Souto: 7 posts Scott Canaan: 7 posts
show more
Archives