Title: RE: Diagnose Slow System
You
need to take a slice of the database when the
performance degrades. Capturing statistics at the end of the
day
before the database goes down is meaningless.
Consider setting up a 10046 event trace and
find
out what session and what wait event is boggin
You may use Designer
Muqthar Ahmed <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/15/02 03:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Any Good Tool for Entity Relationsh
You may want to investigage Advanced Queuing.
It is an async messaging service in the database.
There are examples at otn.oracle.com
Jared
On Friday 14 June 2002 18:58, Robert Monical wrote:
> Hello,
>
> Finally moving from Oracle 7 to 8 or 9 (probably 9).
>
> We currently use DBMS_PIPE and a
Have you looked at System Waits, Session Waits and
or event 10046 trace data ? They hold the keys to
the kingdom on where you should proceed to diagnose
your performance issue.
-Original Message-
Sent: Friday, June 14, 2002 5:03 PM
To: Multiple recipients of list ORACLE-L
> * So
You can run this in another window to see if the session is waiting
on particular resource:
select
s.username username,
e.event event,
s.sid,
e.p1text,
e.p1,
e.p2text,
e.p2,
e.wait_time,
e.seconds_in_wait,
e.state
from v$session s, v$session_wait e
where s.username i
Mike
You have not specified how much memory is on the machine, neither have you
specified which application you will be running against the box. also, are
you going to be using an intelligent RAID controller device (EMC, Shark,
similar) with this ? Are you running this across a LAN / WAN ? Are a
We have a similar problem with a vendor supplied application. We solved it
(at least we masked the symptom) by increasing the ODBC timeout in the
user's W2K registry.
The vendor app uses an ODBC connect to a CORBA broker (OpenLink) on the
server. It's a bank rec that was only returning a porti
Hello,
Finally moving from Oracle 7 to 8 or 9 (probably 9).
We currently use DBMS_PIPE and a scheduled job to empty the pipe and store
the messages.
Works fine in our application but I need to eventually make some improvements.
Are there any new features in the newer Oracles to support this r
> * Solaris 2.6
> * Oracle RDBMS v8.0.5.2.1
>
List:
We are (still) having difficult with a production database. (Users
experiencing severe slowness at times.) I'm constructing a series of
queries to run at intervals to check the health/status of the system.
I'm attempting to run the q
This has been open for a while - I first saw a posting for this opening in
January or so. It is Cabela's. From what I hear, it is an outstanding
place to work. Sidney is a long ways from anything though. As for "2 hours
from Denver" ..., well -- MapQuest says "168.51 miles" with 3 hours, 20
mi
I can say that replication is an application solution level which means you
can not turn on the switch to get all the applications/tables replicated
while on the other hand Standby database is a database level solution that
does not have to know anything about the applications/tables hosted by the
Title: RE: Custom Reports from Aspect System
Could you try to connect internal on the server and create another user with DBA privileges?
> -Original Message-
> From: Rodd Holman [mailto:[EMAIL PROTECTED]]
>
> Are any of you using an Aspect phone system. This system
> maintains a
Muqthar - ErWin is always a safe choice. Does the schema have relationships
defined? If not, you're just going to end up with a bunch of disconnected
boxes.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 14, 2002 5:13 PM
To: Multipl
Pretty interesting. Maybe it's possible, but a simpler explanation is
that something about your workload either during or maybe immediately
before your batch job was different.
The most common case in which I've seen 'free buffer waits' waits is
when all the forces of nature combine to make DBWR'
How about ERwin by CA? We use a lot.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/14/02 3:13 PM
Hi,
One of our databases is custom based application. Is there any good
tool I can use for ER Diagram.
Thank your!
Muqthar Ahmed
DBA
--
Please see the official ORA
As I mentioned a few weeks ago, IMHO, singling out events to ignore in a
system-wide or even session-wide data collection is the wrong thing to
do. But you must ignore some events if you first make what I consider to
be errors in how you collect your data. If you collect data for only the
problem
Hi,
One of our databases is custom based application. Is there any good tool I can use
for ER Diagram.
Thank your!
Muqthar Ahmed
DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Muqthar Ahmed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5
Are any of you using an Aspect phone system. This system maintains a small
Oracle database on the switching equipment. Our telcom techs want to generate
some custom reports out of this system, but I'm having problems getting in.
They use some standard userids, but the passwords are encrypted in
I like SAN's for alot of reasons and if you are using
them in a traditional non-replicated environment, they
work well. Just don't buy into the sales hype that you
don't need to do phsycial database design because we
have should big caches etc... Those big caches are
great for improving write perf
Hi Chris,
I'm not sure I understand the problem, but we have VB apps that routinely retrieve
tens of thousands of records at a time, and occaissionally more, if that helps. We
have not run into any limitation. If you want to send me more details on the problem
I'd be happy to try to help.
Chris - How is VB connecting to Oracle? ADO? I don't know much about your
problem, but I do know that there are a half-dozen Microsoft choices, and I
believe there are a few Oracle choices also, like OO4O. But I do believe
that the first step to solving your problem will be establishing precisely
We have a VB app that uses Oracle as the database. The users noticed a
limitation in the amount of records being returned from the database. So
they decided to increase the memory of the PC and some additional volume of
records were returned. ??
Has anyone using VB/Oracle noticed this?? Is th
Hello Guys,
any guys here who have SAN. We are inviting a SAN vendor for possible solutions for
our enterprise.
i am unaware about how SAN would affect me as DBA. Also we are thinking about how we
can use OS level block replication between two database servers located in different
cities(SF
But she is missing from this list for a while...Hope to see her again
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 14 Jun 2002 11:51:37 -0800
I concur. Anita's one of the most knowledgeable replication
people to ever grace t
Yeah Anita is my favorite support engineer too... except that she's not
on the "front lines" of support anymore :( But I think she's going to
be able to come to NY to present for the user group in December. We're
looking into it now :)
You are right, knowing the members of this list I should hav
Thanks!
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Friday, June 14, 2002 4:10 PM
To: Multiple recipients of list ORACLE-L
Cross-platform is the whole reason for logical standby -- it's SQL
statements that get applied to the secondary database
Cross-platform is the whole reason for logical standby -- it's SQL
statements that get applied to the secondary database
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> All very true. Of course the doc in question was written for 8i, so
> that
> explains some of it. :) Question: Does logical
Unfortunately, the original paper in DOC format is required to get any value
out of the tests, and the doc isn't available at fors.com anymore (404 from
the link). Does anyone have this (Doc 285 from EOUG '97)?
TIA!
Rich Jesse System/Database Administrator
[EMAIL PROTE
I concur. Anita's one of the most knowledgeable replication
people to ever grace this list.
Jared
"Gogala, Mladen" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/14/2002 12:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
I'd start with using the data out of V$SESS_IO.
[EMAIL PROTECTED]> desc v$sess_io
NameNull?Type
---
SID NUMBER
BLOCK_GETS NUMBER
CONSISTENT_GETS
Acording to the manuals SEQUENCE_CACHE_ENTRIES is an obsolete
parameter for 8.1.7
Ramon
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 12:49
PM
Subject: Re: sequence question
while going throgh oracle manu
Use v$sess_io.block_changes to find out who is generating changes, since
each block change generates redo. Join back to v$session and v$sqlarea if
need be and you have your culprits.
Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456
-Original Message-
Sent: Friday, June 14, 2002 1:2
Dear Listers:
Any way (other than LogMiner) to easily identify what sql statements running
now are generaing
archived logs ? I have suddenly a lots of archived logs generated and almost
fillup my file system.
TIA
--David Jones
_
Well, not really. I did that by slightly modifying sql.bsq
in 8.1.7.2, but I'm not quite sure that modifying sql.bsq
is something that Oracle Support likes to hear about...
You can do it in a supported way as of 9.2.
The same goes for renaming a user. One or two quick updates
of the sys.user$ tab
All very true. Of course the doc in question was written for 8i, so that
explains some of it. :) Question: Does logical standby in 9.2 work across
platforms? Haven't had too much time to look at new 9.2 features I'm
afraid.
John P Weatherman
Database Administrator
Replacements Ltd.
-Ori
Here is an old paper from an Oracle analyst discussing SDU/TDU settings...
http://www.fors.com/eoug97/papers/0285.htm.
I never came across any upgraded version of the same.
- Kirti
-Original Message-
Sent: Friday, June 14, 2002 2:01 PM
To: Multiple recipients of list ORACLE-L
Hello,
Not actualy, The data already exists but not retreived till i recreate the
table with same data.
When I rebuild table the correct data will be retreived.
Few tables always corrupted for no reason!!!
-Original Message-
Sent: Friday, June 14, 2002 10:41 AM
To: Multiple recipients of list OR
Title: RE: Replication question
Another potential HA use of AR is that you can use different platforms in an HA configuration. You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored.
Yet another is during
Hello,
There are many theoretical things about tuning SDU/TDU. But, I don't think tuning
SDU/TDU makes benefit in practice.
Kathy Duret wrote:
> FWIW
>
> I tried "mucking" around with the SDU/TDU parameters on both the client and the
>server and never got much success. Tried to up the 2K to
or you can use the logical standby feature of 9.2 and then have both
databases open.
Replication bothers me when I start to think about synchronous vs
asynchronous. Async doesn't "hold up" the primary site from continuing
on, but the databases are not true copies of one another. Sync are true
cop
only in 9.2 can system be an lmt
--- [EMAIL PROTECTED] wrote:
> I am using 9.0.1 - can the system tablespace be setup as lmt? Or is
> that new in 9.2?
>
> Michele
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Netwo
9.2
[EMAIL PROTECTED] wrote:
>I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2?
>
>Michele
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
That is new in 9.2.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 2:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Locally Managed Tablespaces
>
>
> I am using 9.0.1 - can the system tablespace be setup as lmt?
FWIW
I tried "mucking" around with the SDU/TDU parameters on both the client and the server
and never got much success. Tried to up the 2K to 8K but it still was sending alot of
2k packets. I had more results upping the array size to 90-100 in glogin (default is
15).
Kathy
-Original Me
only in 9.2 ... that's the default.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but hav
Try it without the pipe to grep and see if the netstat -a is returning
anything at all.
-Original Message-
Sent: Friday, June 14, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L
When I gave this command on my db server nothing
responded for 10 mnts. then I cancelled the comma
Jarad,
A standby is simpler, however it has limited use for offloading some
system load (opening for read access suspends roll forward, so the
data is somewhat stale). By using Master-Master synchronous replication
with good deadlock handlers, you can use BOTH instances so you get the
benefit
I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2?
Michele
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
That's it, I *must* read that copy of "The Magic Garden Explained"
that is at home langushing on the shelf.
Jared
"Gogala, Mladen" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/14/2002 10:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PR
Stalled trying to do nslookups on all those IP address
probably. Try the following:
netstat -an | grep
It gives you IP address and ports numbers without
doing lookups.
Bill
--- Steve Johnson <[EMAIL PROTECTED]> wrote:
> When I gave this command on my db server nothing
> responded for 10 mnts.
while going throgh oracle manuals I found saying
number of sequence cached is governed by init parameter SEQUENCE_CACHE_ENTRIES . Does it mean that this value
should be set = 'number of sequence I want to cache' ...and what happens
if a sequence gets aged out from sequence pool . Am I going
Curious, that note suggests Advanced Replication as a failover
methodology.
Seems that a standby database would be _much_ simpler.
Any thoughts ( from anyone ) on why one would use AR for failover, rather
than using a standby database?
Jared
John Weatherman <[EMAIL PROTECTED]>
Sent by:
16 Gig of RAM on Windoze?
Bruce, have you had your coffee yet?
Jared
"Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/13/2002 06:03 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subj
Yep. We just upgraded to 8.1.7.x. v9.x isn't even on the radar screen,
yet...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 13, 2002 9:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject:
Are you executing two sql's from two different sessinons . Because it may
happen that you might not have commited the records you inserted in tableA ,
as soon as you create a temp table oracle does commit by itself and you
start finding records .
Can you try issuing a commit and then doing select
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
Actually, for us the percentage is lower since the OLTP
application we're using it for is heavily indexed ( with the exception
of single SQL that updates many rows.) It's one of those claims that is
us
One
more link with a complete package. http://www.quest-pipelines.com/Pipelines/PLSQL/archives.htm#code35
Tony
-Original Message-From: Aponte, Tony
Sent: Thursday, June 13, 2002 12:29 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: oracle error
logging
Title: RE: Management Reports
I'm
currently working on producing statistics for mid-managers. We have a lot
of tools that collect statistics for our 30 production databases so my challenge
it to map their individual repositories with the categories I want to
report. But these are the categ
That was the problem. I checked out that registry entry, and then looked in the
directory that it was pointing to, and there was no init.ora file in that directory.
I looked at the one that was in my previous ORACLE_HOME, copied and pasted it into the
directory in the new ORACLE_HOME (the one
When I gave this command on my db server nothing
responded for 10 mnts. then I cancelled the command ;
please advice.
--- Hemant K Chitale <[EMAIL PROTECTED]> wrote:
>
> On Unix, use "netstat -a | grep "
> to see if there is any service listening on the
> port.
>
> At 11:58 PM 13-06-02 -0800,
Dennis,
I was not referring to any one on this list. I was responding to the
statement that Quest should run a benchmark on someone actual redo logs... I say,
they might for a cost only I run Shareplex and haven't written full
response to this thread yet because at thi
Bill,
When you do an export you have sequence numbers
in cache.
Ramon
- Original Message -
From:
Magaliff, Bill
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 10:53
AM
Subject: RE: sequence question
what
do you mean about losing num
Mitchell - My knowledge is mostly from reading at this point, but here are
some thoughts that a colleague provided from his experience:
- backup and recovery is much more complicated in a replicated environment
so it needs to be planned
- replicated databases inevitably get out of sync so some pr
Tim, I don't believe that you can see that by strace. The whole
thing is happening entirely in the kernel. The problem is that
each device has a fixed size buffer allocated in the kernel address
space. When you allocate user buffer, it's contents it being copied
to either the buffer cache (file s
Mitchell,
There are a LOT of good papers in Metalink. I've been getting my own
education over the last few months. Replication is a really great swiss
army knife though, you need to do a little looking for what you specifically
need to do, then test, test, test. Oh, and did I mention test? :)
Check Note 190435.1 on MetaLink.
[It is under "Upcoming Oracle Product Desupports].
At 09:41 AM 13-06-02 -0700, Charlie Mengler wrote:
>I just went to Metalink & viewed the "desupport notices".
>I did not see where any 9i version is listed.
>Where did you find the notice for 9iR1?
>
>Hemant K Ch
Sorry for the late response, you probably are long done with your partial
restore - but I'll add my $0.2 cents to the discussion:
When I have done these partial restores I have limited my create
controlfile script to only system, rollback, and the tablespaces I wanted.
I have ONLY had succes
Title: RE: SunOS 5.8 I/O buffer size?
Yeah, I've been using this device for backups for
years. Always get very good performance.
(This is a joke folks!)
Matt Adams - GE Appliances - [EMAIL PROTECTED]
When someone says "I want a programming language in which I
only need say what I
I am trying to break the response time of my system into the wait and
service times. I am able to determine the service time by the "CPU used by
this session" line in the statspack report. The wait time I am having
trouble with. I am working from the 'Yet Another Performance Profiling
Method' docu
Robert,
Check _AUTORTART key in Windows registry (regedit.exe) under
HKEY_LOCAL_MACHINE\Software\Oracle\Home.
Set this key to TRUE, thus telling Oracle to automatically startup/open the
db, when Oracle service is starting.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To
Check whether the service finds your init.ora file.
The parameter in the registry might point to a different location for the service.
You can find the parameter file and copy paste it to the location that the service is
looking for it.
I hope that this will help.
Regards
Theodoros
-Orig
On Unix, use "netstat -a | grep "
to see if there is any service listening on the port.
At 11:58 PM 13-06-02 -0800, you wrote:
>Hello Unix Guru's!
>
>One of the port supposed to be used by db server has
>been occupied by application servers. When I want
>start a particular interface programs on
The database should start when you start the service if the registry
entry ORA__AUTOSTART is set to TRUE. When you upgraded the
database, did the ORA__* registry keys get moved into the new
HKLM\Software\Oracle\HOMEx key, and removed from the old one? ORA-27101
can indicate its trying to start
Hi all
I will work on replication soon. any advice for reference I can get.
Thanks in advance.
Mitchell
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 10:58 AM
> We are just starting to look at replication so each manu
The parameter to look in the registry is
ORA_ORA9I_PFILE
and points to the parameter file.
Make sure that it is located there.
Regards
-Original Message-
Sent: Friday, June 14, 2002 6:16 PM
To: '[EMAIL PROTECTED]'
Check whether the service finds your init.ora file.
The parameter in
I'd say any company ... but there is an exception ... you pay exorbitant
licensing fees for MS and Oracle software, but you get
software for the money and bugs for free
-- (on the lines of "Money for nothing and the ... ")
Raj
__
Rajendr
Bruce,
Thanks for the info, it is a useful thing to remember.
Now for the post-game analysis: the way we found this
was that RMAN stopped functioning with a
"dbms_backup_restore.somethingorother must be
declared" because the one in the wrong schema was
invalid. RMAN logs in as sys.
When the onc
Excellent information! Thanks for taking the time to write it all down.
Beth
-Original Message-
Sent: Friday, June 14, 2002 10:42 AM
To: '[EMAIL PROTECTED]'
Cc: Seefelt, Beth
Well, with all the caveats that's a long and boring story, so I'll
shorten
it up. ;)
1) SDU/TDU values of
Well, with all the caveats that's a long and boring story, so I'll shorten
it up. ;)
1) SDU/TDU values of 32768, as were specified by our 3rd-party vendor in
their extremely non-OFA f'd-up install, are not valid.
2) Specifying SDU/TDU in TNSNAMES.ORA (or ONAMES) is useless unless it's
corresp
In Oracle, find the sid and serial# of the session and do an "alter system
kill session" command. That will kill it. It might take awhile to kill,
depending on how much rollback it has to do.
[EMAIL PROTECTED] wrote:
> Hi,
> I want to immediately stop a running stored proc.I tried kill -9
Hi Tim,
> FF21 8K read/write/exec [ anon ]
> FF34 8K read/write/exec/shared [ anon ]
> FF3A 8K read/write/exec [ anon ]
> I don't know what "anon" means, but let's
> assume that it is also private to this specific process,
The anon refers to anonymous pages t
what
do you mean about losing numbers after an import/export?
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002
10:44 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: sequence question
Bigp
Remember that when you
I feel compelled to respond. There are many fine consultants that take time
to respond on this list with free advice. I could name a few names, but I'd
slight someone, so I'll just say that you know who you are and your efforts
are GREATLY appreciated. Say Tim, wouldn't you fall within that catego
Hey Tim!
That /dev/null device is really fast! Solaris wrote 10 megabytes
to it in 0.5 seconds.
Where can I get one of those?
Jared
;)
On Thursday 13 June 2002 19:13, Tim Gorman wrote:
> Carmen et al,
>
> Did some testing on this. On solaris 2.8 there doesn't seem to be any
> upper-l
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
Quest.
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Tim Gorman" <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 10:38 AM
To: Multiple recipients of list ORAC
I tried that...didn't fix the problem. The service actually starts without any
problems, but for some reason, starting the service doesn't actually start the
database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba
and then do a startup manually to get the database r
Bigp
Remember that when you issue
sequence.nextval you are incrementing one value and either your process
function correct or not that number is used.
But, the more important is that if your system
crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers
cached. Also yo
Joe:
Good question. I checked services and it was not running. So I started it.
But I still get these errors.
PARTS database - ORA-12541: TNS: no listener
KEN database - ORA-12154: TNS: could not resolve service name.
Any idea what the problem is?
Thanks,
Ken
- Original Message -
T
Installing 9i (9.2.0.1.0) for the first time on a Win2K server and on my
Win2K pro client
SERVER ISSUE:
standard install- enterprise edition - standard starter datababse -
software appears to install and then config tools launch
net config assistant complets
dbca has now been running for about 18
We are just starting to look at replication so each manufacturing plant can
have their own server. The applications are being developed in-house. I feel
the first issue is to analyze each table and decide how it will be
replicated and what schema changes need to me made to accommodate
replication.
John,
I think you're confusing "characterset" with "language"; you can pack a lot
of languages into the WE8ISO8859P1 or P15 charactersets! I think the P15 is
new for including the euro character, by the way...?
Look in the view NLS_INSTANCE_PARAMETERS for a list of the configurable NLS
initial
Live and learn! I'd never heard of SSTIOMAX, but there's a decent MetaLink
article on it (#131530.1)...
I tried using "nm" and "strings" on the "oracle" executable and many of the
".a" and ".so" objects and couldn't find it mentioned, so it must be a
"#define" compiler directive in the source co
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
who does? :-)
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 6:28 AM
Subject: RE: I/O contention with externa
BDY.RTF
Description: RTF file
One can 'plug' in a DMT via TTS. but can not make it writable... ;)
- Kirti
-Original Message-
Sent: Thursday, June 13, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
I would treat dmt's as obsolete. (In 9.2, all
tablespaces default to locally managed, and
furthermore, i
Title: RE: set sort_area_size, sort_retained_size,hash_area_size but sti
Sorry the OS is Solaris 2.8 the database version 8.1.7.2
-Original Message-
From: Reardon, Bruce (CALBBAY)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 9:03 PM
To: Multiple recipients of list ORACL
Good morning,
I am trying determine whether a proposed 8-way Intel (Unisys ES7000) system
running Windows 2000 will support our anticipated work load.
I know this question has a LOT of variables but I don't even have a feel for
some of the numbers.
Two things:
One - just to get an idea of th
or wrap it within execute immediate
hth
connor
--- Ganesh Raja <[EMAIL PROTECTED]> wrote: >
This is due to the difference betweeen the PL/SQL
> Compiler and SQL
> Compiler. This has been rectified from 9i onwards
>
> One way to achive this is to Create a view and
> access this View in
> Pl/sql
Stephane,
This deals with Section 508 of the Rehabilitation Act. The following link gives
additional info, should anyone have an interest http://www.access-board.gov/508.htm
Hope this helps
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROT
On 2.7
0.8128 read(3, "\0\0\0\0\0\002\0\0\0F0\0"..,
10485760) = 10485760
0.1003 write(4, "\0\0\0\0\0\002\0\0\0F0\0"..,
10485760) = 10485760
0.7603 read(3, "\0\00386\0\0 P\01BAFD0FA"..,
10485760) = 10485760
0.1039 write(4, "\0\00386\0\0 P\01BAFD0FA"..,
10485760) = 10485760
1.0187 read(3, "\0\
1 - 100 of 110 matches
Mail list logo
