from:"Don Jerman"

Re: Partition Question

2002-11-04 Thread Don Jerman

It depends on your reason for partitioning -- if you mean to drop a partition in
the future (to roll off the 1999 data or whatever) then the ID range is
potentially a valid approach, as long as ID is serial.  If you just want to put
chunks on different disk volumes, you could use the type or even a hash
partitioning scheme.  It's down to what you're trying to accomplish, and what is
good for one partition key is probably bad or neutral for the other.


Hamid Alavi wrote:

 Hi List,

 I have a question regarding partitioning: If I want to partition a table
 which strategy is better, like do i have to use a value which from first day
 of using this table all those partion is using or just using first partion,
 then second etc.
 E.G:
 If I do partion tableA based on ID range 1000, so for few month the only
 first partion of this table will be used then second partion, but if I
 partion it on Type (1,2,3,4,5) any record can be any of these type and from
 first day all of the partions will be used.
 Just want to check with you guys which way is better for performance?
 THanks for HELP

 Hamid Alavi
 Office 818 737-0526
 Cell818 416-5095

 === Confidentiality Statement ===
 The information contained in this message and any attachments is
 intended only for the use of the individual or entity to which it is
 addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
 and exempt from disclosure under applicable law.  If you have received
 this message in error, you are prohibited from copying, distributing, or
 using the information.  Please contact the sender immediately by return
 e-mail and delete the original message from your system.
 = End Confidentiality Statement =

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

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: using obfuscation

2002-09-11 Thread Don Jerman


Sorry, I munged the create view with the query.. I was reminded of a meeting
while typing the note :)

create view my_data as select de_encrypt(sensitive_data) as
clear_sensitive_data, sensitive_data from my_table;

create index  on my_table(sensitive data);

select clear_sensitive_data from my_data where
sensitive_data = encrypt('CLEAR TEXT')

Upon review, it does provide a cyphertext/cleartext attack, doesn't it?  Just
goes to show you -- security is hard.


Steiner, Randy wrote:

 Don,

 It seems like a real good idea, but what am I putting inside my call to the
 encrypt function in my Create View statement?

 Randy

  -Original Message-
 Sent:   Tuesday, September 10, 2002 10:13 AM
 To: Multiple recipients of list ORACLE-L
 Subject:Re: using obfuscation

   File: Card for Don Jerman  What about...

 create view my_data as select de_encrypt(sensitive_data) as
 clear_sensitive_data where
 sensitive_data = encrypt('CLEAR TEXT') ?

 This lets you create an index on the sensitive data without decrypting it,
 and
 the function need only be called once on the clear text.

 Caveat: no idea if this should work :)

 Steiner, Randy wrote:

  Hi all,
 
  I have downloaded the Metalink Notes on implementing dbms_obfuscation. I
 am
  using multiple front ends on the database, so the way I plan to implement
  the de-encryption is with a de-encrypt function in a view.
 
  Create View my_data
  AS
  Select de_encrypt(sensitive_data)  AS sensitive_data
  ,other_data
  FROM original_table
  ;
 
  If I select from the view with a where clause on other_data, the response
  time is fine. If I select from the view with a where clause on
  sensitive_data, I do a full table scan and which takes about 15 minutes.
  The de-encrypt function is copied from a Metalink note, nothing fancy.
 
  Since I have various front ends, I can not de-encrypt the data in the
 front
  end.  The only way I can think of is with the function in a view, but the
  response time is unacceptable.  Does anyone have any thoughts on this?
 
  Thanks
  Randy
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Steiner, Randy
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: Steiner, Randy
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: using obfuscation

2002-09-10 Thread Don Jerman


What about...

create view my_data as select de_encrypt(sensitive_data) as
clear_sensitive_data where
sensitive_data = encrypt('CLEAR TEXT') ?

This lets you create an index on the sensitive data without decrypting it, and
the function need only be called once on the clear text.

Caveat: no idea if this should work :)

Steiner, Randy wrote:

 Hi all,

 I have downloaded the Metalink Notes on implementing dbms_obfuscation. I am
 using multiple front ends on the database, so the way I plan to implement
 the de-encryption is with a de-encrypt function in a view.

 Create View my_data
 AS
 Select de_encrypt(sensitive_data)  AS sensitive_data
 ,other_data
 FROM original_table
 ;

 If I select from the view with a where clause on other_data, the response
 time is fine. If I select from the view with a where clause on
 sensitive_data, I do a full table scan and which takes about 15 minutes.
 The de-encrypt function is copied from a Metalink note, nothing fancy.

 Since I have various front ends, I can not de-encrypt the data in the front
 end.  The only way I can think of is with the function in a view, but the
 response time is unacceptable.  Does anyone have any thoughts on this?

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

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: query problem

2002-08-16 Thread Don Jerman


how about

select  tab1.id from tab1,tab2 where tab1.id=tab2.id group by tab1.id having 
sum(decode(tab2.status,'Y',1,'N',-1,0))  0;

Harvinder Singh wrote:

 Hi,

 we have 2 tables tab1 and tab2 each having id column and tab2 also has column status 
that will contain value 'Y' or 'N'
 for particular id and tab2 has many records for particular id
 we need to select distinct id from join of these 2 tables where status in tab2 has 
more 'Y' than 'N'

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Massive update troubles

2002-08-02 Thread Don Jerman

should being the operative wordthey should be doing the transforms
prior to or during load (in my opinion), since they're file-filter or
file-merge operations mostly.

Bart Cortenbach wrote:

...the SAP requirements are slowly mutating...,
...the developers are still tweaking the process...

If the developpers are still tweaking the process, and the requirements
still evolving, it means that they are still in a test phase.
If they are still in a test phase, they shouldn't use production files but
test files...smaller files.

Don Jerman [EMAIL PROTECTED]@fatcity.com on 2002-08-01 17:14:40

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]

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

I have a data conversion team working on our financial data,
prepping it for load into SAP. My concept for the conversion
process was to download the flat files, run programs written in C
or Perl to transform the data, then use SQL*Loader to load them
into relational tables for constraint testing and general
analysis, prior to export to the SAP system.

At some point early on I lost control, and this mutated into:
download the flat files, load them into Oracle, run stored
procedures to transform the data through 2 or 3 stages to a new
schema for SAP. Still ok, you're thinking.

But -- now we're running more than a couple hundred thousand rows
at the time, and the developers are still tweaking the process
(because the SAP requirements are slowly mutating -- another
issue). Frequently the developers will stop a long running query
with ALTER SESSION KILL -- this is working but often takes a very
long time to roll back. Well, there's the rub -- this is a PC
system, and the developers frequently want to make a tweak to
their program and re-run it. This puts a tremendous load on what
the PC isn't good at -- I/O.

So I wind up with a frantic developer on the phone the Oracle
server's locked up! and sure enough, he's right -- there's so
much going on in there you can't do anything that requires a disk
access. The evolved response is shutdown abort, startup
mount, recover, open. This always works and always takes about 3
minutes. Naturally, I've moved them to their Very Own server, so
that this doesn't disrupt other work.

Can anyone turn their diagonstic eyes on this situation and
suggest a better method for me to either limit the damage or
recover from the problem? Or even a good method for analyzing
the problem, given that we haven't the downtime to wait for all
processes to complete (once in this state, a weekend can pass
without successfully ending whatever the database is doing).

(See attached file: djerman.vcf)

begin:vcard
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Replication

2002-08-02 Thread Don Jerman


Oracle Lite is designed to do this -- the content-deployment part for
standalone applications is a little buggy, but the data deployment and
web-app deployment seems to work.  We're instituting a couple of
applications with this now, and data sync seems to be working fine.
Application sync has been getting most of the attention so far, though, as
we try to get the programs deployed properly without by-hand intervention.

paquette stephane wrote:

 Hi,

 We will develop a new system that has a central
 database (817/win2000).
 From times to times, some users will worked with a
 deployable version of the application in a region
 without network connection.
 When the users are back, there should be able to
 synchronize with the centralized database. The data
 goes from the deployable version to the centralized
 database only.

 What strategies can be considered ?

 =
 Stéphane Paquette
 DBA Oracle, consultant entrepôt de données
 Oracle DBA, datawarehouse consultant
 [EMAIL PROTECTED]

 ___
 Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
 Yahoo! Mail : http://fr.mail.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?paquette=20stephane?=
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Replication

2002-08-02 Thread Don Jerman


