Sql to create 'ALTER USER...'

USER command. The type of output I am looking for is: alter user him default role role1,role4,role7; alter user her default role role4,role5,role7; etc... Maybe this is easy and I am just having trouble concentrating this afternoon... Thank you, Jay Hostetter Oracle DBA D. E. Communications

RE: Copy Oracle's binary.

. Thanh-truc Nguyen -- 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 Lists

RE: database disaster recovery

to have our standby server in a different datacenter than our production server. When I first joined this group they were both in NY. Jay Miller x48355 -Original Message- Sent: Friday, September 14, 2001 10:50 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic

Lock Manager in Enterprise Manager 2.1?

part of a different app? TIA, 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 Lists

slightly OT: Way to prevent FTP users from changing dirs?

to implement this.. hints? And please, don't start telling me about setting/removing no world permissions on a directory... that's not what I'm talking about. J -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker INET: [EMAIL PROTECTED] Fat City

RE: STOP THE PRESS!!

list members in the area or with friends and relatives in the area. Jay Miller -Original Message- Sent: Tuesday, September 11, 2001 10:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35

RE: How do you audit a DBA?

but occasional interesting stuff feel free to send my your resume. We need a DB2 DBA too. Oh, and my great-grandboss knows my name but his office is only about 15' from my cubicle so I don't know if that counts. Jay Miller -Original Message- Sent: Friday, September 07, 2001 4:47 PM To: Multiple

RE: Last time an Index was used..

Wow, that's a nice feature. Any idea what the overhead is for this (not that we'll be moving to 9i for at least a year)? Jay Miller -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L Under 9i MONITORING USAGE | NOMONITORING USAGE

RE: Cloning Database failed

short a frustrating 300K), but I'd still like to know what the problem was and any suggestions (in case it happens again in the future). Oracle 8.0.4.3, Solaris 2.5.1 TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL

Cloning Database failed

like to know what the problem was and any suggestions (in case it happens again in the future). Oracle 8.0.4.3, Solaris 2.5.1 TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: How do you audit a DBA?

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 / Mailing Lists

RE: How do you audit a DBA?

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: How do you audit a DBA?

It was our Internal Audit department. And their issue with Unix is the same issue they have with Oracle. root can do anything, sys can do anything. This is evil incarnate. External security problems aren't nearly as important. And yes, it's crazy. Jay Miller -Original Message- Sent

RE: Interesting News..

to the HP products. That one might work... Jay Miller -Original Message- Sent: Wednesday, September 05, 2001 7:16 AM To: Multiple recipients of list ORACLE-L I agree. First of all there is no certainty that the marriage will ever be consummed (there has been a lot of corporate engagement

RE: How do you audit a DBA?

and the administrator account on a NT system can't do everything too? From: Miller, Jay [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How do you audit a DBA? Date: Wed, 05 Sep 2001 10:55:33 -0800 It was our Internal Audit department

RE: archive query - revisited

: Tuesday, September 04, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Mohammad and Jaymany thanks for the responses. Upon running your script Mohammad, I noticed that archive files were being written to the archive directory during a large insert operation and stopped being written

RE: multiple temp tablespaces

of temp space. Don't see the benefit to having seperate tablespaces for every user though. Jay Miller -Original Message- Sent: Friday, August 31, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Hi all, Someone suggested to me to have seperate temp tablespaces for each user. I

RE: ADMIN: Update on donations...

You might also consider a regular e-mail (sort of like Public Television) where you remind people every 6 months or so of the situation and where to send voluntary contributions. This way people new to the list will get the history of the situation. Now I'm off to make my first donation! Jay

RE: archive query

Even if the table is set to nologging DML will still generate redo unless the data is loaded using a) direct load from sql loader b) insert /*+APPEND*/ Updates and deletes will always generate redo. Jay Miller -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04

RE: Column Name

the recreated columns from the new table. Jay Miller -Original Message- Sent: Tuesday, September 04, 2001 3:21 PM To: Multiple recipients of list ORACLE-L If you have 8i you can add new column name,populate with old column data,drop old column. Rick -Original Message- Sent

RE: !! Keeping the list alive

