FAQ

Oracle > oracle-l > October 2007

Search Discussions

166 discussions - 785 posts

  • I have read the BAARF articles about RAID and write intensive Oracle databases. Are any of these problems mitigated with RAID 5 7+1. I did some googling, but the 7+1 part is not really clear. Has ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Oct 4, 2007 at 7:57 pm
    Oct 30, 2007 at 9:01 pm
  • Good morning, can somebody explain what is the difference between Processes and Sessions init paramaters. Thanks -- Mir M. Mirhashimali Oracle Systems Manager Database Architecture, Enterprise ...
    Mir M. MirhashimaliMir M. Mirhashimali
    Oct 30, 2007 at 4:45 pm
    Nov 5, 2007 at 12:23 am
  • We're looking to implement Symantec Storage Foundation HA for Oracle RAC to offer HA for our Oracle 10g RAC on RHEL. Oracle has fully certified most of the components within this Symantec solution, ...
    Ken NguyenKen Nguyen
    Oct 29, 2007 at 9:46 am
    Nov 1, 2007 at 4:54 am
  • Looking to see if people are successfully using streams to move data between 2 databases. This would be on 10g, HP-UX machines. I have attempted a few test cases and have not been able to get the ...
    Fedock, John \(KAM.RIC\)Fedock, John \(KAM.RIC\)
    Oct 18, 2007 at 3:26 pm
    Oct 21, 2007 at 11:12 pm
  • Need some help on this. We have a peoplesoft environment here that seems to have performance issues every so often. When this happens performance comes to s standstill for everyone and a SQL*Plus ...
    Zanen van, J (Jacob)Zanen van, J (Jacob)
    Oct 31, 2007 at 3:00 am
    Nov 6, 2007 at 3:20 pm
  • Hi: I have had the same problem before. From v$sql: Delta CPU_TIME Delta Elapsed_time. The sql is very simple, it's doing "INDEX UNIQUE SCAN" using PK index.' How to explain this? Thanks SQL select ...
    Eagle FanEagle Fan
    Oct 23, 2007 at 6:02 am
    Oct 29, 2007 at 11:05 am
  • Hi Experts, I have a question that's a bit unethical. For a company i'm working for i need to find out what the passwords are of oracle users. As changing them means a lot of work for allot of ...
    Vincent verpoortVincent verpoort
    Oct 16, 2007 at 1:14 pm
    Oct 22, 2007 at 12:18 pm
  • We have a procedure which calls dbms_metadata.get_ddl to get the ddl for an index & this works fine for objects (indexes) owned by the same user as my procedure. For all other objects I get the error ...
    A EbadiA Ebadi
    Oct 15, 2007 at 5:28 am
    Oct 21, 2007 at 4:43 am
  • Hi All, I'm having a bit of an issue with our designers/developers for our so called "datawarehouse" Columns are added to tables every so often based on requirements from the business. They however ...
    Zanen van, J (Jacob)Zanen van, J (Jacob)
    Oct 22, 2007 at 6:00 am
    Oct 23, 2007 at 10:31 pm
  • List, I just spent the last two weeks digging through trace files before I finally narrowed down the problem enough that I could open an SR with Oracle and find out I've encountered a known bug so I ...
    Allen, BrandonAllen, Brandon
    Oct 25, 2007 at 5:24 pm
    Nov 7, 2007 at 10:15 pm
  • Hi Experts, Have enabled directIO on Solaris 9 (Oracle 10g) by setting the parameter filesystemio_options=setall Is there any way that I can verify whether Oracle is using directIO or not? -- ...
    DBA DeepakDBA Deepak
    Oct 17, 2007 at 10:20 am
    Nov 21, 2007 at 11:12 pm
  • All, Running on 9.2.0.7 on Aix. I have a database table with 18 million rows in it. There is an SSN column in the table. Only 625,000 rows have an SSN populated. I also have an index on this column ...
    Mercadante, Thomas F (LABOR)Mercadante, Thomas F (LABOR)
    Oct 2, 2007 at 3:12 pm
    Oct 4, 2007 at 6:55 pm
  • Hi all - I am in the "conception" stage of setting up Heterogeneous Services (HS) from a 9.2.0.8 Linux database to a MSSQL 2000 (v 8.00.2039) database. I need to pull data from MSSQL into Oracle ...
    Sweetser, JoeSweetser, Joe
    Oct 23, 2007 at 4:00 pm
    Oct 31, 2007 at 5:31 pm
  • Hi Experts, Due to cost implications of RAID controllers we have thought of implementing striping at Oracle level using multiple data files per tablespace and spreading them across various disks. Our ...
    DBA DeepakDBA Deepak
    Oct 27, 2007 at 9:25 pm
    Oct 29, 2007 at 8:42 pm
  • I'm hoping that I can get a few of you to give feedback / input on tools or perhaps even methods for graphing statistics. Currently I've got a variety of OS tools gathering OS stats on 15 or so Linux ...
    Herring Dave - dherriHerring Dave - dherri
    Oct 25, 2007 at 2:16 am
    Oct 26, 2007 at 7:24 am
  • Hi all, DataGuard conf. Oracle 10.2.0.2 on Linux - primary and physical standby with real-time-apply. On primary side I get the following error in fal trace file: "FAL Redo Shipping Client Did Not ...
    Goran bogdanovicGoran bogdanovic
    Oct 30, 2007 at 12:32 pm
    Oct 30, 2007 at 4:58 pm
  • Hi Experts, Have a problem related to parallel query execution. I have a setup of Oracle 10g (10.2.0.3) on solaris 64 bit and on a 16 core CPU system. When I execute parallel hint in the query the ...
    DBA DeepakDBA Deepak
    Oct 16, 2007 at 6:49 am
    Oct 28, 2007 at 11:08 pm
  • Hi, everyone, After our database changed into RAC enviroment, the batch job is very slow. I am wondering whether RAC is not good for batch job. As batch job only use one session and only connect to ...
    Qihua wuQihua wu
    Oct 18, 2007 at 10:03 am
    Oct 18, 2007 at 2:35 pm
  • We have been having alot of problems opening tars. We go to the create tar screen, fill everything out. Hit next and nothing happens. Never had this problem before. Oracle is now telling us that IE ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Oct 3, 2007 at 7:54 pm
    Oct 9, 2007 at 12:26 am
  • In 10GR2 there is an option to commit immediate nowait which allows the commit to return before the redo is persistent in the redo log. This is not the default. The default commit remains as commit ...
    John HallasJohn Hallas
    Oct 3, 2007 at 10:51 am
    Oct 5, 2007 at 3:42 pm
  • Folks, I've got a regular job to delete obsolete pieces from our RMAN catalog, which now is failing with "Memory fault". The system is Tru64 5.1b running Oracle 9.2.0.6 and the RMAN catalog is ...
    Herring Dave - dherriHerring Dave - dherri
    Oct 29, 2007 at 5:33 pm
    Oct 29, 2007 at 9:10 pm
  • All, I came across a rather strange situation a few days ago. One of our developers wrote a simple sql script that inserted some rows into a table. However, he was getting things that were not ...
    Michael.Coll-Barth_at_VerizonWireless.comMichael.Coll-Barth_at_VerizonWireless.com
    Oct 18, 2007 at 7:49 pm
    Oct 23, 2007 at 5:07 pm
  • Hi, all! I have a couple questions. I've started moving archive logs from our main database server to a number of standby servers. I noted that rsync on SuSE/ SLES 9 (default operation / no ...
    Mason Loring BlissMason Loring Bliss
    Oct 17, 2007 at 9:53 pm
    Oct 18, 2007 at 9:02 pm
  • Hello group! I have got a tricky problem at hand - migrate an Oracle 8.1.5 on Solaris 7 database to 10.2.0.x on AIX. The problem here is that I am not allowed much downtime. Having started with ...
    Development_at_the-playground.deDevelopment_at_the-playground.de
    Oct 15, 2007 at 3:56 pm
    Oct 16, 2007 at 11:35 pm
  • Anyone know where I can find more information about this KOLCCST object? And other KO objects for that matter? SQL select * from (select * from v$sgastat where pool = 'streams pool' order by bytes ...
    Charles SchultzCharles Schultz
    Oct 4, 2007 at 1:04 pm
    Oct 8, 2007 at 6:59 pm
  • I am looking for a unix shell script I can use that will generate another script that will set the protections on the files in my oracle home directory. I want all the protections on all the files of ...
    Andrew KerberAndrew Kerber
    Oct 31, 2007 at 1:41 pm
    Oct 31, 2007 at 7:30 pm
  • I've been looking at the Oracle CAST function vs. a TO_NUMBER or TO_CHAR or .... Where both the CAST and TO_ functions result in equivalent answers, is there a preferred choice? -- Rumpi Gravenstein ...
    Rumpi GravensteinRumpi Gravenstein
    Oct 11, 2007 at 1:49 pm
    Oct 13, 2007 at 7:24 pm
  • OK. Now I've got a 10046, level 12 trace file and I'm still having trouble seeing the values of my bind variables. Or so I think. If I'm reading this correctly, there are 8 bind variables in my SQL ...
    Sweetser, JoeSweetser, Joe
    Oct 12, 2007 at 3:54 pm
    Oct 12, 2007 at 5:46 pm
  • Hello, It should work if the directory name is the same and the backup pieces are all there. Please post RMAN output with the error. -- http://www.freelists.org/webpage/oracle-l
    Vitalis JeromeVitalis Jerome
    Oct 1, 2007 at 4:27 pm
    Oct 10, 2007 at 3:36 am
  • We've been trying to tune this query below, but to no avail. The table call_detail below is a very large hourly partitioned table with each partition being about 2-4GB! The other table ...
    A EbadiA Ebadi
    Oct 31, 2007 at 3:43 pm
    Nov 1, 2007 at 3:30 pm
  • G'day, I am encountering a problem with the resource group mapping both in Oracle 10.2.0.1/linux and 10.1.0.4/Solaris (64 bits). I am trying to apply a specific resource consumer group to users who ...
    Tony van LingenTony van Lingen
    Oct 30, 2007 at 6:32 am
    Nov 1, 2007 at 1:47 pm
  • all, I have varchar2 column (transc_id) with the value something like this...and this column was indexed (unique index) 811120980.20070920033742 811120980.20071021183003 UPDATE c_transaction SET ...
    Ujang JaenudinUjang Jaenudin
    Oct 24, 2007 at 6:11 am
    Oct 28, 2007 at 8:07 am
  • Greetings Please see the sql and the out put, have a few questions (Orale 8.1.7.4 and 9i Rel2, will be doing the same for 10g also): Want to send this as a report for DEV team on how we are doing ...
    BNBN
    Oct 26, 2007 at 2:26 pm
    Oct 26, 2007 at 9:08 pm
  • Hi, I have a question about v$sqlarea. Appreciate your help/inputs on this. Background I have a procedure named 'XYZ' and inside this procedure I have select statement. When I execute this procedure ...
    Thotangare, Ajay \(GTI\)Thotangare, Ajay \(GTI\)
    Oct 2, 2007 at 7:35 pm
    Oct 25, 2007 at 6:16 am
  • We have ORACLE 10gr2 on Redhat server. Our application vendor told me don't "online rebuild index". They suggest kick out all users then rebuild index. I have been online rebuild index on several ...
    Dba1 mccDba1 mcc
    Oct 22, 2007 at 7:55 pm
    Oct 23, 2007 at 5:58 am
  • We are having some serious performance problems with the RMAN catalog; Oracle suggested that we upgraded to 10.2.0.3 but I think that has only moved the bottlenecks to different parts of the ...
    Charles SchultzCharles Schultz
    Oct 11, 2007 at 3:10 pm
    Oct 12, 2007 at 3:15 pm
  • Anyone have any experience to share for either tool? We actually own Data Integrator but the person who used it has moved on. Doing a 12i Apps implementation and moving data from: Sql Server, Access, ...
    Kathy duretKathy duret
    Oct 31, 2007 at 1:42 pm
    Oct 31, 2007 at 5:21 pm
  • Hi, I am gettting error ORA-12014 when creating a MV on local table with complete refresh. Not on MV log create. Sounds strange. Primary key cannot be created on this table. I do not need fast ...
    A JoshiA Joshi
    Oct 25, 2007 at 1:54 pm
    Oct 30, 2007 at 8:52 pm
  • All, I have a need to change the dbid for a primary db. Will it sync the new dbid on all the standby databases. Please let me know thanks in advance. -Prasad -- ...
    PrasadPrasad
    Oct 18, 2007 at 8:28 pm
    Oct 27, 2007 at 9:06 pm
  • Folks For a Test Database the Controlfile needs to be CREATED from an existing "backup control file to Trace SQL Script" but a few Datafiles are MISSING. How is the Controlfile to be created in such ...
    VIVEK_SHARMAVIVEK_SHARMA
    Oct 19, 2007 at 1:17 pm
    Oct 24, 2007 at 8:41 pm
  • Greetings I have a requirement to enforce Uniqueuness on a DATE Column for a day only (mm/dd/yy(yy) Should allow users to enter data only once in a day, Can it be enforced through a Unique constraint ...
    BNBN
    Oct 23, 2007 at 2:44 pm
    Oct 23, 2007 at 3:58 pm
  • Hi there! We have a couple (18) of tables "linked" with foreign keys and cascading delete. The largest table contains < 1.000.000 records. When deleting a record from the top level table, this is ...
    LegeDoosLegeDoos
    Oct 19, 2007 at 12:28 pm
    Oct 19, 2007 at 2:17 pm
  • I've googled and metalinked all the key words I can think of and can't find any way to extract the actual high and low values for a column since the values given in dba_tab_col_statistics are in an ...
    Allen, BrandonAllen, Brandon
    Oct 17, 2007 at 12:08 am
    Oct 17, 2007 at 9:10 pm
  • How can you find out if a directory has already been created for data pump and the location of the directory? I looked in init parms and didn't see it and looked in system tables and didn't see any ...
    J. DexJ. Dex
    Oct 17, 2007 at 3:41 pm
    Oct 17, 2007 at 4:31 pm
  • has anyone had any problems with this upgrade hanging on the last section, when it is running the Configuration Assistant and the Oneoff Patch Application? been trying to upgrade our 10.2.0.2 on ...
    Dbvision_at_iinet.net.auDbvision_at_iinet.net.au
    Oct 10, 2007 at 2:35 am
    Oct 13, 2007 at 10:32 am
  • Hi all - I can't seem to find the value of the bind variables in my trace analyzer output and I read here (http://www.oracleutilities.com/Packages/trca.html) that they should be displayed. I created ...
    Sweetser, JoeSweetser, Joe
    Oct 10, 2007 at 8:33 pm
    Oct 10, 2007 at 9:19 pm
  • I know it's like a month before the event, but is anyone here going?? (yeah I know bad question) If so is there a get-together in the planning stage?? Dick Goulet / Capgemini North America P&C / East ...
    Goulet, DickGoulet, Dick
    Oct 5, 2007 at 7:07 pm
    Oct 10, 2007 at 3:33 am
  • This is Oracle 10.2.0.2 on HP-UX B.11.23. I have an rman backup which was done in "nocatalog mode" and am attempting to restore this database on another server. The backup was done three days ago. I ...
    Schauss, PeterSchauss, Peter
    Oct 8, 2007 at 3:21 pm
    Oct 9, 2007 at 1:22 pm
  • all, I have this machine: solaris 10 oracle 10.2.0.3 rac 2 nodes asm a smallfile tablespace with 5 datafiles, each 32GB. but when datafiles rech 20GB, oracle complaint that unable to extent on that ...
    Ujang JaenudinUjang Jaenudin
    Oct 29, 2007 at 3:14 am
    Oct 31, 2007 at 2:41 pm
  • All, hostA - SUSE LINUX Enterprise Server 9 (x86_64) / Intel(R) Xeon(TM) hostB - redhat-5 (x86-64) Dual-Core AMD Opteron(tm) Processor 2222 SE Can I setup a dataguard or I need to make both servers ...
    PrasadPrasad
    Oct 30, 2007 at 12:03 am
    Oct 30, 2007 at 2:14 am
Oct 2007
1234
Group Navigation
period‹ prev | Oct 2007 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions166
posts785
users205
websiteoracle.com

205 users for October 2007

Niall Litchfield: 22 posts Charles Schultz: 19 posts Allen, Brandon: 17 posts Finn Jorgensen: 16 posts Jared Still: 14 posts LS Cheng: 13 posts Mercadante, Thomas F (LABOR): 13 posts Andrew Kerber: 12 posts Qihua wu: 12 posts Roman Podshivalov: 12 posts Alvaro Jose Fernandez: 11 posts Jonathan Lewis: 11 posts Prasad: 11 posts Bobak, Mark: 10 posts DBA Deepak: 10 posts Eagle Fan: 10 posts Greg Rahn: 10 posts Crisler, Jon: 9 posts Don Seiler: 9 posts Herring Dave - dherri: 9 posts
show more
Archives