Re: invalid procedure/trigger

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,

Re: Tricky query question

-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 > ---

tim column in trace output

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

Re: tim column in trace output

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. >

Re: tim column in trace output

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. >

OCP discount

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

OTN discount for OCP exams

. 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

RE: OTN discount for OCP exams

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 >

RE: OTN discount for OCP exams

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 > >

RE: Splitting a database: pro and cons

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:

Splitting a database: pro and cons

: 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

RE: Lost of all Control Files

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

RE: create sequence in PL/SQL anonymous block - needs to be in se

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

Listeners listening to multiple IPs

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

RE: Listeners listening to multiple IPs

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

RE: Listeners listening to multiple IPs

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

Solaris 2.8

. 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

RE: Newbie kinda question

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

Change management tools and methodology

: 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

Speaking the same language

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

RE: PL/SQL question

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_

Oracle license historic price

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

RE: How to make DBA cannot 'see' User's Tables?

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

RE: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P

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

RE: Database Down

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

RE: How do I corrupt a block

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

Join in the SQL Plus COPY command

? 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

RE: Join in the SQL Plus COPY command

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

RE: Anybody using Network Applicance Storage boxes with Oracle?

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

shminfo_shmmax

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

v$buffer_pool_statistics

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]

PROCESSES parameter

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

Patchset installation

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

RE: Bstat/Estat File -> Table?

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,

RE: ksedmp

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

RE: Homepage and Internet services for the DBA

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 --

RE: Ugly error in alert log

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

RE: oracle and America

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: