Have you tried 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
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
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 := 'D3846GIVEUP28/10/200313ENT_ID>A001ACT>1>N>29/10/2003IALS>New
CustomerOCCUPANT>
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 erro
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 problem is
I get the following error when i invoke it.
oracle ukwsv71 > usedb uktst233
bash: nawk: command not found
bash: nawk: command not found
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 databas
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
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
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
[EMAIL PROTECTED]
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 hos
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 F
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
alter tablespace 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:
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 which I
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 o
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
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
San Diego, California-- Public Int
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
e 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
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
internal error
>[2603]
>Date: Thu, 10 May 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
il 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 Inte
abair
_
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
_______
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
San Diego, Califo
Hi
Where can i get this Sun/Oracle Best Practices paper.
TIA
Zabair Ahmed
>From: "Louis Avrami" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: fastscan and maxpgio in Solaris 8?
>
25 matches
Mail list logo