view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Explain this

On the subject of cryptic OTN posts, this one has to get an honorary mention as well:

explain this


hi,

write query to find out order detail of oder_date 2 year before (sorry i forget exact question)

No solutions so far.

Make Me One With Everything

Seen on OTN Forums recently (part of a question entitled "HTML not working in PL/SQL block", so I suppose we were warned):

ORA-01775: looping chain of synonyms

Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself.
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.

For example, the following definitions are circular: CREATE SYNONYM s1 for s2;
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
or
CREATE SYNONYM s4 for s4

Check your synonyms with:
select * from all_synonyms where synonym_name = ‘name’ or table_name = ‘name';

Symposium 2011 - My Presentation

I think the best approach here is to focus on the technical details of the mistake first and then follow with any whining, self-justification or philosophy.

Symposium 2011 - Day 3

I woke up at 6:30 but just closed my eyes for a moment and it was 9:15! ;-) That was the first presentation blown away - another tough choice between Margaret Norman discussing Parallel Execution and Karl Arao on AWR (nice write-up by Karl).

RemoteOperationException:ERROR:Wrong Password for User

Problem in Oracle 10g database on Windows 2000/2003 Professional/Enterprise error message  “RemoteOperationException:ERROR:Wrong Password for User

Solutions

1. go to Control Panel -> Administrative Tools.

2. Click on Local Security Policy.

3. Local Policies, User Rights Assignment.

4. Double click, ‘Log on as a batch job‘.

5. Add your local user that you are supplying for the Host Credentials.

 

 

Tsunami in Japan

A massive tsunami triggered by one of the largest earthquakes smashed into Japan, killing hundreds of people. It swept away boats, cars and homes.

My heartfelt condolences to the people who have suffered or lost their near and dear ones in the disaster.

Extend your help to the Tsunami victims here.

Things worth to mention and remember (II) - Parallel Execution Control 2

Continuing from the previous installment of this series I'll cover in this post some of the inevitable classics regarding Parallel Execution Control. So forgive me if you're bored by the repetition of known facts - however I still see these things too often used incorrectly, therefore I decided: This is worth to mention and remember!

- Up to and including version 10.2 PARALLEL (without any parameters) and NOLOGGING are valid keywords only in DDL commands

New York Oracle User Group DBA SIG Webcast

Thank you all those who attended my webcast "Deferred Statistics and SQL Plan Management for Performance in Oracle 11g" for the DBA SIG of New York Oracle User Group. The recording will be available on that website sometime later. In the meantime, here is the zipfile with the slides and the scripts I used for the demo, if you are interested.

Show stuff

There are various “show” commands in SQL*Plus that are convenient short-cuts for simple SQL commands, for example: show parameter show recyclebin show sga show spparameter You may find, though, that the output leaves a little to be desired, for example: show parameter sharing NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _optimizer_extended_cursor_sharing_r string SIMPLE el cursor_sharing string [...]

view counter