date:20010530



No details, just simply novell.  I always loved novell over NT, I only went
into NT at the time because of marketability.  Novell has always been a
stronger OS.  Even than Unix when it came to file/print sharing.  It is a
shame though it is so vastely different than NT and Unix and not compatible.
Now that they are becoming that way it is too late.  It is a sad day for IT
when you have to give up a better opperating system because of where the
market is going.  Now I try to avoid NT as much as possible.  Although for
clients it is still the best os.  (Yes I love linux, but it isn't the choice
for everything like many believe).  There is no perfect OS, and in
fact they all stink.  A good combination of them all would be ideal.
 Although each one has VERY strong strengths and equally strong
weaknesses.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L


Six years? No downtime in any way? That would be...uh.unusual. 

I am sure the details are fascinating...do tell.

|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 9:01 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
|| 
|| 
|| I have built Novell boxes that have 2100+ days of uptime :)
|| 
|| Now that is stability that I have yet to see even unix have.
|| Granted it is only Novell 3.12.
|| 
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Sunday, May 27, 2001 8:10 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Jared,
|| 
|| I have an NT 4 server up for 242 days.
|| 
|| Someone where I work suggested it should be sent to Microsoft for an
|| examination (must be something wrong with it).
|| 
|| Regards,
|| Bruce
|| 
|| -Original Message-
|| Sent: Saturday, 26 May 2001 12:16 
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| On Friday 25 May 2001 18:26, Weaver, Walt wrote:
|| > Ditto. I support Jared's backspace claims 100%, and I 
|| don't think he
|| should
|| > be removed from the list.
|| 
|| I sure appreciate that Walt!
|| 
|| > I've heard there are other operating systems out there 
|| besides Linux and
|| > Solaris. Is this true?
|| 
|| A nasty rumor.  There's an upstart startup in WA that claims to have
|| something akin to an OS, but it keeps failing the 30 day 
|| stability test.
|| 
|| Jared
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jared Still
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Reardon, Bruce (CALBBAY)
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Christopher Spence
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-

RE: Performance tuning

2001-05-30 Thread Jim Hawkins


Sorry - that's what I meant.  No archive log generation.  NOT no redo log 
generation.  Thanks for pointing that out.  Is it Friday yet?

Jim


> Why putting DB in noarchivelog will avoid redo generation? There will be 
no
> archiving, but redo will continue to be generated.
> 
> Alex Hillman
> 
> -Original Message-
> Sent: Wednesday, May 30, 2001 10:21 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Azhar,
> 
> Just two thoughts off the top of my head to improve loading of records:
> 1.  Put database in noarchivelog mode to avoid redo generation (if 
> possible).
> 2.  Drop all indexes on target tables (if possible), then load data, then 
> recreate all indexes on target tables.
> 
> Jim
> 
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 600 Pearl Drive
> St. Louis, MO  633376
> 9636) 474-7832
> [EMAIL PROTECTED] (work)
> [EMAIL PROTECTED] (home)
> 
> > 
> > HI ALL,
> > We have to load almost 3 millions records of average row size of 150 
> bytes.
> > We are importing data using sqloader with ROWS=4000 and 
bindsize=845 .
> > We have adjusted the rollback segment to almost  10 m with 8 extents 
> enough
> > for single transaction size and considering 30% rollback overhead. We
> > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
> > Rollback segment, databuffer cache have hit ratio of 100%.
> > 
> > The loading was fast only for first 10 commits but then it slowed like
> > snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs 
RAM
> > .
> > SGA figures in M :
> > NAME VALUE
> >  -
> > Fixed Size.0676384
> > Variable Size239.02734
> > Database Buffers   39.0625
> > Redo Buffers 7.8203125
> >  -
> > sum  285.97779
> > ( we can't use direct path due to functions in sqlldr controlfile). .
> > Couldn't figure out the bottleneck yet.
> > Any ideas.
> > TIA
> > Azhar Siddiq,
> > DBA
> > LMK Resources
> > 
> > -- 
> > 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).
> > 
> > 
> 
> 
> -- 
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 600 Pearl Drive
> St. Louis, MO  633376
> 9636) 474-7832
> [EMAIL PROTECTED] (work)
> [EMAIL PROTECTED] (home)
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jim Hawkins
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Hillman, Alex
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

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

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

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

RE: PL/SQL Error

2001-05-30 Thread Jamadagni, Rajendra


David,

What I'd want to see is the actual call you are making in the ASP code. Your
package is fine, the problem is with the variables (you have defined in the
ASP code), that are used when this procedure is being called.

If you can ensure that the variables have been declared as following you
should be okay ... otherwise Oracle is right ...

declare
 var1 course.course_bulletin.tbl_call_no;
 var2 course.course_bulletin.tbl_schl_cd;
 var3 course.course_bulletin.tbl_dept_cd;
begin
  course.course_bulletin(i_ccyy, var1, var2, var3);
end;


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

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

*1

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

*1

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]


It is a good point that it's a string, I actually knew that, but it still
doesn't explain why i can't get it to work. Not that it's that big of a
deal.  I'll try again, no harm in that.
Kev

-Original Message-
Sent: Wednesday, May 30, 2001 12:36 PM
To: Multiple recipients of list ORACLE-L
versions of tnsnames.ora in NT/W2K]


If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple
folders, like:

HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1


then you have to create TNS_ADMIN string value (not key) in each of those
folders pointing to your master tnsnames.ora file.

Works for me.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 10:56 AM
versions of tnsnames.ora in NT/W2K]


> On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get
> Oracle db to work off of the tns_admin key.  Only forms would work off of
> the tns_admin, and without that key forms would not connect to the dbs.
> Just thought I would mention that.
> Kev
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 7:16 AM
> To: Multiple recipients of list ORACLE-L
> versions of tnsnames.ora in NT/W2K]
>
>
> You CAN actually set the TNS_ADMIN variable in the registry under
> HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all
you
> need to do is create a new "key" called TNS_ADMIN with a value of the path
> to your master tnsnames.ora file.
>
> HTH
>
> Mark
>
> -Original Message-
> Granaman
> Sent: Tuesday, May 29, 2001 09:45
> To: Multiple recipients of list ORACLE-L
> versions of tnsnames.ora in NT/W2K]
>
>
> In Unix, one can create links to a master by "$ ls -s  tnsnames.ora> ".
> (I know, I could, and probably should, use the TNS_ADMIN environmental
> variable instead.)
>
> There seems to be no equivalent of this in NT though.  Creating a
"shortcut"
> doesn't seem to work.  Copying files around seems primitive at best.  Am I
> missing something?  [OK, OK!  I'll reform and use the environmental
> variable!]
>
> -Don Granaman
> [certifiable OraSaurus]
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, May 29, 2001 2:01 PM
>
>
> > Dave,
> >
> > It seems to me that you are having a problem reading the proper
> TNSNAMES.ORA for
> >
> > the different DBs.  What I would do in your situation is to search for
all
> > TNSNAMES.ORA files in your PC, since you have products installed in more
> than
> > one home and more than one version you should have multiple.  Edit them
> and see
> > which ones contain the entries that you need, in one or more of them
some
> > entries will be missing, what you can do is copy/paste the missing
> entries, once
> >
> > you have the file you want then copy it to all the different "Homes" and
> you
> > should be able to connect to the different DB's.
> [... snip ...]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Don Granaman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Mark Leith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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

RE: PL/SQL Error

2001-05-30 Thread Jack C. Applewhite


David,

How are you calling this procedure?  Into what structures are you receiving
the PL/SQL Out Arguments, which are PL/SQL tables?  I'll bet that's your
problem.

Show us the code that calls this procedure and handles the output.

BTW, if you checked the "speeling" of your PL/SQL as well as you did your
message, there may be even more problems.   ;-)

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
David
Sent: Wednesday, May 30, 2001 12:07 PM
To: Multiple recipients of list ORACLE-L


Hi all

Can someone help me out here? I am getting this error when I try to run this
PL/SQL code from an ASP page.
The error manual just says to check speeling. I DID. Is there anything I am
missing?  The DB is V7.3  I am trying to
return the resultset to the page.

PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT'

Here is the PL/SQL code

create or replace package course.course_bulletin is
TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type
INDEX BY BINARY_INTEGER;
TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type
INDEX BY BINARY_INTEGER;
TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type
INDEX BY BINARY_INTEGER;

  PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd);

end;

create or replace package body course.course_bulletin as

  PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd) IS
   CURSOR c1 is
   SELECT call_no,schl_cd,dept_cd
FROM COURSE.cmcmcrst
   WHERE ccyy = i_ccyy
   AND term_cd = '2'
   AND instrl_cd = '0';

  crscount NUMBER DEFAULT 1;

  BEGIN
  FOR c IN c1 LOOP
o_call_no(crscount) := c.call_no;
o_schl_cd(crscount) := c.schl_cd;
o_dept_cd(crscount) := c.dept_cd;
crscount := crscount + 1;
  END LOOP;
  END;
end;

--

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: PL/SQL Error

2001-05-30 Thread Bartolo, David


Here is the ASP code

ccyy = "2001"

set cn = server.CreateObject("adodb.connection")
set cmd = server.CreateObject("adodb.command")
set rs = server.CreateObject("adodb.recordset")

cn.ConnectionTimeout = 120
cn.CommandTimeout=30
cn.ConnectionString="DSN=db;UID=user;Password=pwd"
cn.Open

cmd.ActiveConnection = cn
cmd.CommandText = "{call course.course_bulletin.course_select({resultset
1, o_call_no,

o_schl_cd, o_dept_cd})}"
cmd.CommandType=adCmdText

cmd.Parameters.Append cmd.CreateParameter("i_ccyy", adInteger, adParamInput,
, clng(ccyy))
set rs.Source = cmd
rs.Open

-Original Message-
Sent: Wednesday, May 30, 2001 12:01 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]



I think the error is in the call to the procedure, not in the procedure
itself -- the procedure looks fine at a glance.  Could you post the ASP
code that makes the call?

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


 

"Bartolo,

David"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>   
  Fax to:

Sent by: Subject: PL/SQL Error

root@fatcity.

com

 

 

05/30/2001

01:06 PM

Please

respond to

ORACLE-L

 

 





Hi all

Can someone help me out here? I am getting this error when I try to run
this
PL/SQL code from an ASP page.
The error manual just says to check speeling. I DID. Is there anything I am
missing?  The DB is V7.3  I am trying to
return the resultset to the page.

PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT'

Here is the PL/SQL code

create or replace package course.course_bulletin is
TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type
INDEX BY BINARY_INTEGER;
TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type
INDEX BY BINARY_INTEGER;
TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type
INDEX BY BINARY_INTEGER;

  PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd);

end;

create or replace package body course.course_bulletin as

  PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd) IS
   CURSOR c1 is
   SELECT call_no,schl_cd,dept_cd
FROM COURSE.cmcmcrst
   WHERE ccyy = i_ccyy
   AND term_cd = '2'
   AND instrl_cd = '0';

  crscount NUMBER DEFAULT 1;

  BEGIN
  FOR c IN c1 LOOP
o_call_no(crscount) := c.call_no;
o_schl_cd(crscount) := c.schl_cd;
o_dept_cd(crscount) := c.dept_cd;
crscount := crscount + 1;
  END LOOP;
  END;
end;

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bartolo, David
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Performance tuning


>Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT
performance monitor and it shows that it is not using swap heavily.

NT swaps heavily with 128Mb ram running office, you must have some sort of
magical system to run oracle with such a large table on it.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L



Actually we have to



Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT
performance monitor and it shows that it is not using swap heavily.
Currently disk configuration is not RAID . however we have  no disk limit
problem. i have autoexetended datafiles.
Regards
Azhar
 

 

 


 

 

 



 

Peter McLarty

   
incts.com> cc:

Sent by:   Subject: Re: Performance
tuning   
[EMAIL PROTECTED]

m

 

 

05/30/2001

04:21 PM

Please respond

to ORACLE-L

 

 




Okay fill us in why would you try and inane thing like that on only 128MB
RAM. NT would be barely running on that without getting your instance up. I

am not that good yet at calculating what amount of RAM you need for a given

SGA but I am thinking that you are running in swap

What is the disk configuration.

Are you running RAID and if so what configuration. (Not RAID 5 I hope)

Can you get this system up to 512MB at least.

With this and a whole lot more you will get some better answers

Peter
Trainee Oracle DBA

At 01:19 AM 30/05/2001 -0800, you wrote:

>HI ALL,
>We have to load almost 3 millions records of average row size of 150
bytes.
>We are importing data using sqloader with ROWS=4000 and bindsize=845 .
>We have adjusted the rollback segment to almost  10 m with 8 extents
enough
>for single transaction size and considering 30% rollback overhead. We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
>.
>SGA figures in M :
>NAME VALUE
> -
>Fixed Size.0676384
>Variable Size239.02734
>Database Buffers   39.0625
>Redo Buffers 7.8203125
>  -
>sum  285.97779
>( we can't use direct path due to functions in sqlldr controlfile). .
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>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: Peter McLarty
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 F

RE: Build an exact copy of a database using export / import

2001-05-30 Thread Kevin Lange


We use "Clones" of databases all the time.   Its much faster than the
Export/import run.   We simply take the DB down, copy the data files to a
new server in the same file layouts (i.e. ... same directory tree), copy
over and change the init file for the new DB name, and bring it up.  Then
you have to alter the global name.  Its a relatively simple process.

If there are tablespaces that were in the original one that you do not want
over then, at this point, drop any associated objects and drop the
tablespaces.

-Original Message-
Sent: Wednesday, May 30, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L


Well, depending on the size of the db and some other network stuff, I do the
following.  I shut down the real db, copy all of the data files,
controlfiles and init file to a machine with Oracle on it.  Then you can
create the service (NT), alter any of the datafiles if necessary (on
different logical drive) then you can just bring that bad boy up.  Then I
just give it a different alias, works for me.
However, what do you mean it creates new tablespaces, I have never
seen
that happen, it just fails miserably for me if the tablespaces don't exist.
You could do the full export, create a new user on the new machine and grant
"become  any user" to the new user.  I believe that then the import would
work, I've done it before.  Sorry I don't have more, brain is still a littel
soft from the weekend.
Kev

-Original Message-
L.
Sent: Wednesday, May 30, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


When I build a new test database I create the database and run all the
required Oracle scripts.  Then I do a full import of a production export.
This works pretty well but I miss some of the grants and The full import
wants to create tablespaces that I may or may not want created.  I get a lot
of errors on system objects.  Does anyone have the proper steps to create an
exact copy of a production database using export / import?

Thanks!
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: 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 Lange
  INET: [EMAIL PROTECTED]

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

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

OT RE: Effective Living

2001-05-30 Thread Boivin, Patrice J

Actually, I think following the Tao has more to do with being true, i.e.
being who you are, which also naturally meshes with where nature is heading.
Similar to other religions that tell you that if you follow certain
precepts, you will be "purer" and therefore will be closer to heaven, God,
whatever.  Otherwise you are living in sin, which actually means "off the
mark", like an arrow that misses its target.

Asking why is good if it brings back to your self, but if you are asking why
and speculating ad nauseam you are off on a tangent.  Like that inner
chatter we sometimes hear in our heads.

That instructor was Austrian, by the way, about fifty to fifty-five years
old when I took that course, which was over ten years ago.  So perhaps he
went through WW2 when he was a child, who knows.  I am also biased, being
son of two psychologists, I don't like social workers all that much
precisely because they don't like to take societal context into account.
Mind you a lot of psychologists and psychiatrists do the same thing, ignore
the context and just try to make the better "better adjusted" - ha ha

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L
Subject:OT: Effective Living

Isn't that sort of like Taoism?  Accept your lot, there must be good
in it
somewhere...

Also, it seems to be the basis of many major religions to
essentially never
ask why.  So, I guess it's a pretty popular philosophy.

(Oh no, I feel a discourse by Eric coming on...)

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]

"Kevin

Kostyszyn"   To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>   
   Fax to:

Sent by: Subject: RE:

root@fatcity.

com

05/30/2001

11:02 AM

Please

respond to

ORACLE-L

This person was actually allowed to teach.  Never ask why, yes
that's a
super philosophy on life.

-Original Message-
Patrice J
Sent: Wednesday, May 30, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L

That's a laugh, I went to a continuing education seminar once at
Carleton
University, in Ottawa.

The seminar was called Effective Living.

The teacher was a social worker, and he emphatically told everyone
NEVER to
ask why, just adapt to life and keep moving...

I had unreconcilable disagreements with him, I guess I don't know
how to
live.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

   -Original Message-
   From:  Don Granaman [SMTP:[EMAIL PROTECTED]]
   Sent:  Tuesday, May 29, 2001 4:11 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:   Re:

   when?
   But, more important, WHY???

   -Don Granaman
   [certifiable OraSaurus]

   - Original Message -
   To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
   Sent: Tuesday, May 29, 2001 1:28 PM

   > And Where.
   >
   > Terry
   >
   > "Boivin, Patrice J" wrote:
   >
   > > When and how
   > >
   > > Patrice Boivin
   > > Systems Analyst (Oracle Certified DBA)
   > >
   > > -Original Message-
   > > From:   Kevin Kostyszyn
[SMTP:[EMAIL PROTECTED]]
   > > Sent:   Tuesday, May 29, 2001 1:41 PM
   > > To: Multiple recipients of list ORACLE-L
   > > Subject:RE:
   > >
   > > what
   > >
   > > -Original Message-
   > > Andrea
   > > Sent: Tuesday, May 29, 2001 11:47 AM
   > > To: Multiple recipients of list ORACLE-L
   > >
   > > who
   > >

OT ("communities of practice") listserv - forum facilitation FAQ


Bruce, Jared & folks,

See below for the info I was looking for yesterday (I gave
you the wrong site, sorry).

regards,
ep

cc: [EMAIL PROTECTED]


http://www.co-i-l.com/coil/knowledge-garden/vcfaq/facfaq1.shtml

version 0.9
   FAQ Editor: George Pór

 About this FAQ
 When and why forums have to be facilitated?
 What are the main roles and responsibilities in
 facilitating forums?
 System Administrator
 Account Administrator
 Forum Convener
 Community Architect
 Moderator
 Content Facilitator
 Cybrarian



 About this FAQ

 Most of the roles and responsibilities
 described in this FAQ are part of a new kind
 of work with no ready-made job-descriptions.

 The responses are definitely not definitive;
 they will change as our understanding of the
 requirements for effectively facilitating virtual
 communities will deepen through the feedback
 from, and collaboration with facilitators
 reading and contributing to this FAQ.

 When and why forums have to be facilitated?

 Facilitate = make easy, promote, help forward
 action or result. (Oxford Dictionary)

 Online facilitators or hosts are the primary
 enablers of any virtual community. It is their
 enthusiasm and attention to the participants
 challenges in communicating and collaborating
 in cyberspace, that can make or brake
 fledgling online communities. Without their
 efforts "it is difficult to build momentum,
 maintain the flow and generate the activity that
 will help to ensure return visits."
   (Denham Grey)

 Developing competence in facilitating the
 electronic meeting of minds that takes place in
 forums is a must in companies that want to turn
 the web tools and methods of coordination into
 a strategic advantage to achieve breakthrough
 results.

 The number of required facilitative functions
 is raising along the following continuum:

  Communities of interest (hobby groups) -->
  communities of practice (professional communities) -->
  communities of commitment (teams, taskforces, work groups).

 What are the main roles and
 responsibilities in facilitating
 forums?

 Responsibilities outlined under the following roles
 can be assumed by one or a few individuals in
 small virtual communities.

 In larger communities, they are divided among the
 participants of the facilitation team.

  System Administrator

 Participates in the administration of the server
 Contributes suggestions and implements
 software-related measures for maximizing uptime
 Maintains software integrity and forum security
 Provides other participants of the facilitation
 team and users with technical support

  Account Administrator

 Implements access privileges
 Issues or confirms user names and passwords in
 password-protected forums

  Forum Convener

 Forum Convener, sometimes also called
 chairperson, is a function of someone who has a
 major stake in the forums outcome(s), typically
 performed in task-oriented virtual communities.

  Community Architect

 Optimizes the community's structure and design to
 help it meet its purpose

 Using the appropriate combination of groupware
 features, designs virtual spaces to meet specific
 community functions

 Drafts guidelines for forum community norms
 ("community covenant")

 Writes and edits user agreements

 Designs the structure of initial topics

 Seeds topics with context-setting materials

 Designs strategy and mechanisms for collecting and
 incorporating feedback from participants

  Moderator

 The moderator, also called "host" or "organizer":

 Participates in the preliminary planning of the
 forum with the sysadmin, convener, and community
 architect

 Welcomes and acknowledges participants

 Stimulates participation and sustains interest

 Facilitates a healthy group dynamics conducive to
 higher quality contributions and achieving
 objectives in task-oriented forums

 Keeps the conversation focused on the purpose of
 the forum

 Provides pointers to sources of user support

 Models behaviors of effective communication and
 collaboration

 Provides closure: in task-oriented forums, s/he
 declares the forum or any topics of it closed, when
 its function is complete

  Content Facilit

RE: backspace in Oracle.


Kim, 

Did you hear the one about the NT box
that ran for SEVEN YEARS, playing solitaire?

Yea, me neither, but it's a good story, just
like the Novell one. 

:)


|| -Original Message-
|| From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 12:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
|| 
|| 
|| Ya, but I can keep a NT box for a long time to, if I don't touch it.
|| 
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 6:01 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| I have built Novell boxes that have 2100+ days of uptime :)
|| 
|| Now that is stability that I have yet to see even unix have.
|| Granted it is only Novell 3.12.
|| 
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Sunday, May 27, 2001 8:10 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Jared,
|| 
|| I have an NT 4 server up for 242 days.
|| 
|| Someone where I work suggested it should be sent to Microsoft for an
|| examination (must be something wrong with it).
|| 
|| Regards,
|| Bruce
|| 
|| -Original Message-
|| Sent: Saturday, 26 May 2001 12:16 
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| On Friday 25 May 2001 18:26, Weaver, Walt wrote:
|| > Ditto. I support Jared's backspace claims 100%, and I 
|| don't think he
|| should
|| > be removed from the list.
|| 
|| I sure appreciate that Walt!
|| 
|| > I've heard there are other operating systems out there 
|| besides Linux and
|| > Solaris. Is this true?
|| 
|| A nasty rumor.  There's an upstart startup in WA that claims to have
|| something akin to an OS, but it keeps failing the 30 day 
|| stability test.
|| 
|| Jared
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jared Still
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Reardon, Bruce (CALBBAY)
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Christopher Spence
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Kimberly Smith
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

RE: Your views on Quest - Shareplex

2001-05-30 Thread Jacques Kilchoer

Title: RE: Your views on Quest - Shareplex





> -Original Message-
> From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
> 
> We are looking into the product as well, but have yet to even 
> toy with the product.  There is a "no chained rows" 
> restriction.


I'm not sure what that statement means. Shareplex will replicate a table that has chained rows.


> Shareplex does not replicate transactions on 
> sys objects.  A table dropped  on one side will not be 
> dropped on the other.  It apparently will replicate truncates 
> however.  It's one thing to read the logs and to find the 
> time when a truncate caused writes to the data dictionary, 
> but quite another to reconstruct the statement.


Statement from a developer of Shareplex:
<>


Let me relate my personal experience working with Shareplex (BEFORE I was an employee with Quest Software). At a previous company we were looking for a replication tool at a company that did payroll taxes. There were large batch loads (bank records) every night, but especially at the end of each quarter and at the end of the year. We wanted to ensure that the replication tool we chose would be fast enough to keep up with the large data loads. When we tested Oracle Replication and Quest Shareplex, we found that Shareplex was significantly faster. I personally argued against it initially for some of the reasons posters here have mentioned (e.g. it uses "unsupported" means to accomplish its goal) but eventually we implemented Shareplex and were satisfied with the result. There can be some manual effort involved in reconciliation of discrepancies but we found that effort to be minor. Another factor that influenced our decision is that we were intending to use Shareplex for Oracle in conjunction with Shareplex FS to replicate datafiles created on the HP-UX server.

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

Re: PL/SQL Error

2001-05-30 Thread Diana_Duncan



I think the error is in the call to the procedure, not in the procedure
itself -- the procedure looks fine at a glance.  Could you post the ASP
code that makes the call?

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   

"Bartolo,  

David"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
  Fax to:   

Sent by: Subject: PL/SQL Error 

root@fatcity.  

com

   

   

05/30/2001 

01:06 PM   

Please 

respond to 

ORACLE-L   

   

   





Hi all

Can someone help me out here? I am getting this error when I try to run
this
PL/SQL code from an ASP page.
The error manual just says to check speeling. I DID. Is there anything I am
missing?  The DB is V7.3  I am trying to
return the resultset to the page.

PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT'

Here is the PL/SQL code

create or replace package course.course_bulletin is
TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type
INDEX BY BINARY_INTEGER;
TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type
INDEX BY BINARY_INTEGER;
TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type
INDEX BY BINARY_INTEGER;

  PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd);

end;

create or replace package body course.course_bulletin as

  PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd) IS
   CURSOR c1 is
   SELECT call_no,schl_cd,dept_cd
FROM COURSE.cmcmcrst
   WHERE ccyy = i_ccyy
   AND term_cd = '2'
   AND instrl_cd = '0';

  crscount NUMBER DEFAULT 1;

  BEGIN
  FOR c IN c1 LOOP
o_call_no(crscount) := c.call_no;
o_schl_cd(crscount) := c.schl_cd;
o_dept_cd(crscount) := c.dept_cd;
crscount := crscount + 1;
  END LOOP;
  END;
end;

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 informat

RE: Is DBMS_OBFUSCATION free in Enterprise Edition?

2001-05-30 Thread Wolfe, Charles


It is free.

-Original Message-
Sent: Wednesday, May 30, 2001 2:02 PM
To: Multiple recipients of list ORACLE-L



We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6.

My manager needs a definitive answer.   Is DBMS_OBFUSCATION
free with this version of Enterprise Edition server or is it part of an
extra-cost add-on.

All definitive answers welcome. I have a call in to Oracle but they
have not yet responded.  My manager wants to know today.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: random equipment seen ???/ RE: V$SESSION.OSUSER returns


http://www.cfainc.org/breeds/profiles/articles/maine.html

---excerpt---

   The Maine Coon Standard

   The Maine Coon Cat is a massive, broad chested cat with a long
   rectangular body and the fur is long and flowing. The males
   average around 12 to 15 pounds, with some going 20 pounds or more.
   The females are smaller, averaging 9 to 12 pounds. 

...

   The Maine Coon is slow to mature, often not reaching full
   development until three to four years of age. 

...

   The Maine Coon is a gentle, loyal breed. They make wonderful
   family pets and get along well with children and dogs. Depending
   on the breed of dog, the Maine Coon can be bigger than Fido. They
   are a vocal breed, with a variety of meows, trills and chirps to
   make up their vocabularies. They are sociable and like to help
   their owners with any project, especially when the owner is
   reading or working on the crossword puzzle.  

   Since 1976, the Maine Coon Cat has been a rising star in the
   competitive reaches of the cat fancy. This popular breed of the
   late 19th century drifted into obscurity and imagined extinction
   well into the 1950s. Those of us who now work with and breed the
   Maine Coon owe a tremendous THANK YOU to those who worked and
   fought for recognition and the championship status we enjoy today.
   As any exhibitor can tell you, spectators can often be seen
   watching the Maine Coons being judged, exclaiming at the size, and
   even saying they have one or two like them at home - today, they
   probably do. The Maine Coon is the second most popular cat in CFA
   as seen by the numbers of kittens registered. America's first show
   cat is back, bigger and better than ever.  

---end---

On 30 May 2001, at 6:56, Christopher Spence wrote:

Date sent:  Wed, 30 May 2001 06:56:50 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> mainekoon cats.  Almost as big as dogs ...

...

-- 
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: Script examples for NT. (yuk!)


You can download CyGWin from Redhat for free that will give you a very nice
cloned shell of linux environment, full compatable with Bash/Sh scripting.

Wish i could find a ksh shell for it, but it has ALOT of the tools normally
available with Unix.  ps, kill, grep, tail, head, piping, shell scripts.

I will generally write scripts in it and move it to unix with no
compatibility problems.

Exact url: http://sources.redhat.com/cygwin/

There are many other unix clones for NT, some are great, some are simily a
directory with clone commands in it.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L


Quick question..

ALL of my experience has been on UNIX platforms... Recently, I have been
asked to work on an Oracle DB that runs on NT.. My scripting capability in
the NT world is "weak" at best.  So I am trying to compare ksh type
activities with the NT world. SO I was wondering if any of you would mind
sharing a couple of NT type scripts with me.. For example-setting variables
to the return of a SQL statement to be used in the shell,etc...

Any help would be appreciated..

TIA

Greg Loughmiller




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OEM Book Recommendation

2001-05-30 Thread K Gopalakrishnan


Rahul !

I have not seen any **books** on OEM. But you can
check in to OLN (!!) Oracle Learning Network and there
are some classes on OEM. 



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Performance tuning

2001-05-30 Thread George Schlossnagle


No to be overly pedantic, but RAID5 does not change the number of write()
calls made by DBWR.  It will change the number of disk operations done by
your hardware controller or your software raid drivers, but that's slightly
different.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:02 PM


> Raid 5 can consume as much as 60% overhead for writes.
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
>
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
> believe. RAID 5 will require additional writes by DBWR which is going to
be
> huge overhead during a dataload.
>
> - Ethan Post
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [EMAIL PROTECTED] eg
> [EMAIL PROTECTED] Emails using the old format will continue to be
delivered
> until 30th June 2001.
>
> Peter McLarty wrote
> "Are you running RAID and if so what configuration. (Not RAID 5 I hope)"
>
> Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
> performance for Oracle RDBMS on NT
>
> RAID 5 is useful for Oracle datafiles but not for redo log files or
rollback
> segments which are sequentially accessed. Datafiles belonging to the
> temporary tablespace are not suitable for a RAID 5 device. More benefits
> will be seen in situations where reads predominate over writes.
>
> I know that in this instance it is a data load that is being discussed but
> presumably once the data is loaded then it will be read more than once.
>
> Certainly the tone of the note suggests that raid 5 is not a definite
no-no
> rather a 'be cautious as to which files are placed where'. It is my belief
> that often a single raid level is set for all files rather than a mix of
> raid 1 and raid 5 as appropriate.
>
> Peter, I fully agree that the level of memory utilised here is totally
> insufficient and is very likely to be the constraining factor in this
case.
>
> John
>
>
> --
--
> --
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you have received this message in error, please
> inform us promptly by reply e-mail, then delete the e-mail and destroy any
> printed copy.   Thank you.
>
>

> ==
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Christopher Spence
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: George Schlossnagle
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Effective Living


Yeah, but just because something is popular doesn't meen it is good. If we
all lived our lives that way everyday I am not so sure we would get much
accomplished?

Oh no, the Database is down!!
Why?
I don't know, who cares.
hehehe

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L



Isn't that sort of like Taoism?  Accept your lot, there must be good in it
somewhere...

Also, it seems to be the basis of many major religions to essentially never
ask why.  So, I guess it's a pretty popular philosophy.

(Oh no, I feel a discourse by Eric coming on...)

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]



"Kevin
Kostyszyn"   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
   Fax to:
Sent by: Subject: RE:
root@fatcity.
com


05/30/2001
11:02 AM
Please
respond to
ORACLE-L






This person was actually allowed to teach.  Never ask why, yes that's a
super philosophy on life.

-Original Message-
Patrice J
Sent: Wednesday, May 30, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L


That's a laugh, I went to a continuing education seminar once at Carleton
University, in Ottawa.

The seminar was called Effective Living.

The teacher was a social worker, and he emphatically told everyone NEVER to
ask why, just adapt to life and keep moving...

I had unreconcilable disagreements with him, I guess I don't know how to
live.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


   -Original Message-
   From:  Don Granaman [SMTP:[EMAIL PROTECTED]]
   Sent:  Tuesday, May 29, 2001 4:11 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:   Re:

   when?
   But, more important, WHY???

   -Don Granaman
   [certifiable OraSaurus]

   - Original Message -
   To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
   Sent: Tuesday, May 29, 2001 1:28 PM


   > And Where.
   >
   > Terry
   >
   > "Boivin, Patrice J" wrote:
   >
   > > When and how
   > >
   > > Patrice Boivin
   > > Systems Analyst (Oracle Certified DBA)
   > >
   > > -Original Message-
   > > From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
   > > Sent:   Tuesday, May 29, 2001 1:41 PM
   > > To: Multiple recipients of list ORACLE-L
   > > Subject:RE:
   > >
   > > what
   > >
   > > -Original Message-
   > > Andrea
   > > Sent: Tuesday, May 29, 2001 11:47 AM
   > > To: Multiple recipients of list ORACLE-L
   > >
   > > who
   > > --
   > > Please see the official ORACLE-L FAQ:
http://www.orafaq.com
   > > --
   > > Author: Quaglio Andrea
   > >   INET: [EMAIL PROTECTED]
   > >
   > > Fat City Network Services-- (858) 538-5051  FAX:
(858)
   538-5051
   > > San Diego, California-- Public Internet
access /
Mailing
   > > Lists
   >


   > > To REMOVE yourself from this mailing list, send an
E-Mail
   message
   > > to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and
   in
   > > the message BODY, include a line containing: UNSUB
ORACLE-L
   > > (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

RE: Performance tuning

2001-05-30 Thread Boivin, Patrice J


I don't know what is causing this, but I would keep an eye on physical
memory available vs. commit charge in Task Manager, I strongly recommend
your commit charge never exceed your physical memory.

I found that Oracle sometimes refuses to even start services when it runs
out of physical memory, it doesn't like virtual memory very much.  Shrinking
the size of your SGA is preferable to exceeding the available physical
memory, in my opinion.  Keep in mind session memory space in your
calculations, and the other programs you may be running on your machine.

I recommend you stop all the services (in Services applet) that you dare
stop, to lighten the load.

In the virtual memory settings, allocate the amount you want, but try to
avoid a range of values - when initial and max size values are different NT
keeps polling the pagefile and memory statistics to figure out if the
pagefile should grow or shrink.  Better to do that manually up front,
allocate at set amount.  NT then stops doing extra work regarding memory
allocation.

Every little bit helps.

I haven't used SQL*Loader, so I can't say much about that, except... when
you start loading those first few rows, what does Commit Charge look like in
Task Manager?  Is it growing?  If it is, notice how slowly NT does this.  It
can't be helped.  If commit charge approaches physical memory available, you
will hit a ceiling I think.  Then things may well slow down to a crawl.

Is there a buffer size you can set for SQL*Loader?  I always set my exp
buffer size to 100 to speed it up.  Maybe you can do the same for
SQL*Loader.  That must use more memory though.

Can you commit every few records?  Could it be every 10 rows? Would it be
better not to commit too often?

As mentioned before, RAID 5 will prove slower than simple disk or RAID 01 or
RAID 10.

Do you have many indexes on the tables you are filling up?  You may want to
drop them and re-create them once the load is finished.

This may sound silly but... do you have a virus checking program running on
your server?  Try to exclude the oradata directories from it.

Just some ideas.  That's what I would check first.

If your RBS segments filled up, you would see an error somewhere, it seems
to me.  Is TEMP filling up?  You never know.

Oh another probably silly thing - if you are not using SCSI, download
DMACheck from microsoft and test whether your DMA is turned on.  That would
speed up your disk by 40% or more.  Servers use SCSI disks normally though,
but sometimes people install Oracle on PCs or workstations with IDE drives.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]  

