 | | | Oracle List | | hi list
I have a strange but interesting problem. I have three tables with below
structure I need to generate a text file using a PL/SQL block on the basis
of below criteria
Table1 structure
***Aha events 38044 and 38056 did the trick now it is peeking the variables
and get a proper cardinality by the way the version of the test database is
9.2.0.8 so it 's ok however the production is 9.2.Hi Cheng
Maybe you would ned to open an SR for this. There are some 9.2
cbo-related bugs fixed on CPUs since the release of 9.2.0.8 . Your
9.2.0.8 is patched with any of them?
It would a case for Hi all
I have a query which involves three table joins a range predicate with dates
with bind variables. The predicate asks for a 30 minutes range data.
num_rows t1 463220
num_rows t2 15
num_rows tAlex and others
I was a lucky guy to meet with ASM for the first time 3 years ago on a non-RAC environment on Windows2003 and I was surprised how it worked well. Although we had only 3 mirrored disk
You can read the text of the statspack package and reports in the varous
sp*.sql in $ORACLE_HOME/rdbms/admin. I can 't remember which
file at the moment but one of them shows you that
'transact
Disclaimer
The following opinions are offered for informational purposes only. They
may not
be correct and they may or may not bRepost due to over-quoting...
Interesting. Thanks Niall.
Also thanks to Chris for his reply.
Has anyone else on the list used ASM on Windows?
On 8/31/07 Niall Litchfield <niall.litchfield@(protected) <html > <head > <style type "text/css " > <!-- DIV {margin 0px } -- > </style > </head > <body > <div style "font-family times new roman new york times serif font-size 12pt " > <div style "font-family times new romAdd two more type of cache in the 11g shared pool - SQL Result cache and
PL/SQL Result Cache.
--
John Kanagaraj < > <
DB Soft Inc
http //www.linkedin.com/in/johnkanagaraj
http //jkanagaraj.wordpress.cEdgar
I have heart a mention of this feature in LewisC podcast and also in Oracle
> 11g new feature white paper. Oracle white paper says
>
> With Oracle Database 11g both patch set and release upgAssuming this is a number as you don 't have any quotes around
&blah_variable
Just put blah_col in as the value when the prompt comes up ?
sys@(protected) > drop table t
Table dropped.
sys@(protected) > crJust look at this
Data Guard 2 servers each 4 CPU 's.
EE required 8 * 25k 200K.
Active Data Guard can 'justify ' the extra license cost for a standby.
Active Data Guard yes if another 8 * 5K try ... where blah_col blah_col
(just put the column name in the & variable).
On 8/15/07 Lyall Barbour <lyallbarbour@(protected) > wrote
>
> Hey everybody
> This is probably something easy Hey everybody This is probably something easy and simple i 'm
missing. I 'm using the & in the WHERE clause of a query to get certain
information. How do i get ALL the information too. Essentially Also (aside note) there are one bug in 10.2.0.3 related to hash joins
using excess memory (above pga_aggregate_target).
I recommend getting a "snap " at peak time with the SQLAREAT tools from
CarlAlso (aside note) there are one bug in 10.2.0.3 related to hash joins using excess memory (above pga_aggregate_target).
I recommend getting a "snap " at peak time with the SQLAREAT tools from CarlGreg
See Note Note 163763.1 Diagnosing Oracle memory on Sun Solaris using
PMAP on Metalink.
alvaro
At this point we 've opened a SR with Oracle to followup on the outage
itself but I need I 'm looking for a good way to determine total Oracle memory usage taking
shared memory into account using standard Unix/Linux tools. I can of
course easily determine how much memory the database It might actually be a good idea IF the price on EE itself is reduced.
On 8/15/07 Connor McDonald <mcdonald.connor@(protected) > wrote
> One initial area of disappointment in 11g is that pretty much eI rather agree I find the pricing of these options at half the price of the
established options mildly interesting as well.
Niall
On 8/15/07 Connor McDonald <mcdonald.connor@(protected) > wrote
>
>
Also have you rebounced the instance? AUDIT_TRAIL is static.
?lvaro Fern?ndez
--
If I did not have audit any priv would this sql have failed?
audit update table
I ran this command Lyndon
are you commiting the updates?
Jaust to check in the same UPDATE session before the updates do an
alter session set events '10046 trace name context forever level 8 '
(to trace all ops Also
Have you granted AUDIT SYSTEM privilege to yourself?
SQL > show parameter audit_trail
NAME TYPE VALUE
If I did not have audit any priv would this sql have failed?
audit update table
I ran this command successfully
SQL > audit update table
Audit succeeded.
On Wed 15 Aug 2007 15 08 47 0200
Hi
You have AUDIT ANY privilege to your user?
AUDIT INSERT UPDATE DELETE
ON <
<table >
?
?lvaro Fern?ndez
---
SQL > show parameter audit_trail
NAME SQL > show parameter audit_trail
NAME TYPE VALUE
Did you set audit_trail DB in the init file and restart?
Show parameter audit
audit_trail string DB
Joel Patterson
Database Administrator
joel.patterson@(protected)Where you audit to is controlled by the AUDIT_TRAIL parameter IIRC.
On 15/08/07 Lyndon Tiu <ltiu@(protected) > wrote
> I ran
>
> SQL > audit insert table update table delete table
>
> Audit suc |
|
|
