Sinardy :
It is expected behavior only. Bit map indexes are not stored in a tree
format and sorting will have no impact.
Have a look at bit map concepts in Oracle Documentation.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Tuesday, March 12, 2002 11:38 PM
Oracle 7.3.4, OpenVMS 7.1
My tkprof report is missing the row count in the execution plan. Does
anyone know why what I might be missing?
If I autotrace the same query in the same database, I do get cardinality.
The tables have been analyzed.
If I tkprof another database using the same
The transaction slots are visible as KTUXESLT in X$KTUXE.
You can get them using this SQL..
select count(*) ktuxeslt from X$ktuxe group by ktuxeusn;
For a complete value you can get the slot size form V$TYPE_SZIE
and do a simple math.. Let me know if you can't. I will do that
for you
Best
Title: RE: Free scripts
I use Tim Onion's site which has a comprehensive listing of basic DBA scripts and there is also a zip file to download the lot in one go.
www.timonions.com
John
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2002 22:54
Hi Lists
I have encountered error(ORA-00600: internal error code, arguments
arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512:) while
running package called 'JC_PR_SPLIT_PROCESS'
Error message is listed below .
I am using SQL Navigotor to process this package.
Any idea
Lee,
Stop a minute and take a look at what your doing. I assume that when the
process was pure PRO*C there must have been a pile of communication between the
database and the program. This communication, even if done by IPC takes time.
Now when you re-code it in PL/SQL there is no reason
Hi:
Just wanted to know if a DBA has to perform an upgrade (patch) across more
than one instance(let's say 5 instances) then how does he about doing the
same... Is there any third party tool that is available which will make
things easier for him?
Regards,
Suresh
--
Please see the official
HI,
When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1 oracle we got error:
There are no patches that need to be applied from patch set Oracle9i Patch set
9.0.1.2.0.
Earlier we are able to apply the same patch on other machine.
What might be the possible reason for this error?
Thanks
select to_char(1) from dual;
to_char is a user defined function (already built for you) by oracle. I am
yet to find someone who says UDF is a bad thing ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
Is my V$SESSION_LONGOPS view broken?
Check out the curious results below. Notice the changing SID-serial# and how
elapsed seconds gyrates. None of the below sessions are in V$SESSION. The
sql address and hash is not extant in V$SQL, V$SQLAREA, etc. (Note, we are
using PQO with timed
Check out the OSM package from www.orapub.com
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
Hi,
could someone please help me with this? I have a table where a column is of
type varray of numbers. I need the 4th and 5th values that are coordinate
values. How can I select only these columns` value?
Every help will be highly appreciated.
Tamas Szecsy
--
Please see the official ORACLE-L
It depends ... to quote my SA, 'You can never be paranoid enough about
security ... but you need to know when to stop and have a life.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
Offline -
I'm sure you already know this, but technically they
are stored in a tree format, loosely speaking as an
IOT with columns:
{column values(s)}, starting rowid, ending rowid, {string of bits}
where the {string of bits} is the 'data' component of the IOT, and
the rest is the
Hi,
Thanks
This is just for the testing purpose, because one of my oracle book
state the syntax like this :
CREATE BITMAP INDEX [schema.] index
ON [schema.] table
(column [ ASC | DESC ] [, column [ ASC | DESC ] ] ...)
[ TABLESPACE tablespace]
[ PCTFREE integer ]
[ INITRANS
Larry
Thanks for a fine and detailed info.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Larry Elkins [SMTP:[EMAIL PROTECTED]]
Sent: Sun, March 10, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: USER DEFINED FUNCTIONS
http://nscpcw.physics.upenn.edu/db2_docs/
could be useful. i'm still trying to get a free trial copy of db2...
-Original Message-
Sent: Thursday, March 07, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
Hi there,
Does anybody know if there's a list such as this
Hi All,
Anybody know a good document on performance issues for ORACLE NAMES
SERVERS. Also how is load balancing done if I have more than one
nameserver?
TIA
Jack
===
De informatie verzonden in dit e-mailbericht is
Hi Friends,
I just need a help in a SQL statement. There is a test table with one
number field say X.
I needed a sql statement which will show the value of x for each row and the
sum of all X.
For ex , if 3 rows are there with values 3,6,9 then the output should be
XSum(X)
I want to thank to everyone on the list for their
replies for my problem. I lastly managed the problem and cloned a new db .
But I have seen an important thing and I want to
share with you. You can be careful about it...
THe original database was in archive log mode. It
is very
Hi,
could someone please help me with this? I have a table where a column is of
type varray of numbers. I need the 4th and 5th values that are coordinate
values. How can I select only these columns` value?
Every help will be highly appreciated.
Tamas Szecsy
--
Please see the official ORACLE-L
Hi Steven,
Exclude the rows with XXX is null in the cursor definition. Does that
get you what you want ?
HTH, Remco
-Oorspronkelijk bericht-
Van: steven wndy [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 12 maart 2002 22:34
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Smart
Hi Friends,
I found the answer . sorry for troubling you.
Thanks
Shankar
-Original Message-
Sent: Wednesday, March 13, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
Hi Friends,
I just need a help in a SQL statement. There is a test table with one
number field say
Gotta go see that!!
Live demo's. always fun!
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:
How about a seat near the power outlets ?? Then, it will be a fun experiment
for Joe Susan ;)
I will be doing my first ever presentation at IOUG-A.. Just a Quick Tips
(Q31) - Wait Events in a Nutshell.. (bring your lunch with you, if they
allow it :) All Quick Tips Sessions are during lunch
Well, since hints are implemented within comments, I would assume that other
databases would simply ignore them. If anyone has direct experience, that
would be interesting. Being completely database-agnostic may play against
tuning.
Just a thought. I suppose you analyzed all tables when
No version numbers, and no O/S details.
Cary Millsap mentioned to me a little while
ago that on one of his linux platforms the
values you got from timed_statistics seemed
to be a very good random number generator ;)
Possibly this is just a 32-bit/64-bit misalignment
in code - I've seem similar
Rajesh,
The transaction slots are clearly visible in the Undo Header dumps. I
think this takes some 40 bytes space in the undo header block and this
limits the number of ***concurrent** transactions for that undo segment.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original
Does your tnsnames.ora have SID or SERVICE_NAME for CONNECT_DATA? It
should be SERVICE_NAME.
Peter Barnett wrote:
We are attempting to install SQLNet in a failover
configuration. The environment consists of two AIX
servers with version 4.3.3 OS, Oracle 8.1.7.2 on both
servers. These
Title: How to deregister OEM 2.2 jobs and events when agent is not available?
There
is a paper on this in MetaLink.
Log a TAR, they will point you to
it.
Regards, Patrice Boivin Systems Analyst (Oracle Certified
DBA)
Systems Admin Operations
| Admin. et Exploit. des systèmes Technology
That as Oracle software becomes larger, fewer DBAs are required.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de
SELECT s.client_info client,s.username,s.osuser,s.PROGRAM,p.pid,p.spid,
s.sid,s.serial#, to_char(S.LOGON_TIME,'MONDD HH24:MI') LOGON TIME
from v$session s, v$process p
where s.status='ACTIVE' and s.type != 'BACKGROUND'
and p.addr=s.paddr
/
Joan
Abul Fazal wrote:
Hello List,
Just a stupid
Here are a few indications, which I believe also were to be found in 7:
- Parse/elapsed time CPU substantial part of CPU used by this session
- parse count (almost) as large as execute count
- latch free wait time high compared to CPU used by this session and the
latches really hit are library
Is it just me, or am I having a slight case of de ja vu here ;P
-Original Message-
Lewis
Sent: 13 March 2002 11:34
To: Multiple recipients of list ORACLE-L
No version numbers, and no O/S details.
Cary Millsap mentioned to me a little while
ago that on one of his linux platforms the
Jack:
It appears that the names server is up and running. Try this:
1. Invoke the namesctl utility from a dos prompt.
2. Type services (I think) to see what service names are processed.
3. Type status to see the status of the names server.
Thank You
Stephen P. Karniotis
Technical Alliance
Wow - does nobody reorg databases anymore? ;P
Thanks for all your help guys.. I'll take that as a cue to put some time
aside..;0P
-Original Message-
Sent: 12 March 2002 11:43
To: Multiple recipients of list ORACLE-L
Does anyone have any set limits to know when it would be time for
Yeah
My clients had a problem a couple weeks ago for the same application
but different databases on different platforms, different weeks.
First occurance on DB1 : This happend on one user's machine and it
came out that his PC was not properly setup. DB1 was running on
WINDOWS NT.
Second
Hi Andrea,
Have you stopped and restarted the Intelligent Agent? The databases are
discovered and stored in the services.ora file when the agent is
started? Your discovery actually reads this file.
Best regards,
John
[EMAIL PROTECTED] wrote:
Hi all,
I created one db and after OEM
When you created the new database, did you add the relevant connection info
in to the Net8 connection definitions such as tnsnames.ora or your names
service?
-Original Message-
Oracle
Sent: 12 March 2002 21:49
To: Multiple recipients of list ORACLE-L
Hi all,
I created one db and after
I give an example, just to make clear what I mean:
How do I retrieve coordinate values from Oracle Spatial Object model?
1. Create a table:
create table sdo (geometry mdsys.sdo_geometry);
2. Insert a record with coordinate values ( 19.135147 and 47.021199 are the
coordinates)
insert into sdo
Yeah
My clients had a problem a couple weeks ago for the same application
but different databases on different platforms.
First occurance on DB1 : This happend on one user's machine and it
came out that his PC was not properly setup. DB1 was running on
WINDOWS NT.
Second occurance on DB2
Tracy - 75 gb is nothing. Lets see: dba hourly rate to create test from data subset
of production vs. cost of 75gb disks? Hmm, seems like a no brainer.
[EMAIL PROTECTED] 03/12/02 05:43PM
We currently have a production, system and development database here. The
system and development
Yes, I think databases still get reorg'd today. It is just that our definition
of a reorg and a database I think are changing. In the past if you said you
were going to reorg a database that a full export, possibly a rebuild and an
import. Way too time consuming for today's 24x7 requirements.
My favorite (or at least the one that annoys me the most) is Every
object in the INITIAL extension. After that would be OFA where the DBA
doesn't get the difference between an LV and a physical drive.
All,
We've got a weird report problem where the report is
called from a form
when a user clicks on a button located on the canvas
of the forms
screen. The button has a trigger on which run 1 of 2
reports based on the
value user selects from a drop down list in the form's
screen. Trigger is
The best argument is that you have the hardware and software on-site for
disaster recovery.
It's not a failover situation but it does mean that production would be
down for hours instead of days.
Thanks to all who helped me with this one, looks like we have * bug *. OWS
is working on resolution and probably a patch. Once I get a clear research
note from dev, I'll update the list if anyone is interested.
Raj
__
Rajendra Jamadagni
Rachel,
SLOUG would definitely pay your travel expenses, and since our meetings run from 1PM
to 5PM, it could really amount to just a day trip for you if you want. You could fly
in that morning, have some lunch, deliver your topic, then take off (unless you wanted
to see the city of St.
Title: RE: Poll Questions
I agree the work involved in creating a representative subset of data , complete with full RI in place can be quite significant. I know there are tools in place that do some of the work (Checkmate by BitybyBit and Quest have one - data factory I think) but these
and we are all grateful to all of you for your time and efforts and obvious
sacrifices in giving that help.
Regards
Lee
-Original Message-
Sent: Wednesday, March 13, 2002 4:28 AM
To: Multiple recipients of list ORACLE-L
oh man, what makes you think *I* feel all that worthy of writing
Mitchell;
Mitchell;
I don't know if this has already been said but my take is;
If you have the time and space export import should be oK. However if you don't
have one or the other, but do have a network, the best way is to use create
table as select across the network.
You'll need to
Also, check your services.ora
-Original Message-
Sent: Wednesday, March 13, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
When you created the new database, did you add the relevant connection
info in to the Net8 connection definitions such as tnsnames.ora or your
names
Given that I saw a 120GB disk for $229 in Sunday's paper,
I'm not convinced that the cost of hardware should be an issue.
At $50/hour for the DBA, the break even point is less than 5
hours. A development system doesn't need to be fast or contain
RAID. It just should be big enough to hold a copy
No... it's Deja vu all over again.
Yogi Berra
-Original Message-
Sent: Wednesday, March 13, 2002 5:53 AM
To: Multiple recipients of list ORACLE-L
Is it just me, or am I having a slight case of de ja vu here ;P
-Original Message-
Lewis
Sent: 13 March 2002 11:34
To: Multiple
Title: RE: RE: Time for a reorg?
Thanks Dick,
I think what you are saying ties in exactly with my post on the matter
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 13:53
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Time
Title: RE: Time for a reorg?
Having a sulk Mark? :-)
There may be a number of factors involved here
1) Database well designed and managed and reorganisation does not become a problem
2) Regular use of alter table move and rebuild index reduces/removes the need to reorg
3) LMT and well
I'm writing an anonymous PL/SQL block that accepts various input from
SQL*Plus via ACCEPT commands. I then take the SQL input and use it in the
block, usually by assigning it to a PL/SQL variable.
If no value is specified on the ACCEPT line, it appears that nothing is
passed into PL/SQL, not
--FDQSKIOZYLYJZUDZQANS
Content-Type: multipart/alternative; boundary=CTAMBEFQWATMTARUCPBS
--CTAMBEFQWATMTARUCPBS
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
We are looking into purchasing a shared scsi disk array and placing
I don't understand
you said ... 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).
1. do you want to update the columns in the table, if the
I thought I reply to all previously, but can't see it
up.
Anyway, the answer to the exclude option is NO.
That cursor row also contains a lot of other
information to update other tables. So no row can be
excluded.
Any other ideas?
Thanks in advance
Wendy
--- Daemen, Remco [EMAIL PROTECTED]
And I forgot...
* Index space is never reused ever (Corollary: set
PCTFREE=0 on all indexes)
* Bind variables simply serve to add complexity to the
application (a Tom Kyte special)
--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
My next to favourite legends.
Small tables don't need to
Title: RE: Anyone use V$SESSION_LONGOPS ???
There have been a few posts today which are repeat posts from a few days ago
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 12:53
To: Multiple recipients of list ORACLE-L
Subject: RE: Anyone use
Title: RE: Anyone use V$SESSION_LONGOPS ???
John:
These
are not reposts.. Infact one of my post (which I have sent long back) appeared
today.
Jared:
Any ideas?
Best Regards,K GopalakrishnanBangalore,
INDIA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
No, I can't do that. The whole row contains a lot of
other information for other updates.
Any other ideas?
Steven
--- Daemen, Remco [EMAIL PROTECTED] wrote:
Hi Steven,
Exclude the rows with XXX is null in the cursor
definition. Does that
get you what you want ?
HTH, Remco
Rob,
Can one use 9i RMAN to backup lower version databases (8.0.x, 8.1.x)?
What new functionality will be supported in doing so?
We do not use RMAN at the moment, but we may consider it in the near
future.
Thanks.
- Kirti
-Original Message-
Sent: Tuesday, March 12, 2002 3:28
Hi
gurus,
My
Production Box has 1Gb Ram with single 933Mhz PIII processor
, though the db is not that big (4 GB), the oracle process is taking too
much of memory, causing server to slow down on peak times of the day, and even
after words, tonight, I looked up the memory which
Title: Oracle taking too much physical memory
Hi gurus,
My Production Box has 1Gb Ram with single 933Mhz PIII processor , though the db is not that big (4 GB), the oracle process is taking too much of memory, causing server to slow down on peak times of the day, and even after words,
oh yes, one more, I got this from a vendor, as an explanation of why
they didn't do a lookup table but instead added columns to the row for
EVERY possible value in the lookup table:
Oracle doesn't handle joins with more than 4 tables very well
--- Jonathan Lewis [EMAIL PROTECTED] wrote:
My
Can't you extract the update out of the cursor loop, and build a new
cursor just for this update, in which you exclude the rows with XXX is
null ? If you execute both loops, the result would be the same ...
-Oorspronkelijk bericht-
Van: Steven Joshua [mailto:[EMAIL PROTECTED]]
Verzonden:
Yep, had that one... another of my fav's!
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: Wednesday, March
My humble suggestions
1. CBO doesn't work ... (well it failed 3 years ago when I compiled a Forms
3.0 form against 803 database, so it is STILL true).
2. Writing reusable code is not good, it is waste of time.
3. Exception handling ... Oracle is pretty good are reporting them ...
4. We need
Naw, it's not just you.
Looks like all the messages that got re-posted have an attachment that says
winmail.dat
Odd
--
From: Orr, Steve[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 7:28 AM
To: Multiple recipients of
Hi Arslan,
Without know anything else it would be difficult to diagnose exactly
what to do. But from the size of the allocated SGA it appears that
you need to reduce some of these parameters.
>From v$sga you have
640 MB of database buffer cache
80 MB of shared pool and other things
What
Title: Oracle taking too much physical memory
You
have one gigabyte of memory on your machine and your SGA
isover 700 MB. That seems excessive I doubt you
need 640megabytes' worth of block buffers. There is nothing wrong by
the way with nearly exhausting physical memory. However improperly
ACCEPT variable PROMPT 'message' DEFAULT 0
--
Chris J. Guidry P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 07:43 AM
To:
Hi Eva,
I find all data modelling tools create lousy SQL so the
DBA ends up rewriting the SQL anyway. Having said this I use
tgif on Linux (other Unisexes also). Similar to Visio except
it has a link feature that allows you to edit the actual
SQL in the text file without disrupting your
Reduce the number of DB_BUFFERS. Unless my eyes deceive me, if you have a
2k block size, then you're trying to allocate 1.2G of SGA just for the
DB_BUFFERS.
On an Intel system (I assume W2K), I wouldn't try to allocate more than 1/2
the physical RAM for the total SGA. Windows will still swap
Hey Guys,Did anyone have a look at Gaja's new paper on myths and folklore about Oracle at Craig Shallahamer's site? Wonderful reading.RajHallas John [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/13/2002 06:28 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL
Title: Oracle.exe taking too much physical ram
Hi gurus,
My Production Box has 1Gb Ram with single 933Mhz PIII processor , though the db is not that big (4 GB), the oracle process is taking too much of memory, causing server to slow down on peak times of the day, and even after words,
Interesting, I wonder if this is 4000 bytes then for 9i and the
manual was not updated? I will ask about this.
So, this implies that my original answer would be b or c (depending
on 9i behavior). This is what I understood Oracle to be telling me.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA
I have a large 7.4 db running under VMS... Database has limited objects, 125,148 meg,
with 1,131 tables and 1,022 indexes. (Total
objects = 3,445)
It runs around 256 I/O per sec and 7,011 logical I/O per sec. Fetch vs. Scan is 5%..
They run about 87 db waits per minute and get 176 I/O per
Most probably it says:
CREATE [BITMAP | UNIQUE] INDEX [schema.] index ...
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 3:48 AM
Hi,
Thanks
This is just for the testing
Your welcome. The problem with these changing paradigms is that there are
folks, like Mark, out there creating tools to make our lives easier but at the
same time the shift makes theirs more difficult. It follows my theory on the
balance of life. If you change the amount of effort required to
Oracle doesn't handle joins with more than 4 tables very well
maybe because they wrote their application for sql server?? Tell them if you
set _allow_tables_to_join = n hidden parameter it WILL allow you to join n
tables, but not n+1.
Raj
__
If you buffer cache hit ratio is 90% you're experiencing poor performance
and you're a DBA wimp. :-)
-Original Message-
Sent: Tuesday, March 12, 2002 1: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
Reading it right now.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, March 13, 2002 11:28
AM
Subject: RE: Fav. Urban Legend...
Hey Guys,
Did anyone have a look
Bigger is better.
This is the best biggest myth. Say that fast 3 times. :-)
-Original Message-
Sent: Wednesday, March 13, 2002 5:18 AM
To: Multiple recipients of list ORACLE-L
That as Oracle software becomes larger, fewer DBAs are required.
Regards,
Patrice Boivin
Systems Analyst
Rman is backwards compatible, but to be honest I have not tried the new
features on 8i databases, so I can't tell you for sure that they work
in that way. My guess is that they probably do, but don't hold me to that.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier
Yes, the man is a X$ marvel
What that I could remember all of the things that
he seems to have at the tip of his emails.
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
Hi
The assumption is that every user of this system will have totally unique
requirements. There will be no data sharing and no commonality of purpose.
As far as alternatives I am not even thinking about multiple instances.
Other alternatives include - many schemas and one tablespace, or many
I just upgraded an 8.1.5.0.0 database to 8.1.7.0.0 and was totally willing
to skip the Upgrading JServer
section under Upgrading Specific Components..until, I saw JServer
Release 8.1.7.0.0 - Production
in the svrmgrl banner. I went and looked at my 8.1.5 banner and found
and Java
How much have you played with Oracle Hints???
-Joe
--- Magaliff, Bill [EMAIL PROTECTED] wrote:
I work in a dev shop - most of the sql is canned and pretty basic.
We've
been running CBO in all of our dev environments, but we have a few
long txns
that just take forever. At the request of
Title: Message
You're
DB_BLOCK_BUFFERS parameter is way too high.
-Original Message-From: Arslan Dar
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:34
AMTo: Multiple recipients of list ORACLE-LSubject:
Oracle.exe taking too much physical ram
Hi
Hi
List,
Checking the alert
log file I found this error
ARC2: Completed archiving log# 3 seq# 736Mon
Mar 11 07:46:18 2002Thread 1 advanced to log sequence 738Mon Mar 11
07:46:18 2002ARC1: Beginning to archive log# 2 seq# 737Mon Mar 11
07:46:18 2002 Current log# 1 seq# 738 mem# 0:
How about -
Oracle's decision to use an index for a
query is determined by the percentage
of rows from the table identified by the
index.
Hints are only suggestions and Oracle
is allowed to ignore them
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK,
1)they'll be a code to generate a code to generate a code to generate a
code, and there'll be self-maintening databases, too. no developers and
dba's will be needed. :-0
2)Y2K was turned out to be a myth, too.
-Original Message-
Sent: Wednesday, March 13, 2002 12:24 PM
To: Multiple
Hi John
It's my party and I'll cry if I want to! ;P
I accept everything you say below.. And have no argument against it.. ;)
What I am trying to do is come up with a script that reports on a number of
factors that would lead a DBA in to feeling that it is time for a reorg.
For example, you
Actually this is true for MS SQL Server: can not handle efficiently more
than 6 joined tables, at least on 6.5 version.
So, m.b. vendor's product was supposed to run not only on Oracle, but other
databases as well.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To:
Title: Oracle.exe taking too much physical ram
Because shared_pool_size, db_block_buffers, log_buffer,
java_pool_size,and perhaps other memory-related init.ora parameters,
are set too high. Cut them down to size. Allow enough memory for
user sessions.
db_block_buffers x db_block_size =
Title: RE: Anyone use V$SESSION_LONGOPS ???
Man! I'm glad somebody else said something.
I was
frantically adjusting my medication.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Hallas John
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 13, 2002
1 - 100 of 238 matches
Mail list logo