>HI ALL,
>We have to load almost 3 millions records of average row size of
150
bytes.
>We are importing data using sqloader with ROWS=4000 and
bindsize=845 .
>We have adjusted the rollback segment to almost  10 m with 8
extents
enough
>for single transaction size and considering 30% rollback overhead.
We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed
like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128
megs RAM
>.
>SGA figures in M :
>NAME VALUE
> -
>Fixed Size.0676384
>Variable Size239.02734
>Database Buffers   39.0625
>Redo Buffers 7.8203125
>  -
>sum  285.97779
>( we can't use direct path due to functions in sqlldr controlfile).
.
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>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 ORACL

Re: OT: Archiving not possible with SQL Server?

2001-05-30 Thread Jared Still

And thus you discover the inane mechanism that SQL Server
inherited from Sybase, by which both try to do concurrency.

Guess what happens when a long running transaction marks
the log near the end, and not too long afterward the log
needs truncated?

If memory serves, ( hasn't worked too well lately :) the database
will hang.  It may just truncate back to the mark, and start from
there, but you always have the possibility of another long
transaction starting.

Can't remember the details, but what I do remember clearly
is that it is a process that has to be closely watched, and I
didn't particularly care for the way it worked.

Jared

On Wednesday 30 May 2001 11:41, Gary Weber wrote:
> Halo,
>
> Windoz 2000/SQL Server 2000
>
> Bringing an axuliary MS SQL db online. Trying to setup "archiving". Am I
> reading documentation right, SQL does NOT automatically archive transaction
> log? This process must be setup via backup routine, which truncates the log
> upon completion?
>
> Lemme try some logic:
>
> Oracle's redo logs = MS transaction log(s)
> Oracle's archived logs = ?
>
>
> Gary Weber
> Senior DBA
> Charles Jones, LLC
> 609-530-1144, ext 5529
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OEM Book Recommendation

2001-05-30 Thread Kevin Lange


I am afraid I have seen 0, Nada, Zilch on OEM.  Even the Oracle based
instructions are prety bad.  The best source yet has been the online
manuals.  At least they are searchable.

-Original Message-
Sent: Wednesday, May 30, 2001 1:37 PM
To: Multiple recipients of list ORACLE-L


Rahul !

I have not seen any **books** on OEM. But you can
check in to OLN (!!) Oracle Learning Network and there
are some classes on OEM. 



=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7

2001-05-30 Thread PHU,JULIA (HP-Sunnyvale,ex2)


VARCHAR is the older version. VARCHAR2 is for 8.0 and above. Changing from
VARCHAR to VARCHAR2 for 8.1.7 will solve the problem.




-Original Message-
Sent: Wednesday, May 30, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
8.1.7.1



Cherie, I have no idea if this could be the case, but I noticed that the
type is based on the datatype VARCHAR, not VARCHAR2.  According to the
docs, this shouldn't make a difference, but they've been warning since the
introduction of VARCHAR2 that they may do something different with VARCHAR
at some point in the future, so it's best not to use it.  From the PL/SQL
manual:

===

VARCHAR2 Subtypes


The VARCHAR2 subtypes below have the same range of values as their base
type. For example, VARCHAR is just another name for VARCHAR2.
 STRING
 VARCHAR


You can use these subtypes for compatibility with ANSI/ISO and IBM types.


Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future
releases of PL/SQL, to accommodate emerging SQL standards, VARCHAR might
become a separate datatype with different comparison semantics. So, it is a
good idea to use VARCHAR2 rather than VARCHAR.
===


Again, I don't see how that could affect the code...just a shot in the
dark.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


 

Cherie_Machler

@gelco.comTo: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>   
Sent by:  cc:

[EMAIL PROTECTED]Fax to:

omSubject: Problems with
CharArrayType after upgrade from 7.3.4 to  
  8.1.7.1

 

05/30/2001

01:40 PM

Please respond

to ORACLE-L

 

 






After upgrading from Enterprise Edition 7.3.4 to 8.1.7.1 on Sun Solaris
2.6, we are
having problems executing a procedure with CharArrayType as shown below.
We don't get any error message.  The package simply does not return any
rows
when there are rows out there that should be returned.

The developer is trying to turn on some debug but I thought I would also
ask if anyone sees anything that is a no-no now under 8.1.7.1.   Is there
something
that I need to do in order to migrate this code that wasn't done
automatically?

CREATE OR REPLACE PACKAGE CCFILECD AS

TYPE NumArrayType IS TABLE OF NUMBER
 INDEX BY BINARY_INTEGER;

TYPE CharArrayType IS TABLE OF VARCHAR(31)
 INDEX BY BINARY_INTEGER;

PROCEDURE GETFILECODES(file_code   OUT CharArrayType,
   file_prefixOUT CharArrayType,
   start_pos  OUT NumArrayType,
   length OUT NumArrayType,
   num_lines_to_skip OUT NumArrayType,
   record_length  OUT NumArrayType,
   cntry_cd_proc  OUT NumArrayType,
   curr_cd_proc   OUT NumArrayType,
   count  OUT NUMBER);

END CCFILECD;

Thanks for any advice you can give,

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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




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

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

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

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

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

RE: Is DBMS_OBFUSCATION free in Enterprise Edition?


It is free - very definite answer :-)

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 2:02 PM
To: Multiple recipients of list ORACLE-L



We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6.

My manager needs a definitive answer.   Is DBMS_OBFUSCATION
free with this version of Enterprise Edition server or is it part of an
extra-cost add-on.

All definitive answers welcome. I have a call in to Oracle but they
have not yet responded.  My manager wants to know today.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Build an exact copy of a database using export / import

2001-05-30 Thread Bowes, Chris

Title: RE: Build an exact copy of a database using export / import





A full export is supposed to allow for a full recovery.  Thus, if you do a full export, the import will try to create all the tablespaces that existed when you exported.  That is the first item in the export file (see below).  However, if you create the tablespaces you want and don't allow (via file naming convention) the ones you don't want created, you can get the import to just create the tablespaces you want created.   For example, the first tablespace in the excerpt below is the TEMPORARY tablespace.  If I did this on a server where /salxha2/u01/oradata/swims  did not exist, then the create will fail and as long as ignore=y is set, the import will continue.   When import sees that a tablespace doesn't exist for a table it is supposed to create and import, it will use the default tablespace of the importer it is connected as (usually the owner of the object).  

Other options include logging into svrmgrl or sqlplus as sys and dropping the tablespaces that you don't want as they are created by the import or editting the export file.  I know some people have successfully editted an export file, however, I haven't been able too.  I always get an invalid marker message or something like that.


As far as some grants not coming across, items created by sys will not be exported as they are expected to be there before the import (via the dictionary scripts).  So if you have sys granting directly to a user (say granting select on v$_lock), then you'll need to do a script that runs as the import is running to fix those problems.  If it isn't grants from sys failing, then make sure the user that granted the options still has the power to grant (ie the "WITH GRANT OPTION" and/or "WITH ADMIN OPTION" authorities in place) when you do the export.  Otherwise the create/alter user that import does will not grant the powers to that user that it used when it made the grants and when it comes time for that user to grant permissions, it may fail due to "insufficient privs".  


Hope this helps...



^C^AEXPORT:V07.03.04
DSYS
RENTIRE
1024
0
   Mon May 28 14:28:
32 2001
BEGINSYS
CONNECT SYSTEM
CREATE TABLESPACE "TEMPORARY" DATAFILE  '/salxha2/u01/oradata/swims/temporary_01
.dbf' SIZE 356515840 REUSE DEFAULT STORAGE (INITIAL 2097152 NEXT 2097152 MINEXTE
NTS 1 MAXEXTENTS 121 PCTINCREASE 0) ONLINE TEMPORARY
CREATE TABLESPACE "MASTER" DATAFILE  '/salxha2/u03/oradata/swims/master_tab_03.d
bf' SIZE 52428800 REUSE, '/salxha2/u03/oradata/swims/master_tab_02.dbf' SIZE 524
28800 REUSE, '/salxha2/u03/oradata/swims/master_tab_01.dbf' SIZE 83886080 REUSE,
 '/salxha2/u03/oradata/swims/master_04.dbf' SIZE 262144000 REUSE DEFAULT STORAGE
 (INITIAL 10240 NEXT 409600 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0) ONLINE PE
RMANENT
CREATE TABLESPACE "WAYBILL" DATAFILE  '/salxha2/u03/oradata/swims/waybill_tab_02
.dbf' SIZE 524288000 REUSE, '/salxha2/u03/oradata/swims/waybill_tab_01.dbf' SIZE
 419430400 REUSE DEFAULT STORAGE (INITIAL 1048576 NEXT 1048576 MINEXTENTS 2 MAXE
XTENTS 11 PCTINCREASE 0) ONLINE PERMANENT
...
CREATE USER "xx" IDENTIFIED BY VALUES 'x' DEFAULT TABLESPACE
 "USERS" TEMPORARY TABLESPACE "TEMPORARY"


.
GRANT "MONITORER" TO "xx" WITH ADMIN OPTION
GRANT "DBA" TO "xx"


---


--Chris
[EMAIL PROTECTED]



-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Build an exact copy of a database using export / import



Well, depending on the size of the db and some other network stuff, I do the
following.  I shut down the real db, copy all of the data files,
controlfiles and init file to a machine with Oracle on it.  Then you can
create the service (NT), alter any of the datafiles if necessary (on
different logical drive) then you can just bring that bad boy up.  Then I
just give it a different alias, works for me.
    However, what do you mean it creates new tablespaces, I have never seen
that happen, it just fails miserably for me if the tablespaces don't exist.
You could do the full export, create a new user on the new machine and grant
"become  any user" to the new user.  I believe that then the import would
work, I've done it before.  Sorry I don't have more, brain is still a littel
soft from the weekend.
Kev


-Original Message-
L.
Sent: Wednesday, May 30, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L



When I build a new test database I create the database and run all the
required Oracle scripts.  Then I do a full import of a production export.
This works pretty well but I miss some of the grants and The full import
wants to create tablespaces that I may or may not want created.  I get a lot
of e

RE: Analyze table and locking

2001-05-30 Thread PD Miller

At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote:
>In earlier versions (7.3 ?) 'analyze ..compute' used to take table 
>level locks. From 8 onwards, compute or estimate does not take any 
>table level or row level locks at all...

Sorry, not true. From at least 7.2.3 (the oldest I have here) there 
was no table-level locking for any analyze statement.

As for the preferment for estimate, Oracle has the last laugh - if 
you estimate on a percentage greater than 50% or specify rows greater 
than half the number of rows in the table, Oracle analyzes the entire 
table.

Regards

Paul Miller
-- 
-
Carib Data Limited

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Archiving not possible with SQL Server?

2001-05-30 Thread Boivin, Patrice J


Correct.

SQL Server can have multiple transaction logs (I discovered this last week
while reading so I am correcting a previous post of mine here), but these
inevitably fill up.  You then either do a backup log filename to device
truncate only to clear the log.  This is the equivalent of running in
noarchivelog mode and using cold backups only.

If you want to keep backups of the transactions, you have to set up jobs to
back up the transaction log files regularly.  After the backup is done, SQL
Server can remove transactions that were backed up from the log(s), clearing
up some space inside the file.

In Oracle, the ARCH process reads the redo logs and stores copies of the
contents into archived log files.  You don't have to worry about the redo
log files filling up, but the archlog_dest directory can fill up.

You can set the SQL Server transaction log to autoextend, until the disk
fills up... which is kind of like running out of space in archive log dest.
Sort of.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Gary Weber [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Subject:OT: Archiving not possible with SQL Server?

Halo,

Windoz 2000/SQL Server 2000

Bringing an axuliary MS SQL db online. Trying to setup "archiving".
Am I
reading documentation right, SQL does NOT automatically archive
transaction
log? This process must be setup via backup routine, which truncates
the log
upon completion?

Lemme try some logic:

Oracle's redo logs = MS transaction log(s)
Oracle's archived logs = ?


Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

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

RE: Is DBMS_OBFUSCATION free in Enterprise Edition?

2001-05-30 Thread Haskins, Ed


Free...unless you look at the TCO (Total Cost of Ownership).

;-)

Ed Haskins
Oracle DBA
Verizon Wireless

-Original Message-
Sent: Wednesday, May 30, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L


It is free - very definite answer :-)

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 2:02 PM
To: Multiple recipients of list ORACLE-L



We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6.

My manager needs a definitive answer.   Is DBMS_OBFUSCATION
free with this version of Enterprise Edition server or is it part of an
extra-cost add-on.

All definitive answers welcome. I have a call in to Oracle but they
have not yet responded.  My manager wants to know today.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Haskins, Ed
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT: Effective Living

as a descendant of (english) indentured servants, i say let those 
freaking idiots burn in hell until the end of time.

until you understand the concept of "social death" (Dr. Orlando 
Patterson, Harvard) that underlies the institution of slavery, you 
can't understand the significance, and limits, of the role of 
"freedom" in western culture:

---

http://www.booknotes.org/transcripts/50140.htm

...
PATTERSON: Oh, I'm talking about Western Europe,
 primarily -- what we mean by it today. The central area, of
 course, in the Middle Ages and before would have been
 what's now France -- mainly France and Spain, Italy and
 Greece, until it was conquered, of course, by the Turks. But --
 so that region -- England, Western Europe and later, of
 course, it includes the extensions of Western Europe. There's
 one other important aspect of the story which -- to complete
 the sort of picture, so to speak, and it's something that
 happened in the midst of this large-scale slave society of
 Rome, which was very important for our story. And you know
 what that is? It was in this hothouse of slavery and freedom
 that Christianity really emerged as a world religion. And
 that's another surprising aspect of the work for many people,
 because in trying to answer the question, why did it become
 so -- why did it capture the mind and imagination of the West,
 the heart and soul of the West, one has to understand the
 nature of Christianity and how it originated. That it originated
 in this large-scale slave society of Rome and that the really
 important early Christians were freedmen, these same people
 who cherished so much this ideal of freedom. 

 And what did Christianity do? In a way, it used the
 experience of slavery and freedom as a metaphor for
 expressing its most important religious ideal, namely
 freedom, spiritual freedom, which we call redemption. Well,
 you know what the word redemption means. I mean, in Latin
 -- from the Latin, it literally means to buy someone out of
 slavery, literally. And in Pauline theology, what you had was
 a simple interjection of the outward experience of freedom.
 He uses a powerful metaphor to explain sin as a form of
 spiritual slavery and salvation as a form of spiritual
 redemption. That is buying someone out of slavery. So really,
 Christianity became the only religion, the only great religion
 -- in this sense it differs from Judaism, Islam, from all other
 great religions -- the only religion which had at the center
 creed the idea of being free -- that's spiritually now. And it is
 true. 

...

---

http://www.depaul.edu/~religion/bhispw99.htm
-
http://citd.scar.utoronto.ca/CLAB41/CLAB41.html
-
http://www.wholeearthmag.com/ArticleBin/278.html

regards,
ep

On 30 May 2001, at 10:37, [EMAIL PROTECTED] wrote:

> 
> Isn't that sort of like Taoism?  Accept your lot, there must be good in it
> somewhere...
> 
> Also, it seems to be the basis of many major religions to essentially never
> ask why.  So, I guess it's a pretty popular philosophy.
> 
> (Oh no, I feel a discourse by Eric coming on...)
> 
> Diana Duncan
> TITAN Technology Partners
> One Copley Parkway, Ste 540
> Morrisville, NC  27560
> VM: 919.466.7337 x 316
> F: 919.466.7427
> E: [EMAIL PROTECTED]

...

-- 
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: OT: RE: Fire your DBA's you don't need them anymore...

2001-05-30 Thread Tim Sawmiller


Thanks...after checking this site, I find out that I'm paid LOTS more than most of 
those bozos out there...   8-)

>>> [EMAIL PROTECTED] 05/30/01 01:16PM >>>
Yeah, I think they've got a retention problem, since the money is
better outside, and consultants have a good idea of what they're
being billed for. But the internal resources are great, as are
their internal email lists.

Of course, now we've got much of their internal stuff on metalink -
if you can get access - and the odtug lists and oracle-l are right
up there too.

All in all, I liked working there very very much, and if they'd been
able to keep up with what the market was offering I never would have
left. And for those of us looking now, we know where the market is
going, and Oracle's salaries are getting more in line with everyone
else's anyway.

(Boy, am I rambling or what? I've got a migraine, the fiorinal didn't
do it's usual magic, and I really ought to go home.)




> -Original Message-
> From: Hillman, Alex [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, May 25, 2001 6:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT: RE: Fire your DBA's you don't need them anymore...
> 
> 
> Oracle charges for such guys 250-350 an hour and pay them 50-90K/year
> (15-20% bonus and 4 weeks of training per year). I would say 
> that Oracle DBA
> knowing what he or she is doing can make more money  in consulting. 
> 
> Alex Hillman
> 
> PS. It would be very useful  if US participants of this list 
> post their
> rates or salaries on www.realrates.com - it is fully 
> anonimous. Also there
> is very interesting contractors BBS
> 
> -Original Message-
> Sent: Friday, May 25, 2001 4:36 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Yosi,
> 
> I interviewed for one of those jobs here in Boston, MA.  
> Although there
> was
> one VERY good individual in the bunch I was a little perplexed by the
> others. 
> Most were very junior and had not been in an outside shop 
> before, one was
> straight out of school and bootcamp and only one had done a 
> real recovery.
> It
> also hit me as strange that other than the smart guy, none of 
> them had ever
> created a database from scratch.  Thankfully I did not take the job.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Gene Sais" <[EMAIL PROTECTED]>
> Date:   5/25/2001 11:52 AM
> 
> From experience, I have used consultants from Oracle.  The 
> 1st one sent was
> right out of DBA school.  We sent him back after 1 week.  At 
> that time,
> Oracle
> didn't allow you to interview their DBA's.  According to 
> Oracle, they were
> all
> good.  The 2nd DBA Oracle sent had only NT experience, never 
> been on a Unix
> machine.  Ok, sent him back too.  By this time, we were about 
> to give up,
> then
> Oracle sent DBA #3 and she was sharp.  The moral of the 
> story, Oracle will
> send
> the juniors 1st b/c they save the good ones for the 3rd strike :)
> 
> 
> >>> [EMAIL PROTECTED] 05/25/01 03:01PM >>>
> I was once one of those superior i-dba consultants. I was pretty good,
> and as with this list, some of my colleagues were amazingly talented,
> knowledgable and great to work with. Others were, well, others.
> 
> It's lots of fun to ridicule, disparage, deride, belittle, and mock
> Oracle Consulting, and don't even get me started about Oracle Support,
> and I do this all the time too, I just want to put in a good word
> for SOME of my old friends.
> 
> Have a great weekend.
> 
> Yosi
> 
> 
> > -Original Message-
> > From: PD Miller [mailto:[EMAIL PROTECTED]] 
> > Sent: Friday, May 25, 2001 1:58 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Fire your DBA's you don't need them anymore...
> > 
> > 
> > I've just spent most of today repairing damage left at a 
> site by some 
> > of Oracle's 'superior' consultants!
> > 
> > At 8:27 -0800 25/5/01, Gary Weber wrote:
> > >Far as their "superior" i-dba team, I sure hope those are 
> different 
> > >people from the ones you get on first line of Support...
> > 
> > Cheers
> > 
> > Paul Miller
> > -- 
> > -
> > Banned and proud of it!
> > 
> > Carib Data Limited
> > 
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> > -- 
> > Author: PD Miller
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / 
> Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (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

RE: Performance tuning


Yes, Agreed.

Raid of any level will not change the number of writes in terms of DBWR.
But will change how many physical reads and writes needed to implement
parity and data to the disks.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L


No to be overly pedantic, but RAID5 does not change the number of write()
calls made by DBWR.  It will change the number of disk operations done by
your hardware controller or your software raid drivers, but that's slightly
different.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:02 PM


> Raid 5 can consume as much as 60% overhead for writes.
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
>
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
> believe. RAID 5 will require additional writes by DBWR which is going to
be
> huge overhead during a dataload.
>
> - Ethan Post
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [EMAIL PROTECTED] eg
> [EMAIL PROTECTED] Emails using the old format will continue to be
delivered
> until 30th June 2001.
>
> Peter McLarty wrote
> "Are you running RAID and if so what configuration. (Not RAID 5 I hope)"
>
> Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
> performance for Oracle RDBMS on NT
>
> RAID 5 is useful for Oracle datafiles but not for redo log files or
rollback
> segments which are sequentially accessed. Datafiles belonging to the
> temporary tablespace are not suitable for a RAID 5 device. More benefits
> will be seen in situations where reads predominate over writes.
>
> I know that in this instance it is a data load that is being discussed but
> presumably once the data is loaded then it will be read more than once.
>
> Certainly the tone of the note suggests that raid 5 is not a definite
no-no
> rather a 'be cautious as to which files are placed where'. It is my belief
> that often a single raid level is set for all files rather than a mix of
> raid 1 and raid 5 as appropriate.
>
> Peter, I fully agree that the level of memory utilised here is totally
> insufficient and is very likely to be the constraining factor in this
case.
>
> John
>
>
> --
--
> --
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you have received this message in error, please
> inform us promptly by reply e-mail, then delete the e-mail and destroy any
> printed copy.   Thank you.
>
>

> ==
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Christopher Spence
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: George Schlossnagle
  INET: [EMAIL PROTECTED]

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

RE: OEM Book Recommendation


Technet if i remember has some good things on OEM.  I generally never use
it.  Although it does have some nice features.  But I remember seeing some
good docs on it.  

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L


DBAs,

As a keyboard lover, hate to do this. But I need to study OEM.
Any good Books / URLs / DOCs / PDFs

Thanks in advance,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Build an exact copy of a database using export / import

2001-05-30 Thread Ray Stell


On Wed, May 30, 2001 at 08:25:44AM -0800, Smith, Ron L. wrote:
> When I build a new test database I create the database and run all the
> required Oracle scripts.  Then I do a full import of a production export.
> This works pretty well but I miss some of the grants and The full import
> wants to create tablespaces that I may or may not want created.  I get a lot
> of errors on system objects.  Does anyone have the proper steps to create an
> exact copy of a production database using export / import?


Not what you asked, but I do this all the time with a warm backup.
Really easy, no downtime, and nothing missing. 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

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

Connection auditing


I am interested to find info about connections with wrong userid/password -
which userid/password were used and other tns errors. For example if
tnsnames group use wrong sid - it will be recorded in listener.log. I did
not try tracing - maybe somebody did it alredy.

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

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

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

Fwd: RE: Would you increase the shared pool? --URGENT

2001-05-30 Thread Pablo ksksksk


Hi Christopher, thanks for answering

>1.  I would check to see if the buffer busy waits are
>on the same
>file/block.  Perhaps the same object is being hit
>constantly.  I would also
>base my action on the type of block being waited on.

I'm doing exactly this, mostly of my waits are data
block waits and p3=0, so there's no much I can do,
anyway I'll try increasing buffer cache size.


>2.  Tuning the redo generation would be a good thing,
>specially one of that
>size.  I would recommend two raid 0 arrays of 3-6
>disks each with quick io /
>raw devices.  3gb is fine, I have never had to work
>with a monstrocity of
>that, but I have heard 2gb+ redo logs a few times. 
>That is a constant
>800Kb/s second sustained.  

This is the first thing I'm trying to do.

>3.  What is the block size of this database?  
8KB Oracle 7.3.4

>4.  I think possibly problem is not further sizing
>the sp but avoiding
>fragmentation by pinning large procedures and
>packages at startup.  

I'll do that. Althought I'm pinning everything that
moves (with some Steve Adams scripts), I'll identify
"large procedures" to pin.

>5.  Do the statements use literals or bind
>variables.  Are objects being
>reloaded because of different syntax or because of
>invalidations and aging?

I really don't know if the application uses bind
variables (I think it does). I think that this high
parsing might be due to a lot of ad hoc queries. I'm
running a script right now to collect data from v$sql,
to see if these reloads are due to different syntax
for the same SQLs.
Is there another way to check this ?


TIA



> --- Pablo ksksksk <[EMAIL PROTECTED]> escribió: >
> Fecha: Tue, 29 May 2001 22:19:09 +0200 (CEST)
> > De: Pablo ksksksk <[EMAIL PROTECTED]>
> > Asunto: RE: Would you increase the shared pool? 
> > --URGENT
> > Para: Steve Adams <[EMAIL PROTECTED]>
> > CC: "ORACLE-L @ Fatcity" <[EMAIL PROTECTED]>
> > 
> > Hi Steve and List,
> > 
> > I'm still having some problem to understand this
> > data.
> > 
> > I've taken Steve Adams advise to reduce Shared
> Pool.
> > I
> > reduced it from 200MB to 180MB. And off course,
> this
> > reduction has impacted in SP latch hit ratio. It
> > sleeps rate has improved from 0.88% to 0.55%.
> > 
> > But I still have some opposed data.
> > 
> > Here I past my wait events:
> > 
> > EVENT   
> TIME_WAITED
> >
> 
> > enqueue 
> 1780156
> > buffer busy waits
> 511713
> > log buffer space 
> 103542
> > latch free
> 71181
> > write complete waits  
> 35970
> > free buffer waits  
> 5246
> > library cache pin  
> 4797
> > log file switch completion 
> 1678
> > library cache load lock 
> 392
> > row cache lock   
> 35
> > 
> > 
> > Shared Pool Info
> > 
> > RECURR TRANSIENT FLUSHED  PINS  ORA-4031 LAST
> ERROR
> > S.
> >
>
--
> >   6531   11538  260744   3555435 0  0
> > 
> > 
> >   BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE  
> > BIGGEST
> >
>
--
> > 0 1005282098   47   
> 72
> > 1  70904 759   93  
> 136
> > 2 2235761252  178  
> 224
> > 3384   1  384  
> 384
> > 4   6456  10  645  
> 808
> > 5 218000 151 1443 
> 2048
> > 6 185536  64 2899 
> 3968
> > 
> > 
> > As far as I can see, transient list is not bigger
> > than
> > tree times recurrent list (so SP is not too big)
> and
> > flushed chunks/pins and releases is more than 1/20
> > (0.07). This posible indicates that the shared
> Pool
> > is
> > too small.
> > 
> > Besides, "library cache load lock" event indicates
> > that a lot of SQLs (or other objects) are being
> > loaded
> > to the LC, this may also indicate that the SP is
> > small.
> > 
> > But on the other hand, We've got that list 0 (of
> the
> > shared pool) is probably too big and that would
> > indicate that the shared pool is too big.
> > 
> > what am I missing here?
> > 
> > I know I've got more serious trouble with enqueue
> > and
> > bbw events, I'm trying to resolve them. That's no
> > problem.
> > I'm also aware that "log file switch completion"
> > event
> > is causing a lot of trouble here and I'm trying to
> > get
> > some disks to place redo logs and make them
> bigger.
> > By the way, I'm going to create redo logs of 3GB
> > each
> > in order to get a switch every hour. Is 3GB some
> > reasonable size for redo?
> > 
> > 
> > TIA
> > 
> > 
> > 
> > 
> > 
> > --- Steve Adams <[EMAIL PROTECTED]>
> escribió:
> > >
> > Hi Pablo,

RE: Build an exact copy of a database using export / import

2001-05-30 Thread Glasrot, Nechama




Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd. 
Boca Raton, Florida 33487 
nglasrot @seisint.com   
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
 


-Original Message-
Sent: Wednesday, May 30, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L


We use "Clones" of databases all the time.   Its much faster than the
Export/import run.   We simply take the DB down, copy the data files to a
new server in the same file layouts (i.e. ... same directory tree), copy
over and change the init file for the new DB name, and bring it up.  Then
you have to alter the global name.  Its a relatively simple process.

If there are tablespaces that were in the original one that you do not want
over then, at this point, drop any associated objects and drop the
tablespaces.

-Original Message-
Sent: Wednesday, May 30, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L


Well, depending on the size of the db and some other network stuff, I do the
following.  I shut down the real db, copy all of the data files,
controlfiles and init file to a machine with Oracle on it.  Then you can
create the service (NT), alter any of the datafiles if necessary (on
different logical drive) then you can just bring that bad boy up.  Then I
just give it a different alias, works for me.
However, what do you mean it creates new tablespaces, I have never
seen
that happen, it just fails miserably for me if the tablespaces don't exist.
You could do the full export, create a new user on the new machine and grant
"become  any user" to the new user.  I believe that then the import would
work, I've done it before.  Sorry I don't have more, brain is still a littel
soft from the weekend.
Kev

-Original Message-
L.
Sent: Wednesday, May 30, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


When I build a new test database I create the database and run all the
required Oracle scripts.  Then I do a full import of a production export.
This works pretty well but I miss some of the grants and The full import
wants to create tablespaces that I may or may not want created.  I get a lot
of errors on system objects.  Does anyone have the proper steps to create an
exact copy of a production database using export / import?

Thanks!
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: 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 Lange
  INET: [EMAIL PROTECTED]

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

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


This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you


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

Fat City Network Services-- (858) 538-5

Update Query

2001-05-30 Thread CC Harvest


Seems like Oracle Doesn't have to the query like this:

update tablea set firstname=tableb.firstname,
lastname=tableb.lastname
where tableb.id = tablea.id;

I can have one, it works if it has a match for the two
tables, otherwise the two columns updated to null:

update tablea set (firstname,lastname)
=(select firstname,lastname from tableb
  where tableb.id=tablea.id);

Then the following one works, but very ugly:

update tablea set (firstname,lastname)
=(select firstname,lastname from tableb
  where tableb.id=tablea.id)
where exists(
select 'x' from tableb 
  where tableb.id=tablea.id)

Any suggestions?
TIA

Chris Harvest





__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  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: RE: RE:


Dam_...my tractor broke.

-Original Message-
Spence
Sent: Wednesday, May 30, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L


Actually I say:

"You know what the farmer said when the cow died?"

"Geesh, it never did that before."

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot



-Original Message-
Sent: Wednesday, May 30, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L


Reminds me of a bad joke...

What did the farmer say when his tractor broke?

-Original Message-
Sent: Wednesday, May 30, 2001 12:03 PM
To: Kevin Kostyszyn; [EMAIL PROTECTED]


Just because!

Reply Separator
Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
Date:   5/30/2001 11:42 AM

Oh my, but why?

-Original Message-
Sent: Wednesday, May 30, 2001 11:48 AM
To: Kevin Kostyszyn; Multiple recipients of list ORACLE-L


Ours is not to wonder why, ours is just to do or die!!

Reply Separator
Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
Date:   5/30/2001 7:02 AM

This person was actually allowed to teach.  Never ask why, yes that's a
super philosophy on life.

-Original Message-
Patrice J
Sent: Wednesday, May 30, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L


That's a laugh, I went to a continuing education seminar once at Carleton
University, in Ottawa.

The seminar was called Effective Living.

The teacher was a social worker, and he emphatically told everyone NEVER to
ask why, just adapt to life and keep moving...

I had unreconcilable disagreements with him, I guess I don't know how to
live.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Don Granaman [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, May 29, 2001 4:11 PM
To: Multiple recipients of list ORACLE-L
Subject:Re:

when?
But, more important, WHY???

-Don Granaman
[certifiable OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 1:28 PM


> And Where.
>
> Terry
>
> "Boivin, Patrice J" wrote:
>
> > When and how
> >
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > -Original Message-
> > From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, May 29, 2001 1:41 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE:
> >
> > what
> >
> > -Original Message-
> > Andrea
> > Sent: Tuesday, May 29, 2001 11:47 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > who
> > --
> > Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> > --
> > Author: Quaglio Andrea
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
(858)
538-5051
> > San Diego, California-- Public Internet access /
Mailing
> > Lists
>


> > To REMOVE yourself from this mailing list, send an
E-Mail
message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and
in
> > the message BODY, include a line containing: UNSUB
ORACLE-L
> > (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: Effective Living

2001-05-30 Thread Rodd Holman


LOL!! Now that sounds like fun.  Just immagine the frustrated users and 
damagers running around trying to deal with that answer!

Rodd Holman
>> Original Message <<

On 5/30/01, 2:12:06 PM, Kevin Kostyszyn <[EMAIL PROTECTED]> wrote regarding 
RE: Effective Living:


> Yeah, but just because something is popular doesn't meen it is good. If 
we
> all lived our lives that way everyday I am not so sure we would get much
> accomplished?

> Oh no, the Database is down!!
> Why?
> I don't know, who cares.
> hehehe

--
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: Performance tuning


You have to get up pretty early in
the morning to pull the wool over
your eyes, Mr. Hillman. 

:)

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 1:22 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Why putting DB in noarchivelog will avoid redo generation? 
|| There will be no
|| archiving, but redo will continue to be generated.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 10:21 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Azhar,
|| 
|| Just two thoughts off the top of my head to improve loading 
|| of records:
|| 1.  Put database in noarchivelog mode to avoid redo generation (if 
|| possible).
|| 2.  Drop all indexes on target tables (if possible), then 
|| load data, then 
|| recreate all indexes on target tables.
|| 
|| Jim
|| 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| > 
|| > HI ALL,
|| > We have to load almost 3 millions records of average row 
|| size of 150 
|| bytes.
|| > We are importing data using sqloader with ROWS=4000 and 
|| bindsize=845 .
|| > We have adjusted the rollback segment to almost  10 m with 
|| 8 extents 
|| enough
|| > for single transaction size and considering 30% rollback 
|| overhead. We
|| > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| > Rollback segment, databuffer cache have hit ratio of 100%.
|| > 
|| > The loading was fast only for first 10 commits but then it 
|| slowed like
|| > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| NT4 128 megs RAM
|| > .
|| > SGA figures in M :
|| > NAME VALUE
|| >  -
|| > Fixed Size.0676384
|| > Variable Size239.02734
|| > Database Buffers   39.0625
|| > Redo Buffers 7.8203125
|| >  -
|| > sum  285.97779
|| > ( we can't use direct path due to functions in sqlldr 
|| controlfile). .
|| > Couldn't figure out the bottleneck yet.
|| > Any ideas.
|| > TIA
|| > Azhar Siddiq,
|| > DBA
|| > LMK Resources
|| > 
|| > -- 
|| > 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).
|| > 
|| > 
|| 
|| 
|| -- 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jim Hawkins
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Hillman, Alex
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

T

RE: Performance tuning


Translation please.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 3:32 PM
To: Multiple recipients of list ORACLE-L


You have to get up pretty early in
the morning to pull the wool over
your eyes, Mr. Hillman. 

:)

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 1:22 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Why putting DB in noarchivelog will avoid redo generation? 
|| There will be no
|| archiving, but redo will continue to be generated.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 10:21 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Azhar,
|| 
|| Just two thoughts off the top of my head to improve loading 
|| of records:
|| 1.  Put database in noarchivelog mode to avoid redo generation (if 
|| possible).
|| 2.  Drop all indexes on target tables (if possible), then 
|| load data, then 
|| recreate all indexes on target tables.
|| 
|| Jim
|| 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| > 
|| > HI ALL,
|| > We have to load almost 3 millions records of average row 
|| size of 150 
|| bytes.
|| > We are importing data using sqloader with ROWS=4000 and 
|| bindsize=845 .
|| > We have adjusted the rollback segment to almost  10 m with 
|| 8 extents 
|| enough
|| > for single transaction size and considering 30% rollback 
|| overhead. We
|| > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| > Rollback segment, databuffer cache have hit ratio of 100%.
|| > 
|| > The loading was fast only for first 10 commits but then it 
|| slowed like
|| > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| NT4 128 megs RAM
|| > .
|| > SGA figures in M :
|| > NAME VALUE
|| >  -
|| > Fixed Size.0676384
|| > Variable Size239.02734
|| > Database Buffers   39.0625
|| > Redo Buffers 7.8203125
|| >  -
|| > sum  285.97779
|| > ( we can't use direct path due to functions in sqlldr 
|| controlfile). .
|| > Couldn't figure out the bottleneck yet.
|| > Any ideas.
|| > TIA
|| > Azhar Siddiq,
|| > DBA
|| > LMK Resources
|| > 
|| > -- 
|| > 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).
|| > 
|| > 
|| 
|| 
|| -- 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jim Hawkins
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Hillman, Alex
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-505

RE: backspace in Oracle.

Netware 3.12 (or 3.2, which is basically 3.12 with Y2K patches) is 
amazingly robust/stable. We still have one running a ("unsupported") 
legacy Oracle 7.3 app with 66mhz 486/DOS clients w/ 8Mb RAM!!! 
(SQL*Net v2 lite). 

Only reason for "downtime" is running VREPAIR (rough equivalent of 
"scandisk") about once every other month, and also when the startup 
files need maintenance (usually related to changed parameters on 
.nlms loaded, versoin upgrades, etc) and a bounce is required. also 
we recently had to put in a new UPS battery, which required a down.

It is amazing how good (well engineered) "no frills" software can be. 
unfortunately the ".NLM" ended up being sort of the "Pinto" of the 
NOS industry. the fall of Novell is one of the great sad stories of 
the industry. corruption of marketing mentality.

--

On 30 May 2001, at 6:56, Mohan, Ross wrote:

Date sent:  Wed, 30 May 2001 06:56:48 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> Six years? No downtime in any way? That would be...uh.unusual. 
> 
> I am sure the details are fascinating...do tell.
> 
> || -Original Message-
> || From: Christopher Spence [mailto:[EMAIL PROTECTED]]
> || Sent: Wednesday, May 30, 2001 9:01 AM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: backspace in Oracle.
> || 
> || 
> || I have built Novell boxes that have 2100+ days of uptime :)
> || 
> || Now that is stability that I have yet to see even unix have.
> || Granted it is only Novell 3.12.

...

-- 
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: Effective Living

2001-05-30 Thread DENISE


What did the Buddhist say to the hotdog vendor?

Make me one with everything.

(Sorry that was from "Motherless Brooklyn" which I just finished reading.)

Denise Gwinn
[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: Build an exact copy of a database using export / import

2001-05-30 Thread Smith, Ron L.


Thanks!
Ron

-Original Message-
Sent: Wednesday, May 30, 2001 3:08 PM
To: Multiple recipients of list ORACLE-L



A full export is supposed to allow for a full recovery.  Thus, if you do a
full export, the import will try to create all the tablespaces that existed
when you exported.  That is the first item in the export file (see below).
However, if you create the tablespaces you want and don't allow (via file
naming convention) the ones you don't want created, you can get the import
to just create the tablespaces you want created.   For example, the first
tablespace in the excerpt below is the TEMPORARY tablespace.  If I did this
on a server where /salxha2/u01/oradata/swims  did not exist, then the create
will fail and as long as ignore=y is set, the import will continue.   When
import sees that a tablespace doesn't exist for a table it is supposed to
create and import, it will use the default tablespace of the importer it is
connected as (usually the owner of the object).  

Other options include logging into svrmgrl or sqlplus as sys and dropping
the tablespaces that you don't want as they are created by the import or
editting the export file.  I know some people have successfully editted an
export file, however, I haven't been able too.  I always get an invalid
marker message or something like that.


As far as some grants not coming across, items created by sys will not be
exported as they are expected to be there before the import (via the
dictionary scripts).  So if you have sys granting directly to a user (say
granting select on v$_lock), then you'll need to do a script that runs as
the import is running to fix those problems.  If it isn't grants from sys
failing, then make sure the user that granted the options still has the
power to grant (ie the "WITH GRANT OPTION" and/or "WITH ADMIN OPTION"
authorities in place) when you do the export.  Otherwise the create/alter
user that import does will not grant the powers to that user that it used
when it made the grants and when it comes time for that user to grant
permissions, it may fail due to "insufficient privs".  


