RE: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Sam P. Roberts (ZADCO ITIS)

STAR Queries would perform better with multiple smaller tables (known as
Dimension Tables). STAR QUERIES are designed specifically for Decision
Support Systems where multiple cartesian products are created on the smaller
(dimension) tables and then joined with the LARGE fact table.  

Sam

-Original Message-
Sent: Thursday, March 22, 2001 4:36 AM
To: Multiple recipients of list ORACLE-L


Guys,

We r working on a Datawarehouse solution.

Our Duhvelopers want to merge all code tables into a single table by adding
a codetype column.

with reference to this, i came across this article from Steve's site
http://www.ixora.com.au/tips/design/meta-data.htm

i want to put them into different individual code tables instead of a single
table, for the foll reasons.

1. specific attributes for a particular code type is logically and
physically seperated from other code types.
2. a table lock affects only the concerned code table
3. granular control over the individual code table

i am short of arguments

wld be grateful, if ull can advise me which would be better from performance
perspective.

-Mandar
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  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: Sam P. Roberts (ZADCO ITIS)
  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: Crontab - Ooops

2001-03-23 Thread David A. Barbour

Charlie,

Some days are like that.  You're right.  Mike Hand had the right idea
when he wrote:

.. 2 choices are

MM HH 22-28 * * (shell script checks for Sunday before proceeding)
OR
MM HH * * 0  (shell script checks for day of month between 22 and 28
before
proceeding)

Mike




Charlie Mengler wrote:
> 
> Just curious.
> 
> Using your algorithm, what happens on those rare months
> where there are FIVE sundays?
> 
> "David A. Barbour" wrote:
> 
> > Luc,
> >
> > One possible solution:
> >
> > Run the cron every Sunday and have the first part of your shell script
> > check to see if that day's date plus seven days falls into another
> > month.
> >
> > Regards,
> >
> > David A. Barbour
> > Oracle DBA
> > Formerly with the now defunct and bankrupt ConnectSouth
> >
> > "DEMANCHE Luc (Cetelem)" wrote:
> > >
> > > Hi gurus,
> > >
> > > I want to schedule a script to run on the fourth sunday of the month.
> > >
> > > How can I do that ?
> > >
> > > TIA
> > >
> > > -
> > > Luc Demanche
> > > CETELEM
> > > Tél.: 01-46-39-14-49
> > > Fax : 01-46-39-59-88
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: David A. Barbour
> >   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: David A. Barbour
  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: Unix question

2001-03-23 Thread Big Planet



No No . Here is full problem 
 
I have this ini file called xyz.ini having 

 
hostname = $HOSTNAME$.acme.com 
schemaname=$SCHEMANAME$
domainname= $HOSTNAME$.foo.bar.com
 
okay , Now I am getting the values of hosname as 
"abc" , schema name as "schem" .
I want to write a script in which I will pass these 
parameters and they will do a search and replace kindof operation.
I was thinking of using sed , but how to get rid of 
quotes because my $1 is "abc" so after replacement file will become
 

hostname = "abc".acme.com 
schemaname="schem"
domainname= "abc".foo.bar.com
 
while I want it to be like
 
 
hostname = abc.acme.com 
schemaname=schem
domainname= abc.foo.bar.com
 
- Big Planet
 
 
 

  - Original Message - 
  From: 
  Charlie Mengler 
  
  To: Multiple recipients of list ORACLE-L 
  Sent: Friday, March 23, 2001 8:45 
PM
  Subject: Re: Unix question
  Yes & no. 
  There are a couple of different way to solve the problem. 1) Write your 
  own functions/filters to accomplish the desired operations 2) If the only 
  place in the file where double quote marks exists are around the hostname 
      and all you want to do is get rid of them, the "tr" 
  command could be used. 3) Unix scripts can accept command line arguments 
  which are positionally dependant so you could create a master script which 
  would look like the following driver.sh host1 schemaA driver.sh host2 
  schemaB driver.sh host9 schemaG etc... 
  The inside driver.sh where you want the hostname to appear place a $1 
  The inside driver.sh where you want the schema    to appear 
  place a $2 
  HTH & YMMV! 
  Big Planet wrote: 
  

Hi geeks ,How can I do substr and instr kind of operaion in 
unix shell script . is it possible ?like i have one paramter as "hostname" .. I want to trim quotes 
surrounding the hostname .One 
more question , is possible to read another text file line by line using a 
shel script and then edit that file .Actually I have this configuration file for my system which have 
keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace with actual 
values at the time of installation by asking questions to the 
user. TIA--Big 
planet  


syntax for trigger

2001-03-23 Thread Andrea Oracle

Hi all,

How to find out the whole syntax for a trigger?

The dba/all/user_source view don't have text for
trigger.  The trigger_body column in All_triggers view
doesn't show all the syntax.

Thanks a lot.

Andrea


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Jacques Kilchoer
Title: RE: Single Code Table or Separate Code tables dilemma





> -Original Message-
> From: Mandar Ghosalkar [mailto:[EMAIL PROTECTED]]
> 
> i dont disagree with u. even i dont like the below mentioned
> implementations. i always prefer seperate tables. btw "lot of 
> rows" is very
> subjective.


Of course. In my case, let's suppose I have hundreds of thousands of rows. In my opinion that's enough to think that having the values 'SPLT' and 'TYPE' in every row would be wasteful.

> i dont know what u mean by "I have to have a table that contains every
> possible combination of SPLT and TYPE. ". 


I guess I don't understand what you mean when you say this:


"> but u can also create surrogate key and make (CODE_TYPE, 
> CODE_VALUE) as 
> alternate key (unique) and then reference the surrogate key 
> in ur doctor 
> table, instead of two cols as one foreign key"


What would the SQL statements look like?





RE: Unix question

2001-03-23 Thread Mandar Ghosalkar



check 
this question from korn faq at 
http://www.kornshell.com/doc/faq.html
 
Q24.	How do I do global substitutions on the 
contents of shell variables?A24.	Use // instead of / for global 
substitution, ${var//aa/bb} will	expand to the value of  with each "aa" 
replace by "bb".
so i 
tried
$ 
var=tester$ echo $vartester$ echo ${var//e/o}bad 
substitution$
 
anyone 
out there :)
 
-Mandar
 

  -Original Message-From: Big Planet 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 7:56 
  PMTo: Multiple recipients of list ORACLE-LSubject: Unix 
  question
  Hi geeks ,
  How can I do substr and instr kind of operaion in 
  unix shell script . is it possible ? 
  like i have one paramter as "hostname" .. I want 
  to trim quotes surrounding the hostname .
  One more question , is possible to read another 
  text file line by line using a shel script and then edit that file 
  .
  Actually I have this configuration file for my 
  system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace 
  with actual values at the time of installation by asking questions to the 
  user.
   
  TIA
  --Big planet
   
   


RE: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Mandar Ghosalkar

i dont disagree with u. even i dont like the below mentioned
implementations. i always prefer seperate tables. btw "lot of rows" is very
subjective. 

i dont know what u mean by "I have to have a table that contains every
possible combination of SPLT and TYPE. ". 

anyways, its a common practice to create surrogate keys to avoid composite
foreign keys. imagine a structure flowing from 
master to detail with 20 sub levels one below other. ur last child table
would have a foreign key with ~20 columns.

-Mandar

-Original Message-
Sent: Friday, March 23, 2001 8:16 PM
To: Multiple recipients of list ORACLE-L


I hate to be picky, but I don't like either of the solutions proposed below.
For the first solution, that means that I would have to have the repeating
values 'SPLT' and 'TYPE' in every row of the DOCTOR table, which is a table
with a lot of rows in it.
For the second solution, I have to have a table that contains every possible
combination of SPLT and TYPE. 
Both solutions seem to be wasteful and clumsy. Please don't take this as a
direct criticism of you, but I still don't see how a single code table can
be implemented well using FK relationships.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  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: Unix question

2001-03-23 Thread Charlie Mengler



Yes & no.
There are a couple of different way to solve the problem.
1) Write your own functions/filters to accomplish the desired operations
2) If the only place in the file where double quote marks exists are
around the hostname
    and all you want to do is get rid of them, the "tr"
command could be used.
3) Unix scripts can accept command line arguments which are positionally
dependant
so you could create a master script which would look like the following
driver.sh host1 schemaA
driver.sh host2 schemaB
driver.sh host9 schemaG
etc...
The inside driver.sh where you want the hostname to appear place a $1
The inside driver.sh where you want the schema    to
appear place a $2
HTH & YMMV!
Big Planet wrote:

Hi
geeks ,How can I do substr
and instr kind of operaion in unix shell script . is it possible ?like
i have one paramter as "hostname" .. I want to trim quotes surrounding
the hostname .One more question
, is possible to read another text file line by line using a shel script
and then edit that file .Actually
I have this configuration file for my system which have keywords like $HOSTNAME$
, $SCHEMA$ which I want to replace with actual values at the time of installation
by asking questions to the user. TIA--Big
planet  





RE: how to store orace errors in database (UNIX scripting challen

2001-03-23 Thread Mandar Ghosalkar

Guys

how about creating a shell script
#/bin/ksh
count=1
while [ $count -ne 10 ]
do
oerr ora $count
count="$(($count + 1))"
done


00088, 0, "command cannot be executed by MTS server "
// *Cause:  Debug command issued on MTS server.
// *Action: Reissue the command using a dedicated server.
00089, 0, "invalid instance number in ORADEBUG command "
// *Cause:   An invalid instance number was specified in an OPS ORADEBUG
//  command.
// *Action: Reissue the command with valid instance numbers.


the output needs to be parsed and stored into a table. 
UNIX shell scripting masters can give me some hints how i can use maybe sed
or awk to break each error output into three variables
step1. first line till line before "*Cause" into first variable
"error_message" 
step2. line containing "*Cause" onwards till line before "*Action"  into
second variable "error_cause"
step3. line containing "*Action" onwards till end

any hints to start the work would be appreciated. now no RTFM pls..:)

-Mandar

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 8:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:how to store orace errors in database
> 
> 
> Kaushik,
> 
> There is nothing that I know of that does a help_table 
> for error messages. 
> One can use the selerrm function to return the text of any 
> error although it
> does not send back the reason why nor the corrective action.  
> I'm not sure about
> NT and oerr.  I haven't found it yet there, but then I don't 
> use NT as a db
> server platform.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "kaushikdas" <[EMAIL PROTECTED]>
> Date:   3/21/2001 11:35 PM
> 
> 
> 
> Hello I am Kaushik Das from india .I am new to your group.
> I had a query ,i hope some one will reply to this mail.
> 
> Just like we can store help of sql commands in HELP table  in
> oracle database.In a semilar way can we store ORACLE errors 
> in database
> 
> for example to see oracle error  in unix we write   oerr ora 
> 
> 1)what command should we write in nt to see the complete info of this
> error.
> 
> 2) How to store and retrive complete oracle error messages in oracle
> database.
> 
> 3) is there any sql file which dba should run to create such 
> table and toad
> data.
> 
> Thanks in advance.
> 
> regards
> 
> kaushik
> 
> 
> 
> --
> -
> 
> IFFCO's Website Address  -   www.iffco.nic.in
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: kaushikdas
>   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: Mandar Ghosalkar
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Jacques Kilchoer
Title: RE: Single Code Table or Separate Code tables dilemma





I hate to be picky, but I don't like either of the solutions proposed below. For the first solution, that means that I would have to have the repeating values 'SPLT' and 'TYPE' in every row of the DOCTOR table, which is a table with a lot of rows in it.

For the second solution, I have to have a table that contains every possible combination of SPLT and TYPE.


Both solutions seem to be wasteful and clumsy. Please don't take this as a direct criticism of you, but I still don't see how a single code table can be implemented well using FK relationships.

> -Original Message-
> From: Mandar Ghosalkar [mailto:[EMAIL PROTECTED]]
> 
> CREATE TABLE I_DONT_LIKE_MASTER 
> ( CODE_TYPE VARCHAR2(4) NOT NULL,
> CODE_VALUE VARCHAR2(3) NOT NULL,
> CODE_DESC VARCHAR2(20) ,
> PRIMARY KEY (CODE_TYPE, CODE_VALUE) )
> 
> SPLT  N   SDFLJDSL
> SPLT  FP  SDFSDKFDS
> SPLT  OBG SFLSDJFSD
> TYPE  MD  SDFLSDFSDF
> TYPE  FP  SDFJDSFJ
> TYPE  OPH SDLFJDSKF
> 
> 
> CREATE TABLE DOCTOR
> (.,
> SPECIALITY_CODE_TYPE  VARCHAR2(4),
> SPECIALITY_CODE_VALUE VARCHAR2(3),
> TYPE_CODE_TYPE        VARCHAR2(4),
> TYPE_CODE_VALUE       VARCHAR2(3),
> .,
> foreign key  (SPECIALITY_CODE_TYPE,SPECIALITY_CODE_VALUE) references
> I_DONT_LIKE_MASTER,
> foreign key  (TYPE_CODE_TYPE, TYPE_CODE_VALUE ) references
> I_DONT_LIKE_MASTER )
> 
> D1    SPLT    N   TYPE    OPH
> D2    SPLT  N TYPE    MD
> 
> 
> but u can also create surrogate key and make (CODE_TYPE, 
> CODE_VALUE) as
> alternate key (unique) and then reference the surrogate key 
> in ur doctor
> table, instead of two cols as one foreign key
> 
> -Original Message-
> 
> I have a table called DOCTOR that has two fields - SPECIALTY 
> and TYPE. 
> The acceptable values for SPECIALTY are N, FP, OBG, etc... 
> The acceptable values for TYPE are MD, FP, OPH, etc... 
> If I have a "single code table", how can I create a Foreign 
> key constraint
> on the SPECIALTY column and another one on the TYPE column? 





RE: IMPORT Error - IMP-00020: long column too large for column bu

2001-03-23 Thread Jacques Kilchoer
Title: RE: IMPORT Error - IMP-00020: long column too large for column buffer size 





> -Original Message-
> From: Antonio Idone [mailto:[EMAIL PROTECTED]]
> 
> i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 
> A 9000/800.
> The folling tables Import terminated successfully  
> 
> AGG_CTR_SEDE_TRG_R
> V_DOC_AGREE_CTR_R 
> 
> but :
> 
> . . importing table   "AGG_CTR_SEDE_TRG_R"
> IMP-00020: long column too large for column buffer size 
> (2)raoul oracle
> 
> i have used buffer with 64k, 100k, 4M  10M 20M  40M  50M  
> 
> 60,80,100M but don't work
> 
> IMP-6: failed to allocate memory of size 1
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
> IMP-0: Import terminated unsuccessfully



Could it be that your buffer size is getting too large? Here's what the Oracle error messages manual says:


IMP-00020: long column too large for column buffer size num 
Cause: The column buffer is too small. This usually occurs when importing LONG data. 
Action: Increase the insert buffer size 10,000 bytes at a time up to 66,000 or greater (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem.




Unix question

2001-03-23 Thread Big Planet



Hi geeks ,
How can I do substr and instr kind of operaion in 
unix shell script . is it possible ? 
like i have one paramter as "hostname" .. I want to 
trim quotes surrounding the hostname .
One more question , is possible to read another 
text file line by line using a shel script and then edit that file 
.
Actually I have this configuration file for my 
system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace 
with actual values at the time of installation by asking questions to the 
user.
 
TIA
--Big planet
 
 


RE: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Mandar Ghosalkar

CREATE TABLE I_DONT_LIKE_MASTER 
( CODE_TYPE VARCHAR2(4) NOT NULL,
CODE_VALUE VARCHAR2(3) NOT NULL,
CODE_DESC VARCHAR2(20) ,
PRIMARY KEY (CODE_TYPE, CODE_VALUE) )

SPLTN   SDFLJDSL
SPLTFP  SDFSDKFDS
SPLTOBG SFLSDJFSD
TYPEMD  SDFLSDFSDF
TYPEFP  SDFJDSFJ
TYPEOPH SDLFJDSKF


CREATE TABLE DOCTOR
(.,
SPECIALITY_CODE_TYPEVARCHAR2(4),
SPECIALITY_CODE_VALUE   VARCHAR2(3),
TYPE_CODE_TYPE  VARCHAR2(4),
TYPE_CODE_VALUE VARCHAR2(3),
.,
foreign key  (SPECIALITY_CODE_TYPE,SPECIALITY_CODE_VALUE) references
I_DONT_LIKE_MASTER,
foreign key  (TYPE_CODE_TYPE, TYPE_CODE_VALUE ) references
I_DONT_LIKE_MASTER )

D1  SPLTN   TYPEOPH
D2  SPLT  N TYPEMD


but u can also create surrogate key and make (CODE_TYPE, CODE_VALUE) as
alternate key (unique) and then reference the surrogate key in ur doctor
table, instead of two cols as one foreign key
-MANDAR 


-Original Message-
Sent: Friday, March 23, 2001 7:31 PM
To: Multiple recipients of list ORACLE-L


I'm still not quite sure I understand the "single code table" business. Let
me give an example (taken from a live example at one of my previous jobs).
I have a table called DOCTOR that has two fields - SPECIALTY and TYPE. 
The acceptable values for SPECIALTY are N, FP, OBG, etc... 
The acceptable values for TYPE are MD, FP, OPH, etc... 
If I have a "single code table", how can I create a Foreign key constraint
on the SPECIALTY column and another one on the TYPE column?
-- 
Jacques R. Kilchoer 
(949) 754-8816 
Quest Software, Inc. 
8001 Irvine Center Drive 
Irvine, California 92618 
U.S.A. 
http://www.quest.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  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: IMPORT Error - IMP-00020: long column too large for column bu

2001-03-23 Thread Mandar Ghosalkar

if ur table is not hving a long column, it could be bug #230777

the imp file could be corrupted.

hv u tried using a fresh new export dump with larger buffersize. then try
importing this new export.



-Mandar

> -Original Message-
> From: Antonio Idone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: IMPORT Error - IMP-00020: long column too large for column
> buffer size 
> 
> 
> Hi list,
> 
> i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 
> A 9000/800.
> The folling tables Import terminated successfully  
> 
> AGG_CTR_SEDE_TRG_R
> V_DOC_AGREE_CTR_R 
> 
> but :
> 
> . . importing table   "AGG_CTR_SEDE_TRG_R"
> IMP-00020: long column too large for column buffer size 
> (2)raoul oracle
> 
> i have used buffer with 64k, 100k, 4M  10M 20M  40M  50M  
> 
> 60,80,100M but don't work
> 
> IMP-6: failed to allocate memory of size 1
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
> IMP-0: Import terminated unsuccessfully
> 
> thanks
> Antonio  
> __
> _
> Visit http://www.visto.com/info, your free web-based 
> communications center.
> Visto.com. Life on the Dot.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Antonio Idone
>   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: Mandar Ghosalkar
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Jacques Kilchoer
Title: RE: Single Code Table or Separate Code tables dilemma





I'm still not quite sure I understand the "single code table" business. Let me give an example (taken from a live example at one of my previous jobs).

I have a table called DOCTOR that has two fields - SPECIALTY and TYPE.
The acceptable values for SPECIALTY are N, FP, OBG, etc...
The acceptable values for TYPE are MD, FP, OPH, etc...


If I have a "single code table", how can I create a Foreign key constraint on the SPECIALTY column and another one on the TYPE column?

--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com





RE: NT Server very slow

2001-03-23 Thread Mandar Ghosalkar

cant find it

> -Original Message-
> From: Jerry C [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: NT Server very slow
> 
> 
> check out Doc ID 941798 at Metalink...
> 
> 
> - Original Message -
> To: <[EMAIL PROTECTED]>
> Sent: Friday, March 23, 2001 3:36 PM
> 
> 
> > There is a bug with some version of Oracle (I believe it 
> was 8.1.6.0.0,
> but
> > don't quote me on that), where even with NO users, oracle.exe would
> > eventually consume your whole CPU. The CPU utilization 
> ramps up after a db
> > restart until it gets to 99 or 100.
> >
> > Open Task Manager and check the oracle.exe process.
> >
> > I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.
> >
> >
> > Good luck!
> >
> > - Jerry
> >
> >
> > - Original Message -
> > From: "Jim Walski" <[EMAIL PROTECTED]>
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, March 23, 2001 12:17 PM
> > Subject: Re: NT Server very slow
> >
> >
> > > Since you mention there are only a few users, I would 
> take a look at the
> > > jobs these users are running.  Maybe one of these users 
> is firing off a
> > > poorly tuned job that brings the database to a grinding halt.
> > >
> > > Is the database the only product on the Server?  Or are 
> there other
> > > applications ( email server, web server...)
> > >
> > > Jim
> > >
> > >
> > >
> > > -Original Message-
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > Date: Friday, March 23, 2001 7:50 AM
> > >
> > >
> > > >I have an Oracle 8.1.6 instance on an NT Server.  The 
> application has
> > only
> > > a
> > > >few users.  Very often throughout the day it seems 
> response time drops
> to
> > > >about 20 seconds.  By the time I log on to look at the problem
> everything
> > > is
> > > >back to normal.  If I do a simple query the result is returned
> > immediately.
> > > >I have looked at SQL through Quest's SQLAB and there is 
> nothing that
> > stand
> > > >out.  The hit ratio averages between 88% and 92%.  Is 
> there a good way
> to
> > > >diagnose this type of problem?
> > > >
> > > >Ron Smith
> > > >Database Administration
> > > >[EMAIL PROTECTED]
> > > >
> > > >--
> > > >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: Jim Walski
> > >   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!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jerry C
>   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: Mandar Ghosalkar
  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

805 client, 815 server ??

2001-03-23 Thread Leslie Lu

Hi all,

I reinstalled 805 client with Database Administration
option.  When I used 805's sqlplus, svrmgrl to connect
to a 815 database, I got this:

ORA-12705: invalid or unknown NLS parameter value
specified 

Any idea?  Thanks a lot.

Leslie

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  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: 8i - Seeing which columns disabled

2001-03-23 Thread yong huang

Hi, Tracey,

>From my own test, I remember data in a column set unused can still be dumped to
a trace file. Depending on your knowledge of interpreting datafile dump, you
can get the result back one row at a time (or even write a script to automate
it; nobody outside Oracle can say that's easy).

Also note that Oracle documention says:

You can view all tables with columns marked as unused in the data dictionary
views USER_UNUSED_COL_TABS, DBA_UNUSED_COL_TABS, and ALL_UNUSED_COL_TABS

Yong Huang
[EMAIL PROTECTED]

you wrote:

> I found though that once marked unused U couldn't find a reference to the
> column name anywhere ie to confirm what columns have been dropped. I get
> the feeling that 'set unused' may be an irreversible process?
>
> Tracey

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: yong huang
  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).



IMPORT Error - IMP-00020: long column too large for column buffer size

2001-03-23 Thread Antonio Idone

Hi list,

i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 A 9000/800.
The folling tables Import terminated successfully  

AGG_CTR_SEDE_TRG_R
V_DOC_AGREE_CTR_R 

but :

. . importing table   "AGG_CTR_SEDE_TRG_R"
IMP-00020: long column too large for column buffer size (2)raoul oracle

i have used buffer with 64k, 100k, 4M  10M 20M  40M  50M  

60,80,100M but don't work

IMP-6: failed to allocate memory of size 1
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-0: Import terminated unsuccessfully

thanks
Antonio  
___
Visit http://www.visto.com/info, your free web-based communications center.
Visto.com. Life on the Dot.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Antonio Idone
  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).



Physical Design Standards

2001-03-23 Thread Murali Vallath


Any suggestions /books whitepapers on Database Physical Standards

Murali Vallath
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Murali Vallath
  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: NT Server very slow

2001-03-23 Thread Jerry C

Hi Kevin,

Yes, it will suck down the whole processor. We had a new implementation,
with ZERO users, that had the problem.

It is a memory leak of some sort. 8163 fixed it.


- Jerry


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 3:59 PM


> Interesting, i have never heard of this bug.  What do you mean, all of the
> sudden it will suck down the whole processor?  How many users?
>
> -Original Message-
> Sent: Friday, March 23, 2001 3:37 PM
> To: Multiple recipients of list ORACLE-L
>
>
> There is a bug with some version of Oracle (I believe it was 8.1.6.0.0,
but
> don't quote me on that), where even with NO users, oracle.exe would
> eventually consume your whole CPU. The CPU utilization ramps up after a db
> restart until it gets to 99 or 100.
>
> Open Task Manager and check the oracle.exe process.
>
> I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.
>
>
> Good luck!
>
> - Jerry
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 23, 2001 12:17 PM
>
>
> > Since you mention there are only a few users, I would take a look at the
> > jobs these users are running.  Maybe one of these users is firing off a
> > poorly tuned job that brings the database to a grinding halt.
> >
> > Is the database the only product on the Server?  Or are there other
> > applications ( email server, web server...)
> >
> > Jim
> >
> >
> >
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Date: Friday, March 23, 2001 7:50 AM
> >
> >
> > >I have an Oracle 8.1.6 instance on an NT Server.  The application has
> only
> > a
> > >few users.  Very often throughout the day it seems response time drops
to
> > >about 20 seconds.  By the time I log on to look at the problem
everything
> > is
> > >back to normal.  If I do a simple query the result is returned
> immediately.
> > >I have looked at SQL through Quest's SQLAB and there is nothing that
> stand
> > >out.  The hit ratio averages between 88% and 92%.  Is there a good way
to
> > >diagnose this type of problem?
> > >
> > >Ron Smith
> > >Database Administration
> > >[EMAIL PROTECTED]
> > >
> > >--
> > >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: Jim Walski
> >   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!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jerry C
>   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 Kostyszyn
>   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 BO

RE: OT -- A humorous reply to the Canada rulz

2001-03-23 Thread Eric D. Pierce

Bon dia amics d'formigas!

for further background (occasional lefist slant), see:

  http://www.context.org/ICLIB/IC03/CoriGord.htm
-
  http://www.context.org/ICLIB/IC03/TOC03.htm
-
  http://www.context.org/ICLIB/backi.htm
-
  http://www.context.org/ICLIB/IC44/Heart.htm
-


They also have some interesting stuff about the
restoration of democratic/participatory values 
that you should find if you put "Bill Moyers" 
into their search engine;

 http://www.context.org/search_context.html  

regards,
ep

On 21 Mar 2001, at 12:15, Boivin, Patrice J scribbled with alacrity and cogency:

Date sent:  Wed, 21 Mar 2001 12:15:47 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> Here is something a friend of mine sent me today, just to show how
> impossible it is to get consensus on history:
> 
>   Hahahahahahaha. He is so right. I guess our Ministry of
> Propaganda will have to do a little research before they create the next
> rant. 

...

> 
> Also, most of the British troops were freemasons, just as the Americans were
> -- so there was some camaraderie between the two sides, even during the
> "war" of 1812.
> 
> History is never simple.  Never as simple as presented on TV, anyway!

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Michael Netrusov


> > Well, in the case of 100 tables you are still hunting all the
> > code looking for pieces which are relevant to that changed table.
> > Depends on your code. I prefer to encapsulate mine, so
> > reference to a table is enclosed in its own package.
>
> My point is that I can use grep to search the entire code for "order_status"
> and get a short list (maybe 10) of places to look.  It is much more
> difficult to search for "code_table", get a list of 1, then filter
> through the results for some bastardized variety of "code_type = 'STATUS'"
> to get down to those same 10.
>
> Not everything can be encapsulated in a procedure.  This is a database we
> are talking about, so people do still write queries where it is easier to
> join the lookup table to the master table directly.  If the code has to be
> broken out of the central lookup table, you have to update every query that
> joins it in, even if all that query needs is the description.  If it is
> already split out, the only code I really have to be concerned with is the
> places where the new functionality applies.

Queries still can be ( and should be ) encapsulated in packages. If you are taking 
this to-be-enhanced 'status' entity out of the
master lookup table, all you have to do is to develop a new package, change the 
calling code and prohibit the usage of code_type =
'status' in the master lookup table. This still would be changed if you had a separate 
package and table for the 'status' entity.

> > > If I were starting a product from scratch and there was a
> > central code table
> > > I would probably code against a set of views in
> > anticipation of the above
> > > event, so the DBA ends up creating 1 objects anyway.
> >
> > Views consume resources and bring new dependencies, so the
> > administration becomes more complicated.
> > What is your point? If somebody makes a change request, youl
> > still will have to change your code. If you are adding columns and
> > prefer not to change the existing procedures, add a new
> > procedure ( with the same name ) which works with new attributes.
> >
>
> The difficulty is not in making the changes, but in doing the analysis to
> figure out where the changes need to be made.

please see above. The changes still would be made.

> > > On the other hand:
> > > 1. Everywhere I have worked, there has been a central code
> > table of some
> > > sort.
> > > 2. In all cases that code table was put in place by the
> > DBAs, not the
> > > developers, because they didn't want all those tables and
> > were not really
> > > hung up on referential integrity that the application was
> > enforcing anyway.
> >
> > As Steve pointed out, it's just a matter of preference. A few
> > years ago I prefered  multiple similar tables vs one master lookup..
> > Now I implemented the opposite approach and I am happy with
> > it. Less code ( packages consuming memory ), less database objects to
> > administer.

No arguing with the latest passage? :-)

Regards,
Michael Netrusov


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  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: SQL Loader Help in 8.1.6

2001-03-23 Thread Aponte, Tony



Is 
your mainframe using EBCDIC?  If so there is a translation table that 
explains what the "}" translates into.  The sign of the field is trailing 
(E.I.. at the end of the field for non-Cobolers)
 
These 
indicate that the sign of the number is negative.
}=0
R=9
Q=8
P=7
O=6
N=5
M=4
L=-
K=-
J=1
 
These 
are for positive numbers:
{=0
A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I=9
 
The 
example you mentioned (00}) is really all zeroes.  A value of 1023A 
really equals 10231.  An example of a negative number would be 112233R 
which equals -1122339.  The Utilities manual might have a sample of how to 
convert external numbers with trailing signs.  You could also code a 
function to do translation and return the resulting number.  Then you can 
use it in the SqlLdr control file.
 
Tony 
Aponte
 
 -Original Message-From: 
Wendy Y [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 2:47 
PMTo: Multiple recipients of list ORACLE-LSubject: SQL 
Loader Help in 8.1.6

  Dear Experts: 
  This does not make any sense to me, can you help me out? 
  
  I have a control file to interpret the mainframe data and then write to my 
  table in Oracle Database.
  The mainframe data looks like "0}",  The table is designed as 
  Number(10,2),  The control file use zoned(10,2).
  All these combination will work fine on Oracle 7.3/8.0.5, but will fail on 
  8.1.6. (the message said: rejected on XXX field)
  If I modify table as Varchar2(10), it will work, but the data format is not 
  the way I want. the format should be "0.00" when it's 0, instead of "0". 
  Also "+" or "-" should be able to display. How can I make this work in 
  8.1.6?
  Here are part of the control file:
  LOAD DATAREPLACEINTO TABLE 
  C_FINANCIAL    
  (CONSOLI_ID   
  POSITION(001:003) CHAR, 
   
  TAX_CREDIT_AMT   
  POSITION(177:186) zoned(10, 
  2), 
  QTY_ORIGINAL 
  POSITION(187:196) zoned(10),... )
   
  Thanks
  Wendy
  
  
  Do You Yahoo!?Yahoo! Mail Personal 
  Address - Get email at your own domain with Yahoo! 
Mail.


Re: DBMS_REPAIR package usage

2001-03-23 Thread Winnie_Liu



Yong,

Thanks a lot for all the research! :D

The file# that actaully contains this block is 9. My database is not that
big at all.

I did do some research myself and some Oracle analysts in the World Wide
Support does suggest that the influxed blocks are very likely to be a
fractured block. But I reallly have no idea how it got in there... .

Winnie





yong huang <[EMAIL PROTECTED]> on 03/23/2001 04:01:21 PM

To:   [EMAIL PROTECTED]
cc:   [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]



Hi, Winnie,

Just a little more research. I wonder how you can have an rdba that big,
0x24070020, which is 604438560 in decimal.

SQL> var a number;
SQL> exec :a := dbms_utility.data_block_address_file(604438560);

PL/SQL procedure successfully completed.

SQL> print

A
-
  144

SQL> exec :a := dbms_utility.data_block_address_block(604438560);

PL/SQL procedure successfully completed.

SQL> print

A
-
   458784

This is done on 8.1.6. It says the block is in file 144, block 458784. Why
does
your error say file=0? Anyway, in case you do have a file numbered 144,
check
to see if there's an object there. If it's indeed file 0, the dba should be
the
same as block#, 458784, or 0x70020. DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS
can
confirm this. However, that file# 0 may be just an indicator that that
information is lost, as multiple other 0's look like.

I believe dbv reports an error when it encounters a fractured block, i.e.,
the
first two bytes of tail (0003 in your case) does not match the last two
bytes
of rdba (0020). We know how a fractured block is created during hot backup.
But
I don't understand why an offlined datafile (as you said in another email)
can
contain fractured blocks. Maybe Jeremiah Wilton can give a better answer.

Yong Huang
[EMAIL PROTECTED]

you wrote:

I have a datafile in my production box (a user data tablespace), when I run
dbv against it, it showed that 5 blocks are "influxed"

Page 458784 is influx - most likely media corrupt
***
Corrupt block relative dba: 0x24070020 file=0. blocknum=458784.
Fractured block found during dbv:
Data in bad block - type:0. format:0. rdba:0x
last change scn:0x. seq:0x0 flg:0x00
consistancy value in tail 0x0003c204
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0

We can copy this file to tape, dd this file. On the OS disk level, the OS
does
n
ot treat this as corrupted. But it is corrupted on the oracle
(software) level.

I've checked and can't find any object associate with these 5 corrupted
blcok.

That means that there is no data inside those blocks.

Since the tablespace is about 12 GB on a highly active system (which only
got 3
hours maintance window each month), export/import (then drop the
tablespace)
which Oracle support suggested is mostly out of the question. (Especially,
it
is
 very hard for me to convince the sysadmin that the blocks are
corrupted
as they don't see any I/O error associate with this file and the developers
don'
t see any problem with the application either!)

I am currently thinking about upgrading this database to 8.1.6 to make use
of
th
e DBMS_REPAIR package to make those blocks as "unusable". But I
am not sure that if the DBMS_REPAIR package can run against the blocks
which do
not belong to any objects!! Can someone  give me some
guidences?

thanks

Winnie


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/




-- 
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: NT Server very slow

2001-03-23 Thread Jerry C

check out Doc ID 941798 at Metalink...


- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 3:36 PM


> There is a bug with some version of Oracle (I believe it was 8.1.6.0.0,
but
> don't quote me on that), where even with NO users, oracle.exe would
> eventually consume your whole CPU. The CPU utilization ramps up after a db
> restart until it gets to 99 or 100.
>
> Open Task Manager and check the oracle.exe process.
>
> I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.
>
>
> Good luck!
>
> - Jerry
>
>
> - Original Message -
> From: "Jim Walski" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, March 23, 2001 12:17 PM
> Subject: Re: NT Server very slow
>
>
> > Since you mention there are only a few users, I would take a look at the
> > jobs these users are running.  Maybe one of these users is firing off a
> > poorly tuned job that brings the database to a grinding halt.
> >
> > Is the database the only product on the Server?  Or are there other
> > applications ( email server, web server...)
> >
> > Jim
> >
> >
> >
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Date: Friday, March 23, 2001 7:50 AM
> >
> >
> > >I have an Oracle 8.1.6 instance on an NT Server.  The application has
> only
> > a
> > >few users.  Very often throughout the day it seems response time drops
to
> > >about 20 seconds.  By the time I log on to look at the problem
everything
> > is
> > >back to normal.  If I do a simple query the result is returned
> immediately.
> > >I have looked at SQL through Quest's SQLAB and there is nothing that
> stand
> > >out.  The hit ratio averages between 88% and 92%.  Is there a good way
to
> > >diagnose this type of problem?
> > >
> > >Ron Smith
> > >Database Administration
> > >[EMAIL PROTECTED]
> > >
> > >--
> > >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: Jim Walski
> >   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!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jerry C
  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: DBMS_REPAIR package usage

2001-03-23 Thread yong huang

Hi, Winnie,

Just a little more research. I wonder how you can have an rdba that big,
0x24070020, which is 604438560 in decimal.

SQL> var a number;
SQL> exec :a := dbms_utility.data_block_address_file(604438560);

PL/SQL procedure successfully completed.

SQL> print

A
-
  144

SQL> exec :a := dbms_utility.data_block_address_block(604438560);

PL/SQL procedure successfully completed.

SQL> print

A
-
   458784

This is done on 8.1.6. It says the block is in file 144, block 458784. Why does
your error say file=0? Anyway, in case you do have a file numbered 144, check
to see if there's an object there. If it's indeed file 0, the dba should be the
same as block#, 458784, or 0x70020. DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS can
confirm this. However, that file# 0 may be just an indicator that that
information is lost, as multiple other 0's look like.

I believe dbv reports an error when it encounters a fractured block, i.e., the
first two bytes of tail (0003 in your case) does not match the last two bytes
of rdba (0020). We know how a fractured block is created during hot backup. But
I don't understand why an offlined datafile (as you said in another email) can
contain fractured blocks. Maybe Jeremiah Wilton can give a better answer.

Yong Huang
[EMAIL PROTECTED]

you wrote:

I have a datafile in my production box (a user data tablespace), when I run
dbv against it, it showed that 5 blocks are "influxed"

Page 458784 is influx - most likely media corrupt
***
Corrupt block relative dba: 0x24070020 file=0. blocknum=458784.
Fractured block found during dbv:
Data in bad block - type:0. format:0. rdba:0x
last change scn:0x. seq:0x0 flg:0x00
consistancy value in tail 0x0003c204
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0

We can copy this file to tape, dd this file. On the OS disk level, the OS does
n
ot treat this as corrupted. But it is corrupted on the oracle
(software) level.

I've checked and can't find any object associate with these 5 corrupted blcok.

That means that there is no data inside those blocks.

Since the tablespace is about 12 GB on a highly active system (which only got 3
hours maintance window each month), export/import (then drop the
tablespace)
which Oracle support suggested is mostly out of the question. (Especially, it
is
 very hard for me to convince the sysadmin that the blocks are
corrupted
as they don't see any I/O error associate with this file and the developers
don'
t see any problem with the application either!)

I am currently thinking about upgrading this database to 8.1.6 to make use of
th
e DBMS_REPAIR package to make those blocks as "unusable". But I
am not sure that if the DBMS_REPAIR package can run against the blocks which do
not belong to any objects!! Can someone  give me some
guidences?

thanks

Winnie


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: yong huang
  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: SQL Loader Help in 8.1.6

2001-03-23 Thread Dennis Taylor
At 11:47 AM 3/23/01 -0800, you wrote: 

The mainframe data looks like "0}",  The table is designed as Number(10,2),  The control file use zoned(10,2). 


That looks like the internal representation for a signed number under COBOL. The least significant digit (LSD) is used to store the sign. If the stored number is negative, the LSD is stored as '}' instead of '0', or 'J' through 'R' for 1-9. If the number is positive, you just see the number as is.





Dennis Taylor

Happiness is Friday at 5:00

--  Please see the official ORACLE-L FAQ: http://www.orafaq.com --  Author: Dennis Taylor 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: Log Buffer

2001-03-23 Thread Mohan, Ross
Title: RE: Log Buffer





v$filestats data?


just curious


-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Log Buffer



Oops,
    All right, I give up, I am dumb.
Kev


-Original Message-
McDonald
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L



The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.


It is very rare to a lot of a benefit once your log
buffer gets more than 512k.


hth
connor


--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hello
DBA's
>   You know, I read somewhere that you can make your
> log_buffer 10 percent of
> your total sga.  So if you had a 500mb sga you could
> have a 50 mb
> log_buffer?  What do you guys think, the illustrious
> Ross doesn't like such
> large log_buffers.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   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).



=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)


"Some days you're the pigeon, some days you're the statue"



Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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 Kostyszyn
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Toepke, Kevin M

I've found so many bugs in code caused by developers forgetting to add "AND
code_type = 'SOME_VALUE'" to there WHERE clauses when multi-purpose code
tables are used.

Kevin Toepke

-
The information in this electronic mail message is Cendant Confidential
and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
-
The sender believes that this E-mail and any attachments were free of
any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation is not
liable for any loss or damage arising in any way from this message or
its attachments.
-


-Original Message-
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L


Snipped text

> > The DBA work on that is easy, but then the developers go 
> hunting in all the
> > existing program code that hits the code table (haystack) 
> to find all the
> > places where that program code is actually using the code 
> in question
> > (needle).
> 
> Well, in the case of 100 tables you are still hunting all the 
> code looking for pieces which are relevant to that changed table.
> Depends on your code. I prefer to encapsulate mine, so
> reference to a table is enclosed in its own package.

My point is that I can use grep to search the entire code for "order_status"
and get a short list (maybe 10) of places to look.  It is much more
difficult to search for "code_table", get a list of 1, then filter
through the results for some bastardized variety of "code_type = 'STATUS'"
to get down to those same 10.

Not everything can be encapsulated in a procedure.  This is a database we
are talking about, so people do still write queries where it is easier to
join the lookup table to the master table directly.  If the code has to be
broken out of the central lookup table, you have to update every query that
joins it in, even if all that query needs is the description.  If it is
already split out, the only code I really have to be concerned with is the
places where the new functionality applies.

> 
> > If I were starting a product from scratch and there was a 
> central code table
> > I would probably code against a set of views in 
> anticipation of the above
> > event, so the DBA ends up creating 1 objects anyway.
> 
> Views consume resources and bring new dependencies, so the 
> administration becomes more complicated.
> What is your point? If somebody makes a change request, youl 
> still will have to change your code. If you are adding columns and
> prefer not to change the existing procedures, add a new 
> procedure ( with the same name ) which works with new attributes.
> 

The difficulty is not in making the changes, but in doing the analysis to
figure out where the changes need to be made.

> > On the other hand:
> > 1. Everywhere I have worked, there has been a central code 
> table of some
> > sort.
> > 2. In all cases that code table was put in place by the 
> DBAs, not the
> > developers, because they didn't want all those tables and 
> were not really
> > hung up on referential integrity that the application was 
> enforcing anyway.
> 
> As Steve pointed out, it's just a matter of preference. A few 
> years ago I prefered  multiple similar tables vs one master lookup..
> Now I implemented the opposite approach and I am happy with 
> it. Less code ( packages consuming memory ), less database objects to
> administer.
> 


Brian Norrell
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Norrell, Brian
  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: Toepke, Kevin M
  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 li

Re: Crontab

2001-03-23 Thread David A. Barbour

Luc,

One possible solution:

Run the cron every Sunday and have the first part of your shell script
check to see if that day's date plus seven days falls into another
month.

Regards,

David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth

"DEMANCHE Luc (Cetelem)" wrote:
> 
> Hi gurus,
> 
> I want to schedule a script to run on the fourth sunday of the month.
> 
> How can I do that ?
> 
> TIA
> 
> -
> Luc Demanche
> CETELEM
> Tél.: 01-46-39-14-49
> Fax : 01-46-39-59-88
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  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: Log Buffer

2001-03-23 Thread Jesse, Rich

Hey Kevin,

My Oracle Perf Tuning instructor suggested doubling the LOG_BUFFER until the
requests get under control.  Problem is that each bump requires a reboot.
Since ours was severe enough, I went from 1MB to 4MB.  When that wasn't
enough, I went to 12MB.  This is over the course of almost 12 months, due to
uptime requirements.

This is fine unless your rego log files are in contention with other
datafiles (archives, datafiles, controlfiles) in the database.  A larger
LOG_BUFFER may help, but it's just a workaround for the underlying problem.

For now, our whole shmear is on an HP AutoRaid.  I know, I know.  It seemed
like a good idea at the time (before Oracle training).  I'm seeing LGWR
write times up to over a second at peak.  Not only that, but even with a
LOG_BUFFER of 12MB in a 500MB total SGA w/175 users, I'm getting almost 3000
redo space requests per week.  Ouch.

Oh, to be able to use Loney's 15-drive setup.  Hell, I'm not asking for 22!

BTW, I'm on 8.0.5.2.0 on HP/UX 10.20.  Next week is HP/UX 11.0, with 8.1.7
and an extra RAID0 for my redos to follow.  Yay!

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

> -Original Message-
> From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 14:06
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Log Buffer
> 
> 
> yes, I think that does help.  I am thinking I am going to 
> make them larger?
> 21 requests
> 
> -Original Message-
> Sent: Friday, March 23, 2001 2:46 PM
> To: 'Kevin Kostyszyn '
> 
> 
> Hi...
> 
> I don't think so...
> 
> you must adjust your LOG_BUFFER acoording to:
> 
> select  substr(name,1,25) Name,
> substr(value,1,15) "VALUE (Near 0?)"
> from v$sysstat
> where name = 'redo log space requests';
> 
> Hope this help!
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 3/23/01 8:35 AM
> 
> Hello DBA's
>   You know, I read somewhere that you can make your log_buffer 10
> percent of
> your total sga.  So if you had a 500mb sga you could have a 50 mb
> log_buffer?  What do you guys think, the illustrious Ross doesn't like
> such
> large log_buffers.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]


