 | | | Oracle List | | It sounds to me that you meant to say "reparse " instead of "recompile ". If that is true the following may be the doc you are looking for (with tests done on a 9i database)
http //asktom.oracle.coHi List
we had a cancelled query that held 'cache buffer chain ' latches on some objects and took a lot of cpu consumption. The time for the cancel operation takes in our production db (8.1.7) aboPete
That was my thought.
Yechiel you need to look at the PeopleSoft certification matrix (if
there is such a thing) and see what version of Oracle *they* certify
against. I 'll bet you a dohi all
I had got one mail from the group wherein following command was given
alter session set nls_date_format 'dd.mon.yyyy hh24 mi '
alter system set fixed_date ' <anydate > '
this was used to > Is there anyway in Oracle 9.2 to write a trigger that tracks when a user
> was created or deleted at the database level?
>
>
>
> Thanks Todd
--
http //www.freelists.org/webpage/oracle-l
We are using ASSM on most of our tablespaces in a ~6
TB DW without any issues so far where tablespace size
varying from 1 G to 700G.
One instance where we used dbms_redef was to 'shrink '
tablesrjamya wrote
> One thing we found on 10.1.0.4 <http //10.1.0.4 > is large pl/sql
> blocks don 't compile. They fail with pls-123 Program too large error.
> I am currently working on creating a tHi
I am looking for some help/input on managing concurrent managers in an
11i/RAC environment. Following is the environment configuration and the
problem description
I am running Oracle E-busin <FONT face "Default Sans Serif Verdana Arial Helvetica sans-serif " size 2 > <DIV >I might be able to help as well though I 'm at home taking care of my wife after her surgery. </DIV > <DIV > </DIV > <DIV >Hi all. I 'm noticing some behavior in 10.1.0.4 that seems odd.
I have a user A who has been directly granted EXECUTE on DBMS_LOCK and UTL_TCP.
Attempts to DROP USER A CASCADE frequently succeThe answer you want is probably somewhere in here -
http //www.stanford.edu/dept/itss/docs/oracle/9i/network.920/a96581/toc.htm
Without more information (like maybe an error message Oracle Net
Ron
Did you download and install the Java Runtime? Are you following the install steps provided at http //www.puschitz.com/
The site is usually complete and accurate for loading Oracle on Linux.Hi Deepender
I would recommend creating explain plans for the query in 8i and again in 10g and then compare to two to see what has changed. Then maybe you can use hints stored outlines column s
Hi All
We recently have migrated 3 databases to 10g. The two 9i databases are having no problems however the 8i (8.1.7.4) database seems to have several performance issues. We have several queHi gurus
Normally oracle says we can not create tables using the keywords but when
one issues CREATE TABLE "INSERT " (col datatype) " it gets created. It can
always be referenced and other taskListers
9.2.
SELECT MAX(COL1) FROM FOO
COL1 has been created as a DESCENDING index. An index fast full scan is used
to resolve the query. If *not* defined as a DESCENDING index then the
"Has anyone used veritas ' global replicator? We are
will be comparing it with Oracle Dataguard and I was
curious if anyone could point me to good info on it or
tell me your experience with the produHello Deepak
First off I need to correct myself. Oracle correctly invalidates your
package. I wrongly assumed that a plsql object should only depend on
the signature of a table and not on its paI was playing around with setting the fixed_date. I was able to set it
to some other date. But I cant set it back to current date (sysdate).
Tried googling for 'unsetting fixed_date ' 'setting sysIs anyone out there running Lawson? I would like to know what type of
auditing you are doing to be SOX compliant. We have a small environment
here with only 3 users LAWPROD LAWTEST and LAWLOGANHello everybody
Working with a client we 've discovered an as-yet unpublished and
data-corrupting bug in the current release of the Oracle thin JDBC
driver (10.1.0.4).
We 're tired of waiting fIn 10g 10.1.0.4 STANDARD edition the following is introduced in your
alert.log file
Unable to restore resource manager plan to ' '
ORA-02097 parameter cannot be modified because specified Paula
I 'm not familiar with this particular tool but if it draws nice
graphs your management will love it! It strikes me that you run out
of capacity at the server level so you may want to enshi gurus
Can we stop accessibility of OEM through a particular machine? If yes then
how?
--
Thanks & Regards
T. Onkar Nath
Ph +91-9826728111(Cell)
to_onkar@(protected)
onkarnath.tiwary@Hello list
Coming to the point when we modify or delete statistics using
dbms_stats for any given table/s all dependent cursors becomes
invalid and re-parsed once they are accessed. using
no_That won 't work. He then would say "We had a lousy bunch of developers
at that time and - Hey Kevin weren 't you on that project? "
LOL!
Is the table(s) partitioned? Do they have Bitmap
indexes?
--- Karthik <karthik@(protected) > wrote
> Hello
>
> I have code that consistently bombs due to ORA-600 -
> Deadlock Detected.
>Friends --
You know it 's not something that comes up everyday but back in v5
you used to be able to do column level grants... that is to say
grant select on tabl(col1 col3 col5) to userX
> I do not recommend that you use this command but it did work
for the test server on which ASM was installed.
> dd if /dev/zero of /dev/hda5 bs 1024 count 64
Being a Linux disk name andGreat Company in North Dakota (city of 150 000) has an opening for an
Oracle DBA / Siebel Administrator to join their IT team.
They are looking for someone who lives in or has a reason to live in |
|
|
