oracle events...

Does anyone know what these oracle events are and how the wait times can be reduced. This is an extract from statspack output on 9.2.0.4 on HP 11.11 Top 5 Timed Events~~ % TotalEvent Waits Time (s) Ela Time ---

Re: query taking a long time to run via sqlnet

ried trace? Did you check trace route to see how many hops it makes to the database server?Zabair Ahmed [EMAIL PROTECTED] wrote: I've got the follwing piece of code which takes almost 3 seconds to run when I execute it on the server itself using sqlplus. DECLARE p_xml_in LONG(32760); p_xml_out LONG(32

query taking a long time to run via sqlnet

I've got the follwing piece of code which takes almost 3 seconds to run when I execute it on the server itself using sqlplus. DECLARE p_xml_in LONG(32760); p_xml_out LONG(32760);BEGIN p_xml_in :=

ORA-7445

Hello Am getting an ORA-7445 and have raised a iTAR with Oracle but so far they have not hot to the bottom of the problem, so I thought I'll try this list! When I run a package in sqlplus I get the follwing error:- ERROR at line 1:ORA-03113: end-of-file on communication channel The following

One for bash experts....

I've got the following script that works fine on most flavours of unix apart from Linux...I think I must be going mad as I can't see where the problemis I get the following error when i invoke it. oracle ukwsv71 usedb uktst233 bash: nawk: command not found bash: nawk: command not found

ORA-12547: TNS:lost contact

Any Oracle Apps DBA out there.. Am getting the following error when am trying to install 11.5.8 on Redhat 8. The error messgae in the adcrdb_PROD.txt is as follows:- ORA-12547:TNS:lost contact SP2-0640 Not connected. Am getting the error when rapwiz is running adcrdb.sh - creating the database

submitting statspack.snap through dbms_job

Quick question, I want to submit statspack.snap at 10:00am and 14:00pm through dbms_job, it's friday afternoon and my head is hurting me from a heavy night and the manuals are as clear as mud. ThanksYahoo! Plus - For a better Internet experience

Checkpoints

The following parameters are set in the init.ora:- NAME VALUE-- ---log_checkpoint_interval 25600log_checkpoint_timeout 0log_checkpoints_to_alert TRUE This means that a checkpoint will happen every 12Mb of redo being filled, os block size is 512. The size of

Re: Checkpoints

Hi Daniel Log switches are happening every 20-25mins during peak times and yes the ckpt process is started automatically. ZabairWith Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs

RE: Oracle Names Server 8.1.7 on HP 11

ECTED] Web: www.compuware.com -Original Message-From: Zabair Ahmed [mailto:[EMAIL PROTECTED]Sent: Thursday, February 20, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Names Server 8.1.7 on HP 11 We've currently got Names Server running on 4 host boxes. If one Names server is down,

Oracle Names Server 8.1.7 on HP 11

We've currently got Names Server running on 4 host boxes. If one Names server is down, the client is configured to automatically attempt to connect to the next one in the list. We had a problem recently were, if we issued a tnsping from any of the clients we got the following message. TNS-03505 –

SQL and TEMP segments

Quick question, I want to find out what sql is currently using my temporary segments. Is their a simple solution. Am getting the ORA-1652 for my locally managed temporary tablespace and I would like to find out what sql is causing this. My temp tablespace is currently 1.2GB. Oracle 8.1.7.3 on HPUX

Oracle TEMPORARY SEGMENT

Is their any way of identifying which user/process is holding onto a temporary segment. I've got a 50Mb temporary tablespace and there is a temporary segment which is 47Mb which is not being freed up by SMON. And, if i can't identify who is holding onto this TEMP segment, is their a way in whichI

RE: Oracle TEMPORARY SEGMENT

temp default storage(pctincrease 0); alter tablespace temp default storage(pctincrease 10); 50Mb seems rather small for a temp tablespace. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Zabair Ahmed [SMTP:[EMAIL PROTECTED

Oracle 8i (8.1.7) for Windows XP Home Edition

Quick question, has anyone managed to sucessfully install 8.1.7 on Windows XP Home Edition. I have read on metalink that this is not officially supported by Oracle, but wanted to know if anyone has managed to install it for test purposes on their home/work PC's tia Zabair -- Please see the

No Subject

HELP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services

Listener problems

Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: Function based index - insufficient priveleges

Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

How much TEMP space is needed for index creation

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ORA-06553: PLS-707: unsupported construct or internal error [2603]

://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]

2001 06:31:12 -0800 zabair ahmed schrieb: Has anybody seen the following error on logon to sqlplus sqlplus dbu/dbu SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 14:29:27 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-06553: PLS-707

No Subject

_ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Sun/Oracle Best Practices URL

/solutions/blueprints/0101/SunOracle.pdf;$session id$Z2EDDYQAABYJRAMTA1FU45Q Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 20, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Hi Where can i get this Sun/Oracle Best Practices paper. TIA Zabair Ahmed -- Please see th