RE:connecting session to sqlarea to find the sql_text

2002-07-22 Thread sam d
Welcome mate , Same question I posted a month back First get the select osuser,sid from v$session; then use sid in foll. query SELECT sql_text FROM v$sqlarea WHERE (address, hash_value) IN (SELECT sql_address, sql_hash_value FROM v$session WHERE sid = sid_number) --- sam d

RE: V. Urgent - Got Stuck with trigger

2002-07-22 Thread G Sanjay
Try to disable the trigger first then drop it. The error is expected because the SQL in trigger will return more than one row. HTH Sanjay -Original Message- Sent: 22 July, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Hi List, My friend has foll.(Big)problem. He'was testing

RE: V. Urgent - Got Stuck with trigger

2002-07-22 Thread G Sanjay
Just realized that alter table disable trigger will not work too.. Even if there is only one session on server it will return more than one row because of BG processes. Sanjay -Original Message- Sent: 22 July, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Hi List, My friend

download or upload.

2002-07-22 Thread Amar Kumar Padhi
Title: download or upload. Some terminology confusion. When you load a text file into the database, you call it download or upload? When you create a text file from your database you call it download or upload? rgds amar http://amzone.netfirms.com

Whistler Server (Windows .NET 2003), Longhorn, Foghorn,

2002-07-22 Thread Eric D. Pierce
The next server after Windows 2000 is going to be called something like: Windows .NET 2003 Product timeline roadmap-wise, it roughly approximates the server version of XP, although they appear to be quite a bit different (see below web sites). Excerpt from the email Bill Gates sent me

Re: V. Urgent - Got Stuck with trigger

2002-07-22 Thread chaos
sam d£¬ hei, it is easy, logon as osuser and drop the trigger, it is ok. I tested it on my 920 on linux: SQL CREATE OR REPLACE TRIGGER tpp 2before alter or create or drop on database 3 declare 4 uname varchar2(20); 5 begin 6 select username into

RE: download or upload.

2002-07-22 Thread Thomas, Kevin
I would say: When you load a text file into the database, you call it download or upload? = upload/insertion When you create a text file from your database you call it download or upload? = download/extraction Cheers, Kev. -- Please see the official ORACLE-L FAQ:

Solution: SQLLOader + nls_date_language

2002-07-22 Thread Sackwitz, Antje
Hi, I asked recently how to provide nls_date_language within sqlloader config file. [EMAIL PROTECTED] provided the solution: specify for the date column: ... date_col to_date(rtrim('Jan 15 1989 11:00:000AM',':000AM'),'Mon dd hh:mi:ss','NLS_DATE_LANGUAGE = American'), ... Antje Sackwitz --

RE: security bug - join syntax

2002-07-22 Thread Eric D. Pierce
re: Bug 2121935 ---metalink excerpts--- Doc ID: 190077.1 List of Bugs fixed in Oracle9i Release 2 base release (9.2.0.1) This is a listing of the main bugs fixed in the Oracle9i Release 2 base release. The bugs are listed in categories related to the product area and/or symptom of the bug.

Badge of Oracle8i OCP

2002-07-22 Thread Edouard Dormidontov
I get an Oracle8i OCP, but I don't receive a badge. Is it right? Thank you

RE: Badge of Oracle8i OCP

2002-07-22 Thread Farnsworth, Dave
Badges, badges,,, we don't need no stinkin badges. -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 6:38 AMTo: Multiple recipients of list ORACLE-LSubject: Badge of Oracle8i OCP I get an Oracle8i OCP, but I don't

Re: DB copying : Attack of the Clones!

2002-07-22 Thread Ruth Gramolini
The good thing with using rman online backups is no down time for production. I clone a 50 gig database in about an hour and a half. I am getting the cites ready as I write this. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July

Why Multiple Parses in Trace ?

2002-07-22 Thread VIVEK_SHARMA
Qs Why is Parse = 2 in the following Query ? Solaris 8 Oracle 8.1.7 SGA = 60 MB shared_pool_size = 30 MB select mesg, lchg_user_id, TO_CHAR(lchg_time,'DD-MM- HH24:MI:SS'), rcre_user_id,

RE: Badge of Oracle8i OCP

2002-07-22 Thread David Marshall (damarsha)
Title: Message lol /me hands the new ocp person a toffee ;-) -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: 22 July 2002 14:48To: Multiple recipients of list ORACLE-LSubject: RE: Badge of Oracle8i OCP Badges, badges,,, we don't need

Row Lock Release Without Rollback Commit ?

2002-07-22 Thread VIVEK_SHARMA
ROW Locked using SELECT FOR UPDATE Done Qs Is there any Other Possible Means of Releasing the Lock on the Row Without using COMMIT ROLLBACK Commands ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services

RE: connecting session to sqlarea to find the sql_text

2002-07-22 Thread Amar Kumar Padhi
Title: RE: connecting session to sqlarea to find the sql_text Thanks! rgds amar http://amzone.netfirms.com -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 10:04 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE:connecting session to

RE: download or upload.

2002-07-22 Thread Khedr, Waleed
Store/retrieve -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/22/02 3:53 AM Some terminology confusion. When you load a text file into the database, you call it download or upload? When you create a text file from your database you call it download or upload?

RE: Badge of Oracle8i OCP

2002-07-22 Thread Sherman, Edward
Title: Message OCP Success Kit After successfully completing all exams in the OCP Track, you will receive an OCP Success Kit which includes: * Letter of Congratulations * Oracle Certified Professional Certificate * OCP ID Card * Oracle Technology Network

RE: download or upload.

2002-07-22 Thread DENNIS WILLIAMS
Amar - From the dictionary: upload - to transfer data or programs usually from a peripheral computer to a central, often remote computer. In your question of loading a text file into a database, if the text file is already on the Oracle server, I wouldn't refer to that as an upload or download. I

RE: Badge of Oracle8i OCP

2002-07-22 Thread Boivin, Patrice J
Edouard, You will probably receive a certificate in the mail. regards, Pat. -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: Monday, July 22, 2002 9:48 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Badge of Oracle8i OCP Badges,

RE: Badge of Oracle8i OCP

2002-07-22 Thread Hately Mike
Title: Message I got the badge for my 7.3 and 8 certifications. By the time I did my 8i they'd discontinued them. They're nothing to get too excited about. Better thanIBM's DB2 pins though = ) Regards, Mike Hately Oracle DBA -Original Message-From: Sherman, Edward

Rant

2002-07-22 Thread mkb
Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real smart DBA, nor do I think that I ask particularly tough questions. The questions that I ask

FW: bind vars change explain plan

2002-07-22 Thread Baker, Barbara
prem. Never did get an answer to this question. I don't know why using bind variables changed the execution path. My best guess comes from the developer. She thinks that when we supplied the values, the optimizer knew what the range of values would be, and could therefore determine to use the

Re: Rant

2002-07-22 Thread Alan Davey
So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid

RE: Rant

2002-07-22 Thread Orr, Steve
Obviously you need to lower your standards. Maybe your test questions were culturally biased. Look at the SQLSever MySQL culture and dumb down accordingly. ;-) -Original Message- Sent: Monday, July 22, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Ok, I need to vent a little.

Re:Rant

2002-07-22 Thread dgoulet
mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do you create a table? Answer: The developer sends me a script. I run script. Question: How do you

Re: Rant

2002-07-22 Thread KENNETH JANUSZ
One thing to keep in mind is that it is easy to get rattled during a job interview and have your mind go blank on you. This is especially true with computer technical types who are basically introverts. Some years back when I was a corporate controller I interviewed a young lady for a admin

RE: bind vars change explain plan

2002-07-22 Thread Thomas, Kevin
Your colleague hit the nail on the head. Using bind variables in queries can give the database a hit or miss approach to whether or not it uses indexes. Something to do with how skewed the indexes are also. Regards, Kev. -Original Message- Sent: 22 July 2002 16:08 To: Multiple

Re: Rant

2002-07-22 Thread mkb
uh...raid. Oh yes, I have a script for that. --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We don't have to worry about backup/recovery. ;^) -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/22/02, mkb [EMAIL PROTECTED] wrote: Ok, I

Re:Rant

2002-07-22 Thread mkb
Wait, the best one yet I heard last week: 'the redo log in 9i is going away...' (Surely you mean that undo tbsp can be used instead of rollback segment tablespace, right???) Yes I see your point, but thankfully, I don't do this very often. --- [EMAIL PROTECTED] wrote: mkb, Your

Re: Rant

2002-07-22 Thread Gary Chambers
baffling and frustrating. Some of these folks claimed to have 5 years experience!!! Unfortunately for most everyone, the only people that benefit from most certification programs are the facilitators. They're cash cows for the purported issuers of such certifications. Gary Chambers

Re:FW: bind vars change explain plan

2002-07-22 Thread dgoulet
Barbara, The path that the optimizer chooses is based on what values are bound into the variables, but also on what information it has in the data dictionary. If those particular tables/indexes have not been analyzed recently then the optimizer will make wrong decisions. Also init

Re[2]: Rant

2002-07-22 Thread dgoulet
Ken, The reason I liked the guy we hired as out Junior DBA. He did not know the answer, but did know where to find it in the manuals. He also knew to calm himself down. Premature actions often cause more trouble. Dick Goulet Reply Separator

Need to have 2 Columns of Size 3000 in 1 Table to Store Character Data

2002-07-22 Thread VIVEK_SHARMA
Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ? NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table create table test10 (test1 long,test2 long); create table test10 (test1 long,test2 long)

RE: Rant

2002-07-22 Thread Grabowy, Chris
Your not the only one. I usually start my interviews with a Metalink question, like... When was the last time you used Metalink, and what problem did it help you solve? I am just amazed at the responses I get... Oh, I haven't used that tool from (take your pick) company... What is a

Re: Rant

2002-07-22 Thread Rachel Carmichael
If that weren't so devastatingly accurate here, I'd laugh. I started, asked about backups, etc etc the response was we're on a netapp filer, they don't go down sigh. they don't go down. Until they do --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We don't

Re: Rant

2002-07-22 Thread Rachel Carmichael
Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that, I asked you the theory behind that little radio button) --- mkb [EMAIL PROTECTED] wrote: Ok, I need to vent a little. Last week, I was asked to do some tech interviews

Re[2]:Rant

2002-07-22 Thread dgoulet
Thankfully neither do I. Reply Separator Author: mkb [EMAIL PROTECTED] Date: 7/22/2002 7:30 AM Wait, the best one yet I heard last week: 'the redo log in 9i is going away...' (Surely you mean that undo tbsp can be used instead of rollback segment

Re: end of correction support question

2002-07-22 Thread Eric D. Pierce
Pat, Sorry for the formatting problems, I didn't check the format of the info after doing a cut/paste from metalink. Note: | EMS includes the following: | Continuance of full metals services, | consisting of: ... -| Error Correction Support (ECS) Here

RE: Rant

2002-07-22 Thread Nirmal Kumar Muthu Kumaran
Gurus, ocp will let you enter into an interview - proved. However the candidates failed to prove it. Results spoiling the image on OCP. Nirmal. -Original Message- Sent: Monday, July 22, 2002 6:24 PM To: Multiple recipients of list ORACLE-L mkb, Your surprised? Over the last

Problem with export 8.1.7 Sun

2002-07-22 Thread Smith, Ron L.
I am having trouble with a compressed full export. If I run a an interactive export it works fine. But if I run a compressed export if fails with the following error message. The export script is identical to the one used for another sid on the same server. Only the sid is changed. .

RE: Rant

2002-07-22 Thread April Wells
you have a script that GETS rid of BUGS!?! COOL!!! -Original Message- Sent: Monday, July 22, 2002 10:33 AM To: Multiple recipients of list ORACLE-L uh...raid. Oh yes, I have a script for that. --- Alan Davey [EMAIL PROTECTED] wrote: So no one responded with, We use raid xx. We

RE: Need to have 2 Columns of Size 3000 in 1 Table to Store Chara

2002-07-22 Thread Nirmal Kumar Muthu Kumaran
create table t1 (a varchar2(4000)); hope that this will work oracle 8 and above. rgds, nirmal -Original Message- Sent: Monday, July 22, 2002 6:48 PM To: Multiple recipients of list ORACLE-L Data Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character

Re: Need to have 2 Columns of Size 3000 in 1 Table to Store Character Data

2002-07-22 Thread Igor Neyman
Why not VARCHAR2(3000) ? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 11:48 AM Data Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ?

Re:Rant

2002-07-22 Thread Rachel Carmichael
Oh I love the get a cup of coffee in other words... THINK before you act --- [EMAIL PROTECTED] wrote: mkb, Your surprised? Over the last 6 years I've interviewed many a candidate while we added two DBA's to the group. I've gotten a lot of answers like this: Question: How do

RE: Rant

2002-07-22 Thread John Weatherman
Jim, So how many like this did you hear?. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Monday, July 22, 2002 11:24 AM To: Multiple recipients of list ORACLE-L mkb, Your surprised? Over the last 6 years I've interviewed many a

RE: Rant

2002-07-22 Thread Orr, Steve
Best answer to a question I've asked: Question: You have a database crash at 6AM, what do you do. Answer: Get a cup of coffee first, then look in recovery manual. YES Once upon a time while self-employed as a high powered consultant, er uh, lowly DBA contractor, I was coming

RE: Rant

2002-07-22 Thread Vergara, Michael (TEM)
I read your rant, and I agree with you. But I do have one little itsy bitsy question... I also asked them how they'd put a tablespace in backup mode. Simple enough, right? Not one of them got it right. Not even close. Didn't have clue as to what I was talking about. Fair enough, you

Re: Need to have 2 Columns of Size 3000 in 1 Table to Store Character Data

2002-07-22 Thread Rachel Carmichael
varchar2 can go to 4000 (yes, in 8i) it's in the SQL reference manual, under datatypes --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table to Store Character Data ? NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table

RE: Rant

2002-07-22 Thread John . Hallas
Referring to the last answer about getting a coffee I don't actually think that is a bad answer!! If he meant I will not rush in and do something rash, rather I will plan what I am going to do and check the book to make sure that I am correct then I think that is a perfectly acceptable approach.

EMN0

2002-07-22 Thread April Wells
Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is Restarting dead background process EMN0 and that appears consistently before the inability to stop the database. I have created an Itar (which was down graded immediately...) and hunted for answers

RE: FW: bind vars change explain plan

2002-07-22 Thread Nicoll, Iain (Calanais)
I thought it was simply that with values the optimizer could look at the histograms to see if data was skewed, whereas it couldn't with bind variables. So the index may not have too many distinct values but the values you were supplying had less than their fair share of records. I'd guess that

RE: bind vars change explain plan

2002-07-22 Thread Cary Millsap
I think I saw the correct answer to this one shoot by on the list. In Oracle8, the use of bind variables completely prevents the Oracle query optimizer from using histograms. Could make a big difference in which plan CBO selects if there's a lot of data skew. In Oracle9, it gets a little better,

RE: Rant

2002-07-22 Thread Fink, Dan
Who needs a script! According to the advertising RAID kills BUGS dead -Original Message- Sent: Monday, July 22, 2002 10:19 AM To: Multiple recipients of list ORACLE-L you have a script that GETS rid of BUGS!?! COOL!!! -Original Message- Sent: Monday, July 22, 2002 10:33 AM To:

RE: Why Multiple Parses in Trace ?

2002-07-22 Thread Cary Millsap
...Because the application requested two parse calls for this statement from the server. The first one was a hard parse (server had never seen the statement before), and the second one was a parse call that did not result in a hard parse. Cary Millsap Hotsos Enterprises, Ltd.

Re: Rant

2002-07-22 Thread Rachel Carmichael
even so, I'd rather have someone tell me my mind has gone blank, but I know I can look it up in this manual --- KENNETH JANUSZ [EMAIL PROTECTED] wrote: One thing to keep in mind is that it is easy to get rattled during a job interview and have your mind go blank on you. This is especially

Re: Re[2]: Rant

2002-07-22 Thread Eric D. Pierce
only a dba would think of drinking coffee as something that would calm one down! har har har On 22 Jul 2002 at 7:43, [EMAIL PROTECTED] wrote: The reason I liked the guy we hired as out Junior DBA. He did not know the answer, but did know where to find it in the manuals. He also

RE: Rant

2002-07-22 Thread April Wells
IT'S NOT a radio button... It is a regular CLICKY button geez -Original Message- Sent: Monday, July 22, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Good rant. :) I sympathize. The answer I get more and more is I click on this item on the GUI... (I didn't ask you that,

Re: Rant-Rant

2002-07-22 Thread Robert Monical
I have been reading this list for the past several months as I prepare to move my universe of databases from 7.3 to 9 (probably 9) and I have a rant of my own. It seems that the implicit expectation is that every DBA should be or should aspire to be a Master Technical DBA. I have a slightly

RE: Rant

2002-07-22 Thread Eric D. Pierce
re: Results spoiling the image on OCP. what image, the marketing people's garbage? the clueless HR departments? big software companies make a lot of money from training and certification, so they have an incentive to selectively present information in such a way as to convince the

dbms_stats vs analyze for statistics

2002-07-22 Thread Jeffrey Beckstrom
Doing a dbms_stats with method option of 'for all indexed columns size 254' with compute optin. I notice that only indexed columns are getting column stats - as expected. Howver, if do an anaylze command instead, all columns get some sort of stats. For non-index columns, stats are

RE: Rant

2002-07-22 Thread Cunningham, Gerald
My favorite is when they claim to run an n Terabyte database, and I ask them how they back it up... uh we don't back it up yet... Bzzzt!! Thank you for playing, bye bye! P.s. I liked your rant... -Original Message- Sent: Monday, July 22, 2002 12:19 PM To: Multiple recipients

RE: Rant

2002-07-22 Thread Baker, Barbara
Hm. these are almost verbatim the instructions I got from Rachel Charmichael after we lost a disk drive and I'd been trying to recover a database for nearly 20 hours. (That was immediately before she steered me towards the magic command that recovered the database.)

Re:RE: Rant

2002-07-22 Thread dgoulet
I have, no fun. But at least your only fooling around with one tablespace and/or file vs. the entire database. The method is rather simple: 1) The tablespace/datafile are already offline, SMON does this for you unless it's SYSTEM in which case your not doing this in the first place.

RE: EMN0

2002-07-22 Thread Vergara, Michael (TEM)
April: I just had something like this over the weekend. In my case, the server was trying to run 'dbms_java.stop_server'. There was some mysterious corruption in the stored Java classes that was making this process hang. If you look at 'ps' or 'top', do you see the client process from

RE: FW: bind vars change explain plan

2002-07-22 Thread Paula_Stankus
Title: RE: FW: bind vars change explain plan Guys, The developer is right. The fact is that the optimizer not knowing what the value will be might not use PK or other indexes when you think it should - have seen this before. The solution in our case since the index had more than one column

RE: Rant

2002-07-22 Thread Rachel Carmichael
you can see how often I use the GUI :) OBTW.. for those of you who are OEM fans... I heard a rumor (from a fairly well-informed, usually accurate source) that Oracle's changing it all again. T --- April Wells [EMAIL PROTECTED] wrote: IT'S NOT a radio button... It is a regular CLICKY button

RE: Re[2]: Rant

2002-07-22 Thread Boivin, Patrice J
Caffeine calms down hyperactive people, it's one of the symptoms for that condition. As for me, beer puts me to sleep. I don't know what THAT means. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology

Moving tables from one schema to another

2002-07-22 Thread Peter . McLarty
Hi I have a user with a schema and want to move that schema to another user. I don't need the original user after the change Can I do this without an export/import. All data and tables in this database I care about is in this schema Cheers --

Oracle on Linux ..... Red Hat vs. Suse

2002-07-22 Thread Christopher Royce
Have been unable to arrive at a definitive position regarding the question of 'which is the preferred distribution of Linux vis-à-vis Oracle'. I have inherited Suse Oracle Implementations which are Oracle Corp. certified and have had little or no problems. There are other Red Hat

Re:RE: Rant

2002-07-22 Thread dgoulet
YUP, Saw the new version at an Oracle event in Boston a couple of months ago. Seems that nothing is sacred anymore. BTW: Installer changes too, now you need a full multimedia terminal, 4 channel audio VR headset recommended. :o) Dick Goulet Reply

Re: Using Old version of SQL Navigator 2.0.d with Oracle 9i.

2002-07-22 Thread Dharminder Kumar
As I was trying to get this scenario worked out, so here is what I have done to get this combination working. I deinstalled the Oracle 9i software, then installed SQL plus client for Oracle 7.3 using a Developer 2000 CD. After than I installed Oracle 9i to a different Oracle Home and now OLD Sql

RE: Re[2]: Rant

2002-07-22 Thread April Wells
And coffee is WAY cheaper than Addrell (my son's prescription). Caffeine helps hyperactive people focus. -Original Message- Sent: Monday, July 22, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Caffeine calms down hyperactive people, it's one of the symptoms for that condition.

RE: Re[2]: Rant

2002-07-22 Thread Jesse, Rich
Interesting. Coffee has a calming effect? I prefer the good ACME Earthquake Pill effect of iced tea, myself. ;) The last time we had a developer truncate a 3M row table, I had fun with it. Fun because some of our recovery implementations were finally proven successful, no data was lost, and

RE: Moving tables from one schema to another

2002-07-22 Thread Richard Huntley
Title: RE: Moving tables from one schema to another 1. create new user 2. export schema with data and tables you care about 3. import to newly created schema using parameters fromuser/touser 4. drop old user -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

RE: end of correction support question

2002-07-22 Thread Boivin, Patrice J
Oracle Support replied: 19-JUL-02 15:23:30 UPDATE You are mostly correct. ECS is only for supported versions of Oracle. However, there are some exceptions. Customers running Oracle Applications (E-Business Suite) have full support on certain versions of Oracle software depending on the

RE: Rant

2002-07-22 Thread Vergara, Michael (TEM)
I was told that same thing in an interview. He said I don't know is not a good answer. I don't know, but I know where to find out. is much better. -Original Message- Sent: Monday, July 22, 2002 9:54 AM To: Multiple recipients of list ORACLE-L even so, I'd rather have someone tell me

RE: T3's and forcedirectio questions

2002-07-22 Thread kkennedy
For setting the db_multiblock_read_count, I suggest the Steve Adams script multiblock_read_test.sql which, on my system, yielded 16 with a block size of 8K. For the optimizer settings, I used the Tim Gorman recommendations from http://www.evdbt.com/SearchIntelligenceCBO.doc which, on my

RE: EMN0

2002-07-22 Thread Farnsworth, Dave
April, I have been fighting this since installing 8.1.7 on windoze. I do an shutdown immediate in my backup script and then it will hang forever periodically. I have not had a solution suggested that has worked. Hope you get better results than I. Are you on windoze also? I know that

[no subject]

2002-07-22 Thread Peter R
Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger:

RE: Rant

2002-07-22 Thread mkb
Checking the FM (Oracle 9i Backup and Recovery Concepts). Page 4-16 gives a high level overview of the principles and Oracle 9i User Managed Backup and Recovery, chapter 4 gives a detailed description. Scenario - Loss of one or more datafiles (NOT SYSTEM) In archivelog mode Database

Re: Rant

2002-07-22 Thread Ruth Gramolini
You have to restore the tablespace with the datafile you want to restore to a clone database and export the datafile's contents from the clone and import it into the database with the bad datafile. HTH, R - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Customized reporting for STATSPACK?

2002-07-22 Thread Jesse, Rich
Hey all, Finally have installed STATSPACK on 8.1.7.2.0, but am disappointed at the archaic two-lines-per-row 80-columns in spreport.sql. Anyone have any links to some report SQL that formats STATSPACK reports a little better? I'll probably use TOAD for my usage, but I'll take anything to

RE: Rant

2002-07-22 Thread Mercadante, Thomas F
that Rachel - what a gal! PS - -- - That Barbara, what a suck-up! :) -Original Message- Sent: Monday, July 22, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Hm. these are almost verbatim the instructions I got from Rachel Charmichael after we lost a disk drive and I'd

RE: Rant

2002-07-22 Thread Orr, Steve
For the GUI-challenged... Hopefully Oracle will offer a class on OEM new features with a certification test on OEM... Probably only a $2000 package and Oracle will market this so headhunters will require OEM button clicking certification before granting an interview. Feeling better now.

RE: Unindexed foreign key

2002-07-22 Thread Freeman, Robert
Perhaps that would be a better way of putting it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i  (Sybex) Clark Griswold:

RE: Rant

2002-07-22 Thread Freeman, Robert
The interview (exerpts from some of my actual ones, and then some made up) We are in my cube. I've studied the resume for Mr. Morias, who is a Portuguese national who's degree is from University who's name I can't pronounce and who's credentials I can't verify. He is a brand new OCP. Me: Good

Re[2]: Using Old version of SQL Navigator 2.0.d with Oracle

2002-07-22 Thread dgoulet
OY, what a cludge!! Dick Goulet Reply Separator Author: Dharminder Kumar [EMAIL PROTECTED] Date: 7/22/2002 8:58 AM As I was trying to get this scenario worked out, so here is what I have done to get this combination working. I deinstalled the

Re:

2002-07-22 Thread dgoulet
Peter, If you want to be obsessive-compulsive safe, shutdown the database. Otherwise update the system clock and don't worry about it. Our HP-UX boxes do that every spring all by themselves. Haven't had a database problem yet. Dick Goulet Reply

RE: security bug - join syntax

2002-07-22 Thread Freeman, Robert
Bug is fixed in 9.0.1.3 (or was it .2, I forget), and is not present in 9.2 (9iR2). A backport for 9.0.1.1 is available as I recall. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)

RE: EMN0

2002-07-22 Thread April Wells
There is no EMN0 process out there TO kill... that is what concerns me. There are also no user connections (haven't had the listener started in a while... it is (so far) for user testing patches, and we haven't had any patches since we got TEST. Quite honestly I like your solution better than

Re: Re[2]: Rant

2002-07-22 Thread Ruth Gramolini
It might mean that you are not a fun dataRuth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 22, 2002 2:03 PM Caffeine calms down hyperactive people, it's one of the symptoms for that condition. As for me, beer puts me to sleep.

Re[2]: Rant

2002-07-22 Thread dgoulet
Ruth, Excuse me, but how is that going to fix the bad datafile? Dick Goulet Reply Separator Author: Ruth Gramolini [EMAIL PROTECTED] Date: 7/22/2002 10:13 AM You have to restore the tablespace with the datafile you want to restore to a clone

RE: Rant

2002-07-22 Thread Rachel Carmichael
OH MY GOD, someone remembers what I said? thank goodness it worked. I've learned that my first, panicked reaction is almost invariably, if not wrong, certainly not the best way to fix something. Taking time to THINK instead of jumping in and mucking about is usually best. you can now see how

RE: OT: MicroSoft Admission

2002-07-22 Thread kkennedy
Why, it simply means that appearances are everything at M$. Let's read it carefully: Our strategy has never changed -- i.e., our consultants have always been your foe. but, it sure looked that way -- i.e., our customers started seeing our consultants as foes. diaslignment between our

RE: Rant-Rant

2002-07-22 Thread Mercadante, Thomas F
OMG! A Socialist in the group! I believe that if we think about these things in a way that we ask ourselves how can I maximize the potential of this person in our organization, pay him/her a fair wage for what they can do, and free up my time to address the really gnarly stuff we can help

Re:RE: Rant

2002-07-22 Thread Rachel Carmichael
um no, I mean they are redoing it AGAIN I love Oracle, it provides me with an ever and ever steeper learning curve --- [EMAIL PROTECTED] wrote: YUP, Saw the new version at an Oracle event in Boston a couple of months ago. Seems that nothing is sacred anymore. BTW: Installer

RE: Rant

2002-07-22 Thread Baker, Barbara
You better believe it!!! next time I've been up a gazillion hours and I'm begging for help, I want the goddess to think kindly of me. -- From: Mercadante, Thomas F[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, July 22, 2002 12:08 PM To:

RE:

2002-07-22 Thread Mercadante, Thomas F
Peter, Doesn't matter. Only if you are using Oracle Jobs does the time make any difference - because some jobs will lose their minds when the time changes. Same thing with any cron jobs - I would disable them before you change the time. Within Oracle itself, time is not important. All

RE: Re[2]: Rant

2002-07-22 Thread Mercadante, Thomas F
Coffee in the moring for me gives me a boost. Coffee in the afternoon/evening puts me to sleep. You're a psycho/No I'm Not! Tom (splitting personalities) Mercadante -Original Message- Sent: Monday, July 22, 2002 2:29 PM To: Multiple recipients of list ORACLE-L And coffee is WAY

  1   2   >