Search Discussions

165 discussions - 897 posts

  • Hi all, I have a query which has a good plan on one node (node 3) and a bad plan (node 1) caused by a Merge Join Cartesian on another. Bind variable peeking is disabled and dynamic sampling is ...
    Fairlie regoFairlie rego
    Jun 7, 2007 at 2:13 am
    Jul 6, 2007 at 7:44 pm
  • Hi all, When we shutdown Oracle instance with shutdown immediate mode. The Oracle will wait until all rollback completed. The challenge is, how we can login to the instance to check the progress of ...
    Sinardy XingSinardy Xing
    Jun 27, 2007 at 2:43 am
    Jun 29, 2007 at 11:31 am
  • Hi, We are looking at using Oracle's SQL Developer as a development tool. Does anyone have any experience with this product? If so, please pass on your findings. We are particularly concerned about ...
    Dennis CutshallDennis Cutshall
    Jun 12, 2007 at 3:51 pm
    Jun 14, 2007 at 4:10 pm
  • We upgraded to 10.2 a month ago and everything was running fine until 2 days ago when a query started running very slow in prod. It is selecting data from a view using distinct and does an 'order ...
    Joe Armstrong-ChampJoe Armstrong-Champ
    Jun 29, 2007 at 4:56 pm
    Jul 3, 2007 at 4:14 pm
  • I have some users who want the dynamic ability of TOAD for development. In particular they want to be able to see any objects under any other schema. They say that they need to be granted SYSDBA. Is ...
    Jun 13, 2007 at 10:53 pm
    Jun 29, 2007 at 7:38 pm
  • Hi, A database was copied from another one and the controlfile to create it missed out couple of datafiles. The database now has missing datafiles listed in it. Also, the fact that some datafiles are ...
    Kanwar PlahaKanwar Plaha
    Jun 28, 2007 at 9:36 pm
    Jul 4, 2007 at 9:15 pm
  • Linux RHEL4, Oracle I have a developer who wants to define a column as CHAR(1) in an existing table. The only values this will ever hold are zero and one. I asked why he didn't define it as ...
    Sandra BeckerSandra Becker
    Jun 5, 2007 at 6:08 pm
    Jun 7, 2007 at 2:24 pm
  • Hello everyone, Select Query has got many outer joins and it runs very good in 9i ( and the same query crawls after upgrade to Index are same in both the cases and statistics are ...
    Jun 13, 2007 at 5:31 pm
    Jun 16, 2007 at 3:53 am
  • How are people handling the presence of database passwords in scripts on client machines? I'm talking about Perl, Java, .NET, SQL*Plus and other programs running on Solaris, Linux, and Windows ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jun 20, 2007 at 3:53 pm
    Jun 26, 2007 at 3:54 pm
  • Does anyone know what the wait event named "enq: UL - contention" means? There is nothing in Metalink or anywhere that I can find that gives the definition. I have a session that waits more than 90% ...
    Dean RichardsDean Richards
    Jun 11, 2007 at 4:31 pm
    Jun 13, 2007 at 1:01 pm
  • How do I tell what Edition (Standard,Enterprise) I've got installed ( on Win2K) Just had a disk array disembowel itself on an old box running 8.1.7 on Win2k. Managed to recover it to another ...
    Neil OverendNeil Overend
    Jun 28, 2007 at 9:19 am
    Jun 28, 2007 at 7:45 pm
  • Hello. I have found that, the following sql is very helpful in finding out the historical (What is in AWR) plan of a given SQL_ID. select * from table (sys.dbms_xplan.display_awr('&Your_SQL_ID')) ...
    Shivaswamy RaghunathShivaswamy Raghunath
    Jun 11, 2007 at 1:05 pm
    Jun 18, 2007 at 6:41 am
  • Hey all, I've installed OEM GC on OEL 4, after giving up trying to follow Oracle's instructions for moving 10gR2- R3 on Windows. Things are mostly working, but I've seen a few important ...
    Rich JesseRich Jesse
    Jun 29, 2007 at 3:03 pm
    Jun 30, 2007 at 1:19 am
  • After upgrading our production database from to yesterday we are having severe performance problems when trying to query any dba_* view or v$* view. I checked and stats were gathered ...
    Jun 25, 2007 at 4:46 pm
    Jun 27, 2007 at 12:38 pm
  • We are considering using EMC Symclone to copy data from production to development databases. Does anyone have any experience with this product used in this way? Any 'gotchas' or words of wisdom? Pete ...
    Peter BarnettPeter Barnett
    Jun 15, 2007 at 5:45 pm
    Jun 19, 2007 at 7:50 pm
  • I was asked to look at performance on someone else's system, running Oracle under HPUX. Its actually a 2 node RAC cluster, but I don't think thats all that important here. This is an older ...
    Peter SylvesterPeter Sylvester
    Jun 13, 2007 at 11:38 pm
    Jun 19, 2007 at 2:53 pm
  • Dear All It's Monday morning after a hard weekend's 9i- 10g/Windows- Linux migration and my brain is in a "London fog" so please excuse me if this is a RTFM question (which I have done and googled to ...
    Tim OnionsTim Onions
    Jun 18, 2007 at 9:52 am
    Jun 18, 2007 at 8:48 pm
  • Is there any way of knowing howmany transactions happened in a day? Some damagement report needs this. Any help is appreciated. Thanks Deen -- http://www.freelists.org/webpage/oracle-l
    Dd yakkaliDd yakkali
    Jun 1, 2007 at 6:17 pm
    Jun 1, 2007 at 9:46 pm
  • Is there a way to force SMON to dump the most current table statistics to all_tab_modifications? -- http://www.freelists.org/webpage/oracle-l
    Ethan PostEthan Post
    Jun 6, 2007 at 4:39 pm
    Jun 6, 2007 at 8:26 pm
  • What is the impact of running an rman hot backup followed by a "restore validate" on application performance? Is there any possibility of applications or transactions being blocked during the backup ...
    Schauss, PeterSchauss, Peter
    Jun 26, 2007 at 5:29 pm
    Jun 28, 2007 at 1:31 am
  • Has anyone come up with a set of queries that will determine if an application will run in standard edition. One query may be to determine if there really ARE any partitions or something like that ...
    Michael KlineMichael Kline
    Jun 16, 2007 at 12:04 am
    Jun 19, 2007 at 6:17 pm
  • I just got off the phone with a woman from a company called IT Convergence. She called me to say that she had heard I was looking for help with a RAC migration project. At first I couldn't imagine ...
    Baumgartel, PaulBaumgartel, Paul
    Jun 13, 2007 at 9:43 pm
    Jun 14, 2007 at 6:45 pm
  • Hi List, I am using RMAN to duplicate our live DB to another identical machine. Full On-line backups are taken 5 days a week (file is 25Gb on disk), each one includes *all* archive logs. I have been ...
    David cheyneDavid cheyne
    Jun 19, 2007 at 10:10 am
    Jun 21, 2007 at 7:22 am
  • Hi, List, I am testing a disaster recovery senario. RMAN backup was done with no catalog. Below are what I did: startup nomount restore spfile from xxx shutdown startup (this time it picks up the ...
    Li LiLi Li
    Jun 13, 2007 at 7:11 pm
    Jun 15, 2007 at 6:11 pm
  • Got this info from our NetBackup person. I'm not sure how much is true or not. Looking for tips and suggestions. The database is 10G on some large IBM AIX servers. I think P595, but not positive ...
    Michael KlineMichael Kline
    Jun 15, 2007 at 11:45 pm
    Jun 20, 2007 at 5:57 am
  • Hi Folks, I'm migrating from Sybase to Oracle, on Sybase I had a function with and update: update XYZ set flag = flag &~4589 Now on Sybase "~" character is used as negative character, so the query do ...
    Guerrero, Citlali (GE, Corporate, consultant)Guerrero, Citlali (GE, Corporate, consultant)
    Jun 15, 2007 at 4:39 pm
    Jun 18, 2007 at 7:40 pm
  • all, recently i have a dev machine 10g on itanium ia-64 another linux is itanium ia-64 with 9i the performance on 10g ( is dropped for almost 1/3 from the 9i, if someone has the same ...
    Ujang JaenudinUjang Jaenudin
    Jun 12, 2007 at 5:13 am
    Jun 12, 2007 at 5:48 pm
  • I did an export from Oracle with the imp utility on the Oracle 9 server. Then I tried to import the dump files into with the imp utility Oracle 10 server. The import worked for ...
    Jun 27, 2007 at 7:07 pm
    Jun 29, 2007 at 12:05 pm
  • DBA fellas, I have seen better query performance after converting two indexes to bitmap, for few warehouse queries. I have got around 50 other indexes, like SELECT ...
    Raj MareddiRaj Mareddi
    Jun 24, 2007 at 6:18 pm
    Jun 27, 2007 at 4:29 pm
  • Hi, Accidently, a developer ran a procedure to delete all objects exists in SYS schema. His intention was to do the same to an application user, but, he run it on sys schema. In this situation, ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Jun 26, 2007 at 4:44 am
    Jun 27, 2007 at 5:28 am
  • I have been assigned to do best option to migrating 9i/HP-UX DB to 10g/Solaris, any body can forward me the step by step instructions to accomplish this, in both cases if the DB size is small/big. -- ...
    Arif GulzarArif Gulzar
    Jun 25, 2007 at 7:35 pm
    Jun 26, 2007 at 1:46 pm
  • Dear all, create table t as select rpad(rownum, 100) x from dual connect by level <= 100000; update t set x=x; in another session: set autotrace on select count(x) from t; Statistics ... 157612 redo ...
    Alberto Dell'EraAlberto Dell'Era
    Jun 21, 2007 at 12:28 pm
    Jun 22, 2007 at 12:17 pm
  • Hello: We are trying to start listener on Linux redhad AS 4.0 it was working ok it was rebooted and then the listener didn't start the message error is the following System parameter file is ...
    Alfonso LeónAlfonso León
    Jun 15, 2007 at 10:59 pm
    Jun 18, 2007 at 8:05 pm
  • Greetings, I would be interested in folks thoughts about how frequently system statistics should be gathered and on what criteria should be used to make this determination. My thoughts are that this ...
    William WagmanWilliam Wagman
    Jun 15, 2007 at 6:23 pm
    Jun 18, 2007 at 3:05 pm
  • What is the easiest way to find out what tables are being used in a database? I am using dba_tab_modifications but this only tracks inserts, updates, or deletes. I am trying to document a ...
    Jordan CaseyJordan Casey
    Jun 14, 2007 at 2:06 pm
    Jun 15, 2007 at 5:13 pm
  • Hi, I am a new member of oracle-l and I am finding it very helpful. We are trying to make our Application debug easier. Currently we write debug messages to a file using utl_file package during the ...
    Jun 12, 2007 at 12:42 pm
    Jun 13, 2007 at 12:40 pm
  • Does oracle clusterware remotely power reset? If I recall correctly from what I have read from Kevin Closson's blog, it is not so. However, this presentation by an oracle insider claims that they ...
    Pedro EspinozaPedro Espinoza
    Jun 25, 2007 at 9:46 pm
    Aug 17, 2007 at 9:41 pm
  • Hi is there any place - where I can get all the posssible recovery scienarios and can practice them in my database. please let me know. Thanks - Ajeet -- http://www.freelists.org/webpage/oracle-l
    Ajeet OjhaAjeet Ojha
    Jun 18, 2007 at 9:06 am
    Jul 5, 2007 at 3:21 pm
  • Hi, From 9i and on shared pool is broken down into subpools. I need query to find out free/used memory by subpool. -- Regards, Ranko Mosic Consultant Senior Oracle DBA B. Eng, Oracle 10g, 9i ...
    Ranko MosicRanko Mosic
    Jun 30, 2007 at 6:10 pm
    Jun 30, 2007 at 11:32 pm
  • Hi If I am installing Oracle 10g Enterprise edition and uncheck the Oracle Partitioning option [ Means nO Partitioning], does that mean that AWR will not work or will not utilize partitioning. I ...
    Sanjay MishraSanjay Mishra
    Jun 27, 2007 at 3:38 pm
    Jun 27, 2007 at 5:50 pm
  • Oracle 10gR2. Is there a way to disable the table monitoring, without setting statistics_level to BASIC and losing the advisories? Looks like this cannot be done from what I have read so far. Regards ...
    Jun 21, 2007 at 5:02 pm
    Jun 22, 2007 at 4:39 am
  • all, does anyone have the URL for installing OAS 10g with clustering and OID inside?. I have 4 machines for application server and OID. thanks for your sharing..... -- regards ujang -- ...
    Ujang JaenudinUjang Jaenudin
    Jun 19, 2007 at 6:48 am
    Jun 21, 2007 at 2:21 pm
  • Hey all, Please forgive my ASM ignorance if it shows but I have a couple of questions. We are considering using BCV Copy with an ASM environment (the database is RAC'd if that matters). Once we make ...
    Best, DavidBest, David
    Jun 13, 2007 at 4:06 pm
    Jun 14, 2007 at 2:00 pm
  • Is it possible to recover information from an undo datafile? I have been searching for information on securing oracle datafiles and see that there are .dbf file viewers that claim to be able to ...
    Freeman, DonaldFreeman, Donald
    Jun 8, 2007 at 5:25 pm
    Jun 11, 2007 at 7:33 pm
  • I may have mentioned this before, but the archives only showed me a tangential reference [1]. The setup: * Oracle on RHEL 3. Table FOO is range partitioned by date, total of 4 monthly ...
    Don SeilerDon Seiler
    Jun 19, 2007 at 5:07 pm
    Aug 20, 2007 at 2:53 pm
  • all, i got problem with this ora on ASM on solaris 9 ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk "1" is missing asking to support, but ...
    Ujang JaenudinUjang Jaenudin
    Jun 6, 2007 at 7:37 am
    Jul 4, 2007 at 6:19 pm
  • Now that I have upgraded our production systems from to I can see via truss that Oracle is taking advantage of our newly implemented JFS2 filesystems and opening the datafiles using ...
    Jun 27, 2007 at 12:47 pm
    Jun 27, 2007 at 7:09 pm
  • All: Is SQLLDR faster or UTL_FILE utility faster? For loads of 130 million rows with about 200 columns, which tool is better? We are on 8.1.7 on Sun server. Thanks for your input. -- Sincerely Ram ...
    Ram SrinivasanRam Srinivasan
    Jun 14, 2007 at 9:54 pm
    Jun 18, 2007 at 5:02 pm
  • Hi, How can I restrict the no. of sessions connected based on osuser? Means I want to restrict the OS user connecting more than 3 concurrent sessions (3 sessions per OS users). Thanks & Regards Kris ...
    Jun 12, 2007 at 1:20 pm
    Jun 12, 2007 at 6:19 pm
  • While trying to applying the latest patch to 9i, we are receiving this error. Any ideas on what may be causing this? Thankd Brian -- http://www.freelists.org/webpage/oracle-l
    Brian LockBrian Lock
    Jun 8, 2007 at 6:36 pm
    Jun 8, 2007 at 7:43 pm
Group Navigation
period‹ prev | Jun 2007 | next ›
Group Overview
grouporacle-l @

233 users for June 2007

Jared Still: 41 posts Niall Litchfield: 21 posts Randy Johnson: 20 posts Alexander Fatkulin: 18 posts Joel.Patterson_at_crowley.com: 18 posts Kerber, Andrew W.: 18 posts Robert Freeman: 18 posts Syed Jaffar Hussain: 17 posts Allen, Brandon: 16 posts Rjamya: 16 posts Alex Gorbachev: 14 posts Elliott, Patrick: 13 posts LS Cheng: 13 posts Bobak, Mark: 12 posts Christian Antognini: 12 posts Jeremy Paul Schneider: 12 posts Ujang Jaenudin: 11 posts Alberto Dell'Era: 9 posts Don Seiler: 9 posts Gints Plivna: 9 posts
show more