Re:

[Mladen Gogala]

That getenrated redo size for this statement was 828 bytes. If an 
instance ecovery
is needed, redo log files will be read and your transaction will be 
applied. If
your transaction was committed, it will not be rolled back. Redo log 
files are
only read during recovery. There are some ramifications about that and 
I believe
that Mr. Rama Velpuri has written a few lines about those. 



On 2002.07.31 01:58 oraora  oraora wrote:
> Guys , my insert statement is below . explain shows 828 for redo
> size . does it mean the no of blocks ? what should be the ideal
> value for the same ? what does the value for redo size = 828
> indicate ?
> 
> kindly explain me.
> 
> insert into MSG_History
> 
>(Tel,MemNo,FromMemNo,Sex,PDate,Content,S_Name,S_Age,S_Hight,S_Style,S_BloodType,S_LooksLike,Name,Age,Hight,Style,BloodType,LooksLike,REFERER,MSGID,DelFLG,RefCNT,EntPC,Opt1)
> 
> values
> 
>(:RTEL,:RMEMNO,:SID,:op_sex,SYSDATE,:MESSAGE,:NAME,:AGE,:HIGHT,:STYLE,:BLOODTYPE,:LOOKSLIKE,:RNAME,:RAGE,:RHIGHT,:RSTYLE,:RBLOODTYPE,:RLOOKSLIKE,'¿¿¿',GetMSGID.NextVal,0,0,:EntPC,:POSTNO)
> 
> Elapsed: 00:00:00.69
> 
> Execution Plan
> -
> 0  INSERT STATEMENT Optimizer=CHOOSE (Cost=39185
> Card=6800153 B
>ytes=1523234272)
> 
> 10   SEQUENCE OF 'GETMSGID'
> 
> Statistics
> -
>0  recursive calls
>8  db block gets
>1  consistent gets
>1  physical reads
>  828  redo size
>  858  bytes sent via SQL*Net to client
> 1520  bytes received via SQL*Net from client
>3  SQL*Net roundtrips to/from client
>2  sorts (memory)
>0  sorts (disk)
>1  rows processed
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: oraora  oraora
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

explain plan - redo size ???

[oraora oraora]

Guys , my insert statement is below . explain shows 828 for redo 
size . does it mean the no of blocks ? what should be the ideal 
value for the same ? what does the value for redo size = 828 
indicate ?

kindly explain me.

insert into MSG_History 
(Tel,MemNo,FromMemNo,Sex,PDate,Content,S_Name,S_Age,S_Hight,S_Style,S_BloodType,S_LooksLike,Name,Age,Hight,Style,BloodType,LooksLike,REFERER,MSGID,DelFLG,RefCNT,EntPC,Opt1)
 
values 
(:RTEL,:RMEMNO,:SID,:op_sex,SYSDATE,:MESSAGE,:NAME,:AGE,:HIGHT,:STYLE,:BLOODTYPE,:LOOKSLIKE,:RNAME,:RAGE,:RHIGHT,:RSTYLE,:RBLOODTYPE,:RLOOKSLIKE,'¿¿¿',GetMSGID.NextVal,0,0,:EntPC,:POSTNO)

Elapsed: 00:00:00.69

Execution Plan
-
0  INSERT STATEMENT Optimizer=CHOOSE (Cost=39185 
Card=6800153 B
   ytes=1523234272)

10   SEQUENCE OF 'GETMSGID'

Statistics
-
   0  recursive calls
   8  db block gets
   1  consistent gets
   1  physical reads
 828  redo size
 858  bytes sent via SQL*Net to client
1520  bytes received via SQL*Net from client
   3  SQL*Net roundtrips to/from client
   2  sorts (memory)
   0  sorts (disk)
   1  rows processed

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: oraora  oraora
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

[no subject]

[oraora oraora]

Guys , my insert statement is below . explain shows 828 for redo 
size . does it mean the no of blocks ? what should be the ideal 
value for the same ? what does the value for redo size = 828 
indicate ?

kindly explain me.

insert into MSG_History 
(Tel,MemNo,FromMemNo,Sex,PDate,Content,S_Name,S_Age,S_Hight,S_Style,S_BloodType,S_LooksLike,Name,Age,Hight,Style,BloodType,LooksLike,REFERER,MSGID,DelFLG,RefCNT,EntPC,Opt1)
 
values 
(:RTEL,:RMEMNO,:SID,:op_sex,SYSDATE,:MESSAGE,:NAME,:AGE,:HIGHT,:STYLE,:BLOODTYPE,:LOOKSLIKE,:RNAME,:RAGE,:RHIGHT,:RSTYLE,:RBLOODTYPE,:RLOOKSLIKE,'¿¿¿',GetMSGID.NextVal,0,0,:EntPC,:POSTNO)

Elapsed: 00:00:00.69

Execution Plan
-
0  INSERT STATEMENT Optimizer=CHOOSE (Cost=39185 
Card=6800153 B
   ytes=1523234272)

10   SEQUENCE OF 'GETMSGID'

Statistics
-
   0  recursive calls
   8  db block gets
   1  consistent gets
   1  physical reads
 828  redo size
 858  bytes sent via SQL*Net to client
1520  bytes received via SQL*Net from client
   3  SQL*Net roundtrips to/from client
   2  sorts (memory)
   0  sorts (disk)
   1  rows processed

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: oraora  oraora
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How to insert Special Characters ?

[guess who]

I want to insert the following characters ,

1.)   '

2.)   "

3.)   &

for example i want to insert the following line as it looks...

   where part_no='1234' and name='guest'

how to do ?

can  anyone help ...

Regards,
Prakash.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: guess who
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Table Naming Conventions

[Mladen Gogala]

That's a classic one, taught in various courses ever since version 5.
The most famous example was

select...
where date_column='12-31-99'

where date_column would be implicitly converted to varchar2. A little 
'explain
plan' effort  and all the confusion is easily avoided.




On 2002.07.31 00:08 Cary Millsap wrote:
> Rachel, one of the SQL statements in our Clinic that people find the
> hardest to optimize is one that has a thing that looks like "id_number
> =
> 1" in the where clause. "id_number" is the table's primary key,
> yet
> the query spends 20 seconds executing a full-table scan. Any guesses?
> 
> It's because "id_number" was actually defined as a varchar2 column.
> Oracle's implicit type coercion converts the predicate into
> "to_number(id_number) = 1". Presto: the PK index is useless.
> 
> This and dozens of other unnecessarily pathological problems await
> people who try to embed too much information into their names.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - NCOAUG Training Day, Aug 16 Chicago
> - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
> 
> 
> 
> -Original Message-
> Carmichael
> Sent: Tuesday, July 30, 2002 8:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> I can see your point, In the data warehouse we are building here, the
> modeler is planning on prefixing tables with the type of table (D_ for
> dimension tables, F_ for fact, etc)
> 
> Hm, you mean we have to go back and revisit the naming standards that
> they developed? Can I please suffix the column names with an indicator
> of the datatype? :)
> 
> The biggest problem is that most management wants "naming
> standards"...
> 
> 
> Rachel
> 
> 
> --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > I just think it's a waste. You can tell by context what kind of
> thing
> > a
> > thing is. For example, consider: "select a.flarg from bloing a where
> > a.croopoo > 7". This can be understood by syntactical context (even
> > with
> > the nonsense names), without having to rename "bloing" to
> > "bloing_table".
> >
> > Most of the embedding of type names into object names that I've seen
> > has
> > been implemented by users who were inexperienced at the time they
> > created the standard. They were worried that without embedding the
> > type
> > name into the object name, they might forget what kind of object it
> > was.
> > ...Most such naming conventions become onerous over time, long after
> > you
> > find out that you can find the type of something in the data
> > dictionary,
> > but after it's too late to save the thousands of extra characters of
> > typing that'll waste people's lifespans over time.
> >
> > In my old OFA paper, I made a joke about how we don't embed type
> > names
> > into object names in daily life, with just a few exceptions (Billy
> > the
> > Kid, Winnie the Pooh, Atilla the Hun, and the younger family members
> > of
> > the old Walton Family TV show are a few examples). If you have both
> a
> > dog and a child named "Rex," though, it's probably a good idea to
> > expect
> > them both to come when you call. With SQL, though, I can't think of
> a
> > case in which it's not easy to tell by syntactic context what kind
> of
> > thing you're talking about...
> >
> >
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> >
> > Upcoming events:
> > - NCOAUG Training Day, Aug 16 Chicago
> > - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> > - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> > Dallas
> >
> >
> >
> > -Original Message-
> > Carmichael
> > Sent: Tuesday, July 30, 2002 4:49 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Cary,
> >
> > you said
> > "* Don't embed the object type in the object's name. I used to see
> > this
> > all the time with tablespaces called XYZ_TS, indexes called
> > IND_THING,
> > and so on."
> >
> > what's your logic behind that?
> >
> > Rachel
> >
> >
> >
> > --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > > Here's a start. Not a checklist by any means, just kind of a micro
> > > pet
> > > peeves list.
> > >
> > > * Decide today whether table names will be singular or plural. Do
> > you
> > > want a THING (singular) table? Or a THINGS (plural) table?
> > >
> > > * Don't use case-sensitive names. E.g., use THING (without quotes)
> > in
> > > your CREATE (DDL) statement, which can be spelled "THING",
> "thing",
> > > "Thing", or even "tHiNG" in your developers' SQL. But don't make
> > > developers type stuff like this...
> > >
> > > select "Name" from "Thing" where "Id" = y  /* won't work
> > without
> > > ""
> > > */
> > >
> > > * Don't embed the object type in the object's name. I used to see
> > > this
> > > all the time with tablespaces called XYZ_TS, indexes called
> > > IND_THING,
> > > and so on.
> > >
> > > * Decide today whether you want to abbreviate or not. If 

RE: Table Naming Conventions

[Cary Millsap]

Rachel, one of the SQL statements in our Clinic that people find the
hardest to optimize is one that has a thing that looks like "id_number =
1" in the where clause. "id_number" is the table's primary key, yet
the query spends 20 seconds executing a full-table scan. Any guesses?

It's because "id_number" was actually defined as a varchar2 column.
Oracle's implicit type coercion converts the predicate into
"to_number(id_number) = 1". Presto: the PK index is useless.

This and dozens of other unnecessarily pathological problems await
people who try to embed too much information into their names. 


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- NCOAUG Training Day, Aug 16 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas



-Original Message-
Carmichael
Sent: Tuesday, July 30, 2002 8:09 PM
To: Multiple recipients of list ORACLE-L

I can see your point, In the data warehouse we are building here, the
modeler is planning on prefixing tables with the type of table (D_ for
dimension tables, F_ for fact, etc)

Hm, you mean we have to go back and revisit the naming standards that
they developed? Can I please suffix the column names with an indicator
of the datatype? :)

The biggest problem is that most management wants "naming standards"...


Rachel


--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> I just think it's a waste. You can tell by context what kind of thing
> a
> thing is. For example, consider: "select a.flarg from bloing a where
> a.croopoo > 7". This can be understood by syntactical context (even
> with
> the nonsense names), without having to rename "bloing" to
> "bloing_table".
> 
> Most of the embedding of type names into object names that I've seen
> has
> been implemented by users who were inexperienced at the time they
> created the standard. They were worried that without embedding the
> type
> name into the object name, they might forget what kind of object it
> was.
> ...Most such naming conventions become onerous over time, long after
> you
> find out that you can find the type of something in the data
> dictionary,
> but after it's too late to save the thousands of extra characters of
> typing that'll waste people's lifespans over time.
> 
> In my old OFA paper, I made a joke about how we don't embed type
> names
> into object names in daily life, with just a few exceptions (Billy
> the
> Kid, Winnie the Pooh, Atilla the Hun, and the younger family members
> of
> the old Walton Family TV show are a few examples). If you have both a
> dog and a child named "Rex," though, it's probably a good idea to
> expect
> them both to come when you call. With SQL, though, I can't think of a
> case in which it's not easy to tell by syntactic context what kind of
> thing you're talking about...
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - NCOAUG Training Day, Aug 16 Chicago
> - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> Dallas
> 
> 
> 
> -Original Message-
> Carmichael
> Sent: Tuesday, July 30, 2002 4:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> Cary,
> 
> you said 
> "* Don't embed the object type in the object's name. I used to see
> this
> all the time with tablespaces called XYZ_TS, indexes called
> IND_THING,
> and so on."
> 
> what's your logic behind that? 
> 
> Rachel
> 
> 
> 
> --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > Here's a start. Not a checklist by any means, just kind of a micro
> > pet
> > peeves list.
> > 
> > * Decide today whether table names will be singular or plural. Do
> you
> > want a THING (singular) table? Or a THINGS (plural) table?
> > 
> > * Don't use case-sensitive names. E.g., use THING (without quotes)
> in
> > your CREATE (DDL) statement, which can be spelled "THING", "thing",
> > "Thing", or even "tHiNG" in your developers' SQL. But don't make
> > developers type stuff like this...
> > 
> > select "Name" from "Thing" where "Id" = y  /* won't work
> without
> > ""
> > */
> > 
> > * Don't embed the object type in the object's name. I used to see
> > this
> > all the time with tablespaces called XYZ_TS, indexes called
> > IND_THING,
> > and so on.
> > 
> > * Decide today whether you want to abbreviate or not. If you do,
> then
> > construct a formal, standard, consistent list of accepted
> > abbreviations.
> > Don't name one table CUSTOMER_THING and another CUST_HISTORY.
> > 
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > 
> > Upcoming events:
> > - NCOAUG Training Day, Aug 16 Chicago
> > - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> > - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> > Dallas
> > 
> > 
> > 
> > -Original Message-
> > Chambers
> > Sent: Tuesday, July 30, 2002 3:37 PM
> > To: Multiple recipients of list ORA

RE: ... And another RMAN Q.

[Ross Collado]

Dennis,
Someone did mention that to me but found it hard to believe Oracle does not
have an option to save the backupsets in the box where you initiated RMAN.
Maybe Oracle thought by allowing it, it will saturate the network. Still, I
would have preferred the option to be there.
Rgds,
Ross

> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 30 July 2002 23:23
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ... And another RMAN Q.
> 
> 
> Ross
>No. 
>The fundamental way RMAN works is to create the backupset 
> on the target
> system.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> Sent: Tuesday, July 30, 2002 12:58 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all,
> 
> Env.: 2 Solaris boxes both Oracle 8.1.7.3
> 
> BoxA has the RMAN catalog. BoxB is where the Prod db is.  
> RMAN backups are
> initiated from BoxA to backup db in BoxB.  RMAN backupsets 
> are created in
> BoxB.  Is there a way to get RMAN to create the backupsets in 
> BoxA instead?
> 
> Below is an excerpt of my rman backup script:
> ---
> ---
> ---
> replace script backup_db_full {
>   execute script archive_log_current;
>   execute script alloc_all_disks;
>   execute script set_maxcorrupt;
>   backup
> full
> skip inaccessible
> tag b_db_full
> filesperset 3
> format '/oracle1/oracle/admin/RMAN/backup/df/dfset_%s_%t.%d'
> database;
>   execute script rel_all_disks;
>   execute script archive_log_current;
>   execute script backup_al_all;
> }
> ---
> ---
> 
> Rgds,
> Ross
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ross Collado
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ross Collado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ... And another RMAN Q.

[Ross Collado]

Hi Tom,
My backup starts on BoxA.  It uses the rman binary in BoxA. So I do 'connect
target user/passwd@BoxB'.
Well I too thought that the backupset will be created in BoxA.  Looks like
backupsets gets created wherever the target db is.
rgds,
Ross

> -Original Message-
> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 30 July 2002 22:53
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ... And another RMAN Q.
> 
> 
> Ross,
> 
> when you say "RMAN backups are initiated from BoxA to backup 
> db in BoxB"
> what do you mean?  are they run on BoxA or BoxB?  If they are 
> run on BoxA,
> then the backup files will be created on BoxA.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ross Collado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table Naming Conventions

[Cary Millsap]

I don't like such prefixes because they make it easier to lie or make
mistakes. I've seen people try for hours to figure out why something
doesn't make sense, only to find out that the index whose name has a 'U'
in it actually wasn't created with the "UNIQUE" attribute.

Names falsely cause reliance that cannot be trusted. Making reports on
such things easier to run is, to my mind, a better idea than integrating
too much information into naming standards.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- NCOAUG Training Day, Aug 16 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas



-Original Message-
Sent: Tuesday, July 30, 2002 8:09 PM
To: Multiple recipients of list ORACLE-L

Hmmm.  Seems I have to play devil's advocate on this one.  So, you see
no purpose to index names such as:

P_EMPLOYEE for a Primary key on the employee table
or UM_METER_CODE for a unique index on the meter table meter_code column
or FE_DEPT for a foreign key index on the employee table dept column
or IIE_LOG_DATE for a non-unique index on the import_export table
log_date column?

The first letter doesn't help me figure out that the object is an index,
but it sure helps to show what the index is being used for.

Constraint naming is another area where we use a one character prefix to
identify the constraint type, in part to conform to index naming.

The keeper of standards here (not me) has also imposed prefix
conventions on global temporary tables and on selected classes of tables
such as work tables or external cross reference tables.  It does help
keep the developers in line.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?


-Original Message-
Sent: Tuesday, July 30, 2002 4:58 PM
To: Multiple recipients of list ORACLE-L


You already know it's an index, why would you include that as part of
the 
name?

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 02:29 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: 
Subject:RE: Table Naming Conventions


My supervisor/client wants object types in names - except tables like I_

for indexes.  Why do you say stay away from this?
-Original Message- 
Sent: Tuesday, July 30, 2002 5:10 PM 
To: Multiple recipients of list ORACLE-L 

Here's a start. Not a checklist by any means, just kind of a micro pet 
peeves list. 
* Decide today whether table names will be singular or plural. Do you 
want a THING (singular) table? Or a THINGS (plural) table? 
* Don't use case-sensitive names. E.g., use THING (without quotes) in 
your CREATE (DDL) statement, which can be spelled "THING", "thing", 
"Thing", or even "tHiNG" in your developers' SQL. But don't make 
developers type stuff like this... 
select "Name" from "Thing" where "Id" = y  /* won't work without "" 
*/ 
* Don't embed the object type in the object's name. I used to see this 
all the time with tablespaces called XYZ_TS, indexes called IND_THING, 
and so on. 
* Decide today whether you want to abbreviate or not. If you do, then 
construct a formal, standard, consistent list of accepted abbreviations.

Don't name one table CUSTOMER_THING and another CUST_HISTORY. 

Cary Millsap 
Hotsos Enterprises, Ltd. 
http://www.hotsos.com 
Upcoming events: 
- NCOAUG Training Day, Aug 16 Chicago 
- Miracle Database Forum, Sep 20-22 Middlefart Denmark 
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas 


-Original Message- 
Chambers 
Sent: Tuesday, July 30, 2002 3:37 PM 
To: Multiple recipients of list ORACLE-L 
All... 
Will some of you please provide some insight on your table naming 
conventions?  I'm in the very early planning stages of what will likely 
be a large and complex schema (IT asset inventory).  I have a chance to 
start it correctly.  TIA 
Gary Chambers 
//- 
// Lucent Technologies GIO/Unix 
// 4 Robbins Road, Westford, MA 01886 
// 978-399-0481 / 888-480-6924 (Pager) 
// Nothing fancy and nothing Microsoft 
//- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Gary Chambers 
  INET: [EMAIL PROTECTED] 
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Cary M

RE: ... And another RMAN Q.

[Ross Collado]

Thanks Alex.
Yes that thought occured in my mind but that would be my last option.
I'm still trying to find other ways than remote mounting filesystems.

Rgds,
Ross

> -Original Message-
> From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 31 July 2002 0:03
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ... And another RMAN Q.
> 
> 
> The one way is to mount the directory from one box to another 
> using nfs.
> 
> Alexandre
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 30, 2002 3:23 PM
> 
> 
> > Ross
> >No.
> >The fundamental way RMAN works is to create the 
> backupset on the target
> > system.
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Tuesday, July 30, 2002 12:58 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi all,
> >
> > Env.: 2 Solaris boxes both Oracle 8.1.7.3
> >
> > BoxA has the RMAN catalog. BoxB is where the Prod db is.  
> RMAN backups are
> > initiated from BoxA to backup db in BoxB.  RMAN backupsets 
> are created in
> > BoxB.  Is there a way to get RMAN to create the backupsets in BoxA
> instead?
> >
> > Below is an excerpt of my rman backup script:
> > ---
> > ---
> > ---
> > replace script backup_db_full {
> >   execute script archive_log_current;
> >   execute script alloc_all_disks;
> >   execute script set_maxcorrupt;
> >   backup
> > full
> > skip inaccessible
> > tag b_db_full
> > filesperset 3
> > format '/oracle1/oracle/admin/RMAN/backup/df/dfset_%s_%t.%d'
> > database;
> >   execute script rel_all_disks;
> >   execute script archive_log_current;
> >   execute script backup_al_all;
> > }
> > ---
> > ---
> >
> > Rgds,
> > Ross
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ross Collado
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / 
> Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / 
> Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Alexandre Gorbatchev
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ross Collado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Cluster problem

[Mr Frank Pettinato]

All,
I am having a problem with a cluster. My environment
is Oracle 8.1.7 on Win2k on a COMPAQ server. This is a
production DB that has been running for a year or so
and I have now taken it over.

My problem is that there is a table that has 1 column
in a cluster. The cluster does not contain any other
columns / tables.

In the DB when I issue the query:
select * from table where seqno = 341124;
I get no rows selected. I know that the data is there
because when I run:
select * from table 
where seqno = 341124 and defect_no =1;
I get: 
SEQNO DEFECT_NO X Y TESTMODE_INDEX DEFECT_INDEX IO
--- -- -- --
--  -
NUM_BITS START_ROW START_COL END_ROW END_COL
ADJACENT_DEF 
TEST_COUNTER
-- -- -- -- --
 

341124 1 14 11 -1 20 R0
25 0 0 0 960 27 

I have traced both queries and the first query uses
the cluster index, while the second uses the PK on the
table that is in the cluster.

I have validated the cluster using analyze
succesfully. I am not sure what else to try and Oracle
just wants me to rebuild te cluster. 

Any ideas?

Thanks!
Frank





__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mr Frank Pettinato
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table Naming Conventions

[Rachel Carmichael]

I can see your point, In the data warehouse we are building here, the
modeler is planning on prefixing tables with the type of table (D_ for
dimension tables, F_ for fact, etc)

Hm, you mean we have to go back and revisit the naming standards that
they developed? Can I please suffix the column names with an indicator
of the datatype? :)

The biggest problem is that most management wants "naming standards"...


Rachel


--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> I just think it's a waste. You can tell by context what kind of thing
> a
> thing is. For example, consider: "select a.flarg from bloing a where
> a.croopoo > 7". This can be understood by syntactical context (even
> with
> the nonsense names), without having to rename "bloing" to
> "bloing_table".
> 
> Most of the embedding of type names into object names that I've seen
> has
> been implemented by users who were inexperienced at the time they
> created the standard. They were worried that without embedding the
> type
> name into the object name, they might forget what kind of object it
> was.
> ...Most such naming conventions become onerous over time, long after
> you
> find out that you can find the type of something in the data
> dictionary,
> but after it's too late to save the thousands of extra characters of
> typing that'll waste people's lifespans over time.
> 
> In my old OFA paper, I made a joke about how we don't embed type
> names
> into object names in daily life, with just a few exceptions (Billy
> the
> Kid, Winnie the Pooh, Atilla the Hun, and the younger family members
> of
> the old Walton Family TV show are a few examples). If you have both a
> dog and a child named "Rex," though, it's probably a good idea to
> expect
> them both to come when you call. With SQL, though, I can't think of a
> case in which it's not easy to tell by syntactic context what kind of
> thing you're talking about...
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - NCOAUG Training Day, Aug 16 Chicago
> - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> Dallas
> 
> 
> 
> -Original Message-
> Carmichael
> Sent: Tuesday, July 30, 2002 4:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> Cary,
> 
> you said 
> "* Don't embed the object type in the object's name. I used to see
> this
> all the time with tablespaces called XYZ_TS, indexes called
> IND_THING,
> and so on."
> 
> what's your logic behind that? 
> 
> Rachel
> 
> 
> 
> --- Cary Millsap <[EMAIL PROTECTED]> wrote:
> > Here's a start. Not a checklist by any means, just kind of a micro
> > pet
> > peeves list.
> > 
> > * Decide today whether table names will be singular or plural. Do
> you
> > want a THING (singular) table? Or a THINGS (plural) table?
> > 
> > * Don't use case-sensitive names. E.g., use THING (without quotes)
> in
> > your CREATE (DDL) statement, which can be spelled "THING", "thing",
> > "Thing", or even "tHiNG" in your developers' SQL. But don't make
> > developers type stuff like this...
> > 
> > select "Name" from "Thing" where "Id" = y  /* won't work
> without
> > ""
> > */
> > 
> > * Don't embed the object type in the object's name. I used to see
> > this
> > all the time with tablespaces called XYZ_TS, indexes called
> > IND_THING,
> > and so on.
> > 
> > * Decide today whether you want to abbreviate or not. If you do,
> then
> > construct a formal, standard, consistent list of accepted
> > abbreviations.
> > Don't name one table CUSTOMER_THING and another CUST_HISTORY.
> > 
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > 
> > Upcoming events:
> > - NCOAUG Training Day, Aug 16 Chicago
> > - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> > - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> > Dallas
> > 
> > 
> > 
> > -Original Message-
> > Chambers
> > Sent: Tuesday, July 30, 2002 3:37 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > All...
> > 
> > Will some of you please provide some insight on your table naming
> > conventions?  I'm in the very early planning stages of what will
> > likely
> > be a large and complex schema (IT asset inventory).  I have a
> chance
> > to
> > start it correctly.  TIA
> > 
> > Gary Chambers
> > 
> > //-
> > // Lucent Technologies GIO/Unix
> > // 4 Robbins Road, Westford, MA 01886
> > // 978-399-0481 / 888-480-6924 (Pager)
> > // Nothing fancy and nothing Microsoft
> > //-
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Gary Chambers
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> 
> > To REMOVE yourself from this m

RE: Table Naming Conventions

[CHAN Chor Ling Catherine (CSC)]

Hi Gary,

In our environment, there are many applications in one database. We always
create public synonym for all the tables. To avoid confusion, all the tables
have to be tagged with the application prefix .eg. Student System has the
prefix STD, so the tables will be STD_XXX where XXX is the table name and
the public synonym is STDXXX. We don't have any rules for the table name
XXX.

Hope it helps.

Regds,
Catherine
-Original Message-
From:   Gary Chambers [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, July 31, 2002 4:37 AM
To: Multiple recipients of list ORACLE-L
Subject:Table Naming Conventions

All...

Will some of you please provide some insight on your table
naming
conventions?  I'm in the very early planning stages of what
will likely
be a large and complex schema (IT asset inventory).  I have
a chance to
start it correctly.  TIA

Gary Chambers

//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Chambers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
San Diego, California-- Public Internet access /
Mailing Lists


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table Naming Conventions

[kkennedy]

Hmmm.  Seems I have to play devil's advocate on this one.  So, you see no purpose to 
index names such as:

P_EMPLOYEE for a Primary key on the employee table
or UM_METER_CODE for a unique index on the meter table meter_code column
or FE_DEPT for a foreign key index on the employee table dept column
or IIE_LOG_DATE for a non-unique index on the import_export table log_date column?

The first letter doesn't help me figure out that the object is an index, but it sure 
helps to show what the index is being used for.

Constraint naming is another area where we use a one character prefix to identify the 
constraint type, in part to conform to index naming.

The keeper of standards here (not me) has also imposed prefix conventions on global 
temporary tables and on selected classes of tables such as work tables or external 
cross reference tables.  It does help keep the developers in line.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?


-Original Message-
Sent: Tuesday, July 30, 2002 4:58 PM
To: Multiple recipients of list ORACLE-L


You already know it's an index, why would you include that as part of the 
name?

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 02:29 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Table Naming Conventions


My supervisor/client wants object types in names - except tables like I_ 
for indexes.  Why do you say stay away from this?
-Original Message- 
Sent: Tuesday, July 30, 2002 5:10 PM 
To: Multiple recipients of list ORACLE-L 

Here's a start. Not a checklist by any means, just kind of a micro pet 
peeves list. 
* Decide today whether table names will be singular or plural. Do you 
want a THING (singular) table? Or a THINGS (plural) table? 
* Don't use case-sensitive names. E.g., use THING (without quotes) in 
your CREATE (DDL) statement, which can be spelled "THING", "thing", 
"Thing", or even "tHiNG" in your developers' SQL. But don't make 
developers type stuff like this... 
select "Name" from "Thing" where "Id" = y  /* won't work without "" 
*/ 
* Don't embed the object type in the object's name. I used to see this 
all the time with tablespaces called XYZ_TS, indexes called IND_THING, 
and so on. 
* Decide today whether you want to abbreviate or not. If you do, then 
construct a formal, standard, consistent list of accepted abbreviations. 
Don't name one table CUSTOMER_THING and another CUST_HISTORY. 

Cary Millsap 
Hotsos Enterprises, Ltd. 
http://www.hotsos.com 
Upcoming events: 
- NCOAUG Training Day, Aug 16 Chicago 
- Miracle Database Forum, Sep 20-22 Middlefart Denmark 
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas 


-Original Message- 
Chambers 
Sent: Tuesday, July 30, 2002 3:37 PM 
To: Multiple recipients of list ORACLE-L 
All... 
Will some of you please provide some insight on your table naming 
conventions?  I'm in the very early planning stages of what will likely 
be a large and complex schema (IT asset inventory).  I have a chance to 
start it correctly.  TIA 
Gary Chambers 
//- 
// Lucent Technologies GIO/Unix 
// 4 Robbins Road, Westford, MA 01886 
// 978-399-0481 / 888-480-6924 (Pager) 
// Nothing fancy and nothing Microsoft 
//- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Gary Chambers 
  INET: [EMAIL PROTECTED] 
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Cary Millsap 
  INET: [EMAIL PROTECTED] 
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access 

RE: Ids and passwords for application users

[Jacques Kilchoer]

Title: RE: Ids and passwords for application users





> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
>   If a common login is used (which is the case with most 
> applications), 
> dbms_application_info can be used to set the actual username 
> in either the 
> module or action. As long as the application is not using 
> dbms_application_info 
> to set both, you should be able to get the info from v$session.


Sure, but I will repeat what I said before:
a) It's easier to write code if the user is determined by the Oracle userid rather than by
 v$session.client_info. Trigger example:
create trigger orders_set_user
 before insert or update on orders
 for each row
begin
   :new.last_upd_user := user ;
end orders_set_user ;
/


b) How do you plan on hiding the password from the user, or, more importantly, changing the
   password if it becomes compromised?

Re: OT: plot by "elitists" confirmed...

[Rachel Carmichael]

Oh I love it!  And I had forgotten about Bored of the Rings  :)


--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> ...from ...
> 
> 
>

> Creators admit: UNIX and C Hoax!
> In an announcement that has stunned the computer industry, Ken
> Thompson, Dennis Ritchie, and Brian Kernighan admitted that the Unix
> operating system and C programming language created by them is an
> elaborate April Fools prank kept alive for over 20 years. Speaking at
> the recent UnixWorld Software Development Forum, Thompson revealed
> the following: 
> 
> "In 1969, AT&T had just terminated their work with the
> GE/Honeywell/AT&T Multics project. Brian and I had just started
> working with an early release of Pascal from Professor Niklaus
> Wirth's ETH labs in Switzerland and we were impressed with its
> elegant simplicity and power. Dennis had just finished reading "Bored
> of the Rings", a hilarious National Lampoon parody of the great
> Tolkien "Lord of the Rings" trilogy. As a lark, we decided to do
> parodies of the Multics environment and Pascal. Dennis and I were
> responsible for the operating environment. We looked at Multics and
> designed the new system to be as complex and cryptic as possible to
> maximize casual users' frustration levels, calling it Unix as a
> parody of Multics, as well as other more risque allusions. Then
> Dennis and Brian worked on a truly warped version of Pascal, called
> "A". When we found others were actually trying to create real
> programs with A, we quickly added additional cryptic features and
> evolved into B, BCPL and finally C. We stopped when we got a clean
> compile on the following syntax: 
> 
> for(;P("\n"),R--;P("|")) for(e=C;e--;P("_"+(*u++/8)%2))
> P("|"+(*u/4)%2); 
> 
> To think that modern programmers would try to use a language that
> allowed such a statement was beyond our comprehension! We actually
> thought of selling this to the Soviets to set their computer science
> progress back 20 or more years. Imagine our surprise when AT&T and
> other US corporations actually began trying to use Unix and C! It has
> taken them 20 years to develop enough expertise to generate even
> marginally useful applications using this 1960's technological
> parody, but we are impressed with the tenacity (if not common sense)
> of the general Unix and C programmer. In any event, Brian, Dennis and
> I have been working exclusively in Pascal on the Apple Macintosh for
> the past few years and feel really guilty about the chaos, confusion
> and truly bad programming that have resulted from our silly prank so
> long ago." 
> 
> Major Unix and C vendors and customers, including AT&T, Microsoft,
> Hewlett-Packard, GTE, NCR, and DEC have refused comment at this time.
> Borland International, a leading vendor of Pascal and C tools,
> including the popular Turbo Pascal, Turbo C and Turbo C++, stated
> they had suspected this for a number of years and would continue to
> enhance their Pascal products and halt further efforts to develop C.
> An IBM spokesman broke into uncontrolled laughter and had to postpone
> a hastily convened news conference concerning the fate of the
> RS-6000, merely stating "VM will be available Real Soon Now." In a
> cryptic statement, Professor Wirth of the ETH institute and father of
> the Pascal, Modula 2, and Oberon structured languages, merely stated
> that P. T. Barnum was correct. 
> 
> In a related late-breaking story, usually reliable sources are
> stating that a similar confession may be forthcoming from William
> Gates concerning the MS-DOS and Windows operating environments. And
> IBM spokesman have begun denying that the Virtual Machine (VM)
> product is an internal prank gone awry. 
> 
> 


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-1658 even though there is enough contig free

[Jacques Kilchoer]

Title: RE: ORA-1658 even though there is enough contig free





Could it be because of the minimum extent size? Though I would think it unlikely that your minimum extent size would be greater than 147MB.

> -Original Message-
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
> 
> On 8.1.7.2.0 on HP/UX 11.0, I need to create an index online. 
>  So, I see how
> much space I have:
> 
> select max(bytes/1024/1024)
> from dba_free_space
> where tablespace_name = 'MY_IDX_TS';
> 
> ...and it returns "147.3475".  So I create my index:
> 
> CREATE INDEX myschema.mycoolidx
>  ON myschema.mycooltbl(mycoolcol) PCTFREE 15
>   STORAGE(
>       INITIAL 140 M
>       NEXT 30 M
>       )
> NOLOGGING ONLINE TABLESPACE my_idx_ts PARALLEL 2;
> 
> But I keep getting "ORA-01658 unable to create initial extent 
> in MY_IDX_TS",
> even though there is ample room.  I thought it was because I 
> had originally
> tried it with "PARALLEL 2" and there was some overhead needed, so I
> coalesced the TS (DICTIONARY, obviously) and tried it without 
> the PARALLEL
> to no avail.  I've even dropped the INITIAL down to 130M 
> without luck (again
> after coalescing).  Oh, to be LOCAL...
> 
> So, how big can I make the initial extent?  I don't remember 
> running into
> this before and I can't find anything on MetaLink.  And of 
> course, I killed
> the session when it was creating it so now I can't drop the 
> index without a
> ORA-8104 error.

RE: Table Naming Conventions

[Jared . Still]

You already know it's an index, why would you include that as part of the 
name?

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 02:29 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Table Naming Conventions


My supervisor/client wants object types in names - except tables like I_ 
for indexes.  Why do you say stay away from this?
-Original Message- 
Sent: Tuesday, July 30, 2002 5:10 PM 
To: Multiple recipients of list ORACLE-L 

Here's a start. Not a checklist by any means, just kind of a micro pet 
peeves list. 
* Decide today whether table names will be singular or plural. Do you 
want a THING (singular) table? Or a THINGS (plural) table? 
* Don't use case-sensitive names. E.g., use THING (without quotes) in 
your CREATE (DDL) statement, which can be spelled "THING", "thing", 
"Thing", or even "tHiNG" in your developers' SQL. But don't make 
developers type stuff like this... 
select "Name" from "Thing" where "Id" = y  /* won't work without "" 
*/ 
* Don't embed the object type in the object's name. I used to see this 
all the time with tablespaces called XYZ_TS, indexes called IND_THING, 
and so on. 
* Decide today whether you want to abbreviate or not. If you do, then 
construct a formal, standard, consistent list of accepted abbreviations. 
Don't name one table CUSTOMER_THING and another CUST_HISTORY. 

Cary Millsap 
Hotsos Enterprises, Ltd. 
http://www.hotsos.com 
Upcoming events: 
- NCOAUG Training Day, Aug 16 Chicago 
- Miracle Database Forum, Sep 20-22 Middlefart Denmark 
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas 


-Original Message- 
Chambers 
Sent: Tuesday, July 30, 2002 3:37 PM 
To: Multiple recipients of list ORACLE-L 
All... 
Will some of you please provide some insight on your table naming 
conventions?  I'm in the very early planning stages of what will likely 
be a large and complex schema (IT asset inventory).  I have a chance to 
start it correctly.  TIA 
Gary Chambers 
//- 
// Lucent Technologies GIO/Unix 
// 4 Robbins Road, Westford, MA 01886 
// 978-399-0481 / 888-480-6924 (Pager) 
// Nothing fancy and nothing Microsoft 
//- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Gary Chambers 
  INET: [EMAIL PROTECTED] 
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Cary Millsap 
  INET: [EMAIL PROTECTED] 
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table Naming Conventions

[Stephen Andert]

I ran into a problem with this once.  I had a procedure that I used to
monitor database statistics that I named monitor_stats.  I stored that
data in a table called monitor_stats (OK, I should have named the table
stats, but that seemed too generic).  With a procedure and table named
the same, the procedure wouldn't compile.  When I renamed the procedure
to monitor_stats_proc, it worked.  

But I agree that keeping object types out of their names is a good
idea.

dba_Stephen
Stephen_dba
Stephen

>>> [EMAIL PROTECTED] 07/30/02 03:53PM >>>
I just think it's a waste. You can tell by context what kind of thing
a
thing is. For example, consider: "select a.flarg from bloing a where
a.croopoo > 7". This can be understood by syntactical context (even
with
the nonsense names), without having to rename "bloing" to
"bloing_table".

Most of the embedding of type names into object names that I've seen
has
been implemented by users who were inexperienced at the time they
created the standard. They were worried that without embedding the
type
name into the object name, they might forget what kind of object it
was.
...Most such naming conventions become onerous over time, long after
you
find out that you can find the type of something in the data
dictionary,
but after it's too late to save the thousands of extra characters of
typing that'll waste people's lifespans over time.

In my old OFA paper, I made a joke about how we don't embed type names
into object names in daily life, with just a few exceptions (Billy the
Kid, Winnie the Pooh, Atilla the Hun, and the younger family members
of
the old Walton Family TV show are a few examples). If you have both a
dog and a child named "Rex," though, it's probably a good idea to
expect
them both to come when you call. With SQL, though, I can't think of a
case in which it's not easy to tell by syntactic context what kind of
thing you're talking about...


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com 

Upcoming events:
- NCOAUG Training Day, Aug 16 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas



-Original Message-
Carmichael
Sent: Tuesday, July 30, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L

Cary,

you said 
"* Don't embed the object type in the object's name. I used to see
this
all the time with tablespaces called XYZ_TS, indexes called IND_THING,
and so on."

what's your logic behind that? 

Rachel



--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> Here's a start. Not a checklist by any means, just kind of a micro
> pet
> peeves list.
> 
> * Decide today whether table names will be singular or plural. Do
you
> want a THING (singular) table? Or a THINGS (plural) table?
> 
> * Don't use case-sensitive names. E.g., use THING (without quotes)
in
> your CREATE (DDL) statement, which can be spelled "THING", "thing",
> "Thing", or even "tHiNG" in your developers' SQL. But don't make
> developers type stuff like this...
> 
> select "Name" from "Thing" where "Id" = y  /* won't work without
> ""
> */
> 
> * Don't embed the object type in the object's name. I used to see
> this
> all the time with tablespaces called XYZ_TS, indexes called
> IND_THING,
> and so on.
> 
> * Decide today whether you want to abbreviate or not. If you do,
then
> construct a formal, standard, consistent list of accepted
> abbreviations.
> Don't name one table CUSTOMER_THING and another CUST_HISTORY.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com 
> 
> Upcoming events:
> - NCOAUG Training Day, Aug 16 Chicago
> - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> Dallas
> 
> 
> 
> -Original Message-
> Chambers
> Sent: Tuesday, July 30, 2002 3:37 PM
> To: Multiple recipients of list ORACLE-L
> 
> All...
> 
> Will some of you please provide some insight on your table naming
> conventions?  I'm in the very early planning stages of what will
> likely
> be a large and complex schema (IT asset inventory).  I have a chance
> to
> start it correctly.  TIA
> 
> Gary Chambers
> 
> //-
> // Lucent Technologies GIO/Unix
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //-
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Gary Chambers
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be remove

Re: user(s) & RBS

[Suzy Vordos]

select c.segment_name, e.sid, e.username,
   b.object_name, b.object_type,
   d.used_urec, a.os_user_name,
   d.xidusn, d.start_time,
   e.process, e.program, e.status
 from v$locked_object a,
  dba_objects b,
  dba_rollback_segs c,
  v$transaction d,
  v$session e
where a.object_id = b.object_id
  and a.xidusn = c.segment_id
  and a.xidusn = d.xidusn
  and a.xidslot = d.xidslot
  and d.addr = e.taddr;


Charlie Mengler wrote:
> 
> If I'm interested in a specific RBS, how do I determine which user(s)
> are making use of this segement?
> 
> How do I determine which RBS a particular user is using?
> 
> --
> Charlie Mengler  Maintenance Warehouse
> [EMAIL PROTECTED] 10641 Scripps Summit Ct.
> 858-831-2229 San Diego, CA 92131
> Lack of planning on your part doesn't constitute an emergency on my part!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: user(s) & RBS

[Jacques Kilchoer]

Title: RE: user(s) & RBS





> -Original Message-
> From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
> 
> If I'm interested in a specific RBS, how do I determine which user(s)
> are making use of this segement?
> 
> How do I determine which RBS a particular user is using?


You could try this script (I have used it on Oracle Server 8.1.x)
From
Oracle FAQ: Script and Code Exchange
Database Performance Tuning Scripts
http://www.orafaq.com/faqscrpt.htm#DBATUNE


Display database sessions using rollback segments
http://www.orafaq.com/scripts/sql/rbs_act.txt
rem ---
rem Filename:   rbs_act.sql
rem Purpose:    Display database sessions using rollback segments
rem Author: Anonymous
rem ---


col RBS format a5 trunc
col SID format 9990
col USER format a10 trunc
col COMMAND format a78 trunc
col status format a6 trunc


SELECT r.name "RBS", s.sid, s.serial#, s.username "USER", t.status,
   t.cr_get, t.phy_io, t.used_ublk, t.noundo,
   substr(s.program, 1, 78) "COMMAND"
FROM   sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r
WHERE  t.addr = s.taddr
  and  t.xidusn = r.usn
ORDER  BY t.cr_get, t.phy_io
/

RE: Creating sequences on the DUAL table?

[Jared . Still]

An interesting use of sequences might be to encrypt information.

Properly sequenced sequences could be used to easily encode
information that would be destroyed upon being read.

Know, I dunno where that came from, just hit me out of the blue
while reading this thread.  Could be fun though.

Jared






"Fink, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/30/2002 01:31 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Creating sequences on the DUAL table?


To be more accurate, a sequence does not even have to be used for a table.
It is a construct to populate a variable (could be a table column, could 
be
run time) with a number that is generated in a specific order (though it 
may
contain gaps).

Dan (as he ducks a knitting needle).

-Original Message-
Sent: Tuesday, July 30, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L


Cherie,

Terminology --  make sure they understand that sequences are not
created attached to any table and can be used for more than one table. 

Rachel

--- [EMAIL PROTECTED] wrote:
> 
> Dan,
> 
> Haven't heard the why yet but I think it may be just a poorly worded
> request.   I suspect he wants the sequences created on another table
> and
> just wants to be able to select from dual.   Maybe he never realized
> that
> the sequences were actually created on another table.Maybe he
> actually
> thought that the sequences were created on the DUAL table since he
> only
> ever used them by selecting from DUAL.   Our developers run quite a
> wide
> gamut and I don't work very regularly with this one so it's hard to
> know
> where he's coming from.   Still trying to get him on the phone.
> 
> Thanks for this info about performance on DUAL.  I will pass the info
> on.
> Thanks to everyone for getting us all on the same page.   I'm sure
> that
> once I talk this out with him, it'll be straightened out quickly.
> 
> Cherie
> 
> 
> 
> 
> "Fink, Dan" 
> 
>  "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 
> com> 
> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> 
> 
>  cc: 
> 
> 07/30/02 12:46   Subject: RE: Creating
> sequences on the DUAL table? 
> PM 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Cherie,
>My first response is 'WHY?'. Do they mean that they want
> to
> create 2
> new sequences and use the DUAL table to retrieve the values? It will
> cause
> performance problems and there are better solutions. I have some
> information
> on the performance implications of DUAL at
> http://www.optimaldba.com/internals/oraint_dual.html.
> 
> Dan Fink
> 
> -Original Message-
> Sent: Tuesday, July 30, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> I have a request from one of our developers to create two new
> sequences on
> the DUAL table.
> 
> This seems like a bad idea to me.   I've never had such a request in
> the
> past.   I asked for clarification on why this is needed and I didn't
> get a
> lot of details yet.
> 
> Is this something that is standard operating procedure?   My
> understanding
> that interfacing with the DUAL table is usually inviting poor
> performance.
> Plus, I don't like to mess around with system tables, in general.
> 
> Under what circumstances would it be justified to create sequences on
> the
> DUAL table?   Should I just flat-out refuse this request and if so,
> why?
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


_

RE: Table Naming Conventions

[Cary Millsap]

I just think it's a waste. You can tell by context what kind of thing a
thing is. For example, consider: "select a.flarg from bloing a where
a.croopoo > 7". This can be understood by syntactical context (even with
the nonsense names), without having to rename "bloing" to
"bloing_table".

Most of the embedding of type names into object names that I've seen has
been implemented by users who were inexperienced at the time they
created the standard. They were worried that without embedding the type
name into the object name, they might forget what kind of object it was.
...Most such naming conventions become onerous over time, long after you
find out that you can find the type of something in the data dictionary,
but after it's too late to save the thousands of extra characters of
typing that'll waste people's lifespans over time.

In my old OFA paper, I made a joke about how we don't embed type names
into object names in daily life, with just a few exceptions (Billy the
Kid, Winnie the Pooh, Atilla the Hun, and the younger family members of
the old Walton Family TV show are a few examples). If you have both a
dog and a child named "Rex," though, it's probably a good idea to expect
them both to come when you call. With SQL, though, I can't think of a
case in which it's not easy to tell by syntactic context what kind of
thing you're talking about...


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- NCOAUG Training Day, Aug 16 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas



-Original Message-
Carmichael
Sent: Tuesday, July 30, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L

Cary,

you said 
"* Don't embed the object type in the object's name. I used to see this
all the time with tablespaces called XYZ_TS, indexes called IND_THING,
and so on."

what's your logic behind that? 

Rachel



--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> Here's a start. Not a checklist by any means, just kind of a micro
> pet
> peeves list.
> 
> * Decide today whether table names will be singular or plural. Do you
> want a THING (singular) table? Or a THINGS (plural) table?
> 
> * Don't use case-sensitive names. E.g., use THING (without quotes) in
> your CREATE (DDL) statement, which can be spelled "THING", "thing",
> "Thing", or even "tHiNG" in your developers' SQL. But don't make
> developers type stuff like this...
> 
> select "Name" from "Thing" where "Id" = y  /* won't work without
> ""
> */
> 
> * Don't embed the object type in the object's name. I used to see
> this
> all the time with tablespaces called XYZ_TS, indexes called
> IND_THING,
> and so on.
> 
> * Decide today whether you want to abbreviate or not. If you do, then
> construct a formal, standard, consistent list of accepted
> abbreviations.
> Don't name one table CUSTOMER_THING and another CUST_HISTORY.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - NCOAUG Training Day, Aug 16 Chicago
> - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> Dallas
> 
> 
> 
> -Original Message-
> Chambers
> Sent: Tuesday, July 30, 2002 3:37 PM
> To: Multiple recipients of list ORACLE-L
> 
> All...
> 
> Will some of you please provide some insight on your table naming
> conventions?  I'm in the very early planning stages of what will
> likely
> be a large and complex schema (IT asset inventory).  I have a chance
> to
> start it correctly.  TIA
> 
> Gary Chambers
> 
> //-
> // Lucent Technologies GIO/Unix
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //-
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Gary Chambers
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Cary Millsap
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling

Foreign Keys and Table Locking

[Sam Bootsma]

Hello List,

Here is my question:  
If a composite foreign key (defined using on delete cascade) is partially
indexed, will a delete operation on the referenced table use the index on
the partial foreign key?

More Detailed Explanation of Question
Assume the following
1. A master table with columns A, B, C, and D.
2. A detail table with columns A, B, C, and X.  
3. The detail table has a foreign key on columns A, B, and C, that reference
the same columns on the master table. 
4. The foreign key on the detail table is defined using "on delete cascade".

If a delete or update operation is performed on the master table, the
operation is cascaded to the detail table.  If there is no index on the
detail table, Oracle will lock the entire table.  If there is an index on
columns A,B, and C of the detail table, Oracle will not lock the detail
table, but will use the index.  

My question (repeated):  If there is an index on columns A and B of the
detail table (but NOT column C), will Oracle lock the detail table?  Or will
Oracle use the existing index?

I appreciate any help anybody can provide.  I am on digest mode only, so if
possible, please send a reply to both my individual email  and to the list.
That way I get a response much quicker.

Thanks!


Sam Bootsma, OCP
Technical Support Analyst
CPAS Systems Inc.
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sam Bootsma
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

user(s) & RBS

[Charlie Mengler]

If I'm interested in a specific RBS, how do I determine which user(s)
are making use of this segement?

How do I determine which RBS a particular user is using?

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my part!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Host System Commands from PL/SQL blocks

[Jared . Still]

One solution is to write custom code to call as an external procedure.

A simpler method might be to just write a daemon that starts up prior
to Oracle and is controlled through data passed via a table.

The daemon tries to connect periodically, and after doing so, polls
the control table on a regular basis for startup instructions.

Jared






John Weatherman <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/30/2002 12:56 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Host System Commands from PL/SQL blocks


OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old 
question...

I need to execute a system call from within a PL/SQL block.  Specifically,
I am looking at starting out report request demons as part of a post 
startup
trigger.  Help?

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Hot tables and Their Costs

[MacGregor, Ian A.]

Title: Message