---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
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:Dumb question...

2001-03-23 Thread Oracle DBA

if u get this to work let me know.  i had a source
view and i got "object type not allowed error'  i had
to go to underlying table to create snapshot.

--- [EMAIL PROTECTED] wrote:
> Scott,
> 
> Yes, "create snapshot 
> refresh complete
> start with 
> next 
> as select * from ;"
> 
> 
> Reply
> Separator
> Author: [EMAIL PROTECTED]
> Date:   3/23/2001 9:11 AM
> 
> I am not at my terminal where my online docs reside
> and I can't get out to
> metalink ATT - or I wouldn't ask, but:
> 
> Can a simple snapshot be created on a view?  View on
> master site tables, I
> want a snapsot of the view data on the remote
> system.  Oracle 7.3.3, HPUX.
> 
> Thanks,
> 
> Scott Shafer
> San Antonio, TX
> 
> "2+2=5, for very large values of 2..."
> 
> 
> -- 
> 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!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  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: Log Buffer

2001-03-23 Thread Kevin Kostyszyn

Oops,
All right, I give up, I am dumb.
Kev

-Original Message-
McDonald
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L


The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.

It is very rare to a lot of a benefit once your log
buffer gets more than 512k.

hth
connor

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hello
DBA's
>   You know, I read somewhere that you can make your
> log_buffer 10 percent of
> your total sga.  So if you had a 500mb sga you could
> have a 50 mb
> log_buffer?  What do you guys think, the illustrious
> Ross doesn't like such
> large log_buffers.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   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).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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 Kostyszyn
  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: Log Buffer

2001-03-23 Thread Kevin Kostyszyn



-Original Message-
McDonald
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L


The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.

It is very rare to a lot of a benefit once your log
buffer gets more than 512k.

hth
connor

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hello
DBA's
>   You know, I read somewhere that you can make your
> log_buffer 10 percent of
> your total sga.  So if you had a 500mb sga you could
> have a 50 mb
> log_buffer?  What do you guys think, the illustrious
> Ross doesn't like such
> large log_buffers.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   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).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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 Kostyszyn
  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: NT Server very slow

2001-03-23 Thread Kevin Kostyszyn

Interesting, i have never heard of this bug.  What do you mean, all of the
sudden it will suck down the whole processor?  How many users?

-Original Message-
Sent: Friday, March 23, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L


There is a bug with some version of Oracle (I believe it was 8.1.6.0.0, but
don't quote me on that), where even with NO users, oracle.exe would
eventually consume your whole CPU. The CPU utilization ramps up after a db
restart until it gets to 99 or 100.

Open Task Manager and check the oracle.exe process.

I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.


Good luck!

- Jerry


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 12:17 PM


> Since you mention there are only a few users, I would take a look at the
> jobs these users are running.  Maybe one of these users is firing off a
> poorly tuned job that brings the database to a grinding halt.
>
> Is the database the only product on the Server?  Or are there other
> applications ( email server, web server...)
>
> Jim
>
>
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Friday, March 23, 2001 7:50 AM
>
>
> >I have an Oracle 8.1.6 instance on an NT Server.  The application has
only
> a
> >few users.  Very often throughout the day it seems response time drops to
> >about 20 seconds.  By the time I log on to look at the problem everything
> is
> >back to normal.  If I do a simple query the result is returned
immediately.
> >I have looked at SQL through Quest's SQLAB and there is nothing that
stand
> >out.  The hit ratio averages between 88% and 92%.  Is there a good way to
> >diagnose this type of problem?
> >
> >Ron Smith
> >Database Administration
> >[EMAIL PROTECTED]
> >
> >--
> >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: Jim Walski
>   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!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jerry C
  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 Kostyszyn
  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: Moving user to a different tablespace ...

2001-03-23 Thread William Beilstein

Export the user, drop it's objects, alter to user to use the correct tablespace as 
it's default tablespace. Set quota on system to none, set quota on new tablespace to 
unlimited, import the objects. Done.

>>> [EMAIL PROTECTED] 03/23/01 02:07PM >>>
look at alter user command, yes break out the documentation and begin 
reading.

joe



>From: Harsh Agrawal <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Moving user to a different tablespace ...
>Date: Fri, 23 Mar 2001 08:10:38 -0800
>MIME-Version: 1.0
>Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net 
>(8.9.3/8.8.7) with ESMTP id NAA14937for ; Fri, 23 Mar 
>2001 13:42:01 -0500
>Received: from mail.the-testas.netby localhost with POP3 
>(fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Fri, 23 Mar 2001 
>13:42:02 -0500 (EST)
>Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by 
>mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2NJjp013747for 
><[EMAIL PROTECTED]>; Fri, 23 Mar 2001 13:45:52 -0600
>Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
>(8.9.3/8.9.3) with UUCP id KAA26614;Fri, 23 Mar 2001 10:29:04 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002D6239; 
>Fri, 23 Mar 2001 08:10:38 -0800
>Return-Path: <[EMAIL PROTECTED]>
>Message-ID: <[EMAIL PROTECTED]>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: Harsh Agrawal <[EMAIL PROTECTED]>
>Sender: [EMAIL PROTECTED] 
>Errors-To: [EMAIL PROTECTED] 
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match 
>any local name
>X-SpamBouncer: 1.2 (10/20/00)
>X-SBPass: NoBounce
>X-SBClass: OK
>Status:
>
>By mistake a user was assigned default tablespace SYSTEM.
>How we can change it to some new tablespace let's say "TBS1" ?
>Because if we do export and import it will again import into that "SYSTEM"
>tablespace.
>
>Thanks,
>- Harsh
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Harsh Agrawal
>   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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Joseph Testa
  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: William Beilstein
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Norrell, Brian

Snipped text

> > The DBA work on that is easy, but then the developers go 
> hunting in all the
> > existing program code that hits the code table (haystack) 
> to find all the
> > places where that program code is actually using the code 
> in question
> > (needle).
> 
> Well, in the case of 100 tables you are still hunting all the 
> code looking for pieces which are relevant to that changed table.
> Depends on your code. I prefer to encapsulate mine, so
> reference to a table is enclosed in its own package.

My point is that I can use grep to search the entire code for "order_status"
and get a short list (maybe 10) of places to look.  It is much more
difficult to search for "code_table", get a list of 1, then filter
through the results for some bastardized variety of "code_type = 'STATUS'"
to get down to those same 10.

Not everything can be encapsulated in a procedure.  This is a database we
are talking about, so people do still write queries where it is easier to
join the lookup table to the master table directly.  If the code has to be
broken out of the central lookup table, you have to update every query that
joins it in, even if all that query needs is the description.  If it is
already split out, the only code I really have to be concerned with is the
places where the new functionality applies.

> 
> > If I were starting a product from scratch and there was a 
> central code table
> > I would probably code against a set of views in 
> anticipation of the above
> > event, so the DBA ends up creating 1 objects anyway.
> 
> Views consume resources and bring new dependencies, so the 
> administration becomes more complicated.
> What is your point? If somebody makes a change request, youl 
> still will have to change your code. If you are adding columns and
> prefer not to change the existing procedures, add a new 
> procedure ( with the same name ) which works with new attributes.
> 

The difficulty is not in making the changes, but in doing the analysis to
figure out where the changes need to be made.

> > On the other hand:
> > 1. Everywhere I have worked, there has been a central code 
> table of some
> > sort.
> > 2. In all cases that code table was put in place by the 
> DBAs, not the
> > developers, because they didn't want all those tables and 
> were not really
> > hung up on referential integrity that the application was 
> enforcing anyway.
> 
> As Steve pointed out, it's just a matter of preference. A few 
> years ago I prefered  multiple similar tables vs one master lookup..
> Now I implemented the opposite approach and I am happy with 
> it. Less code ( packages consuming memory ), less database objects to
> administer.
> 


Brian Norrell
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Norrell, Brian
  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: Crontab

2001-03-23 Thread Hand, Michael T

Unfortunately the previous suggestion would run every Sunday AND on each day
on the 22nd to the 28th.  Your 2 choices are

MM HH 22-28 * * (shell script checks for Sunday before proceeding)
OR
MM HH * * 0  (shell script checks for day of month between 22 and 28 before
proceeding)

Mike

-Original Message-

crontab -e
insert a line with
 
Mi HH24 22-28 * 0 comandline
 
- Hitarth 

-Original Message-
I want to schedule a script to run on the fourth sunday of the month. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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: Log Buffer

2001-03-23 Thread Connor McDonald

The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.

It is very rare to a lot of a benefit once your log
buffer gets more than 512k.

hth
connor

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hello
DBA's
>   You know, I read somewhere that you can make your
> log_buffer 10 percent of
> your total sga.  So if you had a 500mb sga you could
> have a 50 mb
> log_buffer?  What do you guys think, the illustrious
> Ross doesn't like such
> large log_buffers.
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Kevin Kostyszyn
>   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).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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).



Denouement: RE: Log Buffer

2001-03-23 Thread Mohan, Ross
Title: RE: Log Buffer



:-)...that's what I do: ask the experts. 
 
But, 
it's a moving target!
 
take 
care

  -Original Message-From: Kevin Kostyszyn 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 3:06 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Log Buffer
  Yeah, illustrioius, that's good thing isn't it?  Isn't that what 
  someone called Lord Vador in Star Wars.noo non no, it was Jabba the 
  hut.  Ok, I take back the illustrious, I'll think of some other large 
  word that sounds cool!
  I 
  don't, it was just a question, when you don't know for sure you might as well 
  ask the experts.
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
Friday, March 23, 2001 2:32 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Log Buffer
"illustrious"? 
oh my. I  can see I am going to have to be 
even more frivolous, irreverent, and non-topical. 

..."gee, if I had a 4 GB SGA, 
I guess i'd need a 400 Megabyte log buffer...yea, 
sure, that makes sense" 
-Original Message- From: 
Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 23, 2001 9:36 AM To: Multiple recipients of list ORACLE-L Subject: Log Buffer 
Hello DBA's 
    You know, I read 
somewhere that you can make your log_buffer 10 percent of your total sga.  So if you had a 500mb sga you could have a 50 
mb log_buffer?  What do you guys think, the 
illustrious Ross doesn't like such large 
log_buffers. 
Sincerely, Kevin Kostyszyn 
DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] 
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn   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: Log Buffer

2001-03-23 Thread Kevin Kostyszyn

yes, I think that does help.  I am thinking I am going to make them larger?
21 requests

-Original Message-
Sent: Friday, March 23, 2001 2:46 PM
To: 'Kevin Kostyszyn '


Hi...

I don't think so...

you must adjust your LOG_BUFFER acoording to:

select  substr(name,1,25) Name,
substr(value,1,15) "VALUE (Near 0?)"
from v$sysstat
where name = 'redo log space requests';

Hope this help!

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/23/01 8:35 AM

Hello DBA's
You know, I read somewhere that you can make your log_buffer 10
percent of
your total sga.  So if you had a 500mb sga you could have a 50 mb
log_buffer?  What do you guys think, the illustrious Ross doesn't like
such
large log_buffers.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  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 Kostyszyn
  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: Crontab

2001-03-23 Thread Donald Bricker

Luc,

If you do not find a more graceful way of doing this the following will work.
Set 7 different lines in crontab all with 0 for the day-of-week. Then also set the 
day-of-month for each one from 22 to 28. Kind of cumbersome and clutters up crontab, 
but it will get you what you need.
22nd is the lowest value that the 4th Sunday in a month could be if the 1st is on a 
Sunday. 28th is the highest value that a Sunday could be when the 1st is a Monday. And 
a third or fifth Sunday could never be these dates.

Don Bricker
Information Systems Analyst
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
[EMAIL PROTECTED]
(217) 558-2290

>>> "DEMANCHE Luc (Cetelem)" <[EMAIL PROTECTED]> 03/23/01 10:10AM >>>

Hi gurus, 
I want to schedule a script to run on the fourth sunday of the month. 
How can I do that ? 
TIA 
- 
Luc Demanche 
CETELEM 
Tél.: 01-46-39-14-49 
Fax : 01-46-39-59-88 




Luc,
 
If you do not find a more graceful way of doing this the following will 
work.
Set 7 different lines in crontab all with 0 for the day-of-week. Then also 
set the day-of-month for each one from 22 to 28. Kind of cumbersome and clutters 
up crontab, but it will get you what you need.
22nd is the lowest value that the 4th Sunday in a month could be if 
the 1st is on a Sunday. 28th is the highest value that a Sunday could be when 
the 1st is a Monday. And a third or fifth Sunday could never be these 
dates.
 
Don BrickerInformation Systems AnalystIllinois Environmental 
Protection Agency1021 North Grand Avenue EastMail Code 
#32Springfield, IL 62794-9276[EMAIL PROTECTED](217) 
558-2290
 
>>> "DEMANCHE Luc (Cetelem)" <[EMAIL PROTECTED]> 
03/23/01 10:10AM >>>
Hi gurus, 
I want to schedule a script to run on the fourth 
sunday of the month. 
How can I do that ? 
TIA 
- Luc Demanche CETELEM 
Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88 


Re: NT Server very slow

2001-03-23 Thread Jerry C

There is a bug with some version of Oracle (I believe it was 8.1.6.0.0, but
don't quote me on that), where even with NO users, oracle.exe would
eventually consume your whole CPU. The CPU utilization ramps up after a db
restart until it gets to 99 or 100.

Open Task Manager and check the oracle.exe process.

I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.


Good luck!

- Jerry


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 12:17 PM


> Since you mention there are only a few users, I would take a look at the
> jobs these users are running.  Maybe one of these users is firing off a
> poorly tuned job that brings the database to a grinding halt.
>
> Is the database the only product on the Server?  Or are there other
> applications ( email server, web server...)
>
> Jim
>
>
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Friday, March 23, 2001 7:50 AM
>
>
> >I have an Oracle 8.1.6 instance on an NT Server.  The application has
only
> a
> >few users.  Very often throughout the day it seems response time drops to
> >about 20 seconds.  By the time I log on to look at the problem everything
> is
> >back to normal.  If I do a simple query the result is returned
immediately.
> >I have looked at SQL through Quest's SQLAB and there is nothing that
stand
> >out.  The hit ratio averages between 88% and 92%.  Is there a good way to
> >diagnose this type of problem?
> >
> >Ron Smith
> >Database Administration
> >[EMAIL PROTECTED]
> >
> >--
> >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: Jim Walski
>   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!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jerry C
  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: Tuning Matter ==> Parameter PCT_USED in a Table

2001-03-23 Thread Ron Rogers

Harsh,
  The columns size listed in the formula was for the maximum size of the number 
column. The remaining columns are fixed in size.
 The size of a row is determined by 3 factors: 
1. Row header 3 bytes
2. column data varying on size requirements and datatype
3. length byte for each column.
Using the maximum for each column will give you the 142 bytes but using
the actual values for the numeric field in the calculation produces:
total=3+50+8=61 byte max in each row of data.
The size between the average and the max is normal. The only way to have the max=avg 
is to use CHAR not VARCHAR. 
  It will also waste space and at the same time greatly reduce the change of chained 
rows.
I thank you for pointing out the lack of the wording (maximum) in the number sizing. I 
have updated my table size calculations sheet.
Thanks again.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/23/01 11:31AM >>>
Hi Ron,
Let's take a example:

SQL> desc emp
 NameNull?TypeBYTES
 --  --  -- 
 EMPNO  NOT NULL NUMBER(4)   21
 ENAME   VARCHAR2(10)10
 JOB VARCHAR2(9)  9
 MGR NUMBER(4)   21
 HIREDATEDATE 7
 SAL NUMBER(7,2) 21 
 COMMNUMBER(7,2) 21
 DEPTNO  NUMBER(2)   21 

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF 
COLUMNS > 250)

So according to ur formula

TOTAL=3+131+8=142 BYTES

Is this OK 'coz after analyzing the table with COMPUTE I got AVG_ROW_LEN 40.

Can there be such a HUGE difference ?

Pl. comment. 

Thanks,
- Harsh

-Original Message-
Sent: Friday, March 23, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


max(row size) is the sum of all of the columns sizes in the 
table plus overhead.
The following is the column sizes and the sum formula to 
calculate the size of a row in a data block.

NUMBER =21
CHAR = COLUMN SIZE
VARCHAR = COLUMN SIZE
DATE = 7

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF 
COLUMNS > 250)

This is part of the calculations used to determine the storage 
needed for a table.

OR: you could analyze you table and use the average row size is 
you need a general calculation of actual usage.

ROR mª¿ªm


>>> [EMAIL PROTECTED] 03/22/01 08:45PM >>>
Dear Listers,

I've download a presentation talking about Calculating PCT_USED .
the formula is quite simple :
PCT_USED + PCT_FREE < 100
PCT_USED = PCT_FREE + 1 row size

but I have no idea to calculate the size of 1 row in a table .

is there anyone who knows to calculate it  ? 
or any alternative formula to calculate PCT_USED ?

Thanks a lot in advance  : )

=bambang=


<> Bambang Setiawan <>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Bambang Setiawan
  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 Rogers
  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: Harsh Agrawal
  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 Rogers
  INET: [EMAIL PROTECTED]

Fat City Netwo

SQL Loader Help in 8.1.6

2001-03-23 Thread Wendy Y
Dear Experts:
This does not make any sense to me, can you help me out?

I have a control file to interpret the mainframe data and then write to my table in Oracle Database.
The mainframe data looks like "0}",  The table is designed as Number(10,2),  The control file use zoned(10,2).
All these combination will work fine on Oracle 7.3/8.0.5, but will fail on 8.1.6. (the message said: rejected on XXX field)
If I modify table as Varchar2(10), it will work, but the data format is not the way I want. the format should be "0.00" when it's 0, instead of "0". Also "+" or "-" should be able to display. How can I make this work in 8.1.6?
Here are part of the control file:
LOAD DATAREPLACEINTO TABLE C_FINANCIAL    (CONSOLI_ID   POSITION(001:003) CHAR, 
 TAX_CREDIT_AMT   POSITION(177:186) zoned(10, 2), QTY_ORIGINAL POSITION(187:196) zoned(10),... )
 
Thanks
WendyDo You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

RE: Moving user to a different tablespace ...

2001-03-23 Thread Miller, Dave

ONE approach would be.

- export owner=username
- drop the user, AFTER making sure you have available DDL to re-create them.
- re-create the user with the correct info.
- import using fromuser touser and ignore=y

of course if the user owns no objects, just user alter user...



-Original Message-
Sent: Friday, March 23, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


By mistake a user was assigned default tablespace SYSTEM. 
How we can change it to some new tablespace let's say "TBS1" ?
Because if we do export and import it will again import into that "SYSTEM"
tablespace.

Thanks,
- Harsh
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harsh Agrawal
  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: Miller, 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: User define functions (queries) in SELECT statements

2001-03-23 Thread Dan . Hubler



Thanks for replying.

I need to start this by correcting the subject line I put on this
originally.
I am talking about user-defined FUNCTIONS within a SELECT.
Sorry.

The explain plans look exactly the same.
Strangely enough, the small tables that are read in the user-defined
functions
do NOT appear in the explain plan (!?!?!?!?!!?).

Yes.we did re-analyze after the software upgrade.

Thanks again.








"Charlie Mengler" <[EMAIL PROTECTED]> on 03/23/2001 11:55:17 AM

To:   [EMAIL PROTECTED]
cc:


What do the before (V7) and after (V8) explain plans look like?
Have you (re)analyzed all tables & indexes used by the query?


[EMAIL PROTECTED] wrote:
>
> We have run into a big performance issue with our migration from 7.3.4
to
> 8.1.6.
>
> A single query that SELECTs from a large table, also contains
user-defined
> functions that
> appear in the column-list of the SELECT.
>
> This query is running many times longer than under the old version.
>
> Anybody see this before?
>
> (Solaris 2.6)
>
> --
> 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).

--
Charlie Mengler   Maintenance Warehouse
[EMAIL PROTECTED]  10641 Scripps Summit Ct
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.




-- 
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: ? 805 and 815 client question

2001-03-23 Thread Rodd Holman

If you just have the clients installed on your machine, you need to get the 
CD and do an install for Database Administrator, or do a custom install and 
install the Oracle8 Utilities.

On Friday 23 March 2001 13:26, you wrote:
> Hi all,
>
> I have 805, 815 clients installed on NT4.0.  815's
> sqlplus and svrmgrl work fine.  But in 805/bin, there
> is no svrmgrl (or similar name) at all, and when I run
> sqlplus, something flashed for about 1/100 second and
> then nothing special happened (went back to the DOS
> prompt).  Any suggestion before I reinstall 805
> client?
>
> I was told briefly that our application is using 815
> server but 805 client.  I haven't got a chance to find
> out what the reason for this.  Does anybody use this
> kind of combination before and why?
>
> Thanks a lot.
>
> Leslie
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  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: Log Buffer

2001-03-23 Thread Kevin Kostyszyn
Title: RE: Log Buffer



