Search Discussions

169 discussions - 963 posts

  • I want to run a command on sqlplus without making re-connection. At the same time I also want to see the output. I can do this using UNIX but only problem is I have to make reconnection after every ...
    Thotangare, Ajay \(GTI\)Thotangare, Ajay \(GTI\)
    May 9, 2007 at 3:23 pm
    May 24, 2007 at 7:08 pm
  • We are running a few Oracle9i and 10g databases on RHEL and I have always opted NOT to have the databases automatically restart when the server goes down due to something unexpected. My thinking was ...
    Dwayne CoxDwayne Cox
    May 10, 2007 at 12:38 pm
    May 11, 2007 at 5:18 pm
  • Hi, I am at a site which is a high intensive OLTP site doing more than 400 txns/sec on a 8 node cluster on RAC. We are thinking of switching off bind variable peeking and looking into an ...
    Fairlie regoFairlie rego
    May 8, 2007 at 8:43 am
    May 11, 2007 at 2:49 pm
  • I have been a dba for 7 years working with many different databases. I am wanting to get certified in Oracle(10G) to help open up some doors. Can anyone recommend the best book(s) to purchase to ...
    Chris HooverChris Hoover
    May 22, 2007 at 7:34 pm
    May 30, 2007 at 6:03 pm
  • Hi All, As we know when we issue a COMMIT the log buffer content is flushed to the online redo log file before the "Commit complete" status is returned to the user. Please correct me if I am wrong. I ...
    DBA DeepakDBA Deepak
    May 17, 2007 at 2:10 am
    May 17, 2007 at 1:11 pm
  • Greetings Daniel Here is the info, Candidate Datafile: Tablespace Name Size(M) Used(M) Used% ------- ------- ----- AS_INDEX_ES /u56/oradata/vrasdb/ AS_INDEX_ES_01.dbf 6983 1250 18.00 HWM TOTAL_BLOCKS ...
    May 1, 2007 at 7:28 pm
    May 4, 2007 at 2:49 pm
  • Hi all: Something is chewing up the space in /oracle filesystem (AIX). I have trimmed all the log files I could find. No sooner do I free up the space than it gets used up. Can you help me find what ...
    Manjula KrishnanManjula Krishnan
    May 15, 2007 at 6:09 pm
    Aug 17, 2007 at 3:13 pm
  • I am trying to shake out some performance issues in an application which we are putting up (Peregrine Service Center) on Oracle, HPUX. One particular query retrieves 67 rows and runs for ...
    Schauss, PeterSchauss, Peter
    May 22, 2007 at 9:02 pm
    Jun 13, 2007 at 1:53 pm
  • Hello. We have a pl/sql script which we run regularly in the database to monitor tablesapce usage and to generate email notification on our regular (non-RAC) database. This script when run on RAC ...
    Shivaswamy RaghunathShivaswamy Raghunath
    May 14, 2007 at 2:42 pm
    May 18, 2007 at 9:12 pm
  • Following the replacement of a disk I did a mksysb restore on a AIX 5.2 machine running Oracle 9.2 All the Oracle software, data files etc were on a tar tape that has also been restored. But now when ...
    John DunnJohn Dunn
    May 4, 2007 at 7:51 am
    May 4, 2007 at 4:47 pm
  • G'day all. I've spent all day yesterday and today trying to figure this out - but no luck. Has anyone seen this before, or maybe a hint where to look? I've tried all Oracle doco, google, the list ...
    Tony van LingenTony van Lingen
    May 29, 2007 at 1:56 am
    Jul 31, 2007 at 7:01 pm
  • Afternoon all, Sorry about the 'stupidity' of the following question, but I've just been bitten by it, and I can't find a proper answer anywhere in the Oracle DOCS, online or anywhere. If you know of ...
    Norman DunbarNorman Dunbar
    May 11, 2007 at 1:00 pm
    May 18, 2007 at 12:59 pm
  • Looking for comments & experiences regarding sizes of datafiles. We have a large (6+ TB) OLTP database, which currently has 2300+ datafiles. A while ago, we stopped adding datafiles and were ...
    May 2, 2007 at 3:50 pm
    May 4, 2007 at 1:07 am
  • Hello, There is a problem with one of backups for (64-bit) database on AIX 5.3 - 01. The RMAN backup script sends the following error: released channel: ch00 released channel: ch01 released ...
    Andrey GoryunovAndrey Goryunov
    May 29, 2007 at 12:21 am
    Jun 26, 2007 at 4:09 am
  • Hi all, Hope all is well. I have an issue with dropping undo tablespace. I am running Oracle 9i on Solaris 9. On one of our production database, our UNDO tablespace datafiles have autoextend ON, so ...
    Godwin vincentGodwin vincent
    May 31, 2007 at 6:53 pm
    May 31, 2007 at 9:53 pm
  • I just started at a new company about 4 months ago and I noticed that about 4800 of the 7900 tables ( 60% ) do not have primary keys. Is this a problem that I should bring to management or is it more ...
    May 31, 2007 at 4:08 pm
    Jun 8, 2007 at 6:41 am
  • is it just for me or the site is not responding to anyone? Best regards RJamya -- http://www.freelists.org/webpage/oracle-l
    May 31, 2007 at 12:56 pm
    Jun 7, 2007 at 11:11 am
  • Greetings, On a two node RAC cluster, Oracle Enterprise Edition on RHEL4 64-bit using CRS. In my listener.log I see numerous occurrences of the message... WARNING: Subscription for node ...
    William WagmanWilliam Wagman
    May 18, 2007 at 9:40 pm
    May 28, 2007 at 11:18 am
  • Can I do an Alter Index rebuild to move an index to an index tablespace while the database is up? We are a 24x7 operation with scheduled outages usually only once a month. alter index ...
    May 15, 2007 at 3:52 pm
    May 15, 2007 at 7:15 pm
  • Have just installed Oracle 10.2 on AIX 5. When I run sqlplus as oracle it runs OK. When I run it as another user I get the message below I thought the environment variables were not set, but ...
    John DunnJohn Dunn
    May 14, 2007 at 1:12 pm
    May 14, 2007 at 4:26 pm
  • I finally get the chance to recover from a failure and it turns out to be the worst kind - DW (NOARCHIVELOG) 10.2 on RedHat I am using Robert's excellent RMAN book (which was delivered to me from ...
    Rick WeissRick Weiss
    May 3, 2007 at 6:41 pm
    May 4, 2007 at 11:38 am
  • Hello. I need to get "instance" from ('instance.company.com') on SQLPLUS. How I can do this? I tried to use REGEXP_SUBSTR function, but could not make much headway. Please note that, the ...
    Shivaswamy RaghunathShivaswamy Raghunath
    May 17, 2007 at 5:22 pm
    May 18, 2007 at 5:34 pm
  • Folks How can the Schema OWNER of ALL Objects Owned by (say) OWNER1 be Changed to OWNER2 in 10gR2? NOTE - OWNER2 does NOT exist in the Database. NOTE - Other / multiple schemas & respective Objects ...
    May 14, 2007 at 8:16 am
    May 17, 2007 at 12:54 pm
  • Hi Recently I asked about number of voting disks, why odd number is recommended. The responses I have received from several of you states that it is used as Tie Breaker. My question now is, what ...
    May 10, 2007 at 2:28 pm
    May 11, 2007 at 7:22 am
  • I'm researching data guard with physical and logical standby databases. We currently are running standby database in 9.2 and are investigating options that data guard will give us after upgrading to ...
    Smith, Steven K - MSHASmith, Steven K - MSHA
    May 7, 2007 at 11:28 pm
    May 9, 2007 at 8:43 pm
  • Hi all, Luckily this is for a non-production tablespace, but I ran into a problem -- http://www.freelists.org/webpage/oracle-l
    Bill FergusonBill Ferguson
    May 4, 2007 at 7:03 pm
    May 7, 2007 at 4:29 pm
  • I'm working on an SR with Oracle because a number of key queries got their execution plans mugged in an upgrade from 9206 to 9208. I got the following in the SR: After having upgraded to, the ...
    Allan NelsonAllan Nelson
    May 10, 2007 at 3:19 pm
    May 26, 2007 at 4:06 pm
  • Morning all. Our production database ( on RHEL3) is USASCII7, and we've recently had issues with western euro characters being used. I'm researching the idea of migrating to WE8ISO8859P1. So ...
    Don SeilerDon Seiler
    May 9, 2007 at 3:17 pm
    May 21, 2007 at 8:44 pm
  • Hi! from time to time one of our production servers experience ORA-04031 (lack of memory in SGA). today it happens to PMON, so the instance went down. The software is 10gR2 with enabled ASMM. We ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    May 9, 2007 at 1:38 pm
    May 11, 2007 at 8:15 am
  • hi all, My company is asked to make a proposal for an ERP application for several small business companies who uses this application. the situation now is that those companies each have a single ...
    Joop GijsbersJoop Gijsbers
    May 3, 2007 at 5:31 pm
    May 4, 2007 at 10:46 am
  • Hi experts, Does anyone of you know about a way how to influence the threshold for optimizer statistics becoming stale with TABLE MONITORING? I guess that there is an underscore parameter for this ...
    Lutz HartmannLutz Hartmann
    May 21, 2007 at 7:53 pm
    Jun 14, 2007 at 8:30 am
  • List, We are planning to move one of our highly OLTP Oracle 10gR2 database on AIX from single instance to 2 node RAC. I just would like hear from any of one here about the issues or potential ...
    Syed Jaffar HussainSyed Jaffar Hussain
    May 30, 2007 at 7:10 am
    May 31, 2007 at 5:09 pm
  • Greetings, We have 2 databases devx, testx are on the same server and database links are created from devx to testx and vice versa. The following scenario clearly shows that there is an issue with ...
    William WagmanWilliam Wagman
    May 23, 2007 at 12:00 am
    May 24, 2007 at 3:19 pm
  • we have ORACLE on version after we truncate sever tables, we still can NOT shrink data file due to high water mark did not change. Does there has way to check which table after truncate high ...
    Dba1 mccDba1 mcc
    May 17, 2007 at 2:53 pm
    May 18, 2007 at 8:29 pm
  • Is there a way to name the trace file with dbms_system.set_ev();: sys.dbms_system.set_ev(); I have a login trigger that does: sys.dbms_system.set_ev(l_sid,l_serial#,10046,l_level,''); but I need to ...
    Joe SmithJoe Smith
    May 17, 2007 at 3:54 pm
    May 18, 2007 at 12:52 am
  • I've been doing some reading on parallelization, after seeing Doug Burns' presentation on the Pythian blog a while back. In it, Doug mentioned that he doesn't set any degree of parallelization on ...
    Don SeilerDon Seiler
    May 15, 2007 at 8:48 pm
    May 16, 2007 at 2:31 pm
  • Folks Attempting to Create an Application specific Package / Package Body giving the following Error :- SQL @pack_generic_update.sql Creating PACKAGE GENERIC_UPDATE Package created. Warning: Package ...
    May 15, 2007 at 12:10 pm
    May 16, 2007 at 10:38 am
  • I am reading the section regarding conditional compilation here. http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part1.html#compile What is the difference for the example below ...
    Ethan PostEthan Post
    May 15, 2007 at 3:32 pm
    May 15, 2007 at 5:58 pm
  • What kinds of contention do we still need to look for in a RAC and SAN environment? Thanks Brian Lock DBA - East Campus -- http://www.freelists.org/webpage/oracle-l
    May 11, 2007 at 5:42 pm
    May 15, 2007 at 5:46 pm
  • My mentors: we are in the midst of migrating from 9i to 10g. we are a small shop, and unfortunatly are bound to the old hardware for the applications hitting the new database. My question is, for our ...
    Bryan WellsBryan Wells
    May 8, 2007 at 9:51 pm
    May 10, 2007 at 2:25 pm
  • Hi all, I'm being asked to justify the cost of hardware over software raid (38 gig Oracle database, soon to be migrating to 10g - on Solaris). Does anybody know of any good white papers, ...
    David PeasleyDavid Peasley
    May 3, 2007 at 3:06 pm
    May 10, 2007 at 2:07 am
  • When I start the oracle 10 listener it shows an XDB service running. I don't want it running and I am sure in previous versions I just removed the entry from listener.ora. However I see no XDB ...
    John DunnJohn Dunn
    May 9, 2007 at 2:41 pm
    May 9, 2007 at 4:15 pm
  • Hi, In RAC database, how to find out logfiles used by a instance. I queried gv$logfile view, but it is showing all logfiles and it is not clear which files are attached to which instance. Following ...
    Manmohan JalsinghManmohan Jalsingh
    May 8, 2007 at 6:46 pm
    May 9, 2007 at 7:30 am
  • I am running Oracle on HPUX B.11.23. We have an application which complains that it is getting the date in 'DD-MON-RR' format. I changed nls_date_format for the database using: alter ...
    Schauss, PeterSchauss, Peter
    May 4, 2007 at 5:20 pm
    May 5, 2007 at 9:09 pm
  • All: We have need to obtain information from RMAN including the specific tape volumes on which various backupsets are written. For example, "show me the information in the catalog for backupsets ...
    May 2, 2007 at 7:28 pm
    May 4, 2007 at 4:43 pm
  • Is there any way to do an export of a view in either 9i or 10g? I am pretty sure the answer is no, but thought I would ask anyway. Get a FREE Web site, company branded e-mail and more from Microsoft ...
    J. DexJ. Dex
    May 3, 2007 at 3:03 pm
    May 3, 2007 at 7:34 pm
  • Hi folks, I'm about to inherit an interesting project - a group of five databases that produce approximately 2 terabytes (!) of archived redo log files per day. Apparently the vendor ...
    Lou AvramiLou Avrami
    May 3, 2007 at 5:08 am
    May 3, 2007 at 6:01 pm
  • all, both tables are partitioned, with key: EVENT_T PARTITION BY RANGE ("POID_ID0") EVENT_SESSION_IPT_CALL_T PARTITION BY RANGE ("OBJ_ID0") but I_EVENT_IPT_CALL__TRANSID index only 1 column index ...
    Ujang JaenudinUjang Jaenudin
    May 1, 2007 at 8:34 am
    May 3, 2007 at 5:04 am
  • Just upgraded from and this view won't compile. View references columns that don't exist in X$ESTIMATE_MTTR. Not sure if is the view of X$. Ethan -- http://www.freelists.org/webpage/oracle-l
    Ethan PostEthan Post
    May 15, 2007 at 7:50 pm
    May 18, 2007 at 6:31 pm
  • Hey everyone – I just finished putting together a research paper about Oracle services and I'd like to know if you could help my out by reviewing it. I haven't yet seen any single paper that really ...
    Jeremy Paul SchneiderJeremy Paul Schneider
    May 9, 2007 at 9:00 pm
    May 17, 2007 at 7:24 am
Group Navigation
period‹ prev | May 2007 | next ›
Group Overview
grouporacle-l @

244 users for May 2007

Jared Still: 41 posts Allen, Brandon: 24 posts Mercadante, Thomas F \(LABOR\): 20 posts Robert Freeman: 19 posts Dennis Williams: 17 posts Richard J. Goulet: 17 posts Shivaswamy Raghunath: 17 posts Christian Antognini: 16 posts Kerber, Andrew W.: 16 posts Niall Litchfield: 16 posts Rjamya: 16 posts Don Seiler: 14 posts Alberto Dell'Era: 13 posts Bobak, Mark: 13 posts William Wagman: 13 posts Hemant K Chitale: 12 posts Mark W. Farnham: 12 posts Thotangare, Ajay \(GTI\): 12 posts Ujang Jaenudin: 12 posts DBA Deepak: 11 posts
show more