Search Discussions

80 discussions - 396 posts

  • Afternoon all. I've been working on a listener problem all day. Because there is quite a bit of evidence, I've posted the problem on my blog at http://t.co/ss0KHSbfSd - if you care to take a look and ...
    Norman DunbarNorman Dunbar
    May 10, 2013 at 4:50 pm
    May 12, 2013 at 5:47 pm
  • -- http://www.freelists.org/webpage/oracle-l
    Jeffrey BeckstromJeffrey Beckstrom
    May 21, 2013 at 12:47 pm
    May 28, 2013 at 7:42 pm
  • Hi all Does anyone know a way to add "dummy" rows to a resultset? I have current result: * C1 C2 MYDATE ---------- ---------- --------- 1 100 24-MAY-13 2 200 24-MAY-13 2 201 24-MAY-13 3 300 24-MAY-13 ...
    Ls ChengLs Cheng
    May 24, 2013 at 8:21 am
    May 24, 2013 at 6:42 pm
  • Guys/Gals, I'm in the process of configuring hugepages in RAC. Since ASM starts up first, how I do prevent it from using any of the hugepages? Regards! Chris Taylor Oracle DBA Parallon IT&S ...
    Christopher Taylor2Christopher Taylor2
    May 17, 2013 at 5:58 pm
    May 18, 2013 at 9:21 am
  • Hi When adaptive cursor sharing is in action does the database peek the bind variables over and over again? i.e does the database find out the bind literal value in order to determine weather the ...
    May 30, 2013 at 4:53 am
    Jun 4, 2013 at 6:37 am
  • Oracle version numbers are fun, aren't they? compatible in init.ora, the nice message when you log off telling you what version of Oracle you're running down to the 5th digit but the last one always ...
    Patrice sur GMailPatrice sur GMail
    May 22, 2013 at 1:15 pm
    May 24, 2013 at 1:22 pm
  • Ok, the dev group wants the instance name changed. I saw some articles when I googled but wondered what is the quickest way to rename an instance? ciao, Brian This email message may contain legally ...
    Zelli, BrianZelli, Brian
    May 10, 2013 at 5:35 pm
    May 10, 2013 at 7:18 pm
  • rk. It seems simple enough, but I'm doing something very basic, wrong. I can't figure it out and Oracle support has been useless. Does anyone have a document on how to configure Data Guard, ...
    Scott CanaanScott Canaan
    May 29, 2013 at 5:45 pm
    May 30, 2013 at 7:11 am
  • Dear friends, I am planing to do interview for Oracle DBA position. Interviewers are people from system engineering and database management departments. Please share you experience and give me some ...
    Tiran HarutyunyanTiran Harutyunyan
    May 31, 2013 at 6:43 pm
    Jun 11, 2013 at 4:14 pm
  • I am trying to install the Apr 2013 PSU using opatch auto, and I get this error while patching the grid home, oracle on linux x86-64. The error below is in the log file: 2013-05-29 ...
    Andrew KerberAndrew Kerber
    May 29, 2013 at 11:19 pm
    Jun 5, 2013 at 7:09 pm
  • #12 All NoCOUG emails automatically go to your spam folder, including this one. You rely on Outlook for career guidance. #11 They won’t send a stretch limousine to pick you up and take you back. #10 ...
    Iggy FernandezIggy Fernandez
    May 21, 2013 at 10:21 pm
    May 24, 2013 at 2:01 pm
  • It is rather easy to measure a candidate's technical knowledge. However, having interviewed many many DBA's, I'm finding it difficult and less reliable to measure these 2 traits ... 1) Being ...
    May 14, 2013 at 2:15 pm
    May 19, 2013 at 9:27 pm
  • Hi ADG experts, I have installed Oracle 11g data guard in our live environment , now I think about to add second standby DB, can I do that? I mean is Oracle 11g support 2 way replication with Data ...
    Tiran HarutyunyanTiran Harutyunyan
    May 14, 2013 at 2:27 pm
    May 14, 2013 at 4:23 pm
  • Running into interesting behavior with execution plans in (running on Exadata x3 platform). The below query was executed at roughly the same time, against the same environment, originating ...
    Ross LaffertyRoss Lafferty
    May 1, 2013 at 8:16 pm
    May 2, 2013 at 12:09 pm
  • Oracle Production OS: Solaris (don't know the version) We insert date data that comes in a variety of timezones. We can tell what timezone each record is in. We need to normalize this date ...
    Dba DBADba DBA
    May 23, 2013 at 5:45 pm
    Jun 4, 2013 at 6:44 pm
  • List, How long do the listers keep their alert log data for? does it vary in production vs dev environments. Thanks. -- http://www.freelists.org/webpage/oracle-l
    Ram RamanRam Raman
    May 31, 2013 at 6:02 pm
    Jun 3, 2013 at 1:43 pm
  • Hi, We have implemented a customized Oracle EBS R12 recently and faced a severe performance issue in first few weeks due to following query DELETE FROM XLA_DISTRIBUTION_LINKS WHERE APPLICATION_ID = ...
    Ankit ThakwaniAnkit Thakwani
    May 27, 2013 at 1:13 pm
    May 31, 2013 at 12:20 pm
  • Hello, I'm trying to find out if there's a better/faster way to find the existence of a row. The vendor has this query: select 'Y' from <table c where c.<col1 = a.<col1 and rownum = 1 I made this ...
    Lyall BarbourLyall Barbour
    May 21, 2013 at 2:27 pm
    May 22, 2013 at 8:06 pm
  • If you really want to use Chrome and dislike the "other" browser, there is an IE plugin for both Firefox and Chrome. This allows you to create a Chrome/Firefox window/tab with IE capabilities for ...
    Christopher Taylor2Christopher Taylor2
    May 16, 2013 at 6:18 pm
    May 20, 2013 at 6:04 am
  • This is Oracle running on Windows Server 2003 v 5.2 SP2 (64 bit), Grid Control 11g. Under backup settings - policy I specified: Retain at least 2 backups Retain archived redo logs after they ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    May 28, 2013 at 3:19 pm
    May 29, 2013 at 8:56 pm
  • List, One of our colleagues is suggesting that we create a backup table for exporting and storing statistics, in all databases, many of them 10g. The purpose of this backup table would be to store ...
    Orlando LOrlando L
    May 7, 2013 at 6:46 pm
    May 8, 2013 at 12:52 pm
  • Database 11.2 If I have highly skewed data, will oracle balance out the sub-partitions? I won't have real production data to measure the skew until I actually deliver this. So we are trying to ...
    Dba DBADba DBA
    May 2, 2013 at 2:52 pm
    May 7, 2013 at 5:56 pm
  • I'm just now beginning to work through the hugepages configuration on Linux 5.8 64-bit, running Oracle Dev and QA are both 3 node RAC systems running 4 separate databases in each ...
    Christopher Taylor2Christopher Taylor2
    May 1, 2013 at 5:46 pm
    May 2, 2013 at 1:13 pm
  • I'm trying to think of a way we could leverage SSD technology on RedHat on local server nodes in a safe, and controlled manner (if at all). The only thing I can think of currently is to create a ...
    Christopher Taylor2Christopher Taylor2
    May 29, 2013 at 4:15 pm
    May 29, 2013 at 8:25 pm
  • I have two servers that look like they are running the same database. It is a vendor machine, vendor setup and I don't have access but when I look at the listener, it has the same sid and ip address ...
    Zelli, BrianZelli, Brian
    May 23, 2013 at 5:27 pm
    May 23, 2013 at 6:24 pm
  • Dear list, how can I manually add a bucket to an existing Frequency Based histogram? I have a FB histogram that has buckets for STATUS=100,99 and 40. But sometimes the table has thousands of rows ...
    Martin KlierMartin Klier
    May 13, 2013 at 12:19 pm
    May 15, 2013 at 4:01 pm
  • We have spoken to Oracle sales after a long holiday and they are steering us hard toward Oracle Appliances to reduce the multiple core's cost. Are we safe with that route? Howard A. Latham -- ...
    Howard LathamHoward Latham
    May 14, 2013 at 2:21 pm
    May 15, 2013 at 6:39 am
  • /à»+™ëZ¦º•éÿ"z'z‡èº°Áÿ]ÿÛýÿçÿð éê¹êòj)Ý{§v+l–‡µçmi¹^²–œ{ò¢éݶ­i¹^²–œ{ùÚ™è¬5BËjwb·û'¢Ö©j»b¶*'yاuì^³ó–4DS"ž 'ý8ZžK/z¼¦¹Èÿ -- http://www.freelists.org/webpage/oracle-l
    May 9, 2013 at 4:12 am
    May 10, 2013 at 3:17 am
  • oracle Since ASSM uses different size extents, are there any issues with fragmentation? There was an Oracle-L thread dating from 2007 that discussed this. I have multiple tables that need to ...
    Dba DBADba DBA
    May 3, 2013 at 7:10 pm
    May 7, 2013 at 8:33 pm
  • Hi DBA gurus, I am do a performance test. Find that running same query using tns connection string with SCAN host name is 5 seconds slow than using tns connection string points to a specific host ...
    Lu JiangLu Jiang
    May 2, 2013 at 2:11 pm
    May 2, 2013 at 3:42 pm
  • Oracle -- hourly partitions -- inserting by 4 java processes simulataneous -- oracle job runs once/hour to drop partitions over a set number of hours old. -- the java processes are using a ...
    Dba DBADba DBA
    May 28, 2013 at 9:09 pm
    May 29, 2013 at 11:37 am
  • -- http://www.freelists.org/webpage/oracle-l
    Jeffrey BeckstromJeffrey Beckstrom
    May 21, 2013 at 11:46 am
    May 21, 2013 at 1:12 pm
  • Hi all, Does anyone know what the best way to migrate databases from solaris sparc to linux x86-64? It appears that we will need to do an endian conversion and we were thinking of doing transportable ...
    Joseph David PaparoJoseph David Paparo
    May 14, 2013 at 9:07 pm
    May 15, 2013 at 7:33 am
  • I have two instances, 10g and 11g on one server and now they want me to add another 11g instance. Is there some white paper on how to parse up the RAM on the server to even distribute to all 3 ...
    Zelli, BrianZelli, Brian
    May 7, 2013 at 2:47 pm
    May 7, 2013 at 6:26 pm
  • All I am working on re-architect existing high transaction OLTP system facing customers with 1Million users per hour. It is on Oracle 11.2 Version on Enterprise Linux with 2 node RAC. This system ...
    Karth PanchanKarth Panchan
    May 7, 2013 at 12:11 am
    May 7, 2013 at 12:35 pm
  • My new boss has decided I need training so I can become the data architect, as well as the only DBA for 19 Oracle, 4 PostgreSQL, and 5 MongoDB databases. I'm basically a good DBA and I know some ...
    Sandra BeckerSandra Becker
    May 2, 2013 at 8:58 pm
    May 6, 2013 at 7:22 pm
  • All: As the DBA Team Lead, I am in a dilemma. One of my experineced DBA insists that the developers/programmers must use the Designer tool to design the table structures, modify the design, and other ...
    Ram SrinivasanRam Srinivasan
    May 1, 2013 at 8:10 pm
    May 2, 2013 at 4:16 am
  • Hi, Iam trying to setup an two node Oracle RAC on RHEL 5.4 using a virtual Box. Before installing the Grid Infrastructure , I ran the runcluvfy for pre crsinst and verified that there was no ...
    Mohammed Mehraj HussainMohammed Mehraj Hussain
    May 31, 2013 at 1:52 pm
    Jun 3, 2013 at 1:31 pm
  • I setup a single instance database with a DATA and an FRA disk group. Both groups use external redundancy. We had a power outage here yesterday, and the system crashed. When trying to restart the ...
    MacGregor, Ian A.MacGregor, Ian A.
    May 31, 2013 at 7:37 pm
    May 31, 2013 at 8:31 pm
  • Hi Everyone, In one of our QA servers,RMAN incremental backup(s) is running for last 8 days in tape (Netback -Veritas), Large pool was not configured there , Operating system is Solaris SPARC 64 bit ...
    Sandip MukhopadhyaySandip Mukhopadhyay
    May 30, 2013 at 1:37 am
    May 31, 2013 at 6:12 pm
  • (Oracle AIX 6.1, 40 logical cpu's (20 cpu's SMT2)) Hi I have the following parameters (which I think is the one needed to know) parallel_degree_policy=auto parallel_degree_limit=24 ...
    Johan ErikssonJohan Eriksson
    May 30, 2013 at 6:39 pm
    May 30, 2013 at 7:30 pm
  • Hi, There is a code that run on 10g sucessfully. After migration to 11g started getting ORA-00060 (Deadlock). Then looking for solutions, people got it this link ...
    Eriovaldo AndriettaEriovaldo Andrietta
    May 25, 2013 at 3:29 pm
    May 25, 2013 at 5:18 pm
  • Hello. I am trying to find out the most optimal way of writing sql for a particular problem. I have two tables TEST_MST & TEST_TRN CREATE TABLE TEST_MST( ID NUMBER, SHIP NUMBER, MERCHANT NUMBER, BILL ...
    Rajiv IyerRajiv Iyer
    May 23, 2013 at 3:36 pm
    May 24, 2013 at 9:46 am
  • I am trying to do an RMAN duplication. I can't active duplicate, so I need to put all the backup files on the ASM instance in another RAC, but am having problems with the copies. I am on ...
    Walker, Jed SWalker, Jed S
    May 9, 2013 at 9:08 pm
    May 10, 2013 at 1:37 pm
  • Is there a plug-in to monitor Windows hosts? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority Information Systems 1240 W. 6th Street Cleveland, Ohio 44113 -- ...
    Jeffrey BeckstromJeffrey Beckstrom
    May 9, 2013 at 4:36 pm
    May 9, 2013 at 5:41 pm
  • Bad news, this SQL statement caught a 4031. Only 17,819 binds. No, I didn't write it. Cursor_sharing was set to 'FORCE'. No, I didn't set it that way. ----- Current SQL Statement for this session ...
    May 2, 2013 at 7:55 pm
    May 9, 2013 at 3:58 pm
  • I dont do much with Con Text indexes, so I am probably missing something simple, but I am trying to move a context index to a different tablespace. I found one sample, but it is erroring out. Can ...
    Andrew KerberAndrew Kerber
    May 8, 2013 at 10:12 pm
    May 9, 2013 at 1:58 pm
  • hi all, any idea how to figure out know who runs expdp command from dba_ views. please help i am trouble somebody its blunder & we don't know that guy? -- Amit Verma <span class="m_body_email_addr" ...
    May 7, 2013 at 6:32 am
    May 7, 2013 at 6:39 am
  • Hi All, Our application delvelopers have enabled a sql trace at concurrent program level.I've found the session of that and disabled a sql trace for that session at the backend using dbms_system pkg ...
    Bala KrishnaBala Krishna
    May 2, 2013 at 10:31 am
    May 3, 2013 at 4:41 am
  • Please let me know if any one have documentation on HPDMA(HP database middleware automation) tool. Thank You -- http://www.freelists.org/webpage/oracle-l
    Nagaraj SNagaraj S
    May 23, 2013 at 7:22 am
    May 29, 2013 at 10:38 am
Group Navigation
period‹ prev | May 2013 | next ›
Group Overview
grouporacle-l @

137 users for May 2013

Christopher Taylor2: 17 posts Andy Gmail: 15 posts Jonathan Lewis: 15 posts Norman Dunbar: 13 posts Mark W. Farnham: 12 posts Patterson, Joel: 12 posts Hans Forbrich: 11 posts Ls Cheng: 11 posts Dba DBA: 10 posts Jeffrey Beckstrom: 10 posts Breitliw: 8 posts Don Granaman: 7 posts Larry Elkins: 7 posts Nuno Souto: 7 posts Bobak, Mark: 6 posts Guillermo Alan Bort: 6 posts Iggy Fernandez: 6 posts Freeman CTR Donald: 5 posts Niall Litchfield: 5 posts Rjamya: 5 posts
show more