RE: TEST

Title: TEST What are you testing? -Original Message-From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: TEST TESTING ...

Re: Oracle web application

On Sat, 18 May 2002, Keith Carney wrote: I am a beginner in Oracle and I need help. I need to implement a interactive connection of oracle with web. I need to save data from web to database, make a kind of processing and send a response to the web. I have no idea even how to make the

RE: Platinum Fastunloader

Thanks for all the replies chaps. Its a legacy product here and we needed to see if it was licenced correctly. It looks like we are going to dump it anyway. Regards Lee -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: 17 May 2002 17:38To: Multiple

What makes Export slow ?

Hi guys, I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I

tns-12541 no listener while using connection manager

Hi friends. I am having a problem when trying to connect through connection manger i have in my tnsnames.ora and cman.ora as given below then use_cman = TRUE in sqlnet.ora and my server is configured for MTS . It's on oracle 8.1.7 in win 2k . - TNSNAMES.ORA

Errors on Alert file

Hi All, Is it normal that after a shutdown immediate of a database (Oracle 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City

rman

Title: RE: [Q] what difference between count(0), count(1) and Hi Please can you help/advise with an rman problem we are having. We are getting the following error when trying to backup a database: RMAN-20011: target database incarnation is not current in recovery catalog If I look in

SQL Server to Oracle DB

Title: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.

RE: Errors on Alert file

Title: RE: Errors on Alert file ORA-00602 ORA-00602internal programming exception Cause:An internal programming exception has occurred. Action:Report this error as a program bug to Worldwide Customer Support. nirmal. -Original Message- From: GL2Z/ INF DBA BENLATRECHE

RE: Connecting to DB from behind a firewall - solved !

thanks a lot to all who responded !!! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, May 20, 2002 3:27 PM To: [EMAIL PROTECTED] Oracle has a registry setting that will force all traffic for a session through the same port that the

Finally....DBNEWID

Just a FYI... Anyone using RMAN will know the joy of Rman getting very upset if you pretty much do anything with a database that has been cloned from another. (According to the doco) in 9i.2, the rumoured DBNEWID is now available so you can change the database id or database name. Cheers

RE: Errors on Alert file

No. Which patch level is your 8.1.7? Are any trace files generated? Have you checked Metalink? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Hi All, Is it normal that after a

Re: rman

You won't hose the backup you need. You can use rman nocatalog if there is a problem with the incarnation. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:58 AM Hi Please can you help/advise with an rman problem we

RE: Upgrade and it says it doesn't need it

Unfortunately - this is what I'm having a problem with. I did install with OUI. The log files from that installation are in the oraInventory directory. Subsequently, I installed some client software (precompilers) on the machine. The oraInventory only shows the client installation, not the

RE: TEST

Your shift key is not working correctly -Original Message- Sent: Monday, May 20, 2002 1:18 AM To: Multiple recipients of list ORACLE-L TESTING ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat

Numeric comparison in DECODE statement

I was wondering if anyone might have tried this before, because I can't seem to get it to work. I'd like to be able to determine which unit of measure to concatenate to a value by using a decode statement in the query. I have a column in the database that stores time in minutes, and I'd like

RE: SQL Server to Oracle DB

Title: SQL Server to Oracle DB Use BCP to export data from SQL Server and SQL Load import data into Oracle DB. Brian Chen -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject:

Re: Do you ever have days where you dont want to think ?

as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- ||

RE: rman

Fawzia - I have not experienced your error, so these are just some thoughts. Have you checked the dbid in RMAN and in the database (v$database)? Have you performed an O.S. clone of the database? Metalink has quite a few entries on 20011 that may provide some ideas. If you need to reset the

sql server to oracle db

Rich, since you have SQL SERVER, do you have DTS?, thats the easiest way to move he data around. joe

Re:Numeric comparison in DECODE statement

Robert, That won't work. Decode works like a switch statement. If condition 1 then value 1. You can't imbed logic operators therein. DickG. Reply Separator Author: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED] Date: 5/20/2002 7:08

RE: Numeric comparison in DECODE statement

How about select to_char(floor(my_col_in_minutes/60), '990') || ':' || to_char(mod(my_col_in_minutes, 60)) HH:MI from dual / __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here

Re: Do you ever have days where you dont want to think ?

Stephane, I *did* warn you about the OT list before I approved your registration on it.. btw, this sounds like it should have gone private, not to the list Rachel |+--- || | || | ||

RE: Compressing Export Dumps

Simon - I'll repeat (for the third time, I believe) that this sounds like an ideal use for database cloning. Much faster, and as a bonus you get to test your backups, which is always an excellent idea. More information can be found at

Re: Oracle web application

Hi Dennis, my name is Aida, (my fault about this) Keith is my husband (I love to bother him). Thank you for answering to me, I really appreciate it. Let me explain more clear the situation. I am a graduate student at Stephen F. Austin State University in computer science department. I will

RE: Errors on Alert file

Hello DENNIS, Our patch level is 8.1.7.2.2 running under Netware 5.1. I think it's the latest patch that we found on Metalink. Best Regards Kamel Benlatreche -Message d'origine- De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Envoyé : lundi 20 mai 2002 14:23 À : Multiple recipients

RE: Do you ever have days where you dont want to think ?

Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message-

RE: SQL Server to Oracle DB

Title: SQL Server to Oracle DB I would use SQL Servers DTS tool. It is relatively easy depending on how much data you have to move. I use it fasirly often to move data between Oracle, SQL Server, DB2 and other data sources. Dave -Original Message-From: Richard Huntley

Re: Do you ever have days where you dont want to think ?

This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I

RE: Numeric comparison in DECODE statement

I think in this case you're suppose to use sign as decode was only meant to deal with specific values e.g. SELECT DECODE(SIGN(:in_value - 60),1,TO_CHAR(:in_value/60, '9.99')||' hours', -1,TO_CHAR(TO_CHAR(:in_value))||' minutes',

Re: SQL Server to Oracle DB

Title: SQL Server to Oracle DB Richard: Yes. The way I've done it in the past is to generate tilde (~) delimited flat files and then load the data into Oracle via SQL*Loader. You have to do a mapping first before using SQL*Loader. Then you have to write scripts for each table you are

Re:Numeric comparison in DECODE statement

Don't use DECODE, but CASE SELECT TO_CHAR( CASE WHEN in_value 60 THEN in_value ELSE in_value/60 END , '9.99' ) FROM DUAL; JP Reply Separator Author: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED] Date: 5/20/2002 7:08

RE: Do you ever have days where you dont want to think ?

How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how

RE: SQL Server to Oracle DB

Title: SQL Server to Oracle DB You can use BCP Utility (SQL Server side), to download SQL SERVER data into a flat file (text file) and then you can use SQLLOADER (Oracle Side). I hope it may helps you Best Regards Kamel Benlatreche -Message d'origine-De: Richard Huntley

Re: Numeric comparison in DECODE statement

Yexley Robert D Contr Det 1 AFRL/WSI wrote: I was wondering if anyone might have tried this before, because I can't seem to get it to work. I'd like to be able to determine which unit of measure to concatenate to a value by using a decode statement in the query. I have a column in the

9i r2

2 of the files downloaded, will be loading it up today,. woohoo, can anyone say crash and burn, bwahahahahahaha joe

Re: Do you ever have days where you dont want to think ?

[EMAIL PROTECTED] wrote: as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel Well, coming from me 'honorary

RE: SQL Server to Oracle DB

Title: Message If your Oracle platform is Windows, take a look at Heterogeneous Services. I just tried it Friday for the first time to load data from an Excel spreadsheet and it seems to work pretty well. Should work for SQL Server. HTH, Beth -Original Message-From: Richard

RE: SQL Server to Oracle DB

Title: SQL Server to Oracle DB Use the SQLServer DTS package. Under the SQLServer program menu, choose the import/export option, and it will start a Data Transformation Service wizard type thing for you. You can also do SQL transformations and alike as well, by opening the SQL Server

Complementary ODTUG 2002 Registrations

as customers, we just received this. Should be open to all: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ:

RE: Do you ever have days where you dont want to think ?

If we told you, we would have to kill you ;P You will need to be a registered user of Yahoo (have a Yahoo logon/password). Go to: http://groups.yahoo.com/group/oracle-l-ot And click join this group. You will then be prompted for info such as how you want to receive the messages etc.. HTH

