Re: RAID5 question, take 2

Indeed, Paul. Very good points. Gary - you're asking us to determine the number of bags we'll need at the supermarket without knowing what we're going to buy. If we had IO-stats for your datafiles/tablespaces, ie reads/writes and their size, and your availability requirements on the system, we

Cause for explain plan differences? - probably a basic question

Hi, I have two database instances 816SE and 817EE on WinNT. For the same query I get different result as follows (optimizer_mode=CHOOSE). What actually I don't understand is, that why are there resource costs in the EE 8.1.7. version and not in the SE 8.1.6 version. Both databases are created

find allocated and used space for a table

Hi, How to find allocated and used space for a table? I required it urgently Regds __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L

How do IMP EXP - SOS

Title: How do IMP EXP - SOS hi I need to do the IMP of a dmp file from Oracle 8i to 8.1.5 can you guys pls help me how to go about it with warm regards deewaker g v

Cause for explain plan differences? - probably a basic question

Hi, I have two database instances 816SE and 817EE on WinNT. For the same query I get different result as follows (optimizer_mode=CHOOSE). What actually I don't understand is, that why are there resource costs in the EE 8.1.7. version and not in the SE 8.1.6 version. Both databases are created

RE: A bit of SQL tuning

Thanks Mark. I never had the curiosity to look at the Intermedia cartridge, but yes, it answers the problem. Christian (Bilou) -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de Mark Leith Envoyé : jeudi 7 juin 2001 11:24 À : Multiple recipients of list

sys.v_$parameter

Why would someone write a SQL*Plus script against sys.v_$parameter when you want to find the value of an init parm, when instead you could code against v$parameter? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City

RE: find allocated and used space for a table

manoj, i have a procedure which lists the space allocated and space occuopied (and space wasted) for tables/indexes... making use of the dbms_space package...(mail me privately) Also, a while back someone else (Jared ?) posted a similar procedure.. you might find it on his website Regards

Null values

Hallo you DBA's: How can I modify in this script to make it handle also null values. This script only handles 0-values. Hope anyone can help me with this. vOWNERSHIP_NO:= rpad(to_char(nvl(recCursor.OWNERSHIP_NO,' 0')),2,' '); Thanks in advance Roland Sköldblom -- Please see the official

Re: Cause for explain plan differences? - probably a basic question

On Jun 10, 2001 at 11:30:23PM, Szecsy Tamas wrote: Hi, I have two database instances 816SE and 817EE on WinNT. For the same query I get different result as follows (optimizer_mode=CHOOSE). Did you analyze the tables? -- Vladimir Begun | Stability is often more correct than

Re: find allocated and used space for a table

Hi Soman Use one of thies selects SELECT SEGMENT_NAME, TABLESPACE_NAME, FILE_ID, BYTES FROM DBA_EXTENTS WHERE OWNER = 'OWNER' AND SEGMENT_NAME = 'SEGMENT_NAME'; SELECT SEGMENT_NAME, SUM(BYTES) FROM DBA_EXTENTS WHERE OWNER = 'OWNER'

Re: find allocated and used space for a table

On Jun 10, 2001 at 11:55:45PM, Soman Manoj wrote: Hi, How to find allocated and used space for a table? SELECT SUM(blocks) blocks , SUM(bytes) bytes FROM dba_extents WHERE segment_name = 'table_name' / ... SELECT SUM(VSIZE(colA)) + SUM(VSIZE(colB)) + ... +

Re: sys.v_$parameter

On Jun 11, 2001 at 12:25:22AM, Greg Moore wrote: Why would someone write a SQL*Plus script against sys.v_$parameter when you want to find the value of an init parm, when instead you could code against v$parameter? In fact you'll get the same result. v$parameter is a synonym for v_$parameter:

Re: Index organised tables any limitations?

On Jun 10, 2001 at 08:56:12PM, Amar Kumar Padhi wrote: Hi, I need some info regarding if there are any limitations in using index organised tables compared to normal tables. Moreover, what is the deciding factor to be considered to give preference to an index organised table over a normal

RE: find allocated and used space for a table

If you can afford to analyze the Table(for latest statistics) then 1. Analyze Table tablename compute statistics. 2. select blocks Used Blocks , blocks + empty_blocks Allocated Blocks from dba_tables where table_name = 'tablename'; hth, Rajesh -Original Message- Sent: Monday,

RE: primary/ foreign key constraints for oltp, overhead?...soluti

