FAQ

Search Discussions

136 discussions - 640 posts

  • Hi all I have some problem with some dynamic sql generated by a package, it is causing ORA-4031 and I have to reboot the instance to get rid of the problem. The code does something like for i in ...
    AmonteAmonte
    Jun 30, 2009 at 6:42 am
    Jul 2, 2009 at 5:12 pm
  • Dear DBAs, We have recently migrated Oracle from 8.0.6 on HP-Unix to 10.2.0.4 on Red Hat Linux Earlier the same application worked fine with 7GB RAM on HP-UNIX on PA-RISC Upgraded system on IBM X ...
    Mudhalvan MoovarkkuMudhalvan Moovarkku
    Jun 23, 2009 at 5:41 am
    Jul 1, 2009 at 10:23 pm
  • Does anyone have any suggestions for decommissioning a large database? There is no requirement to save the data so all I can think of is 1) Shutdown 2) Erase Doesn't have a lot of pizazz - any other ...
    Douglas CowlesDouglas Cowles
    Jun 26, 2009 at 8:28 pm
    Jun 30, 2009 at 6:03 pm
  • Because of the current economy we are being encouraged to consider open source databases. One of the vendors has referenced a JTPCC benchmark which is an open source Java version of TPCC. Has anyone ...
    Peter BarnettPeter Barnett
    Jun 9, 2009 at 2:52 pm
    Jun 10, 2009 at 10:04 pm
  • Well, adding memory is an option. You should also look at your code. If you are not using bind variables, that can also cause the problem, and it is almost impossible to fix that problem just by ...
    Andrew KerberAndrew Kerber
    Jun 12, 2009 at 1:04 pm
    Jun 14, 2009 at 8:38 pm
  • Hi I would like to know any metalink note or Oracle documentation link which spells out that i can do exp full=y on 8i database and imp full=y into 10g database. I searched this but unable to locate ...
    HrishyHrishy
    Jun 25, 2009 at 9:52 am
    Jun 26, 2009 at 2:17 am
  • Hi List, I have question regarding dataguard, the primary database is xytht1, the standby is xytht2. the oracle is 11.1.0.7. Our client is using jdbc thin client to connect the primary database. the ...
    Joan HsiehJoan Hsieh
    Jun 8, 2009 at 11:34 pm
    Jun 10, 2009 at 7:46 pm
  • Hello folks I generated with TOAD an ER diagram. I am not happy with the result. Can you recommend me a freeware (or even better Open Source) tool for or generating ERM diagram from existing Oracle ...
    Sven AluoorSven Aluoor
    Jun 2, 2009 at 3:09 pm
    Jun 3, 2009 at 2:54 am
  • Hi Folks, We are planning to implement a Sun SPARC based 10g R2 cluster. I see from the oracle link http://www.oracle.com/technology/products/database/clustering/certify/tech_generic_unix_new.html ...
    Sriram KumarSriram Kumar
    Jun 30, 2009 at 9:18 am
    Jun 30, 2009 at 1:54 pm
  • (CC to list) Josh Does your query include ANY other predicates (other than WHERE columnX 'nondup value')? Do you get the right results if you use an index range scan (or full table scan)? What index ...
    Nigel ThomasNigel Thomas
    Jun 9, 2009 at 4:29 pm
    Jun 9, 2009 at 9:07 pm
  • What is the severity level of the SR? If it's a 3 or higher, that is why you are getting slow response. Robert G. Freeman Oracle ACE Author: Oracle Database 11g RMAN Backup and Recovery (Oracle ...
    Robert FreemanRobert Freeman
    Jun 30, 2009 at 4:08 pm
    Jun 30, 2009 at 6:57 pm
  • Hi For one of my databases i am unable to connect using sqlplus user/password but when i try sqlplus username/password_at_connect-string it connects The error message i get using sqlplus ...
    HrishyHrishy
    Jun 29, 2009 at 9:09 am
    Jun 30, 2009 at 9:30 am
  • Hi Group, I am looking at options on forcing Oracle to use literals inside of a PL/SQL package. I have a bind variable peeking issue that is causing a cached execution plan that doesn't work well for ...
    Thomas RoachThomas Roach
    Jun 18, 2009 at 1:19 am
    Jun 19, 2009 at 7:41 am
  • Hi list, the following SQL leads to an execution plan which is absolutely wrong. SELECT pos_komnr FROM po WHERE pos_art = l_tmp_art1 AND pos_num = l_tmp_num1 AND pos_pos = l_tmp_pos; (it is from a ...
    Joerg JostJoerg Jost
    Jun 10, 2009 at 8:34 am
    Jun 10, 2009 at 5:42 pm
  • I want to correlate SQL to the packages and procedures they came from. Is there a way to do this before 10.2.0.4? Starting in 10.2.0.4 this is pretty easy thanks to the fields PLSQL_ENTRY_OBJECT_ID ...
    kyle Haileykyle Hailey
    Jun 1, 2009 at 9:58 pm
    Jun 4, 2009 at 8:26 am
  • List, To plug a security gap, I'm trying to create a trigger on a certain username. If the trigger condition is met, the trigger would force a logout. Is that possible? Thanks for any suggestions, ...
    Dennis WilliamsDennis Williams
    Jun 25, 2009 at 2:15 pm
    Jun 25, 2009 at 3:53 pm
  • This is an issue that has made sleepless over and over again. Critical application sql changes its xplans causing elapse time to go unacceptably worst. We eventually wanted to monitor this kind of ...
    FmhabashFmhabash
    Jun 18, 2009 at 9:51 pm
    Jun 25, 2009 at 8:09 am
  • Dear list, I've got a question about hierarchical queries, especially sys_connect_by_path(): sys_connect_by_path requires a seperator that does not exist in the returned values, otherwise it spawns ...
    Martin KlierMartin Klier
    Jun 8, 2009 at 10:04 am
    Jun 18, 2009 at 10:37 am
  • All, I'm having one heck of a brain dropout recently. I know that there is a way to take a full backup on say Sunday and then incrementals throughout the week and apply those to the original full ...
    Goulet, RichardGoulet, Richard
    Jun 4, 2009 at 1:22 pm
    Jun 4, 2009 at 7:15 pm
  • Still reading documentation. =) http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_DataGuardNetworkBestPractices.pdf ...
    Charles SchultzCharles Schultz
    Jun 26, 2009 at 3:42 pm
    Jul 6, 2009 at 7:23 pm
  • Sort of strange scenario. Oracle 10.2.0.2 64 bit SunOS 5.10 Added a new directory to utl_file. Let's call it /dir_a When a user (user1) connects locally (beq, not SQL*Net) to the db and writes a file ...
    Stephen AndertStephen Andert
    Jun 30, 2009 at 6:05 pm
    Jul 4, 2009 at 5:40 am
  • What kind of problem does the business see with force logging? What transactions do you have that they require nologging on that is critical to the business? That is, are you fighting a theoretical ...
    Mathias MagnussonMathias Magnusson
    Jun 16, 2009 at 6:59 pm
    Jun 17, 2009 at 11:48 am
  • Hi Chapter 7 of the data guard implementation guide describes about role transitions. There are two scenarios which are described here (a) failvoer (b) switchover. What if I really dont want to do ...
    Kumar MadduriKumar Madduri
    Jun 12, 2009 at 3:11 pm
    Jun 13, 2009 at 6:55 am
  • G'day All. A collegue of mine is attempting to install an Oracle 10g R2 database on Oracle Unbreakable Linux 5. He's running into problems even trying to run the installer, which croaks over a ...
    Tony van LingenTony van Lingen
    Jun 9, 2009 at 11:12 pm
    Jun 10, 2009 at 1:50 pm
  • On 9i and 10G you can find listener.log under $ORACLE_HOME/network/log. on 11G I knew sqlnet.log file is gone and information move to alert.log. How about listener.log file, I can not find it in ...
    Dba1 mccDba1 mcc
    Jun 9, 2009 at 3:12 pm
    Jun 9, 2009 at 6:26 pm
  • I have a user that when he drops a table it does not go into the recyclebin. I can see the segments this user created in user_segments and his table name in user_tables. All other users can do this ...
    Joe SmithJoe Smith
    Jun 3, 2009 at 1:43 am
    Jun 7, 2009 at 7:56 pm
  • You can have a single LUN and have separate partitions within that LUN for OCR/Voting, and leave the rest as ASM disks. hth Alan Bort Oracle Certified Professional -- ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 3, 2009 at 2:41 am
    Jun 4, 2009 at 4:22 am
  • Hi, oracle 10.2.0.4 i have deleted the statistics on a table EMP then i have gathered the stats with dbms_stats: EXEC DBMS_STATS.GATHER_TABLE_STATS(ownname= 'HR',tabname= 'EMP',estimate_percent= ...
    Mohammed Mehraj hussainMohammed Mehraj hussain
    Jun 3, 2009 at 9:37 am
    Jun 3, 2009 at 10:12 pm
  • What is the most efficient, quickest way to completely recreate the database to minimize downtime? The system architecture in question is 10.2.0.4 running on Sun SPARC 64-bit Solaris. This is a ...
    Michael WehrleMichael Wehrle
    Jun 30, 2009 at 7:37 pm
    Jun 30, 2009 at 9:09 pm
  • Hi listers, I have a HP-UX box with Oracle 10gR2 installed in it. I created a Database and enabled auto archive. The log files and control files are multiplexed and live in different disks. * sqlplus ...
    Amir GheibiAmir Gheibi
    Jun 19, 2009 at 6:26 am
    Jun 20, 2009 at 9:39 pm
  • Hi all, am trying to duplicate a real-life situation where a db had several sessions with status of active and wait event of sq*net message FROM client. So far, am not able to do that. I tried a ...
    FmhabashFmhabash
    Jun 17, 2009 at 8:17 pm
    Jun 19, 2009 at 11:33 am
  • After a newbie mistake I get a few errors from the data dictionary (dba_* views not working, synonyms brokent, etc). Obviously the data dictionary is broken. When I try to re-create it using ...
    Guillermo Alan BortGuillermo Alan Bort
    Jun 15, 2009 at 12:15 pm
    Jun 15, 2009 at 4:51 pm
  • My log writer is triggering an alert from OEM that it is blocking sessions. (SID ### is blocking -- which is LGWR). I have googled, and searched metalink, and come across log file sync's, and even ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Jun 11, 2009 at 7:40 pm
    Jun 12, 2009 at 2:31 pm
  • I'm trying to complete an incremental restore on one of my physical standby databases. I'm following ...
    Martin BrownMartin Brown
    Jun 11, 2009 at 2:53 pm
    Jun 12, 2009 at 4:53 am
  • I know (at least I think I do) that it is possible to access and modify data in OEM tables - I am thinking of perticularly the tables containing TAblespace sizes and alert levels I just can't find ...
    Howard LathamHoward Latham
    Jun 11, 2009 at 9:34 am
    Jun 11, 2009 at 2:42 pm
  • Hello list, I have a two node 10.1.0.5 RAC setup serv1 - instance 1 serv2 - instance 2 We are using parallel query for batch processing. The time to complete batch is ok when we run in a non ...
    GBA-DBAGBA-DBA
    Jun 10, 2009 at 4:10 pm
    Jun 11, 2009 at 1:45 am
  • Env: Server Oracle 10.2.0.4 Client - Windows, no oracle client, ODBC connection to server Problem: My client has a requirement to install *something* on a windows client that will used by a ...
    Tony AdolphTony Adolph
    Jun 1, 2009 at 12:06 am
    Jun 2, 2009 at 3:31 am
  • What do you mean by 'We are trying to prove expdp is having an issue with just the LOB data of a business table' any ora- errors. I've found that it doesn't matter if you use expdp or exp, exporting ...
    Michael McMullenMichael McMullen
    Jun 29, 2009 at 5:03 pm
    Jun 29, 2009 at 8:21 pm
  • Hi all, I am trying to import a 280G schema into a blank database with impdp. The process took 10 hours, with index creation taking the most time. It took 5.5 hrs: SYSADM_at_tst1 select min(created), ...
    Ram RamanRam Raman
    Jun 21, 2009 at 6:24 pm
    Jun 25, 2009 at 4:38 am
  • [Warning: High acronym content] So I have been reading the online documentation and giving myself a headache. =) Interesting how easy it is to get distracted and start reading about FCF, ONS, FAN and ...
    Charles SchultzCharles Schultz
    Jun 19, 2009 at 7:56 pm
    Jun 22, 2009 at 4:52 pm
  • Listers, What do you normally use as the location of ASM's spfile in a RAC database. I have to decide between spfiles local to each node vs a shared raw device. oracle 10g with ASM. OCR and VD in raw ...
    Ram RamanRam Raman
    Jun 18, 2009 at 5:39 am
    Jun 18, 2009 at 3:16 pm
  • Hi, Can anybody please share some good links or resource means white papers on Oracle RAC architecture and how internal works ? Regards, Amit DISCLAIMER: This message contains privileged and ...
    Amit.Chowrasia_at_iflexsolutions.comAmit.Chowrasia_at_iflexsolutions.com
    Jun 8, 2009 at 1:26 pm
    Jun 11, 2009 at 10:47 am
  • Hi All, Can you please educate me on below things. Also, please correct me if i am wrong 1. db_writer_processes controls number of db writers that are been started when instance is initialized. So, ...
    Taral DesaiTaral Desai
    Jun 2, 2009 at 9:50 pm
    Jun 10, 2009 at 3:51 pm
  • Version 10.2.0.4 on Solaris 5.10 What can be maximum file size of an export file? Are there any limitations. Thanks G. Nizar A. Baig -- http://www.freelists.org/webpage/oracle-l
    Nizar AhmedNizar Ahmed
    Jun 8, 2009 at 9:22 am
    Jun 8, 2009 at 10:26 am
  • Dear Harshan, What do you mean by that? From: oracle-l-bounce_at_freelists.org On Behalf Of harshan eppuram Sent: Sunday, June 07, 2009 9:05 AM To: moovarkku.mudhalvan_at_axa-direct.co.jp Cc ...
    Nizar AhmedNizar Ahmed
    Jun 7, 2009 at 6:44 am
    Jun 7, 2009 at 4:14 pm
  • Hi, I have some doubts regarding cursor sharing and bind value peeking. What i observed is multiple child cursors are created in case of cursor_sharing setting SIMILAR and FORCE. Here is test case ...
    Neeraj BhatiaNeeraj Bhatia
    Jun 30, 2009 at 10:04 am
    Jun 30, 2009 at 11:49 am
  • We are experimenting with RMAN. Now testing the "duplicate" command. I tried running the duplicate command and it is asking for a backup from April 20 instead of the current backup. I notice that a ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jun 26, 2009 at 12:40 pm
    Jun 29, 2009 at 5:44 am
  • After performing a clone of a database, do you do any extra steps to ensure that "all of the data is there"? We usually just ensure that the clone processed the most current production archive log ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jun 26, 2009 at 11:34 am
    Jun 26, 2009 at 1:48 pm
  • Hi, I am helping some one with appserver install using existing database 10.2.0.3 on Solaris 9. Oracle ultrasearch is required for appserver (I am not sure what part of appserver). Since database was ...
    Mayen.Shah_at_lazard.comMayen.Shah_at_lazard.com
    Jun 24, 2009 at 5:31 pm
    Jun 24, 2009 at 8:55 pm
  • Folks, One of our large client has a very large DB (~40TB) configured with ASM. They are currently using RMAN to back it up to tape and it takes a very long time to do that. They have also tried ...
    Hameed, AmirHameed, Amir
    Jun 22, 2009 at 2:50 am
    Jun 23, 2009 at 3:04 pm
Group Navigation
period‹ prev | Jun 2009 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions136
posts640
users193
websiteoracle.com

193 users for June 2009

Mathias Magnusson: 20 posts Goulet, Richard: 18 posts Allen, Brandon: 17 posts Hrishy: 17 posts Matthew Zito: 17 posts Bobak, Mark: 15 posts Niall Litchfield: 15 posts Jared Still: 14 posts LS Cheng: 14 posts Andrew Kerber: 11 posts Howard Latham: 10 posts Joel.Patterson_at_crowley.com: 10 posts Robert Freeman: 10 posts Guillermo Alan Bort: 8 posts Jurijs Velikanovs: 8 posts Martin Berger: 8 posts TESTAJ3_at_nationwide.com: 8 posts Tony Adolph: 8 posts : 7 posts Johnson, George: 7 posts
show more
Archives