Hi,
I've sent a couple of questions on queues and got no answers - that's fine and I
understand we're all busy.
What I'm wondering though is whether anyone is actually using Oracle queues at all?
Any feedback would be appreciated.
For anyone out there who does use Advanced queues:
one of our d
One table should do the purpose and partioning would be a very useful option
to go in for and the local indexes would take care of the efficiency in
terms of retreival.
More options to work in as one of the partitions goes down. The other nine
would still be active and recovery could be carried o
hi deepa
i think Option-2 is a better choice if you want to go for retrieval speed.
but this depends on the types of query you will perform on
that table. generally joins are too costly speed wise so option-1
one seems less efficient i mean more the table joins in u'r query the
slower will be the
Hi,
We are in a process of purchasing Oracle Database. This deal will include
hands-on training as well. The course outline given by the dealer is as
follows:
* Database physical & logical Architecture.
* Database Startup and Shutdown.
* Database physical & logical backups.
* Operating system b
Hello
We are doing database design for a project.
We have 10 distinct transactions types and the total number of records is
expected to be around 5,00,000
taking all transactions together.We have normalised the tables and decided
to store all of them together in a
single table identified by the tr
According to my instructor (I'm in class this week), Oracle hasn't
officially blessed upgrading these seminars to 9i yet.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTEC
Chris - Another alternative for you to consider, depending on your Oracle
version - Resource Manager.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, October 29, 2002 1:29 PM
To: Multiple recipients of list ORACLE-L
I just wanted to
To me, the key point is that sqlplus will log you on the database. If the
database is down, this will fail, so you must use the /nolog option in order
to access the database so you can start it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMA
Lizz - Given the amount of effort you are going to invest in this, I would
seriously study the features in 9i Data Guard (new Standby name) and ask if
there was any way that I could invest that effort in 9i. Many sites feel
that the switchover to standby is so cumbersome in 8i (you must rebuild the
Rick - See the other message titled: Adhoc queries and limiting the amount
of records returned". We thought we would start our DW economically and
store it with an existing OLTP system. Bought a separate server real quick.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-O
Stephen
Can they tell you what the ping times were before? Some applications
are more sensitive to slower networks than others, probably because they
make more network round trips. Even if the ping times are "within spec", if
they have increased, that might cause an issue. Just a thought fo
list,
i'm in the process of recommending Oracle as a "completel solution" for a
;large
data warehouse (for a central bank) . After doing thru some of the
documentation on OTN ..i have the following info
on the products i would need. Please comment if i'm missing something
- 9i database (with da
Anjo,
They have reported the results of ping times and said that response
times are "within spec". They have told me that the network card is
handling "x bytes per second without errors" and that the card is
capable of many times that throughput. They have swtiched network cards
8 times last w
Stephen,
Sounds like you've already done plenty of hunting. Do you know what these
waits were like previously?
Perhaps someone can correct me if I'm mistaken but does a "listener not
responding" error indicate the problem is getting to the server in general,
not the instance itself. Perhaps som
Yes - and I just completed stress-testing an OLTP database where we went
from 2 distinct 'filesystems' for data files to 12 separate filesystems.
Average wait times for I/O dropped from 40 - 50 msec (yes 40 - 50 msec!) to
about 10 - 13 msec. All this was on an Disk Array and all we did was to
convi
As with any "cached" I/O subsystem technology (i.e. RAID-S, NetApps, etc),
please visualize a water tank. The water tank represents the cache, the
drain from the tank represents I/O throughput rates from the cache to the
hard-drives, and the faucet filling the tank represents the I/O volumes from
This is called "Blame Storming". Every component works "fine" but
response time sucks and the problem is some other area. So how do we
turn "Blame Storming" into "Brain Storming"?
Check out the network components. One of the problems is that the
network people look at utilization, instead of resp
Oracle 8i uses a different aging algorithm than
before. It waits for blocks to be accessed several times before
considering keeping them around. That way the full scan of a big table
won't push other tables out. If aging becomes a problem, remember you can
now size a keep and recycle buff
Ah yes.
The eternal argument between the DBA, who likes things separate,and the SA,
who likes big smears (But it's mirrored!).- Original Message
-From: <[EMAIL PROTECTED]>To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>Sent: Tuesday, October 29, 2002 3:43 PMSubject: Re
If you have to convert in place, do it. But let's examine things a bit more
closely first. You say you have tablespaces sized from 5 GB to 60 GB and
you don't have much freespace as a buffer. Do you have 60 GB buffer? If
so, you're home free. Create a new LMT, move the objects from the DMT to
We have experienced a sudden and dramatic decrease in performance
sometime over the weekend (after Sat but before Monday 4 am). In
following Gaja's tuning philosophy, I've found that the top 2 waits are
usually (always 2 of the top 3) SQL*Net Message to client/SQL*Net more
data to client. Everybo
Andrey,
What does V$SESSION_WAIT values for the session that performs the ANALYZE
say? Another though: Do you have Parallel DEGREE set on that table?
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
What would you see if you were allowed to look back at your life at the end
Hello,
Well, I for one got enough of the message to make me curious, so I fed the
stuff into Alta Vista's translator, and for posterity's sake, here it is, in
chronological order (and you owe me one, Dick for this Herculean-like
labor):
Taken from a friend I am seriously thinking to stop bein
Hi Pablo,
There is no known problem if you have installed OPS
even thought actually you don't use it, there is also
no impact on DML_LOCK if your data are accessed by
only one instance.
Comment out PARALLEL_SERVER if is in your parameter
file.
HTH
Kader
--- Pablo Rodriguez <[EMAIL PROTECTED]>
"Armstead, Michael A" wrote:
>
> We're moving from RBO to CBO.
>
> For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS?
> And why?
>
> My thinking is if it's a database where most of the querying is done on
> small sets of records, then we may want to use FIRST_ROWS. On the
Michael,
I think you are correct... OLTP tends to go for FIRST_ROWS. OLAP tends to
go for ALL_ROWS. I say "tends" because I'm sure there are a multitude of
reasons for selecting the other option. I guess you need to look at the
queries being run against the database, and the applications using
Christine,
Pretty simple really.
On your database:
select '|' || value || '|'
from v$parameter
where name = 'os_authent_prefix';
The reason for the enclosing '|' will be apparent if
the value is an empty string.
Assuming you logon to the box as 'administrator', and
that os_authent_prefix = ''
I would go with 3 RAID 1's given the choice.
Not necessarily for performance though.
This would allow you to have 3 control files on separate drives.
It would also allow soft mirroring of the redo logs.
And before someone jumps in with "But you don't need
to mirror them on RAID 1", I *like* hav
No Hable Espanole!!
Reply Separator
Author: "Stephen Andert" <[EMAIL PROTECTED]>
Date: 10/29/2002 10:25 AM
Esto me dio mucha risa. Alguien lo va a traducir al ingles para el
resto de la lista?
Esteban
>>> [EMAIL PROTECTED] 10/24/02 12:05PM >>>
Ups
As well as the structure of the table... What (or how many) indexes are on
the table? Have you tried just analyzing the indexes, or perhaps just
table data?
Also, since I don't have a convenient environment to test this out... Can
someone please confirm what happens to a global index when only
We're moving from RBO to CBO.
For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS?
And why?
My thinking is if it's a database where most of the querying is done on
small sets of records, then we may want to use FIRST_ROWS. On the other
hand, if our database is used to gener
Chris,
I don't really have a nice solution, however I would have to recommend
against using rownum type solutions...
There is a really good chance that the users won't understand the
implications of such a clause and therefore won't understand it's affect
upon the results. A user might ask for t
Aside from severely restricting access to analysts who need to investigate
problems in production data we limit the CPU time in their profile to 5
minutes. That's a pretty generous limit and they've never had any issues
with it.
-Original Message-
Sent: Tuesday, October 29, 2002 2:29 PM
T
Title: Adhoc queries and limiting the amount of records queried...
Hi
all
System is Siebel
Ok I got a couple of tables about 6 GB
big, up to 10 million rows.
Some of the tables come out of the box
with 30+ indexes, now for those not aware Siebel does
not support the dropping of
This is what I do in my shop since they allow(not me) ad hoc queries...
I modified the user id that run ad hoc queries to default to a TEMP
tablespace which is rather small. :)
They failed most of the time and I receive no complains. :)
Bing Wong
Open Systems Database Administrator
x25721
Thi
Hope someone can help me with this one.
I have just realized that PARALLEL SERVER = TRUE in
v$option and I don't have an OPS instalation.
I've installed this Oracle code in a Unix Cluster
that's why Oracle has installed this option
automatically, I assume.
Can anyone tell me if there can be any
Jeroen,
Scott is the instructor -- he didn't develop the curriculum. Let me
check -- I don't want to publish the someone's name to this list and have it
be a big surprise or an inconvenience... :-)
More soon...
-Tim
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMA
You could implement FGAC or create views that only contains necessary
records.
Rick
"Grabowy,
many shops prohibit ad-hoc queries in busy OLTP databases and many of those
have datawarehouses where ad-hoc is allowed. IMHO that's the only way
prevent ad-hoc queries from causing problems in your OLTP environment.
SQL> select * form users where clue > 0;
no rows selected
-Original Mess
Title: Adhoc queries and limiting the amount of records queried...
In SQL Server: "set rowcount " before
running the query does the same thing as oracle's ROWNUM in "where"
clause.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Grabowy, Chris
To
Title: Adhoc queries and limiting the amount of records queried...
I just wanted to ping the list to see what other people have done to control or constrain adhoc query users???
We have a group that is struggling with the adhoc query piece that's in production. Some of the users end up fir
Hello...
As a follow up to the last question about moving to 9i RAC, how many of you out there have made the move or plan to make the move to 9i RAC for DSS (Data Warehouse)? If so... what is driving you to make this upgrade? If data volume can you please provide examples... if query performance
Look for the code
TOP 10 WRITE PINGING OBJECTS
TOP 10 READ PINGING OBJECTS and
TOP 10 FALSE PINGING OBJECTS
in opsdiag.sql ( available in metalink doc. id 205809.1 )
Last week, we wrote a shell script to gather the above information every
20 minutes ( instead of running opsdiag.sql every 20 minu
Title: RE: analyze table takes forever
You
mentioned that count(*) took 10 minutes but did not say how many rows are
present in that partition; if number of rows is less than 1 million, I would do
the following.
alter
table . move partition
tablespace nologging;
and
then re-analyze
John Kanagaraj wrote:
>
> Mark,
>
> If you read the latest Oracle Mag (Peer-to-Peer), you will find that a
> (sometime?) list member Murali Vallath is using RAC and is actually planning
> a book sometime later. Maybe you can address the question to him? Murali
> presents/attends IOUG
What is
Cary,
Here's what my search of Registry revealed:
PPM> search Registry
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/PPMServer:
Win32-Registry-File [1.09] Perl interface to MS-Windows
registry
files.
Win32-TieR
Title: RE: 9i RAC
forget 9201 ... 9202 has about 20+ fixes that are related to RAC code. ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't ref
Jared,
Of course, I have been corrected!
Woo-hoo! I win! I learned something new today! I get to go home early!
Wow. This was really a shocker to me. I tried a little test myself on an
817 database and it works as Raj (and the documentation) said it would.
Does this mean I will change my
We are currently running 8i OPS and having serious issues with "global cache
request" waits that kill the performance on the machines. Because of this
issue, we are almost being forced to upgrade to 9i RAC.
I hope and pray that this will work out, but I've learned to not count on
much until you a
Title: RE: analyze table takes forever
what's the structure of the table?
And try taking an export of this partition and import it into it's own table in a development box... see if you can analyze it there.
Nick
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTEC
Mark,
If you read the latest Oracle Mag (Peer-to-Peer), you will find that a
(sometime?) list member Murali Vallath is using RAC and is actually planning
a book sometime later. Maybe you can address the question to him? Murali
presents/attends IOUG and I know for sure that he 'speakes from the
tre
Esto me dio mucha risa. Alguien lo va a traducir al ingles para el
resto de la lista?
Esteban
>>> [EMAIL PROTECTED] 10/24/02 12:05PM >>>
Ups colegas !
@lex
Lic. Alexander Ordóñez Arroyo
Soporte Tru64Unix & BD Oracle
Am I looking for trouble by mixing an OLTP type database
with a DSS type database?
I currently have a relatively small database that is used
for quick lookup type actions. The company wants to add a much bigger and
constantly growing application for historical reporting on the same
mac
Title: sqlplus /nolog
Ah ha. It's the double quotes you use. These were not necessary with svrmgrl
Rodd
On Tue, 2002-10-29 at 09:49, Toepke, Kevin M wrote:
It doesn't?
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tu
We are planning to use it on Solaris.
Gerardo
-Original Message-
Sent: Tuesday, October 29, 2002 8:30 AM
To: Multiple recipients of list ORACLE-L
A quick question out to the masses..
How many of you out there are ACTUALLY USING 9i RAC technology?
If not already using it - how many ha
The BLOB can be "in line" if the size is less than 4k, otherwise it is
stored as "out-of-line".
RWB
"Gene Sais" <[EMAIL PROTECTED]>@fatcity.com on 10/29/2002 07:39:01
AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL P
No, 1.0.2 is a leaner product - no infrastructure required.
Scott Shafer
San Antonio, TX
210.581.6217
> -Original Message-
> From: Gene Sais [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 29, 2002 10:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Installing iAS
I beg to differ Mr. Holman. The sqlplus command should work if the "/ as
sysdba" is enclosed in quotes. So , the command would be
sqlplus "/ as sysdba" . This works in Oracle9i on Unix and Windows NT/2000
environmnents. At least it does so in my environments.
RWB
Rodd Holman <[EMAIL PROTE
Sorry in advance, but I didn't think I'd need this.
There was a discussion about 4 weeks ago if memory
serves correct, about denying users logging on to
Oracle directly either through SQL*Plus or other tools
such as TOAD. Tried searching the archives but
getting too many hits.
Someone posted tri
I run it at home on the laptop if that counts :-)
But seriously, I'm working with a client who are
migrating from a large Sun box to a 4node Tru64 RAC
architecture on 9.2
Do I think it will workprobably not
Cheers
Connor
--- Mark Leith <[EMAIL PROTECTED]> wrote: > A
quick question out to
Jared:
PPM> search Tie::Registry
PPM> search Win32::Registry
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/
PPMServer:
Win32-Registry-File [1.09] Perl interface to MS-Windows registry files.
PPM>
Is 1.09 really what I want to install?
Cary Millsap
Hotsos Enterp
This is what we have in mind.
For the partitioned tables that are going to have the 'rotation' logic,
we will convert them to LMT when they become empty. We drop the
'oldest' partition and create a new one for next month. This will be
carried out every month. Partition for November data is empty
Tom,
If the string matches the NLS_DATE_FORMAT, Oracle will convert it to a
date.
Try this:
create table d( d date );
alter session set nls_date_format = 'dd-mon-yy';
insert into d values('21-dec-02');
insert into d values('22-dec-02');
insert into d values('23-dec-02');
insert into d values
A quick question out to the masses..
How many of you out there are ACTUALLY USING 9i RAC technology?
If not already using it - how many have plans to use it (or at least plan to
investigate it)?
Cheers
Mark
===
Mark Leith | T: +44
> "Jamadagni, Rajendra" wrote:
>
> Well,
>
> Let me point out one thing following is the original query ...
>
> -- this returns no rows ...
> select ea1.ep_number, ea1.est_dt, veas.est_dt
> from (select a.ep_number, ea.est_dt
> from v_episode_avail_summary_break a, episode_airin
Solaris 5.7
From: "Fink, Dan" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Data guard
Date: Mon, 28 Oct 2002 13:43:33 -0800
What platform are you on?
If UNIX, make sure your i/o settings for reads and writes (asynch or
Title: RE: Implicit Date conversion problem
Raj,
you
said:
"according to Oracle, when comparing a
varchar2 to a date column, the string does get converted to a date ...
"
This
has got to be wrong. If you compare a varchar2 column with a number,
Oracle try's to convert the varchar2 t
Thanks for all the replies. It makes me rethink going to iAS 9.0.2.0.1. Does iAS
1.0.2 require all the same dependencies, i.e. infrastructure install?
Gene
>>> [EMAIL PROTECTED] 10/29/02 07:53AM >>>
made the same experiences with iAS 92 and ended up
using 9iAS 1.0.2.2 for various reasons.
but
Hi,
what do you mean with "to export in system user with two user tables" ?
Regards,
Adrian Ciocildau
Oracle wrote:
Dear
One of the solution is you can export in system user with two
user tables. You can exp/ imp blob column also. Later you can imp thru
system, but use from user and to user
It's these readers-blocks-writers and dirty reads that makes people migrate
their data to Oracle. Blocking writers kills performance. Of course
constantly rolling back blocks to give queries consistent views uses i/o and
cpu. But that extra overhead rarely impacts overall performance as badly as
Greetings ALL..
I have been assigned a security research project by my boss. Really simple
topic, o/s authentication vs. password file authentication. Currently we use
a password file, and the boss wants to know what it would take to convert to
o/s authentication instead. However, I'm not fami
Title: sqlplus /nolog
It
doesn't?
$
sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53
2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
Connected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 -
ProductionWith the Partitio
On Tue, Oct 29, 2002 at 07:23:33AM -0800, Lizz Pena wrote:
> Looks like I'm gonna implement a stand-by database on
> Windows 2000 using Oracle 8.1.7.4
>
> Anyone have any good article, how-tos, caviots I need
> to consider or read up on?
--
caveat, from Latin, let him beware. Ain't English gre
Raj:
The date column has a timestamp value as well. By using the TRUNC
function, you are getting all dates regardless of the time value (i.e.
12:01 AM, etc.) . When dealing with DATE datatypes it is always a good
practice to use the TRUNC function on the columns to prevent the time of
day portio
"Some guy in the Netherlands" uh huh
--- Anjo Kolk <[EMAIL PROTECTED]> wrote:
> No I have given them for Oracle in Holland, Belgium, Norway,
> Singapore
> and Malaysia.
>
> Anjo.
>
> -Original Message-
> Sent: Tuesday, October 29, 2002 12:58 PM
> To: Multiple recipients of list O
Mark Leith wrote:
>
> What is shown to you on the Oracle Ed site, is actually based upon where you are
>located, within your login profile. I don't see any mention of "Seminars" what so
>ever (being UK based).. Can anyone else in the UK confirm this?
>
> Cheers
>
> Mark
>
Nothing of the sort
Dear gurus !
We are trying to analyze a table partition (estimate 2 %) and it takes
forever.
analyze table ... partition (P20021022) estimate statistics sample 2
percent;
For instance, select count(*) from the same partition takes 10 minutes , but
the analyze takes literally infinite amount of tim
What a guy that Joe is. ;-)
But Joe, I thought you were getting out of the DBA business.
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> well that didnt work, ok how about cut/paste :)
>
> Joseph Testa bought a few things at Amazon.com and wanted to offer
> you a
> discount on them.
>
> Its the
Russ:
We're using EMC Clariion disk arrays. These are using EMC's version
of RAID-5; they call it RAID-S. There is 2GB of cache if front of
the disks. They claim that the cache is write guaranteed so that
we'll never lose an update. So far, so good, and the performance
has been acceptable, e
On Tue, Oct 29, 2002 at 01:48:38AM -0800, sonny e. supilanas wrote:
> hi, i learned that i need net8 for linux to rebuild the DBD-Oracle perl
> module. where can i download one for free
otn.oracle.com, you have to download oracle for linux and install it.
The installer gives you the option to ins
Actually, I am sending and receiving files.
They will be handling the FTP of the files, and making sure it has FTPed
correctly.
I just have to have a sanity check of the file. Basically, I decided to
prefix each data line with 'DAT', and the "CRC line" with 'CRC'. The
flat file is "read into th
Title: RE: Implicit Date conversion problem
Sorry about that ... I am working on a sev-1 problem with Oracle (ora-904 error if anyone is interested).
Doesn't work means it doesn't return any data the working query returns correct number of rows. the trunc() syntax is right ... est_dt co
Title: Implicit Date conversion problem
Raj,
you
are forgetting how dates are stored internally vs. how they are displayed by
sqlplus.
change
your first query to:
select ea1.ep_number, ea1.est_dt,
veas.est_dt from (select a.ep_number, ea.est_dt
from
v_episode_avail_summar
otn.oracle.com is the right place.
Jared
On Monday 28 October 2002 20:58, sonny e. supilanas wrote:
> hi, i'm totally new to oracle, we have a webserver running on mandrake
> and can make queries to mysql dbase using perl/cgi scripts on same unit
> which works fine for our sites. but now, we ha
Scott Heisey taught the "New Features for 8i" administrators class that
I took.
Yeah, he's in my top ten of Oracle instructors.
A not at all complete, in no particular order list is:
Scott Gossett
Scott Heisey
Sue Jang
John Hough
Please note, I have NOT taken classes from all the Oracle instru
One of the best sources of information is a white paper by Lawrence To
called Graceful Switchover and Switchback for Standby Databases
(Metalink note 90817.1)
Another one under the White papers sectiopn is note 91570.1 but I have not
looked at that
John
-Original Message-
Sent: 29 Octobe
Hadn't thought of trying that; makes sense. Thanks.
--- "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]>
wrote:
> When you tried under NT, did you use sqlplus.exe or sqlplusw.exe?
>
> If you used sqlplusw.exe, this sounds like Bug No. 1504702
>
> The workaround is to use the copy command from the
In addition to BIshop's excellent response, be sure to install
the latest version of Tie:Registry. The one that comes with
ActiveState Perl doesn't work properly.
The current version (as installed from ActiveState via PPM)
is I believe 1.24. Just reinstall it.
Jared
On Tuesday 29 October 200
On Tue, Oct 29, 2002 at 06:58:49AM -0800, Gogala, Mladen wrote:
> It originates from the wonderful OS that used to have commands like "SET
> DEF", "MONITOR MODES",
> "BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[]*.* MU:" and alike. There is also
> an abomination
> of this OS created by David Cuttler.
Title: Message
Oracle didn't start offering instruction directly
at your desktop or urge you to open up an iTAR instead of talking to a Customer
Service person for nothing. People are expensive.
- Original Message -
From:
Bob
Metelsky
To: Multiple recipients of list ORA
Russ,
I am currently working for a large company who are moving
from EMC disk array to HP XP512 arrays (these are actually HDS disks re-badged by HP).
Both Oracle and HP are very firmly stating that we will have
no negative performance from using Raid 5 and they have put this in wri
Look out for the Pentium 4 bug.
Other than that I've found it to be pretty straightforward.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: RE: Implicit Date conversion problem
http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/sql_elements2a.htm#54201
Look up for table 2-10 and then below the table look for 4th bullet ... that's where I found it out ...
At-least Tom you know my pain
Sony Music also uses it extensively
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> Oxford is using maestro and it is a good software.
>
> > -Original Message-
> > From: BALA,PRAKASH (HP-USA,ex1) [mailto:prakash.bala@;hp.com]
> > Sent: Monday, October 28, 2002 12:09 PM
> > To: Multipl
Title: RE: List of Rows Updated
Gosh. I wish I worked in your shop. I'm
typically asked to produce an audit report for yesterday on a table I didn't
even know existed. "What do you mean you can't do that? Aren't you
an Oracle DBA?"
- Original Message -
From:
Jamadagni, Ra
Dick,
We've looked at another scheduling tool that's paticularly good at cross platform job
dependancies etc. that has support for Peoplesoft. The product is called OpCon/xps
from a US based company called SMA.
Before you ask, no, I receive no commisions from this company.. ;) We did in fact l
Title: sqlplus /nolog
sqlplus /nolog starts sqlplus, but does not connect
you to any database, nor does it prompt you for a
username/password.
- Original Message -
From:
Daiminger, Helmut
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, October 29, 2002 8:29
If the value is not dependent on the parameters entered by the user then you
can have it a user parameter not displayed in the parameter form.
Alternatively, you can also use a placeholder column to achieve the same. You
can place it outside of any group.
Regards
Naveen
-Original Message
can someone provide me with a link to get a oracle 8i
CD ?
there was one available from the oracle store for
around $40 (for 8i). i don't find that link there any more.
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
This is a multi-part message in MIME format.
--=002_Dragon805267761306_=
Content-Type: text/plain;
charset="GB2312"
Content-Transfer-Encoding: quoted-printable
Daiminger, Helmut=A3=AC=C4=FA=BA=C3=A3=A1
=A1=A1=A1=A1It is used when you want to do it in your shell script, or
$sqlpl
1 - 100 of 146 matches
Mail list logo
