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”.
An introductory :
SQL> select count(*) from dba_sql_plan_baselines ;
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;
10 open c1 ;
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.
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 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.:
FROM ( ), WHERE ;
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.
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 ?
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