Yes that's how it works, although the volume for 2-3 months might be
excessive, if the deltas get large.  Light uses Advanced Replication to
manage the deltas so the resolution process might take a while.

paquette stephane wrote:

 Hi,

 Oracle Lite would not be good for us as when I said
 users are working with a deployable version, I mean a
 bunch of users go away with their server/database and
 come back 2-3 months after, then they synchronized the
 master database.

  --- Don Jerman [EMAIL PROTECTED] a écrit : 
 Oracle Lite is designed to do this -- the
  content-deployment part for
  standalone applications is a little buggy, but the
  data deployment and
  web-app deployment seems to work.  We're instituting
  a couple of
  applications with this now, and data sync seems to
  be working fine.
  Application sync has been getting most of the
  attention so far, though, as
  we try to get the programs deployed properly without
  by-hand intervention.
 
  paquette stephane wrote:
 
   Hi,
  
   We will develop a new system that has a central
   database (817/win2000).
   From times to times, some users will worked with
  a
   deployable version of the application in a region
   without network connection.
   When the users are back, there should be able to
   synchronize with the centralized database. The
  data
   goes from the deployable version to the
  centralized
   database only.
  
   What strategies can be considered ?
  
   =
   Stéphane Paquette
   DBA Oracle, consultant entrepôt de données
   Oracle DBA, datawarehouse consultant
   [EMAIL PROTECTED]
  
  
 
 ___
   Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
  et en français !
   Yahoo! Mail : http://fr.mail.yahoo.com
   --
   Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
   --
   Author: =?iso-8859-1?q?paquette=20stephane?=
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051
  FAX: (858) 538-5051
   San Diego, California-- Public Internet
  access / Mailing Lists
  
 
 
   To REMOVE yourself from this mailing list, send an
  E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
   the message BODY, include a line containing: UNSUB
  ORACLE-L
   (or the name of mailing list you want to be
  removed from).  You may
   also send the HELP command for other information
  (like subscribing).
   begin:vcard
  n:Jerman;Don
  tel;work:919.508.1886
  x-mozilla-html:TRUE
  org:Database Management Service,Information
  Technology
  version:2.1
  email;internet:[EMAIL PROTECTED]
  title:Database Administrator
  adr;quoted-printable:;;Database Management
  Service,Information Technology=0D=0A104 Fayetteville
  Street Mall;Raleigh;NC;27699-1521;USA
  x-mozilla-cpt:;-9536
  fn:Don Jerman
  end:vcard
 

 =
 Stéphane Paquette
 DBA Oracle, consultant entrepôt de données
 Oracle DBA, datawarehouse consultant
 [EMAIL PROTECTED]

 ___
 Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
 Yahoo! Mail : http://fr.mail.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?paquette=20stephane?=
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Replication

2002-08-02 Thread Don Jerman

Light works with a 9ias application (part of the Light package) to establish
the mobile database and application on the mobile client. Once the
application and database are downloaded, the database uses Advanced
Replication to sync with the master when the clients are brought back to the
network. While mobile, Light emulates the oracle server (and potentially the
9ias server) for a single user.

You have a master database server connected to the mobile data server (9ias)
which handles the interface to the mobile clients (laptops, desktops,
what-have-you). Up to 64 mobile clients per mobile server, if I remember the
marketing speil right, but we're still at the 4-client dev/test phase.

We have staff working on it, with assistance from an Oracle consultant brought
in for the purpose. I just deal with the master database.

Since we're doing stand-alone, we have to hand-jar the java applications (the
jar wizard with Oracle Developer doesn't fit the bill somehow) so application
deployment is the sticking point at the moment. We might get an answer this
month, but the dev manager is doing the schedule and application details.

My understanding is that if you deploy a JSP web app using 9ias, the app can
be downloaded and run on the mobile client against the Lite database, and that
sort of deployment appears to run smoothly (the examples work). But we're not
doing that in this case so I have no real-world experience there.

Ramon E. Estevez wrote:

Don,

What are you using for deploy the applications ??

I am interested in this topic too.

Ramon

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 10:33 AM

Oracle Lite is designed to do this -- the content-deployment part for
standalone applications is a little buggy, but the data deployment and
web-app deployment seems to work. We're instituting a couple of
applications with this now, and data sync seems to be working fine.
Application sync has been getting most of the attention so far, though, as
we try to get the programs deployed properly without by-hand intervention.

paquette stephane wrote:

Hi,

We will develop a new system that has a central
database (817/win2000).
From times to times, some users will worked with a
deployable version of the application in a region
without network connection.
When the users are back, there should be able to
synchronize with the centralized database. The data
goes from the deployable version to the centralized
database only.

What strategies can be considered ?

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: [EMAIL PROTECTED]

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

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

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

Massive update troubles

2002-08-01 Thread Don Jerman

Re: SMP on windows2000

2002-07-24 Thread Don Jerman


My understanding is according to design it should do it automatically.  My
experience is it does, sort of.  But the app has to be multi-threaded (by the OS
definition, not just context-mapped like Java green threads) for it to ever use
more than one processor at the same time.  If your single-threaded then for
obvious reasons NT will tend to give the next time-slice to the same processor
if it's not busy, so it looks like you're stuck on the same one much of the
time.

With the task manager you can set processor affinity on MP machines from the
right-click menu of the process.  This limits which of the N processors will be
used to schedule your process.  So you can limit one processor hog to 1 or 2
processors and let the well behaved programs run freely on the others.  I don't
know how to do this using non-gui tools or to set it up at start time, and your
userid has to have permission to do it (essentially you have to be running as
the process owner).  But it's a starting point for research :).


Boivin, Patrice J wrote:

 I am probably just complaining now, I think I know the answer already.

 Is it possible to force Windows2000 to spread the load for one application
 to 2 or more CPUs, from the OS side?

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

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

 E-Mail: [EMAIL PROTECTED]

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

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Locally managed tablespaces

2001-07-20 Thread Don Jerman


That's kind of the point -- in an LMT the free space is managed by bitmap.  If
it's contiguous in the bitmap it's contiguous, so if you free two adjacent
blocks then they're already coalesced, nothing for SMON to do.  That's their
advantage -- no overhead for coalesce and no overhead for creating dictionary
rows to manage free space.

Saurabh Sharma wrote:

 consider this also..
 if u make a tablespace as LMT, the SMON process is not going to coalesce it
 automatically..
 as it in the case of dictionary managed TS.

 if i'm wrong.. pls correct.

 Saurabh Sharma

 [EMAIL PROTECTED]
 http://www.geocities.com/saurabh00pc/stride.html

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, July 20, 2001 5:16 AM

  Yes, you can make any tablespace a locally-managed tablespace except
 SYSTEM.
  What they're saying, I think, is that you can't set up temporary
 tablespaces
  and shouldn't set up rollback segments with the AUTOALLOCATE allocation
  management.
 
  Jon Walthour
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, July 19, 2001 4:32 PM
 
 
   I was pretty sure you could use it for any TS but SYSTEM. Is this
  documented?
  
   Cheers,
  
   Earl
  
   ---
  
   TheOracleDBA
   [EMAIL PROTECTED]
  
  
  
   On Thu, 19 Jul 2001 09:32:27
Hillman, Alex wrote:
   You canuse any storage parameters you like but oracle will ignore them
  exept
   for initial for LMT with autoallocate. I would personally do not use
   autoallocate. Also you cannot use autoallocate for temporary tablespace
  and
   shouldn't use it for rollback.
   
   Alex Hillman
   
   -Original Message-
   Sent: Thursday, July 19, 2001 12:43 PM
   To: Multiple recipients of list ORACLE-L
   
   
   HPUX 11i 64 bit
   Oracle 8.1.7.1 32 bit
   
   I am creating a new database and decided to go with locally managed
   tablespaces.  I was going to go with autoallocate because the best I
 can
   tell the only possible drawback with this is a little wasted space.
   However, I was under the impression that you could not specify a next
 in
  the
   storage clause of a table creation.  Yet you can.  So what happens if I
  have
   a next defined?  Do they pretty much just throw that away or should I
  really
   not define it?
   
   
   
   
   Kimberly Smith
   Database Administrator
   IT Dept. - Fujitsu/GMD
   Phone: (503) 669-6050
   Fax: (503) 669-5705
   Email : [EMAIL PROTECTED]
   
   --
   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: 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).
   
  
  
   Get 250 color business cards for FREE!
   http://businesscards.lycos.com/vp/fastpath/
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: The Oracle DBA
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like subscribing).
  
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Jon Walthour
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing

Re: Problem connecting to a db

2001-07-17 Thread Don Jerman

If the person's account is a member of the local NT group ORA_DBA they should be
able to follow this procedure from the server console:

- set ORACLE_SID=SID
- sqlplus /nolog
- connect internal/internal_password

I've had 8.1.5 ignore incorrect or missing passwords when I use this feature so
I always empty ORA_DBA except when I want to use it. That way (since instances
have different passwords) I don't get into the wrong instance by mistake. It
may now detect invalid passwords for ORA_DBA memebers but I've not had a reason
to change the procedure...
If they aren't able to get in that way or they're not at the server console they
should be able to:

- sqlplus /nolog
- connect internal/internal_password@service_name

... assuming the listener is running on the server and everything's correctly
configured.

If neither works then:
- verify that in the init.ora file you've configured remote_login_passwordfile =
exclusive
- verify in listener.ora that the service is correctly configured, and that
you've used the same SID and service names in the procedures above.
- verify that TNSNAMES.ORA or whatever naming method you use is configured
properly for the service.
- run ORADIM -edit -sid sid -intpwd newpassword at the console to reset the
internal password to something you know.

I've not had to go farther than this, so from there on you're on your own :-).

Steven Hovington wrote:

I have someone on a remote site who is having problems connecting to a db in
server mgr as internal.
connect internal should work, but it replies with insufficient privileges, I
must be missing something.

Does anyone have a suggestion what this could be?

OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as
administrator.

Thanks,

Steven.

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

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

Re: LISTENER port issue

2001-07-17 Thread Don Jerman


%SYSTEMROOT%\system32\drivers\etc\services

However, I'm not sure if the OS pays as much attention to this file as unix
systems do.

Seema Singh wrote:

 I want to know which file is equivalent in WIN2000 to /etc/services in unix.

 From: Rodd Holman [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: LISTENER port issue
 Date: Tue, 17 Jul 2001 10:05:58 -0800
 
 Need to change tnsnames.ora for aliases that reference that listener.  If
 not using ONS, need to make this change on each client's tnsnames.ora
 also.
 
 Rodd
 
   Original Message 
 
 On 7/17/01, 12:11:45 PM, Seema Singh [EMAIL PROTECTED] wrote
 regarding LISTENER port issue:
 
 
   Hi Gurus
 
   Normally the listener use 1521 port.I want to change other port like
 1524.I
   make change on listener.ora file.Is is required to add entry 1524 into
 other
   file.If yes,then which file on WIN2000 OS.
   Thanks
   -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).
 --
 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).

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: OT: Re: Oracle Internet Directory

2001-07-17 Thread Don Jerman


Last I checked the license that comes with Enterprise Edition was free solely
for the purpose of implementing Oracle services such as Portal, naming and
database logins.  If you want to use it for anything other than support of
the included Oracle software, you have to pay extra.  IIRC full use is
available with the 9iAS license.  But of course, terms of the offering vary
over time -- contact your sales rep to be sure.

Richard Ji wrote:

 Sorry for the OT question.  Is OID free if I have the Enterprise license?
 if not, how much is it?  I can't find pricing for it on oraclestore site.

 thanks for any help.

  [EMAIL PROTECTED] 07/17/01 12:50PM 
 Check if the schemas ODS and ODSCOMMON exists.

 Regards.

 --- [EMAIL PROTECTED] wrote:
  Hello All.
 
  I have a problem in starting my ldap server
  instance.
   I have created a database say OIDB2 using UTF8
  character set.
   Oracle internet Directory already installed in my
  oracle home.
   I started OID monitor after setting environment
  variable
   NLS_LANG=AMERICAN_AMERICA.UTF8,
 using command oidmon connect=oidb2 sleep=10
  start. It started
  successfully.
   but when i tried to start ldap server instance
  using command  (oidctl
   connect=oidb2 server=oidldapd instance=5 start)
   i received error message ---[gsdsiConnect]
  ORA-1017, ORA-01017:
   invalid username/password; logon denied
 
   I am stuck with this now.
 
   Please help me to come out of this problem.
 
   Thanks and Regards
 
  Vinay
  --
  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).

 =
 Eng. Christian Trassens
 Senior DBA
 Systems Engineer
 [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 Phone : 541149816062

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Richard Ji
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: How to precreate tables for migration?

2001-07-05 Thread Don Jerman


As I impose order on our servers, (moving from project-managed to dba-managed
db's) I perform this sort of task for individual schemas.  The short form is the
same as yours except:

3.5) create schemas where tables or tablespace assignments will change.
4.5) create tables that are to have storage parameters different from the
source.

... and ...

5) import using IGNORE=Y parameter

Imp fills the tables as they exist, or creates them using the info in the export
file where they do not exist.  After all, if you're migrating all the tables you
pre-created should be clean at the beginning, so you won't get duplicate rows
and DESTROY is hardly necessary.  One caveat -- IIRC you don't need to create
all the tables, but you must create all the tablespaces in order to use this
method.  Or this could be a local effect as my new servers have different data
file paths.

It is useful to compose the creation in scripts, and compose a script to destroy
the structures, in case your new storage parameters are flawed somehow and the
import ends badly.  That way you can iterate more easily.  In my shop we move
off the old server and into a test server first, then when the iterations are
done I can replicate the refined procedure for production.  In a few cases the
project managers failed to move the db to production when they went live, so we
move to different schemas on the same server first, then drop one and move the
data (and client connections) to production.


Jesse, Rich wrote:

 So,

 We're taking the leap from 8.0.6 to 8.1.7.  For various reasons, we will be
 using the export/import method of migration.

 Since I'll have the DB all to myself for the weekend, I want to also
 partition most of our larger tables (1M-7M rows each -- it's not a huge DB)
 in the migration.  My plan to precreate the tables was to:

 1)  Export DB.
 2)  Create new 8.1.7 DB.
 3)  Create tablespaces.
 4)  Create partitioned tables.
 5)  Import DB.

 (I've left out many migration steps not pertinent to this question)

 Obviously, step 4 can't go before step 5, as step 5 creates the schemas.

 So, my questions:  Has anyone precreated tables before a full import on a
 clean DB?  Did you just manually precreate the schemas?  How does the import
 deal with this (e.g. the DESTROY arg for imp)?  Or would it be OK to skip
 step 4 and delete/rebuild the tables to be partitioned after the import had
 rebuilt them?  I would prefer not to do the latter, seeing as this will be
 the first time in three years that the TSs will be nice and contiguous.  :)

 Also, for brevity, we won't be going LMT for most of our TSs.  Need too much
 time to plan for that...  :(

 TIA!

 Rich Jesse  System/Database Administrator
 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: NT4 - ORA 8.0.5 - NT4

2001-06-29 Thread Don Jerman


See ch. 10 of the PL/SQL programmers guide -- external procedures.

Summary: someone needs to write a DLL that executes the external program,
then Oracle can call the function from the DLL from a PL/SQL procedure.
I've never had the nerve to put that in a procedure, however, but the
context indexing is done that way so it must be possible :-).

Allen R. Lucas wrote:

 We have Oracle 8.0.5 in NT4.0.

 A developer asked if an Oracle trigger can be used to kick off an
 executable.  Looking in my books, I would have to assume 'no' as I find
 noreference to this, but can anyone verify I am wrong, and where could I
 get addiional information  if I am wrong?

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

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: JDeveloper Connection to Oracle DB

2001-06-27 Thread Don Jerman

JDeveloper may not have installed in the same oracle home as your regular
Oracle client, first see if you have more than one Oracle home directory
on your computer, either by checking the registry under
HKEY_LOCAL_MACHINE/Software/Oracle or by searching for the TNSNAMES.ORA
file. Then ensure that the TNSNAMES.ORA files in all those directories
contain an entry for the database you're trying to test with, and that the
SQLNET.ORA files agree. Then ensure that you can connect to the databse
with SQL*Plus. If you still can't connect using the existing TNSNAMES
method, try entering the host, port and SID instead. ( I see you did some
of this already, but the mutiple homes thing changes the problem)

Finally, give up and call Oracle Support ;-).

Elias Mouchantaf wrote:

Hi again,