and went to Columbia to do a career shift and study Oracle. All in all, one of the best things that ever happened to me :). Jay Miller -Original Message- Sent: Monday, September 03, 2001 6:30 PM To: Multiple recipients of list ORACLE-L I went through several major cuts when I worked

RE: USE_HASH hint

Thanks for posting the results. I'm endlessly fascinated (and frustrated) by Optimizer behavior. Jay Miller x48355 -Original Message- Sent: Sunday, September 02, 2001 5:50 PM To: Multiple recipients of list ORACLE-L The problem with the USE_HASH hint is due to the order of the tables

RE: Logical Backup for a large database

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official

RE: char vs. varchar2

ORACLE-L (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: football fan-hood

meetings. Jay Miller -Original Message- Sent: Wednesday, August 29, 2001 5:20 PM To: Multiple recipients of list ORACLE-L Lisa, The stereotypical football fan is, of course, a male, whose wife/significant other usually wants nothing to do with the sport. I've often wondered what

RE: OT RE: RE: How do you audit a DBA?

3rd party software be installed since Unix isn't a secure operating system (root can do anything). Jay Miller -Original Message- Sent: Monday, August 27, 2001 10:25 AM To: Multiple recipients of list ORACLE-L C'mon. I'd vote for The Rock instead, along with all The Rock's witty

RE: conversion from public to private synonym

Actually, it's even easier. You can create the private synonym (which will then take precedence over the public synonym when logged in as the synonym owner) and then drop the public synonym. Users wouldn't even notice any change. Jay Miller -Original Message- Sent: Tuesday, August 28

Shrinking datafiles in a locally managed temporary tablespace

now and feel like my thoughts are wrapped in cotton at the moment. Any ideas? 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: database upgrade policy?

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: High DML Table - Suggestions??

Walter, Couple of other areas to watch while DMLs are being issues against this table are: LGWR and DBWR statistics and activities. Based on DBWR/LGWR statistics, you may need to tune these parameters. Jay -Original Message- Sent: Monday, August 20, 2001 5:31 PM To: Multiple recipients

RE: Index space not freed when rows deleted?

is still claimed. That would explain why when I rebuilt the indexes recently I regained a huge amount of space. Always glad to learn something new :). Jay Miller -Original Message- Sent: Wednesday, August 15, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Index blocks remain

Ways to improve speediness of truncate, drop, coalesce

is the best I can do. Thoughts? J -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Index space not freed when rows deleted?

based index. Any ideas? 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 Lists

RE: Speed up Truncate tables

Also,if the problem is caused by a large number of extents my understanding is that it will take just as long to DROP it as to TRUNCATE it. Jay Miller -Original Message- Sent: Wednesday, August 15, 2001 4:11 PM To: Multiple recipients of list ORACLE-L THAT depends on what all

RE: Speed up Truncate tables

on the new table. Jay Miller -Original Message- Sent: Wednesday, August 15, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Also,if the problem is caused by a large number of extents my understanding is that it will take just as long to DROP it as to TRUNCATE it. Jay Miller -Original

RE: OT -- training

Pretty amazing actually. I won't feel so bad about missing the cruise this year :-( If I get get to attend this one. Jay Miller -Original Message- Sent: Monday, August 13, 2001 10:21 PM To: Multiple recipients of list ORACLE-L On the other hand, I can take the day off for the NY

RE: OT -- training

that I would be sitting here with everyone asking me to do my usual work while training. Don't think I'll notice much difference. On the other hand, I can take the day off for the NY Users Group when there aren't any emergencies (about 50% of the time). Jay Miller -Original Message- Sent

RE: Extent's datafile.

a line containing: UNSUB ORACLE-L (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

RE: O/S copies of datafiles

: 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, send an E-Mail

Password_verify_function in 8.1.6 doesn't allow ALTER USER IDENTI

(*not* an option :) to each user 2) OCIPasswordChange() can be called from Powerbuilder, and where I could find sample code to do so if it is possible 3) There is any other solution? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL

RE: completely off-topic question...

: 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, send an E

RE: Unix Client Install

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

RE: Password_verify_function in 8.1.6 doesn't allow ALTER USER ID