Hope this helps... 


 
^C^AEXPORT:V07.03.04 
DSYS 
RENTIRE 
1024 
0 
   Mon May 28
14:28: 
32 2001 
BEGINSYS 
CONNECT SYSTEM 
CREATE TABLESPACE "TEMPORARY" DATAFILE
'/salxha2/u01/oradata/swims/temporary_01 
.dbf' SIZE 356515840 REUSE DEFAULT STORAGE (INITIAL 2097152 NEXT 2097152
MINEXTE 
NTS 1 MAXEXTENTS 121 PCTINCREASE 0) ONLINE TEMPORARY 
CREATE TABLESPACE "MASTER" DATAFILE
'/salxha2/u03/oradata/swims/master_tab_03.d 
bf' SIZE 52428800 REUSE, '/salxha2/u03/oradata/swims/master_tab_02.dbf' SIZE
524 
28800 REUSE, '/salxha2/u03/oradata/swims/master_tab_01.dbf' SIZE 83886080
REUSE, 
 '/salxha2/u03/oradata/swims/master_04.dbf' SIZE 262144000 REUSE DEFAULT
STORAGE 
 (INITIAL 10240 NEXT 409600 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)
ONLINE PE 
RMANENT 
CREATE TABLESPACE "WAYBILL" DATAFILE
'/salxha2/u03/oradata/swims/waybill_tab_02 
.dbf' SIZE 524288000 REUSE, '/salxha2/u03/oradata/swims/waybill_tab_01.dbf'
SIZE 
 419430400 REUSE DEFAULT STORAGE (INITIAL 1048576 NEXT 1048576 MINEXTENTS 2
MAXE 
XTENTS 11 PCTINCREASE 0) ONLINE PERMANENT 
... 
CREATE USER "xx" IDENTIFIED BY VALUES 'x' DEFAULT TABLESPACE

 "USERS" TEMPORARY TABLESPACE "TEMPORARY" 

. 
GRANT "MONITORER" TO "xx" WITH ADMIN OPTION 
GRANT "DBA" TO "xx" 

--- 

--Chris 
[EMAIL PROTECTED] 


-Original Message- 
] 
Sent: Wednesday, May 30, 2001 12:57 PM 
To: Multiple recipients of list ORACLE-L 


Well, depending on the size of the db and some other network stuff, I do the

following.  I shut down the real db, copy all of the data files, 
controlfiles and init file to a machine with Oracle on it.  Then you can 
create the service (NT), alter any of the datafiles if necessary (on 
different logical drive) then you can just bring that bad boy up.  Then I 
just give it a different alias, works for me. 
However, what do you mean it creates new tablespaces, I have never
seen 
that happen, it just fails miserably for me if the tablespaces don't exist. 
You could do the full export, create a new user on the new machine and grant

"become  any user" to the new user.  I believe that then the import would 
work, I've done it before.  Sorry I don't have more, brain is still a littel

soft from the weekend. 
Kev 

-Original Message- 
L. 
Sent: Wednesday, May 30, 2001 12:26 PM 
To: Multiple recipients of list ORACLE-L 


When I build a new test database I create the database and run all the 
required Oracle scripts.  Then I do a full import of a production export. 
This works pretty well but I miss some of the grants and The full import 
wants to create tablespaces that I may or may not want created.  I get a lot

of errors on system ob

RE: OEM Book Recommendation

2001-05-30 Thread Prasada . Gunda1




Technical libraries section under metalink has white papers, manuals etc on
OEM packs.

hth,
Prasad






Christopher Spence <[EMAIL PROTECTED]>@fatcity.com on 05/30/2001
04:21:20 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



Technet if i remember has some good things on OEM.  I generally never use
it.  Although it does have some nice features.  But I remember seeing some
good docs on it.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot



-Original Message-
Sent: Wednesday, May 30, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L


DBAs,

As a keyboard lover, hate to do this. But I need to study OEM.
Any good Books / URLs / DOCs / PDFs

Thanks in advance,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Connection auditing

2001-05-30 Thread [EMAIL PROTECTED]

"Hillman, Alex" wrote:
> 
> I am interested to find info about connections with wrong userid/password -
> which userid/password were used and other tns errors. For example if
> tnsnames group use wrong sid - it will be recorded in listener.log. I did
> not try tracing - maybe somebody did it alredy.
> 
> Alex Hillman
> --

Alex,

   There is a possible solution, which would be using 'netcat' - a
hacker tool, but a useful one. You can probably (I have not tried it)
use it as a front-end to the listener and intercept everything sent to
the listener (I have once used it to see what was going on during
exchanges). The only snag is that you would also catch GOOD passwords
:-)

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Build an exact copy of a database using export / import

2001-05-30 Thread Bowes, Chris

Title: RE: Build an exact copy of a database using export / import



Let me 
rephrase that first sentence...  A full export is supposed to allow you to 
recreate your base entirely at the point of export.  A bit different from a 
"full recovery" which means all transactions to the point of failure 
recovered...  Sorry for the mistype.
 
--Chris [EMAIL PROTECTED] 
 

  -Original Message-From: Bowes, Chris 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 4:08 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Build an exact copy of a database using export / import
  A full export is supposed to allow for a full recovery.  
  Thus, if you do a full export, the import will try to create all the 
  tablespaces that existed when you exported.  That is the first item in 
  the export file (see below).  However, if you create the tablespaces you 
  want and don't allow (via file naming convention) the ones you don't want 
  created, you can get the import to just create the tablespaces you want 
  created.   For example, the first tablespace in the excerpt below is 
  the TEMPORARY tablespace.  If I did this on a server where 
  /salxha2/u01/oradata/swims  did not exist, then the create will fail and 
  as long as ignore=y is set, the import will continue.   When import 
  sees that a tablespace doesn't exist for a table it is supposed to create and 
  import, it will use the default tablespace of the importer it is connected as 
  (usually the owner of the object).  
  Other options include logging into svrmgrl or sqlplus as sys 
  and dropping the tablespaces that you don't want as they are created by the 
  import or editting the export file.  I know some people have successfully 
  editted an export file, however, I haven't been able too.  I always get 
  an invalid marker message or something like that.
  As far as some grants not coming across, items created by sys 
  will not be exported as they are expected to be there before the import (via 
  the dictionary scripts).  So if you have sys granting directly to a user 
  (say granting select on v$_lock), then you'll need to do a script that runs as 
  the import is running to fix those problems.  If it isn't grants from sys 
  failing, then make sure the user that granted the options still has the power 
  to grant (ie the "WITH GRANT OPTION" and/or "WITH ADMIN OPTION" authorities in 
  place) when you do the export.  Otherwise the create/alter user that 
  import does will not grant the powers to that user that it used when it made 
  the grants and when it comes time for that user to grant permissions, it may 
  fail due to "insufficient privs".  
  Hope this helps... 
   
  ^C^AEXPORT:V07.03.04 DSYS 
  RENTIRE 1024 0    
  Mon May 28 14:28: 32 2001 BEGINSYS CONNECT SYSTEM CREATE TABLESPACE "TEMPORARY" DATAFILE  
  '/salxha2/u01/oradata/swims/temporary_01 .dbf' SIZE 
  356515840 REUSE DEFAULT STORAGE (INITIAL 2097152 NEXT 2097152 MINEXTE 
  NTS 1 MAXEXTENTS 121 PCTINCREASE 0) ONLINE TEMPORARY 
  CREATE TABLESPACE "MASTER" DATAFILE  
  '/salxha2/u03/oradata/swims/master_tab_03.d bf' SIZE 
  52428800 REUSE, '/salxha2/u03/oradata/swims/master_tab_02.dbf' SIZE 524 
  28800 REUSE, '/salxha2/u03/oradata/swims/master_tab_01.dbf' 
  SIZE 83886080 REUSE,  '/salxha2/u03/oradata/swims/master_04.dbf' SIZE 262144000 REUSE 
  DEFAULT STORAGE  (INITIAL 10240 NEXT 409600 
  MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0) ONLINE PE RMANENT CREATE TABLESPACE "WAYBILL" 
  DATAFILE  '/salxha2/u03/oradata/swims/waybill_tab_02 .dbf' SIZE 524288000 REUSE, 
  '/salxha2/u03/oradata/swims/waybill_tab_01.dbf' SIZE  419430400 REUSE DEFAULT STORAGE (INITIAL 1048576 NEXT 1048576 
  MINEXTENTS 2 MAXE XTENTS 11 PCTINCREASE 0) ONLINE 
  PERMANENT ... CREATE USER "xx" 
  IDENTIFIED BY VALUES 'x' DEFAULT TABLESPACE  "USERS" TEMPORARY TABLESPACE "TEMPORARY" 
  . GRANT "MONITORER" TO "xx" WITH 
  ADMIN OPTION GRANT "DBA" TO "xx" 
  --- 
  
  --Chris [EMAIL PROTECTED] 
  
  -Original Message- From: Kevin 
  Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 12:57 PM To: 
  Multiple recipients of list ORACLE-L Subject: RE: 
  Build an exact copy of a database using export / import 
  Well, depending on the size of the db and some other network 
  stuff, I do the following.  I shut down the real 
  db, copy all of the data files, controlfiles and init 
  file to a machine with Oracle on it.  Then you can create the service (NT), alter any of the datafiles if necessary 
  (on different logical drive) then you can just bring 
  that bad boy up.  Then I just give it a different 
  alias, works for me.     
  However, what do you mean it creates new tablespaces, I have 
  never seen that happen, it just fails miserably f

RE: Analyze table and locking

Oracle actually claims this statement. There are numerous docs stating this,
for example DOC ID: 213220.999.  But I agree 100% with Jeremiah's claims, in
fact it can be verified very easily looking at v$lock while analyzing a
large table.  (I have actually done this in the past and present) and there
are no locks under my current sid or any additional locks under any sid
during analyze.

Take any table that takes more than 3-4 seconds to analyze and in another
window query V$LOCKS and you can see this first hand.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 

-Original Message-
Sent: Wednesday, May 30, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L

I have used compute statistics since version 7.3.2 up through 8.1.6, and
never
had it hold a table lock for the duration of the analyze.  I don't know
where
people are getting the idea that compute statistics holds a lock and
estimate
doesn't.  That just doesn't make sense.  Why would compute need a lock?  Are
you saying I can estimate sample 99 percent, and get what amounts to a
compute
and avoid the supposed lock?  Does that make any sense?  No.

Validate structure cascade holds a lock.  The most the others do is grab
some
resource [very] briefly at the end to update the dictionary.  People
claiming
that compute holds a lock, please post documentation to support that
statement.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 30 May 2001, Raghu Kota wrote:

> Yeah If you use compute statistics your table get locked and will take
long
> time, But If you use  estimate statistics it will be fast But not as
> accurate as before. Better to analyze at nights by setting time.
>
> >From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
> >
> >Anyone know if there are any locking issues while analyzing statistics
for
> >objects ??

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT ("communities of practice") listserv - forum facilitation FAQ

2001-05-30 Thread Jared Still



Oh sure, after I spent 30 minutes looking for it!

:)

Jared


On Wednesday 30 May 2001 11:11, Eric D. Pierce wrote:
> Bruce, Jared & folks,
>
> See below for the info I was looking for yesterday (I gave
> you the wrong site, sorry).
>
> regards,
> ep
>
> cc: [EMAIL PROTECTED]
>
>
> http://www.co-i-l.com/coil/knowledge-garden/vcfaq/facfaq1.shtml
>
> version 0.9
>FAQ Editor: George Pór
>
>  About this FAQ
>  When and why forums have to be facilitated?
>  What are the main roles and responsibilities in
>  facilitating forums?
>  System Administrator
>  Account Administrator
>  Forum Convener
>  Community Architect
>  Moderator
>  Content Facilitator
>  Cybrarian
>
>
>
>  About this FAQ
>
>  Most of the roles and responsibilities
>  described in this FAQ are part of a new kind
>  of work with no ready-made job-descriptions.
>
>  The responses are definitely not definitive;
>  they will change as our understanding of the
>  requirements for effectively facilitating virtual
>  communities will deepen through the feedback
>  from, and collaboration with facilitators
>  reading and contributing to this FAQ.
>
>  When and why forums have to be facilitated?
>
>  Facilitate = make easy, promote, help forward
>  action or result. (Oxford Dictionary)
>
>  Online facilitators or hosts are the primary
>  enablers of any virtual community. It is their
>  enthusiasm and attention to the participants
>  challenges in communicating and collaborating
>  in cyberspace, that can make or brake
>  fledgling online communities. Without their
>  efforts "it is difficult to build momentum,
>  maintain the flow and generate the activity that
>  will help to ensure return visits."
>(Denham Grey)
>
>  Developing competence in facilitating the
>  electronic meeting of minds that takes place in
>  forums is a must in companies that want to turn
>  the web tools and methods of coordination into
>  a strategic advantage to achieve breakthrough
>  results.
>
>  The number of required facilitative functions
>  is raising along the following continuum:
>
>   Communities of interest (hobby groups) -->
>   communities of practice (professional communities) -->
>   communities of commitment (teams, taskforces, work groups).
>
>  What are the main roles and
>  responsibilities in facilitating
>  forums?
>
>  Responsibilities outlined under the following roles
>  can be assumed by one or a few individuals in
>  small virtual communities.
>
>  In larger communities, they are divided among the
>  participants of the facilitation team.
>
>   System Administrator
>
>  Participates in the administration of the server
>  Contributes suggestions and implements
>  software-related measures for maximizing uptime
>  Maintains software integrity and forum security
>  Provides other participants of the facilitation
>  team and users with technical support
>
>   Account Administrator
>
>  Implements access privileges
>  Issues or confirms user names and passwords in
>  password-protected forums
>
>   Forum Convener
>
>  Forum Convener, sometimes also called
>  chairperson, is a function of someone who has a
>  major stake in the forums outcome(s), typically
>  performed in task-oriented virtual communities.
>
>   Community Architect
>
>  Optimizes the community's structure and design to
>  help it meet its purpose
>
>  Using the appropriate combination of groupware
>  features, designs virtual spaces to meet specific
>  community functions
>
>  Drafts guidelines for forum community norms
>  ("community covenant")
>
>  Writes and edits user agreements
>
>  Designs the structure of initial topics
>
>  Seeds topics with context-setting materials
>
>  Designs strategy and mechanisms for collecting and
>  incorporating feedback from participants
>
>   Moderator
>
>  The moderator, also called "host" or "organizer":
>
>  Participates in the preliminary planning of the
>  forum with the sysadmin, convener, and community
>  architect
>
>  Welcomes and acknowledges participants
>
>  Stimulates participation and sustains interest
>
>  Facilitates a healthy group dynamics conducive to
>  higher quality contributions and achieving
>  objectives in task-oriented forums
>
>  Keeps the conve

RE: Analyze table and locking

nice to see you posting again :)

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 

-Original Message-
Sent: Wednesday, May 30, 2001 4:03 PM
To: Multiple recipients of list ORACLE-L

At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote:
>In earlier versions (7.3 ?) 'analyze ..compute' used to take table 
>level locks. From 8 onwards, compute or estimate does not take any 
>table level or row level locks at all...

Sorry, not true. From at least 7.2.3 (the oldest I have here) there 
was no table-level locking for any analyze statement.

As for the preferment for estimate, Oracle has the last laugh - if 
you estimate on a percentage greater than 50% or specify rows greater 
than half the number of rows in the table, Oracle analyzes the entire 
table.

Regards

Paul Miller
-- 
-
Carib Data Limited

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT: RE: Fire your DBA's you don't need them anymore...


This is a problem that not many people put their data. I did not do it
myself for couple of years.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L


Thanks...after checking this site, I find out that I'm paid LOTS more than
most of those bozos out there...   8-)

>>> [EMAIL PROTECTED] 05/30/01 01:16PM >>>
Yeah, I think they've got a retention problem, since the money is
better outside, and consultants have a good idea of what they're
being billed for. But the internal resources are great, as are
their internal email lists.

Of course, now we've got much of their internal stuff on metalink -
if you can get access - and the odtug lists and oracle-l are right
up there too.

All in all, I liked working there very very much, and if they'd been
able to keep up with what the market was offering I never would have
left. And for those of us looking now, we know where the market is
going, and Oracle's salaries are getting more in line with everyone
else's anyway.

(Boy, am I rambling or what? I've got a migraine, the fiorinal didn't
do it's usual magic, and I really ought to go home.)




> -Original Message-
> From: Hillman, Alex [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, May 25, 2001 6:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT: RE: Fire your DBA's you don't need them anymore...
> 
> 
> Oracle charges for such guys 250-350 an hour and pay them 50-90K/year
> (15-20% bonus and 4 weeks of training per year). I would say 
> that Oracle DBA
> knowing what he or she is doing can make more money  in consulting. 
> 
> Alex Hillman
> 
> PS. It would be very useful  if US participants of this list 
> post their
> rates or salaries on www.realrates.com - it is fully 
> anonimous. Also there
> is very interesting contractors BBS
> 
> -Original Message-
> Sent: Friday, May 25, 2001 4:36 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Yosi,
> 
> I interviewed for one of those jobs here in Boston, MA.  
> Although there
> was
> one VERY good individual in the bunch I was a little perplexed by the
> others. 
> Most were very junior and had not been in an outside shop 
> before, one was
> straight out of school and bootcamp and only one had done a 
> real recovery.
> It
> also hit me as strange that other than the smart guy, none of 
> them had ever
> created a database from scratch.  Thankfully I did not take the job.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Gene Sais" <[EMAIL PROTECTED]>
> Date:   5/25/2001 11:52 AM
> 
> From experience, I have used consultants from Oracle.  The 
> 1st one sent was
> right out of DBA school.  We sent him back after 1 week.  At 
> that time,
> Oracle
> didn't allow you to interview their DBA's.  According to 
> Oracle, they were
> all
> good.  The 2nd DBA Oracle sent had only NT experience, never 
> been on a Unix
> machine.  Ok, sent him back too.  By this time, we were about 
> to give up,
> then
> Oracle sent DBA #3 and she was sharp.  The moral of the 
> story, Oracle will
> send
> the juniors 1st b/c they save the good ones for the 3rd strike :)
> 
> 
> >>> [EMAIL PROTECTED] 05/25/01 03:01PM >>>
> I was once one of those superior i-dba consultants. I was pretty good,
> and as with this list, some of my colleagues were amazingly talented,
> knowledgable and great to work with. Others were, well, others.
> 
> It's lots of fun to ridicule, disparage, deride, belittle, and mock
> Oracle Consulting, and don't even get me started about Oracle Support,
> and I do this all the time too, I just want to put in a good word
> for SOME of my old friends.
> 
> Have a great weekend.
> 
> Yosi
> 
> 
> > -Original Message-
> > From: PD Miller [mailto:[EMAIL PROTECTED]] 
> > Sent: Friday, May 25, 2001 1:58 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Fire your DBA's you don't need them anymore...
> > 
> > 
> > I've just spent most of today repairing damage left at a 
> site by some 
> > of Oracle's 'superior' consultants!
> > 
> > At 8:27 -0800 25/5/01, Gary Weber wrote:
> > >Far as their "superior" i-dba team, I sure hope those are 
> different 
> > >people from the ones you get on first line of Support...
> > 
> > Cheers
> > 
> > Paul Miller
> > -- 
> > -
> > Banned and proud of it!
> > 
> > Carib Data Limited
> > 
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> > -- 
> > Author: PD Miller
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / 
> Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line

RE: backspace in Oracle.


Oh come on Ross, it wasn't "running" solitaire for seven years, it would
have been brought to it's knees in a month if solitaire was open!

-Original Message-
Sent: Wednesday, May 30, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Kim,

Did you hear the one about the NT box
that ran for SEVEN YEARS, playing solitaire?

Yea, me neither, but it's a good story, just
like the Novell one.

:)