I would like to clarify the problem once again since it
seems that I might have left some details out. I have
installed JDeveloper 3.0 and I am running Oracle
8i personal edition on a Windows 98 platform. I am
trying to create a connection to the DB from
JDeveloper. I specify the Oracle JDBC Thin as driver
since I need to use applets, and I select Existing TNS
Names as the connection method and I choose the
service running. When I click on the Test Connection
button I get an error message that reads: Io
exception: The Network adapter could not establish the
connection.

I tried to resolve the problem but was unable to. I had
the listener started using the command: lsnrctl start.
I am able to ping the server. There are no firewalls
invovled. According to the documentation, the Thin
driver uses the sqlnet. I tried using the IP address
instead of the TNSNames and I still got the same error
message.

I would appreciate any help.

Thank you,

Elias S. Mouchantaf
Tel. (+961) 3 740319
[EMAIL PROTECTED]
www.moshnet.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Elias Mouchantaf
INET: [EMAIL PROTECTED]

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

Re: Database slowdown after 100 days uptime

2001-05-29 Thread Don Jerman


Keep an eye on free memory -- one of our similar systems has to be restarted
every 60 days to prevent the behaviour you're encountering.   We haven't
determined the source of the memory leak, but if we permit it to continue
eventually the DB stops responding and cannot be shut down.  This system does
some analytical work for us so it has different connection and activity
profiles than the others, so I've a limited basis for comparison, but the other
8.1.5 databse (this one's data source) shows similar problems over a longer
period.
My plan is to take it up to 8.1.7 as those systems are not showing that sort of
problem.
Reardon, Bruce (CALBBAY) wrote:

 Hi,

 We're running Oracle 8.1.5.1.1 on NT 4.

 On Saturday our database started getting much slower
  - to me, there didn't seem to be any major events showing up in
 v$session_wait, v$session_event

 Restarting the database instance and service solved the performance
 problems.

 Today, when reviewing logs of the queries I noticed that the database had
 been up for 100 days when it started slowing.

 The 100 days uptime may be unrelated, but has anyone seen this behaviour on
 any platform?

 For information, the server itself has been up for 242 days (240 days when
 the problem started occurring).

 Thanks,
 Bruce Reardon
 mailto:[EMAIL PROTECTED]
 --
 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).


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Problem with many (160 - 170) sessions in the database on NT

2001-05-29 Thread Don Jerman

You should consider running MTS or buying more RAM (if you want to run MTS you
probably need to get to 8.1.7.2 first -- I don't remember its status as of 7.3.4
but in the 8.0 and 8.1.pre-7 series it appears to be unreliable).

Your problem is probably this: of the 1.7G RAM you really only have about 0.5G
available to Oracle, as NT swallows half your RAM for the operating systems' use
and then runs services in user-space. If you upgrade to 4GB of RAM and run NT
Enterprise Edition you can swing the dividing line and get 3GB for Oracle and
1GB for NT, but otherwise you're stuck with half your RAM for Oracle to share
with all the other running programs.

I recognize that sometimes we have to run NT because the shop says so, but if
you do you have to buy the best box you can get. If you can't get a better one,
or you want to make more efficient use of what you have, I must agree with Dick
-- learn Unix instead.

Jonas A Wetterberg wrote:

Hello

We are running into a little problem with an Oracle installation. The server
OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server
have 4 processes, we have about 1,7 G primary memory and about 2 G of memory
on swap disk. We have 4 processes in the machine. One of these is reserved
for the OS, and Oracle uses the other 3.

We we reach around 170 sessions in the database, the database sometimes goes
down and we have to perform a restart. The 3 process Oracle use are all at
about 100% in task manager. The memory use is somewhere around 1,3 G. Then
we can run the database for aboout 4 more hours, then we have to restart.
Sometimes we have to restart around lunch everyday.

Now I have heard the Windows NT have a limit of how much memory one process
might use, and that limit is somewhere around 1,7 G, and that that might be
our problem.

We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise
Edition or to Windows 2000 Advanced Server. Does anyone know if this can
help? Should we put more memory or more processes in the machine?

Any help is appreacheated

Regards

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

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

Re: Need oracle patch 8.1.7.1.1

2001-05-08 Thread Don Jerman


I must be going blind -- I search for the patch and the latest I find is 8.1.7.0.2 ... 
could you provide the ID number and/or a working
method to find the .1.1 patch for NT?

The Oracle DBA wrote:

 I guess you are not on NT because the .1.1 patch is there. The std procedure for 817 
is to install 817, patch it to .1.1 then .1.2.

 Cheers,

 Earl

 ---

 TheOracleDBA
 [EMAIL PROTECTED]

 On Fri, 04 May 2001 10:31:23
  Shaw, John B wrote:
 I just downloaded patch 8.1.7.1.2 from metalink -
 in the readme (yes I actually read it before installing )  it states that
 the earliest version that this patch may be applied to is
 8.1.7.1.1 - I can't find this patch on metalink
 anybody know where I can get it?
 
 
  . .-..  .--.  .. ...- .  -... . . -.  .--. .-. --- -... . -..
 John B. Shaw
 Intergraph Public Safety
 mailstop LR24A4
 [EMAIL PROTECTED]
 256-730-8038
 All the usual disclaimers and some of the certifications
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Shaw, John B
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: The Oracle DBA
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: OT -- MS makes a statement about open-source software movemen t

2001-05-04 Thread Don Jerman


Don't forget breaking up common industry design standards like incompatible
data requirements for Kerberos implementations and the use of the latest COM+
for all IPC -- you know -- the ones that require you to buy and run Microsoft
products ;-).

David Messer wrote:

 Sounds like MS is afraid Open Source Software (OSS) will undermine MS.  Hard
 to imagine a big company like MS being upset that it's competitors are
 selling ``flimsy,'' ''flawed,'' products that might 'jeopardizing property
 rights'.

 David

 -Original Message-
 Patrice J
 Sent: Thursday, May 03, 2001 2:22 PM
 To: Multiple recipients of list ORACLE-L
 movemen t

 http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html
 http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html

 Let me know what you think.

 : )

 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] mailto:[EMAIL PROTECTED]

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

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

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

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: 9iAS -- Boxes on which to run

2001-04-17 Thread Don Jerman

My experience is that 9iAS requires 1G RAM to run well. More if you want
IFS... Given that the typical inexpensive Intel box is capped at 4GB and
Microsoft won't let you use more than 3GB (2.5 realistically) on a 4GB machine,
or half of your real RAM if you have less than 4GB, and that a typical Oracle DB
will want 1 or more GB to perform well, you're out of RAM before you start.
Blame it on the JVM...

"Eric D. Pierce" wrote:

On 13 Apr 2001, at 17:12, [EMAIL PROTECTED] wrote:

To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Date sent: Fri, 13 Apr 2001 17:12:54 -0500

And where did you get the info on 8.1.7 and Forms Server not being able to
be on the same NT / W2K machine?

Oracle tech support. They were clear (my recollection of
verbal phone conversion) that as of 8.1.7, "middle tier"
stuff would not run on the same NT server box as the database.

They said that I needed to read the (latest?) "middle tier"
white papers to understand the new (as of 8.1.7) "middle
tier web architectural" issues, which they said are
"complex". :) Unfortunately I haven't had time yet.

This was in the context of a conversation about a new Win2k
server that we are setting Oracle8 up on, and I wanted to
know if it was still going to be possible to run the next
equivalent to WebDB on the same box as the database. I then
siad that it sounded like I was going to have to convert our
old Netware3 server to NT (Win/2000) in order to test the
8.1.7 and later "middle tier" web stuff. They said that was
correct. so, it was specific answer, not just some general
info.

Since the documentation you have apparently doesn't cover
the issue, you probably ought to call Oracle tech support.

I am about to try to install 9iAS on my W2K
box at home. I already have 8.1.7 EE, Forms 4.5/5.0/6i, and tons of other
stuff installed. I've read through the install guide, the various release
notes, etc and never came across that. But, if it is so, I don't intend to
waste a perfectly good day trying to get things to work.

ya.

please let me know what you find out.
ep

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

Re: server sizing

2001-04-17 Thread Don Jerman


And I'm just in the mood for a ramble, too...

We stayed with NT too, because we have the sysadmins and engineers already.  I
have a DB that sounds a lot like yours and it's running just fine on a dual p400
with a mirror for redo and archive log and a raid5 for the data files.  The real
problem with NT is the memory cap.  I couldn't get 4GB at the time of purchase,
so we can't use Enterprise server to skew the memory divide, and NT is gobbling
up half of my 2GB server.  That's fine for  100 users, but as we edge up we're
having to reduce buffer cache to avoid paging, which is bad (although admittedly
it's not affecting performance yet).  When the buying freeze lifts I'll
recommend the 4GB upgrade.  It wouldn't be so bad, except I had to install the
Java engine for this one, and it's taking a good quarter gigabyte.

I haven't found the RAID5 to be an operations hazard, though, except in
maintenance tasks.  Large imports, tablespace reorgs, index rebuilds and
sweeping updates suffer but so far the small stuff the application sends in is
absorbed by the cache and runs just fine.  Of course I'm only running about
10-20 write transactions a minute on the DB in question.  If that picks up I'll
be back to the funding well for more external arrays.

I (personally) would just buy more or better equipment if I needed the small
boost that raw partitions would give -- I like the hardware RAID and the OS
backup utilities too much to go the raw route.  Using more volumes is still a
good idea, if you can get them on different controllers, but for goodness' sake
don't bother partitioning a RAID.  More than 2 channels on a controller may
challenge your cache size or bus speeds, so multiple controllers is still a good
idea if you can saturate 2 channels.  Raid 0+1 makes a difference over raid 5 if
you have room in the rack for that many drives, and I'll certainly be doing that
if the projects that want the SAN pan out.  I keep everything redundant (no
raid0) on this class of box, though -- too many things can go wrong, and losing
your redo log volume takes your database down.

That reminds me of a story -- Last month one of my engineers noticed a warning
light that indicated one of the redundant power supplies in a storage array had
gone out.  He jiggled the power cable.  It was the wrong one...  The database
files were taken offline by that, but it was night and the DB was quiet and
fortunately that array had only half of the OS/logging mirror for that server,
so Oracle recovered after a quick shutdown-replace-reboot cycle.

You specified an upper bound of about 2 transactions per second, which should be
doable with an NT system with 300 users.  If you go much beyond 300 - 500,
however, you'll probably start running into memory/networking performance limits
on NT.  In general, you should consider UNIX systems for optimum performance.
NT has too many little gotchas like the lack of memory and process control.
Some, like limits on total memory and practical problems with number of
controllers, are related to the Intel architecture so you'll need to look past
Linux, although Linux can be a good half-step when your NT boxes start
underperforming.  In moving to Linux you'd get more available RAM and less OS
overhead, but you'll have to completely re-learn system administration and then
do it again (incrementally) when you hit the architecture limits, as Linux on
other-than-intel architectures is not supported by Oracle.

So if there's money I'd look at starting on NT since it's an easy step up, but
plan on developing or buying some Sun engineers (or HP, or other) by the time
you're ready for those upper limits. They can take you to Ludicrous Speed, but
for us mere mortals NT is a good starting point.

"Streeter, Lerone A LBX" wrote:

 I'm envisioning various levels of raid just wanted to get something out
 quick for some feedback.  for example, I'm thinking the data files, redo
 logs, arc log, and control files would be on differently combined disks.

 of course some file system recovery and redundancy is desired, but to what
 level should we go?  currently we've got a raid1 set w/ O/S and documents,
 raid5 with hot spares for our existing mssql DB, and the logs on separate
 raid5 set; wanted raid1 for mssql logs but other issues arose and we had to
 go w/ raid5.  this is very functional and suits our needs, failure coverage,
 low processor utilization, etc.  but with oracle I'd be very worried about
 running on a similarly built platform.

 I didn't even mention raw partitions, which were stressed as being a better
 scenario.  they offered the suggestion of multiple controllers with database
 files spread across drives and controllers, this method of "striping" being
 an alternative to raid.  I wasn't too comfortable with the thought of a
 server w/ raw partitions and no hardware redundancy/recovery implementation,
 but the performance/functionality benefits were highly praised.  so I
 thought maybe a mix, some raid10 or 01.

Re: oracle training

2001-03-23 Thread Don Jerman


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


james ellis wrote:

 dbbasics and New Horizons offer Oracle training in NC.
 DBbasics is in Raleigh and Greensboro. New Horizons is
 located in Greensboro. It may be in other cities as
 well.

 Hope that helps

 --- "Streeter, Lerone  A LBX"
 [EMAIL PROTECTED] wrote:
  aren't there some people from north carolina here?
  know any local, in
  state, oracle training outfits?
 
  ===
  Lerone Streeter
  System Analyst
  Abbott LBG
  [EMAIL PROTECTED]
  ===
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Streeter, Lerone  A LBX
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 
 
  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be removed
  from).  You may
  also send the HELP command for other information
  (like subscribing).

 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail.
 http://personal.mail.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: james ellis
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: EE on NT problem (on and off network) ???

2001-03-13 Thread Don Jerman


Try turning off DHCP when off the network -- set up a bogus net address
like 10.0.0.1 or something and Oracle will happily talk to itself.  TNS
bombs because DHCP (actually TCP/IP) reports no address.

Leslie Lu wrote:

 Hi all,

 I installed 815 EE on NT 4.0 on a laptop and created a
 testing database (did both while I was on network.)  I
 can connect to the database without problem, while
 remain on network.  However when I'm off the network,
 I cannot connect to the database. I got:

 ora 12570: TNS: packet reader failure
 ora 12571: TNS: packet writer failure

 It's a demo project for marketing people, and most
 probably they might not be able to connect to the
 network (in the plan or on the beach).  So I really
 need the db to run locally.

 Any idea,  thanks a lot.

 Leslie

 __
 Do You Yahoo!?
 Yahoo! Auctions - Buy the things you want at great prices.
 http://auctions.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Leslie Lu
   INET: [EMAIL PROTECTED]

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Does NT write to random locations on disk?

2001-03-12 Thread Don Jerman

If you created it using the Database Assistant, it created a bunch of strangely
small data files with autoextend turned on. When the file autoextends, it grabs
the next free hunk of disk, of whatever size you set it to grab. Whether
something else is creating ephemeral files that cause these fragments to be
separated or what, I can't say -- but all you need to do to defrag is:

1) shutdown the database, so that all file locks are cleared
2) back up :-)
3) run your defrag utility, or format the disk and restore from backup :-)
4) startup the database

Voila, the files are defragged -- for now. If you want to keep them that way
you probably want to turn autoextend off and resize the files prudently before
taking the time for this procedure, and create new files as needed at a set
size, rather than use autoextend.

