Search Discussions

103 discussions - 551 posts

  • We have a query that began taking a long time about a week ago. The program, in SAP, ran for 10 - 15 minutes but is now taking about 6 hours. The table has 5.1 million rows. The explain plan shows a ...
    Blanchard WilliamBlanchard William
    Dec 11, 2008 at 11:17 pm
    Dec 13, 2008 at 3:34 pm
  • Friends, I was looking for a tool that would convert my oracle storage/performance metrics into a neat graphical report. And I stumbled upon tools like RRDTOOL/ORCA/GNUPLOT ... I would like to hear ...
    Prem Khanna JPrem Khanna J
    Dec 1, 2008 at 8:36 am
    Dec 2, 2008 at 5:29 pm
  • Hello All, Good Morning!! Hope every one is doing great this Morning. As I am a new DBA, a simple question strikes me this morning. What is the main purpose of cloning a database. Is the main purpose ...
    Nilesh kumarNilesh kumar
    Dec 17, 2008 at 2:33 pm
    Dec 29, 2008 at 11:44 pm
  • Hi buddies, I always use EM grid control to clone oracle_home for an oracle binary installation. But everything has an exception, right? I have to install an oracle binary in some sever without ...
    Bao jiejieBao jiejie
    Dec 5, 2008 at 2:48 am
    Dec 10, 2008 at 10:16 pm
  • Is the lazydba.com site gone? I have been unable to access it for a while and my last email from their list was on 12/2/2008. Thanx, <- <- <- <- <- <- <- <- <- <- <- <- <- <- <- <- <- <- <- -Mark ...
    McNary, MarkMcNary, Mark
    Dec 15, 2008 at 2:37 pm
    Dec 17, 2008 at 4:29 pm
  • Hi experts, Today, my colleague ask me what is the difference between v$sql and v$sqlarea, which made me blue... I get some hints from *http://www.adp-gmbh.ch/* <http://www.adp-gmbh.ch/ it says that ...
    Bao jiejieBao jiejie
    Dec 19, 2008 at 2:56 am
    Dec 30, 2008 at 4:53 am
  • Hi folks, I have found the following users in dba_users view: WEBSYS WWW_USER WEBUTIL What are they good for? Can they be deactivated? Regards, Jan -- http://www.freelists.org/webpage/oracle-l
    Dec 9, 2008 at 2:05 pm
    Dec 12, 2008 at 12:40 am
  • Say you have a client that for political reasons only bought 1 single server with 6 internal disks (the first 2 of which are RAID-1'd for the OS). Because you cannot apply any reasonable sense that ...
    Dec 8, 2008 at 9:51 pm
    Dec 9, 2008 at 4:23 pm
  • This init parameter really peeves me. I've been using it for years, and I have read the documentation repeatedly, yet I still have issues with it conceptually. Why have, what appears to be, a ...
    Michael FontanaMichael Fontana
    Dec 19, 2008 at 3:59 pm
    Dec 30, 2008 at 8:42 pm
  • Apart from re-writing pl/sql to java, what are the alternatives to utl_file that I can use in PL/SQL to read and write files? Oracle version is 10.2 John Dunn Product Consultant Sefas Innovation ...
    John DunnJohn Dunn
    Dec 16, 2008 at 12:25 pm
    Dec 17, 2008 at 4:09 pm
  • Hi Gurus, I have an requirement from applicaition team to "Turn audit on for a an user in an Database, in order to monitor who logins (both failed and successful logins) to this account and when the ...
    Nagaraj SNagaraj S
    Dec 5, 2008 at 5:27 pm
    Dec 7, 2008 at 4:00 am
  • Hi I am planning to use ASM for singel instance databases and the server has multiple DB's Article here mentions to start the CSS instance from Oracle home ...
    Dec 1, 2008 at 11:08 am
    Dec 1, 2008 at 12:01 pm
  • It shouldn't be a problem to connect from 8i to 10g as long as you don't try to use any 10g SQL*Plus features (e.g. purge recyclebin). Shouldn't be a problem to install multiple clients on the same ...
    Allen, BrandonAllen, Brandon
    Dec 29, 2008 at 5:55 pm
    Dec 29, 2008 at 8:15 pm
  • Seeing something a bit odd. I have a series of jobs which use DBMS_JOB, just migrated to 10G. The jobs kick off and attempt to run every 10 minutes until they are table to complete. There are some ...
    Ethan PostEthan Post
    Dec 22, 2008 at 7:06 pm
    Dec 24, 2008 at 8:50 am
  • Anyone know a way to drop a histogram on single column? Thanks Kyle http://perfvision.com -- http://www.freelists.org/webpage/oracle-l
    kyle Haileykyle Hailey
    Dec 15, 2008 at 4:44 pm
    Dec 16, 2008 at 9:41 am
  • List, Oracle, Solaris 8 I've found a simple insert that has: 1 execution 2,512,102 Buffer Gets 36,479 Physical Reads 1 Parse call 1 Row This insert statement appears quite a few times in the ...
    Dennis WilliamsDennis Williams
    Dec 12, 2008 at 8:55 pm
    Dec 15, 2008 at 10:35 am
  • Hello fellowship of the Oracle, due to not so recent changes in European and German law, many companies, particularly in the financial sector, have the need to archive critical data over a long ...
    Uwe KüchlerUwe Küchler
    Dec 9, 2008 at 9:25 pm
    Dec 10, 2008 at 5:16 pm
  • 2-node RAC, Redhat 5 I have a service accidentally configured with both instances as available and none as preferred: $ srvctl config service -d dbname -s servicename.example.com ...
    Yong HuangYong Huang
    Dec 16, 2008 at 3:45 pm
    Dec 16, 2008 at 8:24 pm
  • Hi all, I have one requirement, ie. to create a schema PSI_DUP same as PSI (existing). I did export the PSI schema first and later created PSI_DUP similar to PSI. Overall schema size is showing as ...
    Dec 12, 2008 at 6:53 pm
    Dec 13, 2008 at 4:28 pm
  • I have run into a problem with the patchset going from to on Red Hat 32bit x86 Linux. The two databases I upgraded worked fine. I can't upgrade my recovery catalog without ...
    Joe SmithJoe Smith
    Dec 8, 2008 at 2:37 pm
    Dec 11, 2008 at 2:48 am
  • Greetings, I'm running EE on RHEL4 64-bit. Setting whenever oserror exit generates the following behavior... [oracle_at_critpinndev pinntest ~]$ sqlplus / SQL*Plus: Release - ...
    William WagmanWilliam Wagman
    Dec 9, 2008 at 9:12 pm
    Dec 10, 2008 at 10:58 pm
  • All, we have a requirement to keep 1 year worth of audit records. I am kicking around the idea of hourly moving all of the sys.aud$ records from each production database to a central database. That ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    Dec 8, 2008 at 12:32 pm
    Dec 10, 2008 at 5:08 pm
  • I was wondering if it was possible for SQL similar to the following to cause a lock to be created on the remote database: insert into localtable (select columns from remotetable_at_dblink where ); My ...
    Jason HeinrichJason Heinrich
    Dec 9, 2008 at 8:47 pm
    Dec 9, 2008 at 10:24 pm
  • Hi all, I am having problems with getting Oracle Enterprise Grid Control up and running. It was working fine since October till December 5th. On Friday, one of the mount points ran out of space ...
    Maria GurenichMaria Gurenich
    Dec 9, 2008 at 5:33 pm
    Dec 9, 2008 at 10:06 pm
  • I am having trouble getting my scripts to login and run against a 10g database on solaris 8. I can login from the cmd prompt as sysdba all day long. this is the only entry in /etc/passwd that refers ...
    Joe SmithJoe Smith
    Dec 9, 2008 at 5:15 pm
    Dec 9, 2008 at 6:13 pm
  • Hi guys, i've a question for you. one of my RAC ( on AIX makes some trouble. to investigate the problem i ran some system state dumps. the problematic session is this: OSD pid info: Unix ...
    Andreas PieskAndreas Piesk
    Dec 8, 2008 at 8:46 pm
    Dec 8, 2008 at 11:41 pm
  • All, I am running a Data Guard with a Logical Standby on Aix V This is our first run at this so we are still learning. During my first large data load in the primary database, I ran out of ...
    Mercadante, Thomas F (LABOR)Mercadante, Thomas F (LABOR)
    Dec 5, 2008 at 1:36 pm
    Dec 5, 2008 at 5:23 pm
  • Hello I'm pleased to inform you all that I have been awarded with an Oracle ACE this year. I'm really honor to receive this award. Take a look at my Oracle ACE Profile � *Sabdar ...
    Syed Sabdar HussainSyed Sabdar Hussain
    Dec 18, 2008 at 8:46 pm
    Dec 21, 2008 at 7:54 pm
  • I am trying to use perl DBI to connect oracle databases using the secure external password store introduced in oracle 10gR2. It works great when I use sqlplus connect after setting up the wallet and ...
    Wang, TaoWang, Tao
    Dec 12, 2008 at 10:34 pm
    Dec 15, 2008 at 2:34 pm
  • Hi, List, I am running into an error when trying to clone a database with RMAN. The error message is the following. Error seems to be a permission issue but actually it shouldn't because RMAN ...
    Li LiLi Li
    Dec 12, 2008 at 4:26 pm
    Dec 12, 2008 at 9:27 pm
  • Hello I have a database with some strange temporary segments under SYS schema seen from dba_segments as follows: OWNER SEGMENT_TYPE SEGMENT_NAME TABLESPACE_NAME ------------------------------ ...
    LS ChengLS Cheng
    Dec 5, 2008 at 11:22 am
    Dec 7, 2008 at 4:25 pm
  • This is probably a flippin' Windows question, but it's got me stumped at the moment. My manager had been having a recently departed member of our team log CPU utilization details daily into a ...
    David BarbourDavid Barbour
    Dec 4, 2008 at 5:27 pm
    Dec 4, 2008 at 10:31 pm
  • We hace DELL server with Redhat 5.2 X86 installed on it. I tried to created database on ORACLE and have message ORA-00942 in alert.log file. Database look good without problem. This messages ...
    Dba1 mccDba1 mcc
    Dec 19, 2008 at 2:56 pm
    Dec 23, 2008 at 1:54 pm
  • Hi all, I have a query that needs to be ordered by based on the second letter of the code passed in it. For instance if the code is '9F9Q' then I'd order by 'F', then by 'H', then by any other. If ...
    Eugene PipkoEugene Pipko
    Dec 19, 2008 at 4:57 pm
    Dec 19, 2008 at 8:52 pm
  • One of our developers accidentally truncated a production table. That table is infrequently updated/inserted into. I quickly found out that flashback table does not work across truncate commands ...
    Stephens, ChrisStephens, Chris
    Dec 18, 2008 at 3:19 pm
    Dec 19, 2008 at 1:20 am
  • Database Version 11G Anyone know of a parameter to set maximum activity logging to a trace level at instance level- We are trying to diagnose a lockup on a Redhat box. -- Howard A. Latham -- ...
    Howard LathamHoward Latham
    Dec 11, 2008 at 2:09 pm
    Dec 12, 2008 at 4:04 pm
  • Hi I have a 2TB database running in Linux x64 2 nodes RAC. I have to refresh test environment with production regularly. Since this database contains 1.5TB LOB data in their own tablespaces ...
    Dec 11, 2008 at 9:05 pm
    Dec 12, 2008 at 11:50 am
  • Does anyone know how to view the contents of an LCR that is currently sitting in a Streams buffered capture queue? DBMS_APPLY_ADM.GET_ERROR_MESSAGE is helpful for displaying the contents of an LCR if ...
    Stuart BlackburnStuart Blackburn
    Dec 8, 2008 at 8:05 pm
    Dec 8, 2008 at 9:54 pm
  • Never is a very long time. It also seems to be at odds with the size of the name column in dba_objects. Though the max length of any name in the db is 30 character, the potential for more appears in ...
    Jared StillJared Still
    Dec 4, 2008 at 7:28 pm
    Dec 4, 2008 at 9:57 pm
  • Hi, listers Oracle EE 64bit, Linux We have some update statement (part of PL/SQL procedure) that may run for less than a minute if executed from SQL*Plus prompt or may take ~30 minutes if ...
    Vladimir BaracVladimir Barac
    Dec 28, 2008 at 7:30 pm
    Dec 29, 2008 at 4:11 pm
  • At least for 10g (view library). Is this just me? This is what I get with Firefox, IE just sits there and does nothing (Opening page http://www.oracle.com/pls/db102/homepage...). Bad Request Your ...
    S. Anthony SequeiraS. Anthony Sequeira
    Dec 29, 2008 at 8:49 am
    Dec 29, 2008 at 11:49 am
  • Hi, About statistics for temporary table : Is it best to have no statistics or Are they needed? Are they OK? Is there a problem if they have statistics? Any side effects. I mean as such they do not ...
    A JoshiA Joshi
    Dec 28, 2008 at 5:02 pm
    Dec 28, 2008 at 5:52 pm
  • Folks, Having a small problem that's a real irritant. On one of our Linux platforms sqlplus does not recognize the backspace key. Instead it simply displays a ^H. Doesn't happen in the bash shell ...
    Goulet, RichardGoulet, Richard
    Dec 25, 2008 at 11:11 pm
    Dec 26, 2008 at 10:45 am
  • Just try to replace it on the fly ? Some platforms (can't remember off the top of my head if sunos is one of them) even allow relinking the binary while the instance is running. Your next connection ...
    Stefan KnechtStefan Knecht
    Dec 24, 2008 at 11:50 am
    Dec 25, 2008 at 8:01 am
  • I'm sure many on this list can sympathize but I was just given a view which is producing a 'table or view does not exist' error. This view is built on top of other views and tables when are then ...
    Stephens, ChrisStephens, Chris
    Dec 23, 2008 at 4:31 pm
    Dec 23, 2008 at 4:47 pm
  • Hi I am attaching the plan good and the bad plans. First one using NL and a index is a good plan and the one using has join and a full table join is bad regards Hrishy -- ...
    Dec 18, 2008 at 7:57 am
    Dec 23, 2008 at 3:53 am
  • It's not the system tablespace, is it? Else an alter database datafile xyz offline drop should do it. You could also re-create the controlfile and omit the missing datafile. If it's the system ...
    Wolfgang BreitlingWolfgang Breitling
    Dec 19, 2008 at 5:42 pm
    Dec 22, 2008 at 6:04 pm
  • I came across some code today that has the following: SELECT . . . WHERE . . . AND p.refreshTimeStamp = SOME (SELECT MAX(pa.refreshTimeStamp) FROM pymt pa WHERE compid = '12345666' Can anyone tell me ...
    Sandra BeckerSandra Becker
    Dec 18, 2008 at 5:12 pm
    Dec 18, 2008 at 5:59 pm
  • hi all, this is a rac two node db. we have increased the size of redo from 33 mb to 100mb as per recommendations of expert and after which we are facing the problmes of waits..it seems that ...
    Subodh DeshpandeSubodh Deshpande
    Dec 15, 2008 at 12:04 pm
    Dec 16, 2008 at 2:18 pm
  • Hi DBAs, Is RMAN capable of identifying a Tape reaching its end? Can RMAN be configured to wait for next tape to be loaded, when a tape on which backup is being written to reaches its end of tape? ...
    Arul kumarArul kumar
    Dec 8, 2008 at 6:23 am
    Dec 10, 2008 at 12:22 pm
Group Navigation
period‹ prev | Dec 2008 | next ›
Group Overview
grouporacle-l @

161 users for December 2008

Jared Still: 28 posts Michael Fontana: 16 posts Hrishy: 15 posts Allen, Brandon: 14 posts Niall Litchfield: 13 posts Goulet, Richard: 11 posts Mark W. Farnham: 11 posts Bobak, Mark: 10 posts Bort, Guillermo: 10 posts Martin Berger: 10 posts Yong Huang: 10 posts David Barbour: 9 posts Dennis Williams: 9 posts Greg Rahn: 9 posts SHEEHAN, JEREMY: 9 posts Stefan Knecht: 9 posts Subodh Deshpande: 9 posts Blanchard William: 8 posts Rich Jesse: 8 posts Maria Gurenich: 7 posts
show more