Anyone using 8.1.7.4

I have an upgrade of Oracle 7.3.4 on NT. I hear 8.1.7.3 had a lot of bugs. Should I go with 8.1.7.4? Any experience with 8.1.7.4? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

RE: Numeric comparison in DECODE statement

You can also implement your logic as SELECT DECODE(SIGN(in_value-60), -1, TO_CHAR(in_value)||' minutes', TO_CHAR(in_value/60, '9.99')||' hours') FROM dual / HTH Raj __ Rajendra Jamadagni MIS, ESPN

RE: Do you ever have days where you dont want to think ?

One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To:

Re:Numeric comparison in DECODE statement

You can do numeric logic by using the SIGN() function. Here is the solution I think he was looking for: SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570r 1 select ltrim(decode(sign(minutes - 59), 1, to_char(minutes/60, '9.99') ||' hours', 2

Re: Upgrade and it says it doesn't need it

log a tar... sorry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 8:58 AM Unfortunately - this is what I'm having a problem with. I did install with OUI. The log files from that installation are in the oraInventory

RE: What makes Export slow ?

Would you post the parameter file ?? Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , and also you can have a look at the DISK I/O stats ( verify the OFA is same on both the boxes ). Thanks, Madhu -Original Message- Sent:

Re: Do you ever have days where you dont want to think ?

oh I never said it was an honor to be considered a man. --- Ruth Gramolini [EMAIL PROTECTED] wrote: This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list

wait event trace file formatter?

I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED]

RE: Do you ever have days where you dont want to think ?

it's joe's list --- Grabowy, Chris [EMAIL PROTECTED] wrote: One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message-

Re: SQL Server to Oracle DB

Title: SQL Server to Oracle DB ...speaking of $0.02, make sure that the utilityfrom SQL Server that produces the "flat" file does not perform unsolicited rounding of numerics. I was recently burned on a Sybase-Oracle conversion when the BCP (a.k.a. "bulk copy") and ISQL (a.k.a. SQL*Plus in

RE: Oracle web application

Aida - Now that you have described your situation more clearly, I would second the advice you received from Sean - use PHP if you can. While this task can be accomplished with just about any language, with some choices you will spend a lot of time getting everything set up. And you probably would

RE: Do you ever have days where you dont want to think ?

All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L we want jpegs !!! :-) -Original Message- Sent: 20 May 2002 17:03 To: Multiple recipients of list ORACLE-L Hehe... I

Re: wait event trace file formatter?

Hi: Check 'itprof' at http://www.ubtools.com or 'Sparky' at http://www.hotsos.com I have used the first one found very good. --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps

RE: ORA-01722 Error after DBA changes

Hi, Not sure about exact reason. But I am also having similar condition like yours. One of my customers was running 8.1.5 with Forms5. I upgraded his DB to 8.1.7. And I started facing problem with some reports. I got answer from Oracle saying - this combination is not certified. Oracle has done

RE: What makes Export slow ?

On Mon, 20 May 2002, Reddy, Madhusudana wrote: Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , What do you mean assigning the big rollback segment? How do you do that to an export and what does it accomplish? What does COMMIT=Y do

TEMP TABLESPACE

Hi List, I have two data files for my TEMP tablespace, i just find out one of the data file AUTO EXTEND is set to on is it right?? I beleive for TEMP tablespace autoextend shoudn't be ON, AM I RIGHT or NOT? Now my data file almost full for TEMP tablespace how can I Clean it up, I run ALTER

Re: Do you ever have days where you dont want to think ?

But the original poster and some of the others seem to think that this would be an honor...RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 1:33 PM oh I never said it was an honor to be considered a man. --- Ruth

RE: Do you ever have days where you dont want to think ?

What is 'get out more'? -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L

OT: Ray Lane sighting

Check out http://www.dominionpost.com Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

off topic list

send an email to [EMAIL PROTECTED] be prepared for a LOT of chatter it's being used more like a chat room than a bulletin board/email list. We started it on Sept 13 last year and are over 20,000 messages already. on the other hand, the chatter tends to be either funny, informative or

Re: Errors on Alert file

It was Abby something. Abby who? Abby...Abby Normal that's it. On Mon, May 20, 2002 at 06:38:25AM -0800, Nirmal Kumar Muthu Kumaran wrote: ORA-00602 ORA-00602internal programming exception Cause:An internal programming exception has occurred. Action:Report this error as a program

RE: wait event trace file formatter?

Tkprof ?? I was just reading 9iR2 notes and it seems there is a new parameter for tkprof 'wait events' that will list waits (if available) in the file per cursor, very useful feature. Raj __ Rajendra Jamadagni MIS, ESPN Inc.

RE: wait event trace file formatter?

If you are on 9i, tkprof now includes that functionality. Otherwise hotsos.com is one of the source for such a tool. Mohammed Ahsanuddin Oracle DBA -Original Message- Sent: Monday, May 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L I'm looking for a way to format a trace

RE: Do you ever have days where you dont want to think ?

Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more

Re: wait event trace file formatter?

ITRPROF from http://www.ubtools.com/products/itrprof/itrprof.html and I believe that www.hotsos.com has a new 10046 trace analyzer as well... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:03 AM I'm looking for a way to

RE: Do you ever have days where you dont want to think ?

Yeah, so. I would think for the right amount of money, he would put on a wig and dress... -Original Message- Sent: Monday, May 20, 2002 1:54 PM To: Multiple recipients of list ORACLE-L it's joe's list --- Grabowy, Chris [EMAIL PROTECTED] wrote: One makes a large cash offering to the

Re: Do you ever have days where you dont want to think ?

ah but who says Henry Higgins was right? --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being

SHARED POOL SIZE

HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any

RE: TEMP TABLESPACE

Hamid, 1) Do not let TEMP tablespace have autoextend set to on - my .02 is to never have this set to on for any tablespace, but to monitor and expand as necessary. Other DBAs like autoextend, so you may want that for other tablespaces, but not for TEMP. 2) A nice trick to get TEMP cleared of

RE: Do you ever have days where you dont want to think ?

ROFL -- this whole thread has kept me cracking up all morning !!! -- (Mrs.) JoJo :D -Original Message- Paul R. Sent: Monday, May 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on

RE: SHARED POOL SIZE

Yes, upgrade to 9.0.1. Oops, you'll also have to shut down to do that. Well, I guess the answer comes down to . . . . no. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE

RE: SHARED POOL SIZE

Hamid, Check v$parameter table and it will tell you if a given parameter that is used and/or defaulted, is system or session modifiable. Whether or not to modify, if a given parameter is session or system modifiable, is left up to the discretion and experience of the DBA. By the way, the

RE: SHARED POOL SIZE

No. This is not one of the parameters that can be set on the fly... Regards, Melanie Burns -Original Message- Sent: Monday, May 20, 2002 2:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON

Re: SQL Server to Oracle DB

The code to do this in Perl is trivial, and you get the bonus of complete control, as well as the ability to generate sqlloader control and paramters files on the fly. Jared Still Oracle DBA and Part Time Perl Evangelist ( feels like full time lately ) Tim Gorman [EMAIL PROTECTED] Sent

Re: AQ using a trigger?

My limited knowledge of AQ would lead me to believe that you're trying to reinvent the wheel. Maybe you should spend more time on the AQ docs? Jared YTTRI Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/17/2002 02:38 PM Please respond to ORACLE-L To: Multiple recipients

Re: SHARED POOL SIZE

No. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE

Patch: 1951929

Has anyone applied this? The last sentence from support, copied below, gives me the creeps: Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1951929 - RECIEVING MANY ORA-07445 [KQRGCU()+244]ERRORS Customers are reminded

Re: Do you ever have days where you dont want to think ?

Sherman, Paul R. wrote: Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into.

Re: SQL Server to Oracle DB

All this coding stuff is fine if there is a one-to-one correlation between the SQL Server tables and the Oracle tables. If not, then the first thing that needs to be accomplished is mapping the SQL Server tables to Oracle. This can be a fun job especially if data is required in Oracle that

RE: wait event trace file formatter?

Unfortunately this is 8.1.7 (sorry I didn't specify). A note on Metalink makes reference to a formatting utility but, of course, neither includes nor specifies where to find said utility. --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Tkprof ?? I was just reading 9iR2 notes and it seems

DB Clone from RMAN backups

Hi all, I am trying to speed up refreshes of QA databases and am familiar with cloning databases using user managed backups (hot and cold). The problem is the organization I am currently with uses RMAN to manage the backups. The perform a level 0 once a month, level 1 once a week, level 2

RE: What makes Export slow ?

--- Jeremiah Wilton [EMAIL PROTECTED] wrote: On Mon, 20 May 2002, Reddy, Madhusudana wrote: Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , What does COMMIT=Y do in an export? it causes an error message!

RE: What makes Export slow ?

The idea of huge rollback segment is just to eliminate the contention the rollback segment. Well its not always applicable ( possible make sure all the other applications are not used), but we can create a big rollback segment and bring it on line and make other rollback segments offline, and run

RE: SHARED POOL SIZE

Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple

Re: Do you ever have days where you dont want to think ?

My favorite Shakespearean (sp?) play and yes, I think we should move this to the OT list :) --- Stephane Faroult [EMAIL PROTECTED] wrote: Sherman, Paul R. wrote: Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing

RE: Patch: 1951929

Title: RE: Patch: 1951929 This pretty much boilerplate text I've seen on LOTS of patches from Oracle. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Monday, May

RE: SHARED POOL SIZE

No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL / NAME

RE: Korn Shell Sqlplus

Michael - I have noticed the same issue you describe - ie. after the sqlplus process terminates, the shadow process continues to completion (assuming there is a COMMIT in the script). We are also on Compaq Tru64, but Oracle 8.1.6. I have only noticed it, not had a reason to dig in and

RE: DB Clone from RMAN backups

Michele - Have you looked at the RMAN DUPLICATE command? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Hi all, I am trying to speed up refreshes of QA databases and am familiar

Re: Korn Shell Sqlplus

Hand, Michael T wrote: Maybe one of you has some inspiration. Environment: Compaq Tru64 5.1; Oracle 8.1.7.3 The concept is for a parent Korn shell to spawn a sqlplus child in background (which will validate table structure via a PL/SQL Block) then wait for a fixed time period

RE: wait event trace file formatter?

Paul: I think you are talking about the support tool TRCSUMMARY. IT is a perl script from oracle Support. You can get it externally if you have some friends in Oracle Support ;) --- Paul Baumgartel [EMAIL PROTECTED] wrote: Unfortunately this is 8.1.7 (sorry I didn't specify). A note on

RE: SHARED POOL SIZE

Title: RE: SHARED POOL SIZE The value of IMMEDIATE in the ISSYS_MODIFIABLE column means that it IS modifiable and takes effect immediately. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: [EMAIL PROTECTED]

RE: Do you ever have days where you dont want to think ?

Try sending message to: [EMAIL PROTECTED] On Mon, 2002-05-20 at 11:33, Freeman, Robert wrote: How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the

DECODE HELP

Hello all, This has probably been discussed here before and I'm sorry if I'm repeating this. But I'd very much appreciate if someone could show me how to use DECODE to select a MAX date where records are like this: PRIM. KEY FIRST_DATE SEC_DATE THIRD_DATE JO001599O 12/14/2000 03/23/2001

Re: 9i r2

Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Jared JOE TESTA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 08:23 AM Please

Re: oracle job question

What if I have jobs scheduled at 2:15 , 2:30 , 3:00 . Will oracle run them all at once if database is up at 4:00 . -Ajay - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 1:17 PM BigP wrote: Hi List , I have a question

RE: What makes Export slow ?

On Mon, 20 May 2002, Reddy, Madhusudana wrote: The idea of huge rollback segment is just to eliminate the contention the rollback segment. Well its not always applicable ( possible make sure all the other applications are not used), but we can create a big rollback segment and bring it on

RE: wait event trace file formatter?

Resend -Original Message- Sent: Monday, May 20, 2002 2:57 PM To: '[EMAIL PROTECTED]' Paul - We had this discussion last week, so you can probably search the archives and get answers. What I received from the discussion is that it is probably simple to create a simple trace file

Re: DECODE HELP

Why use decode. Look up the greatest sql function. select prim_key, greatest(first_date,sec_date,third_date) from your_table. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats.

  1   2   >