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

2002-03-31 Thread Rachel Carmichael
yes and no, technically you could have other owners in the same Sybase database, so it's more akin to a tablespace than a schema. But both are basically correct. --- Jared Still [EMAIL PROTECTED] wrote: Sybase database = Oracle tablespace My impression was that a Sybase database was more

Re: Do programmers tune SQL?

2002-03-31 Thread Rachel Carmichael
Jared, Gotta wean you away from that peaty stuff :) Rachel --- Jared Still [EMAIL PROTECTED] wrote: 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*

RE: Production Oracle DBA Needed in Rochester, Minnesota

2002-03-31 Thread Andrey Bronfin
Dear Brian and other gurus ! May i ask U to give a word or two on the topics U mentioned , i.e. How to detect, diagnose, and recover from an instance hang; What do you do when a user calls and says the system is slow or that they can't connect; How to capture application SQL errors from the db

RE: Do programmers tune SQL?

2002-03-31 Thread Dave Morgan
Isn't this the DBA's eleventh commandment Rachel's Mother wrote: I'm wrong, I've always been wrong, I will always BE wrong, let's move on from there. As for the programmers I would rather write (right) the SQL for them as it means I don't have to deal with their SQL later. And I write

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

2002-03-31 Thread Denny Koovakattu
Having worked with a lot of Sybase DBAs and having discussed why Sybase Architecture is Inferior to Oracle's and having helped them understand/learn Oracle, I know why Sybase DBAs find it difficult to understand Oracle. But there are a few things Sybase is better at. - Ablility to return

RE: Do programmers tune SQL?

2002-03-31 Thread Larry Elkins
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 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. It was a good idea, thanks for throwing it out there. The

dmoz/odp imports

2002-03-31 Thread Gabriel C Millerd
does anyone have any scripts for importing dmoz/odp datafiles? anything i have tried to develop breaks on whats seems to be the deviation from the rdf they use. i have tried working with tje senga catalog's convert_dmoz ... but its pretty fast and loose with the results since its importing into

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

2002-03-31 Thread Rachel Carmichael
Denny, Great analysis... thanks, I haven't worked with Sybase in quite a while, my memory isn't as clear as it could be :) Rachel --- Denny Koovakattu [EMAIL PROTECTED] wrote: Having worked with a lot of Sybase DBAs and having discussed why Sybase Architecture is Inferior to Oracle's

RE: Do programmers tune SQL?

2002-03-31 Thread Rachel Carmichael
well now you'll have to let us know what the solution turns out to be --- Larry Elkins [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel Carmichael I WISH I owned that website :) as for the programmers well, it was a thought.

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

2002-03-31 Thread Boivin, Patrice J
Out of curiosity, what do SyBase DBAs think of SQL Server and Microsoft? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de

RE: Coriolis is dead

2002-03-31 Thread Boivin, Patrice J
WOW, is the certification market that bad? Their books were useful, I wonder what happened. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch

RE: Do programmers tune SQL?

2002-03-31 Thread Jamadagni, Rajendra
I moved from development to DBA, so now no one comes around and tells us that 'such and such this is not possible in Oracle' .. or 'writing that kind of code will take two weeks'. Some developers love to tune, some aren't afraid to ask after experimentation, some want us to do their work. Then

Re: Coriolis is dead

2002-03-31 Thread Joe Testa
I couldnt find any news on the web about it :( joe Boivin, Patrice J wrote: WOW, is the certification market that bad? Their books were useful, I wonder what happened. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des

ORA-600 Error

2002-03-31 Thread CHAN Chor Ling Catherine (CSC)
Hi Gurus, My Oracle HRMS form server died and none of my production users can access any form module. I bounced the form server. It was up for a while and then died again. Even bouncing the database and form server etc does not help. Now my production database is crippled since 28 Mar 2002 and

ORA-01000: maximum open cursors exceeded

2002-03-31 Thread CHAN Chor Ling Catherine (CSC)
Hi Gurus, Every week, we do a logical export of the whole production database. It used to work until I encounter the ORA-01000: maximum open cursors exceeded Command : exp userid='system/system_pwd' file=$ORA_EXP_FILE grants=y rows=y constraints=y compress=y full=y inctype=complete

RE: ORA-600 Error

2002-03-31 Thread John Kanagaraj
Hi Catherine, Depending on your version, and whether you have set the system profile 'Sign-On:Audit Level' to FORMS, you should be able to view current online forms users using SELECT USER_NAME, USER_FORM_NAME, RESPONSIBILITY_NAME, TIME, PID FROM APPS.FND_SIGNON_AUDIT_VIEW order by user_name

RE: ORA-01000: maximum open cursors exceeded

2002-03-31 Thread ayyappan . subramaniyan
Hi I think u can increase the open cursors at the maximum. currently I am having open cursors as 2000. so I think u can increase up to that Regards Ayyappan.S This communication contains information, which is

RE: ORA-01000: maximum open cursors exceeded

2002-03-31 Thread John Kanagaraj
Catherine, Setting this to a higher value generally does not hurt badly. On a heavily used 10.7 system, this is currently set to 512 with no problems. I have seen larger values before - 600 comes to mind... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting