Search Discussions

131 discussions - 832 posts

  • Hi, I'm working with a customer running a critical web site on a 10gR2 RAC backend DB - they support hundreds of thousands of simultaneous connections at the "quietest" time. They have expressed a ...
    Fahrenfort, Keith (HP Shared Solutions Architect for Oracle)Fahrenfort, Keith (HP Shared Solutions Architect for Oracle)
    Nov 24, 2008 at 4:25 pm
    Feb 6, 2009 at 11:32 am
  • dear all, (sorry cross posting) oracle huge machine :) CREATE TABLE PVC ( ........ CONSTRAINT PVC_PK PRIMARY KEY (AN, SEQ, ES, ETI, ER) ) ORGANIZATION INDEX <=== IOT :( PARTITION BY RANGE ...
    Ujang JaenudinUjang Jaenudin
    Nov 11, 2008 at 10:49 am
    Nov 14, 2008 at 12:47 pm
  • A 3rd party process is passing a date in java.util.date format to my SQLPLUS script and I want to use it in a select statement Can the TO_DATE clause handle a java date? If so, whats the syntax? John ...
    John DunnJohn Dunn
    Nov 4, 2008 at 3:19 pm
    Nov 7, 2008 at 2:53 pm
  • Hi Gurus, I have a requirement. I need to drop all the DB links in the Development database and recreate them as of Production database. How can i do that... Am aware on oracle 9i we can use dynamic ...
    Nagaraj SNagaraj S
    Nov 18, 2008 at 1:27 pm
    Nov 25, 2008 at 3:00 pm
  • List Members: In one of our 3 nodes RAC cluster (currently pre-production/QA), we are having OCRs and VDs in EMC Clariaon disk partitions as follows /dev/raw/raw1(VD) /dev/raw/raw2(VD) ...
    Jayaraj rengarajanJayaraj rengarajan
    Nov 17, 2008 at 7:19 pm
    Nov 20, 2008 at 2:59 pm
  • Nope, not a Star Trek - Voyager reference though it sounds like one, but something that our CEO was asked about by a customer. I have to confess to never having heard the term. Other than FlashBack ...
    Niall LitchfieldNiall Litchfield
    Nov 6, 2008 at 10:15 am
    Nov 7, 2008 at 10:56 pm
  • Hi How can I transfer data from a tablespace in one db to another tablespace in the same db? I have Foreign Key and Sequence objects: Apparently when you use IMP and you already have the structure in ...
    Amir GheibiAmir Gheibi
    Nov 23, 2008 at 5:55 am
    Nov 27, 2008 at 3:19 am
  • Hi We have a 200Gb database and there are 6X50gb luns comprising a diskgroup called dataDG Since my database is growing around 100gb per year i am planning to add two 200Gb disks to the above ...
    Nov 7, 2008 at 5:30 am
    Nov 20, 2008 at 11:27 am
  • Good afternoon, all, I seek your opinions/experiences about tools that can compare two Oracle schemas (or the same schema on two databases) and make a report of the differences. Ideally, it would ...
    Mary Elizabeth McNeelyMary Elizabeth McNeely
    Nov 6, 2008 at 11:55 pm
    Nov 21, 2008 at 10:13 pm
  • Morning, I've upgraded several of my databases to and now I'm having a couple of issues with SQLPLUS. It's probably pathing or environmental, but I can't figure it out. If I want to look at ...
    David BarbourDavid Barbour
    Nov 3, 2008 at 2:53 pm
    Nov 4, 2008 at 5:33 pm
  • Hi everyone, We have a 10g database with over 3.5 TB of data. This supports a SAPR3 application. However, this database has been upgraded twice since it was originally created and the upgrade went ...
    Bort, GuillermoBort, Guillermo
    Nov 28, 2008 at 12:48 pm
    Dec 1, 2008 at 4:33 pm
  • In an effort to chum the water: Why wouldn't DG Logical Standby always be preferable to Physical Standby? According to the 11g DataGuard Concepts guide: Benefits of a Physical Standby Database A ...
    Dominic DelmolinoDominic Delmolino
    Nov 7, 2008 at 8:00 pm
    Nov 10, 2008 at 8:20 pm
  • List, The situation: Oracle database on Solaris 8 (soon to be upgraded to 10g) Rule-based Optimizer A query which has run for years using an indexed access to a very large table (maybe 100 ...
    Dennis WilliamsDennis Williams
    Nov 21, 2008 at 3:05 am
    Nov 27, 2008 at 3:27 am
  • Has anyone on the list seen a discussion of performance cost of running in archivelog mode. overhead of using partitions time calculation to perform statistics time savings of using statistics I ...
    Claudia ZeilerClaudia Zeiler
    Nov 15, 2008 at 9:26 pm
    Nov 18, 2008 at 5:43 pm
  • Hi Listers, Oracle on Solaris 9 In one of my production database session was long running. Session was killed last night. Since then session is marked as KILLED in v$session. This killed ...
    Nov 12, 2008 at 2:24 pm
    Nov 13, 2008 at 2:02 pm
  • Thinking long-term here, it seems 1 OS would allow incredible growth in utilization of existing technology. -- http://www.freelists.org/webpage/oracle-l
    John ThompsonJohn Thompson
    Nov 26, 2008 at 6:23 pm
    Nov 29, 2008 at 1:57 pm
  • For those of you using a SAN, do you disable the write cache? I am concerned that if the UPS loses power thus bringing the SAN down,that writes to the datafiles would be lost. Oracle would think they ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 3, 2008 at 12:24 pm
    Nov 4, 2008 at 7:37 am
  • Hi Oracle 10g2 (data warehouse) I thought I would ask peoples' thoughts on the following. I have setup our database whereby the index tablespace and data tablespace are separate. This is not for ...
    Rob DempseyRob Dempsey
    Nov 18, 2008 at 5:06 pm
    Dec 10, 2008 at 11:52 pm
  • Hi All, I have been asked by someone whether its possible to append to a spool file in sql*plus. i.e. do something like: spool file.a do some sql do some more sql spool off spool file.b do some sql ...
    Pete FinniganPete Finnigan
    Nov 28, 2008 at 8:25 am
    Nov 29, 2008 at 10:10 pm
  • An application called appdetective has flagged one of my systems as having an extproc service which is a security violation in it's estimation. It recommend I either remove the lines from ...
    Douglas CowlesDouglas Cowles
    Nov 14, 2008 at 7:51 am
    Nov 14, 2008 at 5:01 pm
  • Hello List. Does anybody know of a way to refresh multiple MV's in a single transaction? I have a bunch of MV's that users can join as they please in Business Objects (please, hold the jokes) and ...
    Finn JorgensenFinn Jorgensen
    Nov 5, 2008 at 8:50 pm
    Nov 6, 2008 at 4:58 pm
  • Dear All, I would like to simplify the infrastructure by letting the Oracl RAC take care of system failure at the level of the system, do not need to provide extra network cards, and bonding for ...
    Nov 19, 2008 at 1:46 pm
    Nov 19, 2008 at 9:52 pm
  • Hi Oracle-L, I'm trying to simulate a situation (for testing) where any attempt to make tcp connection to a machine hangs. For example, connections using ssh or sqlplus hangs. No error message (as ...
    Chen ShapiraChen Shapira
    Nov 18, 2008 at 6:52 pm
    Nov 18, 2008 at 10:41 pm
  • Greetings, This is a HP-UX 11.23 machine with 30 or so 10g & 9i databases on it. The problem was one volume's space maxing out. Found 4 db's with 2Gb+ MMON trace files with date stamps over ...
    Hand, Michael THand, Michael T
    Nov 14, 2008 at 4:07 pm
    Nov 17, 2008 at 4:21 pm
  • For, HP-UX, the header in the script clearly states you must be a user with SYSBDA privs to run. The doco states that a SYSDBA user can also: Perform STARTUP and SHUTDOWN operations ALTER ...
    Fedock, John \(KAM.RIC\)Fedock, John \(KAM.RIC\)
    Nov 14, 2008 at 4:00 pm
    Nov 15, 2008 at 4:22 am
  • All, I am being told by a support analyst at Oracle re Streams that Oracle must be able to identify uniquely and match corresponding rows at different databases. So each table in a Streams ...
    Niall LitchfieldNiall Litchfield
    Nov 10, 2008 at 2:21 pm
    Nov 10, 2008 at 8:12 pm
  • Hi all Can I use materialized views to copy data from existing database to From windows 32 bit to Linux 64 bit? I have a 3 TB database that I need to move. What happened during the ...
    Yechiel AdarYechiel Adar
    Nov 23, 2008 at 6:47 am
    Dec 1, 2008 at 6:20 am
  • The ADR stuff in 11g does not seem to have an obvious tool to manage the files that are generated. The Frequently Asked Questions, Doc ID: Note:453125.1, doesn't mention how to archive the files. I ...
    Ray StellRay Stell
    Nov 24, 2008 at 11:29 pm
    Nov 25, 2008 at 7:03 pm
  • I appreciate everyone's responses to the extproc problem I had yesterday. I have a further question since many of you seem to know something about sox recommendations. I don't know whether the ...
    Douglas CowlesDouglas Cowles
    Nov 14, 2008 at 9:53 pm
    Nov 16, 2008 at 7:18 pm
  • Good day all, I would appreciate hearing of any experiences of Oracle database migration from HP-UX PA-RISC to HP-UX Itanium, especially relative to Oracle spincount, cursor sharing, HP-UX config, ...
    Hammond, Charles E.Hammond, Charles E.
    Nov 12, 2008 at 8:58 pm
    Nov 13, 2008 at 4:39 pm
  • Hi, As much as Ive been browsing / studying rac... Im looking for a definitive answers about how many "databases" can be on one rac cluster. Say I want to have 4 independent databases on one cluster, ...
    Nov 12, 2008 at 2:12 am
    Nov 13, 2008 at 3:01 am
  • Hi! Thanks for replies but... trace with level 4 is good way for me but developer face went green for too much work of digging dump...;-) Do you have handy example how to get SQL + Binds from audit ...
    Teijo LallukkaTeijo Lallukka
    Nov 6, 2008 at 11:40 am
    Nov 8, 2008 at 6:30 pm
  • Folks What standard best practices may be followed to Tune (Minimize the CPU Consumption) of the below SQL having 2 OR conditions? NOTE - All Tables are relatively small in size i.e. upto 1 GB ...
    Nov 18, 2008 at 8:18 pm
    Nov 25, 2008 at 12:13 am
  • Hi I am planning to use ASM and following diskgroups 1)DataDg 2)redoDg1 3)redoDg2 4)flashDg I have 4 Usable Luns from the SAN that are presented to the host o/s which is rhel 5 I have already created ...
    Nov 21, 2008 at 8:28 am
    Nov 24, 2008 at 6:18 am
  • Hello all I stumbled accross this today: oracle_at_m:~/ [M] sq SQL*Plus: Release - Production on Sat Nov 22 14:55:03 2008 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected ...
    Stefan KnechtStefan Knecht
    Nov 22, 2008 at 1:57 pm
    Nov 23, 2008 at 10:46 pm
  • How do I determine which user actually created a table? I have a table named ???? under schema A. I have numerous schemas/users that have CREATE ANY TABLE system privilege. I have the OBJECT_ID of ...
    Joe SmithJoe Smith
    Nov 20, 2008 at 4:35 pm
    Nov 20, 2008 at 7:46 pm
  • DBA (not my database) says no relink required, it was done on 10G install and patch automatically. 3'rd party bar code App is getting ORA- errors regarding datatype on insert or update (converts ...
    Ethan PostEthan Post
    Nov 19, 2008 at 2:38 pm
    Nov 19, 2008 at 6:37 pm
  • We've recently upgraded to GC on a new server and I cannot figure out how to change the default login timeout from 15 minutes. In our old GC, I had changed this, but cannot find the ...
    Taylor, Chris DavidTaylor, Chris David
    Nov 11, 2008 at 4:53 pm
    Nov 12, 2008 at 2:39 pm
  • Good morning, all! Currently we are building a system in Ethiopia - and as a part of the project need to do a data migration. So. Source - SQL Server 2000 Database with a number of tables with ...
    Michael RosenblumMichael Rosenblum
    Nov 7, 2008 at 3:39 pm
    Nov 12, 2008 at 12:49 pm
  • the purge_audit_template is not well documented. It gives these examples: rem sqlplus user/password_at_tns_name @purge_audit_template.sql MY_WORKSPACE DEPLOYMENT ALL null null rem sqlplus ...
    Ray StellRay Stell
    Nov 9, 2008 at 10:11 pm
    Nov 10, 2008 at 1:18 pm
  • Folks Need to find out if Async IO is setup & working or NOT in our Performance Benchmark Setup. Qs 1 - What HP-UX Command gives the existing filesystemio_options settings for the mounted filesystem ...
    Nov 5, 2008 at 7:35 am
    Nov 7, 2008 at 9:38 am
  • Hey all, I am using the Oracle Press book Oracle Database 10g, OCP Certification all-in-one exam guide to help me study for the exam. I'm just wondering if there is a publish list of mistakes in the ...
    Nov 21, 2008 at 7:35 pm
    Dec 26, 2008 at 6:50 pm
  • Folks Qs 1 Is the following SQL being fired by the Application (& NOT internally by the Oracle Database)? ... Does the message "Module: JDBC Thin Client" prove this? Qs 2 Why is the "% Total" so High ...
    Nov 27, 2008 at 7:08 am
    Nov 27, 2008 at 4:31 pm
  • Good day folks, I�d like to get your thoughts on this issue. (What else would you check?) First the issue, then I�ll list all of the implementation specs. This is a 2 node RAC system that encounters ...
    Darrell LandrumDarrell Landrum
    Nov 21, 2008 at 5:04 am
    Nov 22, 2008 at 5:05 pm
  • Hi, Is anyone know if there any query which can give me who is the primary db ( or tnsnames) . our version is 10.2 . Thanks Amihay Gonen, DBA -- http://www.freelists.org/webpage/oracle-l
    Amihay GonenAmihay Gonen
    Nov 17, 2008 at 2:48 pm
    Nov 17, 2008 at 8:09 pm
  • dear lists, may be the case has been discussed here, but I need to refresh or if someone has extreme solution? I have 8 datafiles need media recovery, backup was taken per day with cold backup ...
    Ujang JaenudinUjang Jaenudin
    Nov 7, 2008 at 8:30 am
    Nov 10, 2008 at 10:44 am
  • Has anybody ever dealt with this error upon starting a db: ORA-00600: internal error code, arguments: [2662], [1922], [3602121928], [1922], [3607967151], [8389130], [], [] This is and I ...
    Joe SmithJoe Smith
    Nov 5, 2008 at 4:27 pm
    Nov 6, 2008 at 8:44 am
  • I was using the classic version and when I signed in today... I got the lovely flash version. I can't seem to find my way out of the rabbit hole to go back to classic. anyone figured this out? ...
    Kathy duretKathy duret
    Nov 4, 2008 at 3:50 pm
    Nov 4, 2008 at 7:53 pm
  • Hi Gurus, I have an clarification on rman restore. My production database was running on server A with DBID 519999874 till October month and we take backup using rman to tape. This month we have ...
    Nagaraj SNagaraj S
    Nov 24, 2008 at 3:14 pm
    Nov 26, 2008 at 7:28 pm
  • hi, I have a problem (as in subject) with the following configuration ora9.2.0.6 on Win2003 (64-bit) on Intel XEON I know this is not certified by Oracle (32-bit ora on 64-bit Win), but so far all ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Nov 26, 2008 at 9:37 am
    Nov 26, 2008 at 12:02 pm
Group Navigation
period‹ prev | Nov 2008 | next ›
Group Overview
grouporacle-l @

208 users for November 2008

Jared Still: 42 posts Niall Litchfield: 29 posts Goulet, Richard: 22 posts Michael Fontana: 21 posts David Ballester: 16 posts Mark W. Farnham: 16 posts Bobak, Mark: 15 posts Stefan Knecht: 15 posts Finn Jorgensen: 14 posts Tim Gorman: 14 posts Yechiel Adar: 14 posts Dan Norris: 13 posts David Barbour: 13 posts Rich Jesse: 13 posts Andrew Kerber: 12 posts Bort, Guillermo: 11 posts Dennis Williams: 11 posts Hrishy: 11 posts Bradd Piontek: 10 posts Martin Berger: 10 posts
show more