Oracle Virtualization and Cloud Consulting
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.

The Oracle XMLDB “anonymous” user account

Trying here to be as correct as possible, as far as I understand it currently.

ANONYMOUS is an Oracle user account specifically designed for HTTP access. It has only one system privilege, that is “create session” and the account is locked by default. If it is unlocked, it only is used for HTTP access via the XDB Protocol Server, aka PL/SQL Gateway, and can access objects in the XDB Repository that are protected by an ACL (Access Control Lists) mentioning this “principal”.

Capturing SQL PLAN Baselines

An introductory :

SQL> select count(*) from dba_sql_plan_baselines ;


SQL> declare
2 ret_value pls_integer;
3 sql_id_in varchar2(30);
4 cursor c1 is
5 select distinct sql_id from v$sql,dba_users
6 where parsing_user_id = user_id
7 and username = 'HEMANT'
8 order by 1;
9 begin
10 open c1 ;
11 loop
12 fetch c1 into sql_id_in;
13 exit when c1%NOTFOUND;
14 dbms_output.put_line('For SQL_ID : ' || sql_id_in);


Swappiness, as the name suggests, affects the swapping in the Linux systems.

Log Buffer #222, A Carnival of the Vanities for DBAs

As the birds have started their yearly migration back to their homes from the warmer areas to the relative less cooler areas in summer, bloggers are also touching base with the technologies which they cherish most and coming back with some master strokes. This new cool edition of Log Buffer, the coolest blog carnival covering hottest topics encompass that home coming. Now Chill with Log Buffer #222!!!

I am not a genius, but I am still 11 year Oracle DBA

Becoming an Oracle DBA is not some mythical thing. Excelling in this field, sustaining in this field, covering milestones is not something out of this world. You really don't have to be an Einstein to become a world class Database Administrator in Oracle technologies.

SPOD for a query

I have two queries that need to be executed by a PL/SQL program. Both of them are quite complex, and both of them have a large section which is identical – because they are different views of the same underlying source data.

One option is to expand out both queries in full, e.g.:

Query 1:


Query 2:

Sun Server Sales on the Rebound

Hooray!  For the first time since 2007, Sun server sales are up.
I’m pleased to hear of this milestone, especially given how difficult it must have been for Oracle to soothe the worried minds of existing Sun owners after the acquisition.  I’m also curious how much of this increase was due to Exadata server sales.

Using Flashback for Automated Testing – a stepping-stone to World Domination

As I’m between jobs at the moment, I’ve had time to sit and reflect on possible future career directions.
With Deb’s help and inspiration (“if that washing isn’t done by the time I get back, there’ll be trouble!”) I think I may have come up with something.
Yep, I’m looking into the possibility of becoming an Evil Genius and Megalomaniac. After all, I’ve already got the alter-ego – I mean, “The Anti-Kyte”, that’s never going to be a super hero name, is it ?

Instrumentation packages

At CIBER we are doing a series of knowledge sessions where several colleagues are doing a one-hour presentation about one or two package of their choice. We have already heard several very interesting presentations about DBMS_HPROF, DBMS_PARALLEL_EXECUTE, UTL_DBWS, UTL_TCP and DBMS_FGA. And this evening a colleague will do a presentation about DBMS_PREPROCESSOR and DBMS_WARNING, and I will do one

view counter