Your Parse time is high, and cpu is
close to elapsed, so you are almost
certainly hard-parsing all the time.
This is either a bug, or you have enough
parse activity going on, and a small enough
shared pool that you keep invalidating the
cursor (and it's dependents).
Did you report the
Thanks for the information - that test has
been on my TODO list for the last couple
of years. Apart from being useful information,
it also tells us that it's not the OP's problem,
as the number of different possibilities is too
low.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The
Dear All,
Seasons Greetings.
I have the following problem:
My system is a Oracle EE 8.1.7.4 64bit on Solaris 8 .
The last days the datawarehouse people complain that
their load process which inserts data into tables is half time as fast as it
was two days ago.
From
My system is a Oracle EE 8.1.7.4 64bit on Solaris 8 .
The last days the datawarehouse people complain that their load process
which inserts data into tables is half time as fast as it was two days
ago.
From v$session_wait I can see that the process is spending time on
SQL*Net message
Hi All,
Merry Christmas to all.
I have this interesting problem..
For this query index ind1 on (c1,c2) columns is getting used.
SELECT 'x'
FROM tab ta
WHERE ta.c1='val1';
(gives index ind1 range scan)
But for
SELECT 'x'
FROM tab ta
WHERE ta.c1='val1'
AND ta.c3 = 'val2';
(gives FTS)
index
Hi
If you go to my website http://www.petefinnigan.com/orasec.htm there are
links to papers and default password lists i wrote at a previous
employer that list known default users and their hashes. I also have a
bigger and corrected list with the code that can be downloaded for the
SANS
Hi
There are risks with knowing the password hash for any user not just
system. Unfortunately reading it from dba_users is not the only way to
get it. There are a number of other options as well that i won't go into
here.
As Arup pointed out the password hash is calculated from the username
and
It is not necessarily true that an error in one application will affect all
applications. If there is a problem with oracle instance or the database,
then all applications might be affected.
Multiple schemas which have the same table names can be a problem. If your
applications uses public
'Twas the night before Christmas
And all thru the datacenter,
Not a virus was stirring,
Not even a worm.
. . .
And if this Saint Nicolas dude
Tries to break in our cage,
He will be summarily cuffed
And we'll get in a rage.
. . .
So stay away,
Leave us alone.
No contact by email,
Not even by
'Twas the Night Before Christmas
- Written by a technical writer working on a
Government contract
'Twas the nocturnal segment of the diurnal period preceding the annual
Yuletide celebration, and throughout the place of residence, kinetic
You answered your own question.
ta.c3 is a nonindexed column, this means that the only way to satisfy the
predicate is to perform a full table scan. Since this predicate condition forces
a full table scan on ta, which will retrieve the ta.c1 column values at the same
time, there is no need to use
A Computer Christmas
'Twas the night before Christmas, and all through the shop,
The computers were whirring; they never do stop.
The power was on and the temperature right,
In hopes that the input would feed back that night.
The system was ready, the program was coded,
And memory drums had
Hi tanel , thanks for the prompt reply. I was not able to understand your
answer. What do you mean by new software installation ?
What happens when you specify nls_lang in your test database ? are your
messages in the specified language or do they remain in english ?
- Original
No.
The index should get used.Thequery result for query 2 is a subset of rows with ta.c1='val1' will get selected. Subset of query 1.
So there is no need for a full table scan.The index can be used in the following way :
1) Use index ind1 to get rows with ta.c1='val1' (which is query 1). This
Greetings,
Could you tell me under what scenario the snapshots can have indexes.
I was under impression that snapshot normally does not have any index but I saw that
some snapshots are creating indexes while creating the snapshots.
Thanks,
Ashoke
Following is the code for the creating the
The difference is that the first query never has to go to the table
(because you're selecting a constant 'x'). The second query has to go
to the table to filter on c3.
Mike
anu wrote:
No.
The index should get used. The query result for query 2 is a subset of
rows with ta.c1='val1' will
One other disadvantage of putting all instances together is if you need to say bounce the database (for parameter change or other maintenanceetc) then all other applications will get affected. Whereas with separate instances other applications will not get affected.
To some extent one
You are (I presume) the keeper of the data,
responsible for its integrity and safety
What you need to present to your manager is what risks
to safety and integrity might be faced if all of the
databases are rolled into one.
How closely tied are the applications for the 5
databases? If 1
I
would be very careful about doing this if you have purchased application
packages. Sooner or later, you will want to upgrade one of the packages,
and it will require a different release of Oracle - and you will be
stuck.
Tom Mercadante Oracle Certified Professional
-Original
Friends --
Happy Halloween!
And remember that OCT(31)=DEC(25).
Best wishes to all,
Bambi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bellow, Bambi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
[This message is not technical, but educational. Readers interested in
technical info only may want to skip]
Hi, Cary and Gopal,
My last message is misunderstood. Nowadays most DBAs that still use buffer
cache hit ratio as a primary performance tuning method are those that rarely
browse public
Hi,
It cound be possible that without Hint, oracle will choose FTS for second SQL,
because with col3 clause, if using index, oracle will have to do a range scan on index
ind1 and than table access by rowid.
If CBO thinks that col1='val1' will get a lot of rows then doing FTS may be
OraJobs-L is a broadcast-only mail list recently launched for employers
and recruiters to post Oracle Skills Job opportunities. You will not be
able to post messages to this list. To subscribe to this free list go
to:
http://peopleapps.com/mailman/listinfo/orajobs-l_peopleapps.com
You may view
An undo segment is used to save the old value of data.
For insert operation, there is no old data to be saved.
So, there should be no undo generated. Right?
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
Folks,
Is there a straightforward way to dynamically create a LOBFILE
specification via an Oracle expression?
For example, assume the following table (note there is /not/ a field for
the file name itself):
create table clob_data (
id number
, data clob
);
And the following
Yong,
The point I want to make is that the buffer cache hit ratio actually
*is* useful, in the following way. If its value is greater than about
99%, then I can practically guarantee that there is some high-LIO SQL
inside the application whose repair will greatly improve system
performance.
I am trying to export a table from one database to another. Table in target database
is dropped before importing and is being created as part of import process. During
import process data Oracle is complaining Unique constraint violated and throwing out
following messages. Its complaining on
BCHR tuning is useless as a starting point in the tuning process.
Anjo.
-Original Message-
Yong Huang
Sent: Wednesday, December 24, 2003 6:09 PM
To: Multiple recipients of list ORACLE-L
[This message is not technical, but educational. Readers interested in
technical info only may want
Avnish,
Are you absolutely sure that the target table is either gone before the
import, or empty? You should not be getting a unique constraint violation
if the table does not exists before import.
The step that Oracle import follows for importing is:
Create the table
import the data
create
I am 100% positive . I tried this process 2-3 times using different approach but same
output. I tried to create objects first using no data. I also tried to create objects
as part of loading data but no difference. I enabled 10046 trace for the import
process but that also didnt help, it
I think data will never change like that. Are the owners the same. Or are you doing fromuser touser.
You can use the show option to see the contents of the export dumpfile. Then make sure all objects are dropped. [EMAIL PROTECTED] wrote:
I am 100% positive . I tried this process 2-3 times using
For insert, in order to rollback, Oracle will still have to get the rowid of the new
inserted rows, so that it can rollback when needed.
So there will still be undo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 25, 2003 1:49
Owners
are different. I am using fromuser touser.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of anuSent:
Wednesday, December 24, 2003 12:04 PMTo: Multiple recipients of
list ORACLE-LSubject: RE: Export/Import issue.
I think data will
I have a related question : What about update? In rollback segment : Will it store the whole row for before image or just the changed column and rowid. Is there a way to get the size of the rollback from some where in the database. or v$ views. Like we can get an idea about redo size from redo log
And then there's the previous version of whichever
ITL entry gets taken by the transaction doing the
insert.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick
Time to hit the books.
5 minutes with the SQL reference manual and
a quick test will show you what is happening.
Jared
On Wed, 2003-12-24 at 08:09, Mandal, Ashoke wrote:
Greetings,
Could you tell me under what scenario the snapshots can have indexes.
I was under impression that snapshot
Good counsel. The assumption is made though that
each database has it's own ORACLE_HOME, which may
not be the case.
Jared
On Wed, 2003-12-24 at 08:39, Barbara Baker wrote:
You are (I presume) the keeper of the data,
responsible for its integrity and safety
What you need to present to your
It's been awhile since I've looked at flashback queries, and
I have a couple questions:
* Given an SCN, is there any way to know for certain whether
a flashback query to that SCN is possible? Can a non-DBA
user determine this?
* Is there an easy way to determine how much undo data my
database is
Just the previous version of the changed columns,
plus an overhead of about 80 bytes which relates
to ITLs, linked lists, operation descriptions etc.
Bear in mind that undo relating to indexes is not
the same as undo relating to tables, though. An
update to an indexed column results in one
Answers in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see
Can you tell me if the same happens to you when you specify nls_lang in 9i
release 2, or is it just me ?
- Original Message -
To: Jamadagni, Rajendra [EMAIL PROTECTED]
Sent: Wednesday, December 24, 2003 02:17
Thanks anyway
merry xmas
- Original Message -
From:
List , sorry to keep troubling you all but even if you are not interested in
helping could someone just let me know if this happens by default in 9i
release 2 or am I doing something wrong.
I am using 9.2.0.1.0 enterprise edition on windows.
Earlier when I use to specify
List, I did a reinstall and got the french language support back when I
specified the languages during the reinstall.
Thanks
Merry xmas and happy new year :)
- Original Message -
To: [EMAIL PROTECTED]
Sent: Thursday, December 25, 2003 06:39
List , sorry to keep troubling you all but
Could be that no one has an answer.
When I set NLS_LANG=French_France.US7ASCII, everything is in
English, which is what I would expect with US7ASCII.
Are you sure that was your previous setting?
Jared
On Wed, 2003-12-24 at 17:14, [EMAIL PROTECTED] wrote:
List , sorry to keep troubling you all
44 matches
Mail list logo