|| -Original Message-
|| From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 12:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
||
||
|| Ya, but I can keep a NT box for a long time to, if I don't touch it.
||
||
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 6:01 AM
|| To: Multiple recipients of list ORACLE-L
||
||
|| I have built Novell boxes that have 2100+ days of uptime :)
||
|| Now that is stability that I have yet to see even unix have.
|| Granted it is only Novell 3.12.
||
||
|| "Walking on water and developing software from a
|| specification are easy if
|| both are frozen."
||
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot
||
||
||
|| -Original Message-
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Sunday, May 27, 2001 8:10 PM
|| To: Multiple recipients of list ORACLE-L
||
||
|| Jared,
||
|| I have an NT 4 server up for 242 days.
||
|| Someone where I work suggested it should be sent to Microsoft for an
|| examination (must be something wrong with it).
||
|| Regards,
|| Bruce
||
|| -Original Message-
|| Sent: Saturday, 26 May 2001 12:16
|| To: Multiple recipients of list ORACLE-L
||
||
|| On Friday 25 May 2001 18:26, Weaver, Walt wrote:
|| > Ditto. I support Jared's backspace claims 100%, and I
|| don't think he
|| should
|| > be removed from the list.
||
|| I sure appreciate that Walt!
||
|| > I've heard there are other operating systems out there
|| besides Linux and
|| > Solaris. Is this true?
||
|| A nasty rumor.  There's an upstart startup in WA that claims to have
|| something akin to an OS, but it keeps failing the 30 day
|| stability test.
||
|| Jared
||
||
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Jared Still
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Reardon, Bruce (CALBBAY)
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Christopher Spence
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Kimberly Smith
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ros

RE: Effective Living


We could implement it and be the inventors of a new kind of DBA theory.  The
"hands off DBA".  When it breaks you can tell us, by are not going to tell
you why it broke, it's just broke, deal with it.

-Original Message-
Sent: Wednesday, May 30, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L


LOL!! Now that sounds like fun.  Just immagine the frustrated users and
damagers running around trying to deal with that answer!

Rodd Holman
>> Original Message <<

On 5/30/01, 2:12:06 PM, Kevin Kostyszyn <[EMAIL PROTECTED]> wrote regarding
RE: Effective Living:


> Yeah, but just because something is popular doesn't meen it is good. If
we
> all lived our lives that way everyday I am not so sure we would get much
> accomplished?

> Oh no, the Database is down!!
> Why?
> I don't know, who cares.
> hehehe

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

-- 
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: Update Query

ha, ha. you got bit by the "null" update thing too, I remember it 
well! :)

except for maybe some newfangled oracle8 features, the "ugly" one is 
the "traditional" way the manual says to do it (iirc). I have many 
many scripts with that kind of code in them since we load mainframe 
datafiles into the local oracle apps, and do a lot of cross-table 
updates  (non-normalized, but that is mostly ok since it is archive 
data).

you *can* "pretty" it up a bit by using better formatting,
e.g.,

update 
   tablea a
   set 
 ( 
   a.firstname,
   a.lastname
 )
   = 
 ( 
   select 
  b.firstname,
  b.lastname 
 from 
  tableb b
where 
  b.id = a.id 
 )
 where 
   a.id in
 (
   select 
  b2.id
 from 
  tableb b2
  )
/

On 30 May 2001, at 11:56, CC Harvest wrote:

Date sent:  Wed, 30 May 2001 11:56:14 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> Seems like Oracle Doesn't have to the query like this:
> 
> update tablea set firstname=tableb.firstname,
> lastname=tableb.lastname
> where tableb.id = tablea.id;
> 
> I can have one, it works if it has a match for the two
> tables, otherwise the two columns updated to null:
> 
> update tablea set (firstname,lastname)
> =(select firstname,lastname from tableb
>   where tableb.id=tablea.id);
> 
> Then the following one works, but very ugly:
> 
> update tablea set (firstname,lastname)
> =(select firstname,lastname from tableb
>   where tableb.id=tablea.id)
> where exists(
> select 'x' from tableb 
>   where tableb.id=tablea.id)

...

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

alter session set events 'immediate trace name redohdr level 10'

2001-05-30 Thread Hagedorn, Linda

Title: alter session set events 'immediate trace name redohdr level 10' 





Hello, 


I'm looking for documentation to name and label the output from the dump of redo headers and logs.  For example, 
siz: 0x5000 seq: 0x1087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2


The size parameter is what, the header size in hex?  x5000 = decimal 20480?  


In the DB2 world, this kind of information is readily available and provided to licensed customers in the DB2 Diagnosis Manual.  I would think the Oracle diagnosis info should be as available as IBM's.  Yes?  A search in MetaLink for this list returned zero hits: siz seq hws bsz nab flg dup    

  
Any information or referral to documentation is appreciated.  Thanks, Linda.  Oracle DBA, former IBM DB2 L2.

Re: Archiving not possible with SQL Server?

2001-05-30 Thread Igor Neyman


Actually, MS transaction log(s) combine the functions of Oracle's redo logs
and Rollback segments (and that's bad).
As for archiving - nop, no archiving in MS SQL Server.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:41 PM


> Halo,
>
> Windoz 2000/SQL Server 2000
>
> Bringing an axuliary MS SQL db online. Trying to setup "archiving". Am I
> reading documentation right, SQL does NOT automatically archive
transaction
> log? This process must be setup via backup routine, which truncates the
log
> upon completion?
>
> Lemme try some logic:
>
> Oracle's redo logs = MS transaction log(s)
> Oracle's archived logs = ?
>
>
> Gary Weber
> Senior DBA
> Charles Jones, LLC
> 609-530-1144, ext 5529
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gary Weber
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

RE: RE: Would you increase the shared pool? --URGENT


Responding to item 4 and 5.

4)  I would recommend doing this at beginging of instance startup or fresh
after pool flush.
I am not a fan of pinning everything that moves, although sizing them sp
with this in mind doesn't pose any notable problems I know of.

5)  I would look at v$sql and v$sqltext and see if you see :b1 or 342452.  I
would do a manual scan of it to make perfectly sure.  Although invalidation
and other stats can give you good estimates as well.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L


Hi Christopher, thanks for answering

>1.  I would check to see if the buffer busy waits are
>on the same
>file/block.  Perhaps the same object is being hit
>constantly.  I would also
>base my action on the type of block being waited on.

I'm doing exactly this, mostly of my waits are data
block waits and p3=0, so there's no much I can do,
anyway I'll try increasing buffer cache size.


>2.  Tuning the redo generation would be a good thing,
>specially one of that
>size.  I would recommend two raid 0 arrays of 3-6
>disks each with quick io /
>raw devices.  3gb is fine, I have never had to work
>with a monstrocity of
>that, but I have heard 2gb+ redo logs a few times. 
>That is a constant
>800Kb/s second sustained.  

This is the first thing I'm trying to do.

>3.  What is the block size of this database?  
8KB Oracle 7.3.4

>4.  I think possibly problem is not further sizing
>the sp but avoiding
>fragmentation by pinning large procedures and
>packages at startup.  

I'll do that. Althought I'm pinning everything that
moves (with some Steve Adams scripts), I'll identify
"large procedures" to pin.

>5.  Do the statements use literals or bind
>variables.  Are objects being
>reloaded because of different syntax or because of
>invalidations and aging?

I really don't know if the application uses bind
variables (I think it does). I think that this high
parsing might be due to a lot of ad hoc queries. I'm
running a script right now to collect data from v$sql,
to see if these reloads are due to different syntax
for the same SQLs.
Is there another way to check this ?


TIA



> --- Pablo ksksksk <[EMAIL PROTECTED]> escribió: >
> Fecha: Tue, 29 May 2001 22:19:09 +0200 (CEST)
> > De: Pablo ksksksk <[EMAIL PROTECTED]>
> > Asunto: RE: Would you increase the shared pool? 
> > --URGENT
> > Para: Steve Adams <[EMAIL PROTECTED]>
> > CC: "ORACLE-L @ Fatcity" <[EMAIL PROTECTED]>
> > 
> > Hi Steve and List,
> > 
> > I'm still having some problem to understand this
> > data.
> > 
> > I've taken Steve Adams advise to reduce Shared
> Pool.
> > I
> > reduced it from 200MB to 180MB. And off course,
> this
> > reduction has impacted in SP latch hit ratio. It
> > sleeps rate has improved from 0.88% to 0.55%.
> > 
> > But I still have some opposed data.
> > 
> > Here I past my wait events:
> > 
> > EVENT   
> TIME_WAITED
> >
> 
> > enqueue 
> 1780156
> > buffer busy waits
> 511713
> > log buffer space 
> 103542
> > latch free
> 71181
> > write complete waits  
> 35970
> > free buffer waits  
> 5246
> > library cache pin  
> 4797
> > log file switch completion 
> 1678
> > library cache load lock 
> 392
> > row cache lock   
> 35
> > 
> > 
> > Shared Pool Info
> > 
> > RECURR TRANSIENT FLUSHED  PINS  ORA-4031 LAST
> ERROR
> > S.
> >
>
--
> >   6531   11538  260744   3555435 0  0
> > 
> > 
> >   BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE  
> > BIGGEST
> >
>
--
> > 0 1005282098   47   
> 72
> > 1  70904 759   93  
> 136
> > 2 2235761252  178  
> 224
> > 3384   1  384  
> 384
> > 4   6456  10  645  
> 808
> > 5 218000 151 1443 
> 2048
> > 6 185536  64 2899 
> 3968
> > 
> > 
> > As far as I can see, transient list is not bigger
> > than
> > tree times recurrent list (so SP is not too big)
> and
> > flushed chunks/pins and releases is more than 1/20
> > (0.07). This posible indicates that the shared
> Pool
> > is
> > too small.
> > 
> > Besides, "library cache load lock" event indicates
> > that a lot of SQLs (or other objects) are being
> > loaded
> > to the LC, this may also indicate that the SP is
> > small.
> > 
> > But on the other hand, We've got that list 0

RE: Performance tuning


"You are above average in awareness, so one would have to
 work harder than normal to slip something by you."


In my fractured metaphor, 
early-ness in the morning maps to degree of awareness, and 
wool over the eyes maps to unawareness. 

The original metaphors are "the early bird gets the worm"
and "you can't pull the wool over my eyes".

http://www.cs.nmsu.edu/atmet/Databank/root.html

http://www.wam.umd.edu/~mturn/

(Mark was my ONLY non math/science/engineering instructor
 in nine years of "higher" education. A genius. He did ran 
 a class on Classic Style ( viz. LaRouchefoucauld, et al.)

http://www.wam.umd.edu/~mturn/WWW/blending.html

 (His work on cognitive blending deserves an award, or 
  at least a small impervious plaque somewhere. )

http://www.reversespeech.com/index.html

I don't buy this, but neither have I read it. It is
simply interesting and tangentially connected to
metaphor generation and usage. 


hth, 

Ross

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Translation please.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 3:32 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| You have to get up pretty early in
|| the morning to pull the wool over
|| your eyes, Mr. Hillman. 
|| 
|| :)
|| 
|| || -Original Message-
|| || From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| || Sent: Wednesday, May 30, 2001 1:22 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: Performance tuning
|| || 
|| || 
|| || Why putting DB in noarchivelog will avoid redo generation? 
|| || There will be no
|| || archiving, but redo will continue to be generated.
|| || 
|| || Alex Hillman
|| || 
|| || -Original Message-
|| || Sent: Wednesday, May 30, 2001 10:21 AM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || Azhar,
|| || 
|| || Just two thoughts off the top of my head to improve loading 
|| || of records:
|| || 1.  Put database in noarchivelog mode to avoid redo 
|| generation (if 
|| || possible).
|| || 2.  Drop all indexes on target tables (if possible), then 
|| || load data, then 
|| || recreate all indexes on target tables.
|| || 
|| || Jim
|| || 
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. Louis, MO  633376
|| || 9636) 474-7832
|| || [EMAIL PROTECTED] (work)
|| || [EMAIL PROTECTED] (home)
|| || 
|| || > 
|| || > HI ALL,
|| || > We have to load almost 3 millions records of average row 
|| || size of 150 
|| || bytes.
|| || > We are importing data using sqloader with ROWS=4000 and 
|| || bindsize=845 .
|| || > We have adjusted the rollback segment to almost  10 m with 
|| || 8 extents 
|| || enough
|| || > for single transaction size and considering 30% rollback 
|| || overhead. We
|| || > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| || > Rollback segment, databuffer cache have hit ratio of 100%.
|| || > 
|| || > The loading was fast only for first 10 commits but then it 
|| || slowed like
|| || > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| || NT4 128 megs RAM
|| || > .
|| || > SGA figures in M :
|| || > NAME VALUE
|| || >  -
|| || > Fixed Size.0676384
|| || > Variable Size239.02734
|| || > Database Buffers   39.0625
|| || > Redo Buffers 7.8203125
|| || >  -
|| || > sum  285.97779
|| || > ( we can't use direct path due to functions in sqlldr 
|| || controlfile). .
|| || > Couldn't figure out the bottleneck yet.
|| || > Any ideas.
|| || > TIA
|| || > Azhar Siddiq,
|| || > DBA
|| || > LMK Resources
|| || > 
|| || > -- 
|| || > 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).
|| || > 
|| || > 
|| || 
|| || 
|| || -- 
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. Louis, MO  633376
|| || 9636) 474-7832
|| || [EMAIL PROTECTED] (work)
|| || [EMAIL PROTECTED] (home)
|| || 
|| || -- 
|| || Please see the o

Job remove?

2001-05-30 Thread Seema Singh


Hi
I have some job which is available in dba_jobs_running but it is not 
available in dba_jobs
How can I remove these job?
Thx
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

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

RE: Update Query


if it was for one column you could use nvl or decode

update tablea set firstname=nvl((select firstname from tableb where
tablea.id=tablea.id), firstname);

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Seems like Oracle Doesn't have to the query like this:

update tablea set firstname=tableb.firstname,
lastname=tableb.lastname
where tableb.id = tablea.id;

I can have one, it works if it has a match for the two
tables, otherwise the two columns updated to null:

update tablea set (firstname,lastname)
=(select firstname,lastname from tableb
  where tableb.id=tablea.id);

Then the following one works, but very ugly:

update tablea set (firstname,lastname)
=(select firstname,lastname from tableb
  where tableb.id=tablea.id)
where exists(
select 'x' from tableb 
  where tableb.id=tablea.id)

Any suggestions?
TIA

Chris Harvest





__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

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

Resolved: Yes, DBMS_OBFUSCATION is free in Enterprise Edition

2001-05-30 Thread Cherie_Machler



Thanks to all who replied.  Since all replies were a strong yes, I will
tell my
manager a definitive yes.

Thanks again,

Cherie


   

Diana_Duncan@ttpa  

rtners.com   To: [EMAIL PROTECTED]  

 cc: [EMAIL PROTECTED]  

05/30/01 12:56 PMSubject: Re: Is DBMS_OBFUSCATION free 
in Enterprise Edition?  
   

   






It's free.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]



Cherie_Machler

@gelco.comTo: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
Sent by:  cc:

[EMAIL PROTECTED]Fax to:

omSubject: Is DBMS_OBFUSCATION
free in Enterprise Edition?


05/30/2001

02:02 PM

Please respond

to ORACLE-L








We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6.

My manager needs a definitive answer.   Is DBMS_OBFUSCATION
free with this version of Enterprise Edition server or is it part of an
extra-cost add-on.

All definitive answers welcome. I have a call in to Oracle but they
have not yet responded.  My manager wants to know today.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


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

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

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








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

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

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

RE: backspace in Oracle.


I personally vouch for the machine running Novell for 6 years, I built it.
It was taken down about 3 months ago.  It happened to be a server use to
store drivers and os builds to zap down to machines as they are being built
at PC manufacture.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Kim, 

Did you hear the one about the NT box
that ran for SEVEN YEARS, playing solitaire?

Yea, me neither, but it's a good story, just
like the Novell one. 

:)


|| -Original Message-
|| From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 12:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
|| 
|| 
|| Ya, but I can keep a NT box for a long time to, if I don't touch it.
|| 
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 6:01 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| I have built Novell boxes that have 2100+ days of uptime :)
|| 
|| Now that is stability that I have yet to see even unix have.
|| Granted it is only Novell 3.12.
|| 
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Sunday, May 27, 2001 8:10 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Jared,
|| 
|| I have an NT 4 server up for 242 days.
|| 
|| Someone where I work suggested it should be sent to Microsoft for an
|| examination (must be something wrong with it).
|| 
|| Regards,
|| Bruce
|| 
|| -Original Message-
|| Sent: Saturday, 26 May 2001 12:16 
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| On Friday 25 May 2001 18:26, Weaver, Walt wrote:
|| > Ditto. I support Jared's backspace claims 100%, and I 
|| don't think he
|| should
|| > be removed from the list.
|| 
|| I sure appreciate that Walt!
|| 
|| > I've heard there are other operating systems out there 
|| besides Linux and
|| > Solaris. Is this true?
|| 
|| A nasty rumor.  There's an upstart startup in WA that claims to have
|| something akin to an OS, but it keeps failing the 30 day 
|| stability test.
|| 
|| Jared
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jared Still
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Reardon, Bruce (CALBBAY)
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Christopher Spence
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Kimberly Smith
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and i

RE: Analyze table and locking

Oracle actually claims this statement. There are numerous docs stating this,
for example DOC ID: 213220.999.  But I agree 100% with Jeremiah's claims, in
fact it can be verified very easily looking at v$lock while analyzing a
large table.  (I have actually done this in the past and present) and there
are no locks under my current sid or any additional locks under any sid
during analyze.

Take any table that takes more than 3-4 seconds to analyze and in another
window query V$LOCKS and you can see this first hand.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 

-Original Message-
Sent: Wednesday, May 30, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L

I have used compute statistics since version 7.3.2 up through 8.1.6, and
never
had it hold a table lock for the duration of the analyze.  I don't know
where
people are getting the idea that compute statistics holds a lock and
estimate
doesn't.  That just doesn't make sense.  Why would compute need a lock?  Are
you saying I can estimate sample 99 percent, and get what amounts to a
compute
and avoid the supposed lock?  Does that make any sense?  No.

