gt;Isn't DBA usually a second or third career at the least?
Is it ??? I am a DBA now and this is my first carrer. Initially I was sort of
sql/pl-sql support person for 10 months and after that I am a DBA. What should I
consider myself ? Lucky or Unlucky ???
Get Your Private, Free E-mail
Thank you Kirti, and thank all of you who attended for your
overwhelmingly enthusiastic feedback! It was a tremendous honor to have
almost three hundred of you in our home this week. I hope we can earn
that privilege again next year.
Thank you again,
Cary Millsap
Hotsos Enterprises, Ltd.
Thanx Rohit.
Thanx everybody.
for helping me to do this.
On Wed, 12 Feb 2003 Negandhi, Hiten wrote :
Is the number of rows in the test table fixed?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: oraora oraora
INET: [EMAIL PROTECTED]
Fat City Network
At 12:23 AM 2/13/2003, Dilip wrote:
Actually lots of users are connecting to this database from remote
locations and connections are very slow because of network. So these
clever people wants some sqls/reports to be run from ODBC connection and
get data into excel and then work on that data.
Title: DBMS_SQL
Dear All,
I am trying to pass to dbms_sql.parse dynamic values from a cursor declared before the call by the dbms_sql.parse. I am getting ORA 1001 .
How can I do that?
Kind Regards,
Hatzistavrou Yannis
I'd be more worried about the bull being nervous :-)
--- Mogens_Nørgaard [EMAIL PROTECTED] wrote: Those
rumors about me being nervous on that bull are
untrue. All of them.
It was good seing you again, Kirti. Take care until
next time.
Mogens
Deshpande, Kirti wrote:
The Hotsos
For me, simplicity and functionality is the key. For
smaller db's, I like every datafile 1G or 2G. Then if
I know that roughly every file takes the same time to
backup. If I need to swap two for io balancing
reasons, then I know space-wise I'll be fine. Any
datafile that I drop can easily be
It may have changed in 9, but I'm pretty sure the
keep, recycle pools are not identical to the default
cache in terms of the hot/cold boundary. You could
always tweak the relevant underscore parms to make
them all the same - but you'd want to be very sure
that you could get maximal use out of
frm Dilbert: Pointy-Haired Boss
the stereotypical damager
--- [EMAIL PROTECTED] wrote:
PHB's? I looked it up and all I could find that fit was Psycho Hose
Beast. Is that correct?
http://www.acronymfinder.com/af-query.asp?Acronym=PHB
Suji,
When you post a question and figure out the answer, please tell us as
well so we don't have to reinvent the wheel should it ever happen to
us!
Rachel
--- Sujatha Madan [EMAIL PROTECTED] wrote:
I think I've figured it out and now I have more info (after
researching a
bit more) to solve
Hi people
Need some to fresh size a new database (9iR2, or other).
Any one happens to know were i can get such tool???
Please
Paulo Gomes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paulo Gomes
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
gt;Have you considered a reporting tool like Brio or Crystal Reports? You can
gt;define reports that users can run whenever they like or have those reports
gt;pushed out to them on a schedule when database activity is lower. You can
gt;present the reports as HTML, or download them as CSV's
yeah but I'm not listed as a speaker either (they haven't updated the
matrix for Wednesday since December 19) and I'll be there.
The IOUG site is notorious for being updated slowly or incorrectly.
--- Adams, Matthew (GECP, MABG, 088130) [EMAIL PROTECTED]
wrote:
The Exhibitor List at at the
Title: Ora-1001
Dear all,
I am trying to construct the following PL/SQL block. When I run it I always get an 0RA-1001 error. May you please help me
Environment
Oracle 8.1.7.0
O/S W2K Sp3
declare
l_cursor integer := dbms_sql.open_cursor;
output utl_file.file_type;
cursor lnklst_cur
Standard Edition(SE)will do the good,
old standby database thing quite well, but without the bells-and-whistles that
became available in v8.1.x (i.e. automated log shipping, log shipping over
SQL*Net, automated log apply, up to 5 archive destinatios, etc). You'll
essentially be running in
Title: RE: Hotsos Symposium in Dallas
He was !!
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,
Title: DBMS_SQL
Would you mind to post a sample of your code?
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Hatzistavrou John
To: Multiple recipients of list ORACLE-L
Sent: Thursday, February 13, 2003 5:06
AM
Subject: DBMS_SQL
Dear
Dilip - I think you are on the right track. I saw your post to Justin, and
that is what what we often run into -- we give the users a report tool and
hope they'll go away, but they come back and ask IS to create the reports.
Here are the issues as I see them:
1. Users are developing more
i generally will not permit a file to exceed 2 gig for reasons of managability.
eg since a file is the smallest recovery unit, i want something small enough so that i can easily recover it without incurring too much downtime.
if i need to move some files around, 2 gig is small enough so that i
tom,
if the process is IO bound (ie consumes little cpu) then you can achieve a lot.
thanks,
steve
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/12/2003 02:23 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Hi list
Does anyone know of any good white papers online (or maybe a Metalink Note
ID, I couldn't really find the right thing) about tuning an Oracle instance
for batch processing ?
Thanks,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:
Title: Ora-1001
You are opening your cursor(l_cursor) outside of the loop, and you are
closing it inside the loop.
So, on the second iteration your l_cursor is
invalid.
Move closing cursor statement outside the loop:
end loop;
dbms_sql.close_cursor( l_cursor );
end;
/
Igor Neyman, OCP
Resending and hoping for some responses, even some real-world stories ... ?...
Date: Sun, 09 Feb 2003 18:38:35 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
X-Sender: Hemant K Chitale [EMAIL PROTECTED]
Subject: Histograms on VARCHAR2 columns ?
I have just begun trying
Dear friends,
I traced one of our test cases and found something weird.
Did anybody else observe this?
Env:
server - 9.0.1.4, Solaris.
client - weblogic 7, uses original oracle thin 9.0.1 jdbc driver to connect.
In fact, I can reproduce all this from SQLPlus
Here is an excerpt
Vivek - I just wanted to make sure that your tests accurately reflect your
production situation. The easiest tests to construct are the simplest ones.
I've seen people draw wrong conclusions from those tests and even widely
publish those conclusions. :-(
Your original question just asked how
If I have Oracle 9.2 on AIX 4.3.3 and we upgrade to AIX 5.1, do I need to re-install
the Oracle 9.2 software or will it all just work after the upgrade? Anybody know?
Keith H.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henry, Keith
INET: [EMAIL PROTECTED]
Hi
Is anyone running ORacle on Sun solaris with db_block_size 16K? We are
getting an error while creating a 32K block size database on Sun and Oracle
says 16K is the max on Sun solaris..
Thanks a lot...
Babu
_
This e-mail transmission and any attachments to it are intended solely
Title: RE: 10046 trace - weird library misses
Are you using dynamic sql? execute immediate? That might explain ... because exec immediate does a hard parse ... and it is documented too.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra
All,
I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun
Unix box to myself when the batch job runs.
Anybody been able to do this? I can send the text of the file, but what I
really want to do is to send the file (it's an Excel Spreadsheet).
thanks in advance.
Tom
Mice.
Adams, Matthew (GECP, MABG, 088130) wrote:
RE: Teradata baned from IOUG???
The Exhibitor List at at the IOUG web site
does not list Teradata.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of
The PHB is from Dilbert (Pointy Haired Boss)
Rick Weiss
-Original Message-
Sent: Wednesday, February 12, 2003 8:04 PM
To: Multiple recipients of list ORACLE-L
PHB's? I looked it up and all I could find that fit was Psycho Hose
Beast. Is that correct?
Let's see ...
Your DB_CACHE_SIZE is 16MB == 2048 blocks
The table is approx 14,677 blocks
The record-size is something like 800bytes
Each multiblock read call will read 32-blocks
Your DB_CACHE will be filled in less than 64 read-calls and will have
less than 1/7th of the table.
Your server will
believe the error message!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 8:03 AM
Hi
Is anyone running ORacle on Sun solaris with db_block_size 16K? We are
getting an error while creating a 32K block size database
Now
you've done it... I'll never be able to listen to that song again without
thinking...
"We
will, we will, RAC you"
:-)
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 12, 2003 11:19
PMTo: Multiple recipients of list
Stephen Evans£¬ÄúºÃ£¡
It seems your words are right, after i balanced my disk io and retest the index
build, wait time during index parallel creation increases.
I will retest my creation next morning.
Thanks.
2003-02-13 06:38:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º
Hi,
It is just telling that you are doing HARD PARSE.
Hard Parse is indicated in the trace file as
'misses in library cache';
Best Regards,
K Gopalakrishnan
-Original Message-
Gorbounov,Vadim
Sent: Thursday, February 13, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L
Dear
Steve,
I
believe what you say, but it seems counter-intuitive.
If you
only have one cpu, and you start two jobs, then it follows that the cpu needs to
split itself to do the work.
So,
what are we gaining? The CPU can only go so fast and do so much
work.
Tom Mercadante Oracle Certified
Not an RDBMS bug -- it is the behavior of both your JDBC thin program as
well as SQL*Plus. Every execute is preceded by a parse in SQL*Plus -- they
didn't write that utility with parsing efficiency as a primary goal.
Apparently, neither was the JDBC thin code...
- Original Message -
To:
Good points. In Denmark we have a lot of Damgaard/Navision/Microsoft Business
Solutions sites running these - usually modestly-sized - ERP-systems on SE.
Tim Gorman wrote:
Standard Edition(SE)will do the good,
old standby database thing quite well, but without the
Dennis,
I think you need to change your tag line to:
Dennis Williams
DBA, 40%OCP 100%DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Cheers!
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/13/2003 9:04 AM
Vivek - I just wanted to make sure that your tests accurately
Jailhouse RAC !!! anyone?
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
having an opinion
Stefan - Batch jobs can vary quite a bit. There are report batch jobs that
just do queries. There are update batch jobs that query and write. It is
hard to have any rules of thumb that apply just to batch jobs.
Actually, batch jobs tend to be easier to tune because it is easier to
run repeated
It's just amazing to me the ideas that people latch on to and will defend
with their very lives. I had, long ago, ae DBA manager that worked for a
client, who was just sure that object oriented databases were the wave of
the future. He blasted Oracle all the time because it didn't have OO
With all this discussion on Why RAC?, I thought I'd chime in with our
reasoning, at least as it stands before any testing.
We currently have a few major databases for our ERP/MRP system,
Engineering drawings, and legacy (I loathe that word) data. These
databases are spread across three larger
How about relink all from the $OH/bin directory? Or is this utility gone
in 9i?
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
Subject:
I forgot to mention that the Oracle version is 8.1.7.4
TIA
Babu
babu.nagarajan@Cu
Simply put, CPU is swifter than I/O (though not as
much as some would have us believe!).
7-8 years ago, we benchmarked Oracle 7.1 PQ on
single-processor IBM RS6000 nodes and found that the "sweet spot" was DOP=4
(where "DOP" means "degree of parallelism"). In testing on those 60Mhz
PowerPC
in oracle 9.0.1 Documentation:
DB_BLOCK_SIZE
2048 to 16384 (Linux, Solaris)
2048 to 32768 (AIX, HP, Tru64)
Of course you can always use the multiple block_size option in non system
tablespaces.
See e.g :Marlene Theriault,paper at IOUG live 2002
...As with earlier databases, the
Title: RE: Oracle License for Training
For me the question is not If? but When?
Any prognostications?
-Original Message-
From: Cary Millsap [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 9:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle License
If you asked me last week I might not have formulated much of an opinion,
but I have been tainted by Mogens presentation on RAC or Not To RAC.
Here are some questions you need to ask...
Why not go with a box capable of the CPU's you will eventually need. Why
add machines when adding CPU's might
Hi!
This should work:
$ sendmail -v [EMAIL PROTECTED]
your_report_file.xls
-v means: verbose
you can skip it!
HTH
JL
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
All,
I'm trying to send an email attachment (Oracle
Tablespace Report) from a Sun
Unix box to myself when the batch
Hi Listers,
I'm trying to build the shared libraries for external procedures :
$ make -f demo_rdbms.mk extproc_no_context SHARED_LIBNAME=shell.so
OBJS=shell.o
I tried in HP as well as Sun machine, both I got the following error :
Make: Don't know how to make shell.o.
Any idea what's wrong ?
Hi all,
Does Unix has an on-line research source, like
metalink for Oracle? Pls send me the links. Much
appreciated.
Also is Linux pretty similar to Unix. What's the
major difference?
Thank you in advance!
Andrea
__
Do you Yahoo!?
Yahoo!
At least you're going to want to relink everything in Oracle on the server.
Go to $OH/rdbms/lib and make -f ins_rdbms.mk install. Also go to
$OH/network/lib and make -f ins_netserver.mk install. In fact, do a
find for all files named ins_*.mk and consider whether to do similar
steps...
-
UUENCODE the file then send it as text.UUDECODE it back to a file at the
recipient.
-Original Message-
Sent: Thursday, February 13, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
All,
I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun
Unix box to
Title: RE: AIX Oracle 9.2
don't reinstall if you already have 64bit installed, just recompile ... it should work fine.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal
Yes KG,
I understand this.
The question is why HARD every time, only when trace is on, and taking into
account 9.2.0.2 doesn't suffer this weirdness, this must be a bug.
Metalink says - fixed in 8.1.7.2.
If the bug, somebody else must be hit since 10046 profiling used by many
people these
Hi I have a function called mail_dba which i load in my .profile
In .profile
FPATH=$ORACLE_BASE/admin/$ORACLE_SID/dbafuncs
export FPATH
autoload mail_dba
Then in the location specified by FPATH i have a file called mail_dba
which contains the following:
mail_dba_ ()
{
mailx [EMAIL PROTECTED]
Hi all:
I'm tuning an OPS env. and the things are getting quite deep, DLM latch
issues and so on (e.g. lots of waits on dlm resource hash list). So I was
wondering if any of you know of any site or doc. which could help me on this
(OPS tuning specific and very deep information).
Of course the
You mean:
mailx -m -s Test Message [EMAIL PROTECTED] EOF
`ux2dos /home/report/tbsp.lst | uuencode
/home/report/tbsp.lst`
This is from an HP-UX system
hth
mohammed
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
All,
I'm trying to send an email attachment (Oracle
Tablespace Report)
8.1.7.2
Is there a short list of steps for a successful RMAN install and
ramp up under Legato in the final phase.
I'm looking at a server with about 4-6 databases on it. We're
basically looking at the following:
Create RMAN database.
Create test area for disk first, then tape as we put it under
Raj, where is it documented that EXEC IMMEDIATE always does a hard parse?
Thanks,
Jared
Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/13/2003 07:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Thomas,
Thursday, February 13, 2003, 9:44:07 AM, you wrote:
M All,
M I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun
M Unix box to myself when the batch job runs.
M Anybody been able to do this? I can send the text of the file, but what I
M really want to do is to
I'm
RAC --ing my brains on this cluster...
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 13,
2003 9:50 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: [new info] Redhat Advanced Server Dev Edition
- RAC
Jailhouse
Title: RE: 10046 trace - weird library misses
Raj,
It's
not dynamic.
From
SQLPlus prompt it looks like
SQL BEGIN :n := FNC_SP_GET_SUBID_BY_EXT_KEY (:v); END;
2 /
Thank
you,
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 13,
Tim - Your statement about the JDBC thin client really grabbed my attention
since we plan to create some important systems based on this.
I thought parsing was related to bind variables (using PrepareStatement
in Java), and whether that SQL statement was previously executed and is
still
Still there! Thanks!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 10:03 AM
How about relink all from the $OH/bin directory? Or is this utility
gone
in 9i?
Scott Shafer
San Antonio, TX
210.581.6217
I setup histograms on a table a little over a year ago to help with a
query that was taking much too long.
The query:
SELECT MIN(DOCNUM)
FROM
SAPEDIDC
WHERE RECSTAT = 'U'
All values for recstat:
SELECT recstat, count(*) recstat_count
FROM
cimuser.SAPEDIDC
group by recstat
/
R
Oh, this is just *begging* for me to do some testing.
Anything that isn't real work. ;)
Jared
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/13/2003 08:34 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
1) Solaris
http://docs.sun.com
2) Linux
http://www.linux.org/docs/index.html
3) AIX
http://www-1.ibm.com/servers/eserver/pseries/library/sp_books/index.html
4) Got questions:
try Google at http://www.google.com
5) There's more out there but these sites are a good start.
--
Lyndon Tiu
Tom,
Look at the 'uuencode' utility - it can do what you want. Care to share how
you generated an Excel Spreadsheet in Solaris?
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
I don't know what the future holds for me, but I do know who holds my
future!
** The opinions and
try 'uuencode server filename to whateverfilename | mail
[EMAIL PROTECTED]'
Thanks
Ana E. Choto
Systems Programmer
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax (202) 885-2224
Tim,
By JDBC Thin program, are you referring to the JDBC Thin driver
or the program that uses the JDBC Thin driver, i.e. the application.
I assume you are talking about the later.
Our application is written in Java and uses JDBC Thin and I don't
see any of the hard parse problem.
Thanks
Stephen/Chao-ping,
I will side with Tom on this. In a single CPU situation, you want to avoid
context switches by _reducing_ the number of processes in a single CPU box.
Depending on other stuff such as processor/L2 cache flushing, this can be
quite a significant overhead. So PQ on a a single
Mohammed,
thanks, but the -m option does not seem to exist in Sun Unix.
$ mailx -m
mailx: illegal option -- m
Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address
-s SUBJECT -f FILE users
any other ideas?
Tom Mercadante
Oracle Certified Professional
-Original
I was with Oracle when the OO thing was big. At least it meant that the
whole OCI layer was rewritten for 8.0, which was good for many things.
Today, that's what's happening with XML databases. Oracle will store
them in LOBs (and in 9.2 in a number of tables) while dedicated XML
databases will
Tom - think of it like a bartender serving beers. the bartender is the CPU,
the beer is the data, the glass is the disk. give him 2 glasses, turn on
parallelism (let him use both hands), and he can get your beer to you
faster...
-Original Message-
Sent: Thursday, February 13, 2003 9:40
I use mutt which has the option to attach a file.
mutt -s 'subject' -a filename user@mailserver /dev/null
would send an attachment with no body, put a file instead of /dev/null if you want a
body for the message.
With mailx in unix, I've been told it can be done by piping through uuencode or
We just upgraded the ORACLE from 8.1.7 to 9.2 on SUN server.
I tried to start up the intelegent agent on it and have error happen.
%lsnrctl dbsnmp_start
LSNRCTL for Solaris: Version 9.2.0.2.0 - Production on 13-FEB-2003
12:14:41
Copyright (c) 1991, 2002, Oracle Corporation. All rights
All,
I guess I made the mistake mentioning Excel.
I am creating a tab delimited text file with an .xls file type that Excel
can easily open. It is not a binary Excel file.
I just need to be able to send the file as an attachement.
thanks again and sorry for the mis-statement!
Tom
Tim,
Thanks for you idea, doesn't solve the mistery though.
AFAK, eliminating _HARD_ parses doesn't seem to be client-side
responsibility, server takes care of this. This is definitely true about
soft parses, i.e., client side cursor caching. BTW JDBC 9.x driver is
capable of maintaining
Tom,
Here is a perl script that will send the file as an attachment.
HTH
Peter
#!/usr/bin/perl -w
# mail_attach.pl -- Mail files as attachments
# Created new perl script mostly from MLB 11/09/1999
# The Perl Journal 14 mail_attach.pl example
#
# $ARGV[0]: The sender e-mail address
#
And don't forget, RAC ( or a cluster ) will be of little
benefit if the SAN fails. ( it happens )
Jared
Post, Ethan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/13/2003 09:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
From: Santosh Varma [EMAIL PROTECTED]
Date: Wed, 12 Feb 2003 15:34:46 +0530
Subject: Newbie to Oracle DBA
Hello list,
I wanted to know of some good sites where i can learn the basics as
well as advanced DBA topics. Could anybody help me out ?
Thanks and Regards,
Santosh
I'd go along
Rui,
It is very difficult to identify the problem by just looking
the contention for dlm resource hash list. What are the
current values of lm_% parameters.
Basically that latch protects the resources in LM resource
structures in the lock manager resource table. And I would
compare the values
Does anyone know of an article(s) that discuss the future
direction of the software industry (availableon the
web)?
Thanks much,
Ken Janusz, CPIM
Steve,
I appreciate the beer-related example. A man after my best interests.
But if the customers are on the far-ends of the bar, then the bartender is
wasting time
walking back and forth!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, February 13,
Ask Anjo. I know everybody says he's neither pretty nor smart, but I
think that's just a little unfair...
Mogens
MARREIROS,RUI (HP-Portugal,ex1) wrote:
Hi all:
I'm tuning an OPS env. and the things are getting quite deep, DLM latch
issues and so on (e.g. lots of waits on dlm resource hash
Whoever is going to help do it, please make sure it has a really good wait
interface from the beginning :).
Orr, Steve wrote:
RE: Oracle License for Training
For me the question is not "If?" but "When?"
Any prognostications?
-Original Message-
OMG!!!
Thanks to all! It actually works!
This is what works for me:
I run a sql script that produces a tab delimited report showing tablespace
usage (think of the OEM screen showing all the tablespaces with size, used
and free listed).
I then use the following command to send the report to
Jared, point well taken. One SAN goes and we lose access to 7 DBs.
However, the paranoia between me and my Team Lead will certainly opt for
dual network path, dual power (to go with our current UPS and Ford V8
generator), and some mix of RAIDs 0 and 1. I'm thinking that this will get
us to the
Title: RE: 10046 trace - weird library misses
hmmm...
I shouldn't work on two emails at the same time anymore... Can't work in parallel.
The statement should be ...
There will be a parse, but it could be a soft if the SQL exists ... but a parse will happen so, my answer was absolutely
As one who has created a number of external procedures on HP, Yes you do have to
acquire and install the HP ANSI C compiler. The C compiler that HP ships with
HP-UX is only good enough to build a new kernel and link up the Oracle
executables. It's most likely giving you that error because in the
Title: Message
Tks
Herman, will make that change.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Hemant K ChitaleSent:
Thursday, February 13, 2003 10:15 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Count(*) last 30
Steve,
I'd say IF. Reason is that MySql has a commercial company behind it and it
appears that they see looming in the near future. Their licensing costs
have risen in the last 3 months. Granted their a pile cheaper than Oracle
(correction, make that a mountain), but as always if
Here what I do on our SUN
(cat $ORACLE_BASE/THO1/scripts/backup_misc.log ; uuencode
$ORACLE_BASE/THO1/scripts/crontab_content.txt crontab_content.txt ;
uuencode $ORACLE_BASE/THO1/scripts/pfile_content.txt pfile_content.txt)|
$MAIL -s Backup misc files THO1 $EMAIL_ADDRESS
Hope it helps
Daniel
Title: RE: [Q] how to start intelegent agent on ORACLE 9.2 version?
Agentctl start (from the command line...not in lsnrctl)
-Original Message-
From: dist cash [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
Subject: [Q]
I usually ...
uuencode filename filename | mailx -s foo [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February 13, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
INET: [EMAIL
Title: RE: 10046 trace - weird library misses
I wonder if soft parsingapplies to pl/sql blocks as it applies to
just plain sql?? do you see the sql inside the function
parsed less times compared to execute?
Raj
__
Rajendra
Jamadagni
1 - 100 of 164 matches
Mail list logo