doc 111316.1 doesn't mention about using
OEM for the same.
so i hope it cannot be done with OEM.
am i right LIST ?
so how do i do it from sqlplus ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Se
--Boundary-00=_ZH8IYHI1VA40
Content-Type: Multipart/Alternative;
boundary="Boundary-00=_ZH8ITSM1VA40"
--Boundary-00=_ZH8ITSM1VA40
Content-Type: Text/Plain;
charset="shift_jis"
Content-Transfer-Encoding: quoted-printable
Mudhalvan ,
Title: Message
Prem
Please check
this Screen.. If you still have doubt please let me know
-Original Message-From: Prem Khanna J
[mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 9:33
PMTo: [EMAIL PROTECTED]Cc: Mudhalvan,
MoovarkkuSubject: RE: How to dro
--Boundary-00=_FF7IDL51VA40
Content-Type: Multipart/Alternative;
boundary="Boundary-00=_FF7I8WA1VA40"
--Boundary-00=_FF7I8WA1VA40
Content-Type: Text/Plain;
charset="shift_jis"
Content-Transfer-Encoding: quoted-printable
Hi Mudhalvan
Thank you so much, I'll get our SQL Server admin to look into your
suggestions.
Regards
Denham
> -Original Message-
> From: Grant Allen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 29, 2003 12:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: MSSQL Link Server connec
Prem..
Why don't you install Enterprise manager in any one of your
client .. Login as Stand Alone.. And you can delete the same
-Original Message-
Sent: Tuesday, October 28, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L
Guys,
it's oracle 9.2.0.3/Win2K.
say for some re
Guys,
it's oracle 9.2.0.3/Win2K.
say for some reason (NOT recovery):
i want to drop a datafile from a tablespace
which has more than 1 datafile.how to do it ?
Doc 111316.1 says u need to drop the tablespace
or exp/imp the objects in the tablespace.
your ideas please.
Jp.
--
Please see the
Check that you have the Cobol environment variable set, $COBDIR I think, set
before starting the installer. Otherwise, the installer will silently not do
anything. At least, that's how it is on Solaris.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sen
We don't have a corporate policy per se, but everything we have ('cept couple of dbs
in the dmz) is RAC. PROD/DEVL/TEST/QA/DEMO etc etc everything same size same config
(except maybe for scaled down SGA etc).
Raj
*
"Exactly" my point! ;-)
You cannot use it for anymore than that, and neither should you ignore it
completely.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 29, 2003 6:39 AM
> yes bchr is only useful at extremes, but its base
If you're interested I can send you the sample batch files and scripts I use to create
databases on Windows. I have sample scripts for 8.1.7 and 9.2
-Original Message-
A Joshi
I am using database configuration assistant to create a NT database. Is there a way
I can get the scripts use
LOL :)
-Original Message-
Sent: Tuesday, October 28, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L
Don't get me wrong, I've recently changed positions and am not interested,
but what are "phone skills"? I know how to use a phone, and I can do it in
yoga position with one hand
Don't get me wrong, I've recently changed positions and am not interested,
but what are "phone skills"? I know how to use a phone, and I can do it in
yoga position with one hand tied behind my back. I've never used a phone under
water or in space. I use it on a regular basis while commuting or
I hope I am not breaching any rules, but I would like to make
it public that I am currently trying to fill a temp to perm position for a Sr
level Oracle/customer support person in Massachusetts. This
person must have strong Oracle and Sun Solaris skills and some Java (J2EE and
Java beans) e
Hi,
I am using database configuration assistant to create a NT database. Is there a way I can get the scripts used in the creation? I clicked on the template but do not know where the template goes. Thank you
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
> -Original Message-
> From: Jonathan Gennick [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 29 October 2003 10:49
> To: Multiple recipients of list ORACLE-L
> Subject: starting/stopping DB2
>
>
> Does anyone here use DB2? I need a bit of an education on
> how to start and stop DB2 under Wi
I'm glad you had some energy left to describe your pain getting RAC to work
on Linux (specially RHAS developer).
I regret every minute of pain I spent trying to do the same!
Waleed
-Original Message-
Sent: Tuesday, October 28, 2003 6:39 PM
To: Multiple recipients of list ORACLE-L
Well,
Hi,
If it's one instance of OPS or RAC ,you should set
parallel_server=no or cluster_database=false,then 'startup mount'
,'alter database archivelog;',and you can change them back once archive
log working.
Zhai
[EMAIL PROTECTED] wrote:
Hi List,
Could someone help me to figure out what i
Does anyone here use DB2? I need a bit of an education on
how to start and stop DB2 under Windows XP. If you can help,
please contact me offlist. Thanks.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Ora
Well, yeah, I thought it was.
The detail info in the trace file will help you pinpoint th CPU usage.
Jared
Muqthar Ahmed <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/28/2003 08:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAI
Another bumper sticker seen today:
That was Zen, this is Tao.
-Original Message-
Sent: Tuesday, October 28, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
Bumper sticker sighted just the other day:
"My karma ran over your dogma"
> How about "Dogma"? That's a new movie and it
Well, we evaluated 9iRAC on some cheap-o Linux boxes as a proof-of-concept,
with the hardware idea based on
http://www.bradmark.com/site2/products/pdfs/9irac_config.pdf As far as I'm
concerned, RAC's a major pain, unstable and not yet worth the risk -- for
us. The idea for us being that we could
Depending on the query, in dba_extents example there are hints only in one
part of multi-part union all SQL, but nevertheless, good point :)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 29, 2003 1:04 AM
> If there'r
Please kill this thread, as it no longer has anything to do with DBA interview questions.
"Schilling, Ben" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/28/2003 02:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
An unusually high BCHR could be an indicator that your database
is running Connor McDonald's choose_a_hit_ratio procedure.
http://www.oracledba.co.uk/tips/choose.htm
Jared
Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/28/2003 09:09 AM
Please respond to ORACLE-L
If there're already hints like ordered and use_nl that tell Oracle how to join,
lack of statistics is less of a problem. In fact, you may need to use those two
hints in some queries against data dictionary even in pre-9i Oracle.
Yong Huang
--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
>
> Jus
Raj
Jamadagni, Rajendra wrote:
Why do you think the profsum output is not right?
I did not say that profsum output is not right/correct. I said that it
does not show what's needed to be seen.
Just imagine to run SUBSTR() you call 1 internal function, to run utl_raw
PL/SQL engine has to do a lot m
Kirti
--
I've
had that experience too. I generally start a telephone interview hopping
around the person's resume and asking questions about individual jobs... what
did they do here... what do they mean by that there what was the environment
over there... was management supportive in
Hi!
Just for the record, in 9.2 some views such dba_extents use "ordered" and
"use_nl" hints, which force usage of CBO.
If you don't have statistics calculated nor optimizer_dynamic_sampling set
to at least 2, then you'll be using CBO with default statistics, which
usually are quite misleading.
T
Better still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to him
because 'X' can answer but Y does not.
Tel.int means you (most probably) have not seen the guys face..correct??
By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains'
Title: RE: anyone have opinions on the future of the 'grid'?
Oracle
confirmed at the road show event I went to yesterday that "pricing will not
change". Let's see how many people are happy to buy 100's of EE CPU
licences :-)
And my
favourite bit? The new OEM is all singing, all dancing .
> -Original Message-
> From: Mladen Gogala [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 29 October 2003 05:44
> To: Multiple recipients of list ORACLE-L
> Subject: Re: dba interview questions
>
>
> How about "Life of Brian"? That's even better then the "Holy Grail".
You're right, Mladen
Hi, Has anyone started to implement 9I Rac as a corporate standard... IE. many or
all the apps being deployed on 9I RAC clusters?
We are looking at doing it and wanted to know what other people had as experience in
doing it or on the way to attempting it.
If so, what hardware platform are
> -Original Message-
> From: Denham Eva [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 28 October 2003 22:09
> To: Multiple recipients of list ORACLE-L
> Subject: MSSQL Link Server connection failure to Oracle 817
>
>
> Hello,
>
> To my surprise I see there alot of us on this list, use MSSQL
Bumper sticker sighted just the other day:
"My karma ran over your dogma"
> How about "Dogma"? That's a new movie and it is
> hillarious. Salma Hayek character was very impresive.
>
>
> On 10/28/2003 02:49:32 PM, "Jesse, Rich" wrote:
> > Ghostbusters?
> > "When someone asks if you're a g
Documentation writing will likely be outsourced to Elbonia. So, wait until
the little bearded men who live in the swamp write your documentation and
everything will be OK. I bet you will not be satisfied even then. You'll
make unreasonable requests and demand that documentation is actually meanin
Why do you think the profsum output is not right? at least it tells me that 83% of my
time is spent on the line that does substr() ... right?
msg_text is a clob, l_n is number you are right substr() was used because we
transfer only US ASCII data.
The point of pipelining was because in my
David,
Glad to be of help.
Looking at your list of steps, I see that your questions is whether building
an MV on the table T is beneficial. Tables and MVs, on prebuilt table or
not, are stored as segments in the database; so space-sise there is no
difference, nor there is any change in the way th
Well then eventually no one will know how to use their products and move to
other products that come with documentation sets.
: )
Patrice
-Original Message-
Sent: Tuesday, October 28, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
none of the apps have documentation. not forsm,
Hi,
Is there any performance problem if two columns have FOREIGN KEY from different tables
and both columns also have UNIQUE CONSTRAINT?
CREATE TABLE table1 (
COL1NUMBER constraint table1_fk1 references table2(col1),
COL2NUMBER constraint table1_fk
does the data dictionary still use rule by support? any idea why toad would bother
slipping it in?
>
> From: "John Shaw" <[EMAIL PROTECTED]>
> Date: 2003/10/28 Tue PM 02:59:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: ora-600 question
>
> TOAD puts a hint
Raj
I'm "in" :), so let's check what was the real issue, some more items
here...
Jamadagni, Rajendra wrote:
Thanks Vladimir ... your input has made me look at my code again ...
Here is relevant portion of profsum.sql output ...
Lines taking more than 1% of the total time, e
By default it's set to
'choose' - but if try to use it for looking at locks (or most any ddl) it will
take forever to come back - you have to go to the options menu and pick
'rule' for optimzer mode on ddl queries.>>>
[EMAIL PROTECTED] 10/28/2003 2:49:29 PM >>>
does the data dictionary still
The data dictionary should not have any statistics on them and thus will use
rule as a "rule" so to speak.
If you have run stats on the data dictionary you coul dbe running into some
odd bugs.
-Original Message-
Sent: Tuesday, October 28, 2003 2:49 PM
To: Multiple recipients of list ORAC
General
support ends Dec 31, 2004, was Dec 31, 2003.>>>
[EMAIL PROTECTED] 10/28/03 03:44PM >>>List,Is any
body know when Oracle stop supporting for 8i?Thanks,Hamid
AlaviOffice
: 818-737-0526Cell phone : 818-416-5095--
Please see the official ORACLE-L FAQ: http://www.orafaq.net-
Mike : Yes the user has select access and is able to do a select on the MLOG table and the original table. Thanks for your help.Mike Spalinger <[EMAIL PROTECTED]> wrote:
Does the user have select access on the mlog?A Joshi wrote:> Hi,> I have a table tableA owned by userA.> If I create a materializ
How about "Dogma"? That's a new movie and it is hillarious.
Salma Hayek character was very impresive.
On 10/28/2003 02:49:32 PM, "Jesse, Rich" wrote:
> Ghostbusters?
> "When someone asks if you're a god, you say 'YES'!"
> "...and the flowers are still standing."
> "Tell him abou
List,
Is any body know when Oracle stop supporting for 8i?
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
What version of TOAD, Oracle server and Oracle client? See Metalink article
34779.1 for details on your bug, which may be fixed in releases 8.1.7.3,
9.0.1.2 and 9.2.0.1.
BTW, TOAD can put in hints, but more importantly, it can do some
conversion/translation of your SQL before sending it. You may
Ah. Some time ago when running a Youth Group, I discovered that there is
only one infallible answer when faced with a 'popular beat music combo,
m'lud' that one has never heard of. This consist of nodding ones head
sagely and saying ' ah yes, but don't you think that they've gone a bit
commercial'.
Well you got a number of responses, but the following have always worked for me:
shutdown immediate;
Startup mount;
alter database archivelog;
alter database open;
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, October 28
Does the user have select access on the mlog?
A Joshi wrote:
Hi,
I have a table tableA owned by userA.
If I create a materialized view in another schema/user fast and complete
refresh set to refresh every 10 minutes then only complete refresh works
and refreshes automatically every 10 minutes.
John,
I'm not running AIX 5.1 or Oracle 9.2 (we're 8.1.6 on AIX 4.3.3). However,
I have had some strange 3113 errors when trying to start a database. Did
you have a false start and then ran the script again? The reason being
we've seen problems due to memory segments hanging around after a cras
what is your remote_login_passwordfile init.ora param set to?
Change it to remote_login_passwordfile = none
and see what happens.
-Original Message-
John Blake
Sent: Tuesday, October 28, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
The alert log statest that the instance is st
John
Check your undo tablespace name in your CREATE CONTROLFILE statement and
your init.ora file. I've received this error because the names are
different.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, October 28, 2003 2:00 PM
To: Multiple r
Hi,
I have a table tableA owned by userA.
If I create a materialized view in another schema/user fast and complete refresh set to refresh every 10 minutes then only complete refresh works and refreshes automatically every 10 minutes. However the fast refresh mv does not refresh automatically. It
The alert log statest that the instance is starting NORMAL and that is all
she wrote
No trace files all my directories exist all owned by oracle UID
The cr_spap script contains all create controlfile commands and yes since
the "STARTUP NOMOUNT" is failing
the balance is just from the echoed ou
Hi All
Can somebody explain me how to tune this corealted
subquery.how do we convert the co-related subquery
into a inline if that helps
Select distinct PA.PersonAddress_IDX, AT.Name
AddressType,
A.Line1 Address1, A.Line2 Address2, A.City, A.State,
A.County, A.Country, A.PostalCo
TOAD puts a hint in.
>>> [EMAIL PROTECTED] 10/28/2003 1:29:25 PM >>>
does toad or the oracle instance itself slip in rule hints? We got an
ora-600 error off of a data dictionary read. i think it has to do with explain
plan. ORA-00600: internal error code, arguments: [17182], [2325084336],
[],
AK
When you have RMAN back up archived logs, IIRC, in a recovery RMAN first
restores those archived logs to the location that Oracle will expect them to
be, and I believe that is done as part of the RESTORE DATABASE command. In
my situation, I found no advantage from having RMAN store the archiv
On 10/28/2003 02:34:24 PM, [EMAIL PROTECTED] wrote:
> Hi List,
>
> Could someone help me to figure out what is going on here?
> I am trying to change db from NOARCHIVELOG --> ARCHIVELOG.
Let me quote the mighty Oracle:
Database must be mounted EXCLUSIVE and not open for this operation.
Idis red
Sami
Any possibility you are using RAC or Parallel Server?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, October 28, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi List,
Could someone help me to figure out what is going on here?
I
Hi
The database must be mounted and in exclusive mode in order
to turn archiving on.
You need to do a: startup mount exclusive
then: alter database archivelog
then: alter database open
Ben
-Original Message-
[EMAIL PROTECTED]
Sent: October 28, 2003 2:34 PM
To: Multiple recipients of
Startup nomount
Alter system enable restricted session;
Alter database mount exclusive;
-Original Message-
Sent: Tuesday, October 28, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi List,
Could someone help me to figure out what is going on here?
I am trying to change db from N
Ghostbusters?
"When someone asks if you're a god, you say 'YES'!"
"...and the flowers are still standing."
"Tell him about the Twinkie, Egon."
Joe vs. The Volcano?
"Not a nice place you have here, Joe."
"I know he can get the job, but can he do the job?"
Th
Are you sure that init.ora has the same database name as the controlfile?
Bambi.
-Original Message-
Blake
Sent: Wednesday, October 29, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
SQL> @cr_spap
SQL> STARTUP NOMOUNT
pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora
ORA-0
Proud?
landing a rock to fakie followed by a fakie 360 in near vertnot bad for
a 41 yo
Nightmare?
Playing a particularly embarrasing gig with a manic dreppressive folk music
ogre, 120 minutes of pure hell in front of an audience. I refused to play
anymore gigs with him.
Do I get the job...?
none of the apps have documentation. not forsm, reports, or discoverer and noone is
writing updated books on them since they dont sell enough copees.
i dont understand oracle on this one. atleast they can write one and sell the damn
thing...
>
> From: "Tracy Rahmlow" <[EMAIL PROTECTED]>
> Date
Hi List,
Could someone help me to figure out what is going on here?
I am trying to change db from NOARCHIVELOG --> ARCHIVELOG.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination/u02/arch
Oldest online log se
does toad or the oracle instance itself slip in rule hints? We got an ora-600 error
off of a data dictionary read. i think it has to do with explain plan.
ORA-00600: internal error code, arguments: [17182], [2325084336], [], [], [], [], [],
[]
Current SQL statement for this session:
select /*+
As long as you have
the database in archivelog mode and have a level 0 backup as your starting point
then you can recover. Make sure that your level 0 includes the
controlfiles.
HTH,
Ruth
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of AKSent:
materialized views have the create statements in the database. you just have to
refresh them.
can you refersh a materialized view in parallel? if not than create can be faster...
>
> From: "David Boyd" <[EMAIL PROTECTED]>
> Date: 2003/10/28 Tue PM 12:04:25 EST
> To: Multiple recipients of list
This was my original suggestion. The only snag I can think of is if you
have a bunch of dependencies like stored procedures and triggers. Even if
somebody was selecting from the old table when you renamed it, the select
would continue OK ... as long as you don't truncate it. You could even
dele
Thanks Dennis for Reply,
My confusion is , does RMAN sees only those archived logs which are backup
using rman or it can use current archived log as well stored in original
format at other disk ?
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Se
Usually when I've seen that it's because of an invalid or missing password
file. Anything in the alert log to tell you more?
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
You can restore database and open it to the mount phase using RMAN.
Then you can get into sqlplus and type something like:
alter system set log_archive_dest_1=/directory/where/log/archives/reside
set autorecovery on
recover database auto until cancel
On 10/28/2003 12:44:24 PM, AK wrote:
> We tak
AK - Unless you specify otherwise, RMAN will automatically apply archive
logs to bring the database up to the time of failure (your recover database
statement). This is why it is good to run disaster recovery tests on a
regular basis, to ensure everything is ready, and you can try different
recover
How about "Life of Brian"? That's even better then the "Holy Grail".
On 10/28/2003 01:19:25 PM, "Thater, William" wrote:
> Bellow, Bambi scribbled on the wall in glitter crayon:
>
> > Oddly, I was thinking the same thing about Monty Python and the Holy
> > Grail. And then I thought... NAAH. "Gr
Hi John...
Actually I do not use AIX, but I used to work with 3x
and first 4x version.
I do not know if your AIX version still manages AIX
modules, but if it does, then you need to load the
modules pointed in your root.sh (or rootpre.sh) file,
I do not remember very well.
Of course, you can run
I have had the same problem. I have contacted Oracle for a "user guide" with
no response as of yet. I am literally printing off the help pages within
Designer to address the need. It sucks
10/28/2003 10:14 AM PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
T
Bellow, Bambi scribbled on the wall in glitter crayon:
> Oddly, I was thinking the same thing about Monty Python and the Holy
> Grail. And then I thought... NAAH. "Grail" is the only common
> denominator that I know of that all technical geeks have in common...
> but now that its years old, I'v
Where is the Designer 9i documentation?
Not on OTN (http://otn.oracle.com/documentation/designer.html),
not in download-east
(http://download-east.oracle.com/docs/cd/A91773_01/ids902dl/index.htm ),
not in tahiti... (http://tahiti.oracle.com )
Oracle Designer Generation seems to be the only book
Title: was: AIX 9.2 refresh
Please ignore my last replay about control file ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can h
Hi,
You DO NOT have to CLONE the databases if you are upgrading the OS from 4.3.3 to 5L.
You mentioned that the instances are already running.
IBM has break the technology at AIX 5.1.0.0, meaning the AIX 4.3.3 and AIX 5.1.0.0
have different architecture. So if you are upgrading IBM AIX 4.3.3
Oddly, I was thinking the same thing about Monty Python and the Holy Grail.
And then I thought... NAAH. "Grail" is the only common denominator that I
know of that all technical geeks have in common... but now that its years old, I've been on a quest to find another one... a
non-Star Trek one, as
We take daily rman backup each nite at 10pm . Which
means in worst case we risk one day of work. Now suppose something wrong
goes before 10 pm . Then Can I recover my database till time using previous day
rman backup and currently available archived logs.
Or in nutshell is it possible to r
Hi,
The developer was executing the SQL statement in the loop in procedure. After
re-writing the code, now the performance is good.
Thanks
Muqthar Ahmed
-Original Message-
Sent: Tuesday, October 28, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L
It's 800 sec for 5617 exec/fetc
yes bchr is only useful at extremes, but its based on interpretation. if you have a
very high BCHR, you probably have alot of very bad sql.
if you have a very low one AND are in a type of application where you should(namely
OLTP) you may want to consider increasing your buffer cache.
mladen is
Hi,
We always copy the Oracle binaries rather than installing Oracle.
Our standard Oracle copy does not contain Pro*cobol.
After reading the doc I can summarize the installation of pro-cobol this
way.
(Cobol is already installed.)
- Install pro*cobol 817
- Apply path 8172 for pro*cobol only.
It
Check to your alert log for error messages.
Maybe you haven't set your kernel parameters accordingly & your new instance
can't allocate enough resources it needs.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 28, 2003 6:
John,
Did you see any messages in the alert log? And what is in the cr_spap
script? the startup nomount is failing immediately, so everything else is
worthless.
Review the initspap.ora file and make sure that all of the directories
exist. Also, is the ORACLE_SID evironmental set prior to runni
This is how ours look like ...
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "XXX" NORESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 3403
LOGFILE
..
maybe it is that pfile line ca
Hi,
I am looking at Oracle schema for IBM's MQ Workflow and I have a table that
has an index on members of a user defined type. This index is not getting
used when it could help a delete statement. Using the 10053 trace I got this
snippet in the trace:
SINGLE TABLE ACCESS PATH
No statistics type
So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
and what do you consider "low"?
What "HR" are you talking about?
This would be the infamous BCHR:
select 'bc_hit_ratio' ratio,( sum(decode(name, 'consistent gets',value,0))
+ sum(decode(name,'db block gets', value
Arup,
I really appreciate your answer in great details. I got "on prebuilt table"
work. Thanks a lot for your help. Here is another question:
Do you see any advantage to use materialized view on prebuilt table for my
data loading over just simple renaming tables as steps below:
1. create ta
I've been a believer in response-time-based performance optimization
for some time now, and reading Cary Millsap's book has reinforced my
belief. That said, I'm looking for some help in identifying what I
_think_ is unaccounted-for elapsed time.
Both tkprof and trcanlzr show (sorry for the wrappe
SQL> @cr_spap
SQL> STARTUP NOMOUNT
pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora
ORA-03113: end-of-file on communication channel
SQL> CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 50
3 MAXLOGMEMBERS 5
4 MAXDATAFILES 100
5 MAXINSTANCES 1
6 MAXLOGHISTORY 226
check out asktom. its up for today. if you use an 8i tkprof on a 9i trace file, you
get bad cpu results.
are you doing that?
>
> From: Muqthar Ahmed <[EMAIL PROTECTED]>
> Date: 2003/10/28 Tue AM 11:04:24 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Execution
just in case, if you have specified explain= on the command line to generate tkprof
summary, remove it and just do
tkprof filename ...
which version of oracle?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All
Jared,
The output is from TKPROF.
Muqthar
-Original Message-
Sent: Tuesday, October 28, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L
Have you run SQLTRACE on this query?
The detail in the trace file will show
where the cpu is being consumed.
There is insufficient data in the
1 - 100 of 128 matches
Mail list logo