connor_mcdonald's replies:

Items(292) /30 Next >> Last >|

How to derive the username that owns the SQL in V$SQLAREA 5 37 (12/2/2007 12:12:48 AM) comp.databases.oracle.server How do you derive the username of the session the created the SQL that appears in V$SQLAREA? In V$SQLAREA, there is a field SQL_ID. Generally, I should look for a view that have SQL_ID, SERIAL# and SID right... htmldeveloper (36)

/etc/init.d/dbora stop hangs 12 36 (1/10/2008 10:39:20 AM) comp.databases.oracle.server Hello, Have 9i on RedHat 3.8 and if I carry out a dbors stop it hangs. [root@carbon init.d]# ./dbora stop SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 10 11:29:34 2008 Copyright (c) 1982, 2002, Oracle... ton_de_winter (102)

BULK Processing Process "Expires" without completing 4 32 (1/21/2008 2:16:10 AM) comp.databases.oracle.server Oracle 10.2.0.3.0 Windows Server 2003 Enterprise Edition I have a process where I have a cursor which returns approximately 36 million rows which I have to check against certain criteria to load into 25 poss... dietzdl (223)

custom aggregate function in oracle 10g 3 47 (3/19/2008 12:12:07 PM) comp.databases.oracle.server Hello I need a aggregate function for concatenate a list of strings. I created a custom aggregate function, here only the body of the aggregate function: MEMBER FUNCTION ODCIAggregateIterate ( self IN OUT S... juerg.schaufelberger1 (9)

Mounting Storage ... NFS? 3 34 (6/8/2008 5:19:11 PM) comp.databases.oracle.server So ... we're getting a new SAN in one of our data centers (a netapp 3040). If you're not familiar with netapps, one of their big things is that you don't have to buy another head unit to expose storage as NFS ... pat.casey (52)

Minimizing downtime for 9i to 10g upgrade 22 39 (9/11/2008 10:07:13 PM) comp.databases.oracle.server I need to upgrade a 9i database to 10g but the business unit cannot tolerate any downtime. I've advised them the cleanest way is to upgrade the db in place which takes about 90 minutes. They are uncomfortable w... chuckh1958_nospam (88)

11g or not to 11g ? 4 43 (10/27/2008 1:32:24 PM) comp.databases.oracle.server Hello, we are currently in a project for setting up a new production environment, based on EMC documentum and as backend oracle. What are pros and cons for using the 11g ? Do you have any experiences, good ... frank.zimmer1 (8)

Oracle 11g Virtual Columns? 16 46 (1/18/2009 10:26:43 PM) comp.databases.oracle.server I have read various articles on virtual columns? I still do not understand their advantages other than they save some disk space, One can put logic of virtual columns in a trigger which will save information in... zigzagdna (346)

popular storage for ORACLE RAC 12 41 (3/16/2009 6:57:45 PM) comp.databases.oracle.server Hi there, I am trying to determine what is the most popular storage solution for Oracle RAC. Specifically I am trying to compare NAS (NetApp, EMC, Sun, etc) versus RedHat cluster file system, versus Veritas, ... novickivan (17)

Copy 100GB MSSQL 9.0 Database to Oracle 10g 13 220 (6/13/2010 3:30:42 PM) comp.databases.oracle.server Hi, I am not sure whether this is the correct group; Perhaps I should choose an MSSQL one. Does anybody know of a way to copy a database of about 100GB in size, on a Win2003 AMD 64-bit platform, from M... if_investor (20)