- 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
, however, what will you gain
by defragmenting. If your files have n extents, their extent
maps are cached in memory and need not to be re-read each time
you access files. Hopefully, you're not using an NT system for
DW, which means that your I/O pattern consists of random
reads/writes, few
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
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
expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Mark Leith
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004
9:45 AMTo: Multiple recipients of list ORACLE-LSubject:
RE:
must.
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
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)
about 1/8th of the
messages sent to mailing lists since 12-Jan-2004 were not redistributed
properly. I have since found and fixed the problem, so this shouldn't
happen in the future. I suspect I was only able to re-send a portion of
the missing messages, so my apologies for anyone who posted
-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21,
2004 8:59 AMTo: Multiple recipients of list
ORACLE-LSubject: RE:
Funny ...Ashish is from "Weight Watchers" and asking for HELP
my advise ... stop starving yourself ...
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.
recipients of list ORACLE-L
*Subject:* RE:
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
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
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.
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
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
:
[EMAIL PROTECTED]Subject: RE: Oracle 817 client on
Windows 2003?
.com
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
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
:Re: FW: Disk capacity planning
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
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,
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:Re: FW: Disk capacity planning
Mladen,
I agree you can measure how many IOs are being done and how many a
disk
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 unpack(u
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
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?
Actually
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
]
[EMAIL PROTECTED]
n.eduTo: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re
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,
[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
:
|
| Subject: Re: ORA-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
RE: Password management using
PMprofiles
Please respond
:44:31 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: pga_aggregate_target and a memory leak
Replies in line...
- Kirti
--- [EMAIL PROTECTED] wrote:
Kirti, you're back!
Thanks. Found some slack time from routine DBA work!
Must
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Ashish realizing his time is short he crawls to the terminal and with his last remaining strength double clicks the outlook icon, clicks the new button selects New Mail Message button, using the shift key he types
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
--
Yep!
Thanks,
Nikhil
-Original Message-
Sent: Wednesday, January 21, 2004 2:55 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] oriole]$ export AWK=awk '{print \$4}'
[EMAIL PROTECTED] oriole]$ echo ${AWK}
awk '{print $4}'
[EMAIL PROTECTED] oriole]$ cal | awk '{print
...
- 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?
Actually, I never bothered
When you have already contacted oracle support, you could have asked
them. It's their job to know that.
On 01/21/2004 05:24:28 PM, AK wrote:
Looks like we are hitting bug 3091541 ( As per oracle support ) .
getting ksedmp: internal or fatal error
ORA-00600: internal error code, arguments:
. 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?
Actually, I never bothered to look at v$pgastat. Should have.. and will,
when we do
Hmm, that's actually a very good idea.
It might actually do the job here. Thanks.
Nuno Souto
[EMAIL PROTECTED]
Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
if it is single instance you could also use global application
contexts ... (alas they don't work in RAC across node) ...
--
Please
Jonathan Lewis [EMAIL PROTECTED] wrote:
Sounds like you just need each user to call allocate_unique
on startup to get a group-specific handle, then do a
request in exclusive mode before doing the job and
a release on completion. Users will then naturally queue
and resume with minimum
Thanks for your reply Jonathan..Here is an update..
The update that i sent you yesterday is updating a column on which there
is a local bitmap index. There are also other local bitmsap indexes on
that partitions. Yesterday i made all the local indexes pertaining to
that partition UNUSABLE and we
--- [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
|
| ||
|-+
---
---|
|
|
| To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] |
| cc:
|
| Subject: Re: ORA-12540: TNS: internal limit restriction
exceeded
|
| ||
|-+
---
---|
|
|
| To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: ORA-12540: TNS: internal
limit restriction
exceeded
, will
have to see tomorrow evening after the day's load has
hit it.
Paul
this was on w2k server sp3, 9.2.0.4 std ed
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
.
- Kirti
--- [EMAIL PROTECTED] wrote:
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
this mean that I'm reading another myth? Couldn't confirm it on metalink.
Ta,
Leng.
---
From: Jonathan Lewis [EMAIL PROTECTED]
Date: Wed, 21 Jan 2004 07:20:30 -
Subject: Re: Oracle 8.1.7 can only use the first 15th indexes?
drop table t1;
create table t1
nologging
pctfree 50
is good as it still allows you to capture the
database structure}
Hemant
At 08:54 AM 21-01-04 -0800, you wrote:
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
On 2004.01.19 23:39, Jonathan Gennick wrote:
I used to use a SQL Module compiler. Not with Oracle though.
It's rare for me to run into someone else who likes that
approach. Actually, it's rare for me to encounter someone
who's even heard of it...
Jonathan, I've been around for a long time.
[EMAIL PROTECTED] wrote:
Firstly, apology if this question sounds silly.
I am intrested in setting up a RAC configuration at my home with
a few desktop PC's. I would run either Win2K or Redhat Linux for the
same. I am not sure whether I would be able to setup the RAC using a few
desktop
I added the parameter to registry OSAUTH_PREFIX_DOMAIN=true
but it didn't help.
Any other place where i can see..?
Thanks and Regards
B S Pradhan
---
On Mon, 19 Jan 2004 Jared Still wrote :
You must set OSAUTH_PREFIX_DOMAIN=true in the registry to
use externally identified domain
Cary,
Good answer. The problem is most people concentrate on bytes because it's
relatively easy and everyone understands it. IOs per sec is much harder to
calculate for a new system and hence it's not normally done.
Cheers,
Chris Dunscombe
Quoting Cary Millsap [EMAIL PROTECTED]:
I don't
- Original Message -
Jonathan, I've been around for a long time. I've seen things like
DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle
Beat ya: Oracle Add-In for Lotus 123.
Using Ora*Net (Async), V4.1.4.
1987. And demoed to the press that same year.
g,dr
PM
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
I think what you've demonstrated is
that pl/sql tables are not limited by
pga-aggregate target, and that a pl/sql
table can grow until it has taken up all
the available memory on your machine.
I'd
Of [EMAIL PROTECTED]
Sent: 20 January 2004 09:19
To: Multiple recipients of list ORACLE-L
Subject: Re: FW: Disk capacity planning
Cary,
Good answer. The problem is most people concentrate on bytes
because it's
relatively easy and everyone understands it. IOs per sec is
much harder
] On
Behalf Of Mark Richard
Sent: 20 January 2004 05:14
To: Multiple recipients of list ORACLE-L
Subject: Re: Spool to Excel File
Hi,
You won't be able to write an Excel format directly but you
can create a .csv file, which Excel will happily read in -
you'll just have
Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os
per second can they perform and they even have tools to measure it. Speaking of
monitoring I/O, there used to be an old OS, which is mostly dead today and it used
to have command monitor io/item=queue which would show
Someone is messing with standard package ... so it would seem.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an
for different Operating Systems, is this true? Is it true with UDB?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2004/01/19 Mon PM 11:04:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle vs Mysql
It needs not to have the same capabilities, it needs to have
Mudhalvan,
I generate files that excel can open all the time. they are not actual
real excel files, but Excel can deal with them quite easily.
Here is a tablespace report I run every week. Note the use of the CHR(9)'s.
This is a TAB character. This forces each column into a new cell in the
Mladen Gogala scribbled on the wall in glitter crayon:
On 2004.01.19 23:39, Jonathan Gennick wrote:
I used to use a SQL Module compiler. Not with Oracle though.
It's rare for me to run into someone else who likes that
approach. Actually, it's rare for me to encounter someone
who's even
Title: RE: MS Access
ACCESS-L. For subscription/signoff info and archives, see
http://peach.ease.lsoft.com/archives/access-l.html .
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: viraj2 [SMTP:[EMAIL PROTECTED
Ahhh.
Sql*Calc, Sql*Graph, Sqr EasySqr. Those were the good old days.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, January 20, 2004 8:05 AM
To: Multiple recipients of list ORACLE-L
Mladen Gogala scribbled on the wall in glitter crayon:
On
I'm going down that path right now. I'll keep you all posted.
hardware: 2.0G, 1G of ram, 40G internal, 2 of those. external 120G
firewire HD.
waiting on the HD to continue, relatively new hardware so had to ditch
the whole RHAS 2.1 and aint willing to pay RH for AS3.
joe
Marcin
@?/rdbms/admin/utlirp
On 01/19/2004 05:00:37 PM, Hamid Alavi wrote:
All,
I have an strange problem, most of the packages under SYS user are
invalid
when I compile it it's compile without error but when I back again
the
package still is invalid, anybody have any idea?
Thanks in advance
Hamid
Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure
I'd trust it that far.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 14, 2004 2:10 PM
To: Multiple recipients of list ORACLE-L
I think he is talking
Oradebug is the right way to go because, for some reason,
alter system set events='904 trace name errorstack forever, level 10';
doesn't do anything. The only way to activate trace is to go to
oradebug,
attach the session (of course, one needs to do gymnastics with V$SESSION
and V$PROCESS to find
Prem, congrats good luck!
On 01/20/2004 12:54:27 AM, Prem Khanna J wrote:
When I was doing my OCP exams, I didn't have Dennis to cheer
me up, only Heineken.Not that I'm complaining.
but Mladen , i can't stop with just one : ))
so i better stay away from it during exams.
Regards,
Prem.
--
AMEN!!
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Monday, January 19, 2004 8:42
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle vs MysqlIf MySQL
comes to have the same
Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make
a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite
COBOL, and could effortlessly have them do DB work. I also didn't have to
hunt thru all the source for a single SQL statement since they were in
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards?
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 8:39 AM
Careful Mladen, your revealing your
The RPT RPF Oracle class was what made me go looking very quickly for a
batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the
current versions of Oracle Reports). We bought it and the rest was history.
Why Oracle didn't buy SQR when they had a chance amazes me.
Tom
401 - 500 of 67344 matches
Mail list logo