But it probably doesn't matter -- NT likes files to be defragged, but if you are
actually reading random disk-blocks anyway contiguous files won't do a lot of
good. If you do a lot of full table scans it will help a bit, if you also
defrag your tablespaces. It will also help if you have a lot of free space
between the fragments (you won't have to fly over it afterwards), but not much
if your disk is mostly full (you didn't say if 1.2G is 80% or 8% :-).

"Boivin, Patrice J" wrote:

Using a little utility called contig I noticed that the Oracle 8.1.6
datafiles on my test NT server are quite fragmented, an average of 177
fragments per file, 118 fragments for the OEM repository datafile. The poor
utility couldn't do anything with the database files, they are too large
perhaps.

These were created on an empty server, 8i release 2 went on it after a
defrag, then the OEM. This is on a hard disk with 1.2G of free space, none
of the datafiles come close to that.

Why so many fragments? Oracle created those files in one pass, does NT
write randomly to disk or what?

Won't this have an impact on my NT database's performance?

Oracle says tablespace fragmentation is not a big deal, but fragmentation at
the OS level matters. Supposedly that's why NT and WndowsXX came with
defragmentation tools.

???

Is there a registry setting somewhere to tell NT to write contiguously to
disk?

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | Rgion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

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

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

Re: Oracle Licensing

2001-03-07 Thread Don Jerman


The disk packs (probably still) come with 60 day trials for everything you
didn't buy.

Alternatively, if you have 10 developers, you could buy a 15-user license for
your developer  test machine (10 devs + you, your assistant, your operator and
a couple spares in case you expand).   The software works the same no matter how
you licensed it.

You should buy support for everything, just in case.  Hard to explain to
management/stockholders why you didn't when the servers are down ;-).

Yes it is expensive if you have a "real" client-test setup where you can run in
parallel with production, but heck, that's what vendor negotiations are for :-).




Steve Orr wrote:

  NOT happy making for the DBA (me)

 Yeah, what if you needed a "temporary install" on a new machine to test
 something? Am I really expected to get a license for a temporary install?
 Suppose you want to test some UNIX parameters and you can't use the
 "Development" or "QA" servers? (Not to mention production:-) Software locks
 just complicate things. Can't we still keep "the spirit of the law" without
 being subjected to draconian measures to enforce licensing?

 How do you "setup shop" for licensing and support? Say you have 3 fairly
 equal servers for Development, Test, and Production. Each server is
 basically the same: same manufacturer; same hardware; same O/S version and
 patches, same Oracle version, etc. OK, maybe your production machine has
 four times the CPU and memory and a 1000 times more connections. How do you
 license and support these machines? An ORA-00600 or ORA-07445 on one machine
 "should" occur on the other machines for the same reasons with the same
 causes and producing the same effects/symptoms. Do you buy support for all
 three machines or do you just buy support for a smaller machine and apply
 patches across the board? What are the fine print legally correct answers
 versus the ethically correct practices in the real world? Is there a
 distinction? I can imagine what the answers would be if Oracle included
 these questions on the OCP tests. ;-)  What do you say?

 Comments and confessions anyone? Feel free to email me privately.

 Steve Orr
 [EMAIL PROTECTED]
 www.arzoo.com

 -Original Message-
 Carmichael
 Sent: Tuesday, March 06, 2001 9:46 AM
 To: Multiple recipients of list ORACLE-L

 Ingres used to do that for expiration date... you had to enter an
 authorization string when you installed the database. It would check and
 refuse to come up if the software expired.

 Except they

 a) never warned you you were close to expiration
 b) usually shut you down around 10AM EST so people who had logged in earlier
 could work
 c) were a pita about sending a new string

 you had to shut down production in order to apply the new string.

 NOT happy making for the DBA (me)

 Rachel

 From: Dennis Taylor [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: Oracle Licensing
 Date: Tue, 06 Mar 2001 07:40:43 -0800
 
 At 03:35 AM 3/6/01 -0800, you wrote:
  my .02 is the whole power unit thing is a good concept but the $$ per
  unit is way outta whack.  the only reason i say that is its been hard
  for oracle to denote when people were using more than the licenses they
  bought were being used.  I had always setup the databases with the
  v$license parms setup in the database. But sometimes damagement
  "required" me to "uplift" the limits.  We'll leave it at that.
  
 
 I've always been very surprised that Oracle didn't put some kind of
 licensing enforcement in their software. They're the perfect situation for
 it -- High ticket, relatively low volume. They could afford to "brand" the
 software before sending it to the customer. I bet they'd more than make up
 enough revenue to be able to drop their prices to something non-lunatic.
 
 
 Dennis Taylor
 
 In any human endeavor, once you have exhausted all
 possibilities and have failed, there will be one solution,
 simple and obvious, highly visible to everyone else.
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Dennis Taylor
INET: [EMAIL PROTECTED]

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

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1

Re: No record in import help me please :..(

2001-03-05 Thread Don Jerman


You need to add

FROMUSER=TEDDY
TOUSER=TEDDY

to your parameter file and try again.

[EMAIL PROTECTED] wrote:

 Hi guys,

 1. In my Oracle I have accounts : - teddy/bear (normal user can create)
   - sun/solaris (granted DBA role)

 2. I run the catexp.sql using sys account (just one error occur
 IMP_FULL_DATABASE confilct)

 3. TEDDY created a table EMP with 7 records

 4. I am using Sun account to export teddy table:
 inside my params.dat :
 FILE=/export/home/dba/myemp.dmp
 TABLES=(teddy.emp)
 ROWS=Y
 GRANTS=Y
 COMPRESS=Y

 I export with this params.dat :
 exp sun/solaris parfile=/export/home/dba/myemp.dmp

 I've got messsges :
 . . exporting table  EMP 7 rows exported

 5. I check the file is exist and with
 -rw-rw-rw  1  dbadmin  3072 Mar (time)  myemp.dmp

 6. I chmod a+x myemp.dmp

 7. teddy delete emp table :
 delete emp
 7 rows deleted

 8. when as sun I try to import :
 inside my imp_params.dat :
 FILE=/export/home/dba/myemp.dmp
 SHOW=Y
 IGNORE=N
 GRANTS=Y
 ROWS=Y
 DESTROY=Y
 COMMIT=Y

 I import
 imp sun/solaris parfile=imp_params.dat

 9. the messeges that I got :
 ...
 ...
 .skipping table "EMP"

 ...
 ...
 ...
 ...
 Import terminated successfully without warnings.

 10. When teddy select * from emp;
 0 rows selected

 Can someone help me please... please ???  :(

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: ORACLE_ON_NT !!!!

2001-03-02 Thread Don Jerman


For the Oracle database to -run- the OracleServiceTEST (created with the
oradim80 command below) must be running, so I infer that you're missing the
OracleStartTEST service.

You can try:

oradim80 -edit -sid SID -intpwd PASSWORD -startmode AUTO -pfile
PATH/initSID.ora

and that might create it, or it will do no harm if it fails.  I know the
-startmode AUTO is the important part, and needs to be included in the
creation if this doesn't work.

Doing the delete/add cycle certainly requires downtime, but the good news is
you don't have to re-create the database, so you should be down only long
enough to stop, run these commands, and start.  (take a backup first,
though!)

Jackson Dumas wrote:

 In order to automatically start Oracle on NT, OracleServiceSID and
 OracleStartSID must be started. They should be set to AUTOMATIC in
 control panel, on NT.Now my case is that both those services are not
 available or created. Now I read that I have to create those services.
 e.g.
 oradim80 -delete -sid TEST
 oradim80 -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile
 c:\ORANT\DATABASE\INITTEST.ORA

 The version of Oracle is 806 and the version of NT is 4.0 Service pack
 5. As to who installed and created the database, that one I don't
 know, maybe someone who was here before I joined the Oracle Team and
 he left already.

 The question is whether is there a way of implemeting this without
 having to ask for down time, in other words shutdown the Production
 database ? I think the question is clear now Kevin. Is there another
 way perhaps of creating this without having impact on the business by
 shuting down the database ?

 On Thu, 01 Mar 2001 05:41:50 -0800 Kevin Kostyszyn ([EMAIL PROTECTED])
 wrote:

 What exactly are you asking?  What version of Oracle, What version of
 NT?
 Who installed and created the DB?
 Kev
 
 -Original Message-
 Dumas
 Sent: Thursday, March 01, 2001 8:15 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 
 I would like to find out how I can make a Oracle database running on
 NT to start up automatically if there is a power failure or something
 on the box without having to down that database. I read another
 article about Oradim and how to include the startup file if it's not
 there on Services running on NT. Actually I did check that there is
 no
 startup service for database to be automatically started. Now my
 problem is whether it's possible for me to incorporate this without
 having to get down time, because this is a 24X7 system and it will
 take a long time before getting approval and things like those
 Please help me, I am new on these thangs.
 Ya help please .. 
 ___
  http://www.webmail.co.za the South-African free email service
  WIN R10 000 by registering  for free online options for EasyMoney in
  http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
 Now!!!
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jackson Dumas
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

 ___
  http://www.webmail.co.za the South-African free email service
  WIN R10 000 by registering  for free online options for EasyMoney in
  http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!!
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jackson Dumas
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')

Re: DBWR slaves in NT???

2001-03-02 Thread Don Jerman


If you're not archiving anyway the NOLOGGING option on import and index creation
might help things go faster (esp. if it's all on the same drive).  Don't turn it
on for the import if you're appending to existing data (unless you like living
dangerously) but for indexes it's a good option for speed (as you can just drop
and re-create them anyway if things go wrong).

Raghu Kota wrote:

 Hi Jesse

 Your insight is good, But due to all these problems(One controller) we
 could't enable archiving. So we are trying to reduce the overhead !! So the
 what ever minimum LGWR work will done okay...I think Iam correct

 Any way thanks to all people for understanding my problem

 Raghu.

 From: "Jesse, Rich" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: DBWR slaves in NT???
 Date: Thu, 01 Mar 2001 12:27:14 -0800
 
 H...I don't know how pounding a single drive with two threads instead
 of
 one would help, but it could be tried.  I would think that the LGWR would
 be
 the big complainer in a 1-disk config, instead of the DBWR.  Or at least I
 think LGWR would complain more often...
 
 My post was simply to point out that the error message in TOAD about
 "Number
 of DB_FILES set too high" was inaccurate.  And as the "Tuning" stuff in
 TOAD
 has been redone, at least in the latest TOAD v7 Beta, this error message
 won't be a hassle too much longer.
 
 Long live Toadman Jim!  :)
 
 Rich Jesse  System/Database Administrator
 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
 
   -Original Message-
   From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, March 01, 2001 14:09
   To: Multiple recipients of list ORACLE-L
   Subject: RE: DBWR slaves in NT???
  
  
   If I am completely off the wall here just slap me around a
   little bit.  But
   couldn't you play with the init parameteres DBWR_IO_SLAVES or
   DB_WRITER_PROCESSES to help improve write performance?  I
   mean, I agree with
   Ross, there is only one disk, but maybe it could help a little to help
   simulate asynchronous I/O?
   Kev
   Just thinkin out loud again!
  
   -Original Message-
   Sent: Thursday, March 01, 2001 2:31 PM
   To: Multiple recipients of list ORACLE-L
  
  
   Actually, that message is invalid for Oracle8 DBs.  From what
   I can gather,
   the DB_FILES init.ora parameter only
   potentially affected DBWR performance in Oracle7.  In
   Oracle8, it ain't
   true.
  
   Remember, the DBWRs write dirty buffers (data in memory that has been
   modified from it's counterpart in a datafile) from the buffer
   cache (memory)
   to the datafiles (disk).  In O7, the DBWR I/O clump size, or
   how many dirty
   blocks could be written at once (also sometimes referred to
   as the DBWR's
   "internal write batch size"), was calculated as:
  
   DB_FILE_SIMULTANEOUS_WRITES*DB_FILES/2.
  
   In O8, the DBWR I/O clump size is static, and is different
   from platform to
   platform.  Thus, for Oracle8, the advise to change DB_FILES is bogus.
  
   HTH!
  
   Rich Jesse  System/Database Administrator
   [EMAIL PROTECTED] Quad/Tech International,
   Sussex, WI USA
  
   Disclaimer:  After taking the Oracle8 Perf Tuning class, I
   think I know more
   than I do.  Don't blame me for your (in)actions based on my opinion!
  
   -Original Message-
   Sent: Thursday, March 01, 2001 12:27
   To: Multiple recipients of list ORACLE-L
  
  
   not a dbwriter problem.
   on a "single-disk wonder", your best
   bet is to DUMP all indexes on loadable
   tables, then load your data, then rebuild
   the indexes.
   of course, that might take just as long.
   any possiblity of getting more disk?
   like, several? a raid controller?
   mit gluck!
  
  
  
   -Original Message-
   Sent: Thursday, March 01, 2001 11:26 AM
   To: Multiple recipients of list ORACLE-L
  
  
   Hi Friends
   I have toad tool for my NT database
   DBWR Average Scan Depth 1024  **Number of DB_Files too high??
   I got doubt due to from v$waitstat I got data block waits
   some time 8000 and
  
   some times higher number. How can I increase the DBWR slaves on NT??
   although I set in development box, How can I see as background process
   really working for me??
   I have my datafile and indexes same on E disk drive, My hit
   ratios are okay,
  
   My import is killing me.
   Any help appreciated.
   Thanks
   Raghu.
   __
   ___
   Get Your Private, Free E-mail from MSN Hotmail at
 http://www.hotmail.com.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Raghu Kota
INET: [EMAIL PROTECTED]
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists

Re: OEM 2.2. installation blues

2001-03-02 Thread Don Jerman

We're struggling with iAS/ iFS now with a similar box (only it's a leftover quad 400,
2GB mem from an appserver upgrade), could you elaborate on the "TWICE" part?

"Jesse, Rich" wrote:

Hi Patrice,

I've successfully installed OEM 2.2 *TWICE* (thanks to Oracle Support for
telling me that it was the only freaking way to get iFS installed on the
same box...) on my P-III 800Mhz running Win2K ("WinTuke") with SP1 and 512MB
memory. You don't mention where your repository DB is, however. My DB is
an O8.0.5.0.1 on an OpenVMS box, which frees up about 200MB of mem for me.