Never mind, I just found the workaround. It just involves creating a procedure owned by system to do the actual password change. I should have thought of that :( embarassed mumbling Jay Miller -Original Message- Sent: Thursday, August 09, 2001 4:16 PM To: '[EMAIL PROTECTED

RE: import size 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: completely off-topic question...

that I know you don't like Tolkien :). Jay Miller -Original Message- Sent: Friday, August 03, 2001 6:17 PM To: Multiple recipients of list ORACLE-L -Original Message- From: Rachel Carmichael [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] I prefer Science Fantasy

RE: completely off-topic question...

Well, okay. But gee, he didn't invent his own language or anything... above should be read in a grudging and slightly whiny tone of voice Jay -Original Message- Sent: Monday, August 06, 2001 3:33 PM To: Multiple recipients of list ORACLE-L Jay, That's okay -- I'll get my mom

RE: deletion of data from a large table

Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate). Jay Miller -Original Message- Sent: Thursday, July 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L This can be done . But what about the constraints ? - Original Message - To: Multiple

RE: deletion of data from a large table

remaining, you might be able to resize the one remaining datafile down after you truncate the table. (e.g., if your initial exent is 5 Meg and you don't anticipate ever having more than 1 Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate). Jay Miller -Original Message

RE: ERROR IN INSTALING PATCH 8.1.6.3.0

We had a similar problem when installing the patchset for Oracle Client on Windows. We ended up renaming each existing .dll (.dll.old) and continuing. Worked fine. Jay Miller -Original Message- Sent: Tuesday, July 24, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Had

Tuning question - Why did this index help so much?

% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- 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: both dbms_stats dbms_utility are gathering stats on sys obj

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 / Mailing Lists

RE: Tuning question - Why did this index help so much?

rows in memory seems rather small. Hmm, is it possible to Cache an index? I just tried an ALTER INDEX xxx CACHE; command and it didn't work. Jay Miller -Original Message- Sent: Wednesday, July 25, 2001 12:57 PM To: Multiple recipients of list ORACLE-L it's possible that the index

RE: re-archiving a redo log file

, 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: Tuning question - Why did this index help so much?

Hi Tom, That's why I expected a 25% decrease in processing time (instead of reading 2 index blocks and 2 table blocks it read 2 index blocks and 1 table block). But why would it give a 75% decrease? Jay -Original Message- Sent: Wednesday, July 25, 2001 2:29 PM To: Multiple recipients

RMAN problem after Duplicate

duplicate the database I'll trash my production db. Anybody ever been here before? Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network

RE: how to run explain plan on SP???

=no explain=username/password Jay Miller -Original Message- Sent: Tuesday, July 24, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Hi, Can anyone show me how to run explain plan on a whole stored procedure? 815 on Sun 5.6. Thanks a lot. Leslie

Re: Listener Security !!

Set a password for listener administration to prevent this. PASSWORDS_LISTENER=(mysecretpassword) Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/23/01 10:11AM Hi All !! Today I came across a typical Hole in Listener Security. If you have lsnrctl

Re: RMAN

going through the school of hard knocks here, so I would love to hear from others. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/23/01 11:28AM Well looks like i've held off learning RMAN long enough, any pointers, good RTFM, etc. thanks, joe -- Please see

RE: Listener Security !!

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

Re: WinNT / 8.0.5 / Import anomaly, or is it?

The tablespace was fragmented. Restarting the database caused it to coalesce your tablespaces. You could have issued 'alter tablespace mytbs coalesce;' for each tablespace before running the import. Jay [EMAIL PROTECTED] 07/20/01 02:55PM From out of nowhere, I started getting the 'ORA

Re: New Listener Question

With 8i, the databases automatically register with the listener. You can disable it by pointing to a port that is not used by a listener. In the initSID.ora put the following entry: local_listener = (address = (protocol = tcp)(host = mymachine.mydomain.com)(port = 1522)) Jay Hostetter

Re: rman question

Joan, RMAN does not backup online redo files. If you take a cold backup, then restore it, you need to issue an 'open database resetlogs'. These documents on MetaLink may be helpful: Note: 61801.1 and Note: 106432.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA

Re: Installation oracle through responsefile

Has ANYBODY ever been able to successfully use a response file? Please share the secret with us! Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/10/01 04:35PM With WWS help, we have tried the non-interactive installation. We have NEVER gotten

A danger in cloning databases

, I first heard about it from a developer). Sigh, learn something new every day. Hope someone out there benefits from my mistake. 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

RE: OT - interviewing your superior(fun question)

:). I think it was Wired magazine that first used the word 'invented'. Jay Miller -Original Message- Sent: Thursday, June 21, 2001 11:25 PM To: Multiple recipients of list ORACLE-L Yes, the statement is different, but just based on the words in the sentence. Playing a role in inventing

RE: A danger in cloning databases

the processes here that it was 45 minutes after I restarted the listener that that our Help Desk contacted me me about the problem, I first heard about it from a developer). Sigh, learn something new every day. Hope someone out there benefits from my mistake. Jay Miller -- Please see the official ORACLE

RE: can i place online redologs with oracle engine ?

Not Complete errors and had to increase the log file size). Jay Miller -Original Message- Sent: Friday, July 06, 2001 6:51 AM To: Multiple recipients of list ORACLE-L infact i should have been more clearer offcourse i can place them on any disk..the reason i asked was... how much IO does

RE: DB Backup Question

We don't back up the filesystems that have the live data during our tape backups. Since these files are effectively unusable there's no point in saving them. Jay Miller -Original Message- Sent: Wednesday, July 11, 2001 3:29 PM To: Multiple recipients of list ORACLE-L Hi all, We

RE: Client Connection-SQLNET and?/or? ODBC.

Hello James, Every ODBC connection I've seen or used has connected through SQL Net (i.e,., app-odbc-sqlnet-database). But ODBC isn't really my area of expertise... Jay Miller -Original Message- Sent: Tuesday, July 10, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Dear DBA

RE: Gaping holes found in Oracle 8i (patch 1654631 info)

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 / Mailing Lists

RE: Good Beginner Oracle book recommendations:

phone calls and e-mails. Once things calm down (ha!) I intend to implement a thorough performance review of all our Oracle databases using that book. I'm really looking forward to it (in fact, the prospect of being able to do it is one of the few things keeping me here at the moment). Jay Miller

RE: Griping about auditing (not the Oracle Kind)

. According to my friend this goes in waves, with everyone moving to functional division, then project division, then back again. He's been through a few shifts back and forth in his time. This is my first one. Jay Miller -Original Message- Sent: Thursday, June 28, 2001 7:52 PM

RE: Griping about auditing (not the Oracle Kind)

conflict with OS stuff. Jack PS: The funniest thing is that the reviewers in general have no clue about what's going on. Miller, Jay JayMiller@TDWater To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] house.com

RE: Griping about auditing (not the Oracle Kind)

:) Thanks for helping me get it off my chest, Jay Miller -Original Message- Sent: Monday, June 25, 2001 11:07 AM To: Multiple recipients of list ORACLE-L One of the reasons DBA's are paid well is that they have total control over the production data. No matter what rules the auditors

Re: Legato NetWorker RMAN: A troublesome pair?

to backup to disk seems to save us a lot of headaches and gray hairs. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 06/26/01 02:35PM The subject line may be overstating things a bit, but I'm pretty frustrated at the moment. Backups are working fine when I run

RE: Automatic emails from Solaris

BODY, include a line containing: UNSUB ORACLE-L (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

RE: Griping about auditing (not the Oracle Kind)

to a hiring freeze). The Change Request department wasn't able to keep up. Their solution was to say 'you can't put that many changes through'. We talked them out of it but... Jay Miller Sr. Oracle DBA -Original Message- Sent: Monday, June 25, 2001 11:32 AM To: Multiple recipients of list

RE: Good Reference for interpretation of Ultbstat/estat Statspa

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

Space Manager vs. Live ReOrg vs TS ReOrg

? Also, can anyone explain the difference between Space Manager and Live ReOrg? Both are marketed by Quest, making me wonder what, if anything, is the difference... TIA J -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker INET: [EMAIL PROTECTED] Fat City

Increasing Freelists?

in the mail :). Thanks in advance. -- 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 Lists

RE: Increasing Freelists?

for 76644.1! The testing is because we are upgrading from 8.0.4 to 8.1.6 so that will simplify matters considerably. Jay -Original Message- Sent: Friday, June 15, 2001 3:27 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Hi Jay, If the table(s) need(s) to support multiple concurrent insert

Help on Upgrade - I'm an idiot

the upgrade? The patchset instructions imply not, but there's a technical forum response that implies you can. Which is it? -- 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: Help on Upgrade - I'm an idiot

to redo the upgrade from the backup. Sigh, late night ahead. -Original Message- Sent: Tuesday, June 12, 2001 4:39 PM To: Multiple recipients of list ORACLE-L There is always the ultimate last resort Jay. If you can not stop the DB any other way you can always kill all of its processes

Re: Partition Elimination

(SINGLE) TABLE ACCESS (BY LOCAL INDEX ROWID) OF DMS_AMA_RECORDS (Cost=1.69535189333285 Card=32 Bytes=3488) BITMAP CONVERSION (TO ROWIDS) BITMAP INDEX (SINGLE VALUE) OF DMS_AMA_RECORDS_UI1 Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 05/31

shmmax vs. SGA

that counts towards the shmmax? I can't find anything in my Oracle8 Unix Performance Tuning book. Thanks for any guidance! 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

RE: shmmax vs. SGA

Thanks! I'm reading the Ixora site for information on sgabeg right now (never know about the 1.7 Gig default limit before). A search of the Oracle docs and the Alomari book didn't turn up anything. From there to shudder Metalink :). Jay -Original Message- Sent: Tuesday, May 29, 2001 1

File created by failed Add Datafile command

? I was about to do that and decided to double check with the experts :) since I've never encountered the specific situation before and I still have a week before I really have to worry about space on this tablespace. Thanks in advance, Jay Miller -- Please see the official ORACLE-L FAQ: http

RE: File created by failed Add Datafile command

Hi Rachel, As mentioned, I had checked DBA_DATA_FILES and it wasn't there. Hadn't thought to use fuser, that also showed no one accessing it so I just issued the command with REUSE and it worked fine. Thanks! Jay -Original Message- Sent: Thursday, May 24, 2001 10:51 AM To: Multiple

RE: ??? how to interpret query plan

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 / Mailing Lists

BMC Patrol - 2nd Wave

, warnings, send out your resume NOW recommendations for working with the BMC Patrol product? Any experience with 2nd Wave? Thanks in advance! Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: BMC Patrol - 2nd Wave

? Thanks in advance! 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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: sys.IDL_UB1$

Thanks to everyone who replied! -Original Message- Sent: Monday, May 14, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Hi Jay, Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. I tried searching on it on Ixora

sys.IDL_UB1$

Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. I tried searching on it on Ixora on Friday but as soon as I did my computer crashed. Now that I'm back up I decided it might be safer to post here :). Thanks in advance, Jay Miller

XA Transaction Support - How to check for?

? Thanks! Oracle v. 8.0.4.3 (but finally got permission to upgrade later this year :). 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

RE: Analyze schema1.mytable from schema2 in a stored procedure

Did you grant the privileges directly or through a role? You need to grant them directly in order to have access to them in PL/SQL. Jay Miller x48355 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 9:56 AM To: Multiple recipients of list ORACLE-L

RE: Help - temp tablespace growing constantly

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: OT: Reading the Oracle Tea Leaves

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

RE: DBA_FREE_SPACE - Problem gone

the data base and restarted ? or problem gone itself without doing anything. A really weired situation. Azhar Miller, Jay JayMiller@TDWaterTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: CURSOR_SHARING=FORCE

RV_VALUE FROM REF_CODES WHERE RV_DOMAIN = 'YESNO' AND RV_ABBREVIATION = RTRIM(:b1) Jay -Original Message-From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 5:38 PMTo: Multiple recipients of list ORACLE-LSubject: CURSOR_SHARING=FORCE We have

RE: cdump, bdump, udump

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

<    1   2   3   4   5   6   >