Validate structure cascade holds a lock.  The most the others do is grab
some
resource [very] briefly at the end to update the dictionary.  People
claiming
that compute holds a lock, please post documentation to support that
statement.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 30 May 2001, Raghu Kota wrote:

> Yeah If you use compute statistics your table get locked and will take
long
> time, But If you use  estimate statistics it will be fast But not as
> accurate as before. Better to analyze at nights by setting time.
>
> >From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
> >
> >Anyone know if there are any locking issues while analyzing statistics
for
> >objects ??

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: random equipment seen ???/ RE: V$SESSION.OSUSER returns

2001-05-30 Thread Rachel Carmichael


oh yeah, I want one of these... of course, my cats, American shorthairs, 
have all been over 16 pounds anyway (mom feeds them good she does!)



>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: random equipment seen ???/ RE: V$SESSION.OSUSER returns Date: Wed, 30 May 2001 10:30:26 -0800
>
>http://www.cfainc.org/breeds/profiles/articles/maine.html
>
>---excerpt---
>
>The Maine Coon Standard
>
>The Maine Coon Cat is a massive, broad chested cat with a long
>rectangular body and the fur is long and flowing. The males
>average around 12 to 15 pounds, with some going 20 pounds or more.
>The females are smaller, averaging 9 to 12 pounds.
>
>...
>
>The Maine Coon is slow to mature, often not reaching full
>development until three to four years of age.
>
>...
>
>The Maine Coon is a gentle, loyal breed. They make wonderful
>family pets and get along well with children and dogs. Depending
>on the breed of dog, the Maine Coon can be bigger than Fido. They
>are a vocal breed, with a variety of meows, trills and chirps to
>make up their vocabularies. They are sociable and like to help
>their owners with any project, especially when the owner is
>reading or working on the crossword puzzle.
>
>Since 1976, the Maine Coon Cat has been a rising star in the
>competitive reaches of the cat fancy. This popular breed of the
>late 19th century drifted into obscurity and imagined extinction
>well into the 1950s. Those of us who now work with and breed the
>Maine Coon owe a tremendous THANK YOU to those who worked and
>fought for recognition and the championship status we enjoy today.
>As any exhibitor can tell you, spectators can often be seen
>watching the Maine Coons being judged, exclaiming at the size, and
>even saying they have one or two like them at home - today, they
>probably do. The Maine Coon is the second most popular cat in CFA
>as seen by the numbers of kittens registered. America's first show
>cat is back, bigger and better than ever.
>
>---end---
>
>On 30 May 2001, at 6:56, Christopher Spence wrote:
>
>Date sent: Wed, 30 May 2001 06:56:50 -0800
>To:Multiple recipients of list ORACLE-L 
><[EMAIL PROTECTED]>
>
> > mainekoon cats.  Almost as big as dogs ...
>
>...
>
>--
>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).

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

RE: Analyze table and locking

2001-05-30 Thread Rajaram

Yes, thats true... you need a lock on an object only when you are changing 
the object. So, analyze table does not have anything to do with locks..

Rajaram.

-Original Message-
From:   Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Analyze table and locking

Oracle actually claims this statement. There are numerous docs stating 
this,
for example DOC ID: 213220.999.  But I agree 100% with Jeremiah's claims, 
in
fact it can be verified very easily looking at v$lock while analyzing a
large table.  (I have actually done this in the past and present) and there
are no locks under my current sid or any additional locks under any sid
during analyze.

Take any table that takes more than 3-4 seconds to analyze and in another
window query V$LOCKS and you can see this first hand.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-Original Message-
Sent: Wednesday, May 30, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L

I have used compute statistics since version 7.3.2 up through 8.1.6, and
never
had it hold a table lock for the duration of the analyze.  I don't know
where
people are getting the idea that compute statistics holds a lock and
estimate
doesn't.  That just doesn't make sense.  Why would compute need a lock? 
 Are
you saying I can estimate sample 99 percent, and get what amounts to a
compute
and avoid the supposed lock?  Does that make any sense?  No.

Validate structure cascade holds a lock.  The most the others do is grab
some
resource [very] briefly at the end to update the dictionary.  People
claiming
that compute holds a lock, please post documentation to support that
statement.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 30 May 2001, Raghu Kota wrote:

> Yeah If you use compute statistics your table get locked and will take
long
> time, But If you use  estimate statistics it will be fast But not as
> accurate as before. Better to analyze at nights by setting time.
>
> >From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
> >
> >Anyone know if there are any locking issues while analyzing statistics
for
> >objects ??

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: backspace in Oracle.


I am all for NLMs, DLMs, and M&M.

But, if you let me bounce most any NT box
once a month for, say, a DEFRAG, I'll be
able to keep it up for one helluva long
time too. 

Ross NMN Mohan

|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:03 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
|| 
|| 
|| Netware 3.12 (or 3.2, which is basically 3.12 with Y2K patches) is 
|| amazingly robust/stable. We still have one running a ("unsupported") 
|| legacy Oracle 7.3 app with 66mhz 486/DOS clients w/ 8Mb RAM!!! 
|| (SQL*Net v2 lite). 
|| 
|| Only reason for "downtime" is running VREPAIR (rough equivalent of 
|| "scandisk") about once every other month, and also when the startup 
|| files need maintenance (usually related to changed parameters on 
|| .nlms loaded, versoin upgrades, etc) and a bounce is required. also 
|| we recently had to put in a new UPS battery, which required a down.
|| 
|| It is amazing how good (well engineered) "no frills" 
|| software can be. 
|| unfortunately the ".NLM" ended up being sort of the "Pinto" of the 
|| NOS industry. the fall of Novell is one of the great sad stories of 
|| the industry. corruption of marketing mentality.
|| 
|| --
|| 
|| On 30 May 2001, at 6:56, Mohan, Ross wrote:
|| 
|| Date sent:   Wed, 30 May 2001 06:56:48 -0800
|| To:  Multiple recipients of list ORACLE-L 
|| <[EMAIL PROTECTED]>
|| 
|| > Six years? No downtime in any way? That would be...uh.unusual. 
|| > 
|| > I am sure the details are fascinating...do tell.
|| > 
|| > || -Original Message-
|| > || From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| > || Sent: Wednesday, May 30, 2001 9:01 AM
|| > || To: Multiple recipients of list ORACLE-L
|| > || Subject: RE: backspace in Oracle.
|| > || 
|| > || 
|| > || I have built Novell boxes that have 2100+ days of uptime :)
|| > || 
|| > || Now that is stability that I have yet to see even unix have.
|| > || Granted it is only Novell 3.12.
|| 
|| 
|| ...
|| 
|| 
|| -- 
|| 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).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: backspace in Oracle.


It kept trying to win. 

It couldn't

|| -Original Message-
|| From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:31 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
|| 
|| 
|| Oh come on Ross, it wasn't "running" solitaire for seven 
|| years, it would
|| have been brought to it's knees in a month if solitaire was open!
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 3:26 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Kim,
|| 
|| Did you hear the one about the NT box
|| that ran for SEVEN YEARS, playing solitaire?
|| 
|| Yea, me neither, but it's a good story, just
|| like the Novell one.
|| 
|| :)
|| 
|| 
|| || -Original Message-
|| || From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| || Sent: Wednesday, May 30, 2001 12:36 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: backspace in Oracle.
|| ||
|| ||
|| || Ya, but I can keep a NT box for a long time to, if I 
|| don't touch it.
|| ||
|| ||
|| || -Original Message-
|| || Sent: Wednesday, May 30, 2001 6:01 AM
|| || To: Multiple recipients of list ORACLE-L
|| ||
|| ||
|| || I have built Novell boxes that have 2100+ days of uptime :)
|| ||
|| || Now that is stability that I have yet to see even unix have.
|| || Granted it is only Novell 3.12.
|| ||
|| ||
|| || "Walking on water and developing software from a
|| || specification are easy if
|| || both are frozen."
|| ||
|| || Christopher R. Spence
|| || Oracle DBA
|| || Fuelspot
|| ||
|| ||
|| ||
|| || -Original Message-
|| || [mailto:[EMAIL PROTECTED]]
|| || Sent: Sunday, May 27, 2001 8:10 PM
|| || To: Multiple recipients of list ORACLE-L
|| ||
|| ||
|| || Jared,
|| ||
|| || I have an NT 4 server up for 242 days.
|| ||
|| || Someone where I work suggested it should be sent to 
|| Microsoft for an
|| || examination (must be something wrong with it).
|| ||
|| || Regards,
|| || Bruce
|| ||
|| || -Original Message-
|| || Sent: Saturday, 26 May 2001 12:16
|| || To: Multiple recipients of list ORACLE-L
|| ||
|| ||
|| || On Friday 25 May 2001 18:26, Weaver, Walt wrote:
|| || > Ditto. I support Jared's backspace claims 100%, and I
|| || don't think he
|| || should
|| || > be removed from the list.
|| ||
|| || I sure appreciate that Walt!
|| ||
|| || > I've heard there are other operating systems out there
|| || besides Linux and
|| || > Solaris. Is this true?
|| ||
|| || A nasty rumor.  There's an upstart startup in WA that 
|| claims to have
|| || something akin to an OS, but it keeps failing the 30 day
|| || stability test.
|| ||
|| || Jared
|| ||
|| ||
|| || --
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || --
|| || Author: Jared Still
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Reardon, Bruce (CALBBAY)
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Christopher Spence
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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:

Re: OT: Archiving not possible with SQL Server?

2001-05-30 Thread Rachel Carmichael


I'd get frantic phone calls from the programmers...

in the version of Sybase we were using (4.something), truncate actually 
archived off the log info. But it needed to write to the log. If the log was 
full, I had to trash it and then pray that nothing went wrong before I could 
get a full backup done.


>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: OT: Archiving not possible with SQL Server?
>Date: Wed, 30 May 2001 12:02:48 -0800
>
>
>And thus you discover the inane mechanism that SQL Server
>inherited from Sybase, by which both try to do concurrency.
>
>Guess what happens when a long running transaction marks
>the log near the end, and not too long afterward the log
>needs truncated?
>
>If memory serves, ( hasn't worked too well lately :) the database
>will hang.  It may just truncate back to the mark, and start from
>there, but you always have the possibility of another long
>transaction starting.
>
>Can't remember the details, but what I do remember clearly
>is that it is a process that has to be closely watched, and I
>didn't particularly care for the way it worked.
>
>Jared
>
>
>On Wednesday 30 May 2001 11:41, Gary Weber wrote:
> > Halo,
> >
> > Windoz 2000/SQL Server 2000
> >
> > Bringing an axuliary MS SQL db online. Trying to setup "archiving". Am I
> > reading documentation right, SQL does NOT automatically archive 
>transaction
> > log? This process must be setup via backup routine, which truncates the 
>log
> > upon completion?
> >
> > Lemme try some logic:
> >
> > Oracle's redo logs = MS transaction log(s)
> > Oracle's archived logs = ?
> >
> >
> > Gary Weber
> > Senior DBA
> > Charles Jones, LLC
> > 609-530-1144, ext 5529
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Your views on Quest - Shareplex

2001-05-30 Thread MacGregor, Ian A.

Title: RE: Your views on Quest - Shareplex



The 
person giving the presentation on Shareplex  stated  that there could 
be no chained rows when the sharepex file, apparently analogous to the log miner 
dictionary file is created.

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 
  11:07 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Your views on Quest - Shareplex
  > -Original Message- > 
  From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] 
  > > We are looking into the 
  product as well, but have yet to even > toy with 
  the product.  There is a "no chained rows" > 
  restriction. 
  I'm not sure what that statement means. Shareplex will 
  replicate a table that has chained rows. 
  > Shareplex does not replicate transactions on 
  > sys objects.  A table dropped  on one 
  side will not be > dropped on the other.  It 
  apparently will replicate truncates > 
  however.  It's one thing to read the logs and to find the 
  > time when a truncate caused writes to the data 
  dictionary, > but quite another to reconstruct the 
  statement. 
  Statement from a developer of Shareplex: <>
  Truncate is not  DML it is DDL.  
  I didn't say there was a problem extracting DML 
  statements.  Oracle's log miner utility will do that.  
  I said that  Shareplex, as per the person who gave the 
  presentation, will replicate truncates and marvelled at this 
  capability.   
  Let me relate my personal experience working with Shareplex 
  (BEFORE I was an employee with Quest Software). At a previous company we were 
  looking for a replication tool at a company that did payroll taxes. There were 
  large batch loads (bank records) every night, but especially at the end of 
  each quarter and at the end of the year. We wanted to ensure that the 
  replication tool we chose would be fast enough to keep up with the large data 
  loads. When we tested Oracle Replication and Quest Shareplex, we found that 
  Shareplex was significantly faster. I personally argued against it initially 
  for some of the reasons posters here have mentioned (e.g. it uses 
  "unsupported" means to accomplish its goal) but eventually we implemented 
  Shareplex and were satisfied with the result. There can be some manual effort 
  involved in reconciliation of discrepancies but we found that effort to be 
  minor. Another factor that influenced our decision is that we were intending 
  to use Shareplex for Oracle in co junction with Shareplex FS to replicate 
  datafiles created on the HP-UX server.
  -- Jacques R. Kilchoer 
  (949) 754-8816 Quest Software, 
  Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. 
  http://www.quest.com

RE: backspace in Oracle.


Now *that's* details.

So, what was the OS version? Hardware? avg/peak
user load?

Let me get this right:  there was ZERO DOWNTIME
in six years?  

my o my

|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:47 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
|| 
|| 
|| I personally vouch for the machine running Novell for 6 
|| years, I built it.
|| It was taken down about 3 months ago.  It happened to be a 
|| server use to
|| store drivers and os builds to zap down to machines as they 
|| are being built
|| at PC manufacture.
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 3:26 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Kim, 
|| 
|| Did you hear the one about the NT box
|| that ran for SEVEN YEARS, playing solitaire?
|| 
|| Yea, me neither, but it's a good story, just
|| like the Novell one. 
|| 
|| :)
|| 
|| 
|| || -Original Message-
|| || From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| || Sent: Wednesday, May 30, 2001 12:36 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: backspace in Oracle.
|| || 
|| || 
|| || Ya, but I can keep a NT box for a long time to, if I 
|| don't touch it.
|| || 
|| || 
|| || -Original Message-
|| || Sent: Wednesday, May 30, 2001 6:01 AM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || I have built Novell boxes that have 2100+ days of uptime :)
|| || 
|| || Now that is stability that I have yet to see even unix have.
|| || Granted it is only Novell 3.12.
|| || 
|| || 
|| || "Walking on water and developing software from a 
|| || specification are easy if
|| || both are frozen."
|| || 
|| || Christopher R. Spence
|| || Oracle DBA
|| || Fuelspot 
|| || 
|| || 
|| || 
|| || -Original Message-
|| || [mailto:[EMAIL PROTECTED]]
|| || Sent: Sunday, May 27, 2001 8:10 PM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || Jared,
|| || 
|| || I have an NT 4 server up for 242 days.
|| || 
|| || Someone where I work suggested it should be sent to 
|| Microsoft for an
|| || examination (must be something wrong with it).
|| || 
|| || Regards,
|| || Bruce
|| || 
|| || -Original Message-
|| || Sent: Saturday, 26 May 2001 12:16 
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || On Friday 25 May 2001 18:26, Weaver, Walt wrote:
|| || > Ditto. I support Jared's backspace claims 100%, and I 
|| || don't think he
|| || should
|| || > be removed from the list.
|| || 
|| || I sure appreciate that Walt!
|| || 
|| || > I've heard there are other operating systems out there 
|| || besides Linux and
|| || > Solaris. Is this true?
|| || 
|| || A nasty rumor.  There's an upstart startup in WA that 
|| claims to have
|| || something akin to an OS, but it keeps failing the 30 day 
|| || stability test.
|| || 
|| || Jared
|| || 
|| || 
|| || -- 
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || -- 
|| || Author: Jared Still
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Reardon, Bruce (CALBBAY)
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Christopher Spence
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| -

RE: Performance tuning


I am impressed.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 5:18 PM
To: Multiple recipients of list ORACLE-L


"You are above average in awareness, so one would have to
 work harder than normal to slip something by you."


In my fractured metaphor, 
early-ness in the morning maps to degree of awareness, and 
wool over the eyes maps to unawareness. 

The original metaphors are "the early bird gets the worm"
and "you can't pull the wool over my eyes".

http://www.cs.nmsu.edu/atmet/Databank/root.html

http://www.wam.umd.edu/~mturn/

(Mark was my ONLY non math/science/engineering instructor
 in nine years of "higher" education. A genius. He did ran 
 a class on Classic Style ( viz. LaRouchefoucauld, et al.)

http://www.wam.umd.edu/~mturn/WWW/blending.html

 (His work on cognitive blending deserves an award, or 
  at least a small impervious plaque somewhere. )

http://www.reversespeech.com/index.html

I don't buy this, but neither have I read it. It is
simply interesting and tangentially connected to
metaphor generation and usage. 


hth, 

Ross

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Translation please.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 3:32 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| You have to get up pretty early in
|| the morning to pull the wool over
|| your eyes, Mr. Hillman. 
|| 
|| :)
|| 
|| || -Original Message-
|| || From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| || Sent: Wednesday, May 30, 2001 1:22 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: Performance tuning
|| || 
|| || 
|| || Why putting DB in noarchivelog will avoid redo generation? 
|| || There will be no
|| || archiving, but redo will continue to be generated.
|| || 
|| || Alex Hillman
|| || 
|| || -Original Message-
|| || Sent: Wednesday, May 30, 2001 10:21 AM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || Azhar,
|| || 
|| || Just two thoughts off the top of my head to improve loading 
|| || of records:
|| || 1.  Put database in noarchivelog mode to avoid redo 
|| generation (if 
|| || possible).
|| || 2.  Drop all indexes on target tables (if possible), then 
|| || load data, then 
|| || recreate all indexes on target tables.
|| || 
|| || Jim
|| || 
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. Louis, MO  633376
|| || 9636) 474-7832
|| || [EMAIL PROTECTED] (work)
|| || [EMAIL PROTECTED] (home)
|| || 
|| || > 
|| || > HI ALL,
|| || > We have to load almost 3 millions records of average row 
|| || size of 150 
|| || bytes.
|| || > We are importing data using sqloader with ROWS=4000 and 
|| || bindsize=845 .
|| || > We have adjusted the rollback segment to almost  10 m with 
|| || 8 extents 
|| || enough
|| || > for single transaction size and considering 30% rollback 
|| || overhead. We
|| || > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| || > Rollback segment, databuffer cache have hit ratio of 100%.
|| || > 
|| || > The loading was fast only for first 10 commits but then it 
|| || slowed like
|| || > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| || NT4 128 megs RAM
|| || > .
|| || > SGA figures in M :
|| || > NAME VALUE
|| || >  -
|| || > Fixed Size.0676384
|| || > Variable Size239.02734
|| || > Database Buffers   39.0625
|| || > Redo Buffers 7.8203125
|| || >  -
|| || > sum  285.97779
|| || > ( we can't use direct path due to functions in sqlldr 
|| || controlfile). .
|| || > Couldn't figure out the bottleneck yet.
|| || > Any ideas.
|| || > TIA
|| || > Azhar Siddiq,
|| || > DBA
|| || > LMK Resources
|| || > 
|| || > -- 
|| || > 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).
|| || > 
|| || > 
|| || 
|| || 
|| || -- 
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. L

