probe database using OEM event or job

2003-09-30 Thread Baylis, John
Title: probe database using OEM event or job Can someone help me with this? Running Oracle 9.2.0.3 under win2000 I have an application server that occasionally looses connectivity with the listener on the database server although other application servers have no problems connecting. I

RE: Question about buffer cache

2003-02-19 Thread Baylis, John
Title: RE: Question about buffer cache I have indexes in a 16k page size tablespace. I have the following init.ora parameters: db_block_size=4096 db_cache_size=600M db_keep_cache_size=200M db_16k_cache_size=200M If I alter an index to put it in the keep pool, how does Oracle hande the

Failsafe and OEM automatic discovery

2002-08-29 Thread Baylis, John
Title: Failsafe and OEM automatic discovery I am running OEM and OMS 9.0.1 on WIN2000 and am having ptoblems discovering databases on a two server Oracle Failsafe cluster. I am running Failsafe 3.3.1 on a two node cluster. Database DB1 on node 1 (cluster group GRP1) Database DB2 on node 2

COLLATING SEQUENCE (EBCDIC to ASCII)

2002-05-22 Thread Baylis, John
Title: COLLATING SEQUENCE (EBCDIC to ASCII) Does anyone know how to change collating sequence in Oracle, either at the database level or for a specific query? We have a mainframe (ebcdic) app that is converted to NT (acsii) and some special characteres (e.g. period(.) dash (-) etc.) not

RE: Export multiple targets using OEM

2002-05-16 Thread Baylis, John
Title: RE: Export multiple targets using OEM I am using OEM 9.0.1 with job scheduler I am trying to export full database for multiple targets using the job scheduler. How do you specify more than one .dmp name and location? I want a .dmp and .log file for each target. Even though I

Export multiple targets using OEM

2002-05-15 Thread Baylis, John
Title: Export multiple targets using OEM I am using OEM 9.0.1 with job scheduler I am trying to export full database for multiple targets using the job scheduler. How do you specify more than one .dmp name and location? I want a .dmp and .log file for each target. Even though I specified 2

cost based optimizer

2002-02-08 Thread Baylis, John
Title: cost based optimizer I have a table of 500,000 records that is analyzed and contains several indexes that are analyzed. Can someone explain to me why the cost without a hint is much lower than the cost with a hint? Using a hint is 10 times faster than without a hint even though the

local connection using pro-cobol

2001-07-19 Thread Baylis, John
Title: local connection using pro-cobol I have a pro-cobol application running on my database server. I am trying to use a local connection in a pro-cobol program but I get an ora-12154 error if I do not have the listener running on a win2000 server using net8. It appears as if it it using a

Locked Oracle dll's

2001-05-10 Thread Baylis, John
Title: Locked Oracle dll's I am trying to remove the Oracle bin directory from an NT 4 server however the Oracle dll's are in use. The reason they are in use is because they are open to the Windows NT winlogon.exe process as a result of remote performance monitoring. When you use

RE: ORACLE-L Digest -

2001-04-02 Thread Baylis, John
Title: RE: ORACLE-L Digest - ORACLE-L NODIGEST