FAQ

Search Discussions

160 discussions - 871 posts

  • ��������Hello, fellow DBAs. I had a call from a custumer, who bought 2 IBM servers with x64 (4 Xeon64 CPUs per node) architectures and NAS, seeking for RAC solution on Windows. Unfortunately, they ...
    Yavor IvanovYavor Ivanov
    Jul 26, 2006 at 12:09 pm
    Aug 3, 2006 at 2:21 pm
  • Hi all I am migrating a Siebel 7.x CRM database from 8i to 9i under HPUX. This version of Siebel only supports RBO therefore we will be using RBO in 9i as well. I noticed that many execution plan ...
    AmonteAmonte
    Jul 12, 2006 at 6:17 am
    Aug 8, 2006 at 12:40 pm
  • 10.1.0.3 RAC on Solaris 9 w/ Physical and Logical Standby Yep, SR is open. Had another incident Friday night where a column was added to a "large" table (not that large) in the primary database and ...
    Mark StricklandMark Strickland
    Jul 24, 2006 at 10:47 pm
    Aug 15, 2006 at 12:17 am
  • Hi List, I am looking for recommendations on which storage hardware to purchase. I want to connect 2 white box PC's ( which I have ) and storage hardware ( which I don't have yet) into RAC ready ...
    Ranko MosicRanko Mosic
    Jul 7, 2006 at 12:33 am
    Jul 30, 2006 at 8:40 pm
  • Help! Upgraded 8.1.7.4 to 10g rel 2 smoothly over the weekend. Batch works fine, but OLTP is causing CPU and disk i/o to max out at 100%, i believe the optimiser is making bad decisions as my ...
    Peter DixonPeter Dixon
    Jul 11, 2006 at 5:43 pm
    Aug 28, 2006 at 8:47 pm
  • I'm having some issues with a client's RMAN backup. They're on Oracle 8.1.7.4, Solaris 8. It's a weekly full backup, and they're backing up ~1.5TB to disk, and the longer the instance is up, the ...
    Terry SuttonTerry Sutton
    Jul 7, 2006 at 6:05 pm
    Jul 11, 2006 at 3:41 pm
  • Oracle 10.2.0.2, AIX 5.3 I've got a couple queries that are taking a lot longer to parse since upgrading from 8.0.6 to 10.2.0.2. I've posted about these earlier - they are 20+ table outer joins and ...
    Allen, BrandonAllen, Brandon
    Jul 7, 2006 at 4:10 pm
    Jul 10, 2006 at 6:11 pm
  • hi: My oracle version is 9205 and optimizer_features_enable is set to 9.2.0. We have a query choose a bad plan. The query is like this: select /*+ index(e) */ max(event_id), sysdate from ANONYMOUS e ...
    Eagle fanEagle fan
    Jul 19, 2006 at 8:14 am
    Jul 20, 2006 at 1:25 pm
  • Does anybody know of a site that is good for translating unix shell scripts into Windows batch files? I have two rman scripts that I want to run on a windows server. thanks. Don�t just search. Find ...
    Joe SmithJoe Smith
    Jul 19, 2006 at 5:08 pm
    Jul 25, 2006 at 2:46 am
  • Hello all, I was asked to look into Oracle database auditing capabilities to flag any activity done in the database outside the normal use of an application. I'm reading the Oracle manual for ...
    Guerra, Abraham JGuerra, Abraham J
    Jul 28, 2006 at 3:47 pm
    Aug 8, 2006 at 8:01 pm
  • Hi,all When I try to use UTL_SMTP package to send mail,I got the following error: ORA-29278: SMTP transient error: 421 Service not available ORA-06512: at "SYS.UTL_SMTP", line 21 ORA-06512: at ...
    XiaoyanXiaoyan
    Jul 27, 2006 at 8:58 am
    Aug 2, 2006 at 6:16 pm
  • hi problem is that, Database stop respone to application Server but still it is giving response to Toad and others things .this problem we faced two times in production database and also Database ...
    Sachin SethiSachin Sethi
    Jul 17, 2006 at 8:38 am
    Jul 21, 2006 at 3:40 pm
  • Hi guys, I have schema A and A own 20 many objects (tables, functions, triggers and others stuff). How to create user B having same privileges with what A can do with his own objects Something like ...
    Sinardy XingSinardy Xing
    Jul 19, 2006 at 3:39 am
    Jul 20, 2006 at 10:54 am
  • Resending due to message size. I can forward the plans and/or trace file if anyone is interested. -- http://www.freelists.org/webpage/oracle-l
    Schultz, CharlesSchultz, Charles
    Jul 25, 2006 at 5:50 pm
    Jul 28, 2006 at 8:15 am
  • http://www.oracle.com/technology/deploy/security/alerts.htm Oracle Critical Patch Update July 2006 Advisory Doc ID: Note:372927.1 ** Database Server 10.1.0.4 Windows 32: Patch 14 (5239736) UNIX and ...
    Paul DrakePaul Drake
    Jul 18, 2006 at 8:50 pm
    Jul 23, 2006 at 2:51 pm
  • Friends, I need to export to multiple compressed files (on oracle 9iR2). And I need to import from multiple compressed files (without uncompressing). All because of space constraint. I find many ...
    PremPrem
    Jul 14, 2006 at 11:27 am
    Jul 17, 2006 at 12:29 pm
  • Short description - different results for the same selects with or without rather innocent hints. Actually I found it on other tables in our system, but at least I can reproduce a testcase. Same ...
    Gints PlivnaGints Plivna
    Jul 13, 2006 at 3:15 pm
    Jul 15, 2006 at 10:01 pm
  • Hello, I am getting the following error selecting from the view select count(*) from v_xxx; ERROR at line 1: ORA-01135: file 5 accessed for DML/query is offline ORA-01110: data file 5 ...
    Inessa WeinerInessa Weiner
    Jul 12, 2006 at 6:02 pm
    Jul 13, 2006 at 1:32 am
  • I am a visual person, so seeing a graph of histograms is easier for me to grasp statistical information, rather than pure numbers. I tried google, but either the hits were completely irrelevant, or ...
    Schultz, CharlesSchultz, Charles
    Jul 29, 2006 at 4:11 pm
    Aug 10, 2006 at 2:47 pm
  • Arg. I know I've seen this before and I may have actually done it before, but I'll be darned if I can remember how. In 9.2, I have two tables kinda like these: CREATE TABLE ALARM_TYPE ( AT_ID NUMBER ...
    Jesse, RichJesse, Rich
    Jul 24, 2006 at 6:33 pm
    Aug 10, 2006 at 12:58 am
  • Hi All, One of system started to choke today and apparantly it turned to be the sql that was executed more often had sub-optimal plan. After digging around i noticed that the index was fragmented as ...
    StalinStalin
    Jul 28, 2006 at 11:08 pm
    Jul 31, 2006 at 4:54 am
  • Hi, We have a file in a database with two slashes in its name: "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how that file was created, but I inherited that database. The tablespace is full now. I ...
    Ram RamanRam Raman
    Jul 27, 2006 at 9:45 pm
    Jul 29, 2006 at 5:14 pm
  • How do we force the generation of a trace file whenever an error (invalid rowid ora-01410) happens in the database. Right now only some of the ORA-01410 show up in alert log, but not all. Is there a ...
    Deepak SharmaDeepak Sharma
    Jul 27, 2006 at 2:58 pm
    Jul 28, 2006 at 5:03 pm
  • I'm trying to avoid using ASM. It works, but I don't like having to use RMAN to do everything. There are more, but I'll let it go. I've looked all over and can't find any references so I thought I'd ...
    Steve PerrySteve Perry
    Jul 23, 2006 at 8:02 pm
    Jul 25, 2006 at 5:58 am
  • I am being asked by management to compare "new features" of 9i to 10g. I have gone to oracle's website and looked around. Does anybody know where there is a comparsion chart or speadsheet comparing ...
    Joe SmithJoe Smith
    Jul 6, 2006 at 3:03 pm
    Jul 8, 2006 at 6:55 am
  • Hi I have a single instance development database located in node 2 of a 9i RAC database. (development purpose as well). Recently the non-rac database had an instance failure showing this error error ...
    LS ChengLS Cheng
    Jul 25, 2006 at 1:08 pm
    Jul 28, 2006 at 6:16 am
  • Hi I have a HP-UX Server running Oracle 8.1.7.4, there are 6 CPUs. I have a statspack report which shows this (2 hours interval) Snap Id Snap Time Sessions ------- ------------------ -------- Begin ...
    AmonteAmonte
    Jul 21, 2006 at 4:35 pm
    Jul 23, 2006 at 9:19 am
  • Hi, We are having this strange QEP problem...Let me try to explain.... Environment: Oracle: Standard 10.1.0.4 Linux EL4 Some queries (which involves some Index Organized Tables) runs like a charm for ...
    Nirmalya DasNirmalya Das
    Jul 17, 2006 at 2:54 pm
    Jul 19, 2006 at 8:54 am
  • Didn't know if anyone else has run across this, but I spent 1.5 hours trying to get a tried and true find command to work on RHEL4 (32-bit) without success. I wanted to delete the audit files in ...
    Steve PerrySteve Perry
    Jul 8, 2006 at 3:14 am
    Jul 12, 2006 at 7:57 pm
  • Have anybody has dropped a tablespace having oracle erasing the datafiles and when you check the free space in OS it was not freed although the datafiles are gone? TIA -- Alfonso Leon -- ...
    Alfonso LeónAlfonso León
    Jul 7, 2006 at 11:30 pm
    Jul 8, 2006 at 5:07 am
  • Hi, I had a big query which was running out of rollback so after some tuning i had to break it down in to two. from the first query i store the result in a temporary table and then use it for second ...
    A JoshiA Joshi
    Jul 5, 2006 at 2:43 pm
    Jul 7, 2006 at 9:51 pm
  • Hi, I am sure this is a repeat post : can some send me list of recommended books for 9i/10G for pl/sql, performance, dba. Also how can I search the archives for this list. Thanks for help.
    A JoshiA Joshi
    Jul 22, 2006 at 1:08 am
    Aug 1, 2006 at 2:29 pm
  • List, I have a friend that is starting the journey into RAC. Does anyone have a suggestion of the best starting place? Oracle documents, or has someone written the definitive book that will get a ...
    Dennis WilliamsDennis Williams
    Jul 24, 2006 at 7:59 pm
    Jul 26, 2006 at 1:36 pm
  • We will be introducing DB2 UDB into our shop in the near future. I am looking for some information to become familiar with it. Who are the respected individuals within the community? Resources ...
    Tracy RahmlowTracy Rahmlow
    Jul 13, 2006 at 3:34 pm
    Jul 17, 2006 at 5:07 am
  • I'm having difficulty visualizing how tracing would work when dealing with compiled applications. Using some command-line interface I can figure out, but how would I enabled it outside an ...
    Michael RayMichael Ray
    Jul 5, 2006 at 3:07 pm
    Jul 6, 2006 at 6:44 pm
  • Hello everyone, I use Oracle 10g R2 on Fedora Core 4, and I use password file. The value of "os_authent_prefix" is "ops$", (default) and the os user that I'm able to login with it as sysdba using os ...
    Amir GheibiAmir Gheibi
    Jul 25, 2006 at 10:24 am
    Jul 26, 2006 at 8:18 am
  • Hi listers, FYI, skip_unusable_indexes is now a pfile/spfile parameter in 10g (not only alter session based as in 8i/9i) and defaults to ... TRUE. I would prefer FALSE as a better default value. HTH ...
    Gparc_at_free.frGparc_at_free.fr
    Jul 17, 2006 at 3:58 pm
    Jul 18, 2006 at 2:42 pm
  • Can anyone confirm if outlines are disabled with cursor_sharing=false as metaling doc 132547.1 from Nov. 2005 states? Thank you in advance, Laimis N. Fyrirvari/Disclaimer ...
    Laimutis NedzinskasLaimutis Nedzinskas
    Jul 10, 2006 at 12:14 pm
    Jul 11, 2006 at 2:59 am
  • Recently, we bounced our database for maintenance. When it came back up, we had open_cursors set to 1000. Last night, some of our clients didn't get their reports because maximum open cursors was ...
    Sandra BeckerSandra Becker
    Jul 28, 2006 at 8:06 pm
    Jul 31, 2006 at 3:46 pm
  • Folks, We are upgrading from "Veritas Database Edition 3.5 for Oracle 9iRAC" to the "Veritas Foundation Suite 4.1 for Oracle RAC". While testing in the lab with the new version, I noticed that the ...
    Hameed, AmirHameed, Amir
    Jul 27, 2006 at 2:01 pm
    Jul 27, 2006 at 6:17 pm
  • Does anyone know a way to get all used tapes, as part of an RMAN backup, out of either RC_* RMAN views or V$BACKUP views? RC_/V$BACKUP_PIECE.MEDIA lists the tape that was initially used for backing ...
    Herring Dave - dherriHerring Dave - dherri
    Jul 25, 2006 at 2:16 am
    Jul 25, 2006 at 4:47 pm
  • For a new application (dot.net) connecting to Oracle (10gr2) RAC DB, what options are available for connection pooling? developers want to write their own connection manager, but we'd rather use a ...
    RjamyaRjamya
    Jul 17, 2006 at 11:57 am
    Jul 17, 2006 at 3:18 pm
  • Hi all, As I understand it, EM Database Control (against one database) comes with our Enterprise Edition database license. Does this mean we can access all pages in the EM Database Control without ...
    D chengD cheng
    Jul 12, 2006 at 10:55 pm
    Jul 13, 2006 at 4:36 pm
  • � I'm trying to use dbms_advanced_rewrite.declare_query_equivalence, but getting error "SP2-0027: Input is too long ( 2499 characters)" because the query is about 6000 characters. Anyone know of a ...
    Allen, BrandonAllen, Brandon
    Jul 10, 2006 at 8:10 pm
    Jul 10, 2006 at 10:42 pm
  • Hello: we are getting a lot of traces files with the following information, does anybody know why this traces appear and how to supress them? THanks in Advance Alfonso Leon Dump file ...
    Alfonso LeónAlfonso León
    Jul 5, 2006 at 7:03 pm
    Jul 8, 2006 at 8:54 am
  • Apologies for the trivial question, but I realized today that I don’t understand how osh (kicked off from oraenv) supposed to work with scripts for users with low file size limit. Running oraenv ...
    Boris DaliBoris Dali
    Jul 27, 2006 at 7:30 pm
    Aug 1, 2006 at 1:16 pm
  • Google did not deign to tell me, so I am looking elsewhere. In somewhat related terms, is there a set mathematical formula for "data skew"? Folks talk about a "little skew" or "very skewed" data ...
    Schultz, CharlesSchultz, Charles
    Jul 27, 2006 at 8:15 pm
    Jul 28, 2006 at 11:35 pm
  • From the alert log (rac 2 node cluster on solaris with shared raw device): Wed Jul 26 16:43:15 2006 Errors in file /u01/app/oracle/admin/rac1db/udump/rac1db1_ora_6522.trc: ORA-19504: failed to create ...
    Johan MullerJohan Muller
    Jul 27, 2006 at 12:13 am
    Jul 28, 2006 at 5:14 pm
  • Hello I would like to ask you about after servererror trigger. I wrote trigger as below: CREATE OR REPLACE TRIGGER notification_error after servererror on database declare d_sender varchar2(30) := ...
    Wojciech SkrzyneckiWojciech Skrzynecki
    Jul 28, 2006 at 2:45 pm
    Jul 28, 2006 at 4:00 pm
  • DB: 9.2.0.5, OS: HP-UX 11.11 I'm working on some size monitoring scripts to integrate with OS disk usage on HP_UX. The problem I'm running into is that I want to do a group by filesystem. Oracle ...
    Rodd HolmanRodd Holman
    Jul 25, 2006 at 4:30 pm
    Jul 25, 2006 at 6:54 pm
Group Navigation
period‹ prev | Jul 2006 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions160
posts871
users195
websiteoracle.com

195 users for July 2006

Alex Gorbachev: 47 posts Allen, Brandon: 33 posts Kevin Closson: 28 posts Mladen Gogala: 24 posts Jared Still: 22 posts Niall Litchfield: 22 posts Mark Brinsmead: 19 posts Dennis Williams: 18 posts Oracle-l-bounce_at_freelists.org: 17 posts Laimutis Nedzinskas: 15 posts David Sharples: 14 posts Mark Strickland: 14 posts Radoulov, Dimitre: 14 posts LS Cheng: 13 posts Ramick: 13 posts Steve Perry: 13 posts Terry Sutton: 13 posts Schultz, Charles: 11 posts Xiaoyan: 11 posts Yechiel Adar: 10 posts
show more
Archives