Jared, I tried again and got the same result. on oracle 8.1.7 (RBO). session1 : delete from emp where deptno = 10; session2 : delete from dept where deptno = 30; session 2 hanged and waited till transaction in session one was committed. the max_trans on both tab is set to 255, incase this

Re: sys.v_$parameter

If you're obsessive about performance - its avoiding the synonym lookup I suppose.. Cheers Connor --- Greg Moore [EMAIL PROTECTED] wrote: Why would someone write a SQL*Plus script against sys.v_$parameter when you want to find the value of an init parm, when instead you could code against

RE: find allocated and used space for a table

if on 8i, use dbms_space utility rgds amar -Original Message- Sent: Monday, June 11, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi, How to find allocated and used space for a table? I required it urgently Regds __ Do

Re: Crash Recovery

Hi, In fact, in your case, adding larger TEMP is not the solution. Solution is the adding TEMP with larger extent size. Because, Oracle cleans up segments extent-by-extent. If you have more extents, cleaning-up them will make more dictionary look-up and this will eat CPU. regards... Charlie

RE: find allocated and used space for a table

Hi, The results from previous mail's query would differ( by 1) from following SELECT SUM(blocks) Allocated Blocks FROM dba_extents WHERE segment_name = 'table_name' / The reason for this is that one block is reserved for the segment header. DBA_SEGMENTS.BLOCKS holds the total number

Re: Cause for explain plan differences? - probably a basic question

Exactly. If you don't have stats on the tables, CHOOSE means RULE, ie no COST. If, on the other hand, you have stats on at least one of the involved tables, CHOOSE means cost-based, and more specifically it means ALL_ROWS, which is usually not what you want. Vladimir Begun wrote: On Jun 10,

Re: ksrchdelete7

On Jun 08, 2001 at 05:30:29AM, novicedba wrote: Hi, Database 8.1.5 OS - NT On my test database I deleted certain tablespaces and then shutdown the databases, deleted the datafiles (still in recycle bin) and restarted the database . The database started fine no errors. When I check the

Sun cluster with Ultra 10

Hi all, Is anyone using 2 Ultra 10 and Sun Cluster 2.2 as test environment ? Is this achievable ? Thank you.. Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

procedure error

Dear Gurus. Icreated a procedure and this procedure takes parameters and then makes and alter table DDL on the database. Butwhen I write exec pp(table_name1,field,table_name2); Gives error. ERROR at line 1:ORA-06550: line 1, column 10:PLS-00357: Table,View Or Sequence reference

Re: primary/ foreign key constraints for oltp, overhead?...soluti

Jared has a point. Is there an index on the foreign key? Another minor detail: You should of course never update a primary key column, of course :-) Amar Kumar Padhi wrote: Jared, I tried again and got the same result. on oracle 8.1.7 (RBO). session1 : delete from emp where deptno = 10;

Re: sys.v_$parameter

What's more interesting is of course a query against v$fixed_view_definition to show how v$parameter (or v_$parameter) is defined. This will point you to x$ksppi and other x$-tables where you can also see the un-documented parameters (those starting with an _). Greg Moore wrote: Why would

Re: Re: sys.v_$parameter

There is only one case when you should use V_$something instead of V$SOMETHING, which is when connected as SYS (or INTERNAL) to grant SELECT to a user who needs to create a stored procedure or view involving the said V$something. As Vladimir said, V$xxx is a synonym for V_$xxx, which is a

RE: Cause for explain plan differences? - probably a basic questi

Explicitly no. Perhaps Oracle did on his own, while I imported the dump files. -Original Message- Sent: Monday, June 11, 2001 10:31 AM To: Multiple recipients of list ORACLE-L On Jun 10, 2001 at 11:30:23PM, Szecsy Tamas wrote: Hi, I have two database instances 816SE and 817EE on

RE: procedure error

hi bunyamin you have forgot to open the cusror before the start of the programme. excute the dbms_sql.open_cursor function to get the curosr id. cursor_name:=dbms_sql.open_cursor; Venkata Ramana Sierra Optima Limited, SVR Towers, 8-2-1/B/1, Panjagutta, Hyderabad 500082, India. Ph: (91-40) -

Re: SID on sqlplus prompt?

