table monitoring counts before the ABORT, either in
8i or 9i?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
> Cheers,
>
> -Roy
>
> Roy Pardee
> Programmer/Analyst
> SWFPAC Lockheed Martin IT
> Extension 8487
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City
8.1.7 db to 9.2 db.
> >
> > Platform is AIX.
> >
> > "Database Upgrade Assistant" is going to be used. Does anyone have
> > any bad experience with this oracle tool? Or the whole process is
> > straight forward?
> >
> > Thanks,
> >
; any bad experience with this oracle tool? Or the whole process is
> straight forward?
>
> Thanks,
> Vladimir Barac
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http:
are
the experience?
I was asked about it. I have no idea how it works. I am trying to
gather as much info as possible from Oracle.com, Google etc..
Thanks.
- Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat
: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
ought 817 and 9i can not coexisted on aix 5L.
Thanks,
joan
"Deshpande, Kirti" wrote:
>
> Tracy,
> We are still debating this issue with our preferred App Vendor...
>
> Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue.
>
> Te
red segments.
Peter Schauss
-Original Message-
Sent: Wednesday, March 26, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Login as the owner of the shared mem segments and run it.
It just worked for me on RH 7.2 with 8.1.7
Jared
--
Please see the official ORACLE-L FAQ: http
all
m 2 0x02da4bbc --rw-r- oracle oinstall
Anyone else have similar experiences?
Thanks,
Peter Schauss
Northrop Grumman Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PR
1. Assuming Wait Events:
Please check the
Database Server Reference Guide for the respective release. Also check www.oraperf.com, there a list of wait events
by Oracle Versions. Free membership is required.
2. Using triggers at database
level.
for
example:
create or repla
Create
a 'flag' file with the 'particular' date as its last modified
date:
touch -t 200303201330.40 oldfile
The
timestamp is of the format: MMDDHHMM.SS
Then
use find command to find files newer (later) than oldfile.
find . -newer oldfile -print
HTH,
-
Kirti
Changing 'find' to following would work:
find . ! -newer oldfile -print
-
Kirti
-Original Message-From: Deshpande, Kirti
Sent: Tuesday, March 25, 2003 1:50 PMTo:
'[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject:
RE: find on unix
Ig
Ignore
that..
It
will find newer files, not older files..
I
misread the question. Sorry..
-
Kirti
-Original Message-From: Deshpande, Kirti
Sent: Tuesday, March 25, 2003 1:39 PMTo:
'[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject:
RE: find on u
that and runs twice a day, but
always sends out.
Thanks.
Maks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
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: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http:/
,
I wanted to know the concept of Rownum.. Is it similar to Row Id ?
Thanks and Regards,
Santosh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
---
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing l
kernel
virtual memory
/stand/vmunixthe kernel, system name list
> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 14, 2003 3:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Su
ACLE-L
>
>
> I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS
> log files worth monitoring?
>
> Thanks,
> Ethan
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Networ
nt where this block ( 259186 ) belongs ?
select segment_name
from dba_extents
where block_id<= 259186 and 259186 <= block_id+blocks
-ak
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-
to just specify a
top level directory.
Has this changed in 9i? Is it possible to specify a top level
directory
and then utl_file can write to subdirectories?
John
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fa
eckpoint occurs
> > (5) when a commit occurs.
> >
> > Therefore, see if any of these could be the problem. It's easy to
> > check #s 4 and 3.
> >
> > As Kirti suggested, the problem could be due to the redo logs being
> > on a busy disk, or even a slow
Title: RE: monitor transactions over time
Make
that bug #2506744.
Sorry..
-
Kirti
-Original Message-From: Deshpande, Kirti
Sent: Thursday, March 13, 2003 7:20 PMTo:
'[EMAIL PROTECTED]'Subject: TXNCOUNT in V$UNDOSTAT (9i R2) [ Was
-- RE: monitor transac
here reason to go for SAN, i
>sugguested to buy an external storage
> box instead. How can i justify my desicion ? (cost of not the factor)
>
> TIA
> rahul
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET:
write one, watch out for those -ve numbers
for TXNCOUNT.. :-))
Somebody is watching this list..
seriously ;)
Rajendra, you need to put your script
on e-bay ;)
Regards,
-
Kirti
-Original Message-From: Deshpande, Kirti
Sent: Friday, March 07, 2003 9:14
Increasing log_buffer size is an option, if it is really small.
I
would also check if the redo logs are on a busy disk. If so, try moving those
(or other busy data files on the same disk) to other not-so-busy
disks.
-
Kirti
-Original Message-From: [EMAIL PROTECTED]
[mailto:[
> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 13, 2003 2:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Corrected SQL Question...
>
>
> All they wanted was to "pair up" those city codes.
> DAL
xt 256k minextents
20 optimal 5M);
create rollback segment rollback_2 tablespace
rollback_space
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for
non-system tablespace
'ROLLBACK_SPACE'
Those script used to work under ORACLE 8i.
Does anyone know why?
Thanks.
_
--
AQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE y
Deshpande,
KirtiSubject: RE: Corrected SQL Question...
(see answer below)
> -Original Message- >
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
> > Here is the test data:
> > SQL> select c1,c2
from cp; > > C1
C2 > --- --- > AUS
e see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
recipients of list ORACLE-L
I think its easier if you do it cross-tab
AUS DAL DAL AUS
Is that acceptable?
Or just select
AUS DAL
If it also has a DAL AUS
Are either of those metods acceptable? If so, pick one and Ill show you how to do it.
>
> From: "Deshpande, Kirti" <[EMAIL
-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To
-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To
A
> CD
> DC
> EF
> FE
> G H
> H G
>
> Thanks for your help.
>
> - Kirti
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq
I messed up typing the data for the table. It has no dups.
The second occurrence of C, D and E, F should actually be D, C and F, E.
Sorry about that...
Need more hot tea to wake me up !!
- Kirti
> -Original Message-
> From: Deshpande, Kirti
> Sent: Thursday, March
Sent: Wednesday, March 12, 2003 2:40
PM
Subject: RE: POLL: Database to DBA
ratio
350 Oracle Databases spread across US and Europe.
14 full time, 4 part time. 75% of
applications are designed and built in-house.
-Original Message- From:
Deshpa
official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
A
CD
DC
EF
FE
G H
H G
Thanks for your help.
- Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
That
sets all roles assigned to the username as it's default and are in effect at the
same time whenever username logs in.
-
Kirti
-Original Message-From: Edouard Dormidontov
[mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 7:39
AMTo: Multiple recipients of list
he 9i track.
>
> Good luck!
> Darrell
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
Title: RE: monitor transactions over time
From
what I know Oracle Development folks have identified the code changes
to correct this problem. Just do not when Oracle would issue the patch.
Since the bug was logged against 9i R2, patch would be provided.
This
bug was originally logged in
tfree gap"...)
> > plus the claim that the author had to be right
> > because the
> > comment was taken from Metalink.
> >
> >
> > It would, quite arguably, have been valid to reply
> > with
> > something like: "Your comments do, indeed reflec
/metalink.oracle.com/odc/east (or west)...
- Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
&
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from
oth paths valid?
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ray Stell
INET: [EMAIL PROTECTED]
--
Please see the offici
Our Current Environment: 64-bit AIX
4.3.3 running 32-bit 8.1.7.4 and 64-bit 9i.
Here is what we are thinking of testing...
(a very high level task list, there will be App testing in all these steps).
First, upgrade databases to 64-bit 9i
Second, upgrade AIX to 5L, install
64-bit
P command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web h
| \
/usr/bin/awk '/^ *[0-9]+/ {printf("LoadList entry at 0x%s\n Name:
%s\n\n",$2,$6)}
fi
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Zabair,
Increasing the l_c_i would help.
I see you have l_c_t set to 0,
so why not set l_c_i to 0 as
well? So that the checkpoint will only occur at log switches.
- Kirti
-Original Message-From: Zabair Ahmed
[mailto:[EMAIL PROTECTED]Sent: Thursday, February 27, 2003 3:
Am I doing something wrong Or you cannot specify a storage size for
partitions.
Please help..
Thanks
Conrad...
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fat
> UK___March 19th
> USA_(FL)_May 2nd
>
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
ebruary 24, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Thanks Kirti. Interesting, dba_extents doesn't return rows for
block_id=57856. However, export to /dev/null does report the
corruption. Does this indicate disk or memory corruption?
"Deshpande, Kirti" wrote
found same corupted
data
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
mentioned, recovering a truncate'd table from the
backup. something similiar, on those lines.
albiet, thanks for the earlier answers !
-sam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-
Title: AIX question
Kevin,
Thanks for sharing those scripts. :)
Those are *good* !! I am
keeping those.
-
Kirti
-Original Message-From: Kevin Lange
[mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 1:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ts full responsibility for taking proactive and
remedial action about viruses and other defects. The sender's business entity is not
liable for any loss or damage arising in any way from this message or its attachments."
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-
Thanks for any suggestions, and have a great weekend everyone
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Cal
apply this patch to upgrade to 8.1.7.4?
Joan
"Deshpande, Kirti" wrote:
>
> Hello All,
> If anyone successfully applied this patch (for Alert #51) to 8.1.7.4 32-bit on HP-UX
>11.0, please let me know. It seems that the patch is not able to find a couple of
>required lib fi
ACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To
SIGSEGV for stack growth failure.
Possible causes: insufficient memory or swap space,
or stack size exceeded maxssiz.
cc: error 1405: "/usr/ccs/bin/ld" terminated abnormally with signal
11.
*** Error exit code 11
Stop.
_
--
Please see the official ORACLE-L FAQ: http://www.ora
th of London and the East Coast of Scotland.
NGSSoftware's
sister company NGSConsulting, offers best of breed security consulting
services, specialising in application, host and network security
assessments.
http://www.ngssoftware.com/
http://www.ngsconsulting.com/
Telephone +44
x27;ListGuru') 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: D
City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT
XACT spelling of 'ListGuru') 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://
Title: RE: GR OWS
FWIW
We have ASSP, SCRP, SCRU...
:)
-
Kirti
-Original Message-From:
Loughmiller, Greg [mailto:[EMAIL PROTECTED]]Sent:
Thursday, February 20, 2003 1:16 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: GR OWS
LMAO.. Now you need a da
We run
4 Names servers on 4 different host machines, each having its own repository
database on that host.
These
are defined in various preference order in SQLNET.ora file on various clients.
Repository databases are monitored by other mechanisms.
-
Kirti
-Original Message-F
ome easy for migration.
Thanks in advance,
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web host
sequential scanning, though I have not
tested it thoroughly.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA (Now in Austria)
--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> In a very limited tests that I performed with ASSM (quite some time
> ago), I found that it tends t
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
Thanks
you, Dan.
Very
nicely put.
-
Kirti
-Original Message-From: Daniel W. Fink
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:31
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Teradata banned from IOUG???IOUG is a volunteer
organization. I
ibing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
ude 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: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat Ci
or my
new 9i database with the new features included?
TIA
M.Godlewski
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services--
e.
The architecture is nothing special.
I imagine the PHB's had their fingers in those moves.
Been there, got the T-shirt, now it's a dust rag.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City
all Hotsos staff !!
Cheers!
- Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
******
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
.uk/seminar.html )
USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Servi
t rather stable,
at least Win2k server is. I have one system on Win2k that I reboot,
oh, every 6 months or so.
Death to NT though.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 85
web site for this driver, but failed
to locate it.
Any ideas about its source?
Thanks.
- Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Lisa,
We have several databases on AIX 4.3.3/8.1.7.x. All of them have
TIMED_STATISTICS set to TRUE.
Not problems have been encountered.
And about that tuning question: May be those are all dedicated
connections, if so check
7.x you can manually start multiple archive processes by
> > using the "archieve log start to " and the added
> > processes wil die when there is no more redofiles to archive, but for
> > permanent having multiple processes the answer is 8.1.3 :-)
> >
> &
ays I need "Sybase Adaptive Server ODBC driver Release 3.11.00.01". Searched Sybase
web site for this driver, but failed to locate it.
Any ideas about its source?
Thanks.
- Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
IN
Title: windows application to show sql being executed by a client program
Pretty cool...
A future Quest product ??? ;)
Just wondering... :)
-
Kirti
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 7:59 PMTo
to NT though.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
rafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this m
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
hy would be a
bonus.
TIA
=
Sundeep Maini
Consultant
Currently on Assignement at Caterpillar Peoria
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://
ead
>0 WAITING 20119
>
>-Original Message-
>Sent: Wednesday, February 05, 2003 2:58 PM
>To: [EMAIL PROTECTED]
>Cc: Thomas Jeff
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Desh
onest' feedback?
Thanks a lot
Cyril
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
ing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
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: Deshpande, Ki
nt 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: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Die
Tom,
Thanks a lot.
I am glad to read that the book is helping you.
I am not so sure about ".. solves all problems", though ;)
Regards,
-
Kirti
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:52
AMTo: Multiple
ese latches are happening, which
objects / cursors etc are causing the contention. I've grappled with SQL
against x$kglob, trying to join back to the P1RAW but am not getting very
far.
Any ideas?
TIA.
Neil.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: D
1 - 100 of 869 matches
Mail list logo