Re: The Oracle Inconsistencies List -- please add to it!

%100 agree.

Hakan

David Sisk wrote:

> I personally would be very happy if Oracle Corp:
>
> 1) Stop delivering features that don't work yet (the Microsoft syndrom).
> 2) Implement some of the hundreds of thousands of enhancement requests that
> they have received from customers. No one knows what's needed better than
> the people actually using the product.
>
> johnvue_at_gte.net wrote in message <6qr24n$mhm$1_at_news-1.news.gte.net>...
> >Why do your fingers want to type "select name from v$logfile" or
> >"create tabespace data1 default storage (pct_increase 0)" even though
> >they don't work? Because Oracle makes it harder than it has to be.
> >
> >
> >---------------------------------------------
> >
> >V$SGA memory structure names and associated initSID.ora parameters do
> >not match
> > Variable Size 12221104 bytes ---> shared_pool_size
> > Database Buffers 16777216 bytes ---> db_block_buffers
> > Redo Buffers 1048576 bytes ---> log_buffer
> >
> >db_block_buffers initSID.ora parameter is plural
> >log_buffer initSID.ora parameter is singular
> >
> >the majority of DBA_... views are plural -- a few are singular.
> >Example: DBA_TABLESPACES
> >the majority of V$... views are singular -- a few are plural.
> >Example: V$TABLESPACE
> >
> >DBA_OBJECTS is plural, DBA_OBJECT_SIZE is singular
> >
> >Oracle uses the term "tablespace" as the generic description for a
> >storage area
> >but the term is misleading because a "TABLEspace" can hold
> >tables, indexes, rollbacks, and temporary segments.
> >
> >STORAGE clause does not use underscores but DBA_* dictionary views do:
> > PCTFREE PCT_FREE
> > PCTUSED PCT_USED
> > INITRANS INI_TRANS
> > MAXTRANS MAX_TRANS
> > INITIAL INITIAL_EXTENT
> > NEXT NEXT_EXTENT
> > MINEXTENTS MIN_EXTENTS
> > MAXEXTENTS MAX_EXTENTS
> > PCTINCREASE PCT_INCREASE
> > FREELISTS FREELISTS
> > FREELIST GROUPS FREELIST_GROUPS
> >
> >STORAGE() clause is mostly about extent allocation.
> >However, FREELISTS and FREELIST GROUPS are about blocks but are
> >inside the STORAGE() clause unlike PCTFREE and PCTUSED.
> >
> >DEFINE uses = but PL/SQL DECLARE section uses :=
> >
> >V$SQLTEXT table name but SQL_TEXT field name
> >
> >Analyze one object is DBMS_DDL. Analyze multiple objects with
> >DBMS_UTIL.
> > dbms_ddl.analyze_object()
> > dbms_util.analyze_schema()
> >
> >Spelled "RESTRICT" in one command and "RESTRICTED" in another
> > STARTUP RESTRICT
> > ALTER SYSTEM ENABLE RESTRICTED SESSION
> >
> >SVRMGRL and SQLDBA uses "command=@myscript.sql" but SQLPLUS uses
> >"@myscript.sql"
> >
> >formally called "rollback segment" but most statistics call it "undo"
> >
> >User name is not spelled the same way in all the tables:
> > TABLE_NAME COLUMN_NAME
> >
> > ------------------------------ ------------------------------
> >
> > DBA_AUDIT_EXISTS USERNAME
> >
> > DBA_AUDIT_OBJECT USERNAME
> >
> > DBA_AUDIT_SESSION USERNAME
> >
> > DBA_AUDIT_STATEMENT USERNAME
> >
> > DBA_AUDIT_TRAIL USERNAME
> >
> > DBA_DB_LINKS USERNAME
> >
> > DBA_EXP_FILES USER_NAME
> >
> > DBA_PRIV_AUDIT_OPTS USER_NAME
> >
> > DBA_STMT_AUDIT_OPTS USER_NAME
> >
> > DBA_TS_QUOTAS USERNAME
> >
> > DBA_USERS USERNAME
> >
> > V$OPEN_CURSOR USER_NAME
> >
> > V$PROCESS USERNAME
> >
> > V$PWFILE_USERS USERNAME
> >
> > V$SESSION USERNAME
> > AUD$ USERID
> >
> >
> >three different ways of spelling "average" in field names
> > table: V_$ROLLSTAT field: AVESHRINK
> >
> > table: V_$SYSTEM_EVENT field: AVERAGE_WAIT
> >
> > table: DBA_TABLES field: AVG_SPACE
> >
> >
> >optimizer_goal in "alter session set ..."
> >optimizer_mode in initSID.ora
> >
> >In V$STATNAME, CPU is sometimes uppercase, sometimes lowercase
> > STATISTIC# NAME
> > ---------- ------------------------------
> > 8 recursive cpu usage
> > 11 CPU used when call started
> > 12 CPU used by this session
> > 129 parse time cpu
> >
> >most views have all uppercase field values,
> >a few (V$PARAMETER, V$STATNAME) have lowercase field values
> >
> >log_archive_start initSID.ora parameter.
> >"log archive start" command instead of an "alter system set ... "
> >
> >FILE_ID in DBA_DATA_FILES but FILE# in V$DATAFILE
> >FILE_NAME in DBA_DATA_FILES but NAME in V$DATAFILE
> >
> >NAME in V$CONTROLFILE
> >MAME in V$DATAFILE
> >MEMBER in V$LOGFILE
> >
> >One command uses "INCLUDING CONTENTS" while the other uses "CASCADE"
> > DROP TABLESPACE DATA1 INCLUDING CONTENTS;
> > DROP USER JOHNDOE CASCADE;
> >
> >initSID.ora has no underscore but alert_SID.ora has an underscore
Received on Thu Aug 13 1998 - 20:44:22 CDT