Oracle

To use Oracle 10g R2 on Linux which distribution?
Hi all I'll use Oracle 10g R2 on Linux with RAC, from the old system we used oracle 7 on Miracle Linux. With 10g R2 I want to know if Red hat enterprise linux is a better choice ? Thank you. Lau. Lu ... 17 Mar 2010 21:10

LogMiner SESSION_INFO is empty
Hi all, I'm trying to investigate a table drop using LogMiner. I can locate the needed SCN and can see the 'DROP' command in V $LOGMNR_CONTENTS along with some internal stuff in one transaction. But for some reason SESSION_INFO is missing for that transacation! Next transaction already comes with session_info.... 18 Mar 2010 11:39

how to know the internal representation of a column of clob type
Hi group, I was trying to figure out the internal representation of the clob type column to see if it is UTF8 encoded, but couldn't find any functions (like dump function provided for varchar2 type colomn) or packages. Here is the procedure I used, but I am not sure if it gives me the actual internal representat... 16 Mar 2010 16:13

Oracle Auditing
Hi, Previously one of our DBA's must have turned on auditing. We get this error in RMAN: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ... 17 Mar 2010 09:04

Network Configuration Assistant error
Hi spent 12 hours trying to sort this. Any suggestions?? My hostname is WINDOWS-READ Used Oracle Net Config Assistant to create Oracle Internet Directory Add the directory service: Hostname: WINDOWS-READ port: 389 ssl: 636 Get cannot connect to directory: directory bind error(5) connect s... 15 Mar 2010 15:47

get distinct values
> SELECT deptno, 2 substr(REPLACE(REPLACE(xmlagg(xmlelement("x", job) ORDER BY job), '</x>'), '<x>', ' '), 2) job_list 3 FROM emp 4 GROUP BY deptno 5 ORDER BY deptno 6/ DEPTNO JOB_LIST ------ ---------------------------------------------------- 10 CLERK MANAGER PRESIDENT 20 ANALYST AN... 25 Mar 2010 16:09

Oracle 10g on Solaris 10 non-global zones with asynchronous I/O
Hi All, I note that using direct I/O (by setting the forcedirectio while mounting the database file systems) and bypassing the file system cache may improve database performance significantly, but this should be done only for file systems in which database files and redo log files exist. If direct I/O is used an... 11 Mar 2010 12:15

New Procedurs With Version# In Name
So when my developers need to make a change to a procedure, instead of just recompiling the procedure they want to create a new procedure named like sp_procedure2 and then use the new procedure in their application. They want to do this so that they don't mess up any other application that might be calling the sam... 12 Mar 2010 20:38

Multiple selects in one
I'm trying to write a query that will combine multiple rows from the same table into one row. That can be done with each column being a SELECT statement. However, in my case each column has different criteria and I'm running into a problem where if any of the criteria from any of the queries is false, the entir... 12 Mar 2010 17:17

ORA-00470: LGWR process terminated with error
Hi, I am currently running two Oracle 10G instances from a single Solaris M4000 server. Every few days one of the instances crashes with the following error and has to be restarted. ORA-00470: LGWR process terminated with error PMON: terminating instance due to error 470 I have spend weeks running various t... 11 Mar 2010 06:42