Dear Guru's
Have a question. Does a incremental checkpoint update the
datafile header with the SCN?. My understanding is that it doesn't
update the datafile header but only updates the controlfile with the SCN
and the datafile header is updated only during a full checkpoint
Is my
drop table t1;
create table t1
nologging
pctfree 50
pctused 50
as select
1 n01,
1 n02,
1 n03,
1 n04,
1 n05,
1 n06,
1 n07,
1 n08,
1 n09,
1 n10,
1 n11,
1 n12,
1 n13,
1 n14,
1 n15,
rownum n16,
lpad(rownum,10) v1
from all_objects
;
create index i01 on t1(n01);
create index i02 on
Hello people,
We recently experienced a hang in our database server, WIN2k Advanced server with raid 5 for Oracle 817 database files.
Examining the perf logs showed that Event 2022 caused the hang:
Event ID: 2022
Source: Srv
Description: Server was unable to find a free connection 144
It's probably the case that the trigger fires
the first time - but at parse/optimise time
Oracle had already determined the sequence
of actions needed to execute the statement
based on the then session state, so that sequence
is played out, irrespective of the fact that you
changed the session
Hi Rhojel
Tjeck out: http://www.baarf.com/
Rgds, Frank
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 21, 2004 9:04
AM
Subject: Defragmenting a RAID 5
volume?
Hello people,
We recently
Mladen,
I agree you can measure how many IOs are being done and how many a disk sub-
system, such as those provided by EMC, can perform and still give good
performance. What I meant is that it is hard and some would say impossible to
estimate how many IOs per sec a new application will do. A
Let's be realistic: any table with 15 indexes
PROBABLY needs a little bit of a re-design
exercise? ;)
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
snip
(I assume the report intended to say the first 15
indexes on a specific table, 'cos the data dictionary
alone has
The first 15 indexes CREATED?
Joking, are they?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
I've just been reading a report for one of our systems and it says that Oracle 8.1.7
will only use the first 15
indexes created. Any index created after the 15th will be ignored
Data warehouse with bitmap indexes ?
But in OLTP I would assume guilty until
proven innocent.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next
Does anyone have examples of how to use bind variables in VB when using
OO4O?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
... to whomever is concerned ...
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
When required I did it through a logon trigger ... wait I still do it.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Does anybody by chance have any examples for creating a calender servlet
for 9iAS? I have to admit to being a servlet virgin! ;)
Any pointers much apreciated!
Many thanks
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
I've seen this sort of thing happen when you have more than one Oracle_Home and client
tools get confused about which tnsnames.ora file to use. Fastest solution is to find
every tnsnames.ora file on the client computer and make sure that they are all
identical. Correct solution is usually to
As in: does it present an inherent or hidden performance
problem when a lot of sessions try to lock/release the same
lock? Or how many lock/release per second. Or some other
idea of how efficient it is?
Need to use it in a design, but not sure of any potential
performance hits or scalability
Hi John ,
i have mailed a doc . have a look at it .
Regards,
Prem.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Does anyone have examples of how to use bind variables in VB
when using
OO4O?
John
--
Please see the official ORACLE-L FAQ:
Gene,
I strongly recommend implementing Statspack.
It is very straight-forward.
Just do it when you have exclusive use of the database, or comment
out the following two lines in ora_rdbms_admin:SPCUSR.SQL if you have
these packages already installed.
(We're running 8.1.7 on
As in: does it present an inherent or hidden performance
problem when a lot of sessions try to lock/release the same
lock?
Will serialize perfectly!
Or how many lock/release per second. Or some other
idea of how efficient it is?
Depends on the work done between acquiring the lock and
On a light-weight test on 8.1.7.4 at 700MHz on W2000 -
About 15,000 request/release per second
if you are using an ID
About 8,000 request/release per second
if you are using a pre-allocated lock handle
About 800 request/release per second
if you have to allocate_unique on every
anyone know?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
i think expert one on one has some comments on it. Its in a section referring to
building your own insert locks. So if a table is locked, the user gets notified.
I read the book last year.
From: Nuno Souto [EMAIL PROTECTED]
Date: 2004/01/21 Wed AM 07:49:25 EST
To: Multiple recipients of
nuno-- what level are you trying to scale it to? how long will you hold the locks? I
used it last year because only one process could run at a time.
seemed to have similiar over head to 'select for update'. If you look at the PL/SQL
Packages book by Fuerstein et al(not a real popular book, but
Either re-run catproc or try with utlirp.
On 01/20/2004 12:44:34 PM, Hamid Alavi wrote:
so what's the solution?
-Original Message-
Sent: Tuesday, January 20, 2004 4:10 AM
To: Multiple recipients of list ORACLE-L
Someone is messing with standard package ... so it would seem.
Raj
- Original Message -
Or how many lock/release per second. Or some other
idea of how efficient it is?
Depends on the work done between acquiring the lock and releasing it.
Not really. I'm asking how many lock/releases can be done
before the thing starts putting a serious load on
Is sombebody playing with Statspack (spcreate.sql)?
One piece of the install runs dbmspool.sql
Nelson
-Original Message-
Sent: Tuesday, January 20, 2004 3:59 PM
To: Multiple recipients of list ORACLE-L
So what's the recommendation, how can I recompile all the SYS packages?
I was using Lattice-C on x286.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carel-Jan
Engel
Sent: Tuesday, January 20, 2004
5:29 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Re[2]:
Thanks, Tanel.
Sorry, if I caused any confusion.
May be I should have used 'pipe get' event instead of 'SQL*Net message from client' as
an example,
which of course, should not be ignored in a multi-tier, networked environment. In
fact, I remove
it, among a few others, from
Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and
9.2.0.4 caused
ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to
'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S)
worked,
however, the
- Original Message -
On a light-weight test on 8.1.7.4 at 700MHz on W2000 -
About 15,000 request/release per second
if you are using an ID
sounds plenty good to me. Thanks a lot.
Bear in mind that each request or release will hit the
enqueue latch a couple of times, so you
- Original Message -
nuno-- what level are you trying to scale it to?
Not much. A few hundred users, maybe 20 or so may
need the lock. However, this app may explode in
# users, so I want to make sure I'm not creating
a monster.
how long will you hold the locks?
only long enough to
if it is single instance you could also use global application contexts ... (alas they
don't work in RAC across node) ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
HELP
On 01/21/2004 03:04:26 AM, [EMAIL PROTECTED] wrote:
GB. My question is, can a RAID 5 volume be defragmented? Is it sane,
technically? The volume is 130GB in size...
You are defragmenting a file system, not a volume. Block based file
systems cannot be defragmented, only extent-based file
I could not find an Oracle wait event named 'Parellel Sync Wait' (in v$event_name view
in 7.3.4,
8.1.7.4, 9.2.0.4).
Precise may be calling something else a 'Parallel Sync Wait', or is smart enough to
figure this
out when it seems Oracle isn't instrumented for this particular wait(?). Just
Title: Message
must.resist..temptation.
For
more help, please dial 999 in the UK, 911 in the US, or open your phone and dial
712-BEAM-ME-UP for the year 2247.
Live
long and prosper.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Hi DBAs,
Here is my situation, I'm running Oracle8174 on Solaris.
We are using an external procedure called in my pl/sql. I'll give you my
example:
I will use the Oracle example DEBUG_EXTPROC
I'm on the Unix server and I connect with SQLPLUS, without the listener
SQL connect c$mdlimol2
Enter
yup
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Carel-Jan Engel
[mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004
5:29 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: Re[2]: Oracle vs MysqlAt 03:29 PM 1/20/2004, you
wrote:
On 01/21/2004 07:20:00 AM, Stephane Faroult wrote:
... to whomever is concerned ...
Regards,
Stephane Faroult
Oriole
Spring??? What is spring? I live in New England, we have record colds
and I dunno what the heck is spring? Is that something like 70 degrees?
I've heard about that mythical event
Title: Message
Funny ...Ashish is from "Weight Watchers" and asking for HELP
my advise ... stop starving yourself ... go eat something.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC -
I did a quick and dirty one in pl/sql. No security, or checks on content
yet though.
I'd be more than happy to send it to you.
It might be kind of ugly...i've not done a ton of coding. (something I am
actively working on.
Let me know,
Chris
-Original Message-
Sent: Wednesday, January
Title: RE: OT : Happy Spring Festival
At least you probably have a warm fuzzy feeling about your Patriots going to the supberbowl.
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 21, 2004 8:45 AM
To: Multiple recipients of list ORACLE-L
Just out of curiocity, and while I am trying to learn about Row_NUMBER(),
how would you code the following to do an update on the 2nd column?
select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x
from emp
thx
maa
the analytical functions are available in 8i
(..) wrap then in
Hi Listers,
I'have registered host concurrent program on Oracle
11.5.9 as TEST.prog which include one line to execute
the ar60runb on command line. Unfortunately this is
does not work for me. The problem is the TEST.prog can
execute any other command or script (shell, Perl,...)
but not ar60runb
I sent this last night. Im not sure if it went through. If it did, I apologize for the
spam.
Does anyone use CMAN? Its in the certification books(yes I know certification isnt
very good, but I might as well learn something if Im going to do it), but I dont know
anyone using it. It strikes me
I know what you are talking about. I lived in New Hampshire when I was in
the US Navy and attended grad. school at the U. of New Hampshire. February
seemed to be the big snow month. Not uncommon to get two feet of snow in a
nor-easter and have 5-6 feet on the ground - in southern NH. The roads
Ryan,
Check out DBCC SQLPERF(WAITSTATS), and also take a look at the
sysprocesses table - with columns waittype, waittime, lastwaittype and
SPID. Something like:
SELECT spid AS SPID, waittype AS WaitType, waittime AS WaitTime,
lastwaittype AS LastWaitType
FROM sysprocesses
WHERE (spid 50)
Bruce,
You are doing a GREAT job keeping the lists running.
And you seem to have put in some effort in developing/implementing the
load balancers
and then again in retrieving the squirreled-away emails.
Thanks. We appreciate your work.
Regards
Hemant
At 05:39 PM 19-01-04 -0800, you wrote:
Wondering if there is a rule of thumb, quick'n fast but good enough
to be used as an indicator, litmus paper so to speak, of overly indexed
table(s)...
Can, better yet - should, sheer size comparison of index versus table
segments be used as a reliable pointer to problematic table indexing?
Title: Message
Ashish
realizing his time is short he crawls to the terminal and with his last
remaining strength double clicks the outlook icon, clicks thenew button
selects "New Mail Message" button,using the shift key he types H - E - L -
P in the message body window and hits send and
I've used it to allow DB connections through a non-sqlnet-aware firewall, and also to
enable SSH tunneling of DB sessions. In the former case the firewall was blocking the
redirect, although port 1521 itself was open. In the latter, a redirect would have
taken us outside the encrypted tunnel.
Raj, bwahahaha, now thats funny :)
joe
Jamadagni, Rajendra wrote:
Funny ... Ashish is from Weight Watchers and asking for HELP my
advise ... stop starving yourself ... go eat something.
Raj
Rajendra dot
Title: SQL Code release
Is there a tool available to release same set of DDLs, DMLs, PL/SQL code
in different database environments like QA, Unit Testing, Production Support etc.
I guess this can done by writing shell or batch scripts. But I am looking for
a GUI tools to do this.
Thanks
Wednesday, January 21, 2004, 9:44:48 AM, Mladen Gogala ([EMAIL PROTECTED]) wrote:
MG Spring??? What is spring? I live in New England, we have record colds
MG and I dunno what the heck is spring? Is that something like 70 degrees?
MG I've heard about that mythical event but at present I'm shoveling
Although you've had a row-at-a-time version
from someone, you might try something like
the following if you can't do a create as
select to rebuild the original data.
Create table temp
pctfree 0
nologging
as
select
rowide_rowid,
row_number() over (PARTITION BY DEPTNO order
OTN has published a list of Oracle Open Source Projects at
http://otn.oracle.com/tech/opensource/projects.html
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ:
Stephane probably meant Chinese New Year, which is tomorrow (1/22/04). This
will be the Year of Monkey.
I live in Boston, the weather has been brutal this winter so far. I cann't
wait for spring to come so I can start to play soccer again.
Guang
-Original Message-
Mladen Gogala
Sent:
Sure. You can try the Change Management Pack for Oracle Enterprise Manager
from Oracle. Then there is the bevy of tools from Quest software.
DB Artisan is another.
RWB
Reginald W.
The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.) on
Windows 2003. Do you know if it is certified to, or will it do it?
Thanks
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
These results don't seem possible.
I run the following query:
select ((vse.time_waited/100)/60) time_waited,
((vse.time_waited/vse1.total_time)*100) p_time_waited,
vse.event
fromv$system_event vse, (select sum(time_waited) total_time from
v$system_event) vse1
where
Hi Hemant,
Many thanks. You are right. It's all about the
variable environments. Now it works fine.
Have nice day.
Ben
--- Hemant K Chitale [EMAIL PROTECTED] wrote:
Does your TEST.prog include the environment for
ar60runb ?
If it runs as a shell script, does it have
$ORACLE_HOME, and
Title: SQL Code release
OEM has such a tool built into it ... we went through a research, ended
up writing our own because each environment is different.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All
Hi Michael,
1) You need to ensure that the listener is configured properly.
2) Your tnsnames.ora or namesserver is configured properly.
3) There are no problems in installation of Oracle client,server and
database .
If the above conditions are satisfied , you should have no problems
in
Unless I am hallucinating (always a distinct possibility), there was a
recent discussion on this list about the trace file location when you
perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious
solutions. I didn't think I'd need this, so deleted the postings. Well,
guess what
Does your TEST.prog include the environment for ar60runb ?
If it runs as a shell script, does it have $ORACLE_HOME, and $PATH
setup correctly ?
Hemant
At 07:09 AM 21-01-04 -0800, you wrote:
Hi Listers,
I'have registered host concurrent program on Oracle
11.5.9 as TEST.prog which include one line
Do you mean Windows 2003 Advanced Server? Check the compatibility matrix
on Metalink.
RWB
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your
www.ixora.com.au
there is a script in there that will identify unnecessary redundant indexes.
for the record, that is one of the best oracle websites out there. Lots of great stuff
on it.
From: Branimir Petrovic [EMAIL PROTECTED]
Date: 2004/01/21 Wed AM 10:39:25 EST
To: Multiple
From metlink, it looks like the 8.1.7 client is not certified for Windows 2003
server. You should
probably install the 9.2 client on the workstations. It should ahve no problems
connecting to the
8.1.7 database on unix.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The box said I needed to have
Calendar servlet sounds pretty generic. What more specifically do you want your
servlet to do?
If you are writing a PL/SQL Web app with mod_plsql, you might want to look into the
OWA_UTIL procedure that takes a query and writes a calendar page in HTML. The query
includes columns for the
Title: SQL Code release
checkout tools for www.agileinfosoftware.com, we use
DataAnalyst to do similiar jobs like yours.
Eric
- Original Message -
From:
Ashish Sahasrabudhe
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 21, 2004 11:09
AM
Title: RE: OT : Happy Spring Festival
60 above zero. Floridians turn the heat on. People in New
England plant gardens.
50 above zero. Californians shiver uncontrollably. People in New
England sunbathe.
40 above zero. Italian and English cars won't start. People in
New England drive with
They appear to be Tango Uniform today!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 21, 2004 12:25 PM
To: Multiple recipients of list ORACLE-L
www.ixora.com.au
there is a script in there that will identify unnecessary redundant
Hi All,
We are running 9.2.0.4 on windoze 2000 server and this morning we were
forced to restart the database server. Users complained about not able to
connect to database...
TNS could not start dedicated server process...So I tried to connect to
db using OS authentication...(sqlplus / as
See the Ratio Modeling paper at Orapub.com
It is a quick and dirty method for capacity planning.
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/21/2004 01:34 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
The result depends on the number of sessions. If you have
session A waiting for a 'enqueue lock' for 10 minutes and session
B waiting for the same lock as session A for another 10 minutes,
then the recorded time is 20 minutes, despite the fact that sessions
are waiting concurrently. If you have,
Dear All,
We are trying to tune SQL*Net using SDU,TDU and Arraysize parameters.
Could some one enlighten me how to calculate an optimal arraysize value for an
application? I did search metalink. In our java applications few queries are returning
1 or 2 records and few of them returning 10s of
When I worked for Oxford, there was a way to force the application to
either perform or die. The OLTP database was enforcing profiles and
there was limit of 1500 logical reads per call, because it was
estimated that our typical OLTP application never performs more
then that. If application was
Wednesday, January 21, 2004, 1:14:25 PM, Goulet, Dick ([EMAIL PROTECTED]) wrote:
GD 500 below zero. Hell freezes over. Red Sox win the World Series.
LOL! Hey, that's funny. But you know, Hell freezes every
year here in Michigan (zoom in one notch to see it):
Sorry it took so long to get back to you; I've been caching the list for awhile
and am just starting to catch up. :-)
Page 43, in the grey box with title 'Re-Creating the Controlfile: RMAN Users
Beware!'
Rich
--
Rich Holland(913) 645-1950SAP Technical Consultant
print
I thought this might be relevant and interesting...
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr
ack=NL-93
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services--
Kirti, you're back!
Must have finished the book. :)
Re the PGA problems, what was the value for 'over allocation count' in v$pgastat?
Did you try increasing P_A_T to a larger number?
Oracle is supposed to grab the memory it needs, if available, regardless of
the P_A_T setting.
Also, did
Jolene,
Mladen's answer is a good one. There is also an in-depth discussion on
this subject on pp210-217 of the book Optimizing Oracle Performance.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL
LG,
I know there is a simple solution to this .. but I can't think of it right
now. Any help will be appreciated ...
Thanks,
Nikhil
=
[ny-nikhil1:/export/home/nkhimani/bin]$ export AWK=awk '{print \$4}'
Thought PostGreSql smelled a lot like DB2. And although I agree with their
definitions on the surface they miss a lot of the underlying capability in Oracle.
Sure, one database per instance, but you can them map multiple applications/schema's
into that instance. Makes for a lot less fun when
Replies in line...
- Kirti
--- [EMAIL PROTECTED] wrote:
Kirti, you're back!
Thanks. Found some slack time from routine DBA work!
Must have finished the book. :)
Not yet.. Its tough..
Re the PGA problems, what was the value for 'over allocation count' in
v$pgastat?
Title: SQL Code release
It
seems we also need to write our own tool.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21,
2004 11:20 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: SQL Code release
OEM has such a tool
Yup..we just added the functionalty to the verify_password
functionwala.
Brian S.
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 5:59 PM
To: Multiple recipients of list ORACLE-L
You have to check for errors in the ORA-28000 range, for this is the
range that
kirti-- would you recommend avoiding pga_aggregate_target for now?
From: Kirtikumar Deshpande [EMAIL PROTECTED]
Date: 2004/01/21 Wed PM 02:44:31 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: pga_aggregate_target and a memory leak
Replies in line...
-
Murali,
Have you checked the OS event logs like the system log? Sounds like you
have hit an OS limit. Please post the rest of the error stack that followed
the ORA-12450 as this gives more information on what is the root cause of
this failure? You can find this in the listener.log at the time
Okay, I was hallucinating -- and it is only Wednesday! I had been looking
through some old emails yesterday. The thread was on September 17 18,
2002. If you are interested, go to Google and enter Oracle-l backup
controlfile to trace. Elegant solutions were posted by Waleed Khedr,
Richard Markham,
I'm happy to see in the Jan/Feb '04 issue of OraMag that the use of Oracle's
extended trace was being explained. I know I've heard that Traffic
analogy somewhere beforeHey! Cary's the article's author!
I also appreciated the reference to 10g as being in the future, since it's
promise date
[EMAIL PROTECTED] oriole]$ export AWK=awk '{print \$4}'
[EMAIL PROTECTED] oriole]$ echo ${AWK}
awk '{print $4}'
[EMAIL PROTECTED] oriole]$ cal | awk '{print $4}'
We
7
14
21
28
[EMAIL PROTECTED] oriole]$ cal | ${AWK}
awk: cmd. line:1: '{print
awk: cmd. line:1: ^ Invalid char ''' in expression
I apologise for the wrong error #...it was a typo on my partthe error #
is 12540
Here is the error stack
===
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
On 01/21/2004 02:29:26 PM, Cary Millsap wrote:
Jolene,
Mladen's answer is a good one. There is also an in-depth discussion
on
this subject on pp210-217 of the book Optimizing Oracle
Performance.
I knew that you will immediately recognize method C!
--
Please see the official ORACLE-L FAQ:
On 01/21/2004 02:54:25 PM, Spears, Brian wrote:
Yup..we just added the functionalty to the verify_password
functionwala.
Brian S.
Brian, are you related to the young lady named Britney and whose
marriage was shorter then the average transaction on my database?
She happens to have the same
Thanks for your reponses. We're working on make these changes now.
Ana E. Choto
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax (202) 885-2224
Spears, Brian
I think it depends on your applications.
In DSS type environments we are still stuggling to figure out if P_A_T is helping or
not. Initial
tests are not in P_A_T's favor.
But in another Application, that is 80% OLTP, P_A_T was the only choice to avoid
swapping. This
9.2.0.3 database had the
LOL!!
Ok, Ashish, the problem is you sent 'help' to the list address.
Send HELP to [EMAIL PROTECTED] and all will be well.
Ok, now back to work everyone.
Jared
Odland, Brad [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/21/2004 07:59 AM
Please respond to ORACLE-L
To:
Title: RE: Old thread - trace file location
For 9.2 users:
Alter database backup controlfile to trase as '/disk1/backup/ccf.sql' reuse noresetlogs;
Alex.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 21, 2004 12:24 PM
To: Multiple
I believe the Jan edition of SQL Server magazine has an article on this very subject.
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 8:35 AM
To: Multiple recipients of list ORACLE-L
anyone know?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
1 - 100 of 118 matches
Mail list logo