 | | | Oracle List | | Just to build on what Kevin has said there have historically been two major
methods for allocating swap space under various flavours of UNIX. With
exceptions of course -- as I recall AIX3 implementYep and if you have SQL statement logging as a requirement for future (e.g.
not just ad hoc) then you could set up fine grained auditing (DBMS_FGA).
FGA is able to log both SQL statements plus bindHi
We have just installed a two-node RAC.
Now we want to test TAF and we wish to know if is
there something special to be tested or just
unplugging one of the nodes and check if the other
node willJohn
> When I query the regular table with some other (indexed) column
> forcing the optimizer to do a table lookup for the later join key
> the join strategy to the inline view changes (to the worWe 're looking for a DBA with 5+ years experience in the Atlanta
Richmond or Orlando area.
Candidate should be experienced in Tuning RMAN partitions etc.
Please send resume to me and I 'll Hi
I have a query that joins a regular table with a "group by " inline view - outer.
When I query the regular table with an (indexed) part of the join criteria to the inline view (part of primary key)What would be the best way to do this in a non-RAC env? All that I can
figure is
ALTER SYSTEM RESET db_cache_size SCOPE memory SID ' <sid > '
/* Since SCOPE spfile doesn 't work in a non-RAC envWe have ran several automated agent installation on windows with no problems
at all - using the agentDownload vb-script supplied by oracle.
Works like a charm just the way it does on *nix
Stefan
OnI doubt that this sql is from a recursive sql. Recursive sql would go straight
after the syn$ table not the all_synonyms view. I am sure (as much as I can be
from the distance) that the sql is issuedORACLE DBA -
Salary $95 000 - $110 000 range
Location Boston MA (Local Candidates Preferred)
Boston client has a fulltime opening for an ORACLE database administrator.
In this position the
As is typical I am going nowhere fast with Oracle UK support and I wondered if someone might be able to point me in the right direction.
Basically I have set remote_dependencies_mode SIGNATURE in Charlotte
> I 'm looking for a "getting started " tip on an XML
> project. I 'd like to publish some XML documents from
> a relational schema (this is a reasonably complex
> mapping not one-table onOS RedHat
DB 10.2.0.2
I am trying to set a new server with two Oracle homes (one for dev
database one for QA) with listeners running in each home on different
ports for each database.
Home 1 dkewl I didn 't know that !!!
Raj
On 8/22/06 Charles Schultz <sacrophyte@(protected) > wrote
>
> I was having a couple sidebars with some folks here and thought to share
> what I have learned. ApologiHello
Recently we have added a few new databases to our development server.
When all (old and new) databases are up and running we can not have
more than 2 jobs concurrently running on this server
select snap_id snap_time from
(
select snap_id snap_time max(snap_time) over () max_snap_time
from $stats where database_name 'monkey '
) where snap_time < max_snap_time
Collier Joshua W - JHi
you have at least two choices
1) DIY with java package
2) buy a commercial product (http //plpdf.com/ for example)
I did some experiments with 1) using iText and it was quite easy to
produce
All you 10g people...stop laughing )
I have a very old (unsupported) Apps 11i HRMS server running OWS
Database (8.05) forms Server and Concurrent Manager running on an NT4
server. Don 't ask...tVivek
The conversion process is in the oracle documentation. We performed a similar activity where we converted a non rac database on vxfs to a rac database running using qfs. We used rman to create here in Austin live music capitol of the world. work for the Austin
ISD on multiple systems dealing with fincinal student information and
accessory systems.
y 'all come on down y 'hear?
--
--
BilDid you have exactly the same execution plan when you ran with the level
1 trace and no trace as the plan you had with the level 12 trace? Same
bind variables for the query?
Rowcache latches are simply latches held so that
Oracle can safely examine the row cache whilst
parsing and optimising a statement. Excess activity
is just another symptom of excessive hard parsing.Hi John
check user_dump_dest for a tracefile whne the error occurs. You 'll see the
permission problem along with the suggested dbms_java call to grant the
permission.
Otherwise call dbms_java.setCan anyone please assist me with java permissions when running a java
function in Oracle 10 on linux?
I use the following java code to run unix commands.
It works fine provided the command does noHi
Anyone know why v$sgastat shows a different shared pool value than the
parameter?
I have a 8.1.74 database in HP-UX
show parameter shared_pool
shared_pool_size string 1572
Thanks Fairlie folks for the great piece of info.
Qs 1 What are the procedures to -
* Convert a NON-RAC Database on VXFS to SFRAC using Veritas CFS
with RAC on Oracle 10g/Solaris 10
* Convert a
Morning Niall
> > There used to be a 10 network connections limit for
> > non-server OS 's.
Interesting. I 've never heard of nor come across that one before. Mind
you I 've always been Unix or WindoThe most important task of a resetlogs operation is updating the
RESETLOGS_CHANGE# in datafile headers (as seen from V$DATAFILE_HEADER).
All other things like overwriting online redologs and updating
Morning Anand
> > While trying to connect thru client it is not allowing more than
10 connection in a while.
> > Can anyone please help me out how to increase the instance session
pool capacityTim
> Could delayed block cleanout from a massive UPDATE or DELETE be
> causing high LIO? Perhaps someone else can confirm but I think
> the count for "current " (a.k.a. "db block changes ") should b |
|
|
