Re: E-mail from Alert Logs

There is a program (AUTOMAIL) which sends an email to anyone you idntify when there is a change in a file. Look at it . It is attached . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:00 PM Hi List Is there any way of

HOW TO CACHE THE TABLE??

I wonder how can I cache a table other than creating it with the cache option.?? Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729

Which tables are in buffer cache.?

Hi all gurus, I want to learn the way to ook at Which tables are in buffer cache./Analyzed? Is there a system view showing these tables?? Thanks to All. Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile

script to run before startup

I want to run a script after the startup of database automatically. How can I do this on NT?? Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729

lock modes

Can anyone explain the lock modes written below.What do they mean . And how will I open the lock? Regards Exclusive Row Excl.None Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729

Re: Need fragmentation reports

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Book

Hi, Gurus, Can you give me an advice about a performance book. I want to buy a oracle performance tuning book where scripts are available and like a handbook. What is the name and ISDN of this book? Thanks bunyamin

X$BH TABLE

CAN ONYBODY EXPLAIN ME , when ý query x$bh table as a state field , I get 0,1, or 3. What do these values mean? And in the query select decode(state,0, 'FREE', 1, decode(lrba_seq,0,'AVAILABLE','BEING USED'), 3, 'BEING USED', state) "BLOCK STATUS", count(*) from x$bh group by

Re: DBMS_OUTPUT.PUT_LINE

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Limit

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

DBMS_UTILITY ?

dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; 1) wHAT DOES THAT PROCEDURE DO? I could not find it in the documentation. Does it analyze all tables in a given user.?? I mean Does it do the below? 2) Then what is NULL and 5 is used for ? Analyze table scott.xxx estimate

Re: Tables and indexes on different disks

-- Author: Bunyamin K.Karadeniz 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

anyone interested in XML

Hi all , Nowadays , I have to write an XML application for querying from Oracle dtabase and showing the results in a web browser . What must I do ? I have read a book of XML but I did not understand how I will connect to database and load the query results to xml tags. Is there any

Re: anyone interested in XML

ptive, to have no goal. ..." Herman Hesse, "Siddhartha" - Original Message ----- From: Bunyamin K.Karadeniz To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 27, 2001 14:40 Subject: anyone interested in XML

Re: proper database sizing ?

containing: UNSUB ORACLE-L (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: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City

Re: proper database sizing ?

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

free tool??

Hi All, I would like to ask you IF YOU KNOW ANY **FREE** MANAGEMENT TOOL which shows database performance,space management statistics,schema objects and their properties? Thanks to All . Bunyamin Karadeniz

number(p,s)

number(p,s) datatype conflicts my mind. every book tells that -84 s 127 How can s be minus. Negative scale??

trigger

Why is referencing keyword is used in triggers ,? I looked at the documentation but could not understand Why I can use it ? TIA Bunyamin

Re: drove me crazier!!!

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: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: ***Urgent Question***

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists