 | | | Oracle List | | Thomas
The LAST_CALL_ET column signifies (in seconds) the last time a session did
*anything*. This value is a delta offset from sysdate.
So the following query would show you the last time tJack
just curious
Are you using the 'vanilla ' standby or Data Guard?
Data Guard is there for 817 of HP as a secret but free option.
Here you find the docs
http //otn.oracle.com/docs/deploHello
We have 2-node OPS cluster (8.1.7.4) mostly OLTP. The system is
(predictably) susceptible to high CPU saturations. From the 10046
traces I see PCM lock contention for indexes of hot (highHas anyone successfully loaded Enterprise Manager 10G Grid Control
(10.0.1.2) on AIX 5.2? I have had a tar opened now for a week and
support hasn 't come up with anything useful. I am getting an eHi Gurus
I have to calculate the CPU time taken or utilized for execution of various application packages/procedures during various phases - such as Parse Execute and Fetch (where applicable).
IHi all
I am sure that inittrans is one of the values controlled by oracle when
you are using auto segment management on a locally managed tables.
Am I correct or is this still a DBA managed valit is the rowid on which the waiting session is we... waiting. That
can be seen in v$session the columns to use are
row_wait_obj# - > the object
row_wait_file# - > datafile number
row_wait_bloJonathan Gennick wrote
>I 'd argue that Oracle should fix it. One shouldn 't have to
>bother with something as cumbersome as 10046 trace just to
>see an execution plan. I don 't even like having to 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D
3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D
After applying some patches to an HPUX box the problems below began to
occur. ThisRaja
We don 't even do delete 's on this table - nothing. Oracle cleans it up for
us at the end of each transaction.
So I 'd say you are doing extra work.
And what kind of statistics do we exLizz
1) Personal Oracle is licensed by each desktop/laptop it 's installed on.
It 's $400 per user. Oracle Lite may be a better choice as it appears to
have the synchronization features you 'll neTry this. It 's also kludgy but at least its a bit of a smaller kludg.
SQL > select case
2 when ascii(a) < 65 then lpad(to_number(a) 8)
3 else a
4 end
5 from sort_test
6 order by I would like to create a query that runs nightly (maybe a procedure kicked
off from oracle jobs?) that runs a query and if the query results in rows
returned then to have it email to a specified
We are building a Linux Cluster [initially 2 nodes later 4 nodes] to hold
multiple Oracle databases.
On Unix we always maintain seperate ORACLE_HOMEs if there is more than 1
database on a All -
I have an Opalis job that creates a seperate script to disabling
constraints truncating the tables insterting from production
instance and re-enable the constraints. However the SQL erThanks for all of the suggestions. Once we actually have an application
(I 'm beginning to start on that now after 8 years of data cleanup) the
separate table and trigger mechanism would probably woThis must be PeopleSoft 's real argument for takeover.
On Tue 26 Oct 2004 17 03 46 -0400 Paul Drake <bdbafh@(protected) > wrote
> This is not a joke it really occurred.
>
> Tue Oct 19 22 40 1Environment
Windows XP professional
Oracle 8.1.7.4
Using Database Configuration Assistant following my software vendor 's
instructions I entered the following values for on Rollback tab
Hi All
In order to avoid the data conflict between replicated sites we are
trying to push the changes to the other site as soon as possible.
Questions -
Is it possible to setup more than onOn Tue 26 Oct 2004 14 43 57 -0500 Jesse Rich
<rich.jesse@(protected) > wrote
> The setup is still a but tricky and try to find resources for creating a
> stoplist but it works great fGeorge
Works fine for me in 9.2. What version you working on?
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From Rusnak George A. (SEC-Lee) CTR [mailto georgHi
your query can be like this
select field1 from table1 where length(field1) 4 and
is_number(field1) 1
while is_number is seperate function like this
-- return 1 if input param cUse the silent install *.rsp files and prepare 2-3 batch scripts that
activate the installer with them.
My manual for the people who build database server is
Run script a
Run script b etc.
Th >Why is the 8 bits good and 7 bits bad?
>Is there any valid reason?
>
>-- Babu
I once worked on a military contract. Since at the time it was
difficult to switch charactersets in a database Hi List
On one of our databases the Temp TS is currently 13 5 GB.
The tablespace is type TEMPORARY.
DB version is 9.2.0.4.0 running on AIX RS 6000.
It is a produktion database and bouncSurendra
You mean you took the test and passed?
Congrats!!!!!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From Surendra.Tirumala@(protected) [mailto Surendra.TYep...one more sip of coffee.
I neglected to take out a literal table name from the bottom piece. 20
Sorry about this. ...i promise not to post anything before 8 30am
anymore! ) 20
-----OriNo...i actually didn 't do a straight copy and paste...i have 'where
owner 3D 'OWNER ' '
Sorry about that. 20
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounAFAIK.. The Cost is Aggreagted from the First Step Onwards to the Last
One. So the First Line In your plan is the last step and that is the
Cost of the Plan.
HTH
Cheers
Ganesh
On Tue 26
Hi
I see that CBO did a wrong choice for his plan (HA join is the best not
NL).
I did a 10053 trace and there 2 two things I don 't understand
How is comptutated this line
BEST_CST 2166 |
|
|
