RE: ALTER TABLE MOVE command causes table to grow

are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com

RE: ALTER TABLE MOVE command causes table to grow

by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http

Recreating database from hot backup but only 1 tablespace - Urgen

create controlfile script (backed up to trace) and open it that way? I've never tried this before and it's rather urgent so I'm e-mailing while I'm still searching the Velpuri book. Any other suggestions are welcome. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Recreating database from hot backup but only 1 tablespace - U

Thanks Dennis, The rollback segments occurred to me already, I'm composing the email to our SAs to restore the files (I'm going to have to wipe out another test box but it's one that can easily be recreated). Thanks! Jay Miller -Original Message- Sent: Monday, September 09, 2002 5:14

Re: Restoring RMAN backups to different host ......

Babu, You need to copy your backup files to HOST_B. If your file systems are different thant HOST_A, create symbolic links for the directories where rman expects to find the backups. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 09/05/02 08:13PM

RE: ALTER TABLE MOVE command causes table to grow

of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

ALTER TABLE MOVE command causes table to grow

are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: PCTUSED - when is block added to freelist?

, but no data actually changes. Would this make the block available for inserts? Hmm, this is getting interesting! Jay Miller -Original Message- Sent: Wednesday, September 04, 2002 12:33 PM To: Multiple recipients of list ORACLE-L See Note: 1029850.6 on MetaLink for more details but here

RE: ALTER TABLE MOVE command causes table to grow

was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat

RE: ALTER TABLE MOVE command causes table to grow

that a low PCTUSED would actually shrink the table since each block in the new tablespace would fill up entirely except for the PCTFREE. Jay -Original Message- Sent: Thursday, September 05, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Jay: I would also wonder that the PCTINCREASE

Pinning and loads

SYS.DBMS_APPLICATION_INFO PACKAGE 20.2 181,297 YES Thanks, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary

RE: ALTER TABLE MOVE command causes table to grow

by a batch insert at the beginning of the month. But even if that wasn't the case how would a low PCT_FREE cause it to grow during the MOVE command? I'm not certain I understand what you're aiming at there. Jay -Original Message- Sent: Thursday, September 05, 2002 3:18 PM To: Multiple

RE: PCTUSED - when is block added to freelist?

Yes, that's what I intended to ask :). Thanks, Jared. Jay -Original Message- Sent: Tuesday, September 03, 2002 9:18 PM To: Multiple recipients of list ORACLE-L If I understand Jay's question correctly, what he's asking is not how PCTUSED and PCTFREE work, but what action

RE: automatic segment space management

-- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

PCTUSED - when is block added to freelist?

. Anyway, why would a lower PCTUSED reduce processing costs during a DELETE but a higher PCTUSED wouldn't increase processing costs during a DELETE. That makes no sense. I'm befuddled. TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET

RE: upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: PL/SQL Editor

and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Oracle Arm Twisting?

a form or two, then that is what we test. Lately we have been applying large groups of patches because we are bringing up another module. This requires us to run through our testing procedures. Jay [EMAIL PROTECTED] 08/15/02 09:38PM Hi Jay, Our Oracle HR consultant said that we are to test

RE: Oracle Arm Twisting?

. Is there a support group for 11i dbas? Jay [EMAIL PROTECTED] 08/14/02 11:08PM I guess you are not using Oracle Human Resources Applications. For most of the patches that we've applied, there are new bugs. It's a never-ending applying patches-after-patches ... We've lost count of the number of TARs

11i Conc. Manager Question

it out, they are just getting impatient waiting for concurrent requests to get picked up by the managers - sometimes it takes as long as 2 minutes. Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA **DISCLAIMER This e-mail message and any files transmitted

Re: 11i Conc. Manager Question

Tim, We already have other managers set up. I was just curious if other folks tweak the standard manager. Thanks, Jay [EMAIL PROTECTED] 08/13/02 10:28AM Jay, It's a little more complicated than that. It sounds like you are using the single default ConcMgr queue (named standard, if I

Explain Plan Question

not seem to be included in the Plan Output. Is this correct? Regards, Jay _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET

RE: set sql*trace VB/Crystal

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: 20 Instances 1 Machine

Good point Dennis - version issues. We create a separate Oracle home for each 3rd party application that we install at our company for this very reason. Jay [EMAIL PROTECTED] 08/02/02 01:05PM Ethan - Now that you have clarified the reason why you want 20 instances, I'll change my advice

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

. Which reminds me of another one: * cost Jay [EMAIL PROTECTED] 08/02/02 12:59PM On Thursday 01 August 2002 09:45, Fink, Dan wrote: Case in point, many databases with few dbas. Logging in each morning to each database and checking status and metrics is very inefficient. By the time all

RE: ONLINE index creation in 8.1.7.2

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network

Re: Install Oracle 8i on Windows XP?

: UNSUB ORACLE-L (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: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Install Oracle 8i on Windows XP?

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: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Portal Question

Could anyone recommend a good news portal which offers RDBMS content which is updated daily? I've been using www.infoworld.com and www.cnet.com and would like more database related material. Thank you in advance, Jay _ Chat

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

’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Q: How to Find Cursor Size

Hello: Is there anyway to find the size of a cursor in bytes? We are attempting to implement ADO returning Oracle cursors and want to make sure we are not returning more then the 64k limit. Thank you in advance, Jay _ MSN Photos

RE: Bind Variables in VB

, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail

RE: Recompiling blocked package - locating blocking session

Actually, I think the executing_packages script should be exactly what I need. Thank you very much. I had browsed ixora but didn't make the connection between this script and what I was looking for. Jay Miller -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002

RE: OEM changes

Oooh! That sounds promising! I don't suppose they'll give up on the idea of writing it in Java? It's been running so slw since I gave in and upgraded. Jay -Original Message- Sent: Wednesday, July 24, 2002 3:26 PM To: Multiple recipients of list ORACLE-L Well, it's not exactly

Recompiling blocked package - locating blocking session

the random searching next time? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Rant-Rant

instincts when I set up my backup and recovery plans, since improvisation and leaving things open is generally *not* advisable. Oh, we'll figure it out as we go along isn't a good choice there :), despite being my being rather good at doing just that. Jay -Original Message- Sent: Monday

Had to get this off my chest

We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss won't approve a plan that doesn't have pictures. I'm ready to move to a new company please. Jay

RE: Rant-Rant

Really? I had you pegged as an E given how well you organize all the NYOUG events/people. The J part was obvious :) Jay -Original Message- Sent: Monday, July 22, 2002 10:18 PM To: Multiple recipients of list ORACLE-L hey, I'm an infj -- according to the out placement company, I'd

RE: How to notify the password expiration in oracle using email?

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL

RE: Had to get this off my chest

Thanks to everyone. After laughing my way through these I feel a lot better about the assignment :) I guess the 96 degree weather was eroding my sense of humor. Jay -Original Message- Sent: Tuesday, July 23, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Use some stickers

RE: How to notify the password expiration in oracle using email?

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network

Converting Longs

was referring to. He said please run a DESC on ALL_TRIGGERS, Then commented that I do not know my database. ALTER SYSTEM DROP STUPID_USER user does not seem to be working in this situation any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay INET: [EMAIL PROTECTED

RE: STATSPACK space requirement feature on 8i (FYI)

Well, it only goes away if you choose your extent size correctly :) I put the objects in their own tablespace and had the same problem with STATS$PARAMETER_PK since I set the default to the same as my TS_SMALL. Jay Miller -Original Message- Sent: Friday, July 19, 2002 4:49 PM

RE: Rant-Rant

FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L That is why I use

RE: Cognos

in the concurrent managers, see who submits the most intensive reports, etc. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/18/02 05:11PM We have deployed cognos, first a local install on all P.C.'s and we are now migrating to the Web based solution

Re: Cognos

. Building a cube can hit your system pretty hard (all of the data needs to be read to summarize it into a cube). You build your cubes off hours and you don't let users build them on demand. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/18/02 12:08PM

How to change VB code to use bind variables?

sConnect = sConnectWSI GetSQL = Array(sConnect, sSql) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: How to change VB code to use bind variables?

to articles that didn't even mention bind variables. And I thought Metalink was bad. Does anyone have a link that goes directly to an article? Thanks, Jay Miller -Original Message- Sent: Tuesday, July 16, 2002 4:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Check on the MS support

Re: Oracle Licensing to be Transparent?

this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

How to sort these values 'correctly?' 1.1..1, 1.1..2, 1.1..13

So imagine I have this series of numbers 1.1 1.1..1 1.1..13 1.1..2 1.1..3 and I want them to sort like a human would sort them 1.1 1.1..1 1.1..2 1.1..3 1.1..7 1.1..13 Anyone have sql to accomplish this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker

OT: Job Locations

some resource and it seems as though the East Coast has more job postings. Regards, Jay _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Increase size of REDO log