You 
already have paret of what you need from the stats$sql_summary table which tells 
you how often a statement has been executed.  Bear in mind this table will 
truncate any statement to 1000 bytes.   You will probably also need 
the stats$sqltext table.  This table was added to statspack in Oracle 
8.1.7.   What you need to do is to parse the statements to find the 
tables they access.  The easiest way of doing that  is to explain 
them.  This will  also tell you the type of access; e.g. FTS  or 
some type of index.  In Oracle 9i there is a V$SQL_Plan  table which 
could be added to the statspack "snapshots".   I have not fooled with 
the 9i version of statspack.  Perhaps it is already 
there. 
 
With 
this information you can say, for instance, the personnel table was accessed 35 
times via an FTS in the past hour, and you would  know which statements 
caused that access.  What would be nice to know is how many I/0's it took 
to accomplish those scans.  The numbers present in stats$sql_summary  
are for the entire statement and not for the individual tables.  The costs 
figures produced by explain are estimates.  It may seem that you could get 
the number of I/O's by knopwing the number of blocks below the highwater mark 
and the size of each db_file_scattered_read.  However  a read for 
various reasons may not fetch the maximum number of blocks.  I'm not sure 
how to get an accurate per segment I/O count.
 
Also 
missing would be  any waits associated with accessing the 
tables.
 
Ian 
MacGregor
Stanford Linear Accelerator Center

  -Original Message-From: Terrian, Tom 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 25, 2002 5:48 
  AMTo: Multiple recipients of list ORACLE-LSubject: Hot 
  tables
  How is everyone 
  identifying hot tables?  In my tool box I have the following two scripts 
  but I am looking for other options.  How do you track frequently accessed 
  tables?
   
  Script #1 - 
  Author unknown:
  select obj_name, 
  sum(decode(action_name,'SELECT',1,0)) sel  
  ,sum(decode(action_name,'INSERT',1,0)) inserts, 
      
  sum(decode(action_name,'UPDATE',1,0)) updates, 
      
  sum(decode(action_name,'DELETE',1,0)) deletes from dba_audit_trail 
  having sum(decode(action_name,'SELECT' , 1, 'INSERT',1, 
  'DELETE',1,'UPDATE',1,0)) > 0 group by obj_name; 
  Script #2 - Dave Ensor (BMC):set 
  verify off col CTYP heading 'Command Type' col OBJ  format a32 
  wrap   heading 'Table' col EXES format 999,990    
  heading 'Execs' col GETS format 99,999,990 heading 'Buff Gets' col 
  ROWP format 99,999,990 heading 'Rows Proc' 
  select CTYP  , OBJ  
  , 0 - EXEM  EXES  , GETS 
   , ROWP   from (select distinct EXEM, 
  CTYP, OBJ, GETS, ROWP 
    from ( select 
  decode (S.COMMAND_TYPE 
    
  ,  2, 'Insert into ' 
    
  ,  3, 'Select from ' 
    
  ,  6, 'Update  of  ' 
    
  ,  7, 'Delete from ' 
    
  , 26, 'Lock    of  ') CTYP 
   
  , O.OWNER || '.' || O.NAME    OBJ 
   
  , sum(0 - S.EXECUTIONS)   EXEM 
   
  , sum(S.BUFFER_GETS)  
  GETS 
   
  , sum(S.ROWS_PROCESSED)   ROWP 
      
  from 
  V$SQL   
  S 
     
  , V$OBJECT_DEPENDENCY D 
     
  , V$DB_OBJECT_CACHE   O 
     
  where S.COMMAND_TYPE in (2,3,6,7,26) 
   
  and D.FROM_ADDRESS = S.ADDRESS 
   
  and D.TO_OWNER = O.OWNER 
   
  and D.TO_NAME  = O.NAME 
   
  and O.TYPE = 'TABLE' 
      
  group by S.COMMAND_TYPE 
     
  , O.OWNER 
     
  , O.NAME )  )  where ROWNUM <= &1 / 
   
   

RE: Ids and passwords for application users

[groups]

  If a common login is used (which is the case with most applications), 
dbms_application_info can be used to set the actual username in either the 
module or action. As long as the application is not using dbms_application_info 
to set both, you should be able to get the info from v$session.

Regards,
Denny

Quoting Jacques Kilchoer <[EMAIL PROTECTED]>:

> I always preferred the option of having a userid for each person,
> because it
> makes it easier to match session to user. When you say userid
> "dwilliams"
> locking a table you know who to call, but if you see userid "app_user"
> you
> have to do some extra work to track the person down. From a developer
> point
> of view, it's easier to determine the name of the logged in user (use
> built-in "user" function) than it would be to find out the machine name
> /
> application name (select * from v$session).
> If you have only one username with a password hard-coded in the
> application,
> how do you plan on hiding the password from the user, or changing the
> password if it becomes compromised?
> 
> > -Original Message-
> > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> > 
> > Peter - Go with option #1 unless you relish a career as an 
> > Oracle security
> > officer. With option #1 the developers can create some administrator
> > screens. Unless security is really, really critical.
> > 
> > -Original Message-
> > 
> > I am in the process of designing a small database which may have
> > as many as 250 to 300 users.  We are reaching a stage where we need
> > to decide how we will control access to this database.  As I see it
> > we have two options:
> > 
> > 1.  Provide a single hidden login for the entire application 
> > and control
> > access to the applicaiton itself either by "roll your own" security
> or
> > using the operating system (UNIX) controls.
> > 
> > 2.  Create ids for the users in Oracle and grant them access
> > to the necessary tables using roles.
> > 
> > Any opinions or alternate suggestions?
> > 
> > Peter Schauss
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

There are even more plots to go around.

[Gogala, Mladen]

Title: Microsoft Bids to Acquire Catholic Church



 
 


Microsoft Bids to Acquire Catholic Church
VATICAN CITY (AP) -- In a joint press conference in St. Peter's Square this 
morning, MICROSOFT Corp. and the Vatican announced that the Redmond software 
giant will acquire the Roman Catholic Church in exchange for an unspecified 
number of shares of MICROSOFT common stock. If the deal goes through, it will be 
the first time a computer software company has acquired a major world religion. 
With the acquisition, Pope John Paul II will become the senior vice-president 
of the combined company's new Religious Software Division, while MICROSOFT 
senior vice-presidents Michael Maples and Steven Ballmer will be invested in the 
College of Cardinals, said MICROSOFT Chairman Bill Gates. 
"We expect a lot of growth in the religious market in the next five to ten 
years," said Gates. "The combined resources of MICROSOFT and the Catholic Church 
will allow us to make religion easier and more fun for a broader range of 
people." 
Through the MICROSOFT Network, the company's new on-line service, "we will 
make the sacraments available on-line for the first time" and revive the popular 
pre-Counter-Reformation practice of selling indulgences, said Gates. "You can 
get Communion, confess your sins, receive absolution - even reduce your time in 
Purgatory - all without leaving your home." 
A new software application, MICROSOFT Church, will include a macro language 
which you can program to download heavenly graces automatically while you are 
away from your computer. 
An estimated 17,000 people attended the announcement in St Peter's Square, 
watching on a 60-foot screen as comedian Don Novello - in character as Father 
Guido Sarducci - hosted the event, which was broadcast by satellite to 700 sites 
worldwide. 
Pope John Paul II said little during the announcement. When Novello chided 
Gates, "Now I guess you get to wear one of these pointy hats," the crowd roared, 
but the pontiff's smile seemed strained. 
The deal grants MICROSOFT exclusive electronic rights to the Bible and the 
Vatican's prized art collection, which includes works by such masters as 
Michelangelo and Da Vinci. But critics say MICROSOFT will face stiff challenges 
if it attempts to limit competitors' access to these key intellectual 
properties. 
"The Jewish people invented the look and feel of the holy scriptures," said 
Rabbi David Gottschalk of Philadelphia. "You take the parting of the Red Sea - 
we had that thousands of years before the Catholics came on the scene." 
But others argue that the Catholic and Jewish faiths both draw on a common 
Abrahamic heritage. "The Catholic Church has just been more successful in 
marketing it to a larger audience," notes Notre Dame theologian Father Kenneth 
Madigan. Over the last 2,000 years, the Catholic Church's market share has 
increased dramatically, while Judaism, which was the first to offer many of the 
concepts now touted by Christianity, lags behind. 
Historically, the Church has a reputation as an aggressive competitor, 
leading crusades to pressure people to upgrade to Catholicism, and entering into 
exclusive licensing arrangements in various kingdoms whereby all subjects were 
instilled with Catholicism, whether or not they planned to use it. Today 
Christianity is available from several denominations, but the Catholic version 
is still the most widely used. The Church's mission is to reach "the four 
corners of the earth," echoing MICROSOFT's vision of "a computer on every 
desktop and in every home". 
Gates described MICROSOFT's long-term strategy to develop a scalable 
religious architecture that will support all religions through emulation. A 
single core religion will be offered with a choice of interfaces according to 
the religion desired - "One religion, a couple of different implementations," 
said Gates. 
The MICROSOFT move could spark a wave of mergers and acquisitions, according 
to Herb Peters, a spokesman for the U.S. Southern Baptist Conference, as other 
churches scramble to strengthen their position in the increasingly competitive 
religious market. 





  
  
Autor: 
Hank Vorjes, Knight-Ridder / Tribune Business News, 1994 
  
Quelle: 
"http://www.mal.com/~jreid/stories/gates.pope" (ursprünglich: via 
  NewsEDGE from Desktop Data, Inc.: 03/07/94 19:20) 
  
toHTML: 
1995-07-24 - Gunnar Anzinger <[EMAIL PROTECTED]> 



letzte Änderung: 1997-06-11 -- Gunnar Anzinger <[EMAIL PROTECTED]> 

Re: ORA-1658 even though there is enough contig free

[Mohammad Rafiq]

Rich,
1)Run following script to check fat size which will indicate how big your 
initial extent may be as you are not finding contigous space in your 
tablespace. when it ask for value give your tablespace name..

undefine table_space
set verify off
prompt This script provides a report useful for resizing datafiles
prompt You should perform a 'ALTER TABLESPACE tsname COALESCE' before 
running
prompt this script to ensure you are getting all free space at end of the 
file
accept table_space prompt "Enter a tablespace_name or all: "
select ddf.file_name,
   dfs.file_id,
   ddf.blocks,
   (ddf.blocks*value)/1024/1024 file_size_mb,
   dfs.block_id block_hwm,
   ddf.blocks-dfs.block_id fat_blocks,
   floor(((ddf.blocks-dfs.block_id)*value)/1024/1024)
fat_mb,
   ceil(((ddf.blocks*value)/1024/1024 -
 ((ddf.blocks-dfs.block_id)*value)/1024/1024)) resize_to
  from dba_free_space dfs,
   dba_data_files ddf,
   v$parameter
where v$parameter.name = 'db_block_size'
   and (ddf.tablespace_name = UPPER('&&table_space')
or 'ALL' = UPPER('&&table_space'))
   and dfs.tablespace_name = ddf.tablespace_name
   and dfs.file_id = ddf.file_id
   and dfs.block_id = (select max(block_id)
 from dba_free_space
where file_id = dfs.file_id)
  order by fat_blocks desc;
/

2) Coalesce your tablespace and run this script again..
3) or reduce yr initial extent size and don't use parallel clause

HTH,
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 30 Jul 2002 13:18:28 -0800

Hi all,

On 8.1.7.2.0 on HP/UX 11.0, I need to create an index online.  So, I see how
much space I have:

select max(bytes/1024/1024)
from dba_free_space
where tablespace_name = 'MY_IDX_TS';

...and it returns "147.3475".  So I create my index:

CREATE INDEX myschema.mycoolidx
  ON myschema.mycooltbl(mycoolcol) PCTFREE 15
STORAGE(
INITIAL 140 M
NEXT 30 M
)
NOLOGGING ONLINE TABLESPACE my_idx_ts PARALLEL 2;

But I keep getting "ORA-01658 unable to create initial extent in MY_IDX_TS",
even though there is ample room.  I thought it was because I had originally
tried it with "PARALLEL 2" and there was some overhead needed, so I
coalesced the TS (DICTIONARY, obviously) and tried it without the PARALLEL
to no avail.  I've even dropped the INITIAL down to 130M without luck (again
after coalescing).  Oh, to be LOCAL...

So, how big can I make the initial extent?  I don't remember running into
this before and I can't find anything on MetaLink.  And of course, I killed
the session when it was creating it so now I can't drop the index without a
ORA-8104 error.

Anyone?

TIA!
Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT: plot by "elitists" confirmed...

[Tim Gorman]

...from ...
 



Creators admit: UNIX and C Hoax!
In an announcement that has stunned the computer industry, Ken Thompson, 
Dennis Ritchie, and Brian Kernighan admitted that the Unix operating system and 
C programming language created by them is an elaborate April Fools prank kept 
alive for over 20 years. Speaking at the recent UnixWorld Software Development 
Forum, Thompson revealed the following: 
"In 1969, AT&T had just terminated their work with the 
GE/Honeywell/AT&T Multics project. Brian and I had just started working with 
an early release of Pascal from Professor Niklaus Wirth's ETH labs in 
Switzerland and we were impressed with its elegant simplicity and power. Dennis 
had just finished reading "Bored of the Rings", a hilarious National Lampoon 
parody of the great Tolkien "Lord of the Rings" trilogy. As a lark, we decided 
to do parodies of the Multics environment and Pascal. Dennis and I were 
responsible for the operating environment. We looked at Multics and designed the 
new system to be as complex and cryptic as possible to maximize casual users' 
frustration levels, calling it Unix as a parody of Multics, as well as other 
more risque allusions. Then Dennis and Brian worked on a truly warped version of 
Pascal, called "A". When we found others were actually trying to create real 
programs with A, we quickly added additional cryptic features and evolved into 
B, BCPL and finally C. We stopped when we got a clean compile on the following 
syntax: 
for(;P("\n"),R--;P("|")) for(e=C;e--;P("_"+(*u++/8)%2)) 
P("|"+(*u/4)%2); 
To think that modern programmers would try to use a language that allowed 
such a statement was beyond our comprehension! We actually thought of selling 
this to the Soviets to set their computer science progress back 20 or more 
years. Imagine our surprise when AT&T and other US corporations actually 
began trying to use Unix and C! It has taken them 20 years to develop enough 
expertise to generate even marginally useful applications using this 1960's 
technological parody, but we are impressed with the tenacity (if not common 
sense) of the general Unix and C programmer. In any event, Brian, Dennis and I 
have been working exclusively in Pascal on the Apple Macintosh for the past few 
years and feel really guilty about the chaos, confusion and truly bad 
programming that have resulted from our silly prank so long ago." 
Major Unix and C vendors and customers, including AT&T, Microsoft, 
Hewlett-Packard, GTE, NCR, and DEC have refused comment at this time. Borland 
International, a leading vendor of Pascal and C tools, including the popular 
Turbo Pascal, Turbo C and Turbo C++, stated they had suspected this for a number 
of years and would continue to enhance their Pascal products and halt further 
efforts to develop C. An IBM spokesman broke into uncontrolled laughter and had 
to postpone a hastily convened news conference concerning the fate of the 
RS-6000, merely stating "VM will be available Real Soon Now." In a cryptic 
statement, Professor Wirth of the ETH institute and father of the Pascal, Modula 
2, and Oberon structured languages, merely stated that P. T. Barnum was correct. 

In a related late-breaking story, usually reliable sources are stating that a 
similar confession may be forthcoming from William Gates concerning the MS-DOS 
and Windows operating environments. And IBM spokesman have begun denying that 
the Virtual Machine (VM) product is an internal prank gone awry. 

Re: Foxbase to Oracle

[Greg Moore]

On Tom Kyte's site asktom.oracle.com he had a question about the cost of
Oracle vs. SQL Server.   The upshot was that Oracle offers some fairly
inexpensive options for small applications.

"Oracle SE with small numbers of users is very inexpensive.  You are looking
at $1,500 USD for 5 named users."

The topic generated quite a bit of discussion and comparison of the two
databases.

I

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Download site for Oracle 9.2.0.1 Upgrade

[Alessandro Guimaraes]

Carle
http://otn.oracle.com/software/products/oracle9i/content.html

Alessandro
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 2:09 PM


Hi,

Where can I find the site to download the 9.2.0.1 upgrade. We currently
have 9.0.1'


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alessandro Guimaraes
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table Naming Conventions

[Rachel Carmichael]

Cary,

you said 
"* Don't embed the object type in the object's name. I used to see this
all the time with tablespaces called XYZ_TS, indexes called IND_THING,
and so on."

what's your logic behind that? 

Rachel



--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> Here's a start. Not a checklist by any means, just kind of a micro
> pet
> peeves list.
> 
> * Decide today whether table names will be singular or plural. Do you
> want a THING (singular) table? Or a THINGS (plural) table?
> 
> * Don't use case-sensitive names. E.g., use THING (without quotes) in
> your CREATE (DDL) statement, which can be spelled "THING", "thing",
> "Thing", or even "tHiNG" in your developers' SQL. But don't make
> developers type stuff like this...
> 
> select "Name" from "Thing" where "Id" = y  /* won't work without
> ""
> */
> 
> * Don't embed the object type in the object's name. I used to see
> this
> all the time with tablespaces called XYZ_TS, indexes called
> IND_THING,
> and so on.
> 
> * Decide today whether you want to abbreviate or not. If you do, then
> construct a formal, standard, consistent list of accepted
> abbreviations.
> Don't name one table CUSTOMER_THING and another CUST_HISTORY.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - NCOAUG Training Day, Aug 16 Chicago
> - Miracle Database Forum, Sep 20-22 Middlefart Denmark
> - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12
> Dallas
> 
> 
> 
> -Original Message-
> Chambers
> Sent: Tuesday, July 30, 2002 3:37 PM
> To: Multiple recipients of list ORACLE-L
> 
> All...
> 
> Will some of you please provide some insight on your table naming
> conventions?  I'm in the very early planning stages of what will
> likely
> be a large and complex schema (IT asset inventory).  I have a chance
> to
> start it correctly.  TIA
> 
> Gary Chambers
> 
> //-
> // Lucent Technologies GIO/Unix
> // 4 Robbins Road, Westford, MA 01886
> // 978-399-0481 / 888-480-6924 (Pager)
> // Nothing fancy and nothing Microsoft
> //-
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Gary Chambers
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Cary Millsap
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Slightly OT: Chart generation tool for db monitoring scripts

[STEVE OLLIG]

Ethan - I empathize with some of the monitoring issues you had trouble with.
In a former life I was tasked with implementing a custom monitoring system
for a shop with over 150 database servers.  In fact - we dedicated a server
to monitoring the others.  A couple tips that saved us a lot of time:

- read the data dictionary for everything (tablespace names, file names,
users, etc).  gather appropriate metrics for the "things" you find in each
instance.
- implement a servers list (table or file) complete with login information
for each instance.  have all your monitoring scripts reference that list of
servers to be monitored.  add a server to the list and viola - you'll soon
have metrics for it.

we used perl, cron, & a Sybase database (we were monitoring Sybase) to make
it all work.  perl cgi & apache to display the data.  sendmail and my least
favorite, an interface to the pager software for alerts.

i thought it was pretty slick.  in fact, i was at a party this weekend and
witnessed one of my scripts page the on-call DBA.  so i know they still use
it ;)

-Original Message-
Sent: Tuesday, July 30, 2002 3:46 PM
To: Multiple recipients of list ORACLE-L
scripts


Actually it isn't that hard.

1. Stuff your data every "N" minutes into a table with time stamp.

2. Aggregate data every "N" hours and stuff in other tables (weekly,
monthly, yearly).  I wrote some functions that round time to nearest half
hour, two hours etc...to make this easy.

3. Delete old data from all tables every so often.

The trouble I ran into designing my own system was to have a system that is
able to do the following.

* Allow one system to monitor multiple systems across db links.,
* Allow easy configuration, especially for things that are different across
databases (file names, tablespace names, etc)
* All alerting for upper, lower thresholds, also for other thresholds like
percentage above or below average.
* Tracking averages (I choose to roll my averages into 7 24 hours days, I
can quickly see what metrics are currently over average for any particular
hour during the day and can average my averages across weekdays, hours
etc..When I have a performance problem I usually look at two things, my top
sessions (I have posted top.sql previously) and then I see what metrics are
over average.
* Email/logging integration.
* Displaying the data.

There were many other problems I came across.  But any project tends to grow
and grow over time.  

As far as aggregating your data it is pretty easy to do.

Ethan Post
perotdba (AIM), epost1 (Yahoo)



-Original Message-
Sent: Tuesday, July 30, 2002 3:22 PM
To: Multiple recipients of list ORACLE-L
scripts


If I can write good SQL to roll up data ... and still generate the charts
... is that a bad thing?

I get your point, but right now, I can't get MRTG working without a web
server, and I was looking for a pure file system based solution.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, July 30, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L
scripts



Think about how you will roll the trend data up over time.  That is
usually the real killer task.  That is why you got people talking
mrtg, because it is the poor man's solution to that problem.  At least
it is one wheel that has already been invented at the right price.

The snapshots you are making are really not that valuable, but they
are better then a stick in the eye.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: STEVE OLLIG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You 

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Whittle Jerome Contr NCI]

Title: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran DBA






Ha! I use to bang rocks together in sea water so that the sand could be used to make the first silicon chip 1,000,000 years later.

Of course that was in my younger days..


Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   kkennedy [SMTP:[EMAIL PROTECTED]]


Who's got time for an abacus?  It takes a lot of effort to chisel those bits into the stone tablets.  Used to take a lot longer before I got my electric chisel 8-)

Kevin Kennedy

First Point Energy Corporation


If you take RAC out of Oracle you get OLE!  What can this mean?



-Original Message-

Sent: Tuesday, July 30, 2002 12:46 PM


 Here we go again. So who's gonna be the first one with the abacus

joke this time?


--Walt (who makes Rachel look like a spring chicken) Weaver

  Bozeman, Montana


-Original Message-

Sent: Tuesday, July 30, 2002 1:20 PM


Hex editor? geez you youngsters have it soft, in MY day we ran magnets

over the disks to encode the "ones" and "zeros"   :)


--- [EMAIL PROTECTED] wrote:

> No, I use a hex editor and directly write the bits to disk.

> 

> Isn't that the way everyone here does it?

> 

> Jared

> 

> "Straub, Dan" <[EMAIL PROTECTED]>

> 

> 

> > > 

> > > ...hardcore DBAs might never use GUI tools. 

> > > 

> > 

> > I fit that category.  :) 

> > 

> What about the OUI? Don't you use that? :) 

> Dan. 

RE: Table Naming Conventions

[Paula_Stankus]

Title: RE: Table Naming Conventions





My supervisor/client wants object types in names - except tables like I_ for indexes.  Why do you say stay away from this?

-Original Message-
From: Cary Millsap [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 5:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Table Naming Conventions



Here's a start. Not a checklist by any means, just kind of a micro pet
peeves list.


* Decide today whether table names will be singular or plural. Do you
want a THING (singular) table? Or a THINGS (plural) table?


* Don't use case-sensitive names. E.g., use THING (without quotes) in
your CREATE (DDL) statement, which can be spelled "THING", "thing",
"Thing", or even "tHiNG" in your developers' SQL. But don't make
developers type stuff like this...


    select "Name" from "Thing" where "Id" = y  /* won't work without ""
*/


* Don't embed the object type in the object's name. I used to see this
all the time with tablespaces called XYZ_TS, indexes called IND_THING,
and so on.


* Decide today whether you want to abbreviate or not. If you do, then
construct a formal, standard, consistent list of accepted abbreviations.
Don't name one table CUSTOMER_THING and another CUST_HISTORY.



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com


Upcoming events:
- NCOAUG Training Day, Aug 16 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas




-Original Message-
Chambers
Sent: Tuesday, July 30, 2002 3:37 PM
To: Multiple recipients of list ORACLE-L


All...


Will some of you please provide some insight on your table naming
conventions?  I'm in the very early planning stages of what will likely
be a large and complex schema (IT asset inventory).  I have a chance to
start it correctly.  TIA


Gary Chambers


//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Chambers
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ORA-1658 even though there is enough contig free

[Jesse, Rich]

Hi all,

On 8.1.7.2.0 on HP/UX 11.0, I need to create an index online.  So, I see how
much space I have:

select max(bytes/1024/1024)
from dba_free_space
where tablespace_name = 'MY_IDX_TS';

...and it returns "147.3475".  So I create my index:

CREATE INDEX myschema.mycoolidx
 ON myschema.mycooltbl(mycoolcol) PCTFREE 15
STORAGE(
INITIAL 140 M
NEXT 30 M
)
NOLOGGING ONLINE TABLESPACE my_idx_ts PARALLEL 2;

But I keep getting "ORA-01658 unable to create initial extent in MY_IDX_TS",
even though there is ample room.  I thought it was because I had originally
tried it with "PARALLEL 2" and there was some overhead needed, so I
coalesced the TS (DICTIONARY, obviously) and tried it without the PARALLEL
to no avail.  I've even dropped the INITIAL down to 130M without luck (again
after coalescing).  Oh, to be LOCAL...

So, how big can I make the initial extent?  I don't remember running into
this before and I can't find anything on MetaLink.  And of course, I killed
the session when it was creating it so now I can't drop the index without a
ORA-8104 error.

Anyone?

TIA!
Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why DB_Name 4 chars only.

[Gene Sais]

My std. also, 4 chars for db with last char denoting db use (Production, Test, 
Development, Training, etc.). I started on VMS Oracle 6, seemed to be the case back 
then, still hold to it.  I used to have dns aliases for db names, VMS node name limit 
was 6 chars.  For example:

Payroll DB Names
—---
payp=Prod
payt=Test
payd=Development
...

Payroll DB Server Names
—---
paypdb=Prod DB Server DNS Alias
paytdb=Test DB Server DNS Alias
payddb=Development DB Server DNS Alias
...


This worked well before oracle names.  Move a db, make a DNS change, done.  Old habits 
are hard to break, never had a need to :)

fwiw,
Gene

>>> [EMAIL PROTECTED] 07/30/02 04:22PM >>>
We have SIDs 9 chars long!

Ron SMith

-Original Message-
Sent: Tuesday, July 30, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L


Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the reason behind
db_name 4 chars only. Is it a common practice to keep
SID/db_name/instance name parameters same (for example
PBDS).

thanks
Srinivas


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Srinivas
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Download site for Oracle 9.2.0.1 Upgrade

[Carle, William T (Bill), ALCAS]

Hi,

Where can I find the site to download the 9.2.0.1 upgrade. We currently have 9.0.1'


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Importing .dbf files into Oracle

[Carle, William T (Bill), ALCAS]

Hi,

Is it possible to import .dbf files that were created in dbase III+ into Oracle?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALCAS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Table Naming Conventions

[Cary Millsap]

Here's a start. Not a checklist by any means, just kind of a micro pet
peeves list.

* Decide today whether table names will be singular or plural. Do you
want a THING (singular) table? Or a THINGS (plural) table?

* Don't use case-sensitive names. E.g., use THING (without quotes) in
your CREATE (DDL) statement, which can be spelled "THING", "thing",
"Thing", or even "tHiNG" in your developers' SQL. But don't make
developers type stuff like this...

select "Name" from "Thing" where "Id" = y  /* won't work without ""
*/

* Don't embed the object type in the object's name. I used to see this
all the time with tablespaces called XYZ_TS, indexes called IND_THING,
and so on.

* Decide today whether you want to abbreviate or not. If you do, then
construct a formal, standard, consistent list of accepted abbreviations.
Don't name one table CUSTOMER_THING and another CUST_HISTORY.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- NCOAUG Training Day, Aug 16 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas



-Original Message-
Chambers
Sent: Tuesday, July 30, 2002 3:37 PM
To: Multiple recipients of list ORACLE-L

All...

Will some of you please provide some insight on your table naming
conventions?  I'm in the very early planning stages of what will likely
be a large and complex schema (IT asset inventory).  I have a chance to
start it correctly.  TIA

Gary Chambers

//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Chambers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Host System Commands from PL/SQL blocks

[Babu . Nagarajan]

Take a look at Doc Id 50868.1 on metalink

Babu




John Weatherman <[EMAIL PROTECTED]>@fatcity.com on
07/30/2002 02:56:37 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old
question...

I need to execute a system call from within a PL/SQL block.  Specifically,
I am looking at starting out report request demons as part of a post
startup
trigger.  Help?

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Why DB_Name 4 chars only.

[Rajesh . Rao]

For most unix Platforms, the SID can be upto 8 characters in length. For
NT, I think, it should be 4 mainly because of DOS file name limitations. I
dont have the resources on hand, but I guess one could confirm this by just
trying to mount an instance with varying SID Names, until you get the error
: ORA-27034 skgfrcre: maximum length of ORACLE_SID exceeded

Also, this is from a Steve Adams post on this subject, that I found on
comp.databases.oracle :

Internally, Oracle allows 9 bytes for the database name and 16 bytes for
the instance name. These are null terminated strings, so the available
length is one less.  For the instance name, all characters, even beyond 15
are significant for distinguishing instances, but if an instance name
exceeds 15 characters Oracle gives up and does not record its name
internally at all. This is fine in a single instance configuration, but I
would not be confident to try it in an OPS environment, although logic says
that it should be OK.

Regards
Raj




   
  
"Igor Neyman"  
  

ptron.com>cc:  
  
Sent by:  Subject: Re: Why DB_Name 4 chars only.   
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
July 30, 2002  
  
04:31 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Database name is limited to 9 characters, see "name" column in v$database.
Instance name is limited to 181 characters (at least according to inst_name
in v$active_instances).

All this under 8.1.5.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 4:08 PM


> Hi,
> What is the reason behind DB_Name/SID usually 4 chars
> length only. I have a customer who is asking us to
> create instance/db with 6 chars length. We usually
> keep instance name and db_name parameters same in .ora
> file. Can someone please explain the reason behind
> db_name 4 chars only. Is it a common practice to keep
> SID/db_name/instance name parameters same (for example
> PBDS).
>
> thanks
> Srinivas


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why DB_Name 4 chars only.

[Straub, Dan]

Title: RE: Why DB_Name 4 chars only.





> 
> What is the reason behind DB_Name/SID usually 4 chars
> length only. I have a customer who is asking us to
> create instance/db with 6 chars length. We usually
> keep instance name and db_name parameters same in .ora
> file. Can someone please explain the reason behind
> db_name 4 chars only. Is it a common practice to keep
> SID/db_name/instance name parameters same (for example
> PBDS).
> 


Only a limitation on NT. We use up to 8 characters for UNIX.


From Metalink doc 48681.1:


"The SID should consist of four or fewer alphanumeric characters. This is to avoid problems with filename length restrictions on some platforms, e.g. the 8.3 restriction on DOS, which is still present on NT if using DOS-style names (which Oracle requires). So the initialization file for a database called ORCL will be called initORCL.ora, representing the longest possible filename."

HTH,
Dan Straub
McKesson Information Solutions
541-681-8278
44°03'N 123°05'W (or thereabouts)
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

RE: Slightly OT: Chart generation tool for db monitoring scripts

[Post, Ethan]

Actually it isn't that hard.

1. Stuff your data every "N" minutes into a table with time stamp.

2. Aggregate data every "N" hours and stuff in other tables (weekly,
monthly, yearly).  I wrote some functions that round time to nearest half
hour, two hours etc...to make this easy.

3. Delete old data from all tables every so often.

The trouble I ran into designing my own system was to have a system that is
able to do the following.

* Allow one system to monitor multiple systems across db links.,
* Allow easy configuration, especially for things that are different across
databases (file names, tablespace names, etc)
* All alerting for upper, lower thresholds, also for other thresholds like
percentage above or below average.
* Tracking averages (I choose to roll my averages into 7 24 hours days, I
can quickly see what metrics are currently over average for any particular
hour during the day and can average my averages across weekdays, hours
etc..When I have a performance problem I usually look at two things, my top
sessions (I have posted top.sql previously) and then I see what metrics are
over average.
* Email/logging integration.
* Displaying the data.

There were many other problems I came across.  But any project tends to grow
and grow over time.  

As far as aggregating your data it is pretty easy to do.

Ethan Post
perotdba (AIM), epost1 (Yahoo)



-Original Message-
Sent: Tuesday, July 30, 2002 3:22 PM
To: Multiple recipients of list ORACLE-L
scripts


If I can write good SQL to roll up data ... and still generate the charts
... is that a bad thing?

I get your point, but right now, I can't get MRTG working without a web
server, and I was looking for a pure file system based solution.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, July 30, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L
scripts



Think about how you will roll the trend data up over time.  That is
usually the real killer task.  That is why you got people talking
mrtg, because it is the poor man's solution to that problem.  At least
it is one wheel that has already been invented at the right price.

The snapshots you are making are really not that valuable, but they
are better then a stick in the eye.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why DB_Name 4 chars only.

[DENNIS WILLIAMS]

Srinivas
   Some systems have trouble with long identifiers. The SID gets various
prefixes and postfixes, and if you have a long SID this can cause problems
for systems that have restrictions on identifiers. An example is the server
processes. This can cause issues on client platforms that are networked to
your server. That is why Oracle has recommended keeping the SID short. You
don't say what platform you are on, so I don't know if it applies to your
system. Safe bet that 6 isn't likely to cause severe problems.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 30, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L


Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the reason behind
db_name 4 chars only. Is it a common practice to keep
SID/db_name/instance name parameters same (for example
PBDS).

thanks
Srinivas


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srinivas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Farnsworth, Dave]

At least you had a light console.

-Original Message-
Sent: Tuesday, July 30, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L


coding?  ha!  I used to flip switches to load my programs directly into core
memory!  and then I had to read the results from the light console!  up-hill
both-ways in a snow-storm!


-Original Message-
Sent: Tuesday, July 30, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L


Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the "ones" and "zeros"   :)



--- [EMAIL PROTECTED] wrote:
> No, I use a hex editor and directly write the bits to disk.
> 
> Isn't that the way everyone here does it?
> 
> Jared
> 
> 
> 
> 
> 
> "Straub, Dan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 10:25 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Guys:  Is this worth $1,749 for 8 year
> Oracle veteran DBA
> 
> 
> > > 
> > > ...hardcore DBAs might never use GUI tools. 
> > > 
> > 
> > I fit that category.  :) 
> > 
> What about the OUI? Don't you use that? :) 
> Dan. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why DB_Name 4 chars only.

[Ron Thomas]

This relates back to the dos days (break out that chisel).  8.3 filename format 
requires a sid less
than 5 characters, eg, init.ora

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The problem with some people is that when they aren't drunk, they're sober."  
--William Butler
Yeats.


   

  [EMAIL PROTECTED]  

  Sent by: To:   [EMAIL PROTECTED]  

  [EMAIL PROTECTED] cc: 

   Subject:  RE: Why DB_Name 4 chars only. 

   

  07/30/02 01:22 PM

  Please respond to

  ORACLE-L 

   

   





We have SIDs 9 chars long!

Ron SMith

-Original Message-
Sent: Tuesday, July 30, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L


Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the reason behind
db_name 4 chars only. Is it a common practice to keep
SID/db_name/instance name parameters same (for example
PBDS).

thanks
Srinivas


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Srinivas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Why DB_Name 4 chars only.

[Rodd Holman]

You can go to 8.  We use up to 8 character SID's here.  I have tried going 9 on an 8.0.5

system and it barfed on the create scripts.



Rodd



On Tue, 2002-07-30 at 15:08, Srinivas wrote:

Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the reason behind
db_name 4 chars only. Is it a common practice to keep
SID/db_name/instance name parameters same (for example
PBDS).

thanks
Srinivas


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srinivas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Table Naming Conventions

[Gary Chambers]

All...

Will some of you please provide some insight on your table naming
conventions?  I'm in the very early planning stages of what will likely
be a large and complex schema (IT asset inventory).  I have a chance to
start it correctly.  TIA

Gary Chambers

//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Chambers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Fink, Dan]

To be more accurate, a sequence does not even have to be used for a table.
It is a construct to populate a variable (could be a table column, could be
run time) with a number that is generated in a specific order (though it may
contain gaps).

Dan (as he ducks a knitting needle).

-Original Message-
Sent: Tuesday, July 30, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L


Cherie,

Terminology --  make sure they understand that sequences are not
created attached to any table and can be used for more than one table. 

Rachel

--- [EMAIL PROTECTED] wrote:
> 
> Dan,
> 
> Haven't heard the why yet but I think it may be just a poorly worded
> request.   I suspect he wants the sequences created on another table
> and
> just wants to be able to select from dual.   Maybe he never realized
> that
> the sequences were actually created on another table.Maybe he
> actually
> thought that the sequences were created on the DUAL table since he
> only
> ever used them by selecting from DUAL.   Our developers run quite a
> wide
> gamut and I don't work very regularly with this one so it's hard to
> know
> where he's coming from.   Still trying to get him on the phone.
> 
> Thanks for this info about performance on DUAL.  I will pass the info
> on.
> Thanks to everyone for getting us all on the same page.   I'm sure
> that
> once I talk this out with him, it'll be straightened out quickly.
> 
> Cherie
> 
> 
>  
>   
> "Fink, Dan"  
>   
>  "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,   
> com> 
> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>  
> 
>  cc: 
>   
> 07/30/02 12:46   Subject: RE: Creating
> sequences on the DUAL table? 
> PM   
>   
>  
>   
>  
>   
> 
> 
> 
> 
> Cherie,
>My first response is 'WHY?'. Do they mean that they want
> to
> create 2
> new sequences and use the DUAL table to retrieve the values? It will
> cause
> performance problems and there are better solutions. I have some
> information
> on the performance implications of DUAL at
> http://www.optimaldba.com/internals/oraint_dual.html.
> 
> Dan Fink
> 
> -Original Message-
> Sent: Tuesday, July 30, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> I have a request from one of our developers to create two new
> sequences on
> the DUAL table.
> 
> This seems like a bad idea to me.   I've never had such a request in
> the
> past.   I asked for clarification on why this is needed and I didn't
> get a
> lot of details yet.
> 
> Is this something that is standard operating procedure?   My
> understanding
> that interfacing with the DUAL table is usually inviting poor
> performance.
> Plus, I don't like to mess around with system tables, in general.
> 
> Under what circumstances would it be justified to create sequences on
> the
> DUAL table?   Should I just flat-out refuse this request and if so,
> why?
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for oth

Re: Host System Commands from PL/SQL blocks

[Igor Neyman]

You have to write an external stored procedure (C, C++, Java) and call it
from your PL/SQL block.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 3:56 PM


> OK, I checked Google and my own old mail and I know I've seen this here
> before, but can't find my notes, so please forgive this same old
question...
>
> I need to execute a system call from within a PL/SQL block.  Specifically,
> I am looking at starting out report request demons as part of a post
startup
> trigger.  Help?
>
> TIA,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Why DB_Name 4 chars only.

[Igor Neyman]

Database name is limited to 9 characters, see "name" column in v$database.
Instance name is limited to 181 characters (at least according to inst_name
in v$active_instances).

All this under 8.1.5.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 4:08 PM


> Hi,
> What is the reason behind DB_Name/SID usually 4 chars
> length only. I have a customer who is asking us to
> create instance/db with 6 chars length. We usually
> keep instance name and db_name parameters same in .ora
> file. Can someone please explain the reason behind
> db_name 4 chars only. Is it a common practice to keep
> SID/db_name/instance name parameters same (for example
> PBDS).
>
> thanks
> Srinivas
>
>
> __
> Do You Yahoo!?
> Yahoo! Health - Feel better, live better
> http://health.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Srinivas
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Slightly OT: Chart generation tool for db monitoring scripts

[Jamadagni, Rajendra]

If I can write good SQL to roll up data ... and still generate the charts
... is that a bad thing?

I get your point, but right now, I can't get MRTG working without a web
server, and I was looking for a pure file system based solution.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, July 30, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L
scripts



Think about how you will roll the trend data up over time.  That is
usually the real killer task.  That is why you got people talking
mrtg, because it is the poor man's solution to that problem.  At least
it is one wheel that has already been invented at the right price.

The snapshots you are making are really not that valuable, but they
are better then a stick in the eye.



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[kkennedy]

Who's got time for an abacus?  It takes a lot of effort to chisel those bits into the 
stone tablets.  Used to take a lot longer before I got my electric chisel 8-)

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?


-Original Message-
Sent: Tuesday, July 30, 2002 12:46 PM
To: Multiple recipients of list ORACLE-L


 Here we go again. So who's gonna be the first one with the abacus
joke this time?

--Walt (who makes Rachel look like a spring chicken) Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, July 30, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L


Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the "ones" and "zeros"   :)



--- [EMAIL PROTECTED] wrote:
> No, I use a hex editor and directly write the bits to disk.
> 
> Isn't that the way everyone here does it?
> 
> Jared
> 
> 
> 
> 
> 
> "Straub, Dan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 10:25 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Guys:  Is this worth $1,749 for 8 year
> Oracle veteran DBA
> 
> 
> > > 
> > > ...hardcore DBAs might never use GUI tools. 
> > > 
> > 
> > I fit that category.  :) 
> > 
> What about the OUI? Don't you use that? :) 
> Dan. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why DB_Name 4 chars only.

[Smith, Ron L.]

We have SIDs 9 chars long!

Ron SMith

-Original Message-
Sent: Tuesday, July 30, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L


Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the reason behind
db_name 4 chars only. Is it a common practice to keep
SID/db_name/instance name parameters same (for example
PBDS).

thanks
Srinivas


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srinivas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Why DB_Name 4 chars only.

[Srinivas]

Hi,
What is the reason behind DB_Name/SID usually 4 chars
length only. I have a customer who is asking us to
create instance/db with 6 chars length. We usually
keep instance name and db_name parameters same in .ora
file. Can someone please explain the reason behind
db_name 4 chars only. Is it a common practice to keep
SID/db_name/instance name parameters same (for example
PBDS).

thanks
Srinivas


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srinivas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Rachel Carmichael]

Cherie,

Terminology --  make sure they understand that sequences are not
created attached to any table and can be used for more than one table. 

Rachel

--- [EMAIL PROTECTED] wrote:
> 
> Dan,
> 
> Haven't heard the why yet but I think it may be just a poorly worded
> request.   I suspect he wants the sequences created on another table
> and
> just wants to be able to select from dual.   Maybe he never realized
> that
> the sequences were actually created on another table.Maybe he
> actually
> thought that the sequences were created on the DUAL table since he
> only
> ever used them by selecting from DUAL.   Our developers run quite a
> wide
> gamut and I don't work very regularly with this one so it's hard to
> know
> where he's coming from.   Still trying to get him on the phone.
> 
> Thanks for this info about performance on DUAL.  I will pass the info
> on.
> Thanks to everyone for getting us all on the same page.   I'm sure
> that
> once I talk this out with him, it'll be straightened out quickly.
> 
> Cherie
> 
> 
>  
>   
> "Fink, Dan"  
>   
>  "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,   
> com> 
> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>  
> 
>  cc: 
>   
> 07/30/02 12:46   Subject: RE: Creating
> sequences on the DUAL table? 
> PM   
>   
>  
>   
>  
>   
> 
> 
> 
> 
> Cherie,
>My first response is 'WHY?'. Do they mean that they want
> to
> create 2
> new sequences and use the DUAL table to retrieve the values? It will
> cause
> performance problems and there are better solutions. I have some
> information
> on the performance implications of DUAL at
> http://www.optimaldba.com/internals/oraint_dual.html.
> 
> Dan Fink
> 
> -Original Message-
> Sent: Tuesday, July 30, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> I have a request from one of our developers to create two new
> sequences on
> the DUAL table.
> 
> This seems like a bad idea to me.   I've never had such a request in
> the
> past.   I asked for clarification on why this is needed and I didn't
> get a
> lot of details yet.
> 
> Is this something that is standard operating procedure?   My
> understanding
> that interfacing with the DUAL table is usually inviting poor
> performance.
> Plus, I don't like to mess around with system tables, in general.
> 
> Under what circumstances would it be justified to create sequences on
> the
> DUAL table?   Should I just flat-out refuse this request and if so,
> why?
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- 

Host System Commands from PL/SQL blocks

[John Weatherman]

OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old question...

I need to execute a system call from within a PL/SQL block.  Specifically,
I am looking at starting out report request demons as part of a post startup
trigger.  Help?

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: <> causing full table scan

[Richard Huntley]

bp, 
indexes are used when limiting conditions are equalities not inequalities 
(<>, !=, NOT IN)
How 
about rewriting the query to replace the  <> by an outer 
join.
 
-Original Message-From: BigP 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 30, 2002 3:20 
PMTo: Multiple recipients of list ORACLE-LSubject: 
<> causing full table scan
Hi list ,
In one of my queries if I use <> in where 
clause it is causing full table scan .  If i use "IN " (  ) it uses 
index . Actually if it is" <> " the it is doing hash join and if "IN" 
then nested loop . 
when i make opt_indx_cost_adj to 5 it starts using 
index again with <> condition .
Is there a way i can cause it to use index ( yeah i 
can use hints . )  ? anything else ..
-bp
 
 
 
 

RE: Creating sequences on the DUAL table?

[Cherie_Machler]

Mladen,

Thanks for everyone's response on this.

I think that this is just a misperception on the part of the developer.   I
took the phrase verbatim from his change request.   I suspect that he has
only ever used sequences in the  SELECT from DUAL statement so he thinks
that they are actual objects associated with dual.   I'll clear it up once
I get him on the phone.   Just wanted to make sure that this wasn't some
weird new thing that I'd just never heard off.

Cherie


   
 
"Gogala,   
 
Mladen"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
 Subject: RE: Creating sequences on the 
DUAL table? 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
07/30/02 02:15 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




What are "sequence on the table"? All I know about sequences
is that they are entities for fas generation of unique numbers
without encountering locks. They are standalone entries without
much connection to any other object.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 1:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Creating sequences on the DUAL table?
>
>
>
> I have a request from one of our developers to create two new
> sequences on
> the DUAL table.
>
> This seems like a bad idea to me.   I've never had such a
> request in the
> past.   I asked for clarification on why this is needed and I
> didn't get a
> lot of details yet.
>
> Is this something that is standard operating procedure?   My
> understanding
> that interfacing with the DUAL table is usually inviting poor
> performance.
> Plus, I don't like to mess around with system tables, in general.
>
> Under what circumstances would it be justified to create
> sequences on the
> DUAL table?   Should I just flat-out refuse this request and
> if so, why?
>
> Thanks,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Weaver, Walt]

 Here we go again. So who's gonna be the first one with the abacus
joke this time?

--Walt (who makes Rachel look like a spring chicken) Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, July 30, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L


Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the "ones" and "zeros"   :)



--- [EMAIL PROTECTED] wrote:
> No, I use a hex editor and directly write the bits to disk.
> 
> Isn't that the way everyone here does it?
> 
> Jared
> 
> 
> 
> 
> 
> "Straub, Dan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 10:25 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Guys:  Is this worth $1,749 for 8 year
> Oracle veteran DBA
> 
> 
> > > 
> > > ...hardcore DBAs might never use GUI tools. 
> > > 
> > 
> > I fit that category.  :) 
> > 
> What about the OUI? Don't you use that? :) 
> Dan. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Foxbase to Oracle - Thanks

[dmeng]

Looks like most of the replies point to VFP. I will present this to my
manager. Thanks to all who replied!

Dennis Meng
Database Administrator
Focal Communications Corp.


   
  
  "Karniotis, Stephen" 
  
  
  puware.com>cc:   
  
  Sent by:   Subject: RE: Foxbase to Oracle
  
  [EMAIL PROTECTED] 
  
   
  
   
  
  07/30/02 12:44 PM
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




Dennis:

   Foxbase was originally called 10-base before Fox Systems change the
name.
Foxbase was changed to FoxPro and then purchased by Microsoft and called
Microsoft FoxPro, and then Microsoft Visual FoxPro.  I would highly
recommend investigating the MSFT solution.  Sorry guys, but this is a
realistic solution.  Oracle, for eight users, will probably cost too much
for the implementation.

   If you need to convert to Oracle, do the following:
1. Convert to FoxPro
2. Bridge Visual FoxPro to SQLServer and use the Data Transformation
Services (DTS) to migrate the data to Oracle.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct:(248) 865-4350
Mobile:(248) 408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com

 -Original Message-
Sent:Tuesday, July 30, 2002 12:09 PM
To:  Multiple recipients of list ORACLE-L

Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very tight and
this application has only about 8 users max. My question is - does Oracle
provide a good tool for migration from Foxbase? This is a small application
and have only about a dozen tables, my main challenge would be the
application code.
If Oracle turns out to be too expensive, what is the least expensive, least
painful migration path? Another attractive option seems to be Visual
FoxPro, which I know little about.   I want to bounce it off the list first
before we make the choice.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or
disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, sen

RE: Creating sequences on the DUAL table?

[Kevin Lange]

I would think they probably saw something like 

  select sequence_name.nextval from dual;

Maybe they thought the sequence and dual were connected in some manner.

-Original Message-
Sent: Tuesday, July 30, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L


Cherie,

You don't create sequences on a table, they are objects in and of
themselves.

So you can create the sequences for the developers but I'm
wondering where they got the notion that sequences were created on a
table. And why they want to use DUAL.

Rachel
--- [EMAIL PROTECTED] wrote:
> 
> I have a request from one of our developers to create two new
> sequences on
> the DUAL table.
> 
> This seems like a bad idea to me.   I've never had such a request in
> the
> past.   I asked for clarification on why this is needed and I didn't
> get a
> lot of details yet.
> 
> Is this something that is standard operating procedure?   My
> understanding
> that interfacing with the DUAL table is usually inviting poor
> performance.
> Plus, I don't like to mess around with system tables, in general.
> 
> Under what circumstances would it be justified to create sequences on
> the
> DUAL table?   Should I just flat-out refuse this request and if so,
> why?
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Lyuda Hoska]

Cherie,
If you push F1 key from SqlPlus there will be a complete explanation called
'all about sequences and how to create them on dual table'.

-Original Message-
Sent: Tuesday, July 30, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Dan,

Haven't heard the why yet but I think it may be just a poorly worded
request.   I suspect he wants the sequences created on another table and
just wants to be able to select from dual.   Maybe he never realized that
the sequences were actually created on another table.Maybe he actually
thought that the sequences were created on the DUAL table since he only
ever used them by selecting from DUAL.   Our developers run quite a wide
gamut and I don't work very regularly with this one so it's hard to know
where he's coming from.   Still trying to get him on the phone.

Thanks for this info about performance on DUAL.  I will pass the info on.
Thanks to everyone for getting us all on the same page.   I'm sure that
once I talk this out with him, it'll be straightened out quickly.

Cherie


 

"Fink, Dan"

,   
com>  "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>   
 cc:

07/30/02 12:46   Subject: RE: Creating sequences
on the DUAL table? 
PM

 

 





Cherie,
   My first response is 'WHY?'. Do they mean that they want to
create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some
information
on the performance implications of DUAL at
http://www.optimaldba.com/internals/oraint_dual.html.

Dan Fink

-Original Message-
Sent: Tuesday, July 30, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyuda Hoska
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[johanna . doran]

Every single message I get on this post gets blocked:>
Can't tell you but how I am wondering what is being said!



-Original Message-
Sent: Tuesday, July 30, 2002 3:07 PM
To: Multiple recipients of list ORACLE-L


The original message content contained a virus or was blocked due to blocking rules 
and has been removed. 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ODBC connection privs in Oracle

[Richard Huntley]

Title: RE: ODBC connection privs in Oracle





Privileges would be that of the account specified in the ODBC connection setup, which
are Oracle specific for the Oracle user.  What do you mean by "The privs do not appear to match Oracle-based security."?


-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
Subject: ODBC connection privs in Oracle



Can someone point out how ODBC connection privileges are set, e.g. if we
connect to Oracle using MS access?


The privs do not appear to match Oracle-based security.


I am going to search technet and Metalink now...


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services    | Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO


E-Mail: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Mercadante, Thomas F]

coding?  ha!  I used to flip switches to load my programs directly into core
memory!  and then I had to read the results from the light console!  up-hill
both-ways in a snow-storm!


-Original Message-
Sent: Tuesday, July 30, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L


Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the "ones" and "zeros"   :)



--- [EMAIL PROTECTED] wrote:
> No, I use a hex editor and directly write the bits to disk.
> 
> Isn't that the way everyone here does it?
> 
> Jared
> 
> 
> 
> 
> 
> "Straub, Dan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 10:25 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Guys:  Is this worth $1,749 for 8 year
> Oracle veteran DBA
> 
> 
> > > 
> > > ...hardcore DBAs might never use GUI tools. 
> > > 
> > 
> > I fit that category.  :) 
> > 
> What about the OUI? Don't you use that? :) 
> Dan. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Cherie_Machler]

Kevin,

Thanks for the suggestion on select statements.   I will pass them on.   I
think it's just a misunderstanding on his part as to where the sequences
are actually created.   Apparently he only uses them in a select from dual
so he thinks they reside there.

Cherie


   
  
"kkennedy" 
  

point.com>cc:  
  
Sent by:  Subject: RE: Creating sequences on the 
DUAL table? 
[EMAIL PROTECTED]
  
m  
  
   
  
   
  
07/30/02 01:28 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




H?  Sequences are not created "on" the dual table.  Sequences exist as
independent entities.  Ofttimes, sequence values are selected using the
dual table (e.g., select seqname.nextval from dual) -- this is a coding
choice.  Performance of queries that select from the dual table are
generally not "inviting poor performance" (although I've seen some postings
on how to improve their performance).

If I were you, I would do some more reading up on sequences in the Concepts
manual and not worry too much about the performance.  Suggest to the
developers that they use the sequences directly whenever possible rather
than selecting from dual as in the following:

One method:
select seqname.nextval into local_var from dual;
insert into destination_table (...id_column...) values (...local_var...);

Better method:
insert into destination_table (...id_column...) values
(...seqname.nextval...);

And, if the value is needed for other things:
insert into destination_table (...id_column...) values
(...seqname.nextval...)
   returning id_column into local_var;

HTH
Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Tuesday, July 30, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, inc

dbsnmpj access violation

[Seefelt, Beth]

Title: dbsnmpj access violation







Hi all,


I've just finished installed 9.2 on W2K.  Whenever I submit a job through the OEM console the dbsnmpj.exe process gets an access violation and the job fails to run.  When I enable tracing on dbsnmpj, it works fine.  Disable tracing and it dies again.  Has anyone seen this problem?

Thanks,


Beth

<> causing full table scan

[BigP]

Hi list ,
In one of my queries if I use <> in where 
clause it is causing full table scan .  If i use "IN " (  ) it uses 
index . Actually if it is" <> " the it is doing hash join and if "IN" 
then nested loop . 
when i make opt_indx_cost_adj to 5 it starts using 
index again with <> condition .
Is there a way i can cause it to use index ( yeah i 
can use hints . )  ? anything else ..
-bp
 
 
 
 

RE: Ids and passwords for application users

[Richard Huntley]

Title: RE: Ids and passwords for application users





Peter,


not clear on if the database is going to be used by developers doing
development work or will an application use it and you'll have up to 300
application users?


If it's an application, how about making one account that owns all of the DB
objects, another generic account on top of that which you grant access to execute
packages, select on tables, etc...so that it can access the objects owned by real account
but has limited abilities accept through privileges it's been granted. That is,


app_owner - owns all DB objects
app_user - owns no DB objects, but has restricted access to objects owned by PRODUCTION
tech_support - granted select privileges only
user1/user1, user2/user2, etc... - id's and passwords stored in a table, password encrypted


When a user needs access to the application, they give login/password as user1/user1, but the 
application uses the APP_USER account, to look in the table that stores the logins to see if the
user is valid, and if so, the application loads, if not they're denied access.


HTH



-Original Message-
From: Schauss, Peter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Ids and passwords for application users



I am in the process of designing a small database which may have
as many as 250 to 300 users.  We are reaching a stage where we need
to decide how we will control access to this database.  As I see it
we have two options:


1.  Provide a single hidden login for the entire application and control
access to the applicaiton itself either by "roll your own" security or
using the operating system (UNIX) controls.


2.  Create ids for the users in Oracle and grant them access
to the necessary tables using roles.


Any opinions or alternate suggestions?


thanks,


Peter Schauss
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Rachel Carmichael]

Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the "ones" and "zeros"   :)



--- [EMAIL PROTECTED] wrote:
> No, I use a hex editor and directly write the bits to disk.
> 
> Isn't that the way everyone here does it?
> 
> Jared
> 
> 
> 
> 
> 
> "Straub, Dan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 10:25 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Guys:  Is this worth $1,749 for 8 year
> Oracle veteran DBA
> 
> 
> > > 
> > > ...hardcore DBAs might never use GUI tools. 
> > > 
> > 
> > I fit that category.  :) 
> > 
> What about the OUI? Don't you use that? :) 
> Dan. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Cherie_Machler]

Dan,

Haven't heard the why yet but I think it may be just a poorly worded
request.   I suspect he wants the sequences created on another table and
just wants to be able to select from dual.   Maybe he never realized that
the sequences were actually created on another table.Maybe he actually
thought that the sequences were created on the DUAL table since he only
ever used them by selecting from DUAL.   Our developers run quite a wide
gamut and I don't work very regularly with this one so it's hard to know
where he's coming from.   Still trying to get him on the phone.

Thanks for this info about performance on DUAL.  I will pass the info on.
Thanks to everyone for getting us all on the same page.   I'm sure that
once I talk this out with him, it'll be straightened out quickly.

Cherie


   
 
"Fink, Dan"
 
,   
com>  "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]>   
 cc:   
 
07/30/02 12:46   Subject: RE: Creating sequences on the 
DUAL table? 
PM 
 
   
 
   
 




Cherie,
   My first response is 'WHY?'. Do they mean that they want to
create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some
information
on the performance implications of DUAL at
http://www.optimaldba.com/internals/oraint_dual.html.

Dan Fink

-Original Message-
Sent: Tuesday, July 30, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Jared . Still]

No, I use a hex editor and directly write the bits to disk.

Isn't that the way everyone here does it?

Jared





"Straub, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/30/2002 10:25 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran DBA


> > 
> > ...hardcore DBAs might never use GUI tools. 
> > 
> 
> I fit that category.  :) 
> 
What about the OUI? Don't you use that? :) 
Dan. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Gogala, Mladen]

What are "sequence on the table"? All I know about sequences
is that they are entities for fas generation of unique numbers
without encountering locks. They are standalone entries without
much connection to any other object. 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 1:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Creating sequences on the DUAL table?
> 
> 
> 
> I have a request from one of our developers to create two new 
> sequences on
> the DUAL table.
> 
> This seems like a bad idea to me.   I've never had such a 
> request in the
> past.   I asked for clarification on why this is needed and I 
> didn't get a
> lot of details yet.
> 
> Is this something that is standard operating procedure?   My 
> understanding
> that interfacing with the DUAL table is usually inviting poor 
> performance.
> Plus, I don't like to mess around with system tables, in general.
> 
> Under what circumstances would it be justified to create 
> sequences on the
> DUAL table?   Should I just flat-out refuse this request and 
> if so, why?
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Creating sequences on the DUAL table?

[Rachel Carmichael]

Cherie,

You don't create sequences on a table, they are objects in and of
themselves.

So you can create the sequences for the developers but I'm
wondering where they got the notion that sequences were created on a
table. And why they want to use DUAL.

Rachel
--- [EMAIL PROTECTED] wrote:
> 
> I have a request from one of our developers to create two new
> sequences on
> the DUAL table.
> 
> This seems like a bad idea to me.   I've never had such a request in
> the
> past.   I asked for clarification on why this is needed and I didn't
> get a
> lot of details yet.
> 
> Is this something that is standard operating procedure?   My
> understanding
> that interfacing with the DUAL table is usually inviting poor
> performance.
> Plus, I don't like to mess around with system tables, in general.
> 
> Under what circumstances would it be justified to create sequences on
> the
> DUAL table?   Should I just flat-out refuse this request and if so,
> why?
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBD::Oracle and JDBC Thin

[Jesse, Rich]

Oh fdge.  (Only I didn't say "fudge").  <10-watt bulb:on>  After
transcribing all my install problems here, I just realized that I'm supposed
to be using DBD::JDBC instead of DBD::Oracle, aren't I?  Hey, I was working
on this at 1:00 AM this morning...

Never mind...  

Thanks, Jared!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 11:11 AM
> To: [EMAIL PROTECTED]
> Cc: Jesse, Rich
> Subject: Re: DBD::Oracle and JDBC Thin
> 
> 
> Jesse,
> 
> Enlighten me as to why DBD::Oracle cares which JDBC driver you use. 
> 
> Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Richard Huntley]

Title: RE: Creating sequences on the DUAL table?





Sequences are DB objects independent of any tables including dual (not
possible to create a sequence "on" a table.  Sequences are sometimes used
to populate the PK of a table, but the actual sequence and the table are
not structurally related.  


Such as:


SQL> create sequence myseq;


Sequence created.


Then, often developers will use the dual table when grabbing the next value from
the sequence.


SQL> select myseq.nextval from dual;


better to do this...insert into table1(id,name) values(myseq.nextval,'FName');


Check out the info in the docs on Sequences, maybe the concepts part would be a
good start.


HTH



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Creating sequences on the DUAL table?




I have a request from one of our developers to create two new sequences on
the DUAL table.


This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.


Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.


Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?


Thanks,


Cherie Machler
Oracle DBA
Gelco Information Network


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DB/APPlication?

[Richard Huntley]

Title: RE: DB/APPlication?





Seema,
That's part of the tnsnames.ora which the client needs to connect to the database.
Check out the alert.log file and look for any trace files for the reason the DB crashed.


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
Subject: DB/APPlication?



Hi,
I have DB server and 2 web servers.Couple days back DB server was crashed 
and back again.I am wondering few processes like
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) on web server.All the 
applications are working fine.But its strange for me.
Is this some kind of hack?
Thx
-Seema



_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Deshpande, Kirti]

Sounds like your developer hangs out with some of our developers! ;) 

I am sorry to say but, I guess the syntax "...from dual" could be confusing
to the developer. 
  
Your understanding is just fine. Don't do anything with dual..
 
May be briefly explaining to the developer how sequence number work could
take care of this request. 

Good Luck..  

- Kirti 

-Original Message-
Sent: Tuesday, July 30, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Slightly OT: Chart generation tool for db monitoring scripts

[Ray Stell]

Think about how you will roll the trend data up over time.  That is
usually the real killer task.  That is why you got people talking
mrtg, because it is the poor man's solution to that problem.  At least
it is one wheel that has already been invented at the right price.

The snapshots you are making are really not that valuable, but they
are better then a stick in the eye.



On Tue, Jul 30, 2002 at 09:44:49AM -0800, Jamadagni, Rajendra wrote:
> Thanks everyone for your kind help, advise and hints.
> 
> I finally got it working with gnuplot.
> 
> I had to make some changes to my code, but this is how it works.
> 
> 1. Every 10 minutes MS task scheduler wakes up and executes a CMD file.
> 2. This CMD file 
>a. Executes a SQL script that generates a HTML table output on different
> data.
>b. Generates an appropriate DATA files for the same.
>c. Generates a script for gnuplot to load and generate the plots as gif
> files.
>d. Loads gnuplot and generates the gif files.
>e. Moved the images to their default directories.
> 3. By clocking on the column header (in the HTML report), I open a new
> window and display the plot for that parameter.
> 
> Works very nice ... I have a long way to go yet (to cover all statistics),
> but this has been a good start and good learning on GNUPLOT.
> 
> Raj
> __
> Rajendra Jamadagni  MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
> 
> QOTD: Any clod can have facts, but having an opinion is an art!
> -Original Message-
> Sent: Monday, July 29, 2002 10:10 PM
> To: '[EMAIL PROTECTED]'
> 
> 
> Sorry, I missed the part about automating it. Please let us know how
> gnuchart works. 
> > -Original Message- 
> > From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] 
> > 
> > me being lazy (and excel ignorant), wanted to find an 
> > automated way out of 
> > this. If I am going to be generating 10-15 graphs, doing it 
> > every half hour 
> > might just be too much for me. 
>   

> 
> *2
> 
> This e-mail message is confidential, intended only for the named recipient(s) above 
>and may contain information that is privileged, attorney work product or exempt from 
>disclosure under applicable law. If you have received this message in error, or are 
>not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
>and delete this e-mail message from your computer, Thank you.
> 
> *2
> 


-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Rajesh . Rao]

Communication gap and ignorance. The developers proably want to create new
sequences. And they are used to writing queries as "Select
sequencename.nextval from dual;" So they call it sequences on the dual
table.




   
   
"kkennedy" 
   

point.com> cc: 
   
Sent by:   Subject: RE: Creating sequences on the 
DUAL table? 
[EMAIL PROTECTED]
   
m  
   
   
   
   
   
July 30, 2002  
   
02:28 PM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




H?  Sequences are not created "on" the dual table.  Sequences exist as
independent entities.  Ofttimes, sequence values are selected using the
dual table (e.g., select seqname.nextval from dual) -- this is a coding
choice.  Performance of queries that select from the dual table are
generally not "inviting poor performance" (although I've seen some postings
on how to improve their performance).

If I were you, I would do some more reading up on sequences in the Concepts
manual and not worry too much about the performance.  Suggest to the
developers that they use the sequences directly whenever possible rather
than selecting from dual as in the following:

One method:
select seqname.nextval into local_var from dual;
insert into destination_table (...id_column...) values (...local_var...);

Better method:
insert into destination_table (...id_column...) values
(...seqname.nextval...);

And, if the value is needed for other things:
insert into destination_table (...id_column...) values
(...seqname.nextval...)
   returning id_column into local_var;

HTH
Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Tuesday, July 30, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the 

RE: Creating sequences on the DUAL table?

[Fink, Dan]

Cherie,
My first response is 'WHY?'. Do they mean that they want to create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some information
on the performance implications of DUAL at
http://www.optimaldba.com/internals/oraint_dual.html. 

Dan Fink

-Original Message-
Sent: Tuesday, July 30, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[Jacques Kilchoer]

Title: RE: Creating sequences on the DUAL table?





answer below


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> I have a request from one of our developers to create two new 
> sequences on
> the DUAL table.
> 
> This seems like a bad idea to me.   I've never had such a 
> request in the
> past.   I asked for clarification on why this is needed and I 
> didn't get a
> lot of details yet.
> 
> Is this something that is standard operating procedure?   My 
> understanding
> that interfacing with the DUAL table is usually inviting poor 
> performance.
> Plus, I don't like to mess around with system tables, in general.
> 
> Under what circumstances would it be justified to create 
> sequences on the
> DUAL table?   Should I just flat-out refuse this request and 
> if so, why?


You don't mean that the developer wants to add columns to dual?
I think the developer means that you should create two sequences, and he will get the next value by saying
select seq.nextval from dual ;
(example:
SQL> create sequence s ;
Séquence créée.
SQL> select s.nextval from dual ;


  NEXTVAL
-
    1
end of example)
I don't see a problem with creating a sequence for someone, as long as you make them beg properly first to teach them respect for the importance of the DBA.

RE: Space Contention and LOG_BUFFER size

[Sherman, Edward]

I can't find it in the docs either.

Info at ixora.com suggests setting LOG_BUFFER to a multiple of the log block
size.
http://www.ixora.com.au/tips/tuning/log_buffer_size.htm

This next link explains what a log block size is:
http://www.ixora.com.au/notes/log_block_size.htm

Have fun!
Ed

-Original Message-
Sent: Tuesday, July 30, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


I am doing some performance monitoring on an 8.1.7 DB on Windoze.  I ran the
following query;

SQL> select name,value
  2  from v$sysstat
  3  where name = 'redo log space requests';

NAME  VALUE
 --
redo log space requests  27


If the number of 'redo log space requests' is much over zero then I should
increase the LOG_BUFFER size in my init.ora, at least that is what I get
from RTFM.  One question I have is that does the size of the LOG_BUFFER
parameter have to be a multiple of the DB_BLOCK_SIZE parameter?  I vaguely
remember that it shuold be but have not found anything in TFM to verify
this.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Creating sequences on the DUAL table?

[kkennedy]

H?  Sequences are not created "on" the dual table.  Sequences exist as independent 
entities.  Ofttimes, sequence values are selected using the dual table (e.g., select 
seqname.nextval from dual) -- this is a coding choice.  Performance of queries that 
select from the dual table are generally not "inviting poor performance" (although 
I've seen some postings on how to improve their performance).

If I were you, I would do some more reading up on sequences in the Concepts manual and 
not worry too much about the performance.  Suggest to the developers that they use the 
sequences directly whenever possible rather than selecting from dual as in the 
following:

One method:
select seqname.nextval into local_var from dual;
insert into destination_table (...id_column...) values (...local_var...);

Better method:
insert into destination_table (...id_column...) values (...seqname.nextval...);

And, if the value is needed for other things:
insert into destination_table (...id_column...) values (...seqname.nextval...)
   returning id_column into local_var;

HTH
Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Tuesday, July 30, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Foxbase to Oracle

[Shaw John-P55297]

Visual FoxPro has an upsize wizard that can go directly to Oracle. It would
still be a lot cheaper to keep it in FoxPro over the cost of Oracle.

-Original Message-
Sent: Tuesday, July 30, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L


Dennis:

   Foxbase was originally called 10-base before Fox Systems change the name.
Foxbase was changed to FoxPro and then purchased by Microsoft and called
Microsoft FoxPro, and then Microsoft Visual FoxPro.  I would highly
recommend investigating the MSFT solution.  Sorry guys, but this is a
realistic solution.  Oracle, for eight users, will probably cost too much
for the implementation.

   If you need to convert to Oracle, do the following:
1. Convert to FoxPro
2. Bridge Visual FoxPro to SQLServer and use the Data Transformation
Services (DTS) to migrate the data to Oracle.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, July 30, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:Foxbase to Oracle 

Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very tight and
this application has only about 8 users max. My question is - does Oracle
provide a good tool for migration from Foxbase? This is a small application
and have only about a dozen tables, my main challenge would be the
application code.
If Oracle turns out to be too expensive, what is the least expensive, least
painful migration path? Another attractive option seems to be Visual
FoxPro, which I know little about.   I want to bounce it off the list first
before we make the choice.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw John-P55297
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[Gesler, Rich]

Title: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran DBA






I'd like to add another free gui thats kind of neat, DataBee DBATool utility.
You can find it at http://www.databee.com


-Rich



-Original Message-
From: Bill Pass [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA



Being a hardcore SQL*Plus hacker as well I was amazed
to find a freebie on the net that I actually liked and
used. It will work with any JDBC accessible database
(being written itself in java). All you have to do is
load your JDBC driver of choice. It also provides a
panel for entering SQL commands directly (for you
hardcore types).


The name of the tool is DBVisualizer and is available
at the following URL:
http://www.minq.se/products/dbvis/index.html


--- [EMAIL PROTECTED] wrote:
> > ...hardcore DBAs might never use GUI tools.
> 
> I fit that category.  :)
> 
> Gaja Vaidyanatha has recently moved to Oracle, and
> server tools
> are now his responsibility.
> 
> I challenged him to turn OEM into something I would
> actually
> be willing to use.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Alexandre Gorbatchev"
> <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 07:28 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:    Re: Guys:  Is this worth
> $1,749 for 8 year Oracle veteran DBA
> 
> 
> Oracle's politic is to make us using GUI tools. This
> is reflected in OCP
> exams, so I can conclude that for newbies exams
> become easier while 
> hardcore
> DBAs might never use GUI tools.
> 
> Alexandre
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, July 30, 2002 3:03 PM
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California    -- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).



__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Foxbase to Oracle

[Farrell, Thomas M.Mr. NGB-ARNG]

Dennis,

While I hate doing this on an Oracle list, you might want to consider SAP DB
considering your limited budget and requirements. The general product
details are here: http://www.sapdb.org/ and you can request a free CD here:
http://www.sapdb.org/sap_db_cd.htm.

Quite impressive and under-rated if you ask me. <;

Good luck.

Cheers,
Thom
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farrell, Thomas M.Mr. NGB-ARNG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: JBDC thin driver

[Shawn Conner]

Make sure that it is in your class path aswell.
  Alex <[EMAIL PROTECTED]> wrote: 
just put the zip file on your pathOn Tue, 30 Jul 2002, Daniel Wisser wrote:> hi!>> anyone knows an answer to this:>> i want to user JDBC thin driver. i can install it from the> CD on windows using the manually configured installation.>> since thin driver is said to be purely java, i want to use> it on linux, too. which are the necessary files?>> are they in> $ORACLE_HOME\jdbc\lib\classes111.zip>> could not find help in metalink>> thx & regards>> daniel>> --> Daniel Wisser, Mag.> Papyrus Quality Assurance> DB Team>> ISIS Information Systems> Alter Wienerweg 12> A-2344 Ma. Enzersdorf, Austria>> Phone: +43-2236-27551-149> Fax: +43-2236-21081> E-mail: daniel.wisser@!
!
isis-papyrus.com>> Hotline: +43-2236-27551-111>> Visit the ISIS Website: http://www.isis-papyrus.com>> ---> This e-mail is only intended for the recipient and not legally> binding. Unauthorised use, publication, reproduction or> disclosure of the content of this e-mail is not permitted.> ---> --> Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> Author: Daniel Wisser> INET: [EMAIL PROTECTED]>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> San Diego, California -- Public Internet access / Mailing Lists> > To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note E!
!
XACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).>-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: AlexINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yah!
!
oo!?
Yahoo! Health - Feel better, live better

RE: Install Oracle 8i on Windows XP?

[Gogala, Mladen]

> My assumption is that (everything else equal) *nix on a PC 
> server is a superior technology, more performant, more stable.
> 
> Unfortunately one has to know a lot more low level tech stuff 
> to get into the *nix game than is the case with windows, and 
> therefore *nix on a PC will remain to a large extent in the 
> domain of high-skill-set purists and tech elites, not the mass 
> market.

For running a stable production database that a company can rely on,
those " high-skill-set purists and tech elitist a*holes" are still needed.
It's not a job for the faint hearted "clickety click" people. Name of the
game is 99% uptime and it's only for the major league, and that means Unix
and OS/390
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[April Wells]

If anyone can... he might be able to.  

-Original Message-
Sent: Tuesday, July 30, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L



I fit that category as well. I talked to him last night he's gonna
try :)

--- [EMAIL PROTECTED] wrote:
> > ...hardcore DBAs might never use GUI tools.
> 
> I fit that category.  :)
> 
> Gaja Vaidyanatha has recently moved to Oracle, and server tools
> are now his responsibility.
> 
> I challenged him to turn OEM into something I would actually
> be willing to use.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Alexandre Gorbatchev" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/30/2002 07:28 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Re: Guys:  Is this worth $1,749 for 8 year
> Oracle veteran DBA
> 
> 
> Oracle's politic is to make us using GUI tools. This is reflected in
> OCP
> exams, so I can conclude that for newbies exams become easier while 
> hardcore
> DBAs might never use GUI tools.
> 
> Alexandre
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 30, 2002 3:03 PM
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Space Contention and LOG_BUFFER size

[Babu . Nagarajan]

More than the number of time you are waiting for 'redo log space requests'
its more important to find out how long you are waiting for that. 27 times
out of a million might not be a big deal for you to tune.

having said that, here is a posting by Steve Adams on this topic

"Q : Every day our production database has more than 10 redo log space requests. 
Oracle suggested that this number should be near 0.
I resized the log files, and increased the log buffer to 1M. What else can I do?

A :  This idea of increasing the log_buffer to get space requests down to 0 is both 
ineffective and bad for performance.
There is always a risk of space requests at log switches and a few other points when 
redo generation is disabled entirely.
 It does not matter how big your log buffer is then. You will get space request waits 
if you try to generate redo at that time.
Also, a large log buffer is actually much worse for performance than the occasional 
space request,
even if that is a genuine log buffer space wait.  "


hth

babu




"Farnsworth, Dave" <[EMAIL PROTECTED]>@fatcity.com on
07/30/2002 12:19:02 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



I am doing some performance monitoring on an 8.1.7 DB on Windoze.  I ran
the following query;

SQL> select name,value
  2  from v$sysstat
  3  where name = 'redo log space requests';

NAME  VALUE
 --
redo log space requests  27


If the number of 'redo log space requests' is much over zero then I should
increase the LOG_BUFFER size in my init.ora, at least that is what I get
from RTFM.  One question I have is that does the size of the LOG_BUFFER
parameter have to be a multiple of the DB_BLOCK_SIZE parameter?  I vaguely
remember that it shuold be but have not found anything in TFM to verify
this.

Thanks,

Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

db comparison site

[Boivin, Patrice J]

FYI,

While looking for db comparisons I found a site that has a few:

http://www.itsystems.lv/gints/compare_db.htm

Note that it is located in Latvia.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

[April Wells]

The functionality for Server Manager command-line was migrated in it's
entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
eliminated svrmgrl not so much as a way of deprecating command-line
utilities in general, but rather to consolidate redundant products...


Except you still can't select from V$AQ in sqlplus even in 9i... just a
teeny little thing... but (per a dozen hits on metalink) it only works in
server manager... 

ajw


-Original Message-
Sent: Tuesday, July 30, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L


Tim:

  I take exception to the age thing here.  Yes, I remember rewriting the MVS
procs for Oracle's MVS implementation because they never checked to see if
MPM was running in the background task manager of SDSF.  Add to it that I
wrote (helped Oracle) a complete TSO Dialog Manager interface to all of the
Oracle tools that ran on the mainframe.

  GUI tools hide the "work" involved in solving the problem  Go Command
Line!!!

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, July 30, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Guys:  Is this worth $1,749 for 8 year Oracle veteran
DBA

GUI tools are simply a front-end presentation layer for SQL commands.  GUI
tools do not "bypass" the SQL command-line layer;  they only abstract it.
Command-line tools (such as SQL*Plus) use the same API as the GUI tools, but
simply do a lot less abstraction on the presentation.  Command-line tools
will never "go the way of the dodo", because they are part of the diagnostic
process for GUI tools, if nothing else.  Also, since the days of ISPF and
JCL (anybody recognize those), on platforms from OS/360 through Windows, it
has proven impossible to wean users away from command-line, especially for
"batch" processing...

The functionality for Server Manager command-line was migrated in it's
entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
eliminated svrmgrl not so much as a way of deprecating command-line
utilities in general, but rather to consolidate redundant products...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 9:20 AM


Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
that it was mentioned that Oracle are moving away from command line tools in
favour of GUI tools in much the same way that server manager is no longer
available - does anyone know if this is truly the case? Will command line
tools go the way of the dodo? I do 99% of my work (be it serious or not)
from the command line and would truly miss the choice if it were taken away.

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 30 July 2002 15:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses.

Corporate IT
THE WOOLWICH
--

Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 3:03 PM


> When people pass exams they tend to say the exam was "easy".
>
> When they fail the exam they tend to say either "I didn't study enough" or
> "It was hard, that one!"
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO  | Région des Maritimes, MPO
>
> E-Mail: [EMAIL PROTECTED]
>
>
>  -Original Message-
> Sent: Monday, July 29, 2002 6:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
> DBA
>
> Funny, I just heard a seasoned Oracle consultant say
> that the 9i exams were considerably more difficult
> than the 8i exams.
>
>
> --- "McBain, Neil  SITI-ITDSEL314"
> <[EMAIL PROTECTED]> wrote:
> > I have just completed my Oracle 8i OCP DBA using
> > only ten years of
> > experience and the Sybex books (thoroughly
> > recommended, except Backup &
> > Recovery does not cover enough RMAN syntax). I
> > believe if you sit the 9i OCP
> > exams then you do have to attend one Oracle course
> > (except if you had sat an
> > Oracle 9i exam prior to a certain date this year),
> > however you can sit the
> > 8i exams and then the 9i upgrade exam without
> > requiring the course (or 

Creating sequences on the DUAL table?

[Cherie_Machler]

I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to use pipe-delimited SQL*Plus output with a long datatype

[Cherie_Machler]

Thanks to those who recommended the relatively new set colsep command.   It
did work in this report.

Thanks again,

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
[EMAIL PROTECTED]
  
ardier.comTo: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] cc:  
  
  Subject: Re: How to use 
pipe-delimited SQL*Plus output with a long 
   datatype
  
07/30/02 09:59 AM  
  
Please respond to ORACLE-L 
  
   
  
   
  





I think the problem is that you can't do an operation (like concatenate) on
a long field.
But another way to get the same output is to set colsep '|' , and then use
plain old select list

chaim




[EMAIL PROTECTED]@fatcity.com on 07/30/2002 09:23:20 AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:




One of our developers wants to create a reusable report where the
pipe-delimited output generated by SQL*Plus would be sent off and used as
input into another process.   The problem is the remarks field which is of
type long.  It causes ORA-00997 errors.   If I take the pipe-delimits off,
the report works o.k.   If I take the remarks field out, the report works
o.k.   There seems to be an incompatibility between the two.   The
developer wants to have the remarks column included in the report and she
also wants the fields to be delimited somehow.

I saw an informative document on Metalink about the ORA-997 error but there
is no work-around suggested.  Does anyone have any bright ideas?   It is
not possible to convert the long within the database, at this time.   This
database will be obsolete in a few months so it's not worth the hassle to
recode all of the apps that use this field.

1  select /*+ USE_NL(CCD,CCDX,ERLI,ERH) */  ar.acct_no || '|' ||
  2  ar.intl_rep_no || '|' ||
  3  ar.rep_id || '|' ||
  4  cr.last_name || '|' ||
  5  cr.first_name || '|' ||
  6  erh.cnfr_no || '|' ||
  7  erli.line_item_amt || '|' ||
  8  erli.line_item_dt || '|' ||
  9  erli.line_seq_no  || '|' ||
 10  ccd.merch_name  || '|' ||
 11  erh.remarks
 12from acct_rep ar,
 13 client_rep cr,
 14 exp_rpt_hdr erh,
 15 exp_rpt_line_item erli,
 16 chrg_card_dtl_xref ccdx,
 17 chrg_card_dtl ccd
 18   where '49368' = erh.acct_no
 19 and ccd.intl_rep_no = erh.intl_rep_no
 20 AND cr.clnt_no = ar.clnt_no
 21 AND cr.intl_rep_no = ar.intl_rep_no
 22 AND erh.intl_rep_no = cr.intl_rep_no
 23 AND erh.acct_no = ar.acct_no
 24 AND erh.intl_rep_no = ar.intl_rep_no
 25 AND erh.cnfr_no = erli.cnfr_no
 26 and trunc(erh.submit_dt) > trunc(sysdate - 25)
 27 AND '810' = erli.pay_seq_no
 28 AND ccdx.cnfr_no (+) = erli.cnfr_no
 29 AND ccdx.line_seq_no (+) = erli.line_seq_no
 30 AND ccdx.cnfr_No is null
 31 AND ar.acct_no = '49368'
 32 AND ccd.acct_no = '49368'
 33 AND ccd.trans_dt = erli.line_item_dt
 34*AND ccd.posted_amt = erli.line_item_amt
SQL> /
erh.remarks
*
ERROR at line 11:
ORA-00997: illegal use of LONG datatype


Thanks for any advice.

Cherie Machler
Oracle DBA
Gelco Information Network

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mail

Re: 11i installation ???

[James J. Morrow]

Leslie Lu wrote:
> 
> Hi all,
> 
> I purchased the Oracle 11i Release 5 (with 11.5.6
> family packs) CD pack for Windows from Oracle online
> store.
> 
> My first installed (Win2000) run out of space, and I
> cleaned the folders manually.  When I got more space
> and installed again, I got:
> 
> not all the dependencies for the component OEM common
> files 2.2.0.0.0 are found.   Missing component
> Oracle.swd.jre 1.1.8.10.0.
> 
> Looks like the manually cleanup didn't go well.  What
> should I do now?
> 
> Also, how long does the install take? One guy told me
> to install one product/one db at a time.  Is this a
> good idea?  Is demo db enough? Are there any Oracle
> 11i group/email list?  I know, lots of questions. :-)
> 
> Thanks!
> 
> Leslie

Bear in mind that Oracle Applications 11i has certain dependencies that are
specific to the M$FT Windows NT/2000 platform.  Most notably:  Visual C++ 6.0
and MKS Toolkit (both of which are additional cost items, totalling between
$600-$1000).  

There are several documents on metalink you may want to look at if you've had a
failed install (on Windows... similar docs exist for Unix):

  DocID:  137200.1 "Checklist when OUI Fails for Windows"
  DocID:  143976.1 "How to clean up a failed install of OA 11.5 on an NT
Platform"

As far as how long the install takes:

  On Unix, once you've built your staging area, it can take upwards of 2-3 hours
to do a full install of the VIS demo instance.  Mostly determined by the speed
of your system (CPUs/Memory/Disk).

  On NT, it can take a bit longer.  Especially if you factor in the additional
time required to install the prerequisites.  (MS Visual C++, MKS Toolkit,
GNUMake).  And, of course, there are at least 5 reboots involved...  (More if
you're into patching things current...)

-- James

James J. Morrow E-Mail:  [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
McKinney, TX, USA

"The reasonable man adapts himself to the world:  the unreasonable man
  persists in trying to adapt the world to himself.  Therefore all progress
   depends on the unreasonable man."  -- George Bernard Shaw
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James J. Morrow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).