Here, here to that. We are using it in production now and have achieved
excellent results. eg A query that was taking almost 2 hours, down to
sub-second !!!
I'm sure Mark Leith from the list won;t mind me giving him a shameless plug.
If you are in the UK visit http://www.cool-tools.co.uk to downl
Hi All Gurus,
I need some guidelines in Migrating an Oracle version 7(Dont have the exact
version right now) database to 9i.
There are few tables which store Chinese Characters. And it also requires
converting Big5 internal code (some are HK characters set) into Unicode
ISO10646:1-2000.
Please a
Oops, my bad. It's the -ctime argument thats broke.
Jared
On Thursday 08 August 2002 15:04, [EMAIL PROTECTED] wrote:
> The "-mtime" functionality of find is known to have issues.
>
> i.e. it's broke.
>
> Jared
>
>
>
>
>
> "Sinardy Xing" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/07/
So,
there is no way ...to sole it out,
Regards
Arvind
-Original Message-
Sent: Friday, August 09, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L
Hi Arvind
From the error message it is clear that remote tables ae having some
object type columns which is not permitted.
--
It's nice to be noticed.
Thanx all
"Deshpande, Kirti"
Sure, I'd love to comment...
1. If you can inexpensively cache your whole database working set in
memory, there's nothing wrong with doing that *unless* you could have
better spent the resources somewhere else to make a bigger positive
impact to the business (business = net profit & return on inv
Save the following code as a C program called aio.c, then a simple "gcc
aio.c -o aio" will compile it. A return value of 1 (one) confirms AIO is
available. I run this on Solaris but it should work on HP. Code is
followed by an example run:
11978:oracle@bart> cat aio.c
#include
#include
main(
Hi Arvind
From the error message it is clear that remote tables ae having some
object type columns which is not permitted.
-Original Message-
Sent: Friday, August 09, 2002 9:58 AM
To: Multiple recipients of list ORACLE-L
Dear All,
i have created a DB link to remote database its
Dear All,
i have created a DB link to remote database its working perfectly
with some tables of remote DB but fails with some tables..
16:27:08 SQL> select * from zone_mst@arvind;
select * from zone_mst@arvind
*
ERROR at line 1:
ORA-22804: remote operations not permitted on object
And on AIX as well..
A bunch of thanks to Brian for sharing the script. I am sure it will be
widely used :)
- Kirti
-Original Message-
Sent: Thursday, August 08, 2002 5:18 PM
To: Multiple recipients of list ORACLE-L
Cool. And, as a bonus, sysresv will let you know if your SHLIB_P
>> Oddly enough, no complaints from users.
I signed up for but missed the presentation because I got pulled into a
meeting with a manager of an
application who was complaining about his database buffer hit ratio...
ok.. not really, but I did get pulled into a meeting. I assume that one of
the
Huh. So true.
Back in the old days when I worked in a large, not-to-be-named, insurance
company in Denver I had an experience similar to this.
At the time (1989) the company was mainframe-centric, and was just delving
into client-server. Company finally decided to go full-bore to client-server
a
> Bottom Line: I stand by my original premise -
> statistics alone do not determine an indexes candicacy
> for rebuild. Some additional knowledge, eg "I know
> the rows I've deleted will never be replaced" etc is
> needed.
Nice test case Connor, thanks.
Q: What are the chances of knowing wheth
Hello All,I'having performance problems. And I think is data contention. This is OLTP system. Solaris 8, Oracle 8.1.7.0I ran this query:SELECT count, file#, name FROM x$kcbfwait, v$datafile WHERE indx + 1 = file# ORDER BY count descAnd this is the top line13672 1 system01.dbfBy the other side I
Jack,
That works well for small schemas. It tends to generate a
lot of recursive SQL when the schema has more than a
couple hundred objects.
This number varies with how intensely RI was implemented.
More RI, *lots* more recursive SQL.
When the schema has many objects, it's much faster to dro
Kevin,
This is a bug in sqlplus. You are using two different releases Oracle,
and when you are using the 8i version of sqlplus and trying to describe
a table on a lower version of Oracle through a dblink, you will get this
error.
The work around is: Don't do that. Seriously. It's not fixed,
Mladen,
See my post from yesterday in another thread on
raising the BHR.
;)
Jared
"Gogala, Mladen" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/08/2002 01:31 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
What values are set for SQL*Plus variables arraysize and copycommit?
Maybe adjusting those wwould eliminate the fetch out of sequence error.
> Kevin Lange wrote:
>
> Sorry for the lack of info. Her it all is:
>
> 1) I have tns entries on both database machines that point to each
> other.
Title: RE: missed Anjo's webcast..
Sorry
hit the return too quickly, Resuming
and
select a.aid, a.chnum, f
from rollup a
where a.effdt=(select max(b.effdt) from rollup b where
a.chnum=b.chnum)
Admittedly they are d
What version of Oracle are the two databases? There are bugs with desc
over db_links (can't remember the details but see it often), and also
with copy 'fetch out of sequence' errors between 8.0 and 8i databases.
> Kevin Lange wrote:
>
> Sorry for the lack of info. Her it all is:
>
> 1)
On 2002.08.08 18:04 Cary Millsap wrote:
> I agree wholeheartedly with your "no such thing as an 'overall system'"
> comment. That is key. For the record, my view on this general topic
> includes the following observations:
>
>
>
> * If you have a really high database buffer cache hit ratio (>
I try to read date/time from times_tamp column in my oracle database but I
could not read it using SQL query. Is it a way to resolve it?
SQL> select time_stamp from user_activity_log;
TIME_STAMP
--
1.0220E+12
1.0220E+12
1.0220E+12
1.0220E+12
1.0220E+12
1.0220E+12
1.0220E+12
1.0220E+12
Hello Listers,
We have two t1 lines between two of our sites and facing some network performance
issues.
other than basic tools like tracert, do ull know about any network monitoring tools
specific to t1 line issues.
thanks
Mandar
--
Please see the official ORACLE-L FAQ: http://www.orafa
Title: RE: missed Anjo's webcast..
Sorry
for the lack of info. Her it all is:
1) I have tns entries on both database machines that point to each
other.
2) I have global_names set to false on both machines.
3) I have the same ID defined with the same password on both
machines.
I like how you think
-Original Message-
Sent: Thursday, August 08, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L
Bill,
Pull out the big cannon and go boom:
export the CREATE USER to create_user script
write a script containing:
DROP USER uname CASCADE;
@CREATE_USER
run t
Is it possible the db_link on B is public, while A is private?
> Kevin Lange wrote:
>
> Does anyone know the most common reasons why a DB LINK would give me
> the following error :
>
> ORA-02019: connection description for remote database not found
>
> Both databases exist And even t
Kevin - You might be specifying a database link that doesn't exist. The
connection string in the database link might be incorrect. The database link
might be owned by a different user and not be public. Do you receive this
message consistently every time you attempt to use the link, or is it
inter
Paula - I agree. I reviewed Quest's SQL Expert about a year ago and was also
disappointed. The advice it gave seemed pretty shallow. It didn't seem to
suggest some of the newer Oracle features, for example. We didn't buy it.
Cherie - Thanks for the tip on SQL*Expert. Can you give us the ballpark
Hi Cary,
This comment made me think. I agree in most cases, but what about a very
small DB situation where the buffer cache is larger than all the tables and
indexes combined (~300MB)? This is for a 3rd party tool of which we have no
control over the SQL. I sized the buffer cache as a guesstim
Title: RE: missed Anjo's webcast..
1) are you using global_names = true? do the link
names match the global names?
2) is there a local tns entry on the machine with
database A that points to database B? we had a problem like then that was
traced to our using Oracle Names without loc
Jared:
I had originally developed this so that I could eventually alter it to just
drop certain parts of the schema (PK's, Unique constraints, etc.) based on
input values, although I never did that.
I suppose I could drop tables first with the cascade constraints clause, and
then drop all other
Dennis:
>> I assumed the same as you, that RMAN writes its most
>> recent information to the control file as well as the catalog (there is a
>> retention parameter, so watch that).
This should be the case. The current database control file should always be
current (assuming you
have not used an
Bill,
Pull out the big cannon and go boom:
export the CREATE USER to create_user script
write a script containing:
DROP USER uname CASCADE;
@CREATE_USER
run this new script.
have beer.
Now of course, this will not be as fast as a parallel
DROP TABLE user.tab CASCADE CONSTRAINTS, but hey,
Cool. And, as a bonus, sysresv will let you know if your SHLIB_PATH (HP/UX)
is defined incorrectly! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: [EMAIL PROTECTED
Title: RE: missed Anjo's webcast..
Does
anyone know the most common reasons why a DB LINK would give me the following
error :
ORA-02019: connection description for remote database not
found
Both
databases exist And even though I get this error going from
Database A to Database B,
Title: Internal Password
Thanks for your response Kevin. We use NT. I can sign on without using a password
as well, but I do not want to be able to.
Today I did found that commenting out an entry in
the SqlNet.ora file will force the need for a
password and this is how I resolved the p
It's like a cartoon I've seen in a french IT magazine.
On the first slide there is the IT director bragging
about it's huge mainframe to track the lost luggages
across all airlines.
In the next slide, you see the fresh new employee just
hired from school who says I just develop on my laptop
a pr
The "-mtime" functionality of find is known to have issues.
i.e. it's broke.
Jared
"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/07/2002 09:31 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Su
>> "It was a business decision. Our system is only 2
>> million dollars, and theirs is 11 million, so we're
>> going with theirs."
I think more than one manager needs to go back to accounting 101 and
understand the concept of "sunk cost" and making decisions ignoring
sunen costs.
RF
Robert
Give Walt time...he'll figure a way to make it off-topic...
Oops, I think I just did it...
-Original Message-
Sent: Thursday, August 08, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L
Just to clarify, this topic is definitely ON topic.
Jared
YTTRI Lisa <[EMAIL PROTECTED]>
Title: RE: missed Anjo's webcast..
I agree wholeheartedly with your “no
such thing as an ‘overall system’” comment. That is key. For
the record, my view on this general topic includes the following observations:
* If you have a really high database buffer
cache hit ratio (>99%), then y
Funny you should post those links to day Lee, as I was just
looking at them earlier.
Did anyone else notice that there are still apparently programmers
that didn't learn anything from Y2K?
Jared
Robertson Lee - lerobe <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/08/2002 02:43 AM
Pleas
Title: Internal Password
What
OS and version of Oracle are you using? On unix systems, the presumption
is that only authorized personnel (DBAs and Sys Admins) can connect as the
oracle user. Only the oracle user can connect internal. If
unauthorized personnel have the oracle password, cha
Title: RE: missed Anjo's webcast..
First,
I didn't see the broadcast. I believe the claim that a high BHR may
not indicate a healthy system, has become it is always indicative of
an unhealthy system.
Egad,
by BHR is over 90% and no users are are complaining, I better start
tinkering!
Just to clarify, this topic is definitely ON topic.
Jared
YTTRI Lisa <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/08/2002 01:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Async I/O - slig
Bill,
Wouldn't DROP TABLE CASCADE CONSTRAINTS be easier,
or do you have some particular reason for doing it this way?
Jared
"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/08/2002 11:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
Ok, this is kind of off topic, but it does have
Oracle in it at least once.
I just couldn't resist sending this to the list.
How many of us have had an experience similar to this?
I've had at least two I can think of.
The worst was after a merger, and we went with the
other companies more exp
Anjo - The way that I would put it is that the operating system (any
multitasking o.s.) must make a decision on which process to give which
processor next and for how long. It is more complex than the o.s. just
picking the highest priority process from the run queue (processes that are
available t
The fact tables were partitionned with hashing than
range.
The volumetry was "supposed" to be huge and there was
no data purging in the architecture.
The range partitionning was done on a protein batch
number or something like that.
--- Jack Silvey <[EMAIL PROTECTED]> a écrit : >
interesting
I think you've hit on something here Ethan. Obviously, there are two ways of dealing
with bad performance. Either tune the system to perform better or tune the users so
that they don't complain 8-)
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of Oracle you get OLE! What
Title: RE: missed Anjo's webcast..
I think I will side with Anjo on this one, if my users
are happy with 1 second response times and 99.9% of the data is coming completly
through PIO that is fine with me. Of course that is an exageration but you
get the point. Keep the customers happy and w
I started working with Oracle 6.0. Back then, the BHR was one of THE
standard ways of looking at performance issues, and even all the Oracle
books back then recommended it. Low BHR, increase db_block_buffers. This
was what was followed. I admit, I did it too. Then came Oracle 7.3 and
Oracle 8 wh
A script which I have inherited is supposed to run in a cron job.
In order to set up the oracle environment variables it calls
/usr/local/bin/oraenv. This script gives the following error
osh [-l]
: Error 0
What is osh, why am I getting this error, and what is the workaround?
It's the direction that Oracle is taking in the BI
field also a manager in the Oracle BI group told me a
few months ago.
--- Greg Moore <[EMAIL PROTECTED]> a écrit : > The
main item of interest in the interview is his
> answer to the question,
> "What's your next move?"
>
> He talks about
Hi Sinardy,
Here is a snippet from a korn shell script I wrote a couple years ago that may explain
your confusion -- NDX is the parameter I pass to the find command:
# find uses the concept that +n means more than n days 23 hours
# and 59 minutes. This statement adjusts to th
The main item of interest in the interview is his answer to the question,
"What's your next move?"
He talks about Oracle's application suite, saying one choice is to buy
Siebel for sales force automation, Epiphany for marketing, SAP for
accounting, etc., comparing this to building a car by bu
Guess what Chris,
... I have saved the stats and there are less than 10% of the rows where
there is any difference in the stats in various columns. Most of the time,
the difference is about less than 5%.
Is that good enough to throw off the optimizer??
Thanks
Raj
___
Raj,
(scratching my head) I haven't really thought about this (actually I dont
think, too old), but I believe NULL would be considered a "value" and
therefore the default doesn't kick in. Don't know, perhaps someone else can
confirm/deny this. If true then I would recode the procedure call to
s
Howdy,
I attended a seminar on Oracle data compression in version 9.2 this morning. There
are no web-based handouts to look at. However, there are a few items on it that may be
of interest:
Data compression is based on duplicate fields
Compression is only done on direct operations ( for ex
You do dd if=/dev/async of=/dev/null
The error you expect is
dd read error: I/O error
If you get "no such device or address", then async IO is not turned on.
Mladen Gogala
Oracle DBA
Phone: (203) 459-6855
Email: [EMAIL PROTECTED]
> -Original Message-
> From: YTTRI Lisa [mailto:[EM
Thanks Chris,
I use following syntax ...
dbms_stats.gather_table_stats(
cRec.owner-- owner
,cRec.table_name -- table_name
,NULL -- partition name
,25--
Not sure if this has been mentioned some where, but it used to be that
UNIX would lower priority of processes that had accumulated a lot of CPU
time. So the Oracle Background processes would get lower priority over
time. Stopping and starting an instance will fix this again ;-)
Cary Millsap wr
I manage one db that has an obscene amount of physical IO but most of it has
to be coming from EMC disk cache (2 GB). I am not so concerned with whether
they are real reads or not ( I don't think you can know from within Oracle
can you?), my real concern is establishing a baseline then getting no
Title: RE: missed Anjo's webcast..
Well,
I guess that I disagree. Buffer hit radio does matter as one of the performance
indicators, but
certainly not the only one. Your and Mr. Milsap thesis
is that LIO also is very expensive and its cost
is far
from being negligible, so having gazillion of
Joe - I have been working on a disaster test for RMAN so we can quit doing
weekly cold backups. I assumed the same as you, that RMAN writes its most
recent information to the control file as well as the catalog (there is a
retention parameter, so watch that). I tested no catalog recovery (just the
65 matches
Mail list logo