A free sql analysis tool

2004-01-08 Thread Hatzistavrou John
Dear All, I have found this Perl script that makes an analysis of 10046 SQL trace http://brainshed.com/software/ Kind Regards, Hatzistavrou Yannis

SQL*net message from client severly impact the Parse call of an insert statement

2003-12-31 Thread Hatzistavrou John
Dear All, I am faced with the following situation. Oracle 8.1.7.4. 64 bit , Solaris 8 There is a loader java process that when is executed against a test database(dwdsa)the response time is as expected to be. However when it is executed against the production instance (dwods) it is

Slow process

2003-12-24 Thread Hatzistavrou John
Dear All, Seasons Greetings. I have the following problem: My system is a Oracle EE 8.1.7.4 64bit on Solaris 8 . The last days the datawarehouse people complain that their load process which inserts data into tables is half time as fast as it was two days ago. From

RE: OpenLDAP instead of OID

2003-12-09 Thread Hatzistavrou John
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.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network

Oracle Licensing

2003-10-31 Thread Hatzistavrou John
Dear All, Oracle licensing has been a subject that often is risen by somebody. I though I shall share this with you. Regards, Hatzistavrou Yannis Oracle_SW_License_Guide.pdf Description: Binary data

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-27 Thread Hatzistavrou John
Title: Message Sorry, It is not readable. Kind Regards, Hatzistavrou Yannis -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2003 6:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Do not connect Oracle DB to the Internet.

RE: dbms_job issue.

2003-09-19 Thread Hatzistavrou John
Have you checked number of queues lately? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003

RE: get sid (session id) and serial#?

2003-08-29 Thread Hatzistavrou John
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.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Query results to .csv

2003-08-25 Thread Hatzistavrou John
') 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.net -- Author: Hatzistavrou John INET: [EMAIL

RE: Analytical Functions

2003-08-14 Thread Hatzistavrou John
') 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.net -- Author: Hatzistavrou John INET: [EMAIL

Problems connecting with Oracle Internet directory Manager

2003-08-14 Thread Hatzistavrou John
Title: Problems connecting with Oracle Internet directory Manager Dear All, I have installed the product after some manual intervention but now I am stuck when I am trying to use Oracle Directory Manager. Although I have manually started the OID mon and OID server and checked their logs

RE: Redo Logs Problem

2003-08-01 Thread Hatzistavrou John
Have you checked whether any tablespace is left in hot backup mode? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday,

RE: Oracle and OpenLDAP server

2003-07-29 Thread Hatzistavrou John
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Oracle and OpenLDAP server

2003-07-29 Thread Hatzistavrou John
GREAT. Exactly what I was looking for. I'll play around with it on the weekend and give some feedback to the list next week (if somebody is interested, that is). Thanks a lot ! Stefan -Ursprüngliche Nachricht- Von: Hatzistavrou John [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. Juli 2003

RE: ORA600 [2103] [0] [0] [1] [900] -- Wrapping up

2003-06-17 Thread Hatzistavrou John
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ORA600 [2103] [0] [0] [1] [900]

2003-06-13 Thread Hatzistavrou John
It is a local filesystem Kind Regards, Hatzistavrou Yannis   -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA600 [2103] [0] [0] [1] [900] 1. Try

ORA600 [2103] [0] [0] [1] [900]

2003-06-12 Thread Hatzistavrou John
Title: ORA600 [2103] [0] [0] [1] [900] Dear All, I have encountered the following message during alter database backup controlfile to reuse after a hot backup. We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which

RE: passing ref cursor on a procedure

2003-06-05 Thread Hatzistavrou John
example -Original Message- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: passing ref cursor on a procedure Dear All, I have a vendor procedure which I wish to run . This procedure takes

RE: StoredProc SQL statistics

2003-06-04 Thread Hatzistavrou John
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

copycommit probs

2003-03-06 Thread Hatzistavrou John
Title: copycommit probs Dear All, I am trying to copy a local table to another local . I have created the link which is working when doing a select but when it comes to copying it gives an ORA-12154 eror. How can I resolve this? Kind Regards, Hatzistavrou Yannis Database Administrator

RE: copycommit probs

2003-03-06 Thread Hatzistavrou John
: Hatzistavrou John Sent: Thursday, March 06, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: copycommit probs Dear All, I am trying to copy a local table to another local . I have created the link which is working when doing a select but when it comes to copying it gives an ORA

RE: oracle version

2003-03-05 Thread Hatzistavrou John
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Geneva application

2003-03-05 Thread Hatzistavrou John
Title: Geneva application Hi, I wish to hear from those that have been administrating Oracle instances of Geneva billing application. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]

DBMS_SQL

2003-02-13 Thread Hatzistavrou John
Title: DBMS_SQL Dear All, I am trying to pass to dbms_sql.parse dynamic values from a cursor declared before the call by the dbms_sql.parse. I am getting ORA 1001 . How can I do that? Kind Regards, Hatzistavrou Yannis

Ora-1001

2003-02-13 Thread Hatzistavrou John
Title: Ora-1001 Dear all, I am trying to construct the following PL/SQL block. When I run it I always get an 0RA-1001 error. May you please help me Environment Oracle 8.1.7.0 O/S W2K Sp3 declare l_cursor integer := dbms_sql.open_cursor; output utl_file.file_type; cursor lnklst_cur

Need some insight views

2003-02-07 Thread Hatzistavrou John
Title: Need some insight views I wish to hear from those that have experience supporting Oracle databases for Geneva billing systems and Siebel. It will be greatly appreciated if somebody can advise me on any hotspots. Kind Regards, Hatzistavrou Yannis Database Administrator