You can also set the hidden parameter _system_trig_enabled=FALSE in your
init file.
The use of this parameter is discussed in the documentation (Chapter 7 of
the 817 migration guide) and it disables any system triggers (the new
Oracle8i event triggers) you may have in your database.
Quote is
Try using the primary key value like if PRD_LVL_CHILD is the primary key then just add
a where cond using and operator like PRD_LVL_CHILD0. This will make the usage of
index in the table PRCMSTEE.
May be this is not the actual way, but we have tuned several queries like this and
they all are
On Tuesday 05 June 2001 13:15, Koivu, Lisa wrote:
10. Benchmarking Solaris E10K/64CPU against Compaq GS-160/16CPU favored
the Compaq! WOW
The same can be said for a loaded ( 16 way ) IBM RS6000 S80
running AIX. *Much* less than an E10k and equivialent processing power.
2. Sun is
Hi,
Are job_queue_interval and job_queue_process parameters applicable to both
dedicated and parallel server? any changes regarding this in 8i.
rgds
amar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Amar Kumar Padhi
INET: [EMAIL PROTECTED]
Fat City Network
Hi Suhen,
The UNION ALL will return duplicates from the two queries, whereas the
original query will not, right? So the query is tuned, but it returns a
different result set.
Do you agree?
Best regards,
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg
Perhaps 2 could be accomplished by a database after login trigger that uses
raise_application_error if the count of sessions from the machine is too
high.
This will depend on what version of Oracle you are on.
Bruce
-Original Message-
Sent: Wednesday, 6 June 2001 4:05
To: Multiple
Hi, Sam,
Thanks for your information.
To my understanding,the script you gave is
for all the queries. There is still no way to figure out which query is
running.
Chuan,
- Original Message -
From:
Sam
Roberts
To: Multiple recipients of list ORACLE-L
Sent: Monday,
Greg,
Correct me if I am wrong but both will return duplicates since the OR
operator is used.
The primary key is on PRD_LVL_CHILD.PRDMSTEE.
Regards
Suhen
Hi Suhen,
The UNION ALL will return duplicates from the two queries, whereas the
original query will not, right? So the query is tuned,
This what I did last time it happened to me. (Bear in mind that this was
Oracle 7.3 and so rowid format is different for later releases of Oracle).
In sqlplus select the following from the table with the corruption
SQL SELECT /*+ ROWID(TABLE_NAME) */ DOC_ID, ROWID
2 FROM TABLE_NAME
3 WHERE
http://www.oracle.com/start/oowsessionsearch/index.html
HTH,
Rajesh
-Original Message-
Sent: Wednesday, June 06, 2001 10:32 AM
To: Multiple recipients of list ORACLE-L
Hi DBA Gurus,
I am looking for whitepapers and presentations of Oracle
Openworld 2000.
Where can I find them?
Hi Chuan,
Still your question is not clear to
me. But I am
sending you some scripts, may be these would help
you:
This gives SQL-TEXT, Oracle-User-name,
machine-name
and program-name for the user executing the
SQLs.
set pagesize 50
set head on
set linesize 70
select
Try
this out my friend:
select
s.sid sid,
c.sql_text
sql_text,
c.address address,
ltrim(to_char(c.hash_value,'99'),' ') hash_value,
substrb('
',1,2) execcur from v$open_cursor c,
v$session
s where c.saddr = s.saddr
and c.hash_value != s.sql_hash_value
and s.sid in
Hi,
Its a long and
boring story but I have an Oracle8 database andI need to create
anOracle 7 database from it to support one of our applications. The schema
of the Oracle 8 db does not have any oo features and is, in theory, it
functionally compatable with an Oracle 7 db. But I
Hello List,
This must be piece of cake for the UNIX gurus.
Trying to pass parameters to a simple awk script. Getting stuck.=20
First q., can we do that.=20
If yes I need to solve the foll. problem,
In a huge text file locate for abc/xyz and replace it with a supplied =
parameter value. This
hi all,
I need ur help urgently. i've
created a standby database with the below mentioned steps..
1. copied consistent backup of
datafiles folder to standby site.
2. created standby control file and
sent to target location.
3. switch logfile current and
copied to target.
4. copied
Just for the sake curiosity
I think we should try to salvage the records which are stored
after the corrupted blocks. Following SQL may be helpful for
this purpose:
SQL SELECT /*+ ROWID(TABLE_NAME) */ DOC_ID, ROWID
2 FROM TABLE_NAME
3 WHERE substr(ROWID,1,8) '7085' and
4
Hi all gurus,
My question is how can I query the database for
which packages are installed?
I wonder if dbsnmp is installed?
Thank you.
Bunyamin
List hi!
Oracle 8.1.7 EE on WinNT.
During instalation of database, package DBMS_RCVCAT was not installed but I
have packages DBMS_RCVMAN, DBMS_BACKUP_RESTORE.
What should I do?
TIA,
Sonja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Yes - and from 8i (I think) upwards you can bind a job
to a particular instance.
hth
connor
--- Amar Kumar Padhi [EMAIL PROTECTED] wrote:
Hi,
Are job_queue_interval and job_queue_process
parameters applicable to both
dedicated and parallel server? any changes
regarding this in 8i.
Hi Jared,
My post was to meant to imply that (say) if (in a
single query - and thats the important bit I missed
out) there were two tables, one with stats, and one
without, then the one without will use defaults (as
quoted in chapter 8 of the same manual)
I was trying to imply that if you've
Given that OPTIMIZER_INDEX_CACHING is presumably meant
to the indicative of how much of an index is cached,
then setting it to your buffer hit ratio would seem
like a reasonable starting point.
Cheers
Connor
--- [EMAIL PROTECTED] wrote: Oracle
8.0.5.2.1 -- yeah, I know I know... we are
Actually there may be no problem at all. Your standby
database might be up to date, the last available archive log file has been
applied to your standby database and Oracle tried to apply the next archive log
file 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 and did not find it, since
you
See the script I just posted in the thread:
Which SQL is executing?
This may help you out..
Mark
-Original Message-
Sent: Tuesday, June 05, 2001 11:34
To: Multiple recipients of list ORACLE-L
select, by user, from v$sqlarea, a list of cursors in the pool
from a typical user. (see
Thought it was Paul Katner..
Oh well..
Mark
-Original Message-
Sent: Tuesday, June 05, 2001 05:07
To: Multiple recipients of list ORACLE-L
No winner! I drink the freaking beer all by myself.
I think I'll pour myself a Smithwick's...somewhere in Dublin...aaa!
(Jefferson
The defaults are in the initSID.ora file, which is the initialization file
that Oracle reads upon startup.
If you are running Oracle 8 then you cna usually find this file in
ORACLE_HOME/admin/SID/pfile
Open the file and look for the parameter JAVA_POOL_SIZE and change as
necessary, and then
Bunyamin,
select * from dba_objects
where object_name like '%DBSNMP%';
"Bunyamin K. Karadeniz" wrote:
Hi
all gurus,My question
is how can I query the database for which packages are installed?I
wonder if dbsnmp is installed?Thank
you.Bunyamin
--
Web: http://www.unal-bilisim.com
*
Dear list,
We are Oracle Apps site, one of the
problem we are having is memory leak with f45webm processes. We had 4G of memory
on the web server tier where the Form server run, when we run the prtmem
command, it reported that 3.5G was used by user (application), using the memps
command I
Paul
The only workaround I found for this was to upgrade to Win2K. Then using the
service recovery option - so that when the service fails, it just restarts
it.
You get a few recovery options with Win2K for services:
Restart the service
Run a file
Restart the computer
Take no action
Which you
Hi - me again, still having lots of fun with Oracle Enterprise Manager 2.1!
Having got OMS working, I fired up the OEM 2.1 console, and gave it a list
of nodes to discover. It found one of the 8.1.6 nodes (an NT box), and the
7.3.4 node (a Sun box), but failed on two others (an 8.1.6 Sun box and
Sorry I'm not much help, but I remember reading about a parameter in one of
the OEM docs that governs retries, time delays.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Hi,
I have a Solaris test system on Intel. This is
first time I installed Solaris. I am trying to findout in i can install the
oracle 9i on this system.
Can someone enlighten me.
I don't mind installing any version as it is for
test purposes, but 9i will be a great thing to do
novice
Hi Uday,
I don't know in which version dbv is stable; but, I know dbv was very buggy product. I
recommend:
- add event="10231 trace name context forever, level 10" to init.ora. This will
eliminate
corrupted blocks during full table scan. Note that this event is used while reading
from
disk.
both will return duplicates since the
OR operator is used.
select ename from emp where mgr = 1 or
mgr in (1);
-- If there are three rows where mgr = 1, this
query will return three rows.
select ename from emp where mgr =
1
union all
select ename from emp where mgr in
(1)
-- But this
has log 505 made it over to the standby yet, you should start reading
the docs, if log 505 is not there yet, than that is the way its SUPPOSED
to work.
joe
Saurabh Sharma wrote:
hi all,
I need ur help urgently. i've created a standby database with the
below mentioned steps..
1. copied
Hi all!
Just a warning for those of you running Oracle on NT.
There's an extremely nasty bug specific to 8.1.6/8.1.7
on NT/Win2K (not sure if it affects 8.1.5) where a
datafile that is resize or autoextended exactly on a
4GB boundary cannot be resized. Bug 1668488.
Options:
1. PITR prior to
why not run version 7 export against the oracle 8 database(its been more
than 4 years since i've played with a 7 database). or am i missing
something here?
joe
Tim Allen wrote:
Hi,
Its a long and boring story but I have an Oracle 8 database and I need
to create an Oracle 7 database from
Hi,
I have oracle 8.06 installed on Sun Solaris. I have problems starting the
database after a system crash and I had to reboot the system. When i run
dbstart I got the following error message:
SVRMGR connected
SVRMGR oracle instance shut down
SVRMGR
Server manager complete
...
Hello everyone.
I am currently finishing off our company website, and am putting together
the links section. This is going to be used to link to COOL resources for
Oracle, Sybase -aahem- SQLServer DBAs.
I was wondering if any of you have, like me, a list of URLs that you swear
by for your
Thanks for taking a shot Jared. I'm just starting with Java, learnin' as I go.
Sorry I didn't post the query initially. It was basically a select * from dba_java_policy wheregrantee = 'TISSD'.
External calls to the OS will be as the oracle user which would be hard to limit however it is happening
Hello Mikael,
Rename open_link parameter in paremeter file initsid.ora or init.ora to
open_links.
Mikael Granhed wrote:
Hi,
I have oracle 8.06 installed on Sun Solaris. I have problems starting the
database after a system crash and I had to reboot the system. When i run
dbstart I got the
On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-I AM AN IDIOT
HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be
the best idiot is can so i *deserve* the job.;-)
--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy, Inc.
Jaren, clue me in. what's the metric?
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/6/2001 2:20 AM
On Tuesday 05 June 2001 11:13, Post, Ethan wrote:
I say we all go to Steve's house and play a game of Survivor to see
who
the most powerfull DBA in the world is.
Paul Cantor (sp?) and Grace Slick were
the driving force..i'm impressed.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/6/2001 5:41 AM
Thought it was Paul Katner..
Oh well..
Mark
-Original Message-
Sent: Tuesday, June 05, 2001 05:07
To: Multiple
I wonder if we on the list made our own show of Wizard of OZ
who would be the StrawMan, TinMan, Lion, and, well...Dorothy.
Applications are being accepted for good witch, bad witch, and
the wizard, of course.
I've got dibs on ToTo
-Original Message-
To: Mohan, Ross
Cc: Multiple
Hi,
I think you need to install the 8.1.6 agent on the NT box in question
(assuming that your OMS is on 8.1.6)
Going by that logic I would love to know how 7.3.4 on the SUN node worked (I
have no experience with SUN)
We had a similar situation where OMS was on 8.1.7 but the other databases
which
Hi,
Few days ago someone posted a link to a newsletter about the slashing of
the prices of Oracle products in Japan and that Larry Ellison would
announce price reductions that will apply worldwide. Someone can send me
the link ??
TIA,
Antonio Belloni
--
Please see the official ORACLE-L FAQ:
For something as you have described, it is relatively simple:
the_val=$1 #set a script variable to the passed value
cat text_file | sed s.abc/xyz.$the_val.g new_file
mv new_file text_file
Keep it as simple as possible.
-Original Message-
From: Satish Iyer
This list is by far incomplete, but it is the links i have on my site
currently.
I have about 50-100 different sites, I only put the ones I most frequently
use or like on my site.
I am going to go through the rest and finishing adding links as well. I
left out some good ones here I know, but my
Can I try out for a flying monkey role! :o)
-Original Message-
Sent: Wednesday, June 06, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L
I wonder if we on the list made our own show of Wizard of OZ
who would be the StrawMan, TinMan, Lion, and, well...Dorothy.
Applications are
PLEASE I want to be the wicked witch!!!
8]
April Wells
Corporate Systems
Amarillo Texas
-Original Message-
Sent: Wednesday, June 06, 2001 8:41 AM
To: Multiple recipients of list ORACLE-L
Can I try out for a flying monkey role! :o)
-Original Message-
Sent: Wednesday, June
According to a technical representative at Oracle in Rochester, NY, Oracle
no longer develops on Solaris. He stated that they have changed to
HP-UX for development. He said the reason was instability with Solaris.
"Koivu, Lisa" wrote:
Kevin, sure I
will. I just didn't want to muck up the list.
I'm sure you'll receive lots of good advice,
but here goes some more (maybe not good?):
The Velpuri Backup and Recovery book has some
very good descriptions of exactly how to cope
with this. There are a number of packages you
can use to flag the blocks as bad and effectively
stop them from being
I'd like to apply for evil-flying-monkey-thing or failing that, the muchkin who
says Follow the yellow brick road! first.
I have previous experience of being evil, flying and saying Follow the yellow
brick road!.
I have studied being a monkey to degree level.
I'm ready for my closeup.
Shouldn't you have just stopped at the first sentance :-))
-Original Message-
Sent: 06 June 2001 12:56
To: Multiple recipients of list ORACLE-L
Hi all!
Just a warning for those of you running Oracle on NT.
The information contained in this communication is
confidential, is
You should rename it to max_transaction_branches .
It's a typo error. I do typo errors very frequently, too.
Mikael Granhed wrote:
Thanks for your help, now it doesn't complain about "open_links" when i
rename it. Now it's problem with the "max_transaktion_bransches". Should I
rename that
Thanks for your help, now it doesn't complain about open_links when i
rename it. Now it's problem with the max_transaktion_bransches. Should I
rename that variable too?
/Mikael
-Ursprungligt meddelande-
Från: Danisment Gazi Unal (Unal Bilisim)
[SMTP:[EMAIL PROTECTED]]
Skickat:
On Wed, 6 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-
-I wonder if we on the list made our own show of Wizard of OZ
-who would be the StrawMan, TinMan, Lion, and, well...Dorothy.
-
-Applications are being accepted for good witch, bad witch, and
-the wizard, of course.
-
-I've
Tim,
AFAIK
you can run the version 7 export utility against the version 8 database, but you
have to run the catexp7.sql script on the 8 database?
Something like that.. have never done it :)
Regards
Mark
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On
On Tue, 5 Jun 2001,Jared Still scribbled on the wall in glitter crayon:
-On Tuesday 05 June 2001 11:13, Post, Ethan wrote:
- I say we all go to Steve's house and play a game of Survivor to see who
- the most powerfull DBA in the world is.
- ^^
-
-Mladen would win.
-
-Jared
-
--- Forwarded Message Follows ---
ERPcentral - http://www.erpcentral.com
Oracle slashes prices in Japan. Global cuts next?
http://www.erpcentral.com
cw360.com June 4, 2001
Oracle could be on the verge of announcing significant price cuts around
the world after its Japanese operation
Oracle 8.1.7
AIX 4.3.3
I looked at the docs and it appears Oracle wants you to use dbms_stats to generate
statistics for cbo. I am currently using dbms_utility.analyze_schema.
Should I change to dbms_stats (i know it doesnt give you chained rows, avg free space,
# of unused blocks)? Are
As I stand a towering 5 feet 7, I could always qualify as a member of the
Lollipop League or was that Guild
Lee
-Original Message-
Sent: 06 June 2001 14:11
To: Multiple recipients of list ORACLE-L
I wonder if we on the list made our own show of Wizard of OZ
who would be the
Hey all,
I am looking for some commands like ( grep, egrep, sed etc) to do the
following on a Unix box.
1. Command to take out all the blank line from a text file. The blank line
may include tabs and whitespaces.
2. Command to take out the trailing and starting blanks and tabs from the
This
surely does sound the Wiz of Oz, Solaris unstable ? Tru64, get real.
-Original
Message-
From: Scott Canaan
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001
9:31 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: SUMMARY: Thanks
everyone - tru64
See
http://tahiti.oracle.com/pls/tahiti/tahiti.initora
for a list of all init params..
-Joe
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 9:51 AM
Thanks for your help, now it doesn't complain about open_links when i
Does that mean I can get a beer?
-Original Message-
Sent: Wednesday, June 06, 2001 01:08
To: 'Mark Leith '; 'Multiple recipients of list ORACLE-L '
Paul Cantor (sp?) and Grace Slick were
the driving force..i'm impressed.
-Original Message-
To: Multiple recipients of
It should be MAX_TRANSACTION_BRANCHES
Unless it is all in another language? And Oracle works with other languages?
Maybe..
Mark
-Original Message-
Granhed
Sent: Wednesday, June 06, 2001 02:51
To: Multiple recipients of list ORACLE-L
Thanks for your help, now it doesn't complain
Just to add
http://www.jlcomp.demon.co.uk
for Johnathan Lewis's excellent site
Cheers
Connor
--- Christopher Spence [EMAIL PROTECTED] wrote:
This list is by far incomplete, but it is the links
i have on my site
currently.
I have about 50-100 different sites, I only put the
ones I most
I have seen number of TAF papers on metalink and google. But wanted to get
some user experience.
This input is great.
Thanks
Murali
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 05 Jun 2001 01:19:36 -0800
Yes. Search on MetaLink. Look
Ok i have a table range partitioned on date.
I have prefixed local indexes also. so far so good.
I created an index, non partitioned, using simple
create index index_name on table(field20);
Is that now assumed to be a global index?
I can't find any docs to say one way or the other.
thanks,
Hi Friends
Iam getting this error frequently..So could you guys explain what's about
it?? and What I need it do?? Mine is oracle8 on NT
*** 2001.06.01.19.48.37.703
*** SESSION ID:(89.7330) 2001.06.01.19.48.37.703
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2001.06.01.19.48.37.703
ksedmp:
sigh
:)
Mark, I'll be as happy as you if I can get my
stars and stripes ass over to GB and buy us
*both* a Smithwick's.
|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, June 06, 2001 9:26 AM
|| To: Lyris; Mohan, Ross
|| Subject: RE: OT RE:
Thanks for the input...
rgds
amar
-Original Message-
Sent: Wednesday, June 06, 2001 5:57 PM
To: Multiple recipients of list ORACLE-L
Shouldn't you have just stopped at the first sentance :-))
-Original Message-
Sent: 06 June 2001 12:56
To: Multiple recipients of list ORACLE-L
I have done this on 8.1.6 by :
Altering the table to add the new column;
Copying the contents of the old column to the new one;
Altering the table to drop the old column...
[EMAIL PROTECTED]@fatcity.com on 06/05/2001 06:13:49 PM
Please respond to [EMAIL PROTECTED]
Sent by:
Well, I'm one of the Munchkins.
Terry
Mohan, Ross wrote:
I wonder if we on the list made our own show of Wizard of OZ
who would be the StrawMan, TinMan, Lion, and, well...Dorothy.
Applications are being accepted for good witch, bad witch, and
the wizard, of course.
I've got dibs on
Yea, Lisa get real.
Next time, don't talk to anyone or do any research.
Just follow the party line, OK?
:)
-Original Message-
Sent: Wednesday, June 06, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L
This surely does sound the Wiz of Oz, Solaris unstable ? Tru64, get real.
I know it sounds AOL-ish, but:
Ditto!
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -
Thanks Anita!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nuno Souto
INET: [EMAIL PROTECTED]
Fat City Network
Joe :
You probably know some of this already, but here is a summary of indexes on
partitioned tables
* Local indexes are just indexes that are equi-partitioned with the table
* Local prefixed indexes have the partition columns as the leading
column(s) in the index
* Local non-prefixed
Anita,
Thank you so much for this info.
Cheers!
- Kirti
-Original Message-
From: A. Bardeen [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 6:56 AM
To: Multiple recipients of list ORACLE-L
Subject: Heads up on nasty bug on NT
Hi all!
Just a warning
Is there any reason I should not modify the parameter file AFTER I copy
it to the new host but BEFORE I restore the controlfile, datafiles,
etc.?
We are planning to move our database from one SPARC/Solaris box to
another. Since the file system, operating system, and Oracle version
(8.1.6) will
We use
standby databases as well and our method is prety muc as yours is. So, my
biggest question is . is that the correct directory for the Archive Files
??? and did you actually copy the files to that directory ?? "D:\ORACLE\ORA81\DATABASE\ARCHIVE" It seems a straight
forward error
Well, that certainly matches my recent experience.
I know of more than one very large customer having
trouble with Sun and another large academic site
who swapped 80-odd sun servers for AIX.
Makes NT look more and more like the dot in dot com
everyday. EG
-Original Message-
Sent:
Well it is dependent on the type of game, I admit.
Mladen is a (large) former Greco Roman wrestler,
so if it's physical, he's got a good chance.
Jared
On Wednesday 06 June 2001 05:55, Thater, William wrote:
On Tue, 5 Jun 2001,Jared Still scribbled on the wall in glitter crayon:
-On
Would appreciate feedback positive and/or negative from anyone who is using
PATROL Availability Suite for Oracle. And if ye had a look but decided
against it why?.
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
They can cut 80% and it would still be expensive.
But it is nice to see they are finally getting some brains. Yeah, I think
Oracle should always be expensive, but ludicrus is just not acceptable,
specially when they are KILLING their main partner (Sun). Sun is laying
off the ENTIRE company
I think that Ross should be the lion! hhehehhehehe whoo hoo
-Original Message-
Sent: Wednesday, June 06, 2001 10:49 AM
To: Multiple recipients of list ORACLE-L
Well, I'm one of the Munchkins.
Terry
Mohan, Ross wrote:
I wonder if we on the list made our own show of Wizard of OZ
Off the top of my head I would say that you have a parameter
called open_link in your init which is not valid.
-Original Message-
Sent: Wednesday, June 06, 2001 5:21 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have oracle 8.06 installed on Sun Solaris. I have problems starting
I'll be riding in yer basket, Mark.
EG
Arf, Arf.
|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, June 06, 2001 10:32 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: OT RE: SUMMARY: Thanks everyone - tru64
||
||
|| Can I be
All:
From reading the release notes for 9i it appears that ANALYZE table and
DBMS_UTILITY.ANALYZE_SCHEMA are desupported in 9i. The only supported way to
generate stats in 9i is DBMS_STATS.
In addition, DBMS_STATS can generate stats for tables in parallel and make
use of the new MONITORING
You need to apply for the UKOUG, and get your Co. to do it on expenses :)
Birmingham is the second capital of England - and the ICC is not a bad
venue - especially when you are in the Hilton that is joined next door by a
bridge over Broad Street (a great place for pubs). I remember one year
I have it monitoring a NT database but can't get OS stats from it.
Of course they could just put it sucks on the page and that would
be enough for me.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L
Ron,
I
Hi Joe,
Here is a blurb from the 8.1.6 Concepts Guide (Chapter 11, under 'Prefixed
and Nonprefixed Global Partitioned Indexes'):
'Nonpartitioned indexes are treated as global prefixed nonpartitioned
indexes'
I ran into the same stupid question not too long ago.
HTH,
Regards
- Kirti
He also gave the presentation at the IOUG-A in Orlando recently, so it
should be available from their CD's/archives or whatever. It's a neat
presentation. Way too many people and monitoring products want you do keep
increasing db_block_buffers until your BCHR is about 99.9% or so. It's
pure
My question is, if they are developing on HP-UX, why was 9i for SPARC
released first?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de
Damn! You beat me to it!
-- Anita
--- April Wells [EMAIL PROTECTED] wrote:
PLEASE I want to be the wicked witch!!!
8]
April Wells
Corporate Systems
Amarillo Texas
-Original Message-
Sent: Wednesday, June 06, 2001 8:41 AM
To: Multiple recipients of list ORACLE-L
Only if the story line matches up to Pink Floyd's Dark Side of the Moon as
well as the original WoZ... Careful taking the bad witch part - monkeys may
have to fly out of your butt!
Scott Shafer
San Antonio, TX
210-581-6217
And no amount of training or preparedness can eliminate the almost
How about
sys.V_$OPEN_CURSOR
to get the SIDs, and then try to get the query they are executing ?
HTH, Remco
-Oorspronkelijk bericht-
Van: Shantanu Talukder [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 6 juni 2001 0:14
Aan: Multiple recipients of list ORACLE-L
Onderwerp: How to
As far as I can work out, DBMS_STATS is purely for
optimizer decisions (presumably thats why they didn't
call it DBMS_ANALYZE).
(If you believe the doco) you can get faster and
better stats with DBMS_STATS (particularly in terms of
partition-wise stats).
I'm using both at the moment, in my
Hi,
I am just curious about to know for what that i
stands for in Oracle 8i.
Can any one shed some light?
Thanks,
Muths
Do not go where
the path may lead, go instead where there is no path and leave a
trail.
I don't really care who's what, as long as I can still play Pink
Floyd's Dark Side of the Moon to it.
But since we're lobbying for parts, I guess I'll audition for the Tin Man
due to his lack of heart ;)
Jim
--
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials,
1 - 100 of 257 matches
Mail list logo