 | | | Oracle List | | You seem to be jumping through a lot of hoops to solve a fairly
straight-forward (sounding) problem.
Your first step should be to optimize / rewrite the query to perform less
I/O and or execute more just to check the validity of a theory
I have recently problems with a DB where the permanent memory went up to 185m due to heavy fragmentation
sums taken from x$ksmsp excluding ksmchon like(retry due to overquote...)
Do you have you optimizer_mode set to first_rows by any chance?
IIRC this way optimizer will always choose index scan if that helps
to avoid sorting - regardless of the cHow to get DDL for contexts?
recently we had to import/export schema which made use of contexts
(create or replace context ... etc)
Oracle is 9i.
imp/exp did not catch contexts which seems to bOnce upon a time I had a session hanging w/o entry in v$session.
Somehow I found the process id and killed it from OS.
> Cheers Nigel
I had sussed that out to be honest. What I don 't understand is how why
you do not see the frequency of the job when querying the scheduler
SELECT start_date end_date next_run_date lastoracle version?
On 04/07/06 Oliver.Jost@(protected) <Oliver.Jost@(protected) > wrote
>
>
> Hi All
> I did some testing on this quite some time ago and was hoping to have a
> refresher.... IHello!
I 'm playing around materialized views a bit and the general question
is - can i somehow find out whether a query was rewritten or not from
v$ views. I can of course query v$sql_plan for mat_viHello All
We have a strange issue.
We have a RAC of two nodes 9206 on windows 2003.
From time to time one server was hang usually at 03 00. When this
happened the other instance also stop respondIn the same way as zour OS does.
2006/7/4 Sinardy Xing <oracle.rdbms@(protected) >
> Will Oracle see Intel Duo Core as two CPUs?
--
Best regards
Alex Gorbachev
http //blog.oracloid.com
--
http /Under what circumstances will a cursor be listed in V$SQL_SHARED_CURSOR
but have all "N " for mismatches? I looked around in askTom and google
but trying to find the right keywords is tricky. The docuI will be out of the office starting 07/03/2006 and will not return until
07/05/2006.
I will respond to your message when I return.
--
http //www.freelists.org/webpage/oracle-l
Have you searched under the sink?
I connected into 10.2.0.1 database with user that is granted DBA rule
and I can query this view.
Connected normally or connected as sysdba.
Adar Yechiel
Rechovot Just a wild guess - check if there are nightly jobs to collect statistics.
Best thing is to trace your batch in the first day and any other day - this
way you can surely compare execution plans and whNot an answer to your question directly but perhaps you can try to
add one filtering condition to your join query so that it targets
specific partition (you mentioned that all rows in GTT match a si
A new customer has an issue where their new T2000-based RAC
cluster running Oracle clusterware (CRS) has a node go to reset under
moderate to intense disk IO workload (10GR2 Solaris 10). The nod > I need to modify certain file using sed. Pattern can be both upper/lower
> case.
> Sun Solaris sed doesn 't have /I switch that GNU sed has.
> Does anybody know how to perform sed insensitive search 2 node RAC 9205 on RH 2.4.9-e.57
I have a number of SQL statements that each use a large amount of shared
memory and have high version counts. Taking one as an example it is a very
small SQL statemEnvironment
9.2.0.5 on Red Hat Linux ES3
I was checking backups from last night with the following oddity. The job failed with "User Authentication Failed. " Simple right? The oracle user accouWhat could explain the following unaccounted for time? And Yes I know
the app parses too much. I only get digest so please CC personal address
in responses as well. Thanks!
insert into table(TextId
I will be out of the office starting 30/06/2006 and will not return until 03/07/2006.
I will respond to your message when I return.
---
This e-mail may contain confidential and/or privileged infor
Morning all
quoting Cary & Jeff in "Optimising Oracle Performance " page 81
Note that WAIT lines appear in the trace data *before* the database
call that motivated them.
I have the following Intended to cc the list
---------- Forwarded message ----------
From Niall Litchfield <niall.litchfield@(protected) >
Date Jun 30 2006 1 00 PM
Subject Re about "Oracle recommends that unique indexe > Can any one please help me regarding
> manul cloning of oracle apps 11i not the Rapid Cloning..
>
> And also the difference between Manual and Rapid Cloning..
MetaLink Note 135792.1
Cloning OraclI 'm growing concerned about the same thing after seeing some of the
comments on this list. I just implemented my first 10g system (10.2.0.2
on AIX 5.3) about a month ago and I decided to go out on a Hello community
Just wonder if anybody from you can comment
A.FS
In case of a regular File System (FS) Oracle process passes file name
and relative block number to FS/OS code is responsible for reHi Mike
I had to work with 9iR2 agent on snmpdv1 / AIX5.2L ... an year back.
I had to make a couple of entries in snmpd.conf
One thing i clearly remember is
9.2.0.1 agent doesn 't work with SNMPDThe technique I have used is to create a temporary table with a CLOB datatype insert the LONG data into the CLOB then you can manipulate it.
I also used the following code to get around a dbms_metaHi all
Got a 2 node RAC in noarchivelog mode
Whats the steps required to get it into archivelog mode
Using ASM
George Leonard
Hi All Could some one share shell script for auto standby databases
and listeners startup and sync with primary databases after standby
server reboot?Sun OS Oracle 8.1.7.4 and 9.2
Thank you
|
|
|
