Thursday, April 07, 2005

DBAzine.com: the online portal for database issues and solutions

Just reading through jonathan's articles adn found this to be interesting
DBAzine.com: the online portal for database issues and solutions

Bottlenecks (JL Comp)

Another good article on what is abottleneck
Bottlenecks (JL Comp)

Tuesday, April 05, 2005

Debating Skills (JL Comp)

Going over mark rittman's blog i found aother article by jonathan lewis titled can we have a sensible debate.
The debates outlines a couple of thing that are interesting point ot note is the topis iof the thread that jonathan mentions
empirical vs research DBA .
The point in fact that is real world knowledge better or research is the key to sucess.
Hey if someone hadnt proved it to me that i've been wrong i would have still be wrong wouldnt I.
Enjoy
Debating Skills (JL Comp)

� Updateable External Tables

While looking at orasblogsi found this very interesting article about updateable external tables. although i prefer the use of external tables as a good read only medium for my flat file the concept is pretty interesting and could have good implications on some applications.
� Updateable External Tables

10g R2

Bert Scalzo has an interestign post baout 10g r2 and the connect role.
Date: Sat, 2 Apr 2005 19:17:18 -0800
From: "Bert Scalzo"
Subject: FYI - 10g Release 2
Oracle 10g Release 2 is in its third and final beta - and should release
this summer ...
Found my first interesting Oracle 10g Release 2 issue that will effect
lots of people ...
When Oracle 7.0 came out, they created three pre-canned roles (DBA,
RESOURCE, and CONNECT) that were really just short hand notations to
ease people migrating from Oracle 6.0 - but the general recommendation
has always been "NOT" to use these, but rather create your own roles.
Well in Oracle 10g Release 2 they've changed one of these pre-canned
roles - CONNECT. I hate to admit it - but this broke a some of my
scripts. I imagine many other Oracle users will have issues as well.
10g Release 1 and prior - CONNECT had:
GRANT CREATE DATABASE LINK TO CONNECT;
GRANT CREATE SEQUENCE TO CONNECT;
GRANT CREATE SYNONYM TO CONNECT;
GRANT CREATE SESSION TO CONNECT;
GRANT CREATE CLUSTER TO CONNECT;
GRANT ALTER SESSION TO CONNECT;
GRANT CREATE TABLE TO CONNECT;
GRANT CREATE VIEW TO CONNECT;
10g Release 2 beta - CONNECT now only has:
GRANT CREATE SESSION TO CONNECT;
Bert

Google Search