Dear All,
Jesper from the Copenhagen Business School got this crazy idea some
weeks ago, and with input from Michael Mller of Miracle A/S, it's my
proud honor to present the World's first Oracle-based RAID-F Simulator.
It's all fun and games, of course, and Jesper got inspired after reading
Well, I guess I could have added a :) after my request on how
to fix the hit ratio, but it wouldn't be nearly as much fun.
On Sun, 2003-12-21 at 03:29, Mogens Nrgaard wrote:
Ah yes, you could introduce heuristically (spelling?!) skewed hit
ratios. As Dave Ensor explained at UKOUG, the word
Hi,
I did something similiar before. It cound be meaningful in some case.
My database was io-bound and top wait event was log file sync. It can because of
too much commit, I asked business guys and according to there data and business logic,
there cound't be so much transactions. I
What's the bug relating to 1,000s of Partitions,
was it the one to with monitoring, or something
more interesting ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T.
hi,
were they any problem installing db 817 in redhat linux es 2.1?
wat are they and how to go about it?
thanks .
Best Regards,
Grace Lim
Suy Sing Comm'l Corp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services
Thats why I carefully wrote:
opportunity for benefits
as opposed to
benefits
:-)
--- Mogens_Nørgaard [EMAIL PROTECTED] wrote: It's
the Best of Breed versus One Vendor debate, and
there are pros and
cons galore.
The perfect scenario, of course, is when they
combine, so one vendor
LOL!
Just to add my 2c worthI think you can get a
simpler XOR implementation with:
CREATE OR replace FUNCTION bitor( x IN NUMBER, y IN
NUMBER ) RETURN NUMBER AS
BEGIN
RETURN x + y - bitand(x,y);
END;
/
CREATE OR replace FUNCTION bitxor( x IN NUMBER, y IN
NUMBER ) RETURN NUMBER AS
I don't think you should be playing with this
and having fun when you could use the valuable
Christmas period for rebuilding all your indexes.
NB Joke
But since it's Oracle 9.2 that gets mentioned
how about trying the new bit functions:
select sys_op_rawtonum(
sys_op_vecxor(
Hallo all of you,
Is there anyone whom could help me with the unix command how to find all rows , that
doesnt exists try in a file.
I mean how to find all rows which doesnt have the characters try in.
Maybe this is too simple, but would appreciate anyone whom could give me some quick
help.
grep command will help you or you could venture to the
sed command. grep is probably the most used unix
command. To learn more, man grep .
[EMAIL PROTECTED] 12/22/03 07:54AM
Hallo all of you,Is there anyone whom could help me with
the unix command how to find all rows , that doesnt exists
Hi,
You can use
the grep command in the following manner:
grep -v try filename
The option -v negates the
search pattern, meaning rows which do not have a try string in
them.
The string can be
enclosed in double quotes as well, this is useful if you are searching for
multiple
Title: Upgrading to Oracle 9.2.0.4 - Any pitfalls?
Jones,
ORA-04031 may arrise if
DB_CACHE_ADVICEparameter isON/REDDY , and SHARED POOL is unable to
allocate the memory required for the advisory. This may be resoleved by
increasing SHARED_POOL_SIZE or putting the DB_CACHE_ADVICE=OFF.
Hello list, I am using 9.2.0.1.0 enterprise edition on windows.
Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release
1
I would get the following messages in French
c: sqlplus
Entrez le nom utilisateur :
But now when I specify nls_lang=French_France.US7ASCII , sqlplus
I decided to play around with ASMs and use the statspack tablespace as my trial
balloons(lots of inserts and deletes and I dont care about fragmentation).
anyway I just ran SPCREATE. Wierd thing is that there is no data in any of my
statspack tables, but their segments sizes vary from 1m to
hmmm... odd
there is no setting for pct_used on tables, but different settings for percent free.
Different settings for initial extent to between tables.
anyone have more info on how this 'intelligent' algorithm works? I heard kyte speak
last week and he assured us that the algorithm is good
Yeah. I noticed that too and wondered about it. The script that was posted
was, in fact, the script that was run. Maybe same kind of line length
limitation?
-Original Message-
From: Yong Huang [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 20, 2003 2:24 PM
To: Multiple
ignore spcreate.sql actually puts pctfree,pctused, and really bad initial and next
extent settings on the tables. its an antiquated script that hasnt been updated.
my bad.
From: [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 09:09:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL
Title: Exporting a partition with transport tablespace
Hi list,
is it possible to export a partition with the transportable tablespace feature ?
My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec
Title: RMAN - the time has come
Okay,
its time to bite the bullet ... time to learn RMAN.
Outside of TFM (which I just started reading), are there any good books/articles on RMAN? I know there is one by RFreeman, and it is for 9i (Robert, will there be a 10g version?)
Yeah, I am also
Title: RMAN - the time has come
Raj,
It
really is a quick learn. The best way is to get some scripts (great
examples in the rdbms/demo directory) and try them on a test database.
Once you get something running, the rest is simple. If you need some
samples, let me know. It's really basic
transportable tablespaces need to be totally self-contained. everything that is being
transported has to be in that tablespace. it doesnt matter if its a different
datafile.
you probably have your partitions in seperate tablespaces? or am i wrong?
From: NGUYEN Philippe (Cetelem) [EMAIL
As a friendly reminder, when debunking myths, I suggest we keep sober and never
go overboard. The recently popular formula to get an arbitrary hit ratio is not
what a database in normal usage naturally gets. Unless a mischievous developer
plays a prank, hit ratios are still useful to some extent
wait or are you just trying to transport 1 partition?
i think you have to do regular export and import.
From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 10:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Exporting a partition with
Last month Oracle Support said there would be a 92045 in Janauary 2004 .
-Original Message-
zhu chao
Sent: Sunday, December 21, 2003 11:49 PM
To: Multiple recipients of list ORACLE-L
- Found word(s) to be removed remove list error e-mail in the Text body.
At lease 9.2.0.5 will be
Hi, Gregory,
I only have access to Oracle 9.2 on my laptop. Here's my test. I have ORCL and
AUX1 databases, the latter created by RMAN DUPLICATE some time ago. I logon
AUX1 as SYSTEM. Set SYSTEM password hash value to the same as in ORCL. Create
link L to ORCL without password. Selecting from a
Title: RMAN - the time has come
In addition to the Freeman book, I would also
suggest the RMAN Pocket Reference from O'Reilly. It predates the RF book and
certainly comes handy for learning - I learned from there.
HTH.
Arup Nanda
- Original Message -
From:
Jamadagni,
Title: Message
To all 9i DBA's.
I am
trying to find out how efficient (or not ) is the option of running dbms_stats
with dbms_stats.auto_sample_size.
Reading metalink I see a lot of issues with the time it takesto
run, and also that sample_size column is always equal to
num_rows.
Would
Title: Exporting a partition with transport tablespace
No it's not. However, you could simply exchange the
partition with a table and then export the tablespace.
For instance,
ALTER TABLE HISTO_DOSSIEREXCHANGE PARTITION
part1 WITH TABLE HISTO_DOSSIER_part1;
Then export the tablespace. Make
Your answer was better than the answer I got from SUN support.
Thanks and Happy Holidays.
At 09:43 PM 11/27/2003 -0700, [EMAIL PROTECTED] wrote:
It's hard to explain this better than the man page. It's short sweet and 2
the point. But alas, I'll try anyway.
Define RAM -
Title: RE: Exporting a partition with transport tablespace
Yes, my partitions are in separate tablespaces
so do I have to export all the tablespaces concerned ?
wich solution do you use ? each partition is over 8 Go so should I use common export command to backup only one tablespace ?
My BCHR is currently 96.62%. In the past, it was normally over 99%. What
should I do?
I'll be waiting for Mladen's reply... :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original
But I thought this was the perfect opportunity for Miracle to fill any
perceived gap in support? :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
-Original
i dont think many people are using bchr anymore. I think its been talked down to
death. only place I hear about it is offshore. people still using the old niemic book.
his new took all that stuff out.
or am i wrong?
From: Jesse, Rich [EMAIL PROTECTED]
Date: 2003/12/22 Mon PM 02:14:26 EST
The datafile for our rollback segments gre huge because of an improper
setting. Even setting optimal and shrink, etc., won't help because the
segments are scattered. Do I have to create a new tablespace? Can I change
the datafile a rollback segment writes to and then take the other offline?
The
CLASSIFICATION: UNCLASSIFIED
I have been off on a brand new program for a couple months now and haven't
really been working with Oracle all that much. That will come later.
Doing alot of prototyping in Perl and Mysql (gag) for this big project.I
let everyone know that once the terabytes
CLASSIFICATION: UNCLASSIFIED
Rich,
Burn any source that talks about hit ratio's.
What exactly is running slow in your system and at what times ?
Talk directly to the user that is experiencing the slowdown and ask them
to repeat the behavior.
Set a 10046 trace and go find the slowdown while
My estimate right now is about a 500GB instance(but could grow). There are several
complexities.
1. high transaction system, but also will have alot of long running queries
2. We deliver data daily and rebuild large parts of the database nightly with loads.
Im not certain I have the window to
At 11:14 22-12-03 -0800, you wrote:
My BCHR is currently 96.62%. In the past, it was normally over 99%. What
should I do?
I'll be waiting for Mladen's reply... :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex,
-Original Message-
Mogens Nørgaard
Sent: Sunday, December 21, 2003 10:14 PM
To: Multiple recipients of list ORACLE-L
It's the Best of Breed versus One Vendor debate, and there are pros and
cons galore.
The perfect scenario, of course, is when they combine, so one vendor
delivers the
Erm...sorry. I said :) when I should've said ;). Joke. Pun.
Tongue-in-cheek. Yer built too low. The fast ones keep going over
your head. Gotta keep your eye on the ball. Eye. Ball. That's
a joke there, son.
Again, sorry. We're in no change mode until after the Holidaze and
Foghorn
Title: RMAN - the time has come
Try Robert Freeman's
book. I have only heard good things about it.
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni,
RajendraSent: Monday, December 22, 2003 10:35 AMTo:
Multiple recipients of
Title: STATSPACK interpretation
We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on
AIX 4.3.3. The cause of the crash was 4031 errors generated by background
processes (Oracle support has confirmed there is a bug involved), however,
since that crash occurred, a
Rich,
you mean due to 'no change mode' you can't even change your hit ratio ... too bad.
Happy holidays everyone !!
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
There is no need to drop the datafiles, just recreate the segments in the
current tablespace.
Pick a slow time to do this as you will significantly increase the likelihood
of 1555s.
1) Offline rbs1
2) Drop rbs1
3) create rbs1
4) Repeat steps 1 - 3 for all rbs2..rbsN.
5) When complete, resize
Title: Exporting a partition with transport tablespace
You could create new table in
transportable tablespace, exchange data with the partition you want to export, move
transportable tablespace file to the destination system, exchange data back
from the table into desired partition.
Daniel,
Thank-you very much for your clear answer. Very helpful. When a RBS is taken
off-line, does it transfer the rollback information to another segment?
Thanks,
Mike
-Original Message-
Sent: Monday, December 22, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
There is no
We have talked about a 10g version of the book, which I'm sure will happen
at some point in time :-)
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/22/2003 2:39 PM
Try Robert Freeman's book. I have only heard good things about it.
Ruth
Inline...
[EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There are several
complexities.
1. high transaction system, but also will have alot of long running queries
Hello, 1555s! I think you will be plagued by these, even with a high number/size
Mike,
When an RBS is taken offline, the undo information is not transfered to another
segment, hence the need to perform these actions at a quiet time. When an rbs
is taken offline, all transactions currently using the rbs are allowed to
complete (either commit or rollback). As these transactions
At 13:14 22-12-03 -0800, you wrote:
I think you are on the right track. If you can turn on tracing with a
logon trigger, you should be able to get some/most(?) of the sql and the
order in which they are performed. Strip out the extraneous info and you
have a test script. James Morle of the Oak
Daniel,
Thank you again. That clears it up even more. I'll wait for a quiet time and
then proceed.
Mike
-Original Message-
Sent: Monday, December 22, 2003 2:19 PM
To: Multiple recipients of list ORACLE-L
Mike,
When an RBS is taken offline, the undo information is not transfered to
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 22, 2003 4:14 PM
Inline...
[EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There
are several complexities.
1. high transaction
see my responses below...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 22, 2003 4:14 PM
Inline...
[EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There
are several complexities.
Hi.
I'm getting ora 6000 error with the kdibc3position
argument in a prod DB. I have read some information on
that issue on the metalink, but the only workaround
that I seem to have found was to drop and rebuild
the bitmap indices on the table. I couldn't see any
info as to how to prevent it in
Title: Delete vs. truncate to free up spaces.
I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I could not use truncate to delete ALL records in table as I
This is one of the cases where a partitioned table can be of great use. What version
of Oracle? Standard or Enterprise Edition?
With a partitioned table you can say
alter table ... drop partition ... ;
to easily get rid of a large chunk of data and release the space.
See
Oracle9i Database
you can also do the following:
1. create table as and copy just the records you want to keep.
2. Drop the old table
3. rename new table to old table
4. re-create the indexes. if there are alot, issue them as jobs and do it at
the same time.
- Original Message -
To: Multiple recipients
Nguyen, David M wrote:
I am using delete command to delete million records in several tables
to free up space in tablespace. I understand delete command does not
release unused spaces as truncate command but I could not use truncate
to delete ALL records in table as I need to keep one
Environment:
DB1: RH 8.0 with Oracle EE 9.2.0.4
DB2: Win2k SP3 with Oracle EE 9.2.0.1
SYSTEM user on each database initially have different passwords.
It goes something like this:
DB1:
select password from dba_users where username = 'SYSTEM';
Let's say the result is 'AC424SDK4398'
DB2:
What is taking place inside GENERATE_PRODUCT_KEYS() ?
Could be dynamic SQL of the worst kind in there. That
is, not using bind variables.
A 10046 trace level 4 or 12 will show you what is
going on there.
Jared
On Mon, 2003-12-22 at 12:39, Thomas Jeff wrote:
We recently experienced a crash on
I would say it is like chess.
Learning how the pieces move is easy.
Learning to put it altogether and use and manage it
is not quite as simple. There are a lot of nuances
to RMAN, and I don't pretend to have a handle on it.
Yet.
Jared
On Mon, 2003-12-22 at 08:04, Mercadante, Thomas F wrote:
Since you are on 9i, have you considered monitoring the tables?
( alter/create table monitor )
This would reduce the need to collect statistics so often.
Jared
On Mon, 2003-12-22 at 12:19, [EMAIL PROTECTED] wrote:
My estimate right now is about a 500GB instance(but could grow). There are
... and if your table is not partitioned, consider using
'CREATE TABLE AS' with WHERE clause that eliminates the
rows you wish to delete, recreate indexes and constraints
on the new table, drop the old table, rename the new to
the old.
Keep in mind that stored procedures and triggers that
It's Oracle8i Enterprise Edition.
-Original Message-
Jacques Kilchoer
Sent: Monday, December 22, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
This is one of the cases where a partitioned table can be of great use.
What version of Oracle? Standard or Enterprise Edition?
With a
And synonyms will have to be re-created. (drop and create).
Grants will have to be given. Jared Still [EMAIL PROTECTED] wrote:
... and if your table is not partitioned, consider using'CREATE TABLE AS' with WHERE clause that eliminates the rows you wish to delete, recreate indexes and
Then you should have the partitioning option. Partition your table if you can.
-Original Message-
Nguyen, David M
It's Oracle8i Enterprise Edition.
-Original Message-
Jacques Kilchoer
This is one of the cases where a partitioned table can be of
great use.
What
Because there is a lot that could be overlooked, I prefer to do it
the other way around:
create table tmp_tbl nologging
as select * from big_table where (rows you want to keep);
truncate table big_table;
alter trigger trigger_name disable; (for each trigger on big_table)
alter constraint
Imagine the banner text: Miracle A/S. The Legacy Support of Tomorrow.
Filling the Gap (jeans) like nobody else.
Thanks to Tim Gorman for inspiration. I don't recall the text completely
anymore, but he used to have this one about Building tomorrow's legacy
systems - one crisis at a time. Or
I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server.
for example this tnsping took about 270 ms which is strange and its consistent
Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION =
There's some notes on my site (www.oracledba.co.uk)
about how it goes about its work. Basically, it will
do a slightly more work than you might think - throw a
10046 trace on it and you can see how it does its job.
Cheers
Connor
--- Arnon, Yuval [EMAIL PROTECTED]
wrote: To all 9i DBA's.
I
Our middle tier opens several dedicated
connections. SQL statements are issued through these dedicated connections. If
Im running a stress test and I want to trace... what is the best method to use?
Just use a logon trigger and trace every session? then dig through it to look at
the top
Murali Vallath [EMAIL PROTECTED] wrote:
I have recently noticed in this one situation that
there is a great difference between a tnsping vs a
regular ping to the same server.
for example this tnsping took about 270 ms which is
strange and its consistent
Used TNSNAMES adapter to resolve the
Jared,
I see you log out and log back in as SYSTEM to DB2. But how do you know the
password for SYSTEM to log back in with after you change it?
What if you don't log out? When I tried that (i.e. not logging out), I got
ORA-1017.
Yong Huang
--- Jared Still [EMAIL PROTECTED] wrote:
Environment:
That works also. I guess it really depends on which
one is faster, and that is dependent on what % of the
data you are trying to remove, and how big the whole
thing is.
In any case, writing a script to generate grants is
just one more thing on the check list, not too hard
to do.
Jared
On Mon,
Paul mentioned a few reasons for this.
Another is that a ping does not get past the NIC. The
ping is answered by software running on the card. You
may have noticed at times that a ping is not a reliable
method for determining if a server is still functioning.
The OS can crash, but the NIC
Hi,
Okay. I'm almost a believer of this as a problem. How
about 9.2.0.4 on RH9.3.
1) What does anyone/everyone get for my this query (my
results shown):
connect system/[EMAIL PROTECTED];
alter user scott identified by tiger;
--
select password
from dba_users
where username = 'SCOTT';
PASSWORD
It doesn't matter which account I logged into DB2 with, as
long as that account has privileges to read DBA_USERS.
SYSTEM was used simply because it was the only account
on the database that could be logged into remotely, so
my test could be run without switching between machines.
If I had
Hi Allan ,
I couldn't get any reply from you .
Can you please mail me the docs.
I am waiting for those docs of 170 Systems.
Thanks in Advance .
Regards
Kirtish P Gaonkar
-Original Message-
Kirtish P Gaonkar
Sent: Saturday, December 13, 2003 10:54 AM
To: Multiple recipients of list
Thanks for the feedback from everyone. I'll probably upgrade to 9.2.0.4
unless there is a pressing reason to upgrade to 9.2.0.4.5 and when it
becomes available.
Apparently bug no 2921201 is showing as fixed in 9.2.0.5 in Metalink but
Oracle support gave me a date of March at the earliest for its
On RH 8.0 Oracle 9.2.0.4: F894844C34402B67
It is required that a password for a particular users always
hashes to the same value, regardless of platform or Oracle version.
This has been true for as long as I have used oracle: since 7.0.13.
If not, export/import would not be able to recreate
Yes, I misunderstood.
Once I change the password, I can no longer connect to the account.
My hasty little test was missing an important condition: I should
have pretended I didn't know the password to the other database,
which would prevent me from logging back on exploiting the db link.
Wonder
In such a case what will happen to the transactions that hit the table
(since the triggers have been disabled)?
Regards
Naveen
-Original Message-
From: Bobak, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 23, 2003 5:49 AM
To: Multiple recipients of list ORACLE-L
Subject:
8.1.7 on win2000
SQL select password
2 from dba_users
3 where username = 'SCOTT';
PASSWORD
--
F894844C34402B67
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 23, 2003 11:44 AM
Hi,
Okay.
Hi all
I am getting ORA-01555 in my database and the solution is to create
huge rollback segments but my doubt is how to calculate the size of this
huge rollback segments . Now I have 24 G of space in rollback segment
tablespace .But still i am getting the error.The
84 matches
Mail list logo