Hi all,
when you would consider to put a table a cache...
rgds
gb
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
--
Please see the official ORACLE-L FAQ:
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 PC
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 ca
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 event
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
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-50
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
you
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
d
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 Pa
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
"Merc
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 r
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
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 use
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 7-10
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 myc
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
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 Peppe
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
>
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 PRO
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 Ser
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
On
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 curre
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
That's the bug number they gave me.
-Original Message-
Sent: Monday, October 20, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
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
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 295492
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 o
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 =
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 PROTE
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
'/
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. An
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 bec
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 Duhv
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 othe
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 experiences.
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, Stefic
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 hash_
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 ren
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 recip
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 i
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
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
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
- H
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 priv
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
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 opport
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 11
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 ar
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 b
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 intere
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, a
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: http://www.orafaq.
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 woul
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
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 applic
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 Message
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
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 fou
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 nam
Db
link slow ?
Are
you sure ? What was the bottleneck when you test ?
Using
insert /*+ appent */ on non-indexed tables with nologging is usually fast
enough in most cases.
I know
that we can play with the SDU-TDU parameters on sql*net but I do not know
what kind of performance improve
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
e
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. H
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 int
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: Mond
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 Me
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
>
>
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 w
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
67 matches
Mail list logo