You also might need to do an alter database checkpoint; if you get a particular error when you try to drop the log (don't remember it offhand, I always recognize it when I see it :). Jay Miller -Original Message- Sent: Monday, July 08, 2002 2:04 PM To: Multiple recipients of list

Re: download leads to sales call

FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: batch file for Scheduling hotbackup in win2k

There is a good offering of examples at http://www.orafaq.com/faqscrpt.htm#WIN if you want to zip the file you can download the winzip command line utility (althought if you are scheduling you will need to register it, no luck with the shareware version) - Original Message -

Re: Adding Control files

, include a line containing: UNSUB ORACLE-L (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: Jay INET: [EMAIL PROTECTED] Fat City

RE: Unidentified sessions brought us to maximum processes - more

I'm on 8.1.6.2, Solaris 2.6. All the unidentified sessions were active but had no SQL associated with them. Jay Miller -Original Message- Sent: Tuesday, July 02, 2002 3:43 PM To: '[EMAIL PROTECTED]' We just had a problem on our datawarehouse where we hit the maximum number

RE: Hints being ignored

-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Frequent ''ORA -1650: unable to extend rollback segment error

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Oracle client won't install on Windows 2000

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jay INET

Re:RE: Alternative to Crystal Reports

). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Any Good , Complete Docs , Source , Links on OUTLN ?

Title: RE: Any Good , Complete Docs , Source , Links on OUTLN ? Oracle High-Performance SQL Tuning by Don Burleson608 pagesISBN 0-07-219058-2 The following excerpt is from Chapter 13 of this publication. Tuning with Optimizer Plan Stability This chapter discusses the use of optimizer plan

Partitioned Tables and Local vs. Global Indexes.

of each. Why would one choose to use a. Local Partitioned Index b. Global Partitioned Index c. Local Non Partitioned Index d. Global Non Partitioned Index Thanks Jay Earle, BSc(CS) ([EMAIL PROTECTED]) DBA, Operations Group -- Please

RE: how to you stop an export?

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: connect as SYSDBA using ADO

From my experience there is no way that you can use a parameter to connect as SYSDBA. I was reading that you are to connect as INTERNAL if you want to connect as SYSDBA. But we all know that is a bad idea and impossible in 9i anyway. If you find away could you let me know. Thanks Jay

RE: Is this a good upgrade path from 8.0.4 to 8.1.7.2?

. This will save considerable time. Good luck! Jay Miller -Original Message- Sent: Thursday, June 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L We are preparing to do an upgrade of our Data Warehouse on Sun Solaris from version 8.0.4.0.0 to 8.1.7.2. We've done a number

RE: Permissions on user trace files

Thanks to everyone who helped with this. It's working perfectly. Jay -Original Message- Sent: Thursday, June 06, 2002 5:38 AM To: Multiple recipients of list ORACLE-L _trace_files_public = true in init.ora Iain Nicoll -Original Message- Sent: Wednesday, June 05

Permissions on user trace files

happy giving them permission to do so, since it means I won't need to run it for them several times a day. I'm on Solaris 2.6, Oracle 8.1.7.2 TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: custom DD views to allow users to see source without needing

We have the same problem with SQL Navigator. Any suggestions would be great. Jay Miller -Original Message- Sent: Tuesday, June 04, 2002 7:08 PM To: Multiple recipients of list ORACLE-L needing exe rights Hi, Jack list, We had the same problem here and we finally resolved

RE: trial version of Oracle Financial ??

Leslie, Even if you do get a trial version, there is a slim chance that you could get it working without the help of consultants and Oracle support. I often ask folks at our company if anybody ever considered Quickbooks. These tier 1 financial systems are applications from hell! Jay

Solution to Microsoft Transaction Server/Standby database problem

connections. Still not certain what's happening in that time period, but it works! If we ever manage to figure out why the problem is happening I'll post again, but wanted to post this now in case anyone else has similar issues. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: RMAN - Disk vs Tape backups

don't have to keep track of archivelog destinations for each database. Jay [EMAIL PROTECTED] 06/03/02 01:43PM Dennis ; You are absolutely right - the DISK option has a big down side that I did not catch : In a disaster (computer room fire) the daily archive logs would be lost leaving you

RE: 9iR2 Install Problem

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Veritas Quick io

temporary tablespaces using regular files and recreate them using Quick I/O files.
You can manually create the mkqio.dat file containing the Oracle database filenames that you want to convert to use Quick I/O, excluding Oracle tablespaces that are marked TEMPORARY from the list. Regards, Jay

Re: So, What is a 'Production DBA'?

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

Yes, I changed it from the default. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA Hemant K Chitale [EMAIL PROTECTED] 05/30/02 09:32AM So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale

Jr.DBA, Mid level DBA, Sr.DBA

Hello: Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a Sr. DBA? I know how our HR department makes the division but would be interested in knowing how other people might classify the differences. Regards, Jay

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: storage parameters

, Jay Jay Earle, BSc(CS) ([EMAIL PROTECTED]) DBA, Operations Group SmartForce, Learning Solutions for the Human Enterprise -Original Message- Sent: Tuesday, May 28, 2002 3:30 PM To: Multiple recipients of list ORACLE-L An example: Think of load a lot of data into a table

RE: so when did you switch from NT to unix for oracle

of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Upgrade is Necessary?

Lucky you. Our CIO tried instituting a you must always be on latest release and patchset policy last year. After I kicked and screamed (that would have meant 9.0.1.0 at the time) I got a little leeway but still need to patch things that work perfectly. Jay Miller -Original Message

RE: partitioning

notify us immediately at [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Mehta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: partitioning

, and save you some big bucks :) HTH and GL! Jay -Original Message- Sent: Wednesday, May 22, 2002 7:12 PM To: Multiple recipients of list ORACLE-L Quick memory test - were you able to create partition views such that you could insert rows into view? In other words, could you create multiple

RE: How to find current ORACLE_HOME programmatically

-- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

RE: Export problem

But why would you want to? If you export using the 7.3.3 database using the 7.3.3 export utility you should be able to import it into your 8.1.7 database using the 8.1.7 import utility. It's backward compatible. You just can't go the other way (import an 8.1.7 export to 7.3.3). Jay Miller

RE: How to enable Java

You don't need this article if in 8.1.6. Java installations and upgrades became a lot more complicated as of 8.1.7. Jay Miller -Original Message- Sent: Tuesday, May 21, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I don't have an account with metalink, and I can't get

RE: Microsoft Transaction Server Standby database problem

wasn't switching the way it should and this resolved the issue? Thanks! Jay -Original Message- Sent: Friday, May 17, 2002 8:43 PM To: Multiple recipients of list ORACLE-L prod = (description= (address_list= (failover

Microsoft Transaction Server Standby database problem

will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, Jay Miller -- Please see

RE: Oracle version usage

At a recent NYOUG meeting the question was asked of of around 150 or so attendees (very rough estimate) how many had 9i on a production system. Two people raised their hands. Jay Miller -Original Message- Sent: Tuesday, May 14, 2002 7:44 PM To: Multiple recipients of list ORACLE-L I

Duplicate from Previous Incarnation

stories from anybody who has done this. Thanks, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you

RE: [Q] How to make Sql*loader run under nologging mode?

And of course you shouldn't do this if you're running with a standby database. Jay Miller -Original Message- Sent: Wednesday, May 15, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Command line option DIRECT=Y Control file option UNRECOVERABLE --- dist cash [EMAIL PROTECTED

RE: Zero-term'd machine in V$SESSION from Winders

Rich, We do have Win clients, and V$SESSION does show proper values for machine and terminal. Are these sessions for background processes and/or slave processes? Jay -Original Message- Sent: Tuesday, May 14, 2002 4:23 PM To: Multiple recipients of list ORACLE-L So, there I am

RE: 1 Table and its Indexes occupying 30% space of the Database.

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Upgrade is Necessary?

problems for about a year. Of course they're very small, straightforward databases. I had been planning on patching to 8.1.7.3 next week but put those plans on hold after reading the posts here. Jay Miller -Original Message- Sent: Wednesday, May 08, 2002 1:30 PM To: Multiple recipients of list

RE: too low optimizer_index_cost_adj causing bizarre index choice

Is this surprising? I still remember an Oracle presentation when 8i was first coming out and the Oracle rep answered a question about hints by saying that no one should use hints any more because the optimizer always used the best path. Half the room burst out laughing :). Jay Miller

RE: DBA_EXTENTS problem

://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

RE: 9i Release 2 features/fixes

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Datawarehousing help

right. Okay, I've rambled along here too long. Hope that gets you off on the right foot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Create a new database

days so this was a very timely post! Thanks, Jay -Original Message- Sent: Thursday, May 02, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Which version exactly? If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any databases. 8.1.7.3 is available, but rife

RE: Prod problem, please help!!!

database hangs. You should install statspack, or if that's not done, run utlbstat/utlestat every hour or so and analyze the statistics. I think that database must be waiting on resources before it completely hangs. Look for wait events, system statistics and latch statistics. Jay -Original Message

RE: How to deinstall oracle 9i and leave 8i intact

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City

<    1   2   3   4   5   6   >