Off-Topic "Job Opportunities & Pay Scale of DBA in Middle East & Saudi Arabia"

2001-05-30 Thread Salman Faheem


Hi All ,

I am looking forward to visit Middle East & Saudi
Arabia for better job perspectives. So wanna know
about
the pay-scale & Job opportunities there. Any help in
this regard will be highly appreciated.( like some
Good Job sites, list of good companies working there
on oracle etc. )

Best Regards

Your DBA 

Salman Faheem

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Salman Faheem
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Performance tuning

2001-05-30 Thread Post, Ethan


sorry, I should have been clear, here is the quote from the article...

"RAID 5 costs more for write-intensive applications than RAID 1. The
so-called "small-write penalty" inherent in the design of RAID level 5 disk
arrays
makes each Oracle DBWR write require four physical I/O operations.
Conse-quently,
to provide adequate throughput capacity for a write-intensive Oracle
ap-plication,
an architect must use about twice as many disk drives as if he were
using RAID level 1 (mirroring)." - Cary Millsap

- Ethan Post

-Original Message-
Sent: Wednesday, May 30, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L


Yes, Agreed.

Raid of any level will not change the number of writes in terms of DBWR.
But will change how many physical reads and writes needed to implement
parity and data to the disks.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L


No to be overly pedantic, but RAID5 does not change the number of write()
calls made by DBWR.  It will change the number of disk operations done by
your hardware controller or your software raid drivers, but that's slightly
different.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:02 PM


> Raid 5 can consume as much as 60% overhead for writes.
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
>
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
> believe. RAID 5 will require additional writes by DBWR which is going to
be
> huge overhead during a dataload.
>
> - Ethan Post
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [EMAIL PROTECTED] eg
> [EMAIL PROTECTED] Emails using the old format will continue to be
delivered
> until 30th June 2001.
>
> Peter McLarty wrote
> "Are you running RAID and if so what configuration. (Not RAID 5 I hope)"
>
> Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
> performance for Oracle RDBMS on NT
>
> RAID 5 is useful for Oracle datafiles but not for redo log files or
rollback
> segments which are sequentially accessed. Datafiles belonging to the
> temporary tablespace are not suitable for a RAID 5 device. More benefits
> will be seen in situations where reads predominate over writes.
>
> I know that in this instance it is a data load that is being discussed but
> presumably once the data is loaded then it will be read more than once.
>
> Certainly the tone of the note suggests that raid 5 is not a definite
no-no
> rather a 'be cautious as to which files are placed where'. It is my belief
> that often a single raid level is set for all files rather than a mix of
> raid 1 and raid 5 as appropriate.
>
> Peter, I fully agree that the level of memory utilised here is totally
> insufficient and is very likely to be the constraining factor in this
case.
>
> John
>
>
> --
--
> --
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you have received this message in error, please
> inform us promptly by reply e-mail, then delete the e-mail and destroy any
> printed copy.   Thank you.
>
>

> ==
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Christopher Spence
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this ma

RE: OT: Archiving not possible with SQL Server?

2001-05-30 Thread James Xing

-Original Message-
Sent: Wednesday, May 30, 2001 1:03 PM
To: Multiple recipients of list ORACLE-L

Oracle's archived logs = MS transaction log dump files.

If you enable "truncate log on chkpt", the transaction log will be truncated
every time there is checkpoint.
Another way to do is to setup thresholdaction, it will be fired up
automically when the space reach certain percentage defined.

James

And thus you discover the inane mechanism that SQL Server
inherited from Sybase, by which both try to do concurrency.

Guess what happens when a long running transaction marks
the log near the end, and not too long afterward the log
needs truncated?

If memory serves, ( hasn't worked too well lately :) the database
will hang.  It may just truncate back to the mark, and start from
there, but you always have the possibility of another long
transaction starting.

Can't remember the details, but what I do remember clearly
is that it is a process that has to be closely watched, and I
didn't particularly care for the way it worked.

Jared

On Wednesday 30 May 2001 11:41, Gary Weber wrote:
> Halo,
>
> Windoz 2000/SQL Server 2000
>
> Bringing an axuliary MS SQL db online. Trying to setup "archiving". Am I
> reading documentation right, SQL does NOT automatically archive
transaction
> log? This process must be setup via backup routine, which truncates the
log
> upon completion?
>
> Lemme try some logic:
>
> Oracle's redo logs = MS transaction log(s)
> Oracle's archived logs = ?
>
>
> Gary Weber
> Senior DBA
> Charles Jones, LLC
> 609-530-1144, ext 5529
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: James Xing
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OEM Book Recommendation

2001-05-30 Thread Luis DeUrioste


The only book that I've found that touches the OEM in an ok way is ORACLE8 on
Windows NT by Lilian Hobbs ISBN 1-8-190-0




begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

App/web login - how do you handle?

2001-05-30 Thread Brian Wisniewski


How do you handle logins for applications that log into the database
using a common login?  I've seen it handled through hard-coded
username/pass in the app, password file in 'secure' directories and
ops$ account with remote_os_authent set to true on a server being
accessed from a 3rd tier web app.  Mgmt didn't seemed too thrilled when
I showed them in about 2 minutes how to break into the db when
remote_os_authent=true.

Just curious how you handle this.  I haven't seen any particularly
great way and am looking for a better solution.   V7.3.4 -> 8.1.7
databases.

Thanks - Brian

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian Wisniewski
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Your views on Quest - Shareplex

2001-05-30 Thread Jim Hawkins


I verified this today actually.  I had a conference call with Quest 
regarding SharePlex, and asked specifically about the chained rows.  They 
said there is a "reorganization" step on the target database, so chained 
rows are not a problem.

Jim

Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)


> > -Original Message-
> > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
> > 
> > We are looking into the product as well, but have yet to even 
> > toy with the product.  There is a "no chained rows" 
> > restriction.
> 
> I'm not sure what that statement means. Shareplex will replicate a table
> that has chained rows.
> 
> > Shareplex does not replicate transactions on 
> > sys objects.  A table dropped  on one side will not be 
> > dropped on the other.  It apparently will replicate truncates 
> > however.  It's one thing to read the logs and to find the 
> > time when a truncate caused writes to the data dictionary, 
> > but quite another to reconstruct the statement.
> 
> Statement from a developer of Shareplex:
> < functionality for DDL is not at all impossible for us.  It is just one of
> the things on the list of enhancements that we plan for SharePlex, the
> priority of which is dependent on the market.>>
> 
> 
> Let me relate my personal experience working with Shareplex (BEFORE I was 
an
> employee with Quest Software). At a previous company we were looking for a
> replication tool at a company that did payroll taxes. There were large 
batch
> loads (bank records) every night, but especially at the end of each 
quarter
> and at the end of the year. We wanted to ensure that the replication tool 
we
> chose would be fast enough to keep up with the large data loads. When we
> tested Oracle Replication and Quest Shareplex, we found that Shareplex was
> significantly faster. I personally argued against it initially for some of
> the reasons posters here have mentioned (e.g. it uses "unsupported" means 
to
> accomplish its goal) but eventually we implemented Shareplex and were
> satisfied with the result. There can be some manual effort involved in
> reconciliation of discrepancies but we found that effort to be minor.
> Another factor that influenced our decision is that we were intending to 
use
> Shareplex for Oracle in conjunction with Shareplex FS to replicate 
datafiles
> created on the HP-UX server.
> 
> --
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
> http://www.quest.com
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

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

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

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

cannot drop snapshot with partition.

2001-05-30 Thread Naik, Sandesh S


Hi All,
 I have a 8.1.6.2 database on hp9000. (11.0).  I have created one snapshot ,
with partition. Now I not able to drop snapshot or nor I cam drop last
partition.
 It does not show that snapshot in dba_snapshot. I renamed the snapshot to
old. But "drop snapshot is not working
SQL> drop snapshot old;
drop snapshot old
*
ERROR at line 1:
ORA-12003: snapshot "SYS"."OLD" does not exist
If I try to drop the table then it gives this error
SQL> drop table old;
drop table old
   *
ERROR at line 1:
ORA-12083: must use DROP MATERIALIZED VIEW to drop "SYS"."OLD"

Does somebody has encountered this error or has solution to this problem.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: backspace in Oracle.

that would be if the stupid (HELP) data janitor remembers to do 
VREPAIR once every other month or so. sometime the stupid data 
janitor forgets and only does it once a year (with no other downtime).

in other words, except for occasional/normal piddly maintenance 
(which is not otherwise required to keep the system up), netware3x 
will not typically experience the same thing as the (supposedly) 
infamous NT reboots.

???

ep

On 30 May 2001, at 13:10, Mohan, Ross wrote:

Date sent:  Wed, 30 May 2001 13:10:37 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> I am all for NLMs, DLMs, and M&M.
> 
> But, if you let me bounce most any NT box
> once a month for, say, a DEFRAG, I'll be
> able to keep it up for one helluva long
> time too. 
> 
> Ross NMN Mohan
> 
> || -Original Message-
> || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> || Sent: Wednesday, May 30, 2001 4:03 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: backspace in Oracle.

...

> || Only reason for "downtime" is running VREPAIR (rough equivalent of 
> || "scandisk") about once every other month, and also when the startup 
> || files need maintenance (usually related to changed parameters on 
> || .nlms loaded, versoin upgrades, etc) and a bounce is required. also 
> || we recently had to put in a new UPS battery, which required a down.

...

-- 
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: OEM Book Recommendation


as in:

Installation Guide for Enterprise Manager with Change Mangement, Diagnostics, and
 Tuning Pack(pdf, 129879 bytes) 
 Installation Guide for Oracle Enterprise Manager with Management Pack for SAP R/3
 Release 2.2.0 for Windows NT, Windows 95 and Windows 98(pdf, 144481 bytes) 
 Oracle Enterprise Manager Concepts Guide Release 2.2(pdf, 1005607 bytes) 
 Oracle Enterprise Manager Configuration Guide Release 2.2 (pdf, 1479412 bytes) 
 Oracle Enterprise Manager Administrator's Guide Release 2.2 (pdf, 1935922 bytes) 
 Oracle Intelligent Agent User's Guide Release 8.1.7 (pdf, 708860 bytes) 
 Oracle SNMP Support Reference Guide Release 8.1.7 (pdf, 1711104 bytes) 
 Oracle Enterprise Manager Messages Manual Release 2.2(pdf, 2409549 bytes) 
 Getting Started with Oracle Change Management Pack 2.2(pdf, 717048 bytes) 
 Getting Started with Oracle Management Pack for Oracle Applications (pdf, 1467164 
bytes) 
 Getting Started with Oracle Management Pack for SAP R/3(pdf, 1098310 bytes) 


On 30 May 2001, at 12:38, [EMAIL PROTECTED] wrote:


> 
> 
> Technical libraries section under metalink has white papers, manuals etc on
> OEM packs.


-- 
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: OT: Archiving not possible with SQL Server?

2001-05-30 Thread Gary Weber


>>Guess what happens when a long running transaction marks
the log near the end, and not too long afterward the log
needs truncated? If memory serves, ( hasn't worked too well lately :) the
database
will hang.  It may just truncate back to the mark, and start from
there, but you always have the possibility of another long
transaction starting.<<

HELP

Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Your views on Quest - Shareplex - Thank you all

2001-05-30 Thread Rao, Maheswara


Thank you all for giving your time to express your opinions.  I would be
consolidating all the opinions I received in the list and send a mail within
the next two days.  I hope, this consolidation would help for any future
queries on this subject.

Thanks,

Rao

[EMAIL PROTECTED]

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: alter session set events 'immediate trace name redohdr level 10'

2001-05-30 Thread Riyaj_Shamsudeen

Hi Linda
Welcome to Oracle! I am aware that db2 has wealth of documentation and manuals, but you would n't find these information any where in the Oracle documentation..
Anyway , here is the info that you are looking for: Again, this is from my memory so use caution..

siz: Indicates the size of the log file in log block size. So your log file size would be 20480 * 512 =10M
seq: Log sequence # in hex
hws: heck, I don't remember this:-( Been a while looking at this..
bsz:log block size. same as 'select lebsz from x$kccle'
nab:next available block.
flg:Status of the log, like current etc. If I remember correctly, this is a bitmap to indicate various statuses.
dup: # of members in the group.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com

"Hagedorn, Linda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/30/01 03:38 PM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: alter session set events 'immediate trace name redohdr level 10'

Hello,
I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example,
siz: 0x5000 seq: 0x1087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2
The size parameter is what, the header size in hex? x5000 = decimal 20480?
In the DB2 world, this kind of information is readily available and provided to licensed customers in the DB2 Diagnosis Manual. I would think the Oracle diagnosis info should be as available as IBM's. Yes? A search in MetaLink for this list returned zero hits: siz seq hws bsz nab flg dup
Any information or referral to documentation is appreciated. Thanks, Linda. Oracle DBA, former IBM DB2 L2.

RE: backspace in Oracle.


compaq Pentium 133Mhz 128Mb, 6 raid disks if I remember correctly.
two disk failures over the life of the box if memory serves correct.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 5:11 PM
To: Multiple recipients of list ORACLE-L


Now *that's* details.

So, what was the OS version? Hardware? avg/peak
user load?

Let me get this right:  there was ZERO DOWNTIME
in six years?  

my o my

|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:47 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
|| 
|| 
|| I personally vouch for the machine running Novell for 6 
|| years, I built it.
|| It was taken down about 3 months ago.  It happened to be a 
|| server use to
|| store drivers and os builds to zap down to machines as they 
|| are being built
|| at PC manufacture.
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 3:26 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Kim, 
|| 
|| Did you hear the one about the NT box
|| that ran for SEVEN YEARS, playing solitaire?
|| 
|| Yea, me neither, but it's a good story, just
|| like the Novell one. 
|| 
|| :)
|| 
|| 
|| || -Original Message-
|| || From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| || Sent: Wednesday, May 30, 2001 12:36 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: backspace in Oracle.
|| || 
|| || 
|| || Ya, but I can keep a NT box for a long time to, if I 
|| don't touch it.
|| || 
|| || 
|| || -Original Message-
|| || Sent: Wednesday, May 30, 2001 6:01 AM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || I have built Novell boxes that have 2100+ days of uptime :)
|| || 
|| || Now that is stability that I have yet to see even unix have.
|| || Granted it is only Novell 3.12.
|| || 
|| || 
|| || "Walking on water and developing software from a 
|| || specification are easy if
|| || both are frozen."
|| || 
|| || Christopher R. Spence
|| || Oracle DBA
|| || Fuelspot 
|| || 
|| || 
|| || 
|| || -Original Message-
|| || [mailto:[EMAIL PROTECTED]]
|| || Sent: Sunday, May 27, 2001 8:10 PM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || Jared,
|| || 
|| || I have an NT 4 server up for 242 days.
|| || 
|| || Someone where I work suggested it should be sent to 
|| Microsoft for an
|| || examination (must be something wrong with it).
|| || 
|| || Regards,
|| || Bruce
|| || 
|| || -Original Message-
|| || Sent: Saturday, 26 May 2001 12:16 
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || On Friday 25 May 2001 18:26, Weaver, Walt wrote:
|| || > Ditto. I support Jared's backspace claims 100%, and I 
|| || don't think he
|| || should
|| || > be removed from the list.
|| || 
|| || I sure appreciate that Walt!
|| || 
|| || > I've heard there are other operating systems out there 
|| || besides Linux and
|| || > Solaris. Is this true?
|| || 
|| || A nasty rumor.  There's an upstart startup in WA that 
|| claims to have
|| || something akin to an OS, but it keeps failing the 30 day 
|| || stability test.
|| || 
|| || Jared
|| || 
|| || 
|| || -- 
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || -- 
|| || Author: Jared Still
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Reardon, Bruce (CALBBAY)
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (or the name of mailing list you want to be removed 
|| from).  You may
|| || also send the HELP command for other information (l

RE: App/web login - how do you handle?

2001-05-30 Thread Kevin Lange


Our method was as follows:

1. Give each user an ID on the system..  a very limited ID.
2. The ID would  have roles that were given to it but were password
protected .  This way the user could not log into something like SQL+ and
see the tables (it was secured radiation dose level information)
3. The ID was given only select access to a security table.  In this table
was all the information as to what security level the user actually had.
4. Based on this security level, the application would activate the
appropriate roles for the user.  Once these were activated then they could
access the application.

You could just as easily have , based on security level, connected the user
at this point to the application using a different ID.

There are, of course, some drawbacks.

The biggest is that you have to maintain the passwords for the roles.   We
did this via a package that had the password imbedded in it.  

The plus that we needed was to NOT allow the users to see any data unless
they were in the Application.  This was handled very easily with the
password protected roles.


Kevin
-Original Message-
Sent: Wednesday, May 30, 2001 4:27 PM
To: Multiple recipients of list ORACLE-L


How do you handle logins for applications that log into the database
using a common login?  I've seen it handled through hard-coded
username/pass in the app, password file in 'secure' directories and
ops$ account with remote_os_authent set to true on a server being
accessed from a 3rd tier web app.  Mgmt didn't seemed too thrilled when
I showed them in about 2 minutes how to break into the db when
remote_os_authent=true.

Just curious how you handle this.  I haven't seen any particularly
great way and am looking for a better solution.   V7.3.4 -> 8.1.7
databases.

Thanks - Brian

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian Wisniewski
  INET: [EMAIL PROTECTED]

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

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

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

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

About parallel server

2001-05-30 Thread Fernando Papa



Hi everybody!

I have some questions about parallel server. Now we have only one instance
"stand-alone" (no parallel), but we are thinking to switch to parallel
server because we have a couple of sparc 3500 and nobody are using it, and
we think it's good for increase our processing power.

The problem is I didn't work with parallel server and I have a lot of
questions about it:

1) Is mandatory to use raw devices for control files, redo logs & data
files?
2) How we transfer our cooked data files to raw devices data files?
import/export? or exist another better (fast) method?
3) If I start with only one node, performance will be the same of one single
instance (no parallel)?
4) Somebody know how to work with raw devices under solaris? any link? I try
to found someting in metalink but there's no samples...
5) What about backup? I can't put tablespaces in backup mode and copy with
cp... maybe it's time to use rman?

Thanks in advance!

--
Fernando O. Papa
DBA
El Sitio - Infraestructura
(54-11) 4339-3854

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Job remove?