I am not sure that I understand what you mean, but check for DBMS_JOB in the 'PL/SQL
supplied packages' manual (or read dbmsjob.sql under $ORACLE_HOME/rdbms/admin).
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 18 Mar
Lets not forget also the benefit of archive log to
allow only restored of a subset of files in the event
of a recovery. In noarchivelog, if you lose one file,
you'll typically need to restore the lot. In
archivelog, you'll typically need to restore just the
one
hth
connor
--- Deshpande,
Thanks
That worked.
Another question re logminer. I notice that must of the values in sql_redo
column are simply :
commit;
set transaction read write;
What does this mean?
John
-Original Message-
From: Lyubomir Petrov [SMTP:[EMAIL PROTECTED]]
Sent: 18 March 2002 17:25
To:
On Monday 18 March 2002 21:33, Stahlke, Mark wrote:
Robert G. Freeman - Oracle8i OCP wrote:
But disk is cheap, right...?
Or is that yet another Urban Legend???
Yes, that's another Urban Legend.
Disk DRIVES are cheap, disk SPACE is not so cheap.
If that were
On advantage with the iTAR is that you CAN precisely define your problem --
you
write in the 15 line problem description yourself not some Analyst who
writes a curt
single line description. You can then keep following up with additonal
details and
questions which certainly get logged as you type
Hi
I am using Oracle 8i SQL and PLSQL exam guide by Jason Couchman
for my preparation of OCP. Is it good or do I need any other Book
(for e.g. Advance PLSQL by Oracle Press OR Exam Cram)
Amol
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nandu Garg
INET:
Hi all,
i have 2 tables software and licence. 1 licence can have many softwares.
softwares
name platform Licence_id
abc NT1
def WIN2K1
ghi all 2
i want to
The 9i doco contains a section called Recovering from
a Backup Created Before a RESETLOGS in the User
Managed Recovery guide.
I haven't tried it :-)
hth
connor
--- Jeremiah Wilton [EMAIL PROTECTED] wrote:
Gopal,
Would you mind posting the procedure for recovering
past resetlogs?
--
My Oracle rep tells me that Oracle Reports is being phased out as a
stand-alone product and will be bundled into 9iAS in the near future, thus
increasing the cost to implement a simple reporting solution.
We're looking for a simple reporting solution and are now a bit reluctant to
go with the
I'd also add a date/time stamp and the Oracle userid of the deleter. Heck,
why not also journal inserts and updates? Or maybe you can get all this
from logminer.
Kevin Lange
Title: Using SQL*LOADER to import UNICODE?
We have an European SQL Server database where it's planned to extract files in UNICODE
with Cyrillic characters and load them into our local UTF8 database.
Is it possible to use SQL*LOADER to load these files?
We are still on 8.1.7.2, and
Logminer shows a large number of entries in redo logs for SYS as follows :
What generates these?
select timestamp,username, sql_redo from v$logmnr_contents
--
03-19-2002:12:31:24 SYS
03-19-2002:12:31:24 SYS
commit;
03-19-2002:12:31:27 SYS
set
You could use a user function. For example,
create or replace function lic_format (id in number) return varchar2
as
tmp varchar2(4000);
hold_tmp varchar2(50);
cursor c1 is
select name from software
where license_id = id;
begin
open c1;
loop
fetch c1 into hold_tmp;
exit when c1%notfound;
tmp :=
One possible way would be to have your package make
calls to dbms_application_info.set_client_info. The
other session could then read v$session to see who is
running it.
hth
connor
--- [EMAIL PROTECTED] wrote:
Hi
I am having one package which I have created.
If I an executing that
I have yet to log an iTar and not have an Analyst phone me. Much to my
annoyance actually. My first form of contact is e-mail. However, they have
this ability to determine when I step away from my desk and then phone
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, March 19,
Title: Standby Database Problem
Hussain,
As long as none of your datafiles were corrupted by
what I assume was the crash of your Standby Instance, you can reinstall 8i and
bring up the Standby just as you describe. The datafiles don't care at all
where Oracle Home is.
Irecently had to
In reality they cannot. Because the internal optimizer uses Rule
occasionally, they must either remove this code from the kernel or perform a
complete rewrite.
In addition, Oracle, and its VARs, have several thousand tools that utilize
rule based, for cost based is not as stable.
Thank You
Hello John
Since all values starting with 'V' are lower then 'W' they will be inserted
into partition p1. (tested it).
I did some tests but could not find a way to do what you want.
Maybe a composite partitioning with 4 hash subpartitions
will get you some results.
Yechiel Adar, Mehish
I beg to differ.
Each disk cost the disk price + 1/24 of the infrastructure costs.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Stahlke, Mark [SMTP:[EMAIL PROTECTED]]
Sent: Mon, March 18, 2002 10:33 PM
To: Multiple recipients of list ORACLE-L
Hi,
Is there a way to write a procedure to return multiple rows? I have some
nasty SQL that I'd like to convert to run server-side, but how do you spit
out multiple rows from PL/SQL?
thx
Bill Magaliff
Framework, Inc.
914-631-2322
--
Please see the official ORACLE-L FAQ:
Here is the latest on the Oracle hangs issue from the DBA working it...
--
In 8.1.7.2 we had frequent crashes, and Oracle told us to upgrade to 8.1.7.3
to solve that. The crashes then turned into these hangs. The problem is
our hangs
Waleed, have you tried this yourself in 9i? I have. And I have the logs to
prove it. The only difference between the two database creates was that one
was connected as / while the other was sys, each while executing
catalog, catproc, and catexp immediately following a CREATE DATABASE . If
you
Wouldn't it be cheaper just to replace each drive with a bigger one rather
than buying all of the infrastructure related stuff? If you replace 8gb
drives with 80gb drives you just saved 9 cabinets.
-Original Message-
Sent: Tuesday, March 19, 2002 9:08 AM
To: Multiple recipients of list
Dear gurus !
I've done some RTFM but have not found any answer to this:
i want to limit the number of open sessions to some number (let's say 1000).
I want the next coming connections (after 1000) to be queued on the
dispatcher until one of the previous sessions drops/disconnects.
Is it possible
Ayyappan,
You can use the procedures in DBMS_APPLICATION_INFO to publish and
interrogate the states and actions of modules.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL
Sun is currently charging us $10,000 a year in maintenance fees just for our
disk drives.
And that's just on 1 system. We have 2 others just like it . . .
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, March 19, 2002
Wouldn't it be great to build Oracle Web Enabled Applications directly in
your browser with minimal skills??? Check out ORBIT, a web application
development suite created by Runner Technologies. It is the most flexible and
easiest way to build full featured web applications and reports. Sign
We say that disk is cheap, but that is a relative term. Yes an individual drive
may be inexpensive, but if your using anykind or raid or mirroring (as we are)
then each GB of space is twice as expensive as the individual part because you
need two drives. Also, don't forget the cost of backing
Confidential sources have revealed me that Oracle will stop supporting RBO
as
of Oracle 18i.
-Original Message-
From: Karniotis, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: is Oracle really planning
Bill,
A PL/SQL Table of MyTable%RowType can be returned from a function or as an
Out Argument from a procedure.
A Ref Cursor (Cursor Variable) can also be returned as an Out Argument from
a procedure.
See the PL/SQL Users Guide and Reference for info. on these.
Jack
Yea, Right
On a dba salary??
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: bill thater [SMTP:[EMAIL PROTECTED]]
Sent: Mon, March 18, 2002 9:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Fav. Urban Legend...
nope he
Write a PL/SQL function which takes the licence_id as argument and returns a
varchar2(... what you deem sufficient, up to 32K).
In the function, loop on the appropriate table and concatenate.
When you run
select licence_id, my_ugly_func(licence_id) softwares
from ...
you more or less
9i Release 2 has a newer setting
_MAKE_SQL_RUN_FASTER=
0 to 100
unlimited
Ludicrous speed
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
There are many things you can do to diagnose a system that is totally
unresponsive.
You should spool output from v$session_wait joined to v$session every
minute so that you have a record of what people started getting hung
up on leading up to the hang. This might allow you to trigger a
Hello Ian
1) We control our databases to such extent that the users have only
select, update, delete and insert permissions
on the tables. All DDL is run by the DBA stuff.
We implemented this policy after some tables were dropped due to the
use of tools that did
I personally prefer the Exam Cram series and the Sybex OCP series.
* disclaimer * I write for both companies... :-)
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take
When trying to select * from
DBA_FREE_SPACE_COALESCED the query hangs. It also hangs when
trying to calculate free space from the DBA_FREE_SPACE view. I looked in
the sys.fet$ table and found that the TEMP tablespace has 21423 entries
and I believe this is my problem.
Now for my questions.
With some of the 9i new features available with 9i, perhaps ARCHIVELOG
is the way to go for the most part. Being able to recover a corrupted
block, while the datafile is still ONLINE and available well,
does kind of cut down on your downtime a bit, doesn't it? :-)
Same thing with running
D'oh! (quickly and quietly running away as the bombs and nukes come flying
in)
-Original Message-
Sent: Tuesday, March 19, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
Wouldn't it be cheaper just to replace each drive with a bigger one rather
than buying all of the
Jared? Can you please go beat up these spammers?
--- Runner Technologies Human Resources [EMAIL PROTECTED]
wrote:
Wouldn't it be great to build Oracle Web Enabled Applications
directly in
your browser with minimal skills???
Check out ORBIT, a web application development suite created by
This may help you :
http://www.oracle.com/oramag/webcolumns/2001/index.html?diy_dynamic.html
That said, sending horrors to the server is not solving the problem, just fudging it,
and bringing the server to its knees will not make the global througput better. I'd
try to make the SQL less nasty
This is the statisticians way of looking at it, not the purchasing agents.
:-))
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
[EMAIL PROTECTED] wrote:
Wouldn't it be great to build Oracle Web Enabled Applications directly
in your browser with minimal skills???
Check out ORBIT, a web application development suite created by Runner
Technologies. It is the most flexible and easiest way to build full
featured web
Interesting... I have 9i installed on a laptop with 64 megs... :-)
Virtual memory does wonders! :-)
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away
Yechiel Adar, Mehish Computer Services wrote:
I beg to differ.
Each disk cost the disk price + 1/24 of the infrastructure costs.
You are correct, of course.
My point is that the infrastructure cost is much higher than the cost of the
disk drives alone. The last disk array I
Thats that Java APP that loads the first time you sign into Metalink.
It uses your monitor as a camera and they can watch you whenever they
want.
Big brother Larry is out there.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette
I've heard the disk vs. memory arguments before, but never have seen
quantifiable data either way... if anyone has any, I'd love to see it.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a
We were just reminiscing today about how PCs used to have a Turbo button.
I recall the non-turbo was for 8008 compatibility for some early programs.
One of the users suggested that we push the turbo button on the server.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Use Ref Cursor (reference cursor) as a parameter in stored procedure.
Sorry, don't have handy sample code, but you can lookup one in any PL/SQL
book or docs.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
The procedure in the 9i docs is limited, and does not include recovery
of a whole database, or any read/write datafiles up to and past
resetlogs.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 19 Mar 2002, [iso-8859-1] Connor McDonald wrote:
The 9i doco contains a section called
There is a good chance that as the data increases in
size, so does the IO bandwidth requirements. Larger
disks may not be the answer.
hth
connor
--- Jenkins, Michael - EDS
[EMAIL PROTECTED] wrote: Wouldn't it be
cheaper just to replace each drive
with a bigger one rather
than buying all of
I've seen some hacks in the past involving dropping
all segments for that tspace, direct deletes from fet$
and then dropping the tablespace...
Not for the faint hearted, certainly not supported and
you never heard it from me :-)
Cheers
Connor
--- Casey A. Jordan [EMAIL PROTECTED] wrote:
When
True story (I kid you not)...
Guy at (previous site) work was running the worst
SQL's in the world and then comes steaming in on
regular occasions with There is a problem with the
server, to which our obvious reply used to maybe its
the 37 table join you've written...
After this had no effect,
Depends on your equipment. If you are dealing with something like Symetrix, you would need to do a 3 for 1 replacement. (Master, Mirror, BCV). And size could be an issue depending on your microcode level of the equipment. We had to do a microcode update prior to going to the 180G drives.
On
Lots of examples avlbl from Concepts manual; also pl check asktom.com
Step 1) Declare a ref cursor inside a package
CREATE PACKAGE APACK AS
TYPE RefCurTyp IS REF CURSOR;
END APACK;
Step 2) Employ the ref curosr IN OUT variable inside the procedure..note
that the cursor is opened but not
Most of the transactions in the redo log are written
in this way:
SQL_REDO
set transaction read write;
insert/update/delete something
commit;
'set transaction read write' is the default setting
for a transaction and that's why it's there, I quess.
Commit is self explaining.
The
For about 10 years in Unix environments, I've been using the ballpark math
of $1.00 per megabyte of data for TCO (Total Cost of Ownership) and it has
served me very well. Disk drives have gotten bigger and cheaper per say,
but we continue to advance the overall technology in ways that keep the
Not me, yet.
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Tuesday, March 19, 2002 11:39 AM
To:
No kidding ??? How much virtual memory do you have set ???
Every time I tried to install 9i, it would get to the database cloning part
and bomb completely.
Cheers,
JoJo
-Original Message-
Robert
Sent: Tuesday, March 19, 2002 8:29 AM
To: Multiple recipients of list ORACLE-L
Change the hidden init.ora parameter in all of your databases as follows:
_MONITOR_DBAS_CHAIR=FALSE
[EMAIL PROTECTED] 03/19/02 08:58AM
I have yet to log an iTar and not have an Analyst phone me. Much to my
annoyance actually. My first form of contact is e-mail. However, they have
this
I have ALOT of VM setup...
Looking.. at... my ... laptop... configuration...
I currently have 143MB of virtual memory allocated. I think I have
actually reduced that from 256MB when I did the install.
Hint #2, do not allow the installer to create the database for you.
that adds significantly
Hello:
I have an identical query that has similar explain plan on both Prod and Dev
environment, only difference being that certain indexes are performing
unique scan on Prod and Range scan on Dev.
Can you cast some light on how this can be matched and under what conditions
this discrepancy
Yup, Filed it in the round file with the rest of the SPAM. Now if you'll
excuse me, I'm off again to get a new keyboard. Wore out my delete key! :-)
Dick Goulet
Reply Separator
Author: Grabowy; Chris [EMAIL PROTECTED]
Date: 3/19/2002 8:38 AM
Did
Acutally, I was hoping we all could send them a polite email
[EMAIL PROTECTED]
I was going to mention how I would make sure their products do not make the
short list for all my clients. How they must have crappy products since
they lowered themselves to SPAMing, or their sales people don't
Stephen,
I think they are fishing for money too. However, they did tell me that they
plan to phase out the IDS as a separate product.
David,
Sorry for taking over your thread here - I hope you still get the
information you are looking for.
Ron Morton
-Original Message-
From:
One of the application users has been complaining that someone keeps
dropping one of his tables. He imports it back, and after a few hours, its
gone again. I tried to turn on auditing for this table when its dropped. I
thought this was possible but looks like its not. I turned on full auditing
No,
but thanks to your quoting it, we are all much happier now.
-Original Message-From: Grabowy, Chris
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 19, 2002 11:39
AMTo: Multiple recipients of list ORACLE-LSubject:
SPAM?? RE: Looking for a Web Application Development
I can smell the rubber now.
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Tuesday, March 19, 2002
What OS are you talking about?
Because, if it's Windows, then 64K is hardly enough to run just OS, and you
are to blame Oracle (not that there is nothing to blame it for).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
4 3 2. 1..
I have not written the books in the series that was being asked about. I
wrote upgrade exam books, I wrote general DBA books, but not the OCP books
that were being asked about. I don't shill for anyone, I don't get a dime
from them for mentioning their name. I don't
--
Daniþment Gazi Ünal
http://www.unal-bilisim.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal (Unal Bilisim)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Ron:
That's quite surprising. Oracle, to its partners, is telling a very
different story. Stay tuned for the As The Oracle Turns
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:
Nope, about a 1 hour install or so.
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Tuesday, March 19, 2002
Been there... Done that. After we estimated coalescing free space would
take 10 hours.
drop all the objects in the tablespace
delete from fet$ for that tablespace
add a single row in fet$ for the entire tablespace
drop the tablespace (reduced from 10 hours to couple of seconds).
recreate the
Now'a'days you have to go into the SETUP during boot and set 'RUN SYSTEM
FASTER' in the CMOS.
DENNIS
CHAN Chor Ling Catherine (CSC) wrote:
Hi,
Pardon me if I am wrong, I thought the only reason for the database to be in
archive log mode is so that I can recover the database up to the time when
the database crushes.
You are right except for ONLY. Another reason is the desire to take
Doesn't creative striping solve this problem to some extent?
-Original Message-
Sent: Tuesday, March 19, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L
This highlights problems with those larger drives... DBA's want more,
smaller drives in order to spread I/O and reduce
Robert,
I currently have Windows automatically setting my VM, and my settings show
currently 1,825 MB. So I don't get why this isn't working.
How do I tell the installer not to create the DB for me?
Thanks in advance,
JoJo
-Original Message-
Robert
Sent: Tuesday, March 19, 2002
Raj,
From Metalink:
The PRODUCT_USER_PROFILE table will only allow you to enable or disable certain
sql*plus commands (Not logins). Connect is one such command.
For example, the command.
INSERT INTO PRODUCT_USER_PROFILE(product, userid, attribute, char_value)
Um, you are not really differing with him. He just
said that disks are cheap.
-Original Message-
Sent: Tuesday, March 19, 2002 6:08 AM
To: Multiple recipients of list ORACLE-L
I beg to differ.
Each disk cost the disk price + 1/24 of the infrastructure costs.
Yechiel Adar, Mehish
Forwading an email from a fellow DBA, for your assistance.
hi,
I have a situation over here. Here the environment:
We have a database on hp cluster and the cluster package is not monitoring
the database. Their contention is that if the database goes down due to any
reason the dba should take a
What about the ability to be able to do point in time recovery?
What about the ability to be able to make a copy of a database without
having
to shut it down?
What about the ability to recover specific datafiles without having to
shutdown the entire database.
What about the ability to recover
Robert,
Well put.
I still have and use the documentation that came automatically with
Oracle 7 rel7.1. Printed word especially in the older oracle versions
was easier to understand and you were able to find the answer you
needed. Have you tried to look up the command format for the ALTER
How do I turn this auditing on? Something like 'Audit drop on
scott.emp'.
Is it possible? I am thinking, not. There are hundreds of users in the
database, and I dont wish to turn full auditing on for all
these users.
How about 'AUDIT DELETE ANY TABLE BY ACCESS WHENEVER SUCCESSFUL;'?? This
Thanks Doug. But doesn't the product_user_profile only work for connections
using SQL*Plus? Anyway, they figured out it was a temporary table, which
was dropped and recreated by a batch job being run daily.
But I just figured out there's no way to audit drop and truncate statements
executed
I
think we all need to send it back to [EMAIL PROTECTED] (that is
where it came from). I sent mine there. If they overloading my
mailbox with junk, I'll do the same to their.
-Original Message-From: Grabowy, Chris
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 19, 2002 2:39
JoJo,
You choose Custom install, and when it asks, if you want starter db,
say - no.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 19, 2002 2:58 PM
Robert,
I currently have Windows
I am running a current Debian v2.3 on kernel v2.4.18 on a Compaq6400r. I
cannot for the life of me get Oracle9i to install.
This is a minimal install - just waiting for oracle I just must be missing
something. I have it nearly automated and have tried many different
solutions - v2.2 and v2.3
This is true for all new features from 7.1 and onwards. Apps 11i has
been CBO'ed, so when recursive SQL statements are also CBO'ed I would
assume there's only the rest of the world and their applications to
worry about ;-).
Mogens
Boivin, Patrice J wrote:
All I know is that the RBO doesn't
Installer asks if you want it to create a database for you if you take
the custom install option So, take the custom install option,
answer NO to the do you want me to install/create a database for you
prompt and away you go.
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX
GUnal,
Just wondering if you have posted the DRPP paper in
your site after the seminor as you said..:)
Cheers,
RS
--- Danisment Gazi Unal (Unal Bilisim)
[EMAIL PROTECTED] wrote:
--
Daniþment Gazi Ünal
http://www.unal-bilisim.com
--
Please see the official ORACLE-L FAQ:
We decided to do from Java since the server site could
be in any worldwide location. IT's not likely that
Oracle 8i can achieve this goal or it's too complete
to accomplish this goal.
Thanks for listening.
Steven
--- Steven Joshua [EMAIL PROTECTED] wrote:
Hello, All:
In Oracle 8i, How can
And
when at it, attach all of your tempfiles to the message.
-Original Message-From: Lyuda Hoska
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 19, 2002 3:24
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SPAM?? RE: Looking for a Web Application Development
Hi,
But you can probably do it with Logminer.
Beth
-Original Message-
Sent: Tuesday, March 19, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L
Thanks Doug. But doesn't the product_user_profile only work for
connections using SQL*Plus? Anyway, they figured out it was a
The memory vs. disk speed argument most likely stems from hardware access times.
Memory is rated in nanoseconds (10E-9), and disk access times are in milliseconds
(10E-6). Hence, memory is rated at 1000 times faster than disk (if these ratings are
accurate...).
Alan
Alan Aschenbrenner
I think your keyboard is stuck.. ;-)
-- Original Message --
Reply-To: [EMAIL PROTECTED]
Date: Tue, 19 Mar 2002 11:28:57 -0800
--
Daniþment Gazi Ünal
http://www.unal-bilisim.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Thanks Igor -- I may try again (this way) and see what happens.
By the way, I'm running Win98 and was attempting to install 9i Personal
Edition, which is supposed to run on Win98. If I get desperate enough, I
could install it on one of our dev servers (NT or Win2K), but I really
wanted it right
Start DBCA separately?!? Whatever happened to the good ol' CREATE
DATABASE?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, March 19, 2002 12:39 PM
To: Multiple
I have not heard Oracle is planning to desupport Oracle!
-Original Message-
Sent: Monday, March 18, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L
Has anyone heard anthing official or semi-official on this?
Bill Magaliff
Framework, Inc.
914-631-2322
--
Please see the
[EMAIL PROTECTED] wrote:
Hello:
I have an identical query that has similar explain plan on both Prod and Dev
environment, only difference being that certain indexes are performing
unique scan on Prod and Range scan on Dev.
Can you cast some light on how this can be matched and under what
1 - 100 of 123 matches
Mail list logo