Search Discussions

241 discussions - 1,129 posts

  • Hi, I've got an application query that is taking hours to run. After tracing and running tkprof, I see the execution plan below. Yes, it's a monster of a query, but Oracle seems to handle it pretty ...
    Allen, BrandonAllen, Brandon
    Jul 6, 2005 at 6:30 pm
    Jul 12, 2005 at 2:13 pm
  • We have finally moved into the modern digital world. Outages of our company web site are being noticed by our customers which is causing management to ask about maintaining 7x24x365 up time. There ...
    Peter BarnettPeter Barnett
    Jul 7, 2005 at 8:37 am
    Jul 8, 2005 at 12:28 pm
  • Hi, I was wondering why not Oracle, writes his own server operating system. The files are simply big bfiles, and if they need some library for something, they can use linux free libraries. The have ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jul 19, 2005 at 1:48 pm
    Jul 22, 2005 at 7:51 am
  • Hi, Excuse me for this OT stuff. Thought this will be pretty useful. Annoyed by frequently having to wait 10-20 seconds for adobe to load when all you want to do was view a single page ! Here's how ...
    Jul 12, 2005 at 1:24 am
    Jul 13, 2005 at 6:45 pm
  • HI I am looking for any tool that can be used to provide some graphical output for Oracle monitoring. Is there any URL where I can download and configure to monitor some of the Oracle / other ...
    Sanjay MishraSanjay Mishra
    Jul 15, 2005 at 9:58 am
    Jul 26, 2005 at 5:48 pm
  • With apologies to the list for going somewhat off-topic, and begging Steve's indulgence.... Today is my last day at work. My last official day as an Oracle DBA. I'll still be lurking on this list ...
    Rachel carmichaelRachel carmichael
    Jul 15, 2005 at 7:18 am
    Jul 19, 2005 at 6:45 am
  • Hi all, Why Oracle allow to have temporary tablespace without the temp file? The error is: ORA-25153: Temporary Tablespace is Empty SQL select tablespace_name from dba_tablespaces; TABLESPACE_NAME ...
    Jul 1, 2005 at 6:22 am
    Jul 12, 2005 at 2:07 pm
  • Hi All, Sun OS 2.9 oracle 9i In what state the datafiles should be when i want to change the OS file permissions from 600 to 640 chmod 640 *.dbf I put the tablespace offline. is that enough?, or ...
    Raja raoRaja rao
    Jul 5, 2005 at 4:26 pm
    Jul 6, 2005 at 12:17 pm
  • Hi All, I am in need of a consultant that is heavy on RedHat Linux real world experience for an emergency situation. Here is the situation: I have recently gone live with our production database on ...
    Magnus AndersenMagnus Andersen
    Jul 22, 2005 at 7:21 am
    Jul 28, 2005 at 6:05 am
  • Hi All, I have to upgrade an instance from to Existing ORACLE_HOME is /u01/oracle/product/9201/ Now i want a new oracle_home for 9206 binaries. say new ORACLE_HOME = ...
    Jul 14, 2005 at 5:46 am
    Jul 19, 2005 at 6:50 am
  • I am trying to send the output of a sqlplus script from Unix (using mailx) to Lotus Notes addresses. The output looks formatted on Unix, but when opened in Lotus Notes, the formatting is no longer ...
    Deepak SharmaDeepak Sharma
    Jul 28, 2005 at 11:21 pm
    Aug 1, 2005 at 7:47 am
  • Folks Need to migrate an Online (near 24x7) Hybrid application from 8.1.7 on Sun to 9.2 on AIX. Source Database is on Sun with Oracle 8.1.7 Target DB needs to go to AIX on Oracle 9.2 DB size - 1 TB ...
    Jul 25, 2005 at 12:23 pm
    Jul 27, 2005 at 10:31 am
  • Anyone know of some examples of analytical procedures/functions/programs that will help me see patterns in repeating sequences of values? This is for a application log table that may have dozens of ...
    Post, EthanPost, Ethan
    Jul 21, 2005 at 1:28 pm
    Jul 22, 2005 at 4:25 pm
  • I have a new Oracle 9.2 database that I am exporting. I keep getting the EXP-00091: Exporting questionable statistics. error. I ran catexp on the database, but that didn't;t help. Can someone tell my ...
    Smith, Ron L.Smith, Ron L.
    Jul 26, 2005 at 8:23 am
    Aug 2, 2005 at 1:00 pm
  • Hi, I am not very about this, I know that every database created it will save those system,indx,tablespace,temp file into oradata folder. I am wondering is that possible to just create a similar ...
    Kean JacintaKean Jacinta
    Jul 28, 2005 at 10:37 am
    Jul 30, 2005 at 12:31 am
  • Has anyone tried monitoring the run duration of jobs scheduled with dbms_jobs over time to determine trends? I'm thinking of running some pl/sql in intervals that will, in general, do the following ...
    Pakhutkin, Maxim (Max)Pakhutkin, Maxim (Max)
    Jul 28, 2005 at 9:33 am
    Jul 28, 2005 at 12:33 pm
  • win 2000 server - oracle 10.1 - archivelog mode Ive seen these object names before and research (goggle) suggested they were "recovered fragments" Ive just performed media recovery on a datafile and ...
    Jul 17, 2005 at 8:50 am
    Jul 19, 2005 at 8:49 am
  • We have a third-party application, which as part of installation process, uses it's own Unix account to create/startup Oracle database/instance. They also want to start a listener with this account ...
    Jul 13, 2005 at 12:26 am
    Jul 15, 2005 at 2:41 pm
  • Those of you who are waiting ... linux 10gR2<http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html is here. Fire up those rusted downloading programs .. ...
    Jul 6, 2005 at 2:23 pm
    Jul 7, 2005 at 9:12 am
  • Hi, I've received a two interesting questions from a collage of mine. 1) If two processes are writing to the same file, will they suffer from some conation on the file handler ? Do you think that ...
    Amihay GonenAmihay Gonen
    Jul 31, 2005 at 12:33 pm
    Aug 1, 2005 at 9:51 am
  • SGVsbG8gYWxsLAoKSSd2ZSBiZWVuIGFza2VkIHRvIHByb3ZpZGUgYSBzaG9ydCBkb2Mgb24gMTAw NDYgdHJhY2luZyBmb3IgREJBcyBhbmQKZGV2ZWxvcGVycy4gU28sIGF0IHRoZSByaXNrIG9mIGlt ...
    Jul 20, 2005 at 10:39 am
    Jul 22, 2005 at 2:24 am
  • Hi, I'm unable to get into either svrmgrl or sqlplus of one of database. I'm getting error ORA-12560 error.I restarted services and tried by setting ORACLE_SID but unable to get into. This happened ...
    Seema SinghSeema Singh
    Jul 11, 2005 at 1:07 pm
    Jul 12, 2005 at 11:16 am
  • Hi, We installed the oracle 10g on solaris 10 and getting following error: $ sqlplus Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your ...
    Harvinder SinghHarvinder Singh
    Jul 27, 2005 at 4:53 pm
    Jul 28, 2005 at 12:47 pm
  • Hi all, We are trying to install OPatch on Oracle Portal DB for the sake of exp-imp. As oracle says that this patch is required to install bug which is there for Oracle Portal DB. But its giving the ...
    Onkar N TiwaryOnkar N Tiwary
    Jul 21, 2005 at 3:59 am
    Jul 25, 2005 at 2:36 am
  • Solaris 9 Oracle Hi! I'm trying to grab a process id from the database and store it in a variable. This syntax works if I'm not using a v$ view. If I use a v$ view, it ignores what's after ...
    Barbara BakerBarbara Baker
    Jul 22, 2005 at 12:39 pm
    Jul 24, 2005 at 12:05 pm
  • Hello, I would like to know if there is such a thing as memory based table in Oracle. What I mean be memory based is table which doesn't require any disk IO for storing or retrieving data. I am ...
    Ondrej FlorianOndrej Florian
    Jul 18, 2005 at 11:34 pm
    Jul 19, 2005 at 5:07 pm
  • hi all, Is it possible to add a new column in the between of table. For ex. Say there is a table as col position col name 1 ID 2 Name 3 Address I have to add a col. after NAME col and before ADDRESS ...
    Onkar N TiwaryOnkar N Tiwary
    Jul 19, 2005 at 12:40 am
    Jul 19, 2005 at 6:45 am
  • This is a 9.2 database on HP 11i. There is some sql from a 3rd party app that is supporting one of our call centers. It is taking approximately 3 minutes to complete. They are not using bind ...
    Chris StephensChris Stephens
    Jul 14, 2005 at 11:25 pm
    Jul 15, 2005 at 10:28 am
  • We have ORACLE installed on REDHAT AS 3.4. While we doing import, there has core dump happen. I send core dump file and other informations to ORACLE support. ORACLE support engineer refuse to ...
    Dba1 mccDba1 mcc
    Jul 11, 2005 at 12:54 pm
    Jul 12, 2005 at 11:15 am
  • Hi all, it's on SQL desc dba_data_files ERROR: ORA-04043: object dba_data_files does not exist so one of my friend did a SQL alter view dba_data_files compile; though it erred out saying ...
    Jul 7, 2005 at 6:40 am
    Jul 12, 2005 at 1:20 am
  • Hi all, We are developing an application that uses Oracle database. We may be hosting this application for multiple clients (expecting 2-4 deployments). The application and the database will remain ...
    Sandeep DubeySandeep Dubey
    Jul 6, 2005 at 4:02 pm
    Jul 7, 2005 at 12:56 pm
  • What am I missing? On one server, if I put in the following it takes me to interactive export without problem: exp / On another server, if I put the same exact thing in (exp / ) I get the error ...
    J. DexJ. Dex
    Jul 3, 2005 at 3:59 pm
    Jul 5, 2005 at 1:51 pm
  • Evening all; We are starting to have issues with our analyze routines running too long on our databases. We are trying to come up with a plan that says "At X number of rows and Y cardinality, start ...
    Kevin LangeKevin Lange
    Jul 25, 2005 at 11:48 am
    Jul 25, 2005 at 8:08 pm
  • I am thinking about using multi-block sizes for my different tablespaces in my 10g database that will be used for data warehouse type applications. Has anyone used this in 9i and/or 10g? If so, is ...
    Arnold, SandraArnold, Sandra
    Jul 21, 2005 at 11:02 am
    Jul 25, 2005 at 8:39 am
  • Anyone else able to get 10gR2 installed on a non-supported Linux like Gentoo (for testing purposes only, obviously)? I haven't yet done a: strace -o /tmp/orainstall -f -ff ./runInstaller ...
    Jesse, RichJesse, Rich
    Jul 18, 2005 at 5:15 pm
    Jul 21, 2005 at 10:45 am
  • Solaris 9 Oracle Does anyone have instructions on using gdb to generate a systemstate dump? Metalink note 121779.1 outlines using dbx, but I can't find anything using gdb. Note 273324.1 using ...
    Barbara BakerBarbara Baker
    Jul 19, 2005 at 10:11 am
    Jul 21, 2005 at 7:23 am
  • Hi, we have 9i ( Standard Edition and as the alert.log states [:o)] Oracle Data Guard is not available in this edition. We plan to mount a second instance in standby and setup a custom ...
    Radoulov, DimitreRadoulov, Dimitre
    Jul 18, 2005 at 1:36 pm
    Jul 19, 2005 at 10:19 am
  • Hi all I have several redhat blade clusters running RAC on 2.4.9-e.43enterprise. All database storage is OCFS, with ext3 for backups, home dirs etc. The servers have 12GB of RAM, of which ...
    Teehan, MarkTeehan, Mark
    Jul 13, 2005 at 2:32 am
    Jul 13, 2005 at 12:37 pm
  • Does anybody know of a nice RMAN tutortial or example without the user of the Recovery Catalog? And yes, I have got and looked at the Oracle pdfs from OTN on this issue. thanks. Is your PC infected? ...
    Joe SmithJoe Smith
    Jul 8, 2005 at 7:47 am
    Jul 11, 2005 at 3:01 am
  • How do I stop Oracle automatically collecting statistics in 10g? Does removing the EMD_MAINTENANCE job do this? Thanks! Steve. Information in this email may be privileged, confidential and is ...
    Barr, StephenBarr, Stephen
    Jul 5, 2005 at 10:42 am
    Jul 6, 2005 at 3:47 pm
  • Anyone actually done this in a production environment? Thanks. -----Original Message----- From: Khemmanivanh, Somckit Sent: Thursday, July 28, 2005 5:22 PM To: Brandon.Allen_at_OneNeck.com; Roger ...
    Roger XuRoger Xu
    Jul 28, 2005 at 5:44 pm
    Aug 2, 2005 at 4:29 pm
  • Hi, We are trying to install oracle 10g release 1 on sun solaris 10 and getting following error: Checking operating system version: must be 5.8 or 5.9. Actual 5.10 Failed <<<< I checked on the ...
    Jul 27, 2005 at 10:28 am
    Aug 1, 2005 at 5:26 am
  • I've got a massive import that takes a long time. This is one I'd love to drop and recreate the index, but that alone would probably be almost a terabyte, so that is out of the question. This is a ...
    Jul 21, 2005 at 9:01 am
    Jul 22, 2005 at 8:13 am
  • Hi all, we have to setup a temporary host(OS Windows 2000), install Oracle software, create an instance on the temporary host's disks and then plug these disks into another host. Both hosts are in ...
    Radoulov, DimitreRadoulov, Dimitre
    Jul 11, 2005 at 11:00 am
    Jul 20, 2005 at 8:02 am
  • Hi list, i would like to know how you guys do to startup oracle9i in winxp without using the windows services. I'm trying with a cmd window using: sqlplus / nolog -- That's ok connect / as sysdba -- ...
    Jul 7, 2005 at 11:59 pm
    Jul 11, 2005 at 10:30 am
  • I am trying to compile a procedure that contains a synonym pointing to another database. I am getting an error ORA-00980 Synonym translation is no longer valid. Is there an easy way around this? ...
    Smith, Ron L.Smith, Ron L.
    Jul 8, 2005 at 12:45 pm
    Jul 8, 2005 at 1:30 pm
  • Good morning all; We are in the process of complying with the IRS security regulations, This is a requirement since our systems contain IRS data. They have adopted the regulations as designed by the ...
    Ruth GramoliniRuth Gramolini
    Jul 6, 2005 at 10:42 am
    Jul 7, 2005 at 11:33 am
  • Hi List, Has somebody used UTL_MAIL in 10g for sending emails with attachments? I'm using the following procedure: CREATE OR REPLACE PROCEDURE mail_attach (dir1 VARCHAR2, filename VARCHAR2) AS ...
    Jul 26, 2005 at 5:17 am
    Jul 27, 2005 at 8:41 am
  • I'm almost done reading Date's book. I have a bunch of questions and need to reread and think about a number of sections. There is one basic question, though, where I am convinced I must be missing ...
    Henry PorasHenry Poras
    Jul 20, 2005 at 1:20 am
    Jul 21, 2005 at 12:00 pm
  • Hi all, We have our production database ( hosted on Windows 2000 Server. Of late we are frequently experiencing ORA-4030 errors, because the Oracle.exe process footprint grows close to 2 GB ...
    Charu JoshiCharu Joshi
    Jul 18, 2005 at 1:45 am
    Jul 19, 2005 at 6:58 am
Group Navigation
period‹ prev | Jul 2005 | next ›
Group Overview
grouporacle-l @

235 users for July 2005

Allen, Brandon: 36 posts Jared Still: 34 posts Rjamya: 33 posts Oracle-l-bounce_at_freelists.org: 31 posts Radoulov, Dimitre: 28 posts Juan Carlos Reyes Pacheco: 25 posts Goulet, Dick: 21 posts Marquez, Chris: 20 posts Mercadante, Thomas F (LABOR): 19 posts Niall Litchfield: 19 posts Dennis Williams: 17 posts Khemmanivanh, Somckit: 17 posts Lex de Haan: 17 posts Sinardy: 15 posts Reidy, Ron: 13 posts Magnus Andersen: 12 posts Mladen Gogala: 12 posts Onkar N Tiwary: 12 posts David Sharples: 11 posts Prem: 11 posts
show more