To check for invalid objects:
select object_type, owner, object_name
from dba_objects where object_type in ('PACKAGE','PACKAGE
BODY','PROCEDURE','FUNCTION') AND OWNER IN
('MyOwner1','MyOwner2') and status = 'INVALID' order
by
decode(object_type,'PACKAGE',0,
-L FAQ: http://www.orafaq.net
> --
> Author: Mark Richard
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---
query from the trace was run.
Thanks.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
m=832261739
>
> Apparently the scale is 100 per second for 8i and 976,562.5
> (1,000,000,000/1024) for 9, but I am not quite clear what could be the
> reference time (the time when counting of tim starts). In different
> databases I tried it, it is usually few months to a year back.
>
quite clear what could be the
> reference time (the time when counting of tim starts). In different
> databases I tried it, it is usually few months to a year back.
>
> BTW, this column can be used if one needs to find out the exact time when
a
> query from the trace was run.
>
Anybody knows of a current "magic" code for a discount on OCP exams. I am
particularly looking into the 8i DBA upgrade if this does matter.
Thanks.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat Ci
.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
at a representative from
> Oracle University told me - but you send an e-mail and you
> wait few days,
> which would like to avoid.
>
> Thanks.
>
> Djordje
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Djordje Jankovic
>
ont mind waiting a few days. I dont see anything on the
> home page about
> a discount.
>
> Thanks
> Erik
>
>
> > -----Original Message-
> > From: Djordje Jankovic [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 17, 2002 4:59 PM
> >
Just to add, something I forgot to say - there are no foreign keys across
apps (one app is just reading other app's data) - so that is not the
problem.
Thanks.
Djordje
> -Original Message-
> From: Djordje Jankovic
> Sent: Tuesday, August 14, 2001 5:52 PM
> To:
: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send
If all
three are corrupted, you have to run the "create controlfile" statement and to
make sure that you list all your data files and redo logs. You will loose
the archiving and RMAN (if you have it) info though.
At
least you will not forget now to backup control files regularly
;-).
D
mediate 'drop sequence temporary_sequence_s' ;
12 end ;
13 /
Procédure PL/SQL terminée avec succès.
SQL> -- please note that 'execute immediate drop sequence'
SQL> -- was successful
SQL> select * from user_sequences ;
aucune ligne sélectionnée
--
Please s
ure ? Any explanation to that
?
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Intern
er way of controlling the workload (especially
> with multiple
> instances).
> Made sense to me.
>
> Djordje Jankovic schrieb:
> >
> > Something I learned today, but haven't seen it documented
> anywhere and would
> > like to see whether anybody has come
have to change anything.
>
> This has been around for as long as I can remember using the listener,
> which means going back to version 6
>
> Rachel
>
> --- Djordje Jankovic <[EMAIL PROTECTED]> wrote:
> > Something I learned today, but haven't seen it documen
.
Thanks a lot.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
It is
part of the Developper suite. However, I don't think it is the best tool
for developping oracle stored objects. I know a lot of developpers around
here are using PL/SQL developer (http://www.allroundautomations.nl/plsqldev.html).
Djordje
-Original Message-From: Michael
: primarily
oracle, but DB2 and sql*server if possible.
Any experiences, good and bad, would be appreciated.
Thanks.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
x27;t
hear back from me that probably means that the list was not very responsive
:-(. Also, please let me know if you think some terminology is wrong in
this list.
Thanks.
Djordje Jankovic
[EMAIL PROTECTED]
Oracle SqlServer
DB2
Database
Title: PL/SQL question
Hi
Linda,
You
cannot put a variable instead of an object name (where by object here I
mean owner, table_name, column_name). You have few options:
-
generate a sql hat you would run, e.g. do select 'select
max('||v_column_name||') from ' ||
v_owner||'.'||v_table_
Title: RE: applications patches
Hi,
Anybody happen to know what was the ratio between a
concurrent license and named user license price, when oracle used to have those
licensing models (before switching to famous UPU). I would like to see how
fair is conversion factor of 2 that oracle now
ne : +62 (31) 8708456 ext.113
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Intern
The
safest way is to do a full database export, to create a new 8.0.6 database
instance and to import the data in the new database. You have to see
for inter-version specifics - you might need to use 8.1.5 import version to
import in the 8.0.6 database - you have to check that, but it is fo
from the tape, control files, good data files) as well, so that you
do not have to restore them from the tape again in case something goes wrong
with the recovery.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL
Do a
"dd" on unix and change the contents of any particular
block.
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 2:16
PMTo: Multiple recipients of list ORACLE-LSubject: How
do I corrupt a block
hi,
This may sound funny. I wa
? This is reallly important as a project is depending on
that.
Thanks.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
as I can see, COPY command does
> not allow a
> subquery.
>
> I am on 8.0.4.
>
> If anybody has had a similar problem and has found a
> workaround, or another
> idea how to copy a part of a table with a long field would be
> very much
> appreciated ? This is realll
or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City
Hi,
Anybody has any gotchas with setting of shminfo_shmmax on Sun Solaris ?
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
hysical reads'
/
Block Gets Consistent Gets Physical Reads Buffer Cache Ratio
------
235,191,957 12,077,935,4592,177,467,949 82.316
Thanks.
Djordje Jankovic
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
ckground atop, and v$process have the parallel processes as well. On the
other hand "operating system processes" more relate to v$process, as this is
where you have OS process ID.
Any thoughts ?
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: D
stand them, oracle does not use them and do not care about them,
only some apps might break (most of all DBA type of scripts).
Thanks.
Djordje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
permit
the creation of tables for storing statistics on their production
databases.
Thanks.
-wk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
anagement, cursor space and other
things, but that's all the information I could get out of that book.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5
kton fall into line..
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- P
May be
he was in South America or on a Caribbean beach ;-).
Out of
curiosity, which database is much used ? Or none ?
-Original Message-From: Bunyamin K.Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 12, 2001
11:50 AMTo: Multiple recipients of list ORACLE-LSubject:
38 matches
Mail list logo