Hi You have already seen many post with the answer to this, but if you use connect glogin.sql will not be run again. I created a very basic script with a very short name and put it in the directory where my SQL_PATH registry key points to. This script does the connect (after prompting for the

Re: whats new in oracle8.1.7

Check out this link ..it is of 8.1.5 www.akadia.com/services/ora815nf.html Azhar - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 3:35 PM http://technet.oracle.com -Original Message- Sent: Friday, June 08, 2001

OT -- SAP and IBM

FYI, I saw a link to this Yahoo news item on a Canadian news website (www.bourque.com): http://www.bourque.com): Monday, June 11 5:42 PM SGT SAP, IBM to unveil e-commerce alliance in next few days: report FRANKFURT, June 11 (AFP) - German software giant SAP and US computer giant IBM are

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

On Sun, 10 Jun 2001, George Schlossnagle wrote: Hmmm so it's a pci only interface, so I can't use it with my Enterprise Sun systems, and drivers for Tru64 don't yet exist, so unless you're running Windoze, AIX or Linux, you're out of luck. That's a real bummer. But there WOULD be the

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

Jared wrote: I just *had* to point this out. Had too many damagers want to solve everything by buying HW when they have no idea what the problem is. how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM made the application fly. Until we hit THE ultimate peak stress day and they died. I

Re: help for rollback segments..

to create them as private, the syntax is: create rollback segment ... you don't need the work private in there. for the ones that are offline try: alter rollback segment segment name online; and see if the status changes. From: Saurabh Sharma [EMAIL PROTECTED] Reply-To: [EMAIL

RE: regarding isqlPlus

We have installed iSQLPlus on our development box, and it seems to work fairly well. The nice thing about it is you don't have to install the client on the user's PC, it just uses a browser. It does have a bug or two - for example, if the user does not click on the "Logoff" button and just

RE: How do IMP EXP - SOS

Title: How do IMP & EXP - SOS Deewaker, You did not mention what is the version of Oracle 8i. I am assuming it is higher than Oracle 815. In this case do the following steps. 1. Take export of the schema using exp from Oracle 815. To do this , you can connect to your source database

RE: Oracle 9i V$VERSION and changes to the system views for 9i

I got some Ultra 1's that run Oracle 9i that I haven't posted on ebay yet. We haven't got them all configured yet. 128-256Mb (possibly more), 167MHz cpu, 9-72Gb drive, 20 monitor, keyboard, mouse. Solaris 8, Oracle 9i Walking on water and developing software from a specification are easy if

Re: regarding isqlPlus

Hi, yes I have tried working with isqlplus. It gets installed fine and works fine too. There is a proper installation doc following which it could be installed. It is buggy as you can expect it to be. everyone who used it at our place liked it (though I had the headache of killing the

Re: OT -- SAP and IBM

I believe that they have already made the tie up here in Australia, I am surprised that we might have been first or nearly first with something like this. Oh well Peter At 03:51 AM 11/06/2001 -0800, you wrote: FYI, I saw a link to this Yahoo news item on a Canadian news website

RE: How do IMP EXP - SOS

Title: How do IMP & EXP - SOS technet.oracle.com should give you everything you need under documentation. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Deewaker G.V.

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

oops Sun E6500 From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O Date: Mon, 11 Jun 2001 04:50:19 -0800 Jared wrote: I just *had* to point this out. Had

RE: Re: OT - Wrap-up of 'Serious Question ' - now book idea - hig

Title: RE: Re: OT - Wrap-up of 'Serious Question ' - now book idea - high I haven't written it yet :), but Don G. and I have talked about writing it together a couple of times. The only thing stopping me from the attempt is the how much time it'll take me away from my kids. R. Matt

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

What's wrong with that picture? You are telling them what they do not wish/want to listen ;) And I am making the same 'mistake' - Kirti -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 7:50 AM To: Multiple

RE: Oracle's Market share

The Gartner group just released a RDBMS market share analysis. Their report showed Oracle's market share was still growing. -Original Message- From: Murali Vallath [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 10, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Subject:

RE: ORA-01555 error

If its a PL/SQL procedure you could actually commit after 'N' records have been processed, that may help, as you will be processing in smaller chunks as opposed to a big bang approach.. Lee -Original Message- Sent: 11 June 2001 14:30 To: Multiple recipients of list ORACLE-L I got

RE: RAID5 question, take 2

Mogens, the super-market analogy does not apply - this is for SQL Server database. I'm not sure how far I'll be able to tweak that rdbms, hence my question did not contain many details - it was simply a request for opinions. Btw, to sum up current responses: Option 1: split 9 drives to separate

RE: sys.v_$parameter

To bypass the view? Is it in a huge script? Could be to glean every bit of performance from the script.. Mark -Original Message- Sent: Monday, June 11, 2001 09:25 To: Multiple recipients of list ORACLE-L Why would someone write a SQL*Plus script against sys.v_$parameter when you want

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

yep -- and as soon as I realized what I'd written I corrected it. I've been running sleep-deprived for several weeks (months?) now. I'm surprised that's all I wrote incorrectly! From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: RAID5 question, take 2

This actually depends on the drives, if they are cheetahs, yeah you will be pinched. But if it is anything but perhaps not. I would hope they would be, but very possible they are not. Walking on water and developing software from a specification are easy if both are frozen. Christopher R.

RE: Re: OT - Wrap-up of 'Serious Question ' - now book idea - hig

Yeah , I think that family is the most sacrificed part. If I would write a book , I would have to do it in my free times ( evenings , nights , weekends ) , and usually this is the time that I have to spend with my wife and kid. Regards, Antonio Belloni Adams, Matthew (GEA, 088130) [EMAIL

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

On Mon, 11 Jun 2001, Rachel Carmichael wrote: how about Sun E650, 26 CPUs (yes, I said 26), 9GB RAM I assume you mean a Sun E6500 (since E650's don't exist). :) -- Larry Herzog Jr.Do nothing out of selfish ambition or vain ZRXOA #1029 conceit, but in humility consider

Re: arguments in ora-600

Raghu ! Normally ORA-600s are bugs or because of some unhandled expectations. The arguements are split up between various kernel layers. This note will help you in understanding the layers and your 17302 falls under KGL (library cache component). So this is probably a bug or something related

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

But there WOULD be the possibility of using them with Sun E250s and E450s. Sure. Except that the drivers aren't available. Besides, these are really tiny, unscaleable boxes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL

Re: ORA-01555 error

Hello, There are about 4 cases for ora-1555. Add following event to init.ora: event = "1555 trace name errorstack, level 3" After that, whenever Oracle encounteres ora-1555, a trace file will be generated. Send trace file, let's look at what is happenning. regards... "Farnsworth, Dave"

Re: regarding isqlPlus

Got it working at home on Windows 2000 with 8.1.7.0.0. Works just fine, but .sql files are not able to read SQL*Plus commands (i.e. column xxx format a10). As I recall the install was fairly simple. Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net Saurabh Sharma

MTS and Java applications

Anyone using MTS with java applications with weblogic servers and JDBC drivers. We are not using this at the moment, but I am unable to track any information about this configuration and the architecture of MTS with JDBC, NET8 etc. Regards, Murali Vallath

RE: Serious Question (believe it or not)...

Post the pic! :-P Scott Shafer San Antonio, TX 210-581-6217 And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grâce via your Ninja Death Touch, you

rollback use query

Hi Gurus I have one question. Create table tbl2 as select * from tbl1; will above query use the rollback segment or not? and why? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

management was heavily invested in making the system go live as is... since they were heavily involved with the design. They designed it without a DBA. OLTP system, main order table had 23 indexes on it. Because they wanted to be able to search by customer first name, customer last name,

RE: Dedicated connections on MTS server

First, if in tnsnames.ora file on the client alias group contains srvr=dedicated or in sqlnet.ora there is a parameter server=dedicated (or something like this) - you will have dedicated connection. Second if your maximum number of shared servers in init.ora less then number of users trying to

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

Larry Herzog Jr. wrote: But there WOULD be the possibility of using them with Sun E250s and E450s. On Mon, 11 Jun 2001, George Schlossnagle wrote: Sure. Except that the drivers aren't available. Besides, these are really tiny, unscaleable boxes. I didn't say it was a GOOD solution. I

RE: dumn unix script question

Jared, Thanks for the summary. Any comments on where Tcl fits in to the mix? Henry -Original Message- Sent: Friday, June 08, 2001 5:11 PM To: Multiple recipients of list ORACLE-L Let me start off by saying that I like Java. I took a class in it from Sun, and Java is easy. Learning

Question about many Oracle Data Files

All, Awhile back, on the other list, there was a discussion regarding the number of data files that an Oracle database might contain. Someone posted a warning that too many data files might actually hurt performance in that it might inflate the amount of work to be done at SCN update time.

RE: Recording Destructive DDL

You are getting current SQL but you need to go thru all SQL for this session to find out if there was alter table drop (column). Alex Hillman Original Message- Sent: Wednesday, June 06, 2001 9:36 PM To: Multiple recipients of list ORACLE-L Obtaining the triggering statement is beyond my

Re: Question about many Oracle Data Files

Hi ! Someone posted a warning that too many data files might actually hurt performance in that it might inflate the amount of work to be done at SCN update time. How would I test this? What wait value might be too high to indicate that this is taking too long? How many is too many?

Re: determining when a refresh has completed

Dave, Unfortunately that info is not currently stored anywhere. You can find out when the refresh began, by checking dba_snapshot_refresh_times (there's a bug where the time in dba_snapshots is listed as some time in 1950). You'll be happy to know that 9i will include some new views that will

Re: determining when a refresh has completed

Wow, I thought I just wasn't looking hard enough. It's seems obvious that we'd want to see when the refreshes finished. I'll take your advice and wrap the call. Thanks, Dave On Mon, Jun 11, 2001 at 10:30:25AM -0700, A. Bardeen wrote: Dave, Unfortunately that info is not currently stored

News: Technology and the corruption of copyright

Hi All, In light of the recent discussion here is an alternate view. http://www.zdnet.com/zdnn/stories/comment/0,5859,2770541,00.html Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services--

Re: arguments in ora-600

Gopalakrishna Thankyou for info. Yeah you are right I find there was open cursors involved in dead lock..Thank for info again. From: K Gopalakrishnan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: arguments in ora-600

What is the logging column of the DBA_TABLES view used for?

There is not a lot of documentation in the Oracle 8.1.5 Server Reference Manual on this column. I know that this logging column in DBA_TABLES view can be set to YES, NO, and NULL. What kind of logging are we talking about? Redo logs? We're running 8.1.5 on Sun Solaris 2.6. This is a

Re: dumn unix script question

On Monday 11 June 2001 10:21, Henry Poras wrote: Jared, Thanks for the summary. Any comments on where Tcl fits in to the mix? I've not used TCL, so I can't really say too much about it. It is generally considered simpler than Perl, and likewise less robust. TK is another matter. If you

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

I disagree wholeheartedly with this statement Alex. How can you make this statement without knowing the situation? (You seem to be becoming the resident troller in this group! Sorry, but it does appear that way.) In spite of all evidence and repeated warnings, management often does not allow

Re: config problem on 8.1.7

Youshouldenable client and server level tracing get more details pertaining to this type of error. Given more detail, we may be able to get to the bootom of the problem. Defry - Original Message - From: Helen rwulfjeq To: Multiple recipients of list ORACLE-L

RE: Sqlloader on VSAM file

Title: RE: Sqlloader on VSAM file Raymond, Please forgive me, but I am not sure now if you are asking a question or stating that you're ok. Your control file looks ok except I 'define' my fields differently. I am sending you an example below. I am assuming your amount fields has 2 decimal

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

On Monday 11 June 2001 09:06, Rachel Carmichael wrote: OLTP system, main order table had 23 indexes on it. Because they wanted to ?!?!?! That's just nuts. be able to search by customer first name, customer last name, recipient first name, recipient last name and had foreign keys all

RE: SID on sqlplus prompt?

Title: RE: SID on sqlplus prompt? I use this as well but it only works going through Sqlplus. If you want to change connections while you are in sqlplus by entering sql Connect username@dbname, then the sid/username will not change on the sql prompt. To make the connection change show, add a

Re: isqlPlus

All you need is Oracle 8.1.7 with the http server (apache) up and running. The server comes as part of the install at least for Enterprise Edition (never checked out Standard Edition). After you install you will see an apache directory under the $ORACLE_HOME directory Jon Baker

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

I hoped that everybody understand that this was a joke. I use damagement and :-) in the end. I hoped that it was grotesc. Apparently I was wrong. My apologies for all offended. For people who do not understand humor I repeate again that it was a joke. Alex Hillman -Original Message-

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

Alex, I think you are trying to not be incredibly rude? How rude of you! grin, duck, and run like hell || -Original Message- || From: Hillman, Alex [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 3:39 PM || To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' || Cc: '[EMAIL

Re: What is the logging column of the DBA_TABLES view used for?

Gopal, How about this: 1* select owner,table_name, logging from dba_tables where logging != 'YES' SQL / OWNER TABLE_NAME LOG -- -- --- SYSATEMPTAB$

Oracle reports

I am creating a report based on a couple tables. The report should show the total amount sold for the current month and another field for total amount sold Year To Date. How can I created the report so that the month to date value for a particular item is adjacent to the total amount for Year to

Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

It seems sarcasm may be beyond you. Check the smileys for emphasis in Alex's mail. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 4:00 PM I disagree wholeheartedly with this statement Alex. How can you make this statement

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

LOL! You got one, Alex. || -Original Message- || From: Don Granaman [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 4:01 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Veritas Quick I/0 and Oracle/ Asycnchronous I/O || || || I disagree wholeheartedly with

RE: Friday thought

He, he, he... forget the good beer - last week at a client get together that happened to occur at a karaoke bar... Well, lets just say that a microphone, feather boa, shots of whiskey, and cheap beer are a dangerous combination in a dba's hands... Scott Shafer San Antonio, TX 210-581-6217 And

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

Let's see. What was that rule of thumb I heard from Kevin Loney? I think it was that each index slows down DML by a factor of 3 (at least for batch jobs where you have to worry about recursive SQL). So 23 indexes would run about 70 times slower than no indexes. Do I sense a hardware throwing

what's wrong with this...DBMS_SQL

Hi List, As the part of developing hot backup strategy, I am testing the following piece of code to take care of arch files to be made avaialable along with backup set. = SQL create or replace procedure log_switch as 2 cursor1 integer; 3 begin 4 cur1 :=

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

I suspect, as with most 'rules of thumb', that Kevin's does not scale well. || -Original Message- || From: Henry Poras [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 4:42 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Veritas Quick I/0 and Oracle/

Re: What is the logging column of the DBA_TABLES view used for?

Hi Mohammad ! They all are **temporary** tables and (have you checked the definition) in the NULL tablespace. So it is perfectly normal :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Gopal, How about this: 1* select owner,table_name, logging from dba_tables where logging != 'YES' SQL /

RE: what's wrong with this...DBMS_SQL

Title: RE: what's wrong with this...DBMS_SQL Surendra, you need to execute it. Look at the spec of dbms_sql (I want to say it's dbms_sql.execute()). Either that or use EXECUTE IMMEDIATE. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message

RE: rollback use query

I'd hate to argue with Anita, but I'm pretty sure that rollback won't be used on CTAS, since it's ddl. Somebody verify or correct please? Thanx, Yosi -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 1:21 PM To: Multiple recipients of

RE: what's wrong with this...DBMS_SQL

The DBMS_SQL is executed inside a package, so the owner of the package must be granted the ability to switch log files directly. More than likely, he only has this privilege through a role. Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972)

Current Osuser

Title: Current Osuser Hi, We can know the current oracle user (the username you are using to connect to database) by 'select user from dual'; How to know what is the current osuser (not the list of osuser) ? Tia. Rivaldi

RE: Friday thought

Were you wearing a speedo with that feather boa? || -Original Message- || From: [EMAIL PROTECTED] || [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 11, 2001 4:36 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Friday thought || || || He, he, he... forget the good beer

RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O

as I said, 26 CPUs, 9GB RAM, lots of disks.. oh, and they wanted a bitmapped index on that table too somedays it don't pay to get out of bed From: Henry Poras [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Veritas

Re: Current Osuser

SELECT USERNAME,OSUSER FROM V$SESSION = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail -

RE: Removing Older version of Oracle on NT Machine

My solution is to uninstall everything you can with O-installer, then delete oracle home and the oracle subdirectory under HKEY_LOCK_MACHINE/SOFTWARE in the registry. Perhaps there are some other things you should do but this has always worked for me in the past. Make sure you get rid of all

RE: Removing Older version of Oracle on NT Machine

This article provides clean remove. http://allaire.com/Handlers/index.cfm?ID=18374Method=Full -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I

RE: rollback use query

Hi Yosi, It's a good idea to not argue with Anita! :) Just do a simple test to confirm. Monitor 'writes' in v$rollstat before and after running the CTAS. Good, if you have a test db and no one but you are the sole user. You will never ever forget what you find. Just do it! :) Regards, -

RE: rollback use query

Hi Yosi, I'd hate to argue with Anita, but I'm pretty sure that rollback won't be used on CTAS, since it's ddl. CTAS or any DDL for that matter *will* need to write to SYS tables - (UET$, FET$ in this simple case as it needs to preserve information about extents allocated, etc.) and this

  1   2   >