Search Discussions

214 discussions - 1,169 posts

  • http://news.ft.com/cms/s/7354696c-cd86-11da-afcd-0000779e2340.html -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning For a successful technology, reality must take precedence ...
    Bobak, MarkBobak, Mark
    Apr 17, 2006 at 3:35 pm
    Apr 19, 2006 at 4:36 pm
  • Very non technical question, but I would appreciate people's views on where the DBA function should reside. In our organization we have Infrastructure support and Applications. I personally want to ...
    Sam robertsSam roberts
    Apr 24, 2006 at 10:50 am
    Apr 28, 2006 at 6:04 pm
  • All, We plan to implement 10g RAC on two node cluster with Windows 2003 OS. Is it possible to host multiple (may two) DB's on 10g RAC? Also, does 10g RAC support mixed operating systems (one node as ...
    Bob RobertBob Robert
    Apr 4, 2006 at 1:26 pm
    Apr 13, 2006 at 7:39 pm
  • Hi List, I have couple of thousand of users all accessing the same, very small lookup table. This is hot block in database cache. How can I avoid this ? Multiple table copies ? How to do this - all ...
    Ranko MosicRanko Mosic
    Apr 19, 2006 at 8:47 pm
    May 2, 2006 at 6:12 pm
  • Hi All: Could you tell me what I'm doing wrong? I need pass different schema owner in SQL, also in some tables there are multiple records will be returned. DECLARE m_dated DATE; m_count NUMBER(10) ...
    Apr 6, 2006 at 3:52 pm
    Apr 7, 2006 at 10:40 pm
  • Well, is that subject a loaded question, or what? Background: I have never used OEM. Well, I have actually, but only long enough to try it and discard it because I didn't like it too much. I've been ...
    Jared StillJared Still
    Apr 5, 2006 at 5:43 pm
    Apr 7, 2006 at 8:50 pm
  • Hi, Please let me know how to identify that a session is executing a Create Table As Select from v$ tables Thanks Joseph Amalraj For errors in "da vinci code" http://www.davincierrors.net/ -- ...
    Joseph AmalrajJoseph Amalraj
    Apr 25, 2006 at 4:07 pm
    Apr 29, 2006 at 1:00 am
  • Got a query from my developers, they are trying to use the "update xxx set row " syntax to modify a row using a record. How would I verify that pk index will not get updated if only non indexed ...
    Apr 26, 2006 at 7:42 pm
    Apr 29, 2006 at 8:56 pm
  • Without creating pfile from spfile how can we edit spfile ? thx Express yourself instantly with MSN Messenger! Download today - it's FREE! ...
    Dean PaulDean Paul
    Apr 26, 2006 at 6:00 pm
    Apr 27, 2006 at 7:00 pm
  • -- http://www.freelists.org/webpage/oracle-l
    Schultz, CharlesSchultz, Charles
    Apr 20, 2006 at 1:14 pm
    Apr 21, 2006 at 2:09 pm
  • Some metalinkisms: http://www.red-database-security.com/wp/oracle_metalink_hacking_us.pdf -- http://www.freelists.org/webpage/oracle-l
    Ray StellRay Stell
    Apr 11, 2006 at 12:49 pm
    Apr 16, 2006 at 6:04 pm
  • Hi we have a table that looks like this: CREATE table t ( n1 NUMBER NOT NULL, n2 NUMBER NOT NULL, n3 NUMBER NOT NULL, n4 NUMBER NOT NULL, ts1 TIMESTAMP NOT NULL, ts2 TIMESTAMP NOT NULL, n5 ...
    johan Erikssonjohan Eriksson
    Apr 21, 2006 at 2:58 pm
    Apr 24, 2006 at 8:10 pm
  • Hello, I have a 10 minute statspack report from a busy time period, and have seen that buffer busy waits were the highest wait events. Would I be correct to then look at the Latch Miss Source at the ...
    Stephen AndersonStephen Anderson
    Apr 24, 2006 at 1:39 pm
    Apr 27, 2006 at 7:46 pm
  • $Log: Blah I am actually looking for a line which has Dollar Log Colon ...any characters...dollar...any characters...but this still returns the line, even thought it is missing the last dollar. I am ...
    Ethan PostEthan Post
    Apr 12, 2006 at 7:56 pm
    Apr 18, 2006 at 9:27 pm
  • Hello Members, has anybody out there tried to setup, only for testing and educational purposes, to setup a 10gR2 RAC on a single SLES9 node ? If so, could you please point me to a how-to ? Thanks in ...
    Markus KuehnMarkus Kuehn
    Apr 5, 2006 at 8:34 am
    Apr 5, 2006 at 9:06 pm
  • Oracle claims the create pfile from spfile command results in an ascii file, which technically is correct, but it's got special ascii characters so notepad or the like isn't suitable to edit it. I'll ...
    Michael RayMichael Ray
    Apr 5, 2006 at 8:41 pm
    May 6, 2006 at 3:12 am
  • Hi All, My sysadmin's been trying to get my opinion on the Yosemite backup agent for Oracle: http://www.yosemitetech.com/products/standard/applications/oracle.htm I can't find much on the site to ...
    Charlotte HammondCharlotte Hammond
    Apr 26, 2006 at 12:51 pm
    May 5, 2006 at 10:30 pm
  • Hi all, I am currently on a RAC database with NOARCHIVELOG option. I want to make the database to ARCHIVELOG mode. Please instruct me as to how to proceed. Any advice is welcome. Thanks in advance ...
    Vikram singhVikram singh
    Apr 25, 2006 at 7:49 pm
    Apr 26, 2006 at 11:07 pm
  • I'm doing some backup/recovery tests on a not-operative database, following the scenarios in: https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=94114.1 I'm ...
    Alessandro VercelliAlessandro Vercelli
    Apr 19, 2006 at 11:03 am
    Apr 26, 2006 at 12:42 pm
  • All, There is a unix command to show who has what files open on a mount point - anybody remember what it is? We dropped a tablespace along with the data files, but the space was not released. I'm ...
    Mercadante, Thomas F \(LABOR\)Mercadante, Thomas F \(LABOR\)
    Apr 20, 2006 at 6:42 pm
    Apr 21, 2006 at 12:13 pm
  • Basically I am looking to isolate just the (distinct) domain name from fully qualified domain names that you'd normally see in web-surfing. I am working on couple of techniques, but it gets ...
    Apr 10, 2006 at 4:51 pm
    Apr 11, 2006 at 7:17 am
  • 12


    Hi I was wondering what would happen if I install Oracle rdbms 10.2 in a server with a 10.1 running? What will happen with ocssd? TIA LSC -- http://www.freelists.org/webpage/oracle-l
    LiShan ChengLiShan Cheng
    Apr 10, 2006 at 4:19 pm
    May 19, 2006 at 10:27 pm
  • Can anyone think of a way to generate a list of years from say 1995 to the current year in straight sql? chris -- http://www.freelists.org/webpage/oracle-l
    Chris StephensChris Stephens
    Apr 20, 2006 at 8:40 pm
    May 5, 2006 at 5:04 pm
  • Hi all, Does anyone use the module Oracle Quoting ? Do you have any reference regd this module, like : integration with another modules, how to setup the module, documentation, process flow, links ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Apr 30, 2006 at 9:24 am
    May 1, 2006 at 6:42 pm
  • Hello all, me again - Hopefully you all had a better weekend then I did - I worked about 20 hours recovering a crashed production database due to running out of disk space. Anyway, my question is ...
    Allen, BrandonAllen, Brandon
    Apr 17, 2006 at 4:20 pm
    Apr 19, 2006 at 9:04 pm
  • Hey all, I'm looking at http://www.oracle.com/database/product_editions.html to get the differences between the Oracle editions (okay, I'm not really looking at XE). There's a "Oracle Database 10g ...
    Jesse, RichJesse, Rich
    Apr 7, 2006 at 7:59 pm
    Apr 11, 2006 at 7:40 am
  • Hey all, While debugging an analytical function issue using, I run this idiotic query: SELECT TRUNC(SYSDATE) - TRUNC(SYSDATE) - TRUNC(SYSDATE) FROM DUAL; And it errors out with: ORA-00932 ...
    Jesse, RichJesse, Rich
    Apr 13, 2006 at 1:51 pm
    Apr 13, 2006 at 5:22 pm
  • hi, all, We have a 3rd party application running on our database, and the vendor asked us to run daily analyze, for those tables with dba_segments/dba_tables shows 5%+ difference for blocks. And we ...
    Zhu chaoZhu chao
    Apr 2, 2006 at 2:56 am
    Apr 6, 2006 at 1:56 pm
  • A little piece of email today told me the following: "... a full 60 percent of DBAs do not know how to implement database security measures, according to Forrester Research". Does that figure seem to ...
    Paul DrakePaul Drake
    Apr 4, 2006 at 8:34 pm
    Apr 5, 2006 at 9:14 pm
  • Hello all: Â Â We have Oracle database ( single Note RAC ). There were some heavy batch jobs running which cuased the db hang ( only sys connection was working ). Â Â We tried to bring down ...
    Ahmed UllahAhmed Ullah
    Apr 27, 2006 at 10:35 pm
    May 1, 2006 at 7:42 pm
  • How does one translate the p2 and p3 values for wait event "cursor: pin S wait on X"? The documentation simply says: A session waits for this event when it is requesting a shared mutex pin and ...
    Schultz, CharlesSchultz, Charles
    Apr 28, 2006 at 4:28 pm
    Apr 29, 2006 at 11:10 am
  • -----Message d'origine----- De : Bertrand Guillaumin Envoyé : jeudi 6 avril 2006 15:29 À : 'Oracle-L Freelists' Objet : Logon Trigger on schema Hi! I'm trying to use a logon trigger on a schema so ...
    Apr 11, 2006 at 8:52 am
    Apr 28, 2006 at 4:28 pm
  • Hi, All, I wonder how you all do when you need oracle software, do you order CD media from oracle or do you just go to otn.oracle.com to download it? I always just go and download it when I need it ...
    Li LiLi Li
    Apr 18, 2006 at 7:44 pm
    Apr 18, 2006 at 9:38 pm
  • I need to extract data from a remote database to local database. One of the column to extract is blob. Each single extract will fetch approx. 1 GB of data. Connectivity between the database is 10 ...
    Sandeep DubeySandeep Dubey
    Apr 12, 2006 at 6:33 pm
    Apr 17, 2006 at 4:10 pm
  • Something to cheer you all up on a Monday http://weblogs.sqlteam.com/jeffs/archive/0001/01/01/5248.aspx I had a hearty laugh at the TRUNCATE line. John -- http://www.freelists.org/webpage/oracle-l
    John KanagarajJohn Kanagaraj
    Apr 3, 2006 at 10:36 pm
    Apr 13, 2006 at 2:43 am
    Hameed, AmirHameed, Amir
    Apr 3, 2006 at 9:21 pm
    Apr 4, 2006 at 3:44 am
  • there have two place I can download ORACLE software: otn.oracle.com edelivery.oracle.com What is difference from those two site? Our consult say download software have lots functions missing. He ...
    Dba1 mccDba1 mcc
    Apr 28, 2006 at 5:42 pm
    May 2, 2006 at 2:13 am
  • Folks, I am trying to understand the impact of creating a function-based index on an order entry table which is heavily used by DML statements. Can anyone tell me the downside of creating such an ...
    Hameed, AmirHameed, Amir
    Apr 5, 2006 at 6:48 pm
    Apr 17, 2006 at 12:18 pm
  • I posted this a while back with a lot more text and I don't think it ever posted, perhaps I was hitting some size limit. So here is the really short version. It occurred to me that a good way to find ...
    Ethan PostEthan Post
    Apr 19, 2006 at 1:59 pm
    Apr 20, 2006 at 1:39 pm
  • Hi, I'm trying to run this Perl script against a remote Oracle 10g R1 database. I'm using WinXP and i already have the oracle client software installed and working. My Perl version is 5.8.7 DBI ...
    Apr 4, 2006 at 3:02 pm
    Apr 4, 2006 at 10:51 pm
  • Hi listers, Perhaps, someone can explain this behavior. I move partition of a table using: alter table . move partition tablespace parallel 8 nologging; Oracle spawn 8 parallel processes that are ...
    Alex GorbachevAlex Gorbachev
    Apr 29, 2006 at 1:01 pm
    May 1, 2006 at 3:41 pm
  • Hi List, Does anybody know where to download this ASM library ? I don't see version for above mentioned kernel on http://www.oracle.com/technology/software/tech/linux/asmlib/rhel3.html. -- Regards, ...
    Ranko MosicRanko Mosic
    Apr 29, 2006 at 10:09 pm
    Apr 30, 2006 at 1:38 pm
  • Greetings 2 CPU HP-UX 11.11 Oracle STANDBY Database Applying 450 Archive Logs of 20 MB each took 2.30 hrs, Is there a way to tune this to cut this time? -- Regards & Thanks BN -- ...
    Apr 27, 2006 at 8:32 pm
    Apr 29, 2006 at 7:51 am
  • Greetings Oralce Version ITs Friday evening. Want to confirm that a, my understanding is Cold (Any Backup except exp) Backup Taken on HP-UX 64 bit cannot be restored on a SUN Box to setup a ...
    Apr 21, 2006 at 9:55 pm
    Apr 25, 2006 at 2:33 pm
  • Considering Migrating a BIG Production Server from Oracle 8i to 9i Is 9.2.0."7" (64 Bit) the most advisable/stable patch on Solaris 9? Thanks Folks CAUTION - Disclaimer ***************** This e-mail ...
    Apr 24, 2006 at 7:53 am
    Apr 24, 2006 at 9:42 pm
  • Hi List, I need to switch between two statspack schemas every 3 months ( tables become too big so we want to switch back and forth with snapshot truncate and dbms_job modification during the switch ...
    Ranko MosicRanko Mosic
    Apr 21, 2006 at 4:52 pm
    Apr 21, 2006 at 10:17 pm
  • We have ORACLE database 9iR2 run on UNIX servers. Sometime when we doing database maintenance, we don't want users connect to DB. for SQL/net connection I can STOP listener. For JDBC client ...
    Dba1 mccDba1 mcc
    Apr 12, 2006 at 12:50 pm
    Apr 13, 2006 at 4:34 pm
  • I personally believe Postgres will cover more of your requirements. Requirement "e" will mean getting a license for enterprise postgres, and I strongly recommend paying for support as well. Good ...
    Michael FontanaMichael Fontana
    Apr 10, 2006 at 7:32 pm
    Apr 12, 2006 at 3:10 pm
  • Hi Database Gurus, I've a question regarding Data Guard. If a database switches role from standby to primary can I still connect to the new primary database without setting a network alias or ...
    Apr 7, 2006 at 12:16 pm
    Apr 7, 2006 at 10:19 pm
  • Hello list, When I grant execute on a function to a user, the session is wating on 'library cache pin' wait event. I have waited for 20 min. still session waits on the same wait event. Any ideas? ...
    The Human FlyThe Human Fly
    Apr 6, 2006 at 1:44 pm
    Apr 7, 2006 at 1:39 pm
Group Navigation
period‹ prev | Apr 2006 | next ›
Group Overview
grouporacle-l @

249 users for April 2006

Jared Still: 34 posts Alex Gorbachev: 32 posts Mladen Gogala: 32 posts LS Cheng: 28 posts Kevin Closson: 25 posts Mark J. Bobak: 24 posts Rjamya: 24 posts David Sharples: 23 posts Oracle-l-bounce_at_freelists.org: 20 posts Baumgartel, Paul: 19 posts Dennis Williams: 18 posts Joseph Amalraj: 17 posts Schultz, Charles: 17 posts Allen, Brandon: 16 posts Niall Litchfield: 16 posts Ranko Mosic: 16 posts Ramick: 14 posts Norman Dunbar: 13 posts Ray Stell: 13 posts Christian Antognini: 12 posts
show more