Re: OT: Solaris: Finding the cause for disk space growth

2004-01-27 Thread Stephen Evans
i normally go to the mount point (ie highest level dir for that disk) and issue: du -k | sort -n that way you see where the space is going in descending sequence good luck, steve Naveen, Nahata (IE10) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 03:44 AM Please respond to

Re: database file sizes....more of smaller size or less of larger size?

2003-02-13 Thread Stephen Evans
i generally will not permit a file to exceed 2 gig for reasons of managability. eg since a file is the smallest recovery unit, i want something small enough so that i can easily recover it without incurring too much downtime. if i need to move some files around, 2 gig is small enough so that i

RE: Re: parallel index creation again:in which case, can we use p

2003-02-13 Thread Stephen Evans
tom, if the process is IO bound (ie consumes little cpu) then you can achieve a lot. thanks, steve Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/12/2003 02:23 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: multiple oracle homes

2003-02-07 Thread Stephen Evans
maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory. during an install/upgrade this common data needs to be updated. i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong. thanks, steve

Re: data migration strategies

2003-01-31 Thread Stephen Evans
Evans Hi Stephen Evans, Thank you for your earlier response to the migration issue.Here i want to eloborate this specific requirement so that you can advise us more.The requirement goes like this: We have a Sybase database and one non-proprietory DB in our old system and these two database

RE: Making dispatchers re-read tnsnames.ora?

2003-01-31 Thread Stephen Evans
jeremiah, some good points. we use onames becuase we have many workstations spread thru out our org (we are a med center/university) to which we dont have access. not only do we not have access to them, we dont even know where they are or how many there are. we also have the problem that some

Re: data migration strategies

2003-01-30 Thread Stephen Evans
vijaya, partition your bigger tables so that they can be loaded by sqlldr via direct path in parallel drop indexes (especially global indexes) before loading do some testing first to determine optimum number of parallel streams from a cpu usage standpoint and an io contention standpoint. try

Re: migration from Sybase to Oracle

2003-01-29 Thread Stephen Evans
vijay, oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects data from sybase to oracle. however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you

Re: Re[2]: undo tablespace

2003-01-29 Thread Stephen Evans
breno, i believe the 'no logging' option only applies to data that is direct loaded into your tables therefore, you may be able to bypass logging if you used sqlldr or 'create table as select' good luck, steve Breno A. K. Magnago [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/29/2003

Re: Installer does not run on Win 2k Service Pack 3

2003-01-17 Thread Stephen Evans
this sounds weird, but i heard that installs will not work via terminal services for 8.1.7 good luck, steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/16/2003 09:08 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: