Search Discussions

73 discussions - 471 posts

  • This probably has been asked before but what is everybody's PL/SQL development tool they use? I currently use PL/SQL Developer by Allround Automations and I like. It is cheap, simple, and easy to use ...
    Jeff ChircoJeff Chirco
    Jul 17, 2012 at 7:36 pm
    Sep 27, 2012 at 10:32 am
  • Hello, (I have also posted this to forums.oracle.com in case this sounds familiar to someone). we have a production server that is running Oracle on Windows and a Development/Test server ...
    Thomas KellererThomas Kellerer
    Jul 23, 2012 at 3:03 pm
    Jul 30, 2012 at 6:09 am
  • Hi Lists Maybe the question is not so easy as it looked from subject. Session 1: SQL update t set n=2 where n=1; <<==== no commit here SQL select sysdate from dual; SQL select table_name from tabs ...
    Leyi Kamus ZhangLeyi Kamus Zhang
    Jul 2, 2012 at 7:52 am
    Jul 4, 2012 at 7:29 pm
  • Hi listers, I know several of you have rolled out EM 12c fairly successfully, so I'm hoping someone can point me in the right direction here. I've made my way through the OMS install, and the ...
    Uzzell, StephanUzzell, Stephan
    Jul 18, 2012 at 1:50 pm
    Jul 19, 2012 at 6:51 pm
  • For a shop with 30 instances on a dozen hosts, would it make sense to use Grid Control EM 11g or EM 12c to deploy PSUs? Is one more reliable than the other? Our approach is opatch. And each quarter ...
    Dana NibbyDana Nibby
    Jul 20, 2012 at 8:39 am
    Jul 25, 2012 at 4:29 pm
  • Remember how much we hated the flash based version of My Oracle Support when it was introduced? I hate the new version even more. Blah. -- http://www.freelists.org/webpage/oracle-l
    Adams, Matthew (GE, Appl & Light)Adams, Matthew (GE, Appl & Light)
    Jul 16, 2012 at 6:19 pm
    Jul 24, 2012 at 4:50 pm
  • Hi, I have an SR with Oracle for this, but perhaps some of you have encountered this issue before. We have the following set up: 1. RHEL 5.8 (standard RH kernel) 2. Oracle RAC (Jan PSU) 3 ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 26, 2012 at 4:45 pm
    Jul 28, 2012 at 5:23 pm
  • Oracle Enterprise Edition: OS: RHL. Hi, I have a table with 1.8 billion rows, on which I created a non unique index and now I am trying to add in a primary key constraint using that ...
    Peter HitchmanPeter Hitchman
    Jul 10, 2012 at 3:59 pm
    Jul 12, 2012 at 3:44 pm
  • Folks, I have a three-node Oracle RAC environment running on Solaris 10. The Grid and DB versions are and respectively. We ran a load test against the environment to simulate our ...
    Hameed, AmirHameed, Amir
    Jul 30, 2012 at 8:16 pm
    Aug 3, 2012 at 5:12 am
  • Folks, I'm monitoring a VERY large rollback operation and could use some help in understanding conflicting values for USED_UREC in V$TRANSACTION. This is for on RHEL 5.6. The transaction was ...
    Herring Dave - dherriHerring Dave - dherri
    Jul 6, 2012 at 5:21 pm
    Jul 7, 2012 at 11:24 am
  • I'm running 10 and 11 on the same box REDHAT Enterprise I'm sure Oracle had a script that read oratab and started say a 9 a 10 and an 11 database using the correct homes. Or Did I dream it? -- Howard ...
    Howard LathamHoward Latham
    Jul 17, 2012 at 3:12 pm
    Jul 17, 2012 at 8:21 pm
  • Anyone know of any particular system or application reason to favor udev over oracleasm or vice versa? Chris Taylor "Quality is never an accident; it is always the result of intelligent effort." -- ...
    Taylor, Chris DavidTaylor, Chris David
    Jul 6, 2012 at 2:46 pm
    Jul 12, 2012 at 6:35 pm
  • Hi, We have a 10205 database on Solaris SPARC with ASMM enabled and sga_target & sga_max_size = 4G. What we observe is that shared_pool has grown from 700MB to 1.6GB in last 3 months whereas buffer ...
    Purav ChovatiaPurav Chovatia
    Jul 9, 2012 at 2:39 pm
    Jul 11, 2012 at 2:05 pm
  • Anyone know of a simpler way to map the database name to the running instance ID? Assume we could have a non-rac database called FOO1, and a rac database called FOO with instance FOO2 running on the ...
    Ethan PostEthan Post
    Jul 18, 2012 at 8:49 pm
    Aug 2, 2012 at 11:21 am
  • I have a system that when system stats are gathered (using either no workload or with a workload) show a value of about 1260 for cpuspeed/cpuspeednw. The server is IBM p7 with 3.5ghtz cpu's. I ...
    Kenneth NaimKenneth Naim
    Jul 26, 2012 at 4:56 pm
    Jul 31, 2012 at 8:46 am
  • If your purpose is to construct a create user script with all privs, roles etc, please check if the following script helps. It won't give you neat commands, some edits needed to apply it to other ...
    Jul 26, 2012 at 12:29 am
    Jul 30, 2012 at 10:19 am
  • Hi All, I am trying to set up RAC to RAC dataguard between 2 databases in different data centers. I am able to ship archivelogs from primary to DR. The logs are not getting applied. In the standby ...
    Jul 2, 2012 at 10:58 am
    Jul 6, 2012 at 2:37 am
  • Hey all, I backup metadata for 6 schemas a few times per day in our Dev DB on AIX 5.3 using DP export to a directory on disk: time expdp / \ content=metadata_only \ exclude=statistics,grant \ ...
    Rich JesseRich Jesse
    Jul 31, 2012 at 5:31 pm
    Aug 14, 2012 at 4:18 pm
  • I am going to OOW for the first time this year, and my wife has decided to go with me. Are there usually activities for spouses at OOW? I have gone through the web site and not found anything yet. -- ...
    Andrew KerberAndrew Kerber
    Jul 21, 2012 at 4:29 pm
    Aug 1, 2012 at 2:00 pm
  • So, why does "crs_stat -t" formatting not adjust correctly to my terminal size? (I'm using the default gnome-terminal in Oracle Linux so any suggestions along that line are also appreciated) $ ...
    Taylor, Chris DavidTaylor, Chris David
    Jul 9, 2012 at 3:23 pm
    Jul 12, 2012 at 9:06 am
  • Hello list, I'm curious to hear stories about Kernel UEK, either one or two and its adoption in the industry. Given that Red Hat seems to be consistently producing great financial results one wonders ...
    Martin BachMartin Bach
    Jul 11, 2012 at 1:17 pm
    Sep 3, 2012 at 2:42 pm
  • Hello Gurus, Doubt on gird software installation.. I have RAC setup already running on my system and i decided to upgrade my crs/asm/db to 11gr2, in that case is it possible to install 11gr2 ...
    Nagaraj SNagaraj S
    Jul 23, 2012 at 5:11 pm
    Aug 3, 2012 at 12:28 pm
  • Hi, The below query is going for 79000 executions when bind variables are used. Select COUNT ( InID) From InD PPR BO95_PPR where IND.PPR = PPR. PPRName AND ( ( ( ( ( ( AGD = :1 ) AND ( AGUD is null ) ...
    Nisha MohanNisha Mohan
    Jul 19, 2012 at 6:58 am
    Jul 26, 2012 at 3:24 pm
  • Hey all, On my EM 12c Agents on AIX (BP1 not yet available), I'm confused as to what the ORACLE_HOME and AGENT_HOME should be. Under $ORACLE_BASE, I have these candidate dirs: $OB/agent12g -- ...
    Rich JesseRich Jesse
    Jul 17, 2012 at 3:35 pm
    Jul 18, 2012 at 4:29 pm
  • Hi, We need to schedule a few database backups as well as archivelog backups. We've been doing that with cron scripts, but since we're moving to RAC I fear that the cron scripts won't cut it. I've ...
    Guillermo Alan BortGuillermo Alan Bort
    Jul 13, 2012 at 7:24 pm
    Jul 13, 2012 at 9:23 pm
  • Two questions I'm interested in answering or getting opinions on are: 1. what is considered great, good, ok and bad I/O and why? what do you use? latency values, throughput values, spread (ie like ...
    kyle Haileykyle Hailey
    Jul 30, 2012 at 6:48 pm
    Sep 30, 2012 at 6:28 pm
  • Hi all, I have an interesting situation: a three nodes cluster (using oracle grid infrastructure) hosting about 20 instances. The cluster is acting as a normal failover cluster, each instance has 3 ...
    Stefano CislaghiStefano Cislaghi
    Jul 30, 2012 at 1:31 pm
    Aug 31, 2012 at 8:11 pm
  • Hi Gerry, a note on the redundancy part: It is not redundant. The emcli does in no way use any of the rdbms binaries, let alone anything inside the database itself. You can install an emcli on any ...
    Robert HanuschkeRobert Hanuschke
    Jul 30, 2012 at 3:09 pm
    Aug 7, 2012 at 12:32 am
  • Quick question for any peoplesoft DBAs out there... I'm trying to help a client troubleshoot a peoplesoft issue. This is more of an app tier question... but I just thought maybe someone in this list ...
    Jeremy SchneiderJeremy Schneider
    Jul 20, 2012 at 6:22 pm
    Jul 21, 2012 at 5:41 am
  • Hi Everybody, we have 4 node rac cluster. Node 4 crashed. All the services on node 4 moved to node1. how can I evenly distribute the services instead all services going to node1 ? for example: i have ...
    Jul 18, 2012 at 11:31 am
    Jul 18, 2012 at 12:44 pm
  • Common sense says "data usage on RAC nodes- aligned to table partitions " should do better. Say, a table list partitioned on state column, thus dividing Txn activity of major states such as NY and CA ...
    Jul 10, 2012 at 2:00 am
    Jul 11, 2012 at 2:41 am
  • YêÞŸÿÿ·£ºË]ŠÇ.²È§‚Øb±§ÞÞ’Æ £ð¡®+k)h¯ÿÿB楊ܢ²w¯z¶§iÇ"uéíþ+b±©pk+- ...
    Taylor, Chris DavidTaylor, Chris David
    Jul 2, 2012 at 5:17 pm
    Jul 2, 2012 at 5:33 pm
  • I wish Oracle would open source the old Java console code, to let us fix minor bugs in it and to update it. I especially liked the old database objects comparison wizard... -- Patrice ...
    Patrice sur GMailPatrice sur GMail
    Jul 23, 2012 at 1:05 pm
    Aug 1, 2012 at 1:57 am
  • Please tell me how to find the size of voting file size located in raw disk -Nagaraj -- http://www.freelists.org/webpage/oracle-l
    Nagaraj SNagaraj S
    Jul 19, 2012 at 11:34 am
    Jul 30, 2012 at 3:11 pm
  • Hey all, Upgrading our 10.1 DB to 11.2 and JDEdwards isn't liking it, because it's trying to load an 11.1 32-bit library from the 64-bit install on AIX 5.3 TL12. Of course, 11.2 isn't a certified ...
    Rich JesseRich Jesse
    Jul 28, 2012 at 6:12 pm
    Jul 28, 2012 at 6:40 pm
  • Hi I have a report that I run on EM 12c to display alerts for the last 7 days. The resulting information includes "...the past alerts that are still open". Can anyone tell me how to close these open ...
    Gerry MillerGerry Miller
    Jul 26, 2012 at 4:55 am
    Jul 27, 2012 at 7:53 pm
  • Hello Michael, I agree. As a concrete example, I recently consolidated several database backups into a single RMAN catalog. The RMAN catalog was installed on a dedicated machine running 11.2. This ...
    David RobillardDavid Robillard
    Jul 20, 2012 at 11:21 am
    Jul 20, 2012 at 7:16 pm
  • Deletion of Archived Redo Logs As explained in "Basic Concepts of Backup and Repository Maintenance", the recommended maintenance strategy is to configure a fast recovery area, a backup retention ...
    Patrice sur GMailPatrice sur GMail
    Jul 16, 2012 at 1:12 pm
    Jul 19, 2012 at 3:51 am
  • Hi List. I'm building a OEM 12c environment for monitoring and tuning my employers databases. This is to replace the old OEM environment we currently use. One of many problems I've run into ...
    Jorgensen, FinnJorgensen, Finn
    Jul 2, 2012 at 5:59 pm
    Jul 12, 2012 at 7:16 pm
  • Although I'm attending the East Coast Oracle User Group conference this Fall in Raleigh, NC, there are other Oracle confs I'm unable to attend. OOW is out because I'll be on holiday in Oahu. Don't ...
    Dana NibbyDana Nibby
    Jul 11, 2012 at 10:52 am
    Jul 11, 2012 at 11:17 pm
  • Not sure how to "reply" to an archived thread on the freelists site, but i did find an answer to Rich Jesse's question from last month. From metalink, there's a bug, but hasn't been fixed/tested ...
    Lyall BarbourLyall Barbour
    Jul 3, 2012 at 4:33 pm
    Jul 11, 2012 at 5:25 pm
  • I have a range partitioned table where each partition has a vastly different size. We recently ran a purge (over several months) to remove alot of old data. So it makes sense to explore rebuilding ...
    Dba DBADba DBA
    Jul 10, 2012 at 3:50 pm
    Jul 10, 2012 at 7:13 pm
  • Hi friends, I need to prepare a basic Sql training for people here. In the team that will participate, there are persons with some experience and others not too much. Does anyone has some material ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Jul 6, 2012 at 1:31 pm
    Jul 8, 2012 at 8:59 am
  • Correction: I was wondering if anyone here is kind enough to share their automated RMAN *refresh* scripts with me? Thanks, Karthik -----Original Message----- From: <span class="m_body_email_addr" ...
    Ramadoss, KarthikRamadoss, Karthik
    Jul 25, 2012 at 3:34 pm
    Jul 25, 2012 at 11:10 pm
  • Hi, Does anyone know how to export a user DDL and its roles/privileges using data pump(11.2)? Thanks, Chen -- http://www.freelists.org/webpage/oracle-l
    Chen ZhouChen Zhou
    Jul 24, 2012 at 9:51 pm
    Jul 25, 2012 at 9:40 pm
  • I'm planning to buy the Gopalakrishnan RAC Handbook and I would really prefer the kindle edition (not enough shelves, pockets too small etc), but as the kindle is generally rubbish at tables and ...
    Jim SmithJim Smith
    Jul 15, 2012 at 8:01 am
    Jul 17, 2012 at 9:03 am
  • I've got a RedHat 5.6, Oracle RAC cluster. I am using Golden Gate 11.2. I have two extracts that each handle six schemas. With those two pumps that send to a second RAC (same versions) ...
    Walker, Jed SWalker, Jed S
    Jul 12, 2012 at 8:47 pm
    Jul 12, 2012 at 9:55 pm
  • Hi all I wonder if anyone knows if Oracle VM HA Server Pool can be setup using NFS instead of OCFS2? Thanks -- LSC -- http://www.freelists.org/webpage/oracle-l
    Ls ChengLs Cheng
    Jul 4, 2012 at 6:32 pm
    Jul 10, 2012 at 7:03 am
  • 10gR2 64 bit EE on Linux. DB was the Primary for a Data Guard Physical Standby, but not now. I've searched MOS and Googled a lot, but can't find any info. on this. Before I file an SR I ...
    Jul 31, 2012 at 2:57 pm
    Jul 31, 2012 at 6:40 pm
  • Hi all, It was installed 2 Oracle Rac on HP-UX - environment Prod and PreProd. The infra-structure team asked us about some differences on ASM, because they will use a tool from HP called ...
    Alex CwbAlex Cwb
    Jul 23, 2012 at 6:44 pm
    Jul 28, 2012 at 3:25 pm
Group Navigation
period‹ prev | Jul 2012 | next ›
Group Overview
grouporacle-l @

134 users for July 2012

Niall Litchfield: 19 posts Rich Jesse: 18 posts Kellyn Potvin: 16 posts Taylor, Chris David: 16 posts Peter Sharman: 15 posts David Fitzjarrell: 13 posts Tim Hall: 13 posts Rjamya: 11 posts Mark W. Farnham: 10 posts Norman Dunbar: 9 posts Guillermo Alan Bort: 8 posts Herring Dave - dherri: 8 posts Jonathan Lewis: 8 posts Ls Cheng: 8 posts Jared Still: 7 posts Michael Schmitt: 7 posts Thomas Kellerer: 7 posts Alex Fatkulin: 6 posts Peter Hitchman: 6 posts Tim Gorman: 6 posts
show more