I haven't had any problems regarding the installation. It's just AFTER the
install that I run into chaos and mayhem. Stupid events won't deregister...

Good luck! :)

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

-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 07:55
To: Multiple recipients of list ORACLE-L
Subject: OEM 2.2. installation blues

Hi,

Has anyone successfully installed OEM 2.2. on their machine?

My test server has 256M more RAM coming, but in the meantime
I haven't given
up hope. Although hope is dwindling... I only have 380M of RAM.

I started the installation process, then went to talk to
someone. When I
returned there was a Blue Screen of Death waiting for me.

After powering off and powering on my machine, Peak Memory usage on my
machine is at 680M of memory! Is this NT going crazy or does
the Oracle
Universal Installer really need that much memory to install
OEM 2.2.? Could
there be a creeping memory leak in the Universal Installer?
(make that a
galloping memory leak)

I allocated 1G of virtual memory, but I know from experience
on this machine
at least that NT can't handle virtual memory very well, it keeps blue
screening when I exceed available physical memory by too much.

---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]

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

Re: Oracle Licensing

2001-03-02 Thread Don Jerman

Last time I danced with our sales rep, power units were per server, not per
user... so the power unit price would be 400*100 = 40,000 for an unlimited (Ha!
at 200mhz?) number of users. If you ask nicely, yours may agree to convert any
concurrent or named user licenses you have into power unit credits.

Dennis Taylor wrote:

At 06:25 AM 3/2/01 -0800, you wrote:
the mire. At any rate, there are suppose to be two basic licensing
schemes, and
GOD only knows how many "allowed" permutations:

1) Power Units which equates to the number of processors times the
speed of
the processors in Megahertz. Oh, BTW: it matters if their Intel or Risc
processors too. Risc processors are more expensive. In general this is the
MOST expensive way to go.

I went to the oracle site and did some calcs for adding users to Oracle
Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of
megahertz". Anyway, for a very behind-the-curve system (2x200mhz
ppro's), it works out to $4000 per additional user.

Or I can look at Interbase/Firebird, which is free.

Today I will be assigning one of my staff the task of downloading,
installing, and evaluating Firebird.

The only way I can imagine that Oracle thinking can be going is: "Hey,
revenues are dropping because of competition from free and less expensive
dbms's". "No problem. Raise prices to make up the shortfall". Then I say to
myself, "Naw, no-one can be that stupid". Then I check the per-user prices
again

Dennis Taylor

Good we must love, and must hate ill,
For ill is ill, and good good still.

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

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

Re: BFILE vs. BLOB

2001-03-01 Thread Don Jerman




Last time I danced with this topic (8.1.5), BFILE required the file to
exist somewhere accessable to the data server (like on a mounted file system)
that you create an alias for with CREATE DIRECTORY. But the data
server could not create or write the file. So you have to let the
application write to a directory mounted by your Oracle server, without
overwriting any old BFILE data and without deleting any files that are
still referenced by the database. Sounded complicated to me.
If you must modify the data BFILEs are out, unless you let the app do
it, and then you might as well just store the file names. Sounds
good for static content that must be streamed back with the query, though.
Of course, 8.1.7 may have fixed this...
"Koivu, Lisa" wrote:

Good morning all,
I have to start storing binary files
in our database somehow. I'm reading up on BFILES and BLOBs.
Seems like one of the differences is
that BLOBs are manipulated within the database, and BFILEs are not.
Can anyone comment on how fast (or not fast) the DBMS_LOB. routines are
when operating in fairly large BLOBs? I'm leaning toward BFILEs to
avoid having the database do anything other than just keep a pointer to
the file and keep the transaction length as short as possible. FWIW,
I'll only need to accept a file and store it, and return it back to the
app when requested.
Another question: Anyone using
temporary BLOBs (8i)?
Any comments, gotchas, boogie men are
appreciated.
Thanks
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information
contained herein does not express the opinion or position of Qode.com and
cannot be attributed to or made binding upon Qode.com."




begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: Connection manager

2001-02-28 Thread Don Jerman


Been there -- I don't know about availability, but this is what we have to
do for people working at home through their ISP.  I'm assuming NAT
produces similar problems.  You can use CMAN for firewall tunnelling with
or without MTS, don't know about connection concentration, though, as we
don't need it yet.

Background: on NT and some other OS's, Oracle listeners use a different
port for reply (like FTP does), so the NAT server doesn't equate the
incoming reply packets with the outgoing connection.  Most NAT servers
recognize and compensate for FTP connections, but not for Oracle.  CMAN
will not redirect its clients to another port, so the server-side redirect
is hidden and the client remains connected.

