Ooops. Was rather late (or rather early) when I sent this. Obviously the ascending
CONNECT BY subquery should not be in the WHERE clause but in the descending CONNECT BY
to stop recursion.
- Original Message -
From: Orr, Steve [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Dear List,
I need some inputs from you all regarding purging data from the database.
This is the requirement
We define a retention period for all the data in the system.
When the retention period is reached, the data should be deleted, but then at a later time, some user might request for
I started to tell you that there were no arch trace file, but got a call,
while writing this mail (1.5 hours ago), that the system stuck again. This
time we put :alter system set archive_log_trace=32; so we have trace. The
trace file for the arch process that stuck is:
Tue Nov 05 14:21:36 2002
Directly from TFM
Notes on Hierarchical Queries:
If you specify a hierarchical query and also specify the ORDER BY clause,
the ORDER BY clause takes precedence over any ordering specified by the
hierarchical query, unless you specify the SIBLINGS keyword in the ORDER BY
clause.
The manner
First rule: Do not mix OLTP and datamart.
Datamart access is very heavy and complex SQL's that will impact your OLTP
system.
I think that an NT with 2-4 CPUs and a lot of memory will do (a not so
educated guess).
Controller with a lot of cache memory and fast disks (15,000 rpm).
Yechiel Adar
Prem,
I
would re-visit the requirement. Why do you feel the need to delete the
data from the database? What is the purpose for this type of
requirement? It would be far easier to modify the requirement than to do
what you are thinking of doing.
Adding
columns to database tables
This is adata-archival requirement, not a
data-purge requirement. It only resembles a purge requirement based on the
multiple-database-migration strategy you outlined. There are
alternatives...
Depending on the volume of data in your database
and your availability requirements,
Title: RE: OCP Exams - What to study out of?
But I did. All I did was study the Corioulus book - and took the exams.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 05, 2002 4:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP
Tim,
my
problem with moving data to tape is as follows:
Your
one strategy involved moving read-only tablespaces to tape. what if you
upgrade Oracle versions. will these read-only files still be valid?
will they still be able to be put back on-line, or will they need to be
converted along
Yechiel Adar,
Use standby database, and you won't lost any transaction if your
online redo log is there.
To add a datafile, just add it in the standby database , no need to
rebuild the standby database.
Global name have nothing to do with standby,
Title: RE: OCP Exams - What to study out of?
Unfortunately there are no Corioulus books for
9i.
Ken
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 06, 2002 8:08
AM
Subject: RE: OCP Exams - What
If you are an Oracle DBA With SAP experience looking for a stable company
where you can work within a great team environment, this company in Toledo,
Ohio
is the place for you. This Fortune 500 employer has experienced steady
growth over
the hundred years it has been in business and is looking
Title: RE: OCP Exams - What to study out of?
Just the first one. That is the only one I have tried. I have the second one Nov. 12th. I am spacing them out a little because I have football games to go to, holidays, elderly parents, etc. I will let you know the gory details if you wish. My
A
poor man's solution might be to load the offline database with appropriate
data, then do a tablespace export and store the results on CD labelled by
date. Restoring needed data would entail a tablespace import of stuff
from the appropriate CD into the offline DB. I'm sure
Hello Gurus,
This morning our database locked us out with the error code ORA-01089.
Circumstances surrounding this occurrence were that a cold backup by
Tivoli is taken performed every night at 4AM.
When I spoke with our senior DBA, he confirmed that the database never
shutdown properly before
I have given up on trying to find document detailing differences between
Oracle 9i (9.2.0) EE and SE.
Can someone provide a link,etc for this?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
- If you ever hope to re-use the data you archive off-line, you must also
archive all the related tables, because after all, this is a RELATIONAL
database.
- PrincetonSoftech has a product
Come on folks...Help me, I am stuck...
I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global Name (say ORCL) - Data
Management - Export ...
and it comes
In response to a post on data purging Tim Gorman wrote some on SAN-based
disk, some on NAS-based storage.
Can someone please explain the differences between these technologies
please.
My understanding that a SAN is a group of disks which are available on a
network and are not 'owned' by a
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)
John
-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L
Prem - You are receiving some excellent advice
Hi Steve,
You can get the below query to work in 8.1.7 (not sure about previous
versions) by setting the undoc parameter _new_connect_by_enabled = true
and can be set for a session
SELECT *
FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder)
START WITH parentid=0
CONNECT BY PRIOR ID =
Grace - Amen to Yechiel's first rule. At the VERY least, warn your
management that they need to consider a second system for the datamart. This
way, if it works terribly, you don't look dumb.
My experience is mainly Unix, so 200 OLTP users on an NT box sounds iffy
from a throughput point of
Hey, thanks for mentioning that, I'll have to mind my manners. I really
don't have a connection to that vendor, just attended a demo.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 06, 2002 9:56 AM
To: Multiple recipients of
could u check please the user rigths on disk place he needs?
colud u please check the ramaing free space of any directory needded to
oracle and its backup?
i supose the problem is in one of those steeps
regards
paulo
-Original Message-
Sent: quarta-feira, 6 de Novembro de 2002 14:59
To:
Hi,
I remember that replication isn't really covered in Robert's book.
The way I did this was to step through the candidate guide and compare it to
the index of the New Features book to see what was missing.
Regards,
Mike Hately
-Original Message-
Sent: Wednesday, November 06, 2002
Title: RE: Oracle DBA with SAP Needed
What does Base Salary is 55K-to maybe high 60s Firm. mean? You can
throw the possibility of a raise out the window? =)
-Original Message-
From: OraStaff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 9:49 AM
To: Multiple
Just bought Oracle Press 9i New Features by the illustrious Robert Freeman.
Seems good and I have also seen another Oracle Press Book 9i New Features
Exam Guide by Daniel Benjamin. This follows the Corioulus format of a
chapter and questions and a big test at the end.
The worrying thing about
Do you have Enterprise manager running?
That may hang up a shutdown immediate as well.
Shut down agent first and then the database.
Everything ok.?
He felt gutsy and decided ORACLE was robust enough to handle the abort.
Maybe he checked the previous backup was alright and that archives were
Someone asked about this 3 weeks ago. Here's my take
on archiving data. I don't expect everyone to agree with this,
but nonetheless, I have an opinion. :)
Here's an email from last month. You can undoubtedly find
some other ideas on this by searching the archives of this
list at fatcity.com
In many cases the exams extract exact sentences from
the Oracle Uinversity manuals for their correct
answers.
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Eva - Everything I've heard says that all the exam
questions come out of the
Oracle University class Student Guides. To put it
bluntly,
Oracle 8i
How can I tell if MTS is activated?
Which parameters should I look at? (in init.ora and
listener.ora)
thanks
Pablo
___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis!
Descárgalo ya desde
http://otn.oracle.com/products/oracle9i/pdf/9idb_rel2_prod_fam.pdf
At the end of the paper is a matrix that compares feature-by-feature.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 06, 2002 8:49 AM
To: Multiple
Title: AW: Differences between Oracle 9.2.0 EE and SE
Rick,
there is a note on Metalink that gives you all the differences: 112591.1
But it only covers releases up to 8i. 9i should be somewhat similar (of course stuff like RAC only works with EE). As far as I know, there is no
u need to set the system operating credentials for the node u are using with
a acount that has at least logon as a batch job directly assigned to it.
Noramally it would administrator/Password
regards
Paulo
-Original Message-
Sent: quarta-feira, 6 de Novembro de 2002 15:04
To: Multiple
Have anyone heard about Oracle Forms going away with Oracle 9.0.1.4?
I was in a technical meeting with Retek (a retail application), and they presenter said that. I did not see anything on the metalink site relating to that information.
If Forms is going away, what will replace it?
Thanks in
Hey all,
I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles. My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the working
Title: RE: OCP Exams - What to study out of?
I took
8i - am taking 8i because I am hoping that then I can just take an upgrade exam
for 9i without the $1,000+ course requirement. I believe that is still the
case. Please tell me if I am wrong.
-Original Message-From: KENNETH
Don't know the exact circumstances but the following note from Metalink
(1014091.102) may be appropriate
However the best way to learn anything is to ask the senior DBA what he
meant. An explanation from him may include looking at the alert log and the
scripts that were used. That is more than
LOL! Thanks John! ;)
As a matter of fact.. ;P
I do actually know of another tool that does just this, it's called
Checkmate from a company called BitByBit http://www.bitbybit.co.uk (which I
have just checked and it now seems they have been acquired by OuterBay!)..
We actually used to promote
To see how many dispatchers/shared servers are started up with the RDBMS, check the
value of 'mts_dispatchers' and 'mts_servers' in the init.ora.
You can also tell by looking in the alert.log(default location is
$ORACLE_HOME/rdbms/log).
Sample:
PMON started
DBWR started
LGWR started
RECO
A couple of things come to mind...
1. Set credentials for the node ORATEST, usually the user you installed
oracle with on the node.
2. Set credentials for the database to be a user with DBA privileges,
possibly even create a specific user to act as the primary user that you
will do this and other
Sysman is not a user on the database. Set preferered
credentials to someone who has sysdba privs or export full database, import full
database privs.
Ruth
- Original Message -
From:
Arif Khan
(GWL)
To: Multiple recipients of list ORACLE-L
Sent: Wednesday,
unfortunatly i don't work with SAP or i would be interessed
regards
Paulo
-Original Message-
Sent: quarta-feira, 6 de Novembro de 2002 14:49
To: Multiple recipients of list ORACLE-L
If you are an Oracle DBA With SAP experience looking for a stable company
where you can work within a
The list of 9i options can be found at:
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt
ions.html
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 4:49 PM
I have given up
If I remember correctly ( a big if) there is an option in the OEM menus to
set the preferred credentials.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:04 PM
Come on folks...Help me, I am
Well with the ridiculous salary they are offering, they could at least train you in
the use of SAP. This is a Fortune 500 company after all.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 11/6/2002 10:56 AM, Paulo Gomes [EMAIL PROTECTED] wrote:
unfortunatly i don't work with SAP or i
JDeveloper
Reply Separator
Author: Gillian [EMAIL PROTECTED]
Date: 11/6/2002 9:18 AM
Have anyone heard about Oracle Forms going away with Oracle 9.0.1.4?
I was in a technical meeting with Retek (a retail application), and they
presenter said that.
Rich,
I have a better set of steps for you:
1). Create a new tablespace (TEMPLMT) and make it a LMT.
2). One by one, issue ALTER USER {username} TEMPORARY TABLESPACE TEMPLMT;
3). Bounce the database
4). DROP TABLESPACE TEMP INCLUDING CONTENTS;
5). Backup the database
6). Let users at it.
Rich,
If you've got the disk space, do it while the DB is up. Much simpler.
Create a new Temporary LMT - call it NewTemp - with the appropriate
tempfiles.
Switch everyone to NewTemp by spooling and executing this and running the
spooled file:
Select 'Alter User ' || UserName || ' Temporary
Title: Oracle to Excel
I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet. We now have a need for this. Could anyone enlighten me?
Thank you in advance.
Laura
That reminds me:
Mark, your annual stipend is due.
Make it a case of Glenmorangie this time, Sherry finish. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Title: Oracle to Excel
Without extra software the easiest way is to setup a delimited file in a
sql statement and spool output to a file. Then import the file into a
spreadsheet.
If you
have it, Toad will save data into spreadsheets for you.
-Original Message-From: Burton, Laura
And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new features class to use up
some education money that was expiring. The Oracle instructor, John Hibbard,
is superb. He makes the class very entertaining and he has done a lot of
I doubt they can fill this position at that salary.
Oracle DBA's that work with SAP can easily earn much more than that.
Jared
Markham, Richard [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list
Title: Oracle to Excel
I usually spool my queries to a .txt (ascii) file and import into Excel.
Easiest way for me. Im sure there are other
more sophisticated solutions out there.
Regards,
Saira
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf
Title: Oracle to Excel
Laura,
lots
of tools do this for you automatically. Oracle discoverer will export the
results of a query directly into Excel format.
You
can do this yourself as follows:
in
SqlPLus
select
col1||chr(10)||col2||chr(10)
from
table.
the
chr(10) is the tab
I'm seeing some very strange results using _new_connect_by_enabled = true
Login to the database, run these 2 commands:
alter session set _new_connect_by_enabled = true;
1 SELECT *
2 FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder)
3 START WITH parentid=0
4 CONNECT BY
If have the space, create the new TEMP tablespace first, alter all users
that have the old one to now use the new one, drop the old tablespace.
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple
Makes sense if...
Base Salary is 155K-to maybe high 160s Firm.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 2:12 PM
I doubt they can fill this position at that salary.
Oracle DBA's that work with SAP can easily earn
Dave,
I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.
Here's my configuration:
mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))
mts_service = PRUE1
mts_dispatchers = tcp,2
Title: Oracle to Excel
Is there a reason why you can't just extract it directly in to Excel using ODBC or Oracle Objects for OLE? ODBC would be the easiest, OO4OLE will give you the most control and better macro scripting for auto updating. Both of these come with the Oracle client install.
If you can live with dumping to a comma delimited file, just do that
and import to Excel.
If you want to write directly to an Excel format, you could do that
with Perl. Have any Perl programmers around?
Here's an example of one. Not really too much code.
Jared
The fact that the job's in or near Toledo might have something to do with
the salary. I doubt the cost of living is that high around there.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday, November 06, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
I doubt
Hello Guys,
i have posted this in Oracle apps mailing list also.
We have a situation here. We have an Open Period for Oct defined as 01/oct/02 to
30/oct/02.
We posted AP with no problems. While importing the sales from a different
application(non-oracle) into GL we received errors in the
You need to set the credentials for the node. If you are doing an export
on the node, OEM must be able to log into the node. As good practice, you
should create a valid userid and password for each node listed by OEM. OEM
cannot run a job on a node without having a userid to log onto the node
Port finish is better :)
--- [EMAIL PROTECTED] wrote:
That reminds me:
Mark, your annual stipend is due.
Make it a case of Glenmorangie this time, Sherry finish. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
Walt - I'm surprised to hear that from somebody in Montana. I would have
expected you to say really expensive to live in the big city, pay for food
rather than just kill your own, rent a house rather than just cut down some
trees and make your own cabin, buy gas instead of ride your horse. Or
Title: Oracle to Excel
Brain
freeze thats the only reason I did not think of it doh
!
-Original Message-From: Rodd Holman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002
1:39 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Oracle to ExcelIs
List,
Would you please explain to me how you are able to get TEMP and LMT
combined together. I use 8.1.7 and it is not allowed.
Oracle8i DBA Handbook Loney and Theriault, Osborne Oracle Press, Page
598 NOTE
If you specify Local in a create tablespace command, you can not
specify a default storage
Title: RE: Oracle DBA with SAP Needed
It's Toledo. That ought to automatically
double the salary.
Saturday night in Toledo Ohio is like being nowhere at all
All through the day, how the hours rush by
you visit the park and you watch the grass die.
- John Denver
Matt Adams - GE
So you took and passed the upgrade exam already?
Brian
-Original Message-
Sent: Wednesday, November 06, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new
An administrative requirement causes a lot of these types of postings
with odd-looking salary ranges. Chances are that the company already has
a foreign national candidate in the hiring pipeline for the job at this
salary. INS requires that US citizens be given a fair shot at the job
posting. One
What does your TNSNAMES.ORA file look like? If there is a line in there
'(server=dedicated)' you might as well turn MTS off.
Dick Goulet
Reply Separator
Author: =?iso-8859-1?q?Pablo=20Rodriguez?= [EMAIL PROTECTED]
Date: 11/6/2002 11:39 AM
Dave,
Yeah, from the List, this method seems to be preferred. My only problem is
in step 7 -- change a to several. This could require more testing,
however. I imagine I'll be trying to ATLER TABLESPAVE TMEP afterwards...
Thx all! :)
Rich Jesse System/Database
Title: Oracle to Excel
Thank you for your response Tom. I received other responses as well, and
I know that I can comma delimit a .txt file but I wanted to know if I could do
it all at one time, which is why I tried your suggestion first. It works except that each field is in a
separate
Cary - I think you have a good insight. I've encountered that before. Often
that is the reason for some strange employment advertisements in national
magazines. As you say, posting on ORACLE-L may meet the requirement, is
free, and is fast (no need to wait months for the publication date).
Dennis
No (sigh), I just took the class, so now I've got to get the energy to take
the test.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 06, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
So you took and passed the
Laura,
Check out Tom Kyte's site. He has posted the source code for a PL/SQL
package called OWA_SYLK that will dump a SQL query to a *.SLK file (*.SLK
files can be directly opened by Excel). Plug in the SQL and then go... send
the output file to the user and they do the rest.
Here is the link:
On Wed, Nov 06, 2002 at 11:39:06AM -0800, Pablo Rodriguez wrote:
Dave,
I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.
Here's my configuration:
mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78)
Yeah, but is smacks of being unethical and un-American.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 11/6/2002 1:08 PM
Cary - I think you have a good insight. I've encountered that before. Often
that is the reason for
create temporary tablespace temp2
tempfile '/u01/oradata/dv01/temp2.dbf' size 10m
extent management local uniform size 128k;
HTH
Jared
Ron Rogers [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 12:10 PM
Please respond to ORACLE-L
To: Multiple recipients of
Pablo,
init.ora -- Look at the dispatchers=... parameter (You can comment it
out if you don't want MTS)
listener.ora -- Look for (SERVER = DEDICATED) vs. (SERVER = SHARED)
In SQLPLUS -- SQL SELECT servers_started FROM v$mts;
-Scott Stefick
-Original Message-
Sent: Wednesday,
In other words smart buisness sense
-Original Message-
Sent: Wednesday, November 06, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L
Yeah, but is smacks of being unethical and un-American.
Dick Goulet
Reply Separator
Author:
Another place to look is how connections are made to the database.
Do you know if the connections are bypassing the tnsnames.ora altogether and
using their own connect string wherein they could be specifying a dedicated
server?
First thing to determine is whether connections are in fact using
Sherry Finish? I thought you liked scotch that tasted like burnt mud?
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L
That reminds me:
Mark, your annual stipend is due.
Make it a case of Glenmorangie this time,
Things seem a little slow on the list ( like I need more email :)
Some choice bits from Dr Dobbs Journal, November 1988.
Some you may actually have been working in IT then. ;)
Jared
-
If a single word sums up the current state of
Agreed. The current Oracle datafile format
(7.3, 8.0, 8.1, 9.0, or 9.2) may not survive 10i -- who the heck
know?
However, the tape-based file-systems (i.e. SAMFS,
Legato DiskExtender, etc) can be treated like a file-system in all respects
(only slower). In other words, convert the
Tim,
I missed the part earlier where you mentioned HSM. Though somewhat
familiar with it, I've never used it. Pretty common in mainframe
environments.
Do you have experience with it? Drawbacks other than performance?
This seems like a much better solution to me than archiving onto tape and
Sorry, forgot to reply-all...
- Original Message -
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 4:51 PM
The SAMFS and Legato DiskExtender HSM file-systems are based on the idea
of migration. Just like on mainframes, a file has a header that stays
resident on disk-based
[EMAIL PROTECTED] wrote:
Things seem a little slow on the list ( like I need more email :)
Some choice bits from Dr Dobbs Journal, November 1988.
Some you may actually have been working in IT then. ;)
Jared
Plus ça change plus c'est la même chose.
--
Regards,
Stephane Faroult
I think the official term is optimizing within the law.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
In response to a post on data purging Tim Gorman wrote some on SAN-based
disk, some on NAS-based storage.
Can someone please explain the differences between these technologies
please.
My understanding that a SAN is a group of disks which are available on a
network and are not 'owned' by a
I had mostly forgotten about the bus architecture wars. The S-100 bus
was another one that was very popular for a time. Every bus
architecture had its manufacturing proponents, development systems,
development environments. That was when computer magazines like BYTE
were at their fattest--there
this will be build in-house...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 11:56 PM
Grace - Amen to Yechiel's first rule. At the VERY least, warn your
management that they need to consider a second system for the
Oui, ce qui circule, vient autour.
Probable imperfect translation courtesy oif babelfish.
Jared
Stephane Faroult [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 03:33 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Laura,
I have seen custom developed XLA's (Excel Add-Ins) for doing this, however
I have also seen a couple of commercial ones.
Check out www.oraxcel.com and their product SQL*XL - it provides what looks
like nice functionality although I only looked at the demo and never
purchased the
List,
How do I find out how full my shared_pool is?
Jos
Yahoo! Careers
- 1,000's of jobs waiting online for you!
On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote:
List,
How do I find out how full my shared_pool is?
--
Diagnosing and Resolving Error ORA-04031
Type: Note Doc ID: 146599.1
Understanding and Tuning the Shared Pool in Oracle7, Oracle8, and Oracle8i
Type: Note Doc ID:
I can't believe you people are talking about Toledo residents like this.
It's disgusting.
--Walt (Go Mudhens!) Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday, November 06, 2002 5:08 PM
To: Multiple recipients of list ORACLE-L
I think the official term is optimizing within
Title: Help: ORA-980 raised if a PLSQL block references a remote public synonym
Hi,
Oracle Version 9014 for Tru64
We are encountering the above problem which appears to be an instance of Bug 1698784 which Oracle claims was fix in 9013. It does not occur for private synonyms. Can anyone
1 - 100 of 108 matches
Mail list logo