 | | | Oracle List | | You need to search AskTom for the "rownum " trick also. That would
likely work here since it forces the inner queries to resolve. I use
that one quite a bit. Sorry I don 't have more time to test this.
Here is a "why do we do this " question.
Most of the policies I see concerning failed login attempts lock a
user our after a very limited number of attempts. It seems to me that
this feature is best aHi
One of our client wants us to migrate PostgreSQL(Windows) database to
Oracle(9.2.0.6 on Solaris). I had never done this before so just exploring
the possible option/tools.
What are the issues w
Funnily enough the first (technical) slide in my
"Migrating to CBO " presentation at Hotsos shows
how you can increase the CPU and latch activity
even if every single execution plan stays the same.
Issue the statement
select table_name last_analyzed from user_tables
If the last_analyzed column is not null statistics exist (although they
may not be up to date) if it is null statistics do I have a C rouine and I need to be able to run it as an external procedure
under Oracle 10 on linux.
I need to compile it to .so....but how do do that?
--
http //www.freelists.org/webpage/oracle-l
Speaking of triggers not firing anyone seen an example of where a
SERVERERROR trigger does not fire?
I was looking an an issue this week where a log file in an app is
reporting a ORA- error (no dataWe are testing our first volume conversion into Ebusiness 11.5.10.2
currently reviewing performance related patches for this process
My question
Are there any other configuration/set-up activi
There is a big clue in the fact that your PINS rather than
the GETS on v$library cache is the high figure. You are
140 000 gets means not very much new activity in the
library cache in 40 minutes - On Wed 01 Mar 2006 17 35 11 -0800 "GovindanK " <gkatteri@(protected) >
said
> Hello
> I am trying to setup cman After installing i setup the cman.ora as per
> metalink / docs and tried starting theHello
I am trying to setup cman After installing i setup the cman.ora as per
metalink / docs and tried starting the cmctl. I am ending up with
TNS-04012 Unable to start Oracle Connection Manager inHerring Dave - dherri wrote
> Database is Oracle 9.2.0.6 OS is Tru64 5.1 data warehouse environment.
>
> It appears that when using the CAST function with a SUBSTR against data
> from a table thHmm...interesting...I 've never looked at this report......my guess would
be that they are speculating that a disk read takes about 20 ms so
disk_reads/50 would give you seconds. Same idea for buffeI just found the following in the 10.2 documentation on licensing for the Diagnostics Pack ( http //download-west.oracle.com/docs/cd/B19306_01/license.102/b14199/options.htm#CIHHIGBI)
Oracle DiagnHi Mark
The Oracle-L dinner is at the Texas Bar and Grill Tuesday
March 7th at 6 30 PM.
Please send me an email if you would like to attend. There
is a limit to the number of people they can accoI understand that the Diagnostic Pack is a separately licensed product.
It should be available on OTN.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)Rachid
> What is the best strategy to resolve the issue of slow intermittent
> applicartion response time ?
Facts. Read Optimizing Oracle Performance by Cary Millsap. Try to measure
response time aHere is a link for more info on the 10g java console for anyone interested
http //download-west.oracle.com/docs/cd/B19306_01/em.102/b16228/app_java_console.htm#sthref689
-----Original Message--http //www.oraperf.com/ does a pretty good analysis of StatsPack
reports. It 's probably worth a look.
I always start with a quick check of Execute to Parse % and % Non-parse
CPU in the instance effiI think this is a network error. I have seen it when using ssh to
connect to various servers when there is a network issue.
--
Ron Reidy
Lead DBA
Array BioPharma Inc.
-----Original Message-----
Fr
We definitely found that we were getting away with murder on our 9.2.x DB with regards bad SQL. When we upgraded to 10.2 we uncovered some real hornets nests of unbound SQL statements You could examine the listener.log located at $ORACLE_HOME/network/log.
I 've never found anything terribly useful there but it is something you
could check for network-type issues.
I realize this is a basic question but I 'd appreciate a bit of a sanity
check.
I need to install Oracle Label Security on our test box and am
wondering
if I need to shutdown all databases in the sI have 10gR2 on RHEL 4 with no issues. Have you set ORACLE_HOME and TNS_ADMIN
as well as creating a listener.ora file appropriately before trying to start?
You may try running the Network ConfiguratPlease do the following
- Switch of the monitor of you computer.
- Close you eyes
- Say loudly three times "I wona Database! "
- If installation package doesn 't arrear on the nearest shelf to you theGreat link from HJR. I have to say if I search Oracle UseNet my first
search is usually "term + HJR ". He has a knack for making things
plain.
On 3/1/06 LiShan Cheng <exriscer@(protected) > wrote
> Hi
You 're welcome. Another lister Brandon Allen pointed out to me that
shutdown immediate actually waits for rollbacks to complete.
That pending rollbacks would only be an issue if you needed to come
On 02/28/2006 01 07 54 PM john d parker wrote
> 'gcs drm freeze in enter server mode '
>
> Anyone have any indepth info on this event? It was captured in the wild
> during heavy load a datafile waMetalink note 40689.1 has a good explanation of delayed block cleanout.
Regards
Brandon
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behal |
|
|
