 | | | Oracle List | | Hello Jeremy
CBO assigns default cost and data distribution statistics for functions that
do not have associated cost. In at least 9i I saw the actual "assumed "
numbers in the 10053 trace.
You can google for "logon trigger "?
2007/6/12 Krishnadas.Chathamath@(protected) <
Krishnadas.Chathamath@(protected) >
>
>
>
> Hi
>
>
>
> How can I restrict the no. of sessions connected based
Try starting the listener without listener.ora file (temporary rename it
to *.bak for example). If it works then you probably encountered a
network / nameresolving problem
-----Original Message----as well as format_error_backtrace in v10 plus a whole shedload of various
attributes available from SYS_CONTEXT( 'USERENV ' '... ')
-----Original Message-----
From oracle-l-bounce@(protected) [mailHi Ujang
I have seen this behaviour. It happens going from 9 to 10 at any level.
In the case I had was due to things doing joins whose performance
changed due to the effects of the optimiser.
You wiI am working on a project where we have to separate a database and schema into two. The biggest issue from a database-side is underlying objects called accessed from packages procedures and views iSure! Use "ALTER TABLE ... MOVE TABLESPACE <another-tablespace > " to
move 'em out.
...don 't forget to ALTER INDEX ... REBUILD on any indexes associated
with a moved table...
Binh Pham wrote
> WAfternoon everyone. I 'm on Oracle 10.2.0.2 on RHEL3.
I 'm exploring the option of using the "rolling forward image copy "
method of incremental backups with RMAN as detailed in section 4.4.3
of of BaIt is possible to find out using dictionary/v$ views how much the online
redo log file contained when it was switched? i.e. it is possible to
estimate/calculate mb of archive log generated per hour wiUL stands for 'User-defined Lock '. Obviously some of your sessions are waiting because of user locks. See DBMS_LOCK package.
Regards Joze
conventional wisdom (and TFM) will point to a user generated lock. Perhaps
someone is _actually_ using dbms_lock?
Rjamya
On 6/11/07 Dean Richards <snowman327@(protected) > wrote
>
> Does anyone knoIt seems that a two socket Dual Core Xeon 3060 processor at about 2.4 GHZ
would do the trick CPU wise. It sounds like about 2GB of memory would work
but we 'd need a little more information to be sure
Hello
Has anyone had any experience with Radius and Oracle? I am having an issue
getting Oracle and Radius to communicate correctly.
I have Oracle 10G installed on RHEL Linux 4 ES and also have Yes you can query the AWR - but the queries provided below only show
the first & last time of the sql_id not the specific plan. To find the
details of the plan you 'd want to run something like thi
Folks
Is it possible to connect via JDBC to an Oracle user that is IDENTIFIED
EXTERNALLY?
If so what would the connect string be?
John
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//ENAfter having applied 10.2.0.3 Patch5 for Microsoft Windows *x64* (5946188)
smon crashes intermittently during startup with ORA-600/ORA-7445 [kcbzfb_1].
ORA-07445 exception encountered core dump [ACAnurag -
With some kernel mods (BigOS Kernel or some such been a long time) and
relinking the Oracle binary to load into an address in memory above the
2 Gig mark. This is well known and should ha
I had been following the thread "Varying plans on different nodes "
(but may not have read all the emails in that thread)
The question I quote below seems to have come up a few times
>Could you pJonathan
DB version 10.1.0.5
System stats are gathered by Oracle 's default job which runs in the default window.
Thanks
Jonathan Lewis <jonathan@(protected) > wrote
Are you I 'm constantly seeing duplicate messages but I just thought it was on
my end because no mention on the group.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounceBrian
Take the subject of this message without the "RE " put quotes around
it and do a MetaLink search. You should see 4 different documents all
apparently relevant.
-Mark
PS The error hOn 6/8/07 Schauss Peter <peter.schauss@(protected) > wrote
>
> Environment Oracle 10.2.0.2.0 HP-UX B 11.23
>
> I am performing hot backups with rman in nocatalog mode.
The first thing you should consIs it possible to recover information from an undo datafile? I have
been searching for information on securing oracle datafiles and see that
there are .dbf file viewers that claim to be able to viewWell a function is supposed to return a value so you would have to
Declare
Variable <type >
Begin
Variable function(a b ...)
End
I would wrap it in a package for security.
_______All -
I think it was discussed on here before but I can 't find it. I am
looking for/building a script to transport table spaces from AIX to
Linux which have different endains. Anyone have one thI am looking for a good book on SOA (Service-Oriented Architecture). Are
there any recommendations on what book should I look at?
Thanks
Amir
--
http //www.freelists.org/webpage/oracle-l
Everybody
I am getting this error and I can not see what is the issue. Normally I am
able to find the discrepancy quickly but
I just can 't see any difference here. I have opened an SR with Oracle a
Hi List
We have a table that has a blob column. We copy the table to another database nightly through DB link. Before we upgraded to 10.2.0.3 from 9.2.0.6 inserting 135 records took 25 seconds.Rob
We had a problem recently where it started skipping a particular job
because the agent was down (something to do with bug 430200.1). Is
the agent running (emctl status agent)?
- David Lord
On |
|
|