Fix: On the server subnet, establish a CMAN server with a fixed address
and (if necesary) make the firewall server route all incoming connections
to 1620 (or whatever port you're using) to it.  You'll need to use a
different port than the Oracle listener if you're running CMAN on the
oracle server.  See the docs to configure CMAN appropriately for your
network security needs. By default it's fairly promiscuous so you'll
probably want to make sure it only connects to Oracle servers inside your
subnets, and you may want to restrict the outside addresses it will
serve.  Once I copied the sample config files into the ADMIN directory I
was able to get it running with no complications, but I did revisit the
routing issue for our site.

In the TNSNAMES file of the client (or in the naming service, whatever
you're using) add (SOURCE_ROUTE=ON) and add an address line for each CMAN
server needed to reach the oracle server (if, for instance, you have
multiple DMZ layers you may need multiple CMAN servers to make connections
visible.).  The CMAN servers will be sent the description information and
will establish the connection to the next leg of the route (another CMAN
server or the data server).  Naturally, each CMAN server needs to be able
to resolve the address of the server that comes after it in the route.

Since you didn't list the errors, I assume this will work.  It's possible
the client needs a CMAN server on the back side of their NAT server, too,
but probably not, unless you're doing server-to-server connections.  If
they do, just add it to the address list in the appropriate order.

Here's a sample TNSNAMES entry (this is what gave me the most trouble):
MYSERVER.MY.ORG =
  (DESCRIPTION =
(SOURCE_ROUTE = ON)
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = FIREWALL.MY.ORG )(PORT = 1620))
  (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER.MY.ORG)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = MY_SERVICE.MY.ORG)
)
  )

Hope that helps!


[EMAIL PROTECTED] wrote:

 Looking for some help with Connection  Manager.
 Suddenly got hit with a NAT issue from a customer site.

 Any suggestions on the use of Connection manager to alleviate this
 situation would be appreciated.

 Also:

 a)   Does Connection manager require the use of MTS?

 b)   Is Connection manager available with both Standard edition and
 Enterprise edition?

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology,Division of Highways
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology,Division of Highways=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: How store 1024 bit ?

2001-02-15 Thread Don Jerman


Something like:

create table keys(
key_id char(8) primary key,
key_val raw(128) not null);


where key_id is rawtohex(the 32-bit key id) and key_val is the 1024bit
key... although it's technically feasable to generate duplicate key id's
(especially with this sample size) it's probably not good policy to allow
them.

The question is, what are you -doing- with 50M keys?  That's enough for
the entire population of the west coast (and then some)!


Henrik Ekenberg wrote:

 Hello,

 We need to store some public keys in our database.
 One key is 1024 bit and the other is 32 bit.

 How can we do ? We will have more than 50 000 000 rows in our table.

 Regards
 Henrik

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

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


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: OT NT2K vs Unix.

2001-02-15 Thread Don Jerman


See www.lokigames.com

Try Heavy Gear II and Quake III...they run well on my box.

Kevin Kostyszyn wrote:

 What about Mechwarrior or Quake II, can I run that on Unix and will it run
 smoothly?  This is a fun debate, but I do agree there will never be a
 winner.

 -Original Message-
 [EMAIL PROTECTED]
 Sent: Thursday, February 01, 2001 4:45 PM
 To: Multiple recipients of list ORACLE-L

 I believe I've seen a shareware version of that out on the web somewhere for
 various flavors of Unix with X-windows.

 Reply Separator
 Author: "Kevin Kostyszyn" [EMAIL PROTECTED]
 Date:   2/1/2001 1:18 PM

 Oh, and not only that, I like the GUI a lot more than I like command based
 programming...unless.can you play solitaire on Unix:)
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky Welch
   Sent: Thursday, February 01, 2001 3:28 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: OT NT2K vs Unix.

   From the URL:

 http://www.microsoft.com/windows2000/guide/professional/solutions/overview/r
 eliable/default.asp

   PCs Stay Up and Running
   Memory conflicts and missing or altered system files caused many of the
 system crashes prior to Windows 2000. To put an end to these problems, we
 changed Windows 2000 memory management to reduce the chance that software
 applications will interfere with one another.

   Applications runing in a seprate memory area...HMM Unix did that 15
 years ago.

   Fewer Reboots
   Performing routine maintenance on your system requires significantly fewer
 reboots, therefore less downtime, with Windows 2000. In addition, with its
 support for Plug and Play, Windows 2000 automatically recognizes and adapts
 to hardware changes. This means users can easily add hardware devices such
 as scanners, DVD players, and speakers without rebooting, and with less
 potential for user error.

   Reboots are also reduced-and reliability increased-through the Microsoft
 hardware device driver certification program. This program helps ensure that
 hardware drivers are compatible with Windows 2000, and do not require a
 reboot after installation. Certified drivers are tested and digitally signed
 by Microsoft. If Windows 2000 detects a driver that Microsoft has not
 digitally signed, it warns users about the risk before they install it on
 their system

   Not having to reboot after installing an applicationUnix from it's
 beginings.

   How Much More Reliable Is Windows 2000 Professional?
   Third-party studies that assess reliability from three different
 perspectives-lab-based testing, customer-site measurement, and user
 perceptions-conclude that Windows 2000 Professional is the most reliable
 desktop operating system.

   Highest Reliability in Production Environments
   NSTL collected uptime data in the real-world environment of several
 customer sites and concluded that the average system uptime between failures
 of Windows 2000 Professional is 13 times more than that of Windows 98 and
 three times more than that of Windows NT Workstation 4.0.

   Notice no comparison to Unix. It's like people that hangout with socially
 unacceptable people to make themselves look better (Hey! Wait a minute! Is
 that why alot of people want to hang out with me? ). I guess you're right
 they aren't the same. Unix posts much higher numbers.

   Sorry, it's sarcastic Thursdsay here. I love the debate about Windows and
 Unix. ;o)

 Kevin Kostyszyn [EMAIL PROTECTED] wrote:

 I would disagree with that, how is Windows becoming like Unix?

   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky
 Welch
   Sennt: Thursday, February 01, 2001 2:01 PM
   To: Multiple recipients of list ORACLE-L
   Subject: Re: OT NT2K vs Unix.

   The same prediction was made at least 5 years ago. At the rate
 Microsoft is going, Windows will be a direct form of Unix. It becomes more
 like it with every release.

   -Rocky

 "Mohan, Ross" [EMAIL PROTECTED] wrote:

 Yea, but..

 Win2K Datacenter will just decimate Unix. I predict that, in
 5 years, there will be two or three Unix vendors, fighting over
 the 45% of the market that DataCenter hasn't eaten.

 -Original Message-
 From: Steve Orr [mailto:[EMAIL PROTECTED
 Sent: Thursday, February 01, 2001 1:01 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OT_RE:_Ref._:_Re:_asyn_i/o_on_sun_

 Close. It's Dave Cutler. There's too much old DOS/Windows backward
 compatibility for WinNT/2000 to achieve stability like VMS despite
 Cutler's
 leadership.

 I knew VMS and you, Mr. NT, are no VMS!

 With apologies to Senator Bentsen,
 Steve Orr

 -Original Message-
 stephane
 Sent: Thursday, February 01, 2001 9:22 AM

Re: Primary Keys

2001-02-01 Thread Don Jerman

When you say "no natural key" I assume you mean no data that is non-null
and unique. How, then, do you propose to get single records, since you
(probably) don't want to have to find them by the image data...

Of course, if the table is write-only -- who cares? :-)

Brian Wisniewski wrote:

I know this violates the most basic data modeling techniques but tell
me what you think.

I'm working on creating a new database which will be fairly small in
number of tables ~8 but large in storage size ~4 terabytes with
millions of records eventually.

The 3 large tables will hold small images along with supporting data
and the only reason I can see to have a primary key is to have a
primary key. There is not a natural key for the tables so it would be
a sequence which would never be selected against. Given the number of
records all I can see it doing is taking up space, increase the time of
the imports, generate more redo logs, etc and I can't see the benefits.

There won't be any tables hanging off of these, I won't be using
snapshots, replication or anything else I can think of that would
require a PK but the voice 'YOU MUST HAVE A PRIMARY KEY' is resounding
loudly in my head so I must ask why?

Tell me what you think.

Thanks

- Brian

__
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

begin:vcard
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

37 matches

Mail list logo