Oracle

Oracle 11g l FOR UPDATE & User Defined Functions locking
Hi, If I have an SELECT query that is ended FOR UPDATE OF; (specifying no specific tables) and I also invoke a User Defined Function (via column select expression, or WHERE predicate, or FGAC) will any and all select statements within that UDF also be instructed to lock the rows that they touch? Regards Richa... 10 Apr 2010 01:34

XE missing pl/sql messages (?)
(Does anyone see these posts? I am not sure our news feed/server is working.) I am using XE on Vista at home. Whenever I get a pl/sql error then I don't see the text of the message, only the number. Can anyone suggest what to do to get the full message? E.g. SQL> exec proc_that_doesnt_exist PLS-00201: Me... 12 Apr 2010 20:20

Oracle 11 R2 SE1
How to disable "Management Pack Access" what we do not need/have no lisence? Is it possible to create more than one instance? (or need we combine databases?) ... 9 Apr 2010 18:58

workload capture on 10.2.0.4
Oracle 10.2.0.4 on HPUX.... I played with DBMS_WORKLOAD_CAPTURE.START_CAPTURE and in one minute captured around 100MB worth of data. Then I created a filter using ADD_FILTER and tried capturing workload information for only one schema. That did not seem to work as only 50KB worth of data been collected and th... 10 Apr 2010 21:12

sqlca.sqlerrd[2] for array insert
I insert array in C++ program and use EXEC SQL FOR :o_rows_to_process. After operation sqlca.sqlcode = 0. Is it possible to have returned value in sqlca.sqlerrd[2] to be less than o_rows_to_process ? I use Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production. ... 8 Apr 2010 17:24

Can OLAP cubes be used, when Application always queries for single
Are OLAP cubes meant only for the cases where the aggregate operations are involved for major set of records? I have a case where I have to maintain the OLAP cubes to give the summary of the Customer transactions, and any point of time, the query will always be meant for a single Customer. Can I use OLAP cubes f... 8 Apr 2010 02:53

Exchange on the Cross
On Tue, 06 Apr 2010 07:13:28 -0700, magicwand wrote: Or, 'cross' is simply the codename for the Oracle 12 release. And the process of implementing it is called "crucifixion". -- http://mgogala.byethost5.com ... 6 Apr 2010 10:46

RMAN not retrying on media manager errors
Hi, I'm using Oracle 10g, RMAN and TDPO (the TSM client for Oracle). I'm trying to do a PITR to a non-production machine, but RMAN is intolerant of any media manager problems that crop up, so things like this ORA-19511: Error received from media manager layer, error text: ANS1017E (RC-50) Session rejec... 7 Apr 2010 15:45

Oracle Database 11g Release 2 for Windows, experience?
Now it is avalable for Windows. Does anybody have any experience how it (11gR2) will work with Forms6i? Or with Microsoft Biztalk? ... 6 Apr 2010 09:39

expdp is painfully slow
I am using Oracle 11.1.0.7.1 on HP UNIX 11.0. I ma using expdp and find it extremely slow. However. Most of the waiting time is during metadata (see below) where it waits for several hours. When it starts exporting the rows, it progresses reasonably fast. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/... 6 Apr 2010 20:57