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
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 receiving an e-mail or sms , whenever a ORA- error > appears in the Oracle Alert Log, or when something unexpected happens to > the Oracle Instance ? > > > TIA > > Saj > > -- > Sajid Iqbal > Database Team Leader > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sajid Iqbal > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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). automailer_free.zip
does anybody have a doc on SQL Tuning??
I need a document with examples on sql tuning. Does anybody have it? I am putting the smallest tables at the beginnings and large ones at the ends of the Where claouse of query. And I am carefull of using columns order due to the order of primary key indexes's column order BUT query never use any of my index... Why ? Thanks to all.. Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
X$ tables ??
I see that there is no X$ tables in my database or I can not view them . My O.S. is NT . How can I view them.?? Thanks Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
Re: Which tables are in buffer cache.?
Thanks so much Suhen.. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 02, 2001 11:25 AM > Bunyamin, > > You can check how many blocks are in the buffer cache for segments through > the x$bh and v$bh views. > > Try this query, > > select "count",b.object_name from > (select count(*) "count",objd from v$bh > group by objd) a, user_objects b > where a.objd=b.data_object_id > / > > Regards > Suhen > > > > > > 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 Tel : +90 535 3357729 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Suhen Pather > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
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 Tel : +90 535 3357729
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
which tables to cache ?
I am planning to cache some tables in my database butI can not decide on them. I have 5 big tables ,150 small tables. these 5 big tables sum is bigger than total size of database buffer cache. Is it good to cache them because I have so much complex views collecting data from these big tables.?? 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
Nobody have a script for fragmantation report. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, April 09, 2001 4:45 PM > > We're trying to determine which partitioned tables > are good candidates for reorganization due to > fragmentation. > > Anybody got any good scripts that would detect > various kinds of fragmentation. Perhaps someone > could point me in the direction of some on various > web sites? > > Thanks in advance for your help. > > Cherie Machler > Gelco Information Network > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
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 decode(state,0,'FREE',1,decode(lrba_seq,0, 'AVAILABLE','BEING USED'),3, 'BEING USED', state); BLOCK STATUS COUNT(*) -AVAILABLE 3928BEING USED 72 You see I do not have FREE blocks . Is it a problem.? Thanks
Re: DBMS_OUTPUT.PUT_LINE
I looked at the documentation and could not see a function giving that . But you can declare a variable and increase it after each insert ( if you do the inserts in a loop , it is good). Then dbms_output.put_line(variable_name); Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, March 20, 2001 3:50 PM Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: Limit
It must be 16 for oracle 8 if I do not remember wrong. You can try it. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, March 19, 2001 2:10 PM > Hello Gurus > > I just want to know the number of columns that can be combined to make a > primary key(composite). > > I have a table with 16 columns of which I would like to make a combination 6 > columns as a PK. > > The volume of records may be 10,000 or less. This table will be used to > generate a report(thro a screen). > > Any suggestions on how to design the table > > TIA > > Regards > Vishak > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vishak > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: Tables and indexes on different disks
May be because offragmantation problem of indexes. JUST an IDEA ... Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 5:31 PM > Hi all, > > I've read an interesting section in Oracle Docu (Tuning I/O): > > --- > Separating Tables and Indexes > > It is not necessary to separate a frequently used table from its index. > During the course of a transaction, the index is read first, and then > the table is read. Because these I/Os occur sequentially, the table and > index can be stored on the same disk without contention. > --- > > Why do you then recommend to separate tables and indexes to different > disks? > > Thanks > Mike > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Michal Zaschke > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
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 statistics; // repeating for all tables of user.
oracle and America
one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA
Re: anyone interested in XML
Thank you Marin, - Original Message - From: Marin Dimitrov To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 27, 2001 4:20 PM Subject: Re: anyone interested in XML http://technet.oracle.com/tech/xml/#techinfo is the place to start reading from For returning data to XML u have several options: - use the Oracle XML SQL Utility (http://technet.oracle.com/tech/xml/oracle_xsu/) which will "generate an XML document (string or DOM) given a SQL query" or "Extract the data from an XML document, then insert the data into a DB table, update a DB table, or delete corresponding data from a DB table" - use the XML parsers available for Java/C++/PLSQL and transform the results from a query into XML document hth, Marin "When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking,because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, 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 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 examples on internet about this subject? I found a lot of but not able to find a database application. Or can anyone show me the way ? Thanks .. WORLD IS GOING TO WEB. A DBA MUST BE AWARE OF WEB TECH. this is my opinion BUNYAMÝN KARADENIZ
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 examples on internet about this subject? I found a lot of but not able to find a database application. Or can anyone show me the way ? Thanks .. WORLD IS GOING TO WEB. A DBA MUST BE AWARE OF WEB TECH. this is my opinion BUNYAMÝN KARADENIZ
Re: proper database sizing ?
Herman , Hope this helps some. first decide sizes of tables and indexes. avg_numberofrows*numberofrows*1.5(tables and clusters) avg_key_len*num_keys*1.5(indexes) then sum them to decide on tablespaces size. * always size for 1 year as a minimum.. Bunyamin K. Karadeniz / TURKEY - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 12:15 PM > Hello all, > > I've been pointed by the boss, to design our database application. > I've a bit oracle background, > it's just that I wanted to know what are the things that we need to notice > when we do database sizing, and how to do the right calculation. > Is there a documentation in the web site how to do that ? > or someone can share his/her experience when sizing the database ? > > thanks a lot > regards > Herman > > > > > > Think you know someone who can answer the above question? Forward it to them! > to unsubscribe, send a blank email to [EMAIL PROTECTED] > to subscribe send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Herman > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: proper database sizing ?
This is a complex and long thing to explain . You must read documents of oracle's own. And I can give you some links. www.searchdatabase.com http://ora.dbasupport.com www.geocities.com/csbabu/ www.orafans.com www.oraclenotes.com If you search these sites , you can find docs related to your problem I think. Bunyamin Karadeniz Database Support Engineer / Oracle,SQL Server HAVELSAN A.S. / TURKEY - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 12:15 PM > Hello all, > > I've been pointed by the boss, to design our database application. > I've a bit oracle background, > it's just that I wanted to know what are the things that we need to notice > when we do database sizing, and how to do the right calculation. > Is there a documentation in the web site how to do that ? > or someone can share his/her experience when sizing the database ? > > thanks a lot > regards > Herman > > > > > > Think you know someone who can answer the above question? Forward it to them! > to unsubscribe, send a blank email to [EMAIL PROTECTED] > to subscribe send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Herman > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
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??
Re: Renaming a Column
No , in 8i it is still impossible to rename a column.Only you can drop a column. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 4:20 PM > "Cale, Rick T (Richard)" wrote: > > > > 8i allows dropping a column or marking them as unused. I do not think you > > can yet rename a > > column. Please provide an example. > > > > Thanks > > Rick > > > wel... you cluld always add the new column, populate it with the old > column's data, then drop the old column. provided you are on 8.0.(?) or > better and that you aren't working with a 3rd party software. > > > -- > Bill Thater Sr. ORACLE DBA > Telergy, Inc [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
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!!!
REALLY IT WORKED??? HOW , CAN YOU WRITE THE SCRIPT.. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 10:50 AM hi pals, I defied my customer that this won't work,and thanks to you it worked!! Now,I have to convince him that what I had said to him was wrong!! thanks folks! dba Mohammad Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: ***Problem***
Yes , Jusy As you say,Mark .. Thanks. Using = seems unreliable to use. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 1:41 PM select empid, empname, dept from employees where rownum = 3546; When you are looking for scott.. That is pretty unreliable, and I think that is what Bunyamin(?) was getting at.. Regards Mark -Original Message- Sent: Sunday, February 04, 2001 02:40 To: Multiple recipients of list ORACLE-L I agree with your solution. But why, using a ronum on a single select statement may not be reliable ? Mark Leith wrote: > In this case, the rownum should not be a problem when using it in a sub > select? You are only trying to get the first seven rows from the sub > select.. Whats the problem? > > Fair enough, using a rownum on a single select may not be reliable, but in > this case it should work like a charm.. > > -Original Message- > K.Karadeniz > Sent: Thursday, February 01, 2001 12:31 > To: Multiple recipients of list ORACLE-L > > No, No not for this statement , my group leader tells that rownum is not > used so much in applications becouse it can give wrong results sometimes. I > do not know if it is correct . I ask you for approve him or not.. > Thanks > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, February 01, 2001 1:25 PM > > paresh mehta, > what was wrong with the sql-statement using > > It works perfeclty, or am I wrong ?? > > regards > > > Frank Foelz < > _ > Scheidt & Bachmann GmbH > Gestaltung Parkhaussysteme > Breite Strasse 132 > 41238 Moenchengladbach > > Phone : ++49 2166 / 266 - 837 > Fax: ++49 2166 / 266 - 615 > e-mail : mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > URL: http://www.scheidt-bachmann.de <http://www.scheidt-bachmann.de/> > > > -Ursprüngliche Nachricht- > Von: Local Folders [mailto:[EMAIL PROTECTED]] > Gesendet am: Donnerstag, 1. Februar 2001 08:35 > An: Multiple recipients of list ORACLE-L > Betreff: ***Problem*** > > Consider the following case. > TABLE : DEPT > empid number, > deptid number, > deptnamevarchar2(30) > primary key (empid, deptid) > > now i want to fetch first seven records from a cursor whose deptid is > maximum > and empid is minimum. kindly let me know how to write this cursor > statement.for example. > > SQL> select deptid, empid from dept; > > DEPTID EMPID > - - > 2 94204 > 2 94205 > 2 94206 > 2 94207 > 2 94208 > 5 94209 > 5 94210 > 5 94211 > 5 94212 > 5 94213 > 7 94214 > 7 94215 > 7 94216 > 7 94217 > 7 94218 > > 15 rows selected. > > i want output as following by single query. > > DEPTID EMPID > - - > 7 94214 > 7 94215 > 7 94216 > 7 94217 > 7 94218 > 5 94209 > 5 94210 > > 7 rows selected > > kindly reply.. thanks in advance. > > regards > paresh mehta > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Foelz.Frank > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a li
Re: Backup and Recovery Question
As far as I know. Read carefully. Time1...Time2..Time3 Time1: Backup time( you said 4 days ago) Time2: drop table command time (you said 9 AM) Time 3: Now . İf you are sure you have all the archieves between T1 and T2 and between T2 and T3. Then You must do an incomplete recovery. No other chance.. but do not be panic. you will recover the data between T2 and T3. *** FIRSTLY BACKUP YOUR DATABASE NOW . DO NOT FORGET IT. tHEN 1) Copy the backup datafiles (4 days ago files to the database's real datafile directory.) That means return to 4 days ago. 2) >SELECT * FROM v&archived_log; // to control if the arhieve files exist between T1 and T2 ) and be sure that they occur in the operating system. 3) >RECOVER DATABASE UNTIL TIME 'T2'; // bE SURE OF SYNTAX.GIVE A TIME 5 SECONDS BEFORE THE DROP TABLE COMMAND EXECUTED. You will recieve suggestion messages for each archive file . Go with ENTER key Until you take the message 'MEDIA RECOVERY COMPLETED' Now you came to T2 time but now you must open the database With RESETLOGS. **DO NOT FORGET IT* Very Critic .. 4) >ALTER DATABASE OPEN RESETLOGS; // ***Never forget RESETLOGS;***I again say. 5) Now take the export of the database . Because you will import the dropped table into database when you come to T3. For example; >EXP scott/tiger file=C:\exp.dmp tables=dept; 6) Now connect with internal and shutdown the DB. 7) You will restore the dbf files that you backed up in time T3. Copy the dbf files of T3 time to their original place in operating system. (Where DBMS looks for them). Now you are again in Tİme T3 . But you have an export of the dropped table. 8 ) oPEN THE DB Then import THE TABLE. After you import it , in my opinion again take a backup. THIS was LONG , I GOT TIRED WHILE WRITING THEM BUT MAY (IN MY OPINION WILL) HELP YOU. but aGAİN I REPEAT . BEFORE ALL THE OPERATION S TAKE A BACKUP BE SURE YOU HAVE ALL ARCHIVE FILES. DO NOT FORGET TO OPEN THE DATABASE WITH RESETLOGS IN THE 4th STEP.. BYEE Bunyamin Karadeniz An Oracle Lover . Want to be a DBA. But no Chance. - Original Message - From: Sanjay Kumar To: Multiple recipients of list ORACLE-L Sent: Thursday, February 01, 2001 8:16 PM Subject: Backup and Recovery Question Hi, I have a situation like this. I found a user dropping a table today at 9 AM but I came to know about that only at 2 PM the same day. I have a backup which was taken the previous day at 4 PM. My database runs in Archivelog mode. I want to restore the table. If I put the database in recovery mode and recover using until time option then I may loose all the transactions that happened between 9 to 2. But I dont want to loose that. I donot have a export. How do I accomplish this? Help Appreciated. Vinay
Re: ***Problem***
Thanks Marin... - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 3:55 PM > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, February 01, 2001 14:31 > > > > No, No not for this statement , my group leader tells that rownum is not > > used so much in applications becouse it can give wrong results sometimes. > I > > do not know if it is correct . I ask you for approve him or not.. > > we use ROWNUM restrictions extensively without any problem > > probably your manager has a mistaken by a wrong use of ROWNUM restriction > and ORDER BY clause in the same query (rownums are assigned as rows are > processed, before the sorting step so if u use "rownum < X" and ORDER BY > together u'll get wrong results, u have to use subqueries as was shown in > one of the previous emails) > > hth, > > Marin > > > "When someone is seeking, it happens quite easily that he only sees > the thing that he is seeking; that he is unable to find anything, unable to > absorb anything, because he is only thinking of the thing he is seeking, > because he is obsessed with his goal. Seeking means: to have a goal; > but finding means: to be free, to be receptive, to have no goal. ..." > > > Herman Hesse, "Siddhartha" > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Marin Dimitrov > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: ***Problem***
No, No not for this statement , my group leader tells that rownum is not used so much in applications becouse it can give wrong results sometimes. I do not know if it is correct . I ask you for approve him or not.. Thanks - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 1:25 PM paresh mehta, what was wrong with the sql-statement using It works perfeclty, or am I wrong ?? regards > Frank Foelz < _ Scheidt & Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> URL: http://www.scheidt-bachmann.de <http://www.scheidt-bachmann.de/> -Ursprüngliche Nachricht- Von: Local Folders [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 1. Februar 2001 08:35 An: Multiple recipients of list ORACLE-L Betreff: ***Problem*** Consider the following case. TABLE : DEPT empid number, deptid number, deptnamevarchar2(30) primary key (empid, deptid) now i want to fetch first seven records from a cursor whose deptid is maximum and empid is minimum. kindly let me know how to write this cursor statement.for example. SQL> select deptid, empid from dept; DEPTID EMPID - - 2 94204 2 94205 2 94206 2 94207 2 94208 5 94209 5 94210 5 94211 5 94212 5 94213 7 94214 7 94215 7 94216 7 94217 7 94218 15 rows selected. i want output as following by single query. DEPTID EMPID - - 7 94214 7 94215 7 94216 7 94217 7 94218 5 94209 5 94210 7 rows selected kindly reply.. thanks in advance. regards paresh mehta -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: ***Urgent Question***
My group leader tells that rownum may give wrong results . Do not use it... Really ??? - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 3:00 PM > try this: > select * from (select emid, deptid from dept order by deptid desc, empid asc) where rownum<8 > > Gyula > Local Folders wrote: > > > Consider the following case. > > TABLE : DEPT > > empid number, > > deptid number, > > deptnamevarchar2(30) > > primary key (empid, deptid) now i want to fetch first seven records from a cursor whose deptid is > > maximum > > and empid is minimum. kindly let me know how to write this cursor statement.for example. SQL> > > select deptid, empid from dept; DEPTID EMPID > > - - > > 2 94204 > > 2 94205 > > 2 94206 > > 2 94207 > > 2 94208 > > 5 94209 > > 5 94210 > > 5 94211 > > 5 94212 > > 5 94213 > > 7 94214 > > 7 94215 > > 7 94216 > > 7 94217 > > 7 94218 15 rows selected. i want output as following by single query. DEPTID EMPID > > - - > > 7 94214 > > 7 94215 > > 7 94216 > > 7 94217 > > 7 94218 > > 5 94209 > > 5 94210 7 rows selected kindly reply.. thanks in advance. regards > > paresh mehta > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andor Gyula > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: Locally managed tablespaces
But some had claimed that Locally managed tablespaces are slower. I do not know if it is correct but you must consider it . And I wonder the performance results too. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 3:35 PM > I have always been concerned with fragmentation of tablespaces, whether it > be lots of extents, honeycomb or > bubble fragmentation. Now I am reading that in Oracle 8i with the use of > locally-managed table spaces, > these concerns are a thing of the past as Oracle now uses bit maps within > the tablespaces themselves to > do space management. This seems foreign to me that even though Oracle will > use up all the space in > the tablespaces with no coalescing, it is OK that extents will go into the > thousands with no performance degradation. > Could folks who are currently using locally managed tablespaces please > comment on how well it > is working for them and if they have experienced any problems in using them. > Thanks > Skip > Here is a good white paper on the subject. > http://www.embarcadero.com/news/white_papers.htm > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Malkuns, Skip > 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 an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line 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 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).