FAQ

Search Discussions

141 discussions - 717 posts

  • I keep my certification current. It gives me that extra bit of motivation. Plan to get the OCM. Figure I talked my way into my first DBA job in 1993 (v6.0.3...scared without excrement to upgrade to ...
    Mark StricklandMark Strickland
    Jun 9, 2008 at 5:09 am
    Jun 12, 2008 at 6:18 pm
  • Hi, List, Can you please share the best practice inside your organization about how you meet your audit requirement? How do you audit oracle users, especially DBAs? We are a small shop and all DBAs ...
    Li LiLi Li
    Jun 26, 2008 at 6:11 pm
    Jul 3, 2008 at 3:28 pm
  • Well, I visited the SourceForge site of my long time fav Oracle tool TOra. The end of life release has been posted. Why is it my favorite tools die ugly deaths... Does anyone have a suggestion for ...
    John D ParkerJohn D Parker
    Jun 13, 2008 at 7:56 pm
    Jun 16, 2008 at 7:04 pm
  • All, This is a minor annoyance, but any clues from anyone on the list would be appreciated. I have Grid control up (version 10.2 on AIX) and monitoring 6 database servers. It does a reasonably good ...
    Mercadante, Thomas F (LABOR)Mercadante, Thomas F (LABOR)
    Jun 16, 2008 at 12:55 pm
    Jun 18, 2008 at 3:35 pm
  • List, It's official - hiring managers consider the value of a certification to be lower than a few years ago ...
    Dennis WilliamsDennis Williams
    Jun 6, 2008 at 7:45 pm
    Jun 12, 2008 at 1:44 pm
  • we have ORACLE 10.2.0.4 with Redhat AS 4.4 on DELL server. Recently we are test "UTL_SMTP" on ORACLE PL/SQL program and tried to send MAIL to customers. The problem is this send MAIL program always ...
    Dba1 mccDba1 mcc
    Jun 26, 2008 at 3:56 pm
    Jun 26, 2008 at 10:13 pm
  • All, We have a user that needs to do cleanup on a table in a 10.2 instance and wants to remove rows in a table based on when the record was created but there is no creation date as part of the record ...
    Langston, ChrisLangston, Chris
    Jun 18, 2008 at 2:44 pm
    Jun 20, 2008 at 10:13 pm
  • To borrow the style from some MetaLink notes-- Fact: Oracle 10.2.0.1.0 Fact: RedHat 3 Fact: 3 node RAC Many concurrent sessions inserting one row at a time into the same table. On first run, table in ...
    Baumgartel, PaulBaumgartel, Paul
    Jun 25, 2008 at 7:18 pm
    Jun 26, 2008 at 2:46 pm
  • Hello *, I'm a bit confused with CR block management in db cache... Please have a look at the following test case: Session 1 SQL startup #obj=53254, DBABLK=61458 - table T SQL select ...
    Robert BialekRobert Bialek
    Jun 25, 2008 at 11:50 am
    Jul 2, 2008 at 4:04 pm
  • http://www.jlcomp.demon.co.uk/faq/duplicates.html I do not know how to do an 'alter table add unique constraint' in parallel. the only way I know how to use parallel is with a 'create index'. Problem ...
    Rick RickyRick Ricky
    Jun 23, 2008 at 1:24 pm
    Jun 25, 2008 at 5:48 pm
  • We are moving all of our instances to AIX from Windows and VMS. Since I have been the only DBA on the new AIX servers, I have been using the oracle OS user login. Now that we are moving into ...
    DIANNA GIBBSDIANNA GIBBS
    Jun 16, 2008 at 8:49 pm
    Jun 18, 2008 at 5:57 pm
  • Hi guys, Hypothetical situation. I have a view. The view has one field. The DDL: create view test_view as select 1 + 2 "test_col" from dual; Now if a user does this: select * from test_view; The ...
    Lyndon TiuLyndon Tiu
    Jun 12, 2008 at 1:39 pm
    Jun 13, 2008 at 1:19 pm
  • Greetings, I have been asked the following questions by the windows administrator on one of the databases I administer. Is it possible to restrict Oracle to one of the two processors. We would be ...
    William WagmanWilliam Wagman
    Jun 5, 2008 at 10:53 pm
    Jun 12, 2008 at 11:04 pm
  • Hi Vivek, As I mentioned in the private reply, you need to take two snapshots of netstat output (over 10 sec interval for example) and calculate delta between corresponding bytes/sent values (also ...
    Tanel PoderTanel Poder
    Jun 3, 2008 at 2:14 pm
    Jul 2, 2008 at 8:57 am
  • Oracle 10.2.0.3 HP-UX I have a 10.2 listener listening on port 1522, and see connections established using that. However, I also see connections coming in on other ports, that look like the increment ...
    Sherrie.Kubis_at_swfwmd.state.fl.usSherrie.Kubis_at_swfwmd.state.fl.us
    Jun 26, 2008 at 4:58 pm
    Jun 26, 2008 at 7:58 pm
  • I give up. I keep taking feedback from previous conferences and incorporate them into my future presentations, and I still can't get them right. I was "slow", well, the last few times I was "too ...
    Grabowy, ChrisGrabowy, Chris
    Jun 12, 2008 at 6:26 pm
    Jun 14, 2008 at 1:34 am
  • Upgraded a database to 10.2.0.4 from 9.2.0.8. Trying out some 10g features and notice recyclebin is not working. SQL SQL create table jb (f1 number); Table created. SQL drop table jb; Table dropped ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jun 10, 2008 at 4:00 pm
    Jun 10, 2008 at 5:31 pm
  • Hi, all When using tcpdump to check what happen over the network when do a simple query as SQL select sysdate from dual; SYSDATE 20-JUN-08 The tcpdump is as following, 3 round trips between the ...
    Qihua wuQihua wu
    Jun 20, 2008 at 9:13 am
    Jul 16, 2008 at 11:36 pm
  • I have an Oracle 9i (9.2.0.7.0) database. One question on table export. Can we export a table and import into another table (which has the same structure)? Both the tables are in the same schema ...
    Anurag VermaAnurag Verma
    Jun 30, 2008 at 11:10 pm
    Jul 2, 2008 at 2:02 pm
  • Hi everyone - Forgive me if this has been asked before... how / where can I research what the various wait events mean? I'm seeing an event called "messages" and that is such a common word it is ...
    Wittry, DanWittry, Dan
    Jun 19, 2008 at 2:50 pm
    Jun 28, 2008 at 8:57 pm
  • http://www.theregister.co.uk/2008/06/20/oracle_license_increase/ I hadn't seen someone post this to the list yet - the database's list prices are going up by 18% ($47,500 list for an EE CPU now) ...
    Matthew ZitoMatthew Zito
    Jun 20, 2008 at 3:06 pm
    Jun 24, 2008 at 8:11 pm
  • Hi list, does ASM's EXTERNAL REDUNDANCY feature stripe the data or does it concatenate them? Background: Oracle EE x86_64 on Linux, Version 10.2.0.4 Setup: 2x Adaptec 5085, each connected to an own ...
    Martin KlierMartin Klier
    Jun 30, 2008 at 9:54 am
    Jul 1, 2008 at 2:21 pm
  • I seem to remember chuckling heartily over an article in Oracle Magazine sometime in the late '90s (??) or possibly slightly later, with the title, "A Day in the Life of a DBA." The article ...
    Jeremiah WiltonJeremiah Wilton
    Jun 27, 2008 at 12:33 am
    Jun 30, 2008 at 6:41 pm
  • Environment: IBM zSeries VM, SLES10, Oracle EE 10.2.0.3 We have several SQL queries that run slowly when run through SQL Server Reporting Services 2005. Explain plans with the bind variable look ...
    Sandra BeckerSandra Becker
    Jun 25, 2008 at 5:30 pm
    Jun 26, 2008 at 3:01 pm
  • We've got the auditors in this week and I need to provide a list of what oracle patches were applied and when they were applied. I can do 'opatch lsinventory -all' which is good for interim patches ...
    Neil OverendNeil Overend
    Jun 20, 2008 at 11:59 am
    Jun 20, 2008 at 2:53 pm
  • Is it normal or best practice to snapshot the control file to disk even if the backup is going to tape? The rman closed backup runs to tape with no problem, but I noticed that the snapshot of the ...
    Joe SmithJoe Smith
    Jun 6, 2008 at 6:10 pm
    Jun 6, 2008 at 9:05 pm
  • I need idea to change this sql to return one row. select 1 from dual where NUMTAB(9,8,4) in NUMTAB(4,8,9,33); Amihay Gonen Dba Team Leader PD Division ECTel Ltd. celluar:+972-525092168 ...
    Amihay GonenAmihay Gonen
    Jun 5, 2008 at 2:14 pm
    Jun 6, 2008 at 6:36 am
  • OS= HP-UX 11 Oracle version 10.1.0.4 I need to move a bunch of oracle homes to new filesystems. The problem is matching up the installed options exactly. One would think, install the new version via ...
    BobBob
    Jun 20, 2008 at 11:39 pm
    Jun 23, 2008 at 12:52 pm
  • Hi All, I have inherited an application which opens a new connection to the database every single time it executes a query. The CPUs are all maxed out despite the fact that each individual query is ...
    Charlotte HammondCharlotte Hammond
    Jun 9, 2008 at 11:10 am
    Jun 11, 2008 at 4:32 pm
  • Can you guys give me opionions reasons why to have the $ORACLE_HOME product on the cluster filesystem? I believe on benefit for not doing this is when you upgrade you can bring one node down at a ...
    Laura penaLaura pena
    Jun 9, 2008 at 12:54 pm
    Jun 10, 2008 at 11:12 am
  • Oracle 8.1.7.4 - Solaris 5.9 - Cost based optimizer I have a query which takes 28 minutes to run on my production system and about a two minutes to run on my QA database. The query looks like this ...
    Schauss, PeterSchauss, Peter
    Jun 4, 2008 at 2:08 pm
    Jun 6, 2008 at 3:55 am
  • I've been battling rman strangeness for some time. Every couple of days, messages like the following will show up in our rman logs: RMAN-00571 ...
    Stephens, ChrisStephens, Chris
    Jun 2, 2008 at 2:35 pm
    Jun 3, 2008 at 8:39 am
  • Hey all, I have a new 10.2 XE install on Win2K3 server (box is VMware if that matters). Since I'm running GC 10.2.0.3.0 (OMS and Repository are OEL4), I've installed the 10.2.0.3.0 agent on the ...
    Rich JesseRich Jesse
    Jun 25, 2008 at 1:52 pm
    Jun 30, 2008 at 7:08 pm
  • I am having problems with my OEM Agent on Solaris 64-bit since I have upgraded to 10.2.0.4. I am seeing the following in my log files: 2008-05-16 08:37:06,778 Thread-21594 ERROR upload: rawdata.dat ...
    Arnold, SandraArnold, Sandra
    Jun 23, 2008 at 2:32 pm
    Jun 30, 2008 at 1:40 pm
  • Can anyone recommend any books, technical papers or web sites which discuss SQL tuning using Oracle's 10053 trace data? I know Cary Millsap's new company Method-R offers a week long class on this ...
    Andrew ZitelliAndrew Zitelli
    Jun 25, 2008 at 5:17 pm
    Jun 27, 2008 at 2:07 pm
  • Oracle stores the High Value of a Partition in a Long column. I swear I've searched the friendly web, and I just can't figure out how to get this long column converted back to a date or char I can ...
    Brady, MarkBrady, Mark
    Jun 26, 2008 at 7:10 pm
    Jun 27, 2008 at 4:17 am
  • Hi all, I'm facing a problem on Oracle 10.2.0.3 linux 64bit (Centos 5) I'm issuing a simple delete from command, the table has 4M rows and is referenced by some fk (but there is and index for every ...
    Giovanni CuccuGiovanni Cuccu
    Jun 25, 2008 at 11:19 am
    Jun 26, 2008 at 6:11 pm
  • In have a customer still runing 8.1.7. They were having performance issues which appeared to be due to frgmentation. An export and import solved the performance issue. They are due to move to Orcale ...
    John DunnJohn Dunn
    Jun 20, 2008 at 11:36 am
    Jun 20, 2008 at 7:22 pm
  • Oracle 10gr1 on AIX. RMAN backups using Recovery catalog and CommVault Using a full backup, we are trying to refresh a database on another server (something done quite frequently without problems) ...
    Daniel FinkDaniel Fink
    Jun 16, 2008 at 4:07 pm
    Jun 16, 2008 at 6:39 pm
  • Hello Friends I'd like to ask about Oracle RAC in Linux environment. I installed two machine with RedHat AS 4Up5 and Oracle 10.2.0.3 with ClusterWare. The installation finish with successful and the ...
    Waldirio Manhães PinheiroWaldirio Manhães Pinheiro
    Jun 12, 2008 at 2:01 pm
    Jun 13, 2008 at 12:22 am
  • Question, anyone ever see the following behavior form the 10.2 listener on AIX 4.3? pfbwqas:orabws 1 lsnrctl start LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 11-JUN-2008 ...
    Goulet, DickGoulet, Dick
    Jun 11, 2008 at 2:16 pm
    Jun 12, 2008 at 9:31 pm
  • I am running a query to dump some rows and I made the rows comma delimited like this select col1||','||col2||','|| .... from table I set lines 5000. I want to spool it so the spool file does not ...
    Rick RickyRick Ricky
    Jun 11, 2008 at 1:27 pm
    Jun 12, 2008 at 6:10 am
  • Hi, Could some one help on the below error F:\ tnsping CDER TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 10-JUN-20 08 14:00:10 Copyright (c) 1997, 2006, Oracle Corporation ...
    Shanmugam, DhandapaniShanmugam, Dhandapani
    Jun 10, 2008 at 7:02 pm
    Jun 11, 2008 at 10:09 am
  • We had consultant come in and build a 3 node rac for us. I need to know how to find out which /dev/mapper/mpath devices are used in the asm diskgroup. Oracle 10gR2 10.2.0.4 RHEL 4.6 Thanks Allan -- ...
    Allan NelsonAllan Nelson
    Jun 9, 2008 at 2:16 pm
    Jun 10, 2008 at 2:40 am
  • Hello, I'm attempting to create a custom report in 10gr2 EM, looking for auditing information. I know there is a separate report for failed logins (which runs successfully), but the actual SQL isn't ...
    Newman, ChristopherNewman, Christopher
    Jun 4, 2008 at 5:15 pm
    Jun 4, 2008 at 8:01 pm
  • Hello to you all, I've an old fashion application that uses an Oracle Database where each application user, is also a database user. That way, each user can connect to the database through other ...
    Ricardo SantosRicardo Santos
    Jun 2, 2008 at 11:48 am
    Jun 3, 2008 at 6:47 pm
  • I have a need to export data from a 9i database in XML format. Using the table and column names as the XML descriptors (or whatever they are called) would be fine. Ideally I'd like to be able to ...
    Janine SiskJanine Sisk
    Jun 19, 2008 at 9:00 pm
    Jul 4, 2008 at 1:07 pm
  • All, I am running a multi-node RAC Oracle 10.2.0.3 on Windows64. I am using Incremental Merge Backups to the FRA and my database is on ASM. I use RMAN and Windows .cmd files to run my backups to disk ...
    Frank PettinatoFrank Pettinato
    Jun 23, 2008 at 11:36 pm
    Jun 24, 2008 at 6:13 pm
  • I am connecting to an Oracle instance through a Oracle 10G client in a Windows box. Is it possible to choose the client's port number or limit the port number range not to be so wide (ie, from 4500 ...
    Jose Manuel QuesadaJose Manuel Quesada
    Jun 17, 2008 at 11:50 am
    Jun 17, 2008 at 1:47 pm
  • I am pretty sure I need to use the model clause to do this efficient. I am reading the docs and examples, but I am a bit stumped. I have two tables daily_summary ( day_id number, empno number, ...
    Rick RickyRick Ricky
    Jun 11, 2008 at 3:28 am
    Jun 11, 2008 at 4:19 pm
Group Navigation
period‹ prev | Jun 2008 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions141
posts717
users191
websiteoracle.com

191 users for June 2008

Jared Still: 40 posts Dan Norris: 22 posts Niall Litchfield: 20 posts Mark W. Farnham: 17 posts Bradd Piontek: 16 posts Blanchard William: 15 posts Rich Jesse: 14 posts Mercadante, Thomas F (LABOR): 13 posts Yong Huang: 13 posts Robert Freeman: 12 posts Lyndon Tiu: 11 posts Nuno Souto: 11 posts Bobak, Mark: 10 posts Dennis Williams: 10 posts Elliott, Patrick: 10 posts Andrew Kerber: 9 posts Martin Klier: 9 posts Tanel Poder: 9 posts Yechiel Adar: 9 posts David Barbour: 8 posts
show more
Archives