Hi all,
I try create bitmap index with nosort
like:
SQL> select kill from emp;
KILL
--
1
2
3
4
5
6
7
8
9
9 rows selected.
SQL> create bitmap index bmap1 on emp(kill asc) nosort;
create bitmap inde
Thanks
Alex! The second method is great. However knowing what tables are
undergoing a full table scan is only a part of what's needed. One also
needs to know the size of the table; i.e., blocks up to the highwater mark,
and the statement which caused the scan in the first place. The
fi
Title: How to deregister OEM 2.2 jobs and events when agent is not available?
All,
Does anyone know how to deregister Enterprise Manager jobs and events when the Intelligent Agent is not available. I have looked on metalink and was not able to find anything of relevance.
The platform is So
Hi Gurus,
Does anyone have the unix script to monitor disk space or a certain file ?
For example, if the disk space is more than 80%, send an email to the
administrator or if the log file is too huge, email the log file to the
administrator and truncate the file etc .
Please help. Thanks.
Regds
Try to use Configuration Assistant to create Repository on Enterprise
Manager.
Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
okay, I like this one better than mine :)
--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> My favorite is the one where you come in one morning and find your
> database in the bathtub, bleeding and sedated. After taking the
> database to the hospital, the DBA tells you that one of your
> databa
oh man, mine has to be what is probably Jeremiah's as well:
the myth that Oracle doesn't write to the database files when you are
in hot backup mode
--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> I'm putting the final touches on my IOUG-A presentation (I got an
> extension
> for those who
oh man, what makes you think *I* feel all that worthy of writing books?
I am constantly aware of just how little I really know about Oracle.
My only consolation seems to be that there are lots of people out there
who don't know all that much either. And some who know less than me,
and THOSE are t
Hi,
I'm just wondering how you guys know so many undocumented Oracle parameters
and what to do with them and things like that.
Please don't answer "because we're smart" ... that would be stating the
obvious.
Cheers,
Sujatha
PS: "undocumented Oracle parameters" makes it OnT rather than a
philos
Gopal,
You sure like to play with fire... Don't you ??
Thanks for the info, though.
:)
- Kirti
-Original Message-
Sent: Tuesday, March 12, 2002 9:23 PM
To: Multiple recipients of list ORACLE-L
John,
alter session set events 'immediate trace name ADJUST_SCN level 1' bumps
t
John,
alter session set events 'immediate trace name ADJUST_SCN level 1' bumps
the current SCN By one billion. I have used this event once while recovering
a Tera Byte database where LGWR crashed and all the data files were
inconsistent.
And also there is an undocumented paramter something like
Anyone else doing seti at home? If you are interested we could setup an
Oracle
group... :-))
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
One of my approaches for resolving this issue was to ask them exactly
where they intended to build a test database to validate that bug out of
the production environment, because sometimes those bugs don't show up in
the stripped down developer database . There was also an issue of space
and
Actually, I was presented with your web site some time ago but never looked
at it...
I didn't want to be accused of plagiarism! :-) However, now that I have
turned in
my abstract, I decided to go ahead and look at it... I have many of the same
ideas
that you have... couple in there I didn't have.
> I think you can **artificially** force a database to reach the SCN to
> 0xfff. by using the event ADJUST_SCN.
> This bumps the SCN to one billion if set at level 1. So
> running them in a
> loop will bump the SCN to the max value.
> THis event generally used to bump the SCNs if there is
My favorite urban legend about oracle is that oracle is trying to cache
rollback segment extents instead of blocks. That has resulted in rollback
segments with a gazillion of small extents.
> -Original Message-
> From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 12,
Wait, need to login to my production database
-Original Message-
Gopalakrishnan
Sent: Tuesday, March 12, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Robert,
I think you can **artificially** force a database to reach the SCN to
0xfff. by using the event ADJUST_SCN.
Hey, man... don't joke. After all, that really happened to this guy who's
a friend of my brother who just happened to be related to this guy at
Oracle who was visiting a convention in Las Vegas with his old roommate
who knew this lady that had called her brother only to find out that his
wife had
I try to find some scripts (PL/SQL package) to monitor my oracle database
such as tablespace, rollback segment, etc. Does someone know a website that
has this?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat
On Tue, 12 Mar 2002, John Kanagaraj wrote:
> I believe Jeremiah Wilton presented on a similar topic at OOW.
I did do a similar presenatation, and Rachel Carmichael did a similar
one the year before. Also, Gaja has a tuning myths
paper/presentation.
Robert, you are welcome to consult my paper i
I vaguely recall a bug a little while ago that was
along these lines. Oracle failed to notice that
the predicate had been repeated, and treated
it as two predicates with an argument like:
selectivity due to pred 1 is 10%
selectivity due to pred 2 is 10%
Cross-product results in selecti
We currently have a production, system and development database here. The
system and development databases are purged periodically and reloaded with
lookup data. The developers are then responsible for entering transactional
data in both regions. I am looking to follow the same practice for
dev
Hello list:
In my cursor loop, I have an update statement, see
below. Now I need to the update only for the field (in
that cursor) that has data in it. (which means when is
null, that field will not be updated).
- Dynamic SQL can do it. But now for many reasons that
I can't use Dynamic SQL in th
Everyone, some great ideas
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Tuesday, March 12, 2002 4
Sorry 8.1.7.Release 3 is in fact 8.1.7.0.0. The Release 3 is the third
release of 8i
8.1.5 Release 1
8.1.6 Release 2
8.1.7 Release 3
If you go to Metalink and select patches you can search for the Patches
for your platform. There you will find the Patch 3 for your platform, if
it is ava
OK.
How about this one? And I quote:
"Oracle9i will be the last database..." - Chairman and CEO of large
software organization.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:w
Robert,
I think you can **artificially** force a database to reach the SCN to
0xfff. by using the event ADJUST_SCN.
This bumps the SCN to one billion if set at level 1. So running them in a
loop will bump the SCN to the max value.
THis event generally used to bump the SCNs if there is a m
> Robertson Lee - lerobe wrote:
>
> All,
>
> Following SQL runs for ages (almost 2 hours)
>
> select * from table1 addr,
> table2 pers,
> table3 lookup
> table4 cust
> where cust.customer_key = lookup_customer_key
> and lookup_address_key = addr_address_key
> and lookup.person_key = pers.person
>I'm doing Oracle Urban
> Legends. I've got
> several in my presentation but I thought I'd ask here, before
> I put the
> presentation to bed, what your favorite (or the one you find the most
> irritating) Oracle Urban legend was
Robert,
I believe Jeremiah Wilton presented on a similar to
FAM?
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Tuesday, March 12, 2002 4:31 PM
To: '[EMAIL PROTECTED]'
April Wells wrote:
>
> I got an interesting email yesterday from our Business Objects Admin...
> Anyone know why ADDING a duplicate join would make this run faster...?
>
> April Wells
> Corporate Systems
> Amarillo Texas
>
> I am trying to clean up some junk in one of the universes. Below is
Hi all,
I created one db and after OEM discovered node, that
db shows on navigator. I created another database, I
refreshed the node, the new db did NOT show; then I
deleted the old node, and did a discover again, but
the new db still did not show. Metalink suggests
refresh twice it will work,
Check MetaLink Doc ID: Note: 176129.1 ALERT: "LATCH FREE" And
"FREE_BUFFER_WAITS" Cause Performance Degradation/Hang
Problem affects 9.0.1.2 and sounds like what you're experiencing.
HTH,
david
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency Park
Regarding chattr and changing atime updates on Oracle database files...
here's the response I got from Oracle support:
-
UPDATE:
According to "man chattr":
When a file with the 'A' attribute set is modified, its atime record
My favorite is the one where you come in one morning and find your
database in the bathtub, bleeding and sedated. After taking the
database to the hospital, the DBA tells you that one of your
database's logfile groups has been removed, for the black-market
logfile group trade.
--
Jeremiah Wilton
Robert:
As you FAM, please finish early. I could use the vacation time before
the deadline to relax.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Origi
That should be patch if you got it off Oracle site. The base release is
Oracle 8.1.7.0.0. Release 3 is the approved patch which brings you to
8.1.7.3.0.
If you want further info search Oracle Metalink.
good luck.
-Original Message-
Sent: Tuesday, March 12, 2002 12:30 PM
To: Multiple
It has to be that "unless your data is all in one extent, you would
experience bad performance"
Paul
-Original Message-
Sent: Tuesday, March 12, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
I'm putting the final touches on my IOUG-A presentation (I got an extension
for those
Hi Steve. I also see your point, of course, and it's often a fine line
to tread. However, if making something well tuned were a simple case of
plugging in numbers, it would already be configured that way. Of course,
some defaults are plain silly! The reality is, and the point behind my
objections,
New Rman features in 9i make it even nicer...
Recover specific blocks, while the database and the datafile is still
available.
Automatic channel allocation.
retention policies.
restartable backups and restores.
backing up database and archivelog files in one operation
run command isn't needed in
Ron (and several people who have sent me personal emails as well),
Thanks so much. I love what I do. I'm actually taking a break from writing
right now, been at it almost 3 years non-stop, but I have a couple of
ideas that I'm brewing with Oracle Press and one with Sybex. The
economic times
I'm putting the final touches on my IOUG-A presentation (I got an extension
for those who
realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got
several in my presentation but I thought I'd ask here, before I put the
presentation to bed, what your favorite (or the one you find
Robert,
Very good response. I guess that is why some people write books and
others read books. I normally don't have time for either but I have
learned lately that you have to make time to keep up with the changes.
I have used you book to pass the Oracle 7 to 8 upgrade. The content
was complete
Hi Witold :
You should, to create an function "divide" : divide(12345/100)
result = 123.45
In ControlFile you should include the following sentence :
LOAD DATA
TRUNCATE
PRESERVE BLANKS
INTO TABLE TABLENAME
(
FIELD1 POSITION (1:20) CHAR,
FIELD2 POSITION (21:21) DECIMAL E
Can anyone tell me more about this? I have a 7.3.4 database that appears to
be doing an awful lot of parsing even though it uses bind variables.
How do I tell for sure it is doing too much parsing and is there a way to
control it assuming the app is already using bind variables?
Ron Smith
DBA
Ke
Thanks James.
OK, now I see where you're coming from... like the esteemed published author
that you are, you're wanting a complete treatise on Oracle database tuning.
:-) But my sense was that the article was merely addressing quick and dirty
tuning options or "low hanging fruit" as the author pu
I watched the WTC lights on the news last night. They said they are the second most
powerful lights. I would have to think the one coming out of the Luxor in Vegas is
#1. Their promo material says you can see it from the moon. I guess there are no
planes flying around the strip...
> -O
Thanks for the correction and for your paper
Regards,
Ed
> The parameter is really called session_cached_cursors and it doesn't actually
> reduce the soft parses - it just decreases the serialization overhead of
> repeated soft parses within the same session. It's all in my paper on OTN.
>
> T
Hello
There are few numeric formats when you load data from a file. I am
looking for a way, if possible, to load a number from a field that doesn't
have the decimal point.
For example I may know that in my five-character field the first three
characters always represent the most-significant d
I wonder if any Oracle database has ever yet experienced an absolute SCN
wrap??
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original
Ron,
I have one DBA lined up to ask that same question for the next 6 months for
that
very purpose. I have an opening on September 27th, would you like to take
it??
My personal rule is that I don't just fashion a message that will
shamelessly plug
my book, in and of itself. For example I would
This query was totally customized for our production database.
We run this query every 2 secs
This is querying the main knowN events which causes sometimes the database
to freeze
especially the latch free wait you can customize it as you want.
the format comes out like below
SIDEVENT_WITH_
Why are you saying "FROM" is missing? It is there...
Regards
Rafiq
FROM X$KSUSECST
> s,x$ksuse u
> WHERE KSUSSOPC IN(2,12,94,95,144,75,145,146,91) and
> bitand(s.ksspaflg,1)!=0 and bitand(s.ksuseflg,1)!=0 and s.ksussseq!=0
> and u.indx=s.indx
Reply-To: [EMAIL PROTECTED]
To: Multiple recip
At 08:03 AM 3/12/2002 -0800, you wrote:
>Another good one, and I *think* at a more reasonable cost than ERWin is
>ERStudio - www.embarcadero.com
i use this one and really like it.
>-Original Message-
>[EMAIL PROTECTED]
>Sent: 12 March 2002 14:29
>To: Multiple recipients of list ORACLE-L
Robert,
Shame on you for the "plug". Did you ask Ashoke to post the message so
there could be some saving grace distributed for the 9i upgrade
shortcomings?.
Yes, I have the book and find it very informative. It is nice to
know that there is an 8i to 9i upgrade book available. I have not see i
Thanku Brorn
-Seema
>From: Bjørn Engsig <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: SOFT PARSE RATIO?
>Date: Tue, 12 Mar 2002 10:13:44 -0800
>
>The parameter is really called session_cached_cursors and it doesn't
>
It's a beautiful query which only misses "FROM" clause. I'll save it
for later use. Much later.
> -Original Message-
> From: Arun Chakrapani [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 12, 2002 10:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: DB freezes ... no ind
There is something similar in Kansas City, MO. A church designed by Frank Lloyd
Wright (on the Plaza) has a shaft of light projecting straight up from the
roof. The shaft of light was part of the original design by FLW. However, at
the time, the lights required to achieve the intensity and cohe
Are you sure your query able to exclude partitions?
Another thing to consider is not only query performance, but table maintenance. It is
much easier to drop a partition than it is to delete x million rows. Partitioning
definitely improves query performance and table maintenance for us (360+
This is *so* typical.
SA's tend to live and think in isolation.
Sometimes all it would take is a short email.
Like last fall, when our SA decommissioned my dev server
without discussing it with me first. :(
Jared
April Wells <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/12/02 06:33 A
The +0 does disable the indexes and I agree with Iain I do not know why you
would disable them here.
Rick
"Nicoll, Iain
A high transaction database, such as those at amazon.com
Jared
"Hand, Michael T" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/12/02 08:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Li
The parameter is really called session_cached_cursors and it doesn't actually
reduce the soft parses - it just decreases the serialization overhead of
repeated soft parses within the same session. It's all in my paper on OTN.
Thanks, Bjørn.
On Tuesday 12 March 2002 14:58, you wrote:
> Seema,
I
assume you are using Rules based optimizer and not the Cost based. In the Rules
based world the structure of the SQL statement effect the path the optimiozer
chooses. The second statement differs from the first in three ways, first the
FIRST_ROWS hint, second the table1 addr is moved to th
Try Amazon
Oracle 8 to 8i Upgrade Exam Cram (Exam: 1Z0-020)
http://www.amazon.com/exec/obidos/ASIN/157610737X/qid=1015956097/sr=8-1/ref=sr_8_7_1/104-0428629-4654355
Also
http://studyguides.cramsession.com/cramsession/oracle/Oracle8iupgrade/default.asp
-Joe
--- "Mandal, Ashoke" <[EMAIL PROTECT
If your queries are using indexes, then 2 million rows will be no problem to
Oracle even without partitions.
Jim
-Original Message-
Darren
Sent: 12 March 2002 17:45
To: Multiple recipients of list ORACLE-L
We are in the process of deciding whether to purchase a license for the
partitio
I just happen to have a book published by Coriolis called the Oracle 8 to 8i
Exam Cram Guide...
You can find it on Amazon, bookpool, etc...
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's
Hi Steve,
>
>
> > The author is also misinformed about the workings of the
> log buffer,
> > and
> > the interaction of Oracle blocksize with the filesystem block size.
>
> I didn't see any discussion of this in the article. ?
This is two separate issues: a) log buffer - this was discusse
Lee,
The +0 looks bizarrely like the old trick to stop indexes being used though
it would appear that here you wouldn't want to do this. Have you got the
explain plans and what version is it?
Iain Nicoll
-Original Message-
Sent: Tuesday, March 12, 2002 4:24 PM
To: Multiple recipients
We are in the process of deciding whether to purchase a license for the
partitioning option of Oracle.
We are developing a data warehouse, with our largest tables being approx 2
million rows and about
300 Megs in size.
We have setup two tables, a standard table ( < 2 million rows) and a
partiti
HI ALL,
I WAS LOOKING FOR 817 & PATCH3 FOR 817 BUT THE ONLY THING WHICH I FOUND WAS
817 RELEASE3 IS THIS MEAN 8.1.7 PATCH3 OR NOT?
I HAVE HEARED FOR UPGRADING FROM 8.1.6 FIRST INSTALL 8.1.7 THEN UPGRADE IT
TO PATCH3 BUT I DON'T KNOW WHERE CAN I DOWNLOAD PATCH3.
THANKS
Hamid Alavi
Office 818 73
That is whats happening, e.g. i have (cut down),
create view all_data as(select swname ,business ,org,waf
from licence l,business b, organisation o,wafs w where
l.id = o.id (+) and
l.wafid = w.id (+)
etc.
How can i get around this ?
sorry for the inconvenience. It was more an informational... have you seen
it before... not tell me what the error stack didn't tell me. You will see
that it has since been resolved.
-Original Message-
Sent: Tuesday, March 12, 2002 8:18 AM
To: Multiple recipients of list ORACLE-L
Hi
You can have multiple outer joins in the where clause but one table
can be outer-joined to one other table only.
For example you can write:
select tb1.col_1
from table1 tb1, table2 tb2, table3 tb3
where tb1.some_col = "some value"
and tb1.col_a(+) = tb2.col_a
and tb2.col_b(+) = tb3.col_b
but
Ok Jeremiah,
I'll warrent that Redo sequence# is a uneven measuring stick.
Longest since last restart - 6/22/01
Oldest - 7/24/96
Highest SCN- a pokey 366 802 309
What kind of environment gets you to a 13-digit SCN?
Mike
-Original Message-
My stats:
All,
Following SQL runs
for ages (almost 2 hours)
select * from table1
addr,
table2
pers,
table3
lookup
table4
cust
where
cust.customer_key = lookup_customer_key
and
lookup_address_key = addr_address_key
and
lookup.person_key = pers.person_key
and rownum <
1000;
when this is chang
And how would I interpret the output of this query?
Thanks Arun
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any
Another good one, and I *think* at a more reasonable cost than ERWin is
ERStudio - www.embarcadero.com
-Original Message-
[EMAIL PROTECTED]
Sent: 12 March 2002 14:29
To: Multiple recipients of list ORACLE-L
I have not used many but ERWIN in a very good modeling tool. I am not sure
Go
Greetings All,
Could you please send me the name & author of the books, or any sample questions for
Oracle 8i new features upgrade test.
For 7.3 and 8 upgrade tests, I used DBA Certification Exam guide by Couchman and it
was helpful.
Thanks,
Ashoke
--
Please see the official ORACLE-L FAQ: ht
> The author is also misinformed about the workings of the log buffer, and
> the interaction of Oracle blocksize with the filesystem block size.
I didn't see any discussion of this in the article. ?
Could you briefly explain your understanding of the workings of the log
buffer and the interac
Better than that and even because soft parse it is
usually a problem related to synonyms. Therefore try
changing with code and using alter session set
current_schema. Also because of some problems with
v$session_longops look for notes on Metalink about
setting _sqlexec_progression_cost in 0.
Rega
Position: Oracle DBA
Location: Rochester, Minnesota
Salary Range: 65-75K- maybe more
Description:
This client company-a leader in its' field, needs an Oracle DBA to provide
database support.
This position includes support of all aspects of the Oracle relational
database product (ASE)
on primaril
Rachel,
From what I heard on NPR, they need to avoid blinding pilots and
distracting migratory birds with the lights. It was rather awesome on tv.
Please let us know how it looks in person.
Denise Gwinn
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
A
You've probably had a problem when you first opened
resetlogs. Fe., setting rollback segments that don't
exist yet. Issue a select over v$log and v$logfile to
determine which is the current redo. Copy that one to
path and with the name of the archive Oracle is
asking. Then issue the recover again
You've probably had a problem when you first opened
resetlogs. Fe., setting rollback segments that don't
exist yet. Issue a select over v$log and v$logfile to
determine which is the current redo. Copy that one to
path and with the name of the archive Oracle is
asking. Then issue the recover again
You should also try
using paths like "/data/yedek123" or "D:[YEDEK123.DATAFILES]". Database
works
much better with those
file naming conventions.
-Original Message-From: Hallas John
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 12, 2002 8:03
AMTo: Multiple recipients of list
I saw it on tv, and will be in the city tonight and hope to see it
"live"...
my feeling from tv was, the lights need to be brighter
--- bill thater <[EMAIL PROTECTED]> wrote:
> has anybody seen the tribute? what's your opinion?
>
> --
> --
> Bill "Shrek" Thater ORACLE DBA
>
This paper is rather old, and I'm not sure some of the points
are still valid, such as multiple tablespace creation. I haven't
tried it though, maybe someone already knows?
As for the fast export/import, there's another method that's
been ignored in this thread, and that is to dump your tables
If you are able to login and query the session_Wait
try using the below said query
select s.INDX
SID,u.KSUUDNAM||','||u.KSUSEUNM||','||u.KSUSEMNM||'('||decode(KSUSSOPC,2,'LA
TCH FREE',12,'ENQUEUE',94,'db file sequential read',
95,'db file scattered read',144,'LIBRARY CACHE PIN',75,'buffer busy wa
H Are these base tables or views? Have you explained both statements? Have
you looked at consistent gets and so forth.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 12, 2002 4:28 AM
To: Multiple recipients of list O
<>
Oh you are being kind I think that particular document
from
Oracle is terrible... It seems to me to be more of a "here is what you will
learn
about if you take our Oracle9i New Features class" book I was really
frustrated
during the writing of the 9i New Features book b
As I'm looking over that article in PC Mag that compares different DBs, I
noticed that the spreadsheet from their website has available Oracle clients
listed as "Any with a Java VM". And that's got me wondering.
How would one attempt to implement an Oracle client on an unsupported
platform like
thank you ...
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA.
- Origin
Yep,
That was my feeling when I first saw it too.
I think that some of the assumptions are pretty naive. Most of the people
who've replied to the article seem to say much the same thing.
A little knowledge ...
Mike
-Original Message-
Sent: 12 March 2002 13:58
To: Multiple recipients of
Thanks john,
The dbms_job has problems on 9012, so I am switching to good old cron ...
basically I don't have the statpack info at all ... but I am starting it at
10am today.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Ja
Sorry... our SA just fessed up... he changed the UID for Oracle on the OS on
the same day we started the Financials install... but forgot to bounce the
listener, and forgot to tell anyone.. but we are now consistent with
Production UID for Oracle... which is really all that matters, right.
Anyway
Thanks Stephan,
No it is not a problem with archiving at all, the filesystem assigned for
archiving has may more GB of space than it needs.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
Now thats assuming Oracle's migration utility works :-) I always prefer exp/imp for
upgrades, much cleaner. But will have to trust Oracle's migration utility for the 1TB
db upgrade from 8.1.7 to 9i.
Gene
>>> [EMAIL PROTECTED] 03/12/02 07:58AM >>>
If I moved one database to a higher version I
I have not used many but ERWIN in a very good modeling tool. I am not sure
Go to http://www.infogoal.com/dmc/dmcdmd.htm This will provide you with
tons of Data Modeling Resources.
Rick
When your database freezes can you log in as internal thro svrmgrl and see
what is happening on v$session_Wait
-Original Message-
Sent: Tuesday, March 12, 2002 9:19 AM
To: Multiple recipients of list ORACLE-L
Thanks john,
The dbms_job has problems on 9012, so I am switching to good ol
1 - 100 of 140 matches
Mail list logo
