FAQ

Oracle > oracle-l > January 2013

Search Discussions

109 discussions - 655 posts

  • All - I have been searching the oracle website to see how Oracle handles "hyperthreading" in their processor license, but no luck. I have a server with 2-quad core CPUs or 8 cores, it also has ...
    Bill ZakrzewskiBill Zakrzewski
    Jan 8, 2013 at 1:07 pm
    Jan 16, 2013 at 8:23 pm
  • Hi all, I have a question about database design best pratice. In my db I have about one hundred tables like this: code description To avoid to have a so great number of similar tables in the db I ...
    Jose SoaresJose Soares
    Jan 28, 2013 at 9:12 am
    Jan 31, 2013 at 11:18 pm
  • Hello all As a simple example we will use tables emp and dept (the demo tables) who have a parent child relationship, if we make emp.deptno NOT NULL and we run this query select ename, dname from ...
    AmonteAmonte
    Jan 24, 2013 at 9:08 pm
    Jan 26, 2013 at 11:29 pm
  • Hi all Your opinions please! We are embarking on a new database server build - the sysadmin is keen on Solaris 11.1 and ZFS on the T4-1 server. We will use zones for environment segregation and ...
    ~Jeff~~Jeff~
    Jan 25, 2013 at 12:15 am
    Jan 30, 2013 at 11:42 pm
  • Hi all, I'm trying a query like this: SELECT id, name from anagrafica WHERE id in (100,32,43,66,2,1,334, ...... more than 1000 values) and I got this error: cx_Oracle.DatabaseError: ORA-01795 ...
    Jose SoaresJose Soares
    Jan 2, 2013 at 10:02 am
    Jan 9, 2013 at 10:52 pm
  • Has anybody purchased this book from Don Burleson? It sounds potentially worthwhile but there are no examples of the scripts or what says about each script. Is there good examples of how and when to ...
    Jeff ChircoJeff Chirco
    Jan 31, 2013 at 8:51 pm
    Feb 6, 2013 at 10:02 pm
  • Hi all, I am installing 11.2.0.3 grid infrastructure on RHEL 6 Virtual server and running into the following issue. Run root.sh failed at the end - failed to start nodeapps. Have been working with ...
    Lu JiangLu Jiang
    Jan 24, 2013 at 9:32 am
    Jan 27, 2013 at 5:15 pm
  • All, In our production system(oracle 10.2.0.4) users are complaining slowness when they try to retrive few rows from a tiny table(133 rows in 5 blocks) using �Unique Index Scan�.The index has only 1 ...
    OracledbaOracledba
    Jan 17, 2013 at 7:22 pm
    Jan 20, 2013 at 9:01 pm
  • hi, in the Oracle documentation there is stated that parse time elapsed and sql execute elapsed time are counted on the same level ie. they are accounted into DB time (exec time + parse time + other ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jan 8, 2013 at 11:51 am
    Jan 28, 2013 at 3:39 pm
  • Hi, I am looking for any recommendation or Material for Performance Tuning on Database. Thank you, Sheldon. -- http://www.freelists.org/webpage/oracle-l
    Sheldon QuinnySheldon Quinny
    Jan 28, 2013 at 9:02 am
    Jan 30, 2013 at 9:19 am
  • Would anyone care to comment on the fact that Oracle sales folks are saying that Exadata patching is included in the purchase price of Exadata appliances + support vs. the "patch madness" I keep ...
    Stephens, ChrisStephens, Chris
    Jan 9, 2013 at 1:58 pm
    Jan 14, 2013 at 6:27 pm
  • Hey list, This is backwards enough that I don't quite know where to start with it. This morning we noticed that for one environment, we cannot make direct local connections... but we can connect to ...
    Uzzell, StephanUzzell, Stephan
    Jan 3, 2013 at 2:45 pm
    Jan 9, 2013 at 12:23 am
  • Environment: Appserver1-6 Oracle Weblogic Server 10.3.0.5 Db server 1: Oracle 11.2.0.3.0.x Primary DB Db server 2: Oracle 11.2.0.3.0.x Logical Standby Server 3: Oracle 11.2.0.3.0.x Oracle 11g grid ...
    Bill ZakrzewskiBill Zakrzewski
    Jan 7, 2013 at 6:58 pm
    Jan 8, 2013 at 5:12 pm
  • Hi, ASM 11.1.0.7.0 Solaris 10 We have a diskgoup that won't mount. I'm believe it a SAN/disk issue as opposed to an ASM issue but I'm trying to eliminate some guesswork in troubleshooting this. In ...
    Fergal TahenyFergal Taheny
    Jan 2, 2013 at 5:53 pm
    Jan 6, 2013 at 8:28 pm
  • Hi, I have a query and I want the output ordered. I also want to assign a key to the output using a sequence. I don't care about the ordering in which the key is assigned. *I can't do this:* select ...
    Fergal TahenyFergal Taheny
    Jan 31, 2013 at 5:04 pm
    Feb 1, 2013 at 5:29 pm
  • We get LUNs from various storage devices for building our RACs. They guy who taught me how to set things up said to partition the LUNs so I've always done that with fdisk; however, recently someone ...
    Walker, Jed SWalker, Jed S
    Jan 25, 2013 at 4:38 pm
    Jan 31, 2013 at 7:16 pm
  • If I'm reading this right, for systems with a lot of RAM, the recommended value for 10.2 and above is 16GB for swap when memory is 16GB or higher, *OR* am I reading this entirely incorrectly? It's ...
    Christopher Taylor2Christopher Taylor2
    Jan 22, 2013 at 4:08 pm
    Jan 29, 2013 at 2:16 pm
  • Do most people install Oracle Text when creating a new 11g database? I'm finding that with the newly created databases we get an error when we run utlrp. We haven't been installing Oracle Text in the ...
    Maureen EnglishMaureen English
    Jan 23, 2013 at 2:21 am
    Jan 24, 2013 at 10:53 am
  • Does anyone know of an editor (or program) that will match beginning and ending parentheses in sql and highlight an ending paren that is missing? I thought notepad++ did that, but it's not working ...
    Barbara BakerBarbara Baker
    Jan 16, 2013 at 6:37 pm
    Jan 16, 2013 at 9:03 pm
  • YèZ½æ§¢—§Šx¢¶’¬êÚrWƒŸj|¨ïìŠ{^­ë-yßÔý/܊سz{(ž\ÿý'§vgšéšŠV­Á¹ZÈZ­ßè²(²(®ŸÜ¢hŸŠ{^­ë-yßÒPÃèºwlr·žž)à­ê®Š·¦z{lüD’ÔÈÞz)ȝú+™«b¢t²²×¦²ŠëzV­y×âzWpŠØZ¶Wš²ß ...
    WblanchardWblanchard
    Jan 30, 2013 at 2:52 pm
    Jan 30, 2013 at 9:43 pm
  • G'day I am running into the most stupefying error. The version is 11.2.0.3.3, OS is solaris 11, in a local zone. The zone has 72G of RAM and 72G of swap allocated. The memory parameters are ...
    De DBADe DBA
    Jan 15, 2013 at 7:16 am
    Jan 17, 2013 at 6:57 am
  • Hi, Just a tiny wish from me - my email threading OCD goes mad when somebody replies to a previous thread in order to start a new one [by changing the subject of the email]. It doesn't create a new ...
    Philip JonesPhilip Jones
    Jan 14, 2013 at 6:17 pm
    Jan 15, 2013 at 6:38 am
  • Hello, In our application, we are going record some specific user triggered events. These triggered events are often specific pages access and user clicks on some web page controls. At first, these ...
    Bruno LavoieBruno Lavoie
    Jan 24, 2013 at 6:05 pm
    Jan 25, 2013 at 7:40 am
  • So I have all the classic queries for finding blockers and waiters. I keep running into the situation where I have one holder and 600 waiters. I clear off the blocker and then another one picks up ...
    John D ParkerJohn D Parker
    Jan 9, 2013 at 4:28 pm
    Jan 23, 2013 at 8:07 pm
  • I'm curious how many of you guys have set CURSOR_SHARING=FORCE from EXACT in a development or test database (or even production) and what led you to set it? My only experience with CURSOR_SHARING ...
    Christopher Taylor2Christopher Taylor2
    Jan 22, 2013 at 6:43 pm
    Jan 24, 2013 at 1:13 pm
  • Looking at this news, I wonder what kind of storage media do the listers here use and what kind of backup media they have. Anyone using any external hard drive for live data? ...
    Ram KRam K
    Jan 22, 2013 at 10:44 pm
    Jan 23, 2013 at 1:48 pm
  • List, Traditionally we've supported databases with Solaris servers using VCS. These are medium-sized databases with average availability requirements. Nothing leading-edge. We are considering a new ...
    Dennis WilliamsDennis Williams
    Jan 15, 2013 at 9:29 pm
    Jan 18, 2013 at 10:03 am
  • Hi, I have a question for your all, i don´t understand because in v$session we have many sessions (BMC/REMEDY) with different sid and same serial#. I tried to find something about this behavior but i ...
    Rafael Alberto HernandezRafael Alberto Hernandez
    Jan 10, 2013 at 8:01 am
    Jan 10, 2013 at 5:16 pm
  • So I changed the subject a bit here - does anyone have recommendations on running VMs off of SSDs versus SATAs? (I've seen to stay away from 5400rpm SATAs for performance reasons) I'm trying to gauge ...
    Christopher Taylor2Christopher Taylor2
    Jan 3, 2013 at 2:50 pm
    Jan 4, 2013 at 8:42 am
  • Can I take an export of an oracle database instance from windows and drop it on a unix box? ciao, Brian This email message may contain legally privileged and/or confidential information. If you are ...
    Zelli, BrianZelli, Brian
    Jan 17, 2013 at 5:14 pm
    Jan 17, 2013 at 6:59 pm
  • I used to configure AMM assigning appropiate values to sga_target and pga_aggregate_target but nearly all my dbs have more memory assigned to shared_pool than buffer_cache. v$sgainfo; NAME BYTES RES ...
    Juan MirandaJuan Miranda
    Jan 8, 2013 at 2:49 pm
    Jan 14, 2013 at 12:57 pm
  • Hello All, we have configure Oracle goldengate on 11.2.0.X RAC databases. In a scenriors if any of the nodes or instances crashes we need the goldengate manager & extract process to relocate to other ...
    Nagaraj SNagaraj S
    Jan 31, 2013 at 6:27 pm
    May 9, 2013 at 10:50 am
  • Hello, I recently created my first logical standby database. I have noticed that when I update a data from a table in the primary database, the data doesn't transfer over to the equivalent table on ...
    Joseph David PaparoJoseph David Paparo
    Jan 28, 2013 at 8:17 pm
    Jan 28, 2013 at 10:01 pm
  • Would I be able to put an oracle client on a thumb drive and use it from one machine and then another? Couldn't quite get a straight answer from googling it..... ciao, Brian This email message may ...
    Zelli, BrianZelli, Brian
    Jan 28, 2013 at 6:19 pm
    Jan 28, 2013 at 9:53 pm
  • I've googled this but can you do grants on a schema? I have a little proc that could loop thru and run the grant but I thought that maybe there was a one-liner to do it..... ciao, Brian This email ...
    Zelli, BrianZelli, Brian
    Jan 11, 2013 at 7:49 pm
    Jan 14, 2013 at 5:07 pm
  • Currently our part of our ASM disk layout looks like the below. Since I'm new to ASM and RAC, I'm wondering if I could improve this layout (that I inherited) - I'm not sure how many physical devices ...
    Christopher Taylor2Christopher Taylor2
    Jan 31, 2013 at 12:51 pm
    Feb 2, 2013 at 5:10 pm
  • I'm working on a migration from OEM11 to OEM12 and running into an issue with regards to host targets after removal from OEM12. As a test I performed a silent install of the agent to a test server, ...
    Ryan JanuaryRyan January
    Jan 18, 2013 at 9:52 pm
    Jan 23, 2013 at 2:59 pm
  • All, I created a stored procedure that analyzes the tables in a small schema. The procedure is owned by one user and was created with authid current_user, so it can be run by another user. It runs ...
    Scott CanaanScott Canaan
    Jan 21, 2013 at 2:58 pm
    Jan 22, 2013 at 12:45 pm
  • Hi, Tablespace logging level takes precedence if no explicit option is provided. check the tablespace level settings for the new partitions and do an alter tablespace logging to change that behaviour ...
    Sriram KumarSriram Kumar
    Jan 21, 2013 at 11:33 am
    Jan 22, 2013 at 8:13 am
  • Is there a way to push EM12c agents onto unix hosts where the DBA does not have privileges to sudo to root? I tried pushing it by entering bogus sudo information, but the agent deployment just fails, ...
    Patrice sur GMailPatrice sur GMail
    Jan 18, 2013 at 11:23 am
    Jan 18, 2013 at 7:22 pm
  • All, I am a newbie to Oracle. Can someone write a SQL to show tablespace's growth weekly like week1,week2,week3,week4 of each month? The table has the following columns and populated everyday ...
    OracledbaOracledba
    Jan 9, 2013 at 8:02 pm
    Jan 10, 2013 at 4:49 pm
  • In the platform guide for Oracle 11.2 on windows 64-bit, it states to set the server to be an application server "You can reset the Windows Server memory model from the default file and print server, ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jan 29, 2013 at 8:59 pm
    Jan 30, 2013 at 8:27 am
  • We have the peculiar SQL statements that are executed in PL/SQL as an "execute immediate" for application reasons. When I look up the SQL statement and get the SQL_ID and check DBA_HIST_SQLSTAT, I'm ...
    Christopher Taylor2Christopher Taylor2
    Jan 24, 2013 at 1:19 pm
    Jan 25, 2013 at 7:31 am
  • Hi All, We have a customer who recently started complaining about performance of our application which had been running smoothly for several years. On looking at some AWR reports the top wait was 'PX ...
    Fred TillyFred Tilly
    Jan 24, 2013 at 10:28 am
    Jan 24, 2013 at 2:25 pm
  • -- http://www.freelists.org/webpage/oracle-l
    Dennis WilliamsDennis Williams
    Jan 18, 2013 at 2:16 pm
    Jan 19, 2013 at 1:49 pm
  • If you need to upload files to MOS as part of an SR resolution, you might find a problem since the latest update (January 13th I think) of MOS. It appears that IE needs a setting changed to allow ...
    Norman DunbarNorman Dunbar
    Jan 16, 2013 at 4:52 pm
    Jan 17, 2013 at 1:59 pm
  • Currently for our .Net applications call a web service that runs in IIS which then access the Oracle database. When I query v$session the OS User listed as making the call shows as "SYSTEM". Does ...
    Jeff ChircoJeff Chirco
    Jan 11, 2013 at 4:27 pm
    Jan 11, 2013 at 8:35 pm
  • I have a pfile available - SPFILE is in ASM but db won't start because I wasn't thinking when I resized SGA MAX size and made it too small. Any suggestions? Chris Taylor Oracle DBA Parallon IT&S -- ...
    Christopher Taylor2Christopher Taylor2
    Jan 11, 2013 at 5:05 pm
    Jan 11, 2013 at 5:19 pm
  • Hi all, Have any body applied patch set to Oracle client 11.2.0.1? The database patch set 11.2.0.2 is actually not a patch, it is a full install. So how can I patch Oracle client from 11.2.0.1 to ...
    Lu JiangLu Jiang
    Jan 9, 2013 at 5:43 pm
    Jan 9, 2013 at 7:17 pm
  • The -s is for silent mode. sqlplus -h is the help menu and can explain more about the -s options. Bobby L. Curtis (e): <span class="m_body_email_addr" title="287ca87a1f1621d422c0922d7bc99a46" ...
    Bobby CurtisBobby Curtis
    Jan 7, 2013 at 6:22 pm
    Jan 8, 2013 at 1:05 am
Jan 2013
123
Group Navigation
period‹ prev | Jan 2013 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions109
posts655
users169
websiteoracle.com

169 users for January 2013

Christopher Taylor2: 54 posts Hans Forbrich: 26 posts De DBA: 15 posts Niall Litchfield: 14 posts Oratune: 14 posts Sayan Malakshinov: 14 posts Sriram Kumar: 14 posts Andy Gmail: 12 posts Radoulov, Dimitre: 12 posts Tanel Poder: 12 posts Jonathan Lewis: 11 posts Lu Jiang: 11 posts Mark W. Farnham: 11 posts Rich Jesse: 11 posts Fergal Taheny: 10 posts Guillermo Alan Bort: 10 posts Norman Dunbar: 10 posts Saibabu Devabhaktuni: 9 posts Amonte: 8 posts Jorgensen, Finn: 8 posts
show more
Archives