Re: Oracle From a Sybase DBA perspective

2002-03-30 Thread Jared Still
There's a lot of junk here, that's for sure. The reason for replying to it is that this thing get's passed around among the Sybase types and it's rather misleading. I'm not trying to foment a religious war, just answer the half truths and misinformation. Jared On Friday 29 March 2002 14:3

Re: Oracle From a Sybase DBA perspective| What is a Database to S

2002-03-30 Thread Jared Still
> Sybase database = Oracle tablespace My impression was that a Sybase database was more akin to an Oracle Schema. Mind you I've had the training for Sybase, but haven't done much with it. I'm thankful too, I didn't care for it much. Jared On Saturday 30 March 2002 04:23, Rachel Carmichael

Re: Do programmers tune SQL?

2002-03-30 Thread Jared Still
I'll take a case of Lagavulin or Glenmorangie, you decide. Email me off list for my shipping address. Jared On Friday 29 March 2002 18:03, Larry Elkins wrote: > Greg, > > You *do* see DBA's doing the bulk of the SQL tuning work in many shops. But > it's not necessarily because the developers,

RE: Do programmers tune SQL?

2002-03-30 Thread Rachel Carmichael
I WISH I owned that website :) as for the programmers well, it was a thought. Obviously not the right one in this case, but it was a thought. enjoy the rain, I hear you guys are sending it our way Rachel --- Larry Elkins <[EMAIL PROTECTED]> wrote: > > From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Oracle From a Sybase DBA perspective| What is a Database to S

2002-03-30 Thread Rachel Carmichael
oops, well, I haven't SEEN Sybase for at least 4.5 years so am I forgiven? So, how would you translate the dbo user? SYSTEM? Any account with DBA role? --- Mark Leith <[EMAIL PROTECTED]> wrote: > You pretty much hit it on the head Rachel, except: > > Sybase sa user = Oracle sys user > > ---

Re: Oracle From a Sybase DBA perspective

2002-03-30 Thread Rachel Carmichael
Oracle does not use the redo logs to create the index. It uses the redo logs to RECORD the creation effort if logging is on. Semantics perhaps but important. If Sybase does not write to the journal file when an index is created, then if the database has to be recreated, how does it know that the

Re: DRPP Paper

2002-03-30 Thread Danisment Gazi Unal
Hello Rajesh and the list, Since some others asked some questions, I'm CCing the list. Sorry for that. I've renamed DRPP to MRPP(Microstate Response-time Performance Porfiling). I'll add some further tests to MRPP to make it more practical. Most probably it'll be availabe in 2-3 months. Sorry li

RE:

2002-03-30 Thread Deshpande, Kirti
RTFM and experimentation. However, paying Oracle by attending the ILT classes and studying from Student Guides also works !!   - Kirti -Original Message-From: Rohit [mailto:[EMAIL PROTECTED]]Sent: Saturday, March 30, 2002 3:13 AMTo: Multiple recipients of list ORACLE-LSubje

Re: Oracle From a Sybase DBA perspective

2002-03-30 Thread Jan Benjamins
Hmm, what about the LOGGING/NOLOGGING option of the CREATE INDEX statement ? Jan - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 29, 2002 11:58 PM > Jared, > > There are too many mistakes in that "document" to even begin to an

RE: Oracle From a Sybase DBA perspective| What is a Database to S

2002-03-30 Thread Mark Leith
You pretty much hit it on the head Rachel, except: Sybase sa user = Oracle sys user -Original Message- Carmichael Sent: 30 March 2002 12:23 To: Multiple recipients of list ORACLE-L S Ian, Having worked with Sybase years ago, I developed this "translation" Sybase instance = Oracle dat

RE: Generate Data for TEST

2002-03-30 Thread John Hallas
Don't know exactly what you want but if you just "create table Hamid_table as select * from dba_tables" and do likewise with some of the other data dictionary tables (objects,triggers,segments etc) then you have a set of tables which are all related to each other. Another quick way of populating

RE: Do programmers tune SQL?

2002-03-30 Thread Larry Elkins
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel > Carmichael > > Larry, > > Mine is Glenmorangie in a port finish. Write me offline for the address > :) > > Oh -- your poor programmers who have queries that don't perform in > production as they do in development? Have you t

RE: Do programmers tune SQL?

2002-03-30 Thread Rachel Carmichael
Larry, Mine is Glenmorangie in a port finish. Write me offline for the address :) My last shop we had one programmer who not only expected me to tune his SQL, he expected me to WRITE his SQL for me. I got emails "I need a query that returns this information from these tables". His boss set him s

RE: Oracle From a Sybase DBA perspective| What is a Database to S

2002-03-30 Thread Rachel Carmichael
Ian, Having worked with Sybase years ago, I developed this "translation" Sybase instance = Oracle database Sybase database = Oracle tablespace Sybase dbo user = Oracle sys user Sybase master database = Oracle SYSTEM tablespace anyone have a better explanation? Rachel --- "MacGregor, Ian A."

RE: Do programmers tune SQL?

2002-03-30 Thread Rachel Carmichael
My mantra (developed after years of living with a Jewish mother) is: I'm wrong, I've always been wrong, I will always BE wrong, let's move on from there. What I used to love is "Oracle is broken". Really? Was it its leg? Arm? your head? --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Oh yes, it'

Re: exma tips

2002-03-30 Thread Joe Testa
Study Rohit wrote: > hi there, > > I want tips regarding 1z0-023 architecture exam.. please help, > > Thanks > > Rohit > > > -- Joe Testa, Oracle DBA Nothing new to put here, hmm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [E

[no subject]

2002-03-30 Thread Rohit
hi there, I want tips regarding 1z0-023 architecture exam.. please help, Thanks Rohit  

Database Creation hangs up

2002-03-30 Thread paPIpapupapePO
Good day! I suppose to create a new database. But when the process reaches the part of "Creating and Starting Oracle Instance", the said process will just stall.  I dunno the cause because there is no any dialog that pops-up.  And when I also look CloneDBCreation.log, I can read nothing. Any sugg