Off topic: Linux - NT dual boot

Hello listers Would someone explain (or point me to the web page) how to make Linux - NT dual boot system. When having Windows 9x/ME it is not problem at all. But, when installed Linux after NT installation, I simply lost NT installation. LILO offered linux boot only. Thank you in advance --

Re: sql help --urgent

Hi, Select a, decode(sign(a), -1, 0, a-1) from Table Name For summing up : sum(decode(sign(a), -1, 0, a-1)) Hope this helps Bye Sundar Ravindra Basavaraja wrote: I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But

Argument too large at

Hello All I have installed OEM2.2 and OMS on W2000 machine with Oracle 8.1.7. The oracle Agent is running (in the local machine). For the remote nodes there's no Agents (Manual Discovery). The problem is when I try to execute the export utility from the console. If I select the local

oracle dba and tuning books

hi all can u plz give me good books for dba and tuning thanks in advance thanks and regards ! Shirish Khapre, SE Rolta India Ltd.Off Ph No. (+91) (022) 832,826,8300568Ext'n 2730visit me at:- www.geocities.com/shirishkhapreMinds are like parachutes. They only function when

Re: Extent allocation

Kirti and others: Actually, Oracle only uses a round-robin extent allocation method for direct loads and parallel CTAS operations. For dynamic extent allocation, Oracle doesn't fill up one file and then the next. Actually, Oracle doesn't distinguish between datafiles, but rather looks at the

Re: Extent allocation

What do you mean by the first one on the list? The list ordered how? The order in which dynamic extent allocation is reading fet$ appears to favor distributing extents equally among files. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 21 Jul 2001, Jon Walthour wrote: Kirti

sql help

hi dba's how to find out a users all objects+the tablespaces in which they reside. i tried using the flwng way: select tablespacename,table_name from dba_tables where obj in (select obj_nm from dba_objects where obj_type ='table' and owner='xyz') union select for indexes union select for

table scan vs idx scan

Hi dbas we have a situation here. can anybody tell me why this is happening : we have 2 tables with identical rows(almost) with same columns even indexed in same manner. tab1 51000 rows tab2 51500 rows tab1 indexed with idx1 on col1,col2,col3 tab2 indexed with idx2 on col1,col2,col3 TAB1:

parameters at session level

hi dba's can anybody clarify me the flwng: at database level the parameter optimizer_mode=choose. and i connected to scott and i set the optimizer_goal= rule. when i see from scott using sqlshow parameters optimizer the value is shown as RULE where as from connect internal SVRMGRSHOW

Re: Off topic: Linux - NT dual boot

I think this site should provide you with what you need: http://www.redhat.com/support/manuals/RHL-6.2-Manual/ref-guide/ch-dualboot.h tml Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 21, 2001 7:05 AM Hello listers

Re: Extent allocation

I mean just that--that Oracle will look in its free extent cache for the first free extent the tablespace that is the same size as that which it needs. There is no particular ordering first. And that would make it appear to be distributing extents equally among the files, but not always.

Re: oracle dba and tuning books

Personally, for tuning, I would suggest "Oracle Performance Tuning Tips and Techniques" by Richard Niemac, et. al. In the DBA arena, I've never really found a good book that I could wholeheartedly recommend (sorry, Rachael, I'venot gotten around to readingyour book yet). Jon Walthour

stopping applications connecting to a database

is there any way (apart from running a reoccuring scripts ) to stop users from accessing the database with software such as msaccess.exe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: oracle dba and tuning books

On Sat, 21 Jul 2001,Jon Walthour scribbled on the wall in glitter crayon: -Personally, for tuning, I would suggest Oracle Performance Tuning Tips -and Techniques by Richard Niemac, et. al. In the DBA arena, I've never -really found a good book that I could wholeheartedly recommend (sorry,

Re: sql help

Srinivas: Try this: break on TYPE SELECT 'TABLE' AS TYPE , table_name AS object_name FROM sys.dba_tables WHERE owner = 'SCOTT' UNION SELECT 'INDEX' , index_name FROM sys.dba_indexes WHERE owner = 'SCOTT' UNION SELECT 'CLUSTER' , cluster_name FROM

Re: table scan vs idx scan

Prasad: Have you run an explain plan on the the query on tab2 to see what Oracle is doing? Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 21, 2001 12:15 PM Hi dbas we have a situation here. can anybody tell me why

Re: stopping applications connecting to a database

Sam Roberts wrote: is there any way (apart from running a reoccuring scripts ) to stop users from accessing the database with software such as msaccess.exe -- This is an idea, totally untested, but I think that with Oracle 8i a trigger on login could check the program in V$SESSION (where

RE: Locally managed tablespaces

SMON will only automatically coalesce if pctincrease is 0 but you can always ask for a coalesce. Its part of the alter tablespace command and is the method I use. However, according to the doco there is no need to coalesce a LMT. -Original Message- Sent: Friday, July 20, 2001 7:01 AM

RE: Sql*Loader and assign a ROLLBACK segment

You can disable archiving, you can specify that the load is UNRECOVERABLE, or you can set the NOLOG attribute of the objects being loaded. --Kevin -Original Message- [EMAIL PROTECTED] Sent: Monday, June 18, 2001 5:50 PM To: Multiple recipients of list ORACLE-L Hello, I have a

Off Topic: For Sale Sparc 5 170MHz capable of running 9i

If anyone is interested in a cheap machine to start playing with 9i with. I just got a lot of 100 Sparc 5's. Standard configuration is: HyperSparc 170MHz 64Mb Ram Internal CDROM and Floppy Turbo GX Video (13W Connector) 2Gb SCSI Hard Drive I am putting them on ebay at $225 each. Which is

Re: Off Topic: For Sale Sparc 5 170MHz capable of running 9i

Can you run 9i on 64M of ram? On Saturday, July 21, 2001, at 09:35 PM, Christopher Spence wrote: If anyone is interested in a cheap machine to start playing with 9i with. I just got a lot of 100 Sparc 5's. Standard configuration is: HyperSparc 170MHz 64Mb Ram Internal CDROM and

Re: oracle dba and tuning books

Jon, don't be sorry -- just go read it. Tuning: Oracle 8i Performance Tuning 101 by Gaja Krishna Vaidyanatha and Kirti Deshpande. Both of this list. DBA: Oracle 8i DBA Handbook by Kevin Loney and Marlene Theriault. BUT ... what level are you looking for? Beginner? Advanced? Intermediate?

Re: table scan vs idx scan

hi walthour thnq for responding. i ran explain plan after every change. it is made sure, that oracle is doing full table scan. prasad --- Jon Walthour [EMAIL PROTECTED] wrote: Prasad: Have you run an explain plan on the the query on tab2 to see what Oracle is doing? Jon Walthour

RE: oracle dba and tuning books

For SQL and PL/SQL, I've been reading Guy Harrison's Oracle SQL High-Performance Tuning (second edition). Pretty good so far. I also got O'Reilly's Oracle Performance Tuning (also second edition) but haven't read enough of it yet to really rate it. I generally like the O'Reilly books though.

Enterprise dba

hi lists sorry for off topic. what is this Enterprise DBA. is this anything other than regular DBA activities. prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ --