Have
you tried SQL*Plus's COPY command??
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Gunnar Berglund
[mailto:[EMAIL PROTECTED]Sent: Monday, October 20, 2003
1:39 AMTo: Multiple recipients of list ORACLE-LSubject:
Data Transfer between two
Iz SAP DB Oracle??
On 2003.10.20 07:34, Goulet, Dick wrote:
Have you tried SQL*Plus's COPY command??
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, October 20, 2003 1:39 AM
To: Multiple recipients of list ORACLE-L
Hi all,
we have an application
yep
Iz SAP DB Oracle??
On 2003.10.20 07:34, Goulet, Dick wrote:
Have you tried SQL*Plus's COPY command??
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, October 20, 2003 1:39 AM
To: Multiple recipients of list ORACLE-L
Hi all,
If this is true, then what is the difference between RAC (formerly Oracle
Parallel Server) and Grid computing? Is this just another fine example of
Oracle taking an existing product and renaming it yet again? they *like*
doing this.
Tom Mercadante
Oracle Certified Professional
-Original
SAP runs on Oracle. Unless you use that cheap thing that MYSql currently offers, in
which case use heterogeneous services, if you can find the odbc driver. Then a DB
Link or the COPY command will work.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent:
Gunnar,
Please do not discard dblinks so readily.
As in many situations, I suspect that they are blamed for ³slowness² when it
is really the application code that is at fault. All too often, people will
write PL/SQL code that hasn¹t a hope in hell of performing well, then put a
database link
This is for non-transactional data load instances. The guys here sware that by using
smaller temporary tables(not global temp tables) they can increase the speed of the
data loads.
Not worried about latch contention because its just for bulk loads. I know this bad in
transactional instances.
All the time. Oracle Apps's open interfaces are built this way, for
example.
However, the guys here covered their bases by specifying smaller
temporary tables, as if they could prevent them from becoming large. I
suppose they might feel that they indemnify themselves if the tables should
ever
Db
link slow ?
Are
you sure ? What was the bottleneck when you test ?
Using
insert /*+ appent */ on non-indexed tables with nologgingis usually fast
enough in most cases.
I know
that we can playwith the SDU-TDU parameters on sql*net but I do not know
what kind of performance improvement
Tom
I would suspect that you are correct. I suppose we won't know until the
10g manuals are released. I do understand that parallel server was pretty
much rewritten to create RAC. However, I would argue that what you see as an
irritation is part of Oracle's marketing success. By changing the
we drop and recreate the temp tables every night. We also use PCTFREE PCTUSED at 99
and 1 to pack in the blocks and we use very small extent sizes. then we analyze with
an estimate size of 20 percent which is quite fast.
All of them are used for full table scans and do not have indexes. Ive
We have some servers with 6-8 instances. These are typically staging instances and
maybe 1 low transaction production instance.
We keep multiple instances on one server strictly for cost. Licensing additional
servers would be prohibitively expensive so we bought higher end servers and stacked
Dennis,
I guess this is the crux of my question. My impression was that it was
*not* just another implementation/release of OPS/RAC, that it was indeed
something brand new. I guess I need to wait and see what it actually does.
Tom Mercadante
Oracle Certified Professional
-Original
Stephane,
After much experimentation it is my considered opinion that
SQL*Net is NOT the most efficient way to move data from point a to b, especially
when using DB_LINKS. SDU-TDU do help, but only marginally. What you
really need to do is use a bulk collect method that most application
the big question is how useful will it be in 10g. Will anyone want to use it? I think
I saw a post somewhere that says wait until oracle version 12 before anyone uses it.
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/10/20 Mon AM 10:44:25 EDT
To: Multiple recipients of list
I believe that transferring large quantities of data between
point A and point B at discrete intervals is not an optimal operation
in itself. I could argue a point that if application needs to do so,
the application needs to be re-designed, possibly by using data guard
or similar tools which
Please send me an email, if you are interested.
_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com
--
Please see the official ORACLE-L FAQ:
I have the impression that Oracle has a grid running from Texas somewhere,
that they used it to test 10g, and that they also are using w.r.t the
Collaboration Suite.
In their case, if they can allocate resources like people used to be able to
allocate disk from an NAS to servers that require it,
Now that's a piece of recruiter mail that I can really appreciate. Short to the
point.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, October 20, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L
Please send me an email, if you are
We are trying to analyze 200G of redologs (archive logs) from past 1 year. The
database is on windows and the log miner is taking about 4 hours to analyze 2G log
files. Is it possible to move the log files to sun SPARC Solaris and analyze ? I would
think the log files between NT and Unix won't
Please send me some more information.
Thanks,
Quamrul
From: "system manager" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: job opportunity in Dallas
Date: Mon, 20 Oct 2003 07:09:32 -0800
Please send me an email, if you
Rakesh,
According to a session I attended at this years OraTechs conference, yes you
can. Now I haven't experimented with that so throw a shovel full of salt into the mix.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, October 20, 2003
Title: RE: job opportunity in Dallas
What kind of job? Mail Carrier, garbage collector, retail clerk Details.
-Original Message-
From: system manager [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 20, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
Subject: job
You need the power of the Grid!
;)
Sorry, can't help from my side - just couldn't resist!
-Original Message-
Rakesh Gupta
Sent: 20 October 2003 17:00
To: Multiple recipients of list ORACLE-L
We are trying to analyze 200G of redologs (archive logs) from past 1 year.
The database is on
Executioner.
On 10/20/2003 12:14:35 PM, Stefick Ronald S Contr ESC/HRIDD wrote:
What kind of job? Mail Carrier, garbage collector, retail clerk
Details.
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally
Fyi, Oracle updated note 182699.1 last Friday. The inaccurate statements
about index fragmentation have been removed.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
-
Hi,
I'm trying to troubleshoot ora-1000 (max cursors exceeded) for an
application. When I ran the following query on the SID(192),
select hash_value ,count(*)
from v$open_cursor
where sid=192
group by hash_Value
having count(*) 1;
HASH_VALUE COUNT(*)
-- --
670480087 5
Yes, what kind of job is it?
Stefick Ronald S Contr ESC/HRIDD wrote:
RE: job opportunity in Dallas
What kind of job? Mail Carrier, garbage collector,
retail clerk Details.
-Original Message-
From: system manager [mailto:[EMAIL PROTECTED]]
Sent: Monday,
Is 38 that old ???
Stephane
-Original Message-
Mladen Gogala
Sent: 17 octobre, 2003 18:00
To: Multiple recipients of list ORACLE-L
Ah, another one who can claim experience. According to one of
the previous post it's a genuine gold mine these days. Being born
in the Jurassic (1961) has
Let's do the time warp again! 2003-1961=42... But, I liked 1999 better...
just a jump to the left...
One thing about living in the past...
The rent sure is cheaper.
Bambi (feeling that 38 is a spry young thang)
-Original Message-
Sent: Monday, October 20, 2003 11:44 AM
To: Multiple
38 is my age, Mladen is 42
Stephane
-Original Message-
Bellow, Bambi
Sent: 20 octobre, 2003 13:04
To: Multiple recipients of list ORACLE-L
Let's do the time warp again! 2003-1961=42... But, I liked 1999 better...
just a jump to the left...
One thing about living in the past...
The
Do you have CURSOR_SPACE_FOR_TIME set to true?
On 10/20/2003 12:39:25 PM, elain he wrote:
Hi,
I'm trying to troubleshoot ora-1000 (max cursors exceeded) for an
application. When I ran the following query on the SID(192),
select hash_value ,count(*)
from v$open_cursor
where sid=192
group by
Hummm, sounds interesting. Been doing that on Duhvelopers for the last 10 years! *-)
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, October 20, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Executioner.
On 10/20/2003 12:14:35 PM,
generally speaking there are two groups of people using the RBO.
1. The DBAs who have been around for 15 years and doesnt read release notes and doesnt
feel the need to read release notes or documentation because he knows everything. He
may have tried the CBO in 1995 and had 1-2 bad
Tom
Your perception is correct. Think about grid in very simple terms as a
collection of database servers (clearly there's more to it than that, but
for the point I'm trying to make this makes it easier to understand), and
you'll quickly see that a RAC database can be part of that BUT so can
I wonder... in the VMS world, they were executables, so is this a VMS job?
Would it be '.o'ers in Unix? Or batchers in DOS?
Bambi.
-Original Message-
Sent: Monday, October 20, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
Hummm, sounds interesting. Been doing that on
Unfortunately, our applications fall into the second category. And due to
the complexity of the queries being run, attempting to turn on CBO also
activates a bug for which Oracle has a fix in v10.1 but will not do a
backport, and so, until we are ready to go to 10.1, we are stuck with RBO,
and
what is the bug?
From: Bellow, Bambi [EMAIL PROTECTED]
Date: 2003/10/20 Mon PM 02:04:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: CBO, RBO and will v5 ever really go away?
Unfortunately, our applications fall into the second category. And due to
FYI,
I tried the logminer utility ver 8.1.7.2 on solaris to analyze windows os based log
files, it didn't work. Apparently, it could not read the file header information.
Errors:
ORA-01284: file /export/home/oracle/utldir/ORCLT001S03748.ARC cannot be opened
ORA-00308: cannot open archived log
Title: Message
On the
application which needs the data,can you use CTAS with nologging? This is
a pretty fast way of transfering data. Have you investigated
transportable tablespaces. How current does the data have to be?
Ian
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
Didn't I mention that? Bug 2954921... simple query blows away one of their
internal views. Here's a snippet of the text from the TAR.
select a.* from nt_admin_place a, nt_country c where c.country_id in
(select id from TEMP_ADMINPLACE union select id from TEMP_ADMINBORDER )
and a.admin_level
Hey guys - this is funny. Don't respondit is actually a trick...various employers
are using this service to determine how loyal their current DBA's are while the market
is tight
Just kidding
-Original Message-
Sent: Monday, October 20, 2003 1:54 PM
To: Multiple recipients
is that the correct number? its not on metalink.
From: Bellow, Bambi [EMAIL PROTECTED]
Date: 2003/10/20 Mon PM 02:54:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: CBO, RBO and will v5 ever really go away?
Didn't I mention that? Bug 2954921... simple
And you think I used my real name !
Clark Kent
-Original Message-
[EMAIL PROTECTED]
Sent: 20 octobre, 2003 14:59
To: Multiple recipients of list ORACLE-L
Hey guys - this is funny. Don't respondit is actually a trick...various
employers are using this service to determine how loyal
Speaking of a tight market
http://update.informationweek.com/cgi-bin4/DM/y/hcut0BdZe50V20CBbm0Aj
On 10/20/2003 02:59:25 PM, [EMAIL PROTECTED] wrote:
Hey guys - this is funny. Don't respondit is actually a
trick...various employers are using this service to determine how
loyal their
2% - that's all we get? -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Monday, October 20, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Speaking of a tight market
http://update.informationweek.com/cgi-bin4/DM/y/hcut0BdZe50V20CBbm0Aj
How come the following does not work
select *
from mytable
where mycol like '\%%'
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: [EMAIL PROTECTED]
Fat City Network
Monday, October 20, 2003, 4:54:26 PM, you wrote:
IN 2% - that's all we get? -:)
Didn't someone write a book once called The 2% Solution?
That's what we are: the solution!
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL
According to this census, the database administrators are the 2nd highest
jobless rate among the general IT workforce.
--Kevin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 20, 2003 12:59 PM
Speaking of a tight market
select *
from mytable
where mycol like '\%%' escape '\'
-Original Message-
Roger Xu
Sent: Monday, October 20, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
How come the following does not work
select *
from mytable
where mycol like '\%%'
Roger Xu
Database Administrator
Dr
select *
from mytable
where mycol like '\%%' escape '\'
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 opinion is an
Roger Xu wrote:
How come the following does not work
select *
from mytable
where mycol like '\%%'
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
Because '\' is an escape character only when explicitly declared as such
..
where mycol like
I think you need this instead:
select *
from mytable
where mycol like '\%%' escape '\'
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March
Hi Jared,
I agree it would be nice! In fact I am writing a paper for security
focus at present about password features and profiles and the password
function and what can be done with it.
The paper includes a script that writes a password function and profile
based on answers to given by the
Hi
Try looking in the $ORACLE_BASE/oraInstaller/installerActions.log (the
file name is from memory, i am sure you will find it). Parse the file
and all of the installed versions are listed towards the end. Also you
can search the oraInventory directory, there is a sub-directory for each
component
thank a million to everyone replied this.
-Original Message-
Sent: Monday, October 20, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
select *
from mytable
where mycol like '\%%' escape '\'
-Original Message-
Roger Xu
Sent: Monday, October 20, 2003 4:29 PM
To: Multiple
From what little I know about it, I would say that RAC is simply a piece of the
Grid enabling infrastructure. Grid computing is much larger than just Oracle.
There is no dearth of grid computing literature available on the www.
Simply google for it and you will be inundated.
Jared
Hello,
I am trying to concatenate several records with simple sql. Is this possible?
--
Thanks,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Tires, and Wheel
Jake
Can you provide a simple example of what you have in mind? Several
possibilities occur to me, but I'm not sure which will suit your need.
Concatenating the columns of a row, the same column from several rows, all
columns of several rows? Also, when you say several, how many specifically
do
Interesting question.
Some initial thoughts on that are that latches don't actually consume
much CPU. In a poorly written app (or in the extremely rare event
of a database bug, but probability of that is so low as to not be
worth discussing) you may encounter latch contention that will cause
Yes.
-Original Message-
Jake Johnson
I am trying to concatenate several records with simple sql.
Is this possible?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Is this database on the same O_H as OEM or a different one ?
Also you may want to review MEtalink articles on How OEM discovers a node
on Metalink...
Babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 10:44 AM
Hi List:
Thanks for the info Cary.
Jared
On Mon, 2003-10-20 at 09:29, Cary Millsap wrote:
Fyi, Oracle updated note 182699.1 last Friday. The inaccurate statements
about index fragmentation have been removed.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
-
Actually, that 'cheap thing' is SAP DB, which is a simply
what SAP renamed Adabas when they purchased it. Apparently it
is quite a capable databas.
On Mon, 2003-10-20 at 05:59, Goulet, Dick wrote:
SAP runs on Oracle. Unless you use that cheap thing that MYSql currently offers, in
which
Unless you typo'd, there are some serious problems here...
Setting PCTFREE to 99 is not likely to pack in the blocks. Rather the
opposite; you are instead leaving blocks 99% empty. Quite a bit of wasted
I/O in performing a FULL table scan here... :-)
Anyway, it is not a good idea to have
65 matches
Mail list logo