On Sat, 03 Sep 2011 16:49:39 +0000, Mladen Gogala wrote: BTW Sharon, your name is mighty strange for an Indian person. Your address tells me that...

Mladen Gogala

09-03-2011 03:09 PM
Mladen Gogala

The newly upgraded 11.2.0.2 database is behaving strangely. The most expensive SQL, with respect to CPU consumption, is the following: MERGE INTO...

Mladen Gogala

09-02-2011 03:16 PM
Mladen Gogala

I issued "show alert" command and the result showed me that I need to clean things up: 2011-04-23 18:28:38.255000 -04:00 Starting ORACLE instance...

Mladen Gogala

09-02-2011 02:23 PM
Mladen Gogala

Our dataguard is on our test RAC. so far on TEST-RAC, we have two Oracle HOME, buth at 10.2.0.2, one for test database and another one for...

charles

09-02-2011 12:53 PM
ddf

Hi, We have a massive query. But there is a problem. One of the subqueries does not return any rows, therefore the entire query returns no rows. ...

The Magnet

09-02-2011 11:38 AM
The Magnet

Hello, I like to query the SDO_ELEM_INFO of a SDO_GEOMETRY column like that: select distinct p.geometry.sdo_elem_info from pointtable p; Why does...

Juerg

09-02-2011 11:00 AM
Juerg

Hello, I like to query the SDO_ELEM_INFO of a SDO_GEOMETRY column like that: select distinct p.geometry.sdo_elem_info from pointtable p; Why does...

Juerg

09-02-2011 06:27 AM
Juerg

Db version 11.2.0.2 Physical standby : LGWR ASYNC Database on ASM. Application Oracle EBS Redo log files : 5 groups with 2 members each 500M Log...

HansP

08-31-2011 09:47 AM
Mladen Gogala

Capitani IT é uma empresa que atua na área de consultoria de tecnologia da informação desde 1996, seus principais parceiros são: Oracle, SAP e...

Capitani IT Solutions

08-30-2011 04:02 AM
Noons

Hi, The database version is Oracle 11.1 When star transformation enabled is set to true, I see redo log being generated. I believe this is because...

Pratap

08-28-2011 04:44 PM
Mladen Gogala

Hi, I've got problem with merge statement and it has appeared exacly after upgrade to 10.2.0.5 Executiom time before upgrade was about 1-1.5h and...

helter skelter

08-26-2011 01:59 PM
helter skelter

A Capitani IT Solutions, em parceria com a SAP Education, oferece aos nossos alunos o Programa SAP Professional 2011. O programa é destinado a...

Capitani IT Solutions

08-25-2011 09:36 AM
Capitani IT Solutions

oracle 10.2.0.4 enterprise on windows 2003 I am looking at awr reports for most disk intensive sql / the trouble i am finding that pl/sql code...

dba cjb

08-23-2011 04:54 AM
dba cjb

hello, in pl/sql code I have defined a variable: x varchar2(100) := 'do not :1'; is it possible to change the value of x to 'do not eat' with...

geos

08-22-2011 05:12 PM
geos

As of 10g Oracle supports IEEE 754 with 32-bit (5 bytes) BINARY_FLOAT (BFLOAT) and 64-bit (9 bytes) BINARY_DOUBLE (BDOUBLE). These types...

Richard

08-22-2011 12:35 PM
joel garry

I have an Oracle 9i table containing details of "courses taken": CourseCode, StudentID, DateAttended, Grade 0001, 1, 2011/04/18, 60 0001, 1,...

luisdev

08-22-2011 12:05 PM
joel garry

We have a 10g database on Solaris 10 that is having some serious performance issues. The same database restored onto a Windows machine performs...

Alex L

08-22-2011 11:19 AM
Richard

Hi, I'm converting rtf-files to html with ctx_doc.policy_filter (ctx_ddl.create_preference,'xxx','AUTO_FILTER') but it seems to loose all the...

Maikku

08-22-2011 09:45 AM
Maikku

Hi, We have several applications which access the oracle DB and issue queries. Usually these applications are very close to the database (over LAN)....

Ilan Shiber

08-21-2011 12:24 PM
Mladen Gogala

A 5A atua fortemente no mercado Corporativo de TI, com destaque em Terceirização de Profissionais de Tecnologia (Desenvolvimento e Infraestrutura),...

Núbia 5A

08-19-2011 01:32 PM
Núbia 5A

A 5A atua fortemente no mercado Corporativo de TI, com destaque em Terceirização de Profissionais de Tecnologia (Desenvolvimento e Infraestrutura),...

Núbia 5A

08-19-2011 01:20 PM
Núbia 5A

I've been playing around on 10g with External tables and I have been able to load up csv files on them. The problem I seem to run into is that if I...

Jack Schmidt

08-18-2011 06:17 PM
Jack Schmidt

I am trying a silent install of Oracle 11g (11.2.0.1) for a single instancedatabase (software only) on a 64bit Linux server. For some reason, I get...

pradeep

08-18-2011 02:26 PM
pradeep

We have an application with range partitioned tables (Oracle 9.2.0.8). All partitioned tables use the same partitioning key column called YearMonth...

vsevolod afanassiev

08-17-2011 09:49 AM
Robert Klemme

I was reading about ITL mechanism and it was mentioned that Oracle creates ITL entry for *every* updated row in a block. So if one transaction...

vsevolod afanassiev

08-15-2011 12:13 PM
Mladen Gogala

Hi, For some reason, even though we have set retention to 86400 seconds (1 day) of dequeued messages in an Oracle AQ based application we are using,...

z1hou1

08-14-2011 06:04 AM
Paulie

On Aug 12, 11:19*am, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote: ah ha! SELECT a.asset_id FROM asset a WHERE EXISTS (SELECT...

Adrian Harrison

08-12-2011 07:05 AM
Adrian Harrison

(This in Oracle 11g.) I'm trying to run DBMS_UTILITY.ANALYZE_SCHEMA on a database through a link. I'm connected as USER01/PW01 (AT) LINK01 (DOT)...

blindsey

08-11-2011 07:54 PM
vsevolod afanassiev

Materialized view logs can now be purged automatically. It is possible to specify something like 'PURGE REPEAT INTERVAL '5' DAY. Wow! That...

Mladen Gogala

08-11-2011 07:08 PM
Mladen Gogala

On Wed, 10 Aug 2011 13:17:50 -0700, joel garry wrote: Everybody was on vacation, so I took to myself to keep the group alive. It would be a shame...

John Hurley

08-11-2011 05:19 PM
joel garry

First, RDBMS based http and OEM will not work without SCAN address on a RAC db. Second, with the requirement to put SCAN into DNS, DBA can no longer...

Mladen Gogala

08-11-2011 11:44 AM
joel garry

Hi Guys, I need some help in creating DB Links. 1. While I read the documentation for DB link creation, I found that TNSNAMES.ora entry of the...

Arun

08-10-2011 05:06 PM
joel garry

I know that I need advanced compression option if I compress table for all operations. Do I need advanced compression license if I compress just LOB...

Mladen Gogala

08-10-2011 04:37 PM
John Hurley

The first production database in my company is just being upgraded from 9.2.0.8 to 11.2.0.2. It's a RAC, running on RH AS 2.1 (32bit) and OCFS, being...

Mladen Gogala

08-10-2011 04:37 PM
joel garry

Hi, We have an SAP system (ECC6.0) running on Oracle 10.2.0.4 on Solaris 5.9 in, say, servera. We are looking to copy it, and rename its Oracle...

if_investor@yahoo.com

08-08-2011 07:58 PM
Mladen Gogala

Hello, Is anyone successfully using VM VirtualBox 4.1.0 (the last version)? I had nothing but troubles: - shared clipboard not working for a user...

mhoys

08-08-2011 09:48 AM
mhoys

I have two tables A: field1, field2 B: field1, field2 field2 always has a value in table A. table B may or may not have a record with a value of...

sheldonlg

08-07-2011 06:32 PM
Maxim Demenko

The company that I work for uses Apex. There are several simple applications and reports created using Apex. There is also a development instance...

Mladen Gogala

08-06-2011 12:22 AM
Paulie

I'm running Oracle 10g with FGA to OS file. How can I limit the file size to 1gig? The command below does not work with 10g but it works fine with...

indytoatl

08-03-2011 06:46 PM
ddf

Hi, We are looking to copy a cold Oracle 10.2.0.4 backup from a Solaris 5.0 Sparc server to a Solaris 5.10 one. We intend to use the default...

if_investor@yahoo.com

08-02-2011 10:58 AM
if_investor@yahoo.com

Hi, I have a table with 3 nested tables in it. I want to be able to return the number of rows retrieved from each nested table in my result...

The Magnet

08-01-2011 04:52 PM
TheBoss

Hi, We would like to copy a cold backup of an Oracle 10.2.0.4 database running on Sun Sparc 5.9 to a Sun Sparc 5.10 server. We intend to use a...

if_investor@yahoo.com

07-29-2011 12:11 PM
if_investor@yahoo.com

Hello Floks: Job Description: Job Description: Looking for Oracle Apps DBA with release 11i, performance tuning, Should be good with Database...

Luke Curtis

07-27-2011 11:50 AM
joel garry

Hi, I have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have...

Syed Hussaini

07-25-2011 12:02 PM
joel garry

Hi , I got to know of an exciting event happening in Bangalore on July 30th. I guess it will add a great value to all the Business...

sha t

07-25-2011 07:43 AM
Mladen Gogala

Sorry having trouble finding it at the moment. Working on a presentation ... not a big fan of AMM and/or ASMM anyway. There is some kind of...

John Hurley

07-23-2011 03:19 PM
Mladen Gogala

Hi , I got to know of an exciting event happening in Bangalore on July 30th. I guess it will add a great value to all the Business...

sha t

07-22-2011 12:27 AM
sha t

We are replicating a few tables from Oracle Database 11gR2 to Oracle 11gR1 using Streams Replication (Downstream Capture). The archived log files...

Sanjay Dharmadhikari

07-20-2011 11:16 AM
Michel Cadot

Hello! It's a webbsite using C# and ado.net to access a oracle database. Below is just the beginning of the sql select statement that is used...

Tony Johansson

07-19-2011 09:01 AM
Charles Hooper

Position: Sr Java Developers/ Tech lead Rate: Get the best rate Start Date: 2 weeks Total 20 openings Location: Iowa Total exp of 9 to 12 Plus...

Vincent Mathew

07-18-2011 02:27 PM
Vincent Mathew