Search results for query: *

I have setup a counter log using performance monitor in Windows 2000. The log file is stored on the disk of the machine being monitored. In order to not have the monitor influence the disk counters I want to store the log on a different server on our network. I use the browse button on the...

The table definition is: job_key (int, Not Null) job_number (int, Null) name (varchar(32), Not Null) queue (varchar(32), Null) submit_time (datetime, Null) start_time (datetime, Null) end_time (datetime, Null) exitcode (int, Null) cpu_time (int, Null) job_params...

Probably not as I did not create one. What index would you recommend?

This solution works and runs quickly with a small table, but I am having a problem with a large table. The table I am using has about 120,000 rows and 237 distinct names. When I executed the query it ran for over 16 hours before I killed it. Why does it take so long? While experimenting with...

Great, it works! Thanks for the help cheyney.

I am using SQL Server 2000 and I have a table that contains a column of job_name and cpu_time. Every time a job completes the job_name and cpu_time used is interted to the table. I have been asked to find the cpu_time of the 75th percentile for each job_name. There are over 50,000 rows with...

I have a problem with a cobol program that experiences a periodic 60 second slowdown while executing the following statement - CALL "SQLBEX" USING SQLCTX SQLEXD SQLFPN. Does anyone know what this statement does and why it would take 60 seconds to execute? It doesn't happen all the...

Thanks for the info jimbopalmer.

I have a cobol program that is inquiry only, but it has the following statement in it: EXEC SQL COMMIT WORK END-EXEC. I can see that it is being executed and I am curious what Oracle does when a commit is requested but no tables have been chaged. Does anyone know?

I am a seasoned cobol programmer who is new to Oracle. My cobol experience is in the Unisys arena. ie I have been using a DMSII database (uses pointers). I have a basic understanding of Oracle and cursor but I am having difficulty understanding how to write a batch update program. For...