Yeah, 
illustrioius, that's good thing isn't it?  Isn't that what someone called 
Lord Vador in Star Wars.noo non no, it was Jabba the hut.  Ok, I take 
back the illustrious, I'll think of some other large word that sounds 
cool!
I 
don't, it was just a question, when you don't know for sure you might as well 
ask the experts.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Friday, March 23, 2001 2:32 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Log Buffer
  "illustrious"? 
  oh my. I  can see I am going to have to be 
  even more frivolous, irreverent, and non-topical. 
  ..."gee, if I had a 4 GB SGA, 
  I guess i'd need a 400 Megabyte log buffer...yea, 
  sure, that makes sense" 
  -Original Message- From: Kevin 
  Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:36 AM To: 
  Multiple recipients of list ORACLE-L Subject: Log 
  Buffer 
  Hello DBA's 
      You know, I read 
  somewhere that you can make your log_buffer 10 percent of your total sga.  So if you had a 500mb sga you could have a 50 
  mb log_buffer?  What do you guys think, the 
  illustrious Ross doesn't like such large 
  log_buffers. 
  Sincerely, Kevin Kostyszyn 
  DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn   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: Crontab

2001-03-23 Thread Trivedi, Hitarth

crontab -e
insert a line with
 
Mi HH24 22-28 * 0 comandline
 
- Hitarth 

-Original Message-
Sent: Friday, March 23, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L



Hi gurus, 

I want to schedule a script to run on the fourth sunday of the month. 

How can I do that ? 

TIA 

- 
Luc Demanche 
CETELEM 
Tél.: 01-46-39-14-49 
Fax : 01-46-39-59-88 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trivedi, Hitarth
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Michael Netrusov

- Original Message -

> Preface: I am a developer!
>
> If the DBA wants to have 1 tables, no skin off my nose.  A generic
> maintenance form and LOV form for a set of tables all with the same format
> is not that huge a task.
>
> The best developer argument AGAINST a centralized code table is that
> eventually someone will request an enhancement that adds functionality to
> one of the codes beyond a simple code/description table.  This means the
> codes have to be pulled out of the central code table and created as a new
> table with the 3 flags and 5 coded fields to support the new functionality.
> The DBA work on that is easy, but then the developers go hunting in all the
> existing program code that hits the code table (haystack) to find all the
> places where that program code is actually using the code in question
> (needle).

Well, in the case of 100 tables you are still hunting all the code looking for pieces 
which are relevant to that changed table.
Depends on your code. I prefer to encapsulate mine, so
reference to a table is enclosed in its own package.

> If I were starting a product from scratch and there was a central code table
> I would probably code against a set of views in anticipation of the above
> event, so the DBA ends up creating 1 objects anyway.

Views consume resources and bring new dependencies, so the administration becomes more 
complicated.
What is your point? If somebody makes a change request, youl still will have to change 
your code. If you are adding columns and
prefer not to change the existing procedures, add a new procedure ( with the same name 
) which works with new attributes.

> On the other hand:
> 1. Everywhere I have worked, there has been a central code table of some
> sort.
> 2. In all cases that code table was put in place by the DBAs, not the
> developers, because they didn't want all those tables and were not really
> hung up on referential integrity that the application was enforcing anyway.

As Steve pointed out, it's just a matter of preference. A few years ago I prefered  
multiple similar tables vs one master lookup..
Now I implemented the opposite approach and I am happy with it. Less code ( packages 
consuming memory ), less database objects to
administer.

Regards,
Michael Netrusov
www.atelo.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Ron Rogers

At one of the Oraccle Applications User meetings, Oracle displayed the new table 
layout for the 11i version. It basically was one table with a lot of columns for the 
application that was talked about. I asked about the normalization of the data and the 
reply was in the form: it will take more disk reads to gather data from many tables 
where if the data is in one table, the heads are already in position and you get your 
data faster than multiple reads.
 For what it's worth
ROR mª¿ªm


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  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: Moving user to a different tablespace ...

2001-03-23 Thread Terry Ball

What version of Oracle?  With 8i + you have the ability to mover a table to
a different tablespace.

Terry

Harsh Agrawal wrote:

> By mistake a user was assigned default tablespace SYSTEM.
> How we can change it to some new tablespace let's say "TBS1" ?
> Because if we do export and import it will again import into that "SYSTEM"
> tablespace.
>
> Thanks,
> - Harsh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harsh Agrawal
>   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: Terry Ball
  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: Moving user to a different tablespace ...

2001-03-23 Thread Joseph Testa

look at alter user command, yes break out the documentation and begin 
reading.

joe



>From: Harsh Agrawal <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Moving user to a different tablespace ...
>Date: Fri, 23 Mar 2001 08:10:38 -0800
>MIME-Version: 1.0
>Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net 
>(8.9.3/8.8.7) with ESMTP id NAA14937for ; Fri, 23 Mar 
>2001 13:42:01 -0500
>Received: from mail.the-testas.netby localhost with POP3 
>(fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Fri, 23 Mar 2001 
>13:42:02 -0500 (EST)
>Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by 
>mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2NJjp013747for 
><[EMAIL PROTECTED]>; Fri, 23 Mar 2001 13:45:52 -0600
>Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
>(8.9.3/8.9.3) with UUCP id KAA26614;Fri, 23 Mar 2001 10:29:04 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002D6239; 
>Fri, 23 Mar 2001 08:10:38 -0800
>Return-Path: <[EMAIL PROTECTED]>
>Message-ID: <[EMAIL PROTECTED]>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: Harsh Agrawal <[EMAIL PROTECTED]>
>Sender: [EMAIL PROTECTED]
>Errors-To: [EMAIL PROTECTED]
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match 
>any local name
>X-SpamBouncer: 1.2 (10/20/00)
>X-SBPass: NoBounce
>X-SBClass: OK
>Status:
>
>By mistake a user was assigned default tablespace SYSTEM.
>How we can change it to some new tablespace let's say "TBS1" ?
>Because if we do export and import it will again import into that "SYSTEM"
>tablespace.
>
>Thanks,
>- Harsh
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Harsh Agrawal
>   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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph Testa
  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: Which is faster??

2001-03-23 Thread Hillman, Alex

When inserting only rowid gows into rollback segment, so 1GB will be more
then enough.

Alex Hillman

-Original Message-
From:   CC Harvest [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 23, 2001 12:18 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Which is faster??

Thank you all for the reply. Probbaly I need to do
more test. My concern is that whether it's ok to do
the buld insert of 9 million records(say 2.7GB) on a 1
GB RBS? I think the RBS should also be at least 3GB,
right?

Thanks,

Chris

--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   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).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   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!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

Fat City Network 

? 805 and 815 client question

2001-03-23 Thread Leslie Lu

Hi all,

I have 805, 815 clients installed on NT4.0.  815's
sqlplus and svrmgrl work fine.  But in 805/bin, there
is no svrmgrl (or similar name) at all, and when I run
sqlplus, something flashed for about 1/100 second and
then nothing special happened (went back to the DOS
prompt).  Any suggestion before I reinstall 805
client?

I was told briefly that our application is using 815
server but 805 client.  I haven't got a chance to find
out what the reason for this.  Does anybody use this
kind of combination before and why?

Thanks a lot.

Leslie

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  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:Dumb question...

2001-03-23 Thread dgoulet

Scott,

Yes, "create snapshot 
refresh complete
start with 
next 
as select * from ;"


Reply Separator
Author: [EMAIL PROTECTED]
Date:   3/23/2001 9:11 AM

I am not at my terminal where my online docs reside and I can't get out to
metalink ATT - or I wouldn't ask, but:

Can a simple snapshot be created on a view?  View on master site tables, I
want a snapsot of the view data on the remote system.  Oracle 7.3.3, HPUX.

Thanks,

Scott Shafer
San Antonio, TX

"2+2=5, for very large values of 2..."


-- 
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: Log Buffer

2001-03-23 Thread Mohan, Ross
Title: RE: Log Buffer





"illustrious"?


oh my. I  can see I am going to have to be
even more frivolous, irreverent, and non-topical.


..."gee, if I had a 4 GB SGA, 
I guess i'd need a 400 Megabyte log buffer...yea, 
sure, that makes sense"


-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
Subject: Log Buffer



Hello DBA's
    You know, I read somewhere that you can make your log_buffer 10 percent of
your total sga.  So if you had a 500mb sga you could have a 50 mb
log_buffer?  What do you guys think, the illustrious Ross doesn't like such
large log_buffers.


Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  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).





os commands from stored procs

2001-03-23 Thread Chesebro, Eric

I am trying to run sqlloader without leaving the my stored procedure but it
seems the only way to invoke it is from the command line or sql plus.  Is
there any way to run an os command from within a pl/sql stored
procedure/package?

Thanks,
Eric
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chesebro, Eric
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Michael Netrusov



> Some good points... different strokes for different folks ya know. :)

exactly.

> Partitioning a code table? Really??? Show me the money, er, cache. If your
> lookup/validation data is not "mixed together" then why would you need to
> partition it?

Why not? If you can imagine a code table with 10M rows, somebody might want to partion 
it with local indices. ( For those who prefer
to search for data among 10 rows :-)).

> Regarding "lookup" or validation tables and more complex "rules" tables...
> do they ALL go into your master code table?

It depends. "Rules" tables do not go into master lookup. Validation - maybe.. if the 
number of values is small and unvariant, they
can go into check constraint.

 > For instance, what about a "code
> table" for all valid U.S. zip codes? Do they go into your master code table?
> State abbreviations too? What about valid city/state/zip code combinations
> which you can get from the U.S.P.O.? At what point are
> validation/lookup/rules data not in the master code table and how do you
> decide?
If you have relationship between lookup tables, probably they will not go to the 
master lookup table ( although is is still
possible ). Depends on a common sense. If you have 100 tables all of them are of ( 
t_id, name, description ) - they will sure go.

> The code table technique may be fine for smaller apps but couldn't
> it become unwieldy for larger apps with 5000+ tables? Of which 1-3000 would
> be "lookup/validation tables?"

I think it still work for large models. Large app with 5000 tables of which 3000 
tables are lookups is a medium app with 2001 tables
:-).
Do you prefer to administer 3000 tables instead of one, even partitioned?

> Do Oracle ERP or SAP ERP apps do this?
> Curious.

They do not. But I do not consider them a good example of desing and programming.

Regards,
Michael


> -Original Message-
> Ghosalkar
> Sent: Thursday, March 22, 2001 3:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> > -Original Message-
> > From: Michael Netrusov [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 22, 2001 4:23 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Single Code Table or Separate Code tables dilemma
> >
> >
> >
> >
> > > > Referential integrity is still present if you create
> > Master lookup table
> > > > with type attribute
> > > This requires a "composite referential integrity
> > constraint" such as:
> > > alter table tname
> > >   add constraint fk_whatever
> > >   foreign key (extra_column_for_code_table_key,
> > >column_i_really_care_about)
> > >   references  master_codes(lookup_id, lookup_type);
> > >
> > > Still don't like it. Maybe it's just a preference thing...
> >
> > What's wrong with a composite foreign key constaint? Works
> > for me all the time..
>
> As a duhveloper wont u like to pass one argument to a procedure rather than
> two?
>
> >
> > > > granular control over the individual code table
> > > You DON'T have granular control for caching specific tables because
> > > everything is mixed together. (Hawaiian pidgin translation:
> > "All kalikaka
> > > li' dat. Da' kine chop suey. Easy Brah." :) No control for different
> > > indexing requirements or not even having an index for small
> > tables where it
> > > would be better to do a FTS.
> >
> > I DO. Nothing is mixed - you can even partition this table if
> > you prefer to keep unlike data in different places.
> >
>
> so u will create one single table and then partition it. do u think
> partitioning is cheap from maintenance point?
>
> > > > prefer to have multiple numerous small tables or one large?
> > > Numerous small tables are not a problem, actually a benefit
> > because you have
> > > more granular control for tuning. I once had the misfortune
> > of having to do
> > > reports where the "mother of all code tables" had around
> > 100,000 rows. (It
> > > was a big, dumb 3rd party app with roots in COBOL and it
> > had a lot of
> > > unmaintained junk in it). To pick up a description in a
> > large multi-table
> > > join query I had to join against the mother of all code
> > tables where a small
> > > 10 row table would have sufficed.
> >
> > I don't think a join to 100K rows table versus a join to 10
> > rows table would make a big difference.. Most likely the join was slow
> >  was it? ) because of some other factors.
>
> u dont mind searching 10 starbuck's shops to find one cup of coffee?
> also u dont mind releasing 10 different versions of ur programs to ur client
> and then let the client search thru them for the best one.
>
> >
> > > I'm not exactly a relational purist and for some apps code
> > tables may work
> > > just fine. But usually it's just for duhveloper convenience
> > (laziness) and
> > > why make life easy for them ;-) at the expense of "normal"
> > relational
> > > design. Especially if they haven't bothered to answer the
> > challenge I posed
> > > below? When I was a develop

RE: db_name, instance_name, service_names and the sqlnet alias

2001-03-23 Thread Jacques Kilchoer
Title: RE: db_name, instance_name, service_names and the sqlnet alias





see answer below.


> -Original Message-
> From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]
> 
> What is the relation between db_name,  instance_name, 
> service_names and the
> sqlnet alias for an instance.  'Cause in my init.ora file I 
> fdefined the
> following things 
>   db_name = "db1"
>   instance_name=inst1
>   service_names=service1
> 
> And I defined an entry in my tnsnames.ora file, for my 
> instance as following
> :
> 
> cs_inst1 =
>   (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
>   (COMMUNITY = TCPCOM)
>   (PROTOCOL = TCP)
>   (Host = alpha)
>   (Port = 1527)
> )
> )
> (CONNECT_DATA =
>    (SID = db1)
>    (GLOBAL_NAME = cs_inst1)
> )
>   )
> 
> But I cannot connect to my instance by the following command .
>   sqlplus system/manager@cs_inst1



The db_name is the name of the database (the files on disk).
The SID is the name of the instance (the background processes and shared memory).


The database name and the SID are not necessarily the same, and for example if you have Oracle Parallel Server (OPS) running, you can have several instances for one database. So you can see why there are good reasons for them to be different. Also database names cannot be as long as SIDs.

The alias in your TNSnames.ora file can be different from the db_name and also different from the SID. Or all three can be the same. However, the SID= parameter in TNSnames.ora expects an INSTANCE name, the SID, and NOT the database name. This can also be explained with the OPS example: when you have several instances accessing the same database, the instances are typically on different hosts, and you are connecting to only one of those instances.

In your case, you have the database name as a value for SID=, which is incorrect.


--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com





Re: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Michael Netrusov

- Original Message -


> at last i convinced my duhvelopers to go for individual tables.

Probably they were just unaware of how much code they would have to write. DUHelopers 
are easy to convince - they just have no
brain. Developers have. :-))

> > -Original Message-
> > From: Steve Orr [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 22, 2001 5:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Single Code Table or Separate Code tables dilemma
> >
> >
> > Regarding "lookup" or validation tables and more complex
> > "rules" tables...
> > do they ALL go into your master code table? For instance,
> > what about a "code
> > table" for all valid U.S. zip codes? Do they go into your
> > master code table?
>
> we r in the process for defining country--->state/province--->city and
> airports tables. there would be another 30-40 masters  and all in different
> tables :-) sweet smell of victory

:-) In this case you have dependencies. I would create multiple tables there.

> > State abbreviations too? What about valid city/state/zip code
> > combinations
> > which you can get from the U.S.P.O.? At what point are
> > validation/lookup/rules data not in the master code table and
> > how do you
> > decide?
>
> i blive every logical entity should hv its seperate physical presence.

I think if logical entities differ from each other only a couple of attributes, they 
should go into one table.

> but then every solution is an "Engineering Compromise". So i wont mind some
> give and take. but its fun to have an occasional fight with a duhveloper.

Yeah, a duhveloper might consider it's fun to write 10 packages which differ only by 
name and a couple attributes.
Later he might claim that he wrote 10K lines of code ( instead of 1K ) and worked 
hard. :-)

Regards,
Michael Netrusov
www.atelo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  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: Moving user to a different tablespace ...

2001-03-23 Thread Thater, William

Harsh Agrawal wrote:
> 
> By mistake a user was assigned default tablespace SYSTEM.
> How we can change it to some new tablespace let's say "TBS1" ?
> Because if we do export and import it will again import into that "SYSTEM"
> tablespace.

alter user bob default tablespace tbs1;

then grant a quota to bob on tbs1, revoke his quota on system, export
and import his objects.  since they can't go into system [he has no
quota on system] they go in his default tablespace.

--
Bill Thater  Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Michael Netrusov

ok.
lookup_id varchar2(20)  pk
lookup_type_id varchar2(20)  pk, fk
description   varchar2(255)

I use the first approach when lookup_type has several invariant values.

One index with an extra level of index block causes a performance hit only when you 
are running your DB on a PII/ 256M/ 1 IDE hard
drive NT box :-)

Less tables = less packages, less sql in your sql area, less database objects.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 09:41


Nice, but this construct violates Second Normal Form.  I  only denormalize for 
compelling reasons, like for performance reasons, and
I don't see how performance is enhanced by jamming all this stuff into one big table.  
You may end up with an index that has an
extra level of index blocks, which comes with a performance hit.


>>> [EMAIL PROTECTED] 03/22/01 01:55PM >>>


Referential integrity is still present if you create Master lookup table with type 
attribute:

lookup_id varchar2(20)  pk
lookup_type varchar2(20)  pk
description   varchar2(255)

> 1. specific attributes for a particular code type is logically and physically 
>separated from other code types.

It does not matter - just don't read the attributes' values that are irrelevant

> 2. a table lock affects only the concerned code table

who needs a table lock in a lookup table??!!  :-)

> 3. granular control over the individual code table

still present with the lookup_type column.



So now for the DBA side: do you prefer to have multiple numerous small tables or one 
large? :-)


Regards,
Michael Netrusov,
www.atelo.com


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 11:50


> Code tables... been there done that (with PowerBuilder/Oracle) and I don't
> like it. Here's why...
>
> Large apps may consist of 100's or 1000's of lookup tables so duhvelopers
> like the "master code table" idea because they only have to build one front
> end for maintaining all the "lookup" values. But what about referential
> integrity? If you have to do it against one massive code table via triggers
> or from front end code then you're adding work back to the coding effort.
> What about database tuning? Lookup tables are good candidates for caching...
> Are you going to cache one huge, denormalized code table? If your lookup
> values are in multiple normalized tables then you the DBA can choose which
> tables are suitable for caching.
>
> With a few exceptions, most "Lookup tables" have a common structure with
> just two columns: one for the PK value and another for the description. You
> could review all the referential integrity/data lookup requirements in your
> app and come up with a common structure for all lookup tables that could
> handle most situations. Here's are some example columns: _ID
> (the primary key);
> short_label; long_label; short_description; long_description; enabled_flag;
> effective_date; expiration_date; date_created; last_update; last_updated_by.
>
> I'd put my foot down and place the following challenge to the duhvelopers:
>
> "Any SAVVY developer worth his salt should be able to create a robust,
> object oriented design to make coding a snap no matter how many lookup
> tables there are. [Good] Developers can do this by inheriting from a parent
> window or set of objects in his class library. The label and description
> columns could be for GUI display. The enabled_flag could default to 'Y' and
> be referenced as standard practice in the where clause of every lookup
> query. Ditto for the effective_date and expiration_date columns where your
> validations have a time fence constraint such as a
> 'date_DBA_hourly_rate_increase_becomes_billable column." :>)
>
> Ready for duhveloper combat...
> Steve Orr
>
>
> -Original Message-
> Sent: Wednesday, March 21, 2001 4:32 PM
> To: Oracledba (E-mail); ORACLE-L (E-mail)
>
>
> Guys,
>
> We r working on a Datawarehouse solution.
>
> Our Duhvelopers want to merge all code tables into a single table by adding
> a codetype column.
>
> with reference to this, i came across this article from Steve's site
> http://www.ixora.com.au/tips/design/meta-data.htm
>
> i want to put them into different individual code tables instead of a single
> table, for the foll reasons.
>
> 1. specific attributes for a particular code type is logically and
> physically seperated from other code types.
> 2. a table lock affects only the concerned code table
> 3. granular control over the individual code table
>
> i am short of arguments
>
> wld be grateful, if ull can advise me which would be better from performance
> perspective.
>
> -Mandar
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steve Orr
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet ac

Re: changing the datbase server name and IP number

2001-03-23 Thread Rodd Holman

As long as you are keeping the DB_NAME's the same you should be able to get 
by with changing the listener.ora and tnsnames.ora files.  You will also need 
to change your global tnsnames or Onames server references to these db's.

On Friday 23 March 2001 11:30, you wrote:
> We are setting up a new database server.  It's HP-UX 11.0.  Oracle 7.3.4 (I
> know, we need to upgrade !) has already been installed and configured on
> it. Databases have been built and are in use for testing.  In a couple of
> weeks, we'll be exporting the production database from our old server and
> importing it to the new machine.  Sometime during this process, we'd like
> to rename the new machine to have the same name as our old production
> server.  At the same time, the IP number will be changed.  The goal is to
> make the new production machine have the same name and IP number as the old
> production machine.  Since Oracle has already been installed on the new
> server, and it already has test databases on it, what will need to change
> Oracle-wise when the host machine name and IP number change ?
>
> Thanks for any information you can share!
>
> Judy Hazeley
> Millersville University
> Millersville, PA
> [EMAIL PROTECTED] 

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  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: Tuning Matter ==> Parameter PCT_USED in a Table

2001-03-23 Thread Jim Walski

Are all the columns completely filled?  ie all the "ename" are 10 chars long
and all the "job" fields are 9 chars.  When you use the varchar2 field it
only stores the length _used_.

Jim

-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Friday, March 23, 2001 9:21 AM


Hi Ron,
Let's take a example:

SQL> desc emp
NameNull?TypeBYTES
--  --  --
EMPNO  NOT NULL NUMBER(4)   21
ENAME   VARCHAR2(10)10
JOB VARCHAR2(9)  9
MGR NUMBER(4)   21
HIREDATEDATE 7
SAL NUMBER(7,2) 21
COMMNUMBER(7,2) 21
DEPTNO  NUMBER(2)   21

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF
COLUMNS > 250)

So according to ur formula

TOTAL=3+131+8=142 BYTES

Is this OK 'coz after analyzing the table with COMPUTE I got AVG_ROW_LEN 40.

Can there be such a HUGE difference ?

Pl. comment.

Thanks,
- Harsh

-Original Message-
Sent: Friday, March 23, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


max(row size) is the sum of all of the columns sizes in the
table plus overhead.
The following is the column sizes and the sum formula to
calculate the size of a row in a data block.

NUMBER =21
CHAR = COLUMN SIZE
VARCHAR = COLUMN SIZE
DATE = 7

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF
COLUMNS > 250)

This is part of the calculations used to determine the storage
needed for a table.

OR: you could analyze you table and use the average row size is
you need a general calculation of actual usage.

ROR m*?*m


>>> [EMAIL PROTECTED] 03/22/01 08:45PM >>>
Dear Listers,

I've download a presentation talking about Calculating PCT_USED .
the formula is quite simple :
PCT_USED + PCT_FREE < 100
PCT_USED = PCT_FREE + 1 row size

but I have no idea to calculate the size of 1 row in a table .

is there anyone who knows to calculate it  ?
or any alternative formula to calculate PCT_USED ?

Thanks a lot in advance  : )

=bambang=


<> Bambang Setiawan <>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bambang Setiawan
  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 Rogers
  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: Harsh Agrawal
  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: Jim Walski
  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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Michael Netrusov

> > What's wrong with a composite foreign key constaint? Works
> > for me all the time..
>
> As a duhveloper wont u like to pass one argument to a procedure rather than
> two?

I don't care - I am using the wonderful copy-paste.

> > > > granular control over the individual code table
> > > You DON'T have granular control for caching specific tables because
> > > everything is mixed together. (Hawaiian pidgin translation:
> > "All kalikaka
> > > li' dat. Da' kine chop suey. Easy Brah." :) No control for different
> > > indexing requirements or not even having an index for small
> > tables where it
> > > would be better to do a FTS.
> >
> > I DO. Nothing is mixed - you can even partition this table if
> > you prefer to keep unlike data in different places.
> >
>
> so u will create one single table and then partition it. do u think partitioning is 
>cheap from maintenance point?

No, it's not cheap.  I only said it could be partitioned, if someone wants to.  Do you 
think adiministering of a 100 similar tables
is cheap?

> > > > prefer to have multiple numerous small tables or one large?
> > > Numerous small tables are not a problem, actually a benefit
> > because you have
> > > more granular control for tuning. I once had the misfortune
> > of having to do
> > > reports where the "mother of all code tables" had around
> > 100,000 rows. (It
> > > was a big, dumb 3rd party app with roots in COBOL and it
> > had a lot of
> > > unmaintained junk in it). To pick up a description in a
> > large multi-table
> > > join query I had to join against the mother of all code
> > tables where a small
> > > 10 row table would have sufficed.
> >
> > I don't think a join to 100K rows table versus a join to 10
> > rows table would make a big difference.. Most likely the join was slow
> >  was it? ) because of some other factors.
>
> u dont mind searching 10 starbuck's shops to find one cup of coffee?

are you searching those rows manually? :-) DB does not care.

> also u dont mind releasing 10 different versions of ur programs to ur client
> and then let the client search thru them for the best one.

how's that related?

> > > I'm not exactly a relational purist and for some apps code
> > tables may work
> > > just fine. But usually it's just for duhveloper convenience
> > (laziness) and
> > > why make life easy for them ;-) at the expense of "normal"
> > relational
> > > design. Especially if they haven't bothered to answer the
> > challenge I posed
> > > below? When I was a developer I had a set of objected oriented class
> > > libraries and could bang out a new window for a lookup
> > table in 60 seconds.
> > > Of course I probably spent 600 hours developing and maintaining my
> > > libraries... sigh. Oh yeah, developer designed tables
> > containing metadata
> > > come in handy also.
> >
> > Do developers design ER models in your shop? It should be you
> > or a DA. :-)
> >
> > > Duhveloper combat is so much fun! :-) Unfortunately they
> > usually outnumber
> > > us DBA's so we have to be particularly nimble. ;-)
> >
> > In my current shop I am a pl/sql developer :-) ... as well as
> > a DA and a DBA.  This saves me a LOT time and nerves.
>
> so whose is the PM and client?

PM is a atavistic fugure. No PMs - no problems. Clients are happy so far :-)

> I taste blood :)
> Har Har Mahadev ... Thats a Battle Cry :-)

:-))

Regards,
Michael




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  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: Oracle_In_NT !!!

2001-03-23 Thread Rodd Holman

Chuck is correct.  You need to run the oradim.exe utility to create the 
Oracle_Server service.

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation

On Friday 23 March 2001 10:36, Chuck Hamilton <[EMAIL PROTECTED]> 
wrote:
> I might be wrong on this but I think you have to create and start the
> oracle service first.
>
> --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote:
> > Did you set the default oracle_sid?  Is the database running when you
> > try to
> > connect?
> >
> > -Original Message-
> > Dumas
> > Sent: Friday, March 23, 2001 4:50 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi there
> >
> > I have a problem when I install Oracle 816 on NT. I have done it
> > twice
> > before amd it worked, that was Oracle 805 and 806. Now I am trying to
> > install and create database on NT, Oracle 8i version, 816.
> > I get the error ORA-12560, which protocol adapter error, whenever I
> > try connect to server manager. At first I thought it's because I
> > created the database with the option during installation. I tried to
> > install software only and then use scripts to create the database
> > manually, but I get the same error. Can somebody help me?
> > ___
> >  http://www.webmail.co.za the South-African free email service
> >  WIN R10 000 by registering  for free online options for EasyMoney in
> >  http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
> > Now!!!
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jackson Dumas
> >   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 Kostyszyn
> >   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!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  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: NT Server very slow

2001-03-23 Thread Jim Walski

Since you mention there are only a few users, I would take a look at the
jobs these users are running.  Maybe one of these users is firing off a
poorly tuned job that brings the database to a grinding halt.

Is the database the only product on the Server?  Or are there other
applications ( email server, web server...)

Jim



-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Friday, March 23, 2001 7:50 AM


>I have an Oracle 8.1.6 instance on an NT Server.  The application has only
a
>few users.  Very often throughout the day it seems response time drops to
>about 20 seconds.  By the time I log on to look at the problem everything
is
>back to normal.  If I do a simple query the result is returned immediately.
>I have looked at SQL through Quest's SQLAB and there is nothing that stand
>out.  The hit ratio averages between 88% and 92%.  Is there a good way to
>diagnose this type of problem?
>
>Ron Smith
>Database Administration
>[EMAIL PROTECTED]
>
>--
>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: Jim Walski
  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: Reverse engineering

2001-03-23 Thread Scott Crabtree

Roland,
Erwin has options for importing text files, so you could dump the
ddl for tables you are having problems with (Or all tables for that matter)
and import them as text into Erwin.  At least you can play around with the
text file and hopefully figure out what the invalid character is, if you are
just trying to build a logical model you can strip most of the columns out
of the text file and start from there.

HTH,
Scott Crabtree

-Original Message-
Sent: Friday, March 23, 2001 8:21 AM
To: Multiple recipients of list ORACLE-L


Hallo,

I am doing a reverse engineer of the Oracle database, which means that I am
loading the database into the program Erwin. When it i simported into erwin
I willbe able to seeall the relations, tables, views  etc of the database.
But when i am doing the
reverse engineer I get many  error messages during the process? Erormessages
which I get  are for  instance,
A:  "Can' t load the table X".
B: ORA-error: Invalid Caracter - cant load the table.
Why  is it so? Does it depend on  the fact that some procedures are invalid
in the database ? or what is the reason to this?
What should I  do to fix this thing?
Hope someone could help me.

Roland Sköldblom





-- 
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: Scott Crabtree
  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_name, instance_name, service_names and the sqlnet alias

2001-03-23 Thread Jacques Kilchoer
Title: RE: db_name, instance_name, service_names and the sqlnet alias





In my previous e-mail I forgot that you were also asking about service_name.
If you are not running OPS, then the service_name parameter can be omitted. If you ARE running OPS, then you will have to ask someone smarter than me the difference between service_name, instance_name, and how they relate to instance_group, etc... All I know is what I've read in the manual but I've never tried it in real life. Or you could look in the Server reference manual, the Net8 Administrator's manual, and the Oracle Parallel Server Concepts manual for service_name, instance_name, instance_group.




ONTOPIC: "C" is for "Coffee"

2001-03-23 Thread Jesse, Rich

Found this link while surfing for...Oracle and Linux.  Yeah, that's it.  ;)

Apparently, supermodels do more than model.  They do Oracle on Linux, too.

http://www.c-cup.com

Seemingly good info on a funny site.  And, yes, the "c" apparently stands
for "coffee".

Enjoy,

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


---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
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).



Failed DB link

2001-03-23 Thread Chuck Hamilton
I ran into a situation this week where a session was waiting for results from a failed db link and holding a lock (library cache pin) on the sql it was executing. It never detected the failure and hung waiting for a reply on the link. This caused the pin to be help indefinitely too, which caused numerous other sessions to hang as they tried to pin either the same sql. What can I do to ensure that if a db link fails (it failed due to a network adapter failure on the remote server), the session will either abort or return an error? Will setting sqlnet.expire_time on the remote server do this?Do You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

perl problem on linux

2001-03-23 Thread Adams, Matthew (GEA, 088130)
Title: perl problem on linux





I've got some developers trying to get 
perl's dbi/dbd stuff working on linux, 
and they keep getting ORA-2035 every time
the execute from a for loop.


Anybody seen this before?


Linux kernal 2.2.16 with 8.1.7 client installed



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
  trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)





changing the datbase server name and IP number

2001-03-23 Thread Judy Hazeley

We are setting up a new database server.  It's HP-UX 11.0.  Oracle 7.3.4 (I
know, we need to upgrade !) has already been installed and configured on it.
Databases have been built and are in use for testing.  In a couple of weeks,
we'll be exporting the production database from our old server and importing
it to the new machine.  Sometime during this process, we'd like to rename
the new machine to have the same name as our old production server.  At the
same time, the IP number will be changed.  The goal is to make the new
production machine have the same name and IP number as the old production
machine.  Since Oracle has already been installed on the new server, and it
already has test databases on it, what will need to change Oracle-wise when
the host machine name and IP number change ?

Thanks for any information you can share!

Judy Hazeley
Millersville University
Millersville, PA
[EMAIL PROTECTED]  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Judy Hazeley
  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: Which is faster??

2001-03-23 Thread CC Harvest

Thank you all for the reply. Probbaly I need to do
more test. My concern is that whether it's ok to do
the buld insert of 9 million records(say 2.7GB) on a 1
GB RBS? I think the RBS should also be at least 3GB,
right?

Thanks,

Chris

--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   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).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   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!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  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: NT Server very slow

2001-03-23 Thread Patrick Housholder

Anything in the event viewer?
*
what else is on the nt box? defrag..norton..?
*
or is it the actual "network", do you have a network sniffer..or SMS to
check you network traffic..
check the traffic.
*
does a reboot file fix the problem?


patrick

===
Patrick Housholder
Sr. Staff Anl Tech Spt Design
United Airlines Flight Training Center
Denver CO


*>-Original Message-
*>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Smith, Ron
*>L.
*>Sent: Friday, March 23, 2001 8:31 AM
*>To: Multiple recipients of list ORACLE-L
*>Subject: NT Server very slow
*>
*>
*>I have an Oracle 8.1.6 instance on an NT Server.  The application
*>has only a
*>few users.  Very often throughout the day it seems response time drops to
*>about 20 seconds.  By the time I log on to look at the problem
*>everything is
*>back to normal.  If I do a simple query the result is returned
*>immediately.
*>I have looked at SQL through Quest's SQLAB and there is nothing that stand
*>out.  The hit ratio averages between 88% and 92%.  Is there a good way to
*>diagnose this type of problem?
*>
*>Ron Smith
*>Database Administration
*>[EMAIL PROTECTED]
*>
*>--
*>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: Patrick Housholder
  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).



Moving user to a different tablespace ...

2001-03-23 Thread Harsh Agrawal

By mistake a user was assigned default tablespace SYSTEM. 
How we can change it to some new tablespace let's say "TBS1" ?
Because if we do export and import it will again import into that "SYSTEM"
tablespace.

Thanks,
- Harsh
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harsh Agrawal
  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: Tuning Matter ==> Parameter PCT_USED in a Table

2001-03-23 Thread Nicoll, Iain (metering)

Harsh,

I thought number would only generally take 4 bytes (I've checked a couple
using vsize on 7.3.4) and varchar will only take what it needs.

Cheers

Iain

-Original Message-
Sent: 23 March 2001 16:32
To: Multiple recipients of list ORACLE-L


Hi Ron,
Let's take a example:

SQL> desc emp
 NameNull?TypeBYTES
 --  --  -- 
 EMPNO  NOT NULL NUMBER(4)   21
 ENAME   VARCHAR2(10)10
 JOB VARCHAR2(9)  9
 MGR NUMBER(4)   21
 HIREDATEDATE 7
 SAL NUMBER(7,2) 21 
 COMMNUMBER(7,2) 21
 DEPTNO  NUMBER(2)   21 

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF 
COLUMNS > 250)

So according to ur formula

TOTAL=3+131+8=142 BYTES

Is this OK 'coz after analyzing the table with COMPUTE I got AVG_ROW_LEN 40.

Can there be such a HUGE difference ?

Pl. comment. 

Thanks,
- Harsh

-Original Message-
Sent: Friday, March 23, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


max(row size) is the sum of all of the columns sizes in the 
table plus overhead.
The following is the column sizes and the sum formula to 
calculate the size of a row in a data block.

NUMBER =21
CHAR = COLUMN SIZE
VARCHAR = COLUMN SIZE
DATE = 7

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF 
COLUMNS > 250)

This is part of the calculations used to determine the storage 
needed for a table.

OR: you could analyze you table and use the average row size is 
you need a general calculation of actual usage.

ROR mª¿ªm


>>> [EMAIL PROTECTED] 03/22/01 08:45PM >>>
Dear Listers,

I've download a presentation talking about Calculating PCT_USED .
the formula is quite simple :
PCT_USED + PCT_FREE < 100
PCT_USED = PCT_FREE + 1 row size

but I have no idea to calculate the size of 1 row in a table .

is there anyone who knows to calculate it  ? 
or any alternative formula to calculate PCT_USED ?

Thanks a lot in advance  : )

=bambang=


<> Bambang Setiawan <>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Bambang Setiawan
  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 Rogers
  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: Harsh Agrawal
  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: Nicoll, Iain (metering)
  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: Oracle_In_NT !!!

2001-03-23 Thread Kevin Kostyszyn

Well of course, maybe I was assuming too much, my apologies.
Kev

-Original Message-
Hamilton
Sent: Friday, March 23, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


I might be wrong on this but I think you have to create and start the
oracle service first. 

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote:
> Did you set the default oracle_sid?  Is the database running when you
> try to
> connect?
> 
> -Original Message-
> Dumas
> Sent: Friday, March 23, 2001 4:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi there
> 
> I have a problem when I install Oracle 816 on NT. I have done it
> twice
> before amd it worked, that was Oracle 805 and 806. Now I am trying to
> install and create database on NT, Oracle 8i version, 816.
> I get the error ORA-12560, which protocol adapter error, whenever I
> try connect to server manager. At first I thought it's because I
> created the database with the option during installation. I tried to
> install software only and then use scripts to create the database
> manually, but I get the same error. Can somebody help me?
> ___
>  http://www.webmail.co.za the South-African free email service
>  WIN R10 000 by registering  for free online options for EasyMoney in
>  http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
> Now!!!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jackson Dumas
>   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 Kostyszyn
>   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!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chuck Hamilton
  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 Kostyszyn
  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: SALARY IN AUSTRIA

2001-03-23 Thread dieter . oberkofler

Hi!

I live in Austria and have a position similar to a DBA
but actually am not a real DBA. I would guess that you
can expect a monthly income (before taxes) of 2.000 up
up to 4.000 US$.

See you in lovely Austria...

DO

-Original Message-
Bahar
Sent: Friday, March 23, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L


IS THERE  ANYBODY  WHO HAVE  KNOWLEDGE ABOUT  SALARY IN AUSTRIA AT DBA
POSITION

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arslan Bahar
  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).



Crontab

2001-03-23 Thread DEMANCHE Luc (Cetelem)
Title: Crontab





Hi gurus,


I want to schedule a script to run on the fourth sunday of the month.


How can I do that ?


TIA


-
Luc Demanche
CETELEM
Tél.: 01-46-39-14-49
Fax : 01-46-39-59-88





Dumb question...

2001-03-23 Thread Scott . Shafer

I am not at my terminal where my online docs reside and I can't get out to
metalink ATT - or I wouldn't ask, but:

Can a simple snapshot be created on a view?  View on master site tables, I
want a snapsot of the view data on the remote system.  Oracle 7.3.3, HPUX.

Thanks,

Scott Shafer
San Antonio, TX

"2+2=5, for very large values of 2..."


-- 
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: about analyse table..

2001-03-23 Thread Toepke, Kevin M

Just a FYI about Analyzing...

As of Oracle 8i, Oracle recommends using the DBMS_STATS package instead of
the ANALYZE command or DBMS_UTILITY procedures. The DBMS_STATS package
gathers more statistics than either ANALYZE or the DBMS_UTILITY packages --
potentially resulting in better query performance. In addition, the
DBMS_STATS package can parallelize the gathering of statistics, speeding the
procss.

Do not mix and match your analyze tool usages!!! ANALYZE cannot overwrite or
delete some of the values of statistics that were gathered by DBMS_STATS.
This could cause some EXTREMELY bad query performance -- trust me, I know.
Been there, done that.

Kevin Toepke
-
The information in this electronic mail message is Cendant Confidential
and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
-
The sender believes that this E-mail and any attachments were free of
any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation is not
liable for any loss or damage arising in any way from this message or
its attachments.
-


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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: Oracle license costs

2001-03-23 Thread Jim Conboy

Chaim-

I managed to save hardcopy but not soft, so I can't send it but I can comment.  
Actually, I was surprised at how little difference there was between Oracle and 
SQLServer at moderate usage levels assuming these numbers are accurate and you're 
using a similar server configuration.  At 100 users Oracle was ~64K, SS was 50K, but 
Oracle upgrades are included in support costs while you have to pay 50-75% of new 
price for SS upgrades.  SS support is priced per call, such that after 4 calls per 
month Oracle support is cheaper.  At 200 users you see more of a difference (127K 
Oracle vs 50K for SS) and support breakeven is after 9 calls a month, but if you 
upgrade SS at the 50-75% additional cost the difference starts to go away again.  The 
big difference is as you scale the ladder of licensed users because SS gives an 
unlimited user license, but of course if you have problems getting SS to climb that 
scale then no amount of $$$ will be enough.  I don't have direct experience in that, 
but if you have to buy 5 'low-cost' NT servers (and presumably 5 SS licenses?) to 
replace one  Unix server the economics could get ugly.

Long live free-range fresh-air chocolate-covered Canadian ants!

Jim


>>> [EMAIL PROTECTED] 03/23/01 10:50AM >>>


List,
Recently there was a discussion concerning the cost of Oracle licenses vs MS Sql
Server licenses wasn't there? That discussion was not an issue at my job - until
today which is why I'm wondering if there were any postings that in any shape or
form justified some of the price differential between Oracle and MSSQL? If so,
could someone forward the arguments to me? I would appreciate it very much.

I admit that in the last little while, I was deleting (a little too quickly)
everything that had nothing to do with ants, canada, chocolate factories and
fresh air.

I think what's really  needed is a dba certificate program based on the postings
of this list which would of course include off and on topic material.

Thanks
Chaim
[EMAIL PROTECTED] 


-- 
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: Jim Conboy
  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).



OTS

2001-03-23 Thread dgoulet

To All,

Over the last few months, OK years, we've all blasted OTS for not doing
their "job".  For the most part it I think it is justified.  Too many times the
"fix" is to upgrade to the latest software, which will take a number of days
which allows the analyst to close the TAR & get his/her brownie points.  Well,
I've a case where I need to complement OTS.  Yeah you got that right,
complement.  Here is what happen:

On Wednesday night the good old pager went off at 8PM EST.  Our locally
created Oracle monitor had a problem with the database that runs the current
generation assembly line.  The error was "ORA-12500: TNS:listener failed to
start a dedicated server process"

I connected into our network (remote access is just the berries) and sure
enough I could not get into that server via any SQL*Net process.  I logged on to
the computer (an HP L2000 running HP-UX 11.0) and queried the listener which
looked very normal.  Also If I set the Oracle SID and used the BEQ protocol, no
problems.  Humm, Since this machine does not use MTS I looked for the dedicated
server processes and found only 52 out of the "normal" 130.  The listener.log
was no real help either, except for an "HP-UX error: 12: out of space" at the
end.  Called the SA who likewise dialed in & could not see anything funny.  Now
he & I are both stumped, so I tried restarting the listener and deleting the
listener.log.  No help, OK time to call OTS.  As normal they asked for the
alert.log and the newly created listener.log.  The normal delay tactics, but
wait there's more!

Fifteen minutes after I finish uploading the specified files (MetaStink
being itself again) I get a return call for OTS.  Your out of swap space they
say.  Reboot the server & all should be well again.  Yeah right!  Pigs will fly
some day too!

So, I call the SA & inform him of Oracle's recommendation.  This prompted
him to take a second look at the swap space settings & sure enough swap was less
than the HP recommendation of 200% of physical.  Now since we're on a journaled
file system he could add swap space online & bingo, pigs start flying!

Why you ask, is this so?  Well there is a "feature" in HP-UX that allocates
an amount of swap for every process in physical memory just in case the system
crashes so that a core dump exists.  That's why they recommend that swap equal
200% of physical at least.  Our real problem was a new process that spawned
copies of itself as required & the darn thing had gone ballistic eating up all
of swap.  Both the SA & I forgot about this "feature".

So for once I need to get off of the rant box and pass a complement to one
group at Oracle that we all love to hate.

Dick Goulet
-- 
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_name, instance_name, service_names and the sqlnet alias

2001-03-23 Thread ALEMU Abiy

What is the relation between db_name,  instance_name, service_names and the
sqlnet alias for an instance.  'Cause in my init.ora file I fdefined the
following things 
db_name = "db1"
instance_name=inst1
service_names=service1

And I defined an entry in my tnsnames.ora file, for my instance as following
:

cs_inst1 =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
  (COMMUNITY = TCPCOM)
  (PROTOCOL = TCP)
  (Host = alpha)
  (Port = 1527)
)
)
(CONNECT_DATA =
   (SID = db1)
   (GLOBAL_NAME = cs_inst1)
)
  )

But I cannot connect to my instance by the following command .
sqlplus system/manager@cs_inst1

I've no error message.  It seems working indefinitely.  What did I miss?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ALEMU Abiy
  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: NT Server very slow

2001-03-23 Thread Marin Dimitrov


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 17:30


> I have an Oracle 8.1.6 instance on an NT Server.  The application has only
a
> few users.  Very often throughout the day it seems response time drops to
> about 20 seconds.  By the time I log on to look at the problem everything
is
> back to normal.  If I do a simple query the result is returned
immediately.
> I have looked at SQL through Quest's SQLAB and there is nothing that stand
> out.  The hit ratio averages between 88% and 92%.  Is there a good way to
> diagnose this type of problem?
>

Once I experienced simillar periods of mysterious slowdown and it turned out
that someone has configured a 3D screen saver on the server

I'm attaching part of a paper for tuning Oracle on NT that was posted few
months ago

hth,

Marin


"When someone is seeking, it happens quite easily that he only sees
the thing that he is seeking; that he is unable to find anything, unable to
absorb anything, because he is only thinking of the thing he is seeking,
because he is obsessed with his goal. Seeking means: to have a goal;
but finding means: to be free, to be receptive, to have no goal. ..."


Herman Hesse, "Siddhartha"




==

Oracle8i Tuning on Windows

Included in the following sections are advice and guidelines for tuning
Oracle8i on Windows from a hardware, operating system, and Oracle
software
perspective. Generic Oracle8i tuning advice (such as database structure
layout and SQL statement tuning) which is applicable to all platforms on

which Oracle8i runs is not included, since this is already covered
extensively in the Oracle8i documentation library.



Hardware

As they say, "Bigger is better." This certainly applies when selecting
hardware for an Oracle database server, since Oracle can typically use
all
resources provided to it, as needed by the particular application in
question. However, not all applications require an extremely large
server to
achieve reasonable response times and performance characteristics.
Included
in the following sections are some very general guidelines for choosing
or
configuring specific hardware components.



CPU

An Oracle database is a particularly memory-intensive application that
heavily exercises the system bus with memory accesses, especially in the

case where a large SGA is in use. As a result, the CPU to memory
interface
is a crucial part of system performance when dealing with Oracle8i and
in
some cases is more important than raw CPU speed. Choosing the largest
available level 2 (L2) data cache and the fastest system bus available
is
typically a very important consideration when selecting a system. CPU
speed
obviously is also an important factor, but it is sometimes the case that

extra CPU speed will not result in a proportional increase in throughput
if
the system bus is a limiting factor in the configuration. In an SMP
configuration in which multiple CPUs are used, this effect is amplified
since there can be 2, 4 or 8 CPUs performing memory operations on the
same
system bus simultaneously. Having a large L2 cache can reduce the number
of
bus transactions required and can help achieve better scalability and
throughput.



Memory

With the introduction of VLM support as described earlier, Oracle8i on
Windows NT v4.0 Server Enterprise Edition and Windows 2000 Datacenter
Server
can now utilize up to 16GB of RAM for database buffers. (For Windows
2000
Server and Advanced Server, Oracle can support 4GB and 8GB of RAM for
database buffers, respectively, the maximum amount of memory allowed on
these systems.) As a result, memory sizing is no longer limited to 4GB,
even
though this number still implies a very high end system. At this point,
the
number of applications running on Windows that need 16GB of database
buffers
are very few indeed as most applications that need to scale this high
typically are hosted on UNIX servers. With the release of 8-way SMP
servers
that run Windows, however, the number of large applications moving to
Windows will increase and 16GB of RAM will become a more common
configuration.

For smaller installations, memory should obviously be sized such that no

paging (or minimal paging) occurs during normal database operations.
Determining the right amount of memory ahead of time is extremely
difficult
since an application often needs to be up and running before it's
possible
to determine the minimum required memory usage and SGA settings needed
to
achieve acceptable performance.



Disk Subsystem

Besides the CPU and memory, the disk subsystem is another crucial
component
of an Oracle8i server machine. This is particularly true for
transaction-intensive applications that post many changes to the
database.
The following tips come from a relevant article in Microsoft's Knowledge

Base (http://support.microsoft.com/support/kb/ar

RE: Tuning Matter ==> Parameter PCT_USED in a Table

2001-03-23 Thread Harsh Agrawal

Hi Ron,
Let's take a example:

SQL> desc emp
 NameNull?TypeBYTES
 --  --  -- 
 EMPNO  NOT NULL NUMBER(4)   21
 ENAME   VARCHAR2(10)10
 JOB VARCHAR2(9)  9
 MGR NUMBER(4)   21
 HIREDATEDATE 7
 SAL NUMBER(7,2) 21 
 COMMNUMBER(7,2) 21
 DEPTNO  NUMBER(2)   21 

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF 
COLUMNS > 250)

So according to ur formula

TOTAL=3+131+8=142 BYTES

Is this OK 'coz after analyzing the table with COMPUTE I got AVG_ROW_LEN 40.

Can there be such a HUGE difference ?

Pl. comment. 

Thanks,
- Harsh

-Original Message-
Sent: Friday, March 23, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


max(row size) is the sum of all of the columns sizes in the 
table plus overhead.
The following is the column sizes and the sum formula to 
calculate the size of a row in a data block.

NUMBER =21
CHAR = COLUMN SIZE
VARCHAR = COLUMN SIZE
DATE = 7

TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF 
COLUMNS > 250)

This is part of the calculations used to determine the storage 
needed for a table.

OR: you could analyze you table and use the average row size is 
you need a general calculation of actual usage.

ROR mª¿ªm


>>> [EMAIL PROTECTED] 03/22/01 08:45PM >>>
Dear Listers,

I've download a presentation talking about Calculating PCT_USED .
the formula is quite simple :
PCT_USED + PCT_FREE < 100
PCT_USED = PCT_FREE + 1 row size

but I have no idea to calculate the size of 1 row in a table .

is there anyone who knows to calculate it  ? 
or any alternative formula to calculate PCT_USED ?

Thanks a lot in advance  : )

=bambang=


<> Bambang Setiawan <>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Bambang Setiawan
  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 Rogers
  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: Harsh Agrawal
  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: about analyse table..

2001-03-23 Thread Kevin Kostyszyn

Can't you also analyze an entire schema to make it easier, there's a dbms
package in the admin directory?
kev

-Original Message-
Carmichael
Sent: Friday, March 23, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L


if you have your database in the "CHOOSE" mode for the optimizer (using the
cost-based optimizer) and you don't analyze your tables, Oracle doesn't have
good information to determine the query path.

If you do "analyze table  compute statistics" the entire table is
read to gather the statistics

if you do "analyze table  estimate statistics" (and you can give
it the percentage to estimate on) then Oracle takes a sampling of the data
to generate the statistics

analyze table will also cause all indexes to be analyzed, although you can
analyze the indexes separately.

If you do analyze the tables in your database, make sure to analyze all of
them as a query with even one table not analyzed will have performance
degradation.

For more details, you can start with the SQL Reference manual and look up
the ANALYZE command




>From: "Saurabh Sharma" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: about analyse table..
>Date: Thu, 22 Mar 2001 22:00:23 -0800
>
>hello,
>
>i'm not very familiar with the analyse table command. and not fully aware
>of it's advantage or limits to analyse the tables.
>could anyone pls help me with this cmd, how to see the analysed statistics,
>etc.
>any help is highly appreciated.
>
>thanks in advance.
>
>saurabh sharma

_
Get your FREE download of MSN Explorer at http://explorer.msn.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 Kostyszyn
  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: Oracle_In_NT !!!

2001-03-23 Thread Chuck Hamilton

I might be wrong on this but I think you have to create and start the
oracle service first. 

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote:
> Did you set the default oracle_sid?  Is the database running when you
> try to
> connect?
> 
> -Original Message-
> Dumas
> Sent: Friday, March 23, 2001 4:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi there
> 
> I have a problem when I install Oracle 816 on NT. I have done it
> twice
> before amd it worked, that was Oracle 805 and 806. Now I am trying to
> install and create database on NT, Oracle 8i version, 816.
> I get the error ORA-12560, which protocol adapter error, whenever I
> try connect to server manager. At first I thought it's because I
> created the database with the option during installation. I tried to
> install software only and then use scripts to create the database
> manually, but I get the same error. Can somebody help me?
> ___
>  http://www.webmail.co.za the South-African free email service
>  WIN R10 000 by registering  for free online options for EasyMoney in
>  http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
> Now!!!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jackson Dumas
>   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 Kostyszyn
>   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!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chuck Hamilton
  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: oracle training

2001-03-23 Thread Don Jerman

There's someone in Charlotte, too (dbBasics I believe) but we never use
them as all our programmers are in Raleigh.  I've seen some basic-level
classes float through the universities and tech schools, but I wouldn't
recommend them for non-students.  Someone at Global keeps after me, too,
but they haven't shown me courses in the areas a DBA or programmer needs.


james ellis wrote:

> dbbasics and New Horizons offer Oracle training in NC.
> DBbasics is in Raleigh and Greensboro. New Horizons is
> located in Greensboro. It may be in other cities as
> well.
>
> Hope that helps
>
> --- "Streeter, Lerone  A LBX"
> <[EMAIL PROTECTED]> wrote:
> > aren't there some people from north carolina here?
> > know any local, in
> > state, oracle training outfits?
> >
> > ===
> > Lerone Streeter
> > System Analyst
> > Abbott LBG
> > [EMAIL PROTECTED]
> > ===
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Streeter, Lerone  A LBX
> >   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!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: james ellis
>   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:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard



RE: Oracle_In_NT !!!

2001-03-23 Thread Bala, Prakash

1. Make sure thay your service 'OracleService???' (??? is your db name) is
up.
2. On DOS prompt, enter 'set ORACLE_SID=???'
3. Then connect to svrmgrl

HTH!

Prakash

-Original Message-
Sent: Friday, March 23, 2001 4:50 AM
To: Multiple recipients of list ORACLE-L


Hi there

I have a problem when I install Oracle 816 on NT. I have done it twice
before amd it worked, that was Oracle 805 and 806. Now I am trying to
install and create database on NT, Oracle 8i version, 816.
I get the error ORA-12560, which protocol adapter error, whenever I
try connect to server manager. At first I thought it's because I
created the database with the option during installation. I tried to
install software only and then use scripts to create the database
manually, but I get the same error. Can somebody help me?
___
 http://www.webmail.co.za the South-African free email service
 WIN R10 000 by registering  for free online options for EasyMoney in
 http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jackson Dumas
  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: Bala, Prakash
  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: DNS vs. Oracle Names vs. tnsnames.ora

2001-03-23 Thread Chuck Hamilton
 AKAIK tnsnames.ora will always be supported. Oracle Names is being dropped in 9i in favor of LDAP, and since 8i Oracle ships a new LDAP compliant directory server called Oracle Internet Directory with the database. You can also use any other LDAP directory server such as Microsoft Active Directory. LDAP will allow you not only to resolve database service names, but also authenticate clients with an SSL connection. In fact with LDAP authenticated clients, you can map an LDAP user to a particular database and schema and have the database authenticate that user without even having to create a schema for him/her (or so the documentation states). It will also allow you to include Oracle in an enterprise-wide single sign-on solution. Since Onames is dropped in 9i, they will provide a program called Names Proxy. It will look and act like an Onames server from the client's perspective, but uses an LDAP back end.
HOSTNAME is another method they now support for database resolution. The way it works is you set up a DNS alias with the same name as the database SID, then specify that alias as the database service name. The listener needs to be on port 1521 for this to work. You can still have multiple databases on one server, just set up different DNS aliases for each one. 
  Paul Sheahan <[EMAIL PROTECTED]> wrote: 
Can anyone shed some light on this?I heard that Oracle is going toward a DNS solution and going away fromtnsnames.ora and the Oracle Naming Service. Is this true?We are looking to place a naming solution in our environment and I want toknow which direction to head in. Also, if possible, I would like users toonly see the databases they need to see, which is the main problem we haveright now using a global tnsnames.ora file. Limiting users' views to onlywhat they have a business need to see is an important step in many steps tosecure the environment. I don't see how this would be accomplished usingDNS.Comments?Thanks,Paul-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Paul SheahanINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051S!
!
an 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 Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

OFF TOPIC - FW: Sony Vaio Japanese error messages

2001-03-23 Thread lerobe - Lee Robertson

Very funny




>> > In Japan, Sony Vaio machines have replaced the
>>
>> > impersonal and unhelpful Microsoft error messages
>>
>> > with their own Japanese haiku poetry, each only 17
>>
>> > syllables.
>>
>> >
>>
>> > ---
>>
>> >
>>
>> > A file that big?
>>
>> > It might be very useful.
>>
>> > But now it is gone.
>>
>> >
>>
>> > 
>>
>> >
>>
>> > The Web site you seek
>>
>> > Cannot be located but
>>
>> > Countless more exist.
>>
>> > 
>>
>> >
>>
>> > Chaos reigns within.
>>
>> > Reflect, repent, and reboot.
>>
>> > Order shall return.
>>
>> >
>>
>> > 
>>
>> >
>>
>> > ABORTED effort:
>>
>> > Close all that you have worked on.
>>
>> > You ask way too much.
>>
>> >
>>
>> > ---
>>
>> >
>>
>> > Windows 98 crashed.
>>
>> > I am the Blue Screen of Death.
>>
>> > No one hears your screams.
>>
>> >
>>
>> > ---
>>
>> > Yesterday it worked.
>>
>> > Today it is not working.
>>
>> > Windows is like that.
>>
>> >
>>
>> > 
>>
>> > First snow, then silence.
>>
>> > This thousand dollar screen dies
>>
>> > So beautifully.
>>
>> >
>>
>> > 
>>
>> >
>>
>> >
>>
>> > With searching comes loss
>>
>> > And the presence of absence:
>>
>> > ""My Novel"" not found.
>>
>> >
>>
>> > 
>>
>> >
>>
>> > The Tao that is seen
>>
>> > Is not the true Tao, until
>>
>> > You bring fresh toner.
>>
>> >
>>
>> > 
>>
>> >
>>
>> > Stay the patient course.
>>
>> > Of little worth is your ire.
>>
>> > The network is down.
>>
>> >
>>
>> > 
>>
>> > A crash reduces
>>
>> > Your expensive computer
>>
>> > To a simple stone.
>>
>> >
>>
>> > 
>>
>> > Three things are certain:
>>
>> > Death, taxes, and lost data.
>>
>> > Guess which has occurred.
>>
>> >
>>
>> > 
>>
>> >
>>
>> > You step in the stream,
>>
>> > But the water has moved on.
>>
>> > This page is not here.
>>
>> >
>>
>> > Out of memory.
>>
>> > We wish to hold the whole sky,
>>
>> > But we never will.
>>
>> >
>>
>> >
>>
>> > Having been erased,
>>
>> > The document you're seeking
>>
>> > Must now be retyped.
>>
>> >



The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: lerobe - Lee Robertson
  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).



Oracle license costs

2001-03-23 Thread Chaim . Katz



List,
Recently there was a discussion concerning the cost of Oracle licenses vs MS Sql
Server licenses wasn't there? That discussion was not an issue at my job - until
today which is why I'm wondering if there were any postings that in any shape or
form justified some of the price differential between Oracle and MSSQL? If so,
could someone forward the arguments to me? I would appreciate it very much.

I admit that in the last little while, I was deleting (a little too quickly)
everything that had nothing to do with ants, canada, chocolate factories and
fresh air.

I think what's really  needed is a dba certificate program based on the postings
of this list which would of course include off and on topic material.

Thanks
Chaim
[EMAIL PROTECTED]


-- 
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: Single Code Table or Separate Code tables dilemma

2001-03-23 Thread Tim Sawmiller

Nice, but this construct violates Second Normal Form.  I  only denormalize for 
compelling reasons, like for performance reasons, and I don't see how performance is 
enhanced by jamming all this stuff into one big table.  You may end up with an index 
that has an extra level of index blocks, which comes with a performance hit. 

 

>>> [EMAIL PROTECTED] 03/22/01 01:55PM >>>


Referential integrity is still present if you create Master lookup table with type 
attribute: 

lookup_id varchar2(20)  pk
lookup_type varchar2(20)  pk
description   varchar2(255)

> 1. specific attributes for a particular code type is logically and physically 
>separated from other code types.

It does not matter - just don't read the attributes' values that are irrelevant

> 2. a table lock affects only the concerned code table

who needs a table lock in a lookup table??!!  :-) 

> 3. granular control over the individual code table

still present with the lookup_type column.  



So now for the DBA side: do you prefer to have multiple numerous small tables or one 
large? :-) 


Regards, 
Michael Netrusov, 
www.atelo.com 


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 11:50


> Code tables... been there done that (with PowerBuilder/Oracle) and I don't
> like it. Here's why...
> 
> Large apps may consist of 100's or 1000's of lookup tables so duhvelopers
> like the "master code table" idea because they only have to build one front
> end for maintaining all the "lookup" values. But what about referential
> integrity? If you have to do it against one massive code table via triggers
> or from front end code then you're adding work back to the coding effort.
> What about database tuning? Lookup tables are good candidates for caching...
> Are you going to cache one huge, denormalized code table? If your lookup
> values are in multiple normalized tables then you the DBA can choose which
> tables are suitable for caching.
> 
> With a few exceptions, most "Lookup tables" have a common structure with
> just two columns: one for the PK value and another for the description. You
> could review all the referential integrity/data lookup requirements in your
> app and come up with a common structure for all lookup tables that could
> handle most situations. Here's are some example columns: _ID
> (the primary key);
> short_label; long_label; short_description; long_description; enabled_flag;
> effective_date; expiration_date; date_created; last_update; last_updated_by.
> 
> I'd put my foot down and place the following challenge to the duhvelopers:
> 
> "Any SAVVY developer worth his salt should be able to create a robust,
> object oriented design to make coding a snap no matter how many lookup
> tables there are. [Good] Developers can do this by inheriting from a parent
> window or set of objects in his class library. The label and description
> columns could be for GUI display. The enabled_flag could default to 'Y' and
> be referenced as standard practice in the where clause of every lookup
> query. Ditto for the effective_date and expiration_date columns where your
> validations have a time fence constraint such as a
> 'date_DBA_hourly_rate_increase_becomes_billable column." :>)
> 
> Ready for duhveloper combat...
> Steve Orr
> 
> 
> -Original Message-
> Sent: Wednesday, March 21, 2001 4:32 PM
> To: Oracledba (E-mail); ORACLE-L (E-mail)
> 
> 
> Guys,
> 
> We r working on a Datawarehouse solution.
> 
> Our Duhvelopers want to merge all code tables into a single table by adding
> a codetype column.
> 
> with reference to this, i came across this article from Steve's site
> http://www.ixora.com.au/tips/design/meta-data.htm 
> 
> i want to put them into different individual code tables instead of a single
> table, for the foll reasons.
> 
> 1. specific attributes for a particular code type is logically and
> physically seperated from other code types.
> 2. a table lock affects only the concerned code table
> 3. granular control over the individual code table
> 
> i am short of arguments
> 
> wld be grateful, if ull can advise me which would be better from performance
> perspective.
> 
> -Mandar
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Steve Orr
>   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: Michael 

RE: identifying shared memory segments

2001-03-23 Thread Chuck Hamilton

Thanks. That works on SGI too.

--- Lord David <[EMAIL PROTECTED]> wrote:
> Under unix (Solaris at least): set your oracle environment and run
> $ORACLE_HOME/bin/sysresv.
> No idea about windoze.
> 
> HTH
> David Lord
> 
> -Original Message-
> From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
> Sent: 21 March 2001 16:02
> To: Multiple recipients of list ORACLE-L
> Subject: Re: identifying shared memory segments
> 
> 
> Me too!
> 
> Thanks,Ruth B. Gramolini
> ORACLE & DB2  DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> [EMAIL PROTECTED]
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 21, 2001 10:00 AM
> 
> 
> > A while back someone posted a method for determining which shared
> memory
> segments belonged to an instance. Can someone repost that and CC me?
> Thanks.
> >
> >
> > -
> > Do You Yahoo!?
> > Yahoo! Mail Personal Address - Get email at your own domain with
> Yahoo!
> Mail.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ruth Gramolini
>   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).
>
**
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
>  
> are addressed. If you have received this email in error please notify
> 
> the system manager.
> 
> This footnote also confirms that this email message has been swept by
> 
> MIMEsweeper for the presence of computer viruses.
> 
> www.mimesweeper.com
>
**


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chuck Hamilton
  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: Migration from 7.3.4 to 8.1.6

2001-03-23 Thread Dan . Hubler



The thing that is killing us is a single query.

This query does a group by.

It also references some user-defined functions in the column-list of the
SELECT statement.

These user-defined functions are actually SELECTS from 2 other small
tables.

It is not behaving the same way it did in version 7.3.4.

The table that the query runs against is pretty big (700,000 rows across 4
gig).
The 2 tables referenced by the user-defined functions are very small (10-20
rows).








"Ruiz, Mary A (CAP, CDI)" <[EMAIL PROTECTED]> on 03/22/2001 04:18:30
PM

To:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>


Dan:
  What kinds of problems ?  I am beginning a migration of a hybrid OLTP /
OLAP database from 7.3.4 to 8.1.5 on Solaris 2.6  We are planning to take 6
weeks to "clean up" the
database and fix the chained /migrated rows before we migrate (mainly on
the big tables).  We will spend a month testing on a migrated copy before
migrating production.  Our apps
are custom Powerbuilder apps.  I decided to go to 8.1.5 because our other
databases are 8.1.5, and just live with the fact I cannot import a table
from a multiple-table export.
(that bugs me to no end)  I am most interested in responses to this post.
Maybe some truly compelling reasons to go to 8.1.6 , although I heard about
hanging listener problems
with that version which scared me.

thanks in advance,
Mary Ruiz / Atlanta

-Original Message-
Sent: Thursday, March 22, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L



We just migrated the first of our environments from 7.3.4  to  8.1.6  (
Solaris  2.6   ).

We have run into a couple of problems that only seem to appear when
processing
large tables or large amounts of data.

This is kind of what we expected because we did not have the resources to
do full-blown, production size testing.

Anybody have any information on things that go wrong with this type of
migration?



--
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).



  1   2   >