RE: sqlplus question

Title: RE: sqlplus question SQLPlus outputs data in columns based on their Maximum length or the COLUMN format set in SQLPlus. Value of SQLPlus COLUMN attribute takes precedence.   Even when you do a substr() based on length, SQLPlus doesn't calculate the length of the maximum length value a

Re: count(*)

If you can live with 10 minutes, why not 60 minutes or 120 minutes ? Examine why this app feels so insecure that it needs to know the number of rows every 10 minutes. On Thursday 19 September 2002 20:28, you wrote: > Hi Gurus, > > In one of our insert intensive application we are inserting arou

RE: Consulting Position Available-Oracle DBA/Developer/NYC

Or SQL server -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

RE: Consulting Position Available-Oracle DBA/Developer/NYC

TD, Transactional..for Sybase Bill Christison --- Thomas Day <[EMAIL PROTECTED]> wrote: > > Datawarehouse meta data. > > But what the heck is T SQL? > > > > > >

Re: count(*)

If the table has a primary key, you can also combine the parallel hint with index_ffs on that primary key which is by far the fastest way of doing count(*). On 2002.09.19 16:18 "Suri, Deepak" wrote: > I have in the past used parallel hints to speed up a count(*) kind of full > table scan query.

RE: copying all schemas except sys

True, and if the original poster will check i believe he'll find those objects are not owned by sys but by system. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 12:43 PM To: Multiple recipients of list ORACLE-L

RE: count(*)

Title: RE: count(*) Hi, I am not sure if I have a solution for you, but I have a number of questions: 1) just for my interest, what type of application would need to insert 3-4 million records per hour? 2) Why does the application need to do the select count(*)?  What verification is

RE: count(*)

Paula et al: It could work if the analyze is done after the load using DBMS_STATS. Then the num_rows would be accurate. With the monitoring turned on , analyzing would be done on the table if more than a certain percentage had changed. It is not an elegant solution. A more pratical one , if y

RE: Consulting Position Available-Oracle DBA/Developer/NYC

Datawarehouse meta data. But what the heck is T SQL? "Miller, Jay"

Re: count(*)

If you can modify the application code, how about incrementing a sequence for each row inserted? Not to hamper performance with a "Select MySequence.NextVal From Dual" you could select from - I vaguely remember this from a thread a few weeks ago - x$dual (or something like that - I can't remembe

RE: sqlplus question

Title: RE: sqlplus question Use rtrim and ltrim are you sure data was loaded with spaces?  -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus question Tried this

RE: count(*)

Title: RE: count(*) That won't work if he is constantly loading data as analyze is going to take longer then just the count(*).  What about writing in the load process or a trigger itself a variable with a running total could use dbms_output to write it out to a file.  Starting with existing r

Re: Query performance improvement ?

David Jones wrote: > > Dear Lister: > > Is there any way to further improve the following query performance ? > > Thanks > > David Jones > ITResource > > SQL> select distinct A.* > >from POData A , InvData B where A.OWNERID=B.OWNERID AND A.ID = > >B.PURCHASEORDERID > >and B.Status = 12 an

RE: count(*)

That's certainly a possibility, but it still won't scale. Regardless of whether PQ is used, Oracle will need to do x consistent gets. As the tables grow larger, x will increase. Regardless of whether PQ is used, that number of buffer gets that are required will not change, and the total load on

listener problem ???

Hi all, I have a database LMANAGER (817 on win2000), it's on my local machine. I can log into it using svrmgrl. But when I connect using sqlplus, I got "ORA-12541: TNS:no listener". LMANAGER is already in listener.ora file, and lsnrctl status shows LMANAGER is there: (c) Copyright 1998 Oracle Co

Re: count(*)

Try this: select table_name, num_rows from dba_tables where table_name = [table_name]; [table_name] = the name of the table or a variable. This works if you are updating your statistics and you may also want monitoring turned on for the table. It is easier to get the information from the data d

Re: log_file_sync io wait question

What about Steve Adam's comments at: http://www.ixora.com.au/tips/tuning/log_buffer_size.htm What results have been achived by tweeking _log_io_size settings? I was about to poke around with this. "Of course, it is not necessary to carefully balance log buffer space waits against

Re: Best method to move Filesystems to RAW Devices.

Hi Nat, As long as you are not changing hardware platforms, you can use dd. (Of course, I assume you're on some flavor of unix, since you didn't mention OS.) You can just do 'dd if=/path/to/filsystem/datafile of=/path/to/raw/volume'. Of course, your database must be down. -Mark On Thu, 2002-

RE: Staspack Grapher/Viewer ?

Sent: Thursday, September 19, 2002 2:55 PM To: '[EMAIL PROTECTED]' Rich - I think the original poster mentioned Don Burleson's book. Don suggests you take multiple STATSPACK snapshots over time, say every hour for a week, then query the STATSPACK tables directly to, say graph database transacti

RE: Best method to move Filesystems to RAW Devices.

Nat - I'm assuming you can connect raw devices to your existing system. Myself, I would create new tablespaces and datafiles on the raw devices. Preferably you will use LMT with uniform extents. Then I would use CREATE TABLE AS SELECT NOLOGGING to move the data. Personally I prefer to first rename

Re: count(*)

Hi Rishi, Oracle does not keep track of the total number of rows anywhere. When you need to do this, you need to issue a 'select count(*)...'. Note that unless ou are on a very old version of Oracle count(*), count(1), and count(pk_column) will do the same thing. This is a design issue. You

Re:OT: oracle and appliance storage

Rick, Having been down a similar road very recently, actually still going down the road. Oracle will not support NFS mounted drives if 1) they are on a unauthorized/certified filer (read that as NetAppliance or EMC), and 2) the nfs mount is not across a private network. Basically this means

URGENT! URGENT!

Hi, Does anyone has information for "ORA-327000 error occurred in DIAG Group Service". I am using Oracle9i RAC on AIX servers. When I try to bring up the database I get that error. Thank you in advance. Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://w

RE: count(*)

Sent: Thursday, September 19, 2002 2:48 PM To: '[EMAIL PROTECTED]' Rishi - I've encountered this as well. I think the problem is the fact that you are pounding millions of rows into the table. When you ask for a count, Oracle won't give you an approximate answer, but insists on giving you a pre

RE: Why does my insert creates so many logs?

Title: RE: Why does my insert creates so many logs? is the tablespace in hotbackup mode? -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Why does my insert creates so many l

RE: Used/Free Temporary Space

Vivek - For the username you are executing this query under, what is the designated temporary tablespace? How many rows (approximately) are you expecting this query to retrieve? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: T

RE: count(*)

I have in the past used parallel hints to speed up a count(*) kind of full table scan query. thanx deepak -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Hi Gurus, In one of our insert intensive applicat

RE: Why does my insert creates so many logs?

This might sound like an exercise in pointlessness but here goes... Are you sure you are generating the redo? Use the following to get the sid of the sessions generating redo and then track back to the session/process/statement info. I realize that the query does not exactly query redo, but I ha

Re: sqlplus question

Tried this. The field length is still 56. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 6:43 PM > select substr(ename,1,length(ename)), job from emp; > > >From: "Bob Metelsky" <[EMAIL PROTECTED

RE: Rule Vs Cost

John, Thanks again for providing those links to Tim's paper and yours. They are really helping in understanding/talking about CBO in a better way. BTW, Today I have experienced the Over-kill of PQ you mentioned. One of our reports which used to run very fast kept hanging in there and I had to di

RE: copying all schemas except sys

Export program **never** exports the contents of SYS. WHy do you need a parameter IGNORE_SYS when it is ignored already? KG -Original Message- Sent: Thursday, September 19, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hi Starting with Oracle8i there is a problem with using

RE: Staspack Grapher/Viewer ?

This has me thinking. What exactly do you want to graph? I guess I'm just trying to see some value in graphing data from a single SP report. Graph waits as a pie chart? Or would it be for several reports combined? Also, after looking again at the layout of an SP report, a home-rolled query wo

RE: High values

John - Since nobody has replied to your question, I discussed it with a fellow COBOL programmer. I think that in COBOL you normally would use this in an iterative loop, as a comparison. In SQL itself, you rarely iterate, so you probably don't have that much need for a HIGH-VALUE. In PL/SQL you mig

count(*)

Hi Gurus, In one of our insert intensive application we are inserting around 3-4 million rows / hour. Also this app needs to do a count(*) of the tables every 10 minutes for verifying some application based logic. This is really killing us and it takes a lot of time. Can you please guide me to

RE: Why does my insert creates so many logs?

All the indices are dropped and the PK is disabled. I agree that there are some changes to be done in the data disctinary tables, but the amount of archived logs - about 90M per minute looked too high to me --- Viral Desai <[EMAIL PROTECTED]> wrote: > > A couple of things to try --- > > 1. Drop

re: copying all schemas except sys

Maybe I answered my own question. If I do the full export as another dba user (not sys,system) then hopefully I will not get the sys schema in the export. Ben -Original Message- Sent: September 19, 2002 2:14 PM To: Oracle List New Hi Starting with Oracle8i there is a problem with usin

Used/Free Temporary Space

On Issue of Following Query :- select ollh_acid,decode(oldalh.b2k_type,'ACFFD',oldalh.modify_bod_date , oldalh.another_date) from oldalh,solgam where oldalh.acid=solgam.acid and solgam.sol_id = CONSTANT NOTE - NO Index Exists acid has a Unique Value in Every Record of solgam Table sol_id is

copying all schemas except sys

Hi Starting with Oracle8i there is a problem with using full export and full import to re-create a database. The import coughs up a lot of errors due to the SYS schema (replication and help objects). How do people go about moving all the schemas from one instance to another without manually creat

Re: oracle and appliance storage

Use map network drive and then use the new drive letter for files. Of course, do not forget sharing on the receiving drive. Yechiel Adar Mehish - Original Message - > From: <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, September

RE: Why does my insert creates so many logs?

What version? What is the definition of table A? Have you enabled parallel DML? What about the append hint? According to the docs it is supposed to be automatic with the parallel hint but... Tim -Original Message- Sent: Wednesday, September 18, 2002 3:39 PM To: Multiple recipients of

Best method to move Filesystems to RAW Devices.

We are planning to move to raw devices for all our existing file systems. Our database size is around 400 Gig. What is the recommended method that you guys feel is best as far as time required to convert and ease of conversion. We feel we cannot use export - import as this may take more time for

PL/SQL help

I am building a dynamic sql statement which will contain varying number of bind variables depending on user selection criteria. As an example, the sql statement may be: c_sql := 'select col1 from atable where col2 = :1' ; or it may be c_sql := 'select col1 from atable where col2 = :1 and c

RE: Staspack Grapher/Viewer ?

I have a 1.5 MB zip file containing my old web site for called gnumetrics which uses a PL/SQL package and MRTG to chart performance data. If someone has a webserver I can load this to I will. It is old but it works. At the very least you will get some ideas on how to do this. I store all my da

Re: Privileges needed for truncate

To truncate you need delete privileges. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 10:23 AM Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out whic

Re: Lost ofall redo logs

Hi People I don't think that i need to update my CV, since I don't administer the database in subject and that am trying to solve the an unhappy customer's problem. I had already researched and tried almost everything that you suggested me and what really solved went use to suggestion of the not

Process question

Do I have something wrong with this query? I thought that each oracle process corresponded to one database connection (unless you are using MTS, which we aren't). This query surprised me. It shows that two different oracle database processes each correspond to 3 database connections. What a

RE: Consulting Position Available-Oracle DBA/Developer/NYC

But 4th normal form? Does anyone really use this? -Original Message- Sent: Tuesday, September 17, 2002 3:35 PM To: Multiple recipients of list ORACLE-L well the market must be picking up some, been definitely more reqs posted here a/o recent. joe Bill Christison wrote: >Interested

RE: Staspack Grapher/Viewer ?

And if you don't want to use MS Graph, you can use Perl's built-in graphing facility (see Programming Perl) or gnuplot. I had developed something similar at a previous gig but I used gnuplot. mkb --- "Gesler, Rich" <[EMAIL PROTECTED]> wrote: > Here is something I am playing around with. The >

RE: Staspack Grapher/Viewer ?

MRTG is good stuff but doesn't it use RRDTool. We have used RRDTool with great success. -Original Message- Sent: Thursday, September 19, 2002 8:58 AM To: Multiple recipients of list ORACLE-L We use MRTG to produce graphs for data from different sources network stats, hardware stat

High values

Is there a Oracle equivalent to the Cobol HIGH-VALUES value? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and w

RE: Staspack Grapher/Viewer ?

This product seems to use the now infamous CHR which has been banned from this list :) Has anyone figured out how to use MRTG (or Cricket) to get this done? [Why buy when you can use Open Source!] John > -Original Message- > From: George Leonard (ZA) [mailto:[EMAIL PROTECTED]] > Sent: T

OT: oracle and appliance storage

Hi All, Server A, Win 2000, Oracle 8.1.7 Server B, Win 2000 with Auspex storage appliance We want to test all datafiles to be on Server B. How does Oracle on server A know about datafiles on server B. It is my understanding that Oracle does not recognize map drives. There must be another way t

RE: sqlplus question

"set Trimspool on" will only trim the empty spaces at the end of each line. The only way i know to trim in between the lines is to concatenate all the columns SELECT column_1 || '|' || column_2. FROM . Naveen -Original Message- Sent: Thursday, September 19, 2002 9:49 PM To: Mul

RE: sqlplus question

Instead of using colsep, try this: select ename||'|'||job from emp; I was going to suggest -> col emp form a4 but if it can be more than 4 positions, it will wrap. Jay >>> [EMAIL PROTECTED] 09/19/02 11:53AM >>> I don't want just 4. It's variable length and I want the actual number of valid b

RE: Why does my insert creates so many logs?

A couple of things to try --- 1. Drop the indexes and primary key instead of disabling them. Insert the data and recreate pk. 2. This could be due to changes in data dictionary, when you insert large number of rows in the table, new extents may be allocated or high water mark of the table wo

Re: RMAN implementation strategy

Why can't you just restore the data and put it on a new tape? Why do you have to an export to do this? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 11:53 AM I want to add another point. After 7 years your tap

oraperf report - 2 queries

I have just tried using www.oraperf.com again after about a year since the last time. The output both in terms of formatting, readability and comment are much improved on what was already a valuable resource Well done Anjo 2 questions that the list (or even Anjo) may be able to answer for me Wit

RE: Privileges needed for truncate

create or replace PROCEDURE truncate_table(tbl_name in varchar2) AUTHID DEFINER is total INTEGER ; trouve EXCEPTION ; cursor_name INTEGER

RE: sqlplus question

select substr(ename,1,length(ename)), job from emp; >From: "Bob Metelsky" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: sqlplus question >Date: Thu, 19 Sep 2002 08:18:51 -0800 > > > > > > I am spooling my sqlplus o

RE: Query performance improvement ?

Dennis: Thanks for those helpful suggestions. I'll give it a try. David Jones ITResource -Original Message- WILLIAMS Sent: Thursday, September 19, 2002 8:04 AM To: Multiple recipients of list ORACLE-L David - I'm assuming this query is being run interactively? - I recently pos

RE: sqlplus question

> > I am spooling my sqlplus output to a file with no > headings and all the fields separated by a delimiter. I have > a field that is defined as varchar2(56), but typically only 4 > or 5 bytes are filled. Oracle recognizes that and if you > select length(fld1) from the table, you will g

PL/SQL DDL Permissions

I am trying to write a pl/sql package to allow end users to rebuild partitioned indexes. I have everything working when the package.procedure is run as sys, however when I run it as the object owner I get ORA-01031: insufficient privileges errors.  Other parts the the package (adding new

RE: sqlplus question

> > I am spooling my sqlplus output to a file with no > headings and all the fields separated by a delimiter. I have > a field that is defined as varchar2(56), but typically only 4 > or 5 bytes are filled. Oracle recognizes that and if you > select length(fld1) from the table, you will ge

RE: sqlplus question

Bill couldn't you just concatenate the fields together with your delimiter between. e.g. select fld1||'|'||fld2||'|'||fld3 I think the trimspool is just trailing blanks so unless you made that the last field output you'll get this behaviour. Iain Nicoll -Original Message- Sent: Thursd

RE: RMAN implementation strategy

Yechiel - Excellent point. Even better, burn the exports on a CD, making several copies. We have started doing that for special year-end reports that need to be retained for long periods of time. Much cheaper than tapes as well.   Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]

RE: Staspack Grapher/Viewer ?

Here is something I am playing around with. The idea came from Burleson's Statspack book. It requires Active Perl with DBD/DBI installed. Also MS Graph is used. This is still a work in progress. #!C:\Perl\bin\perl.exe -w # # rpt_avg_bbw_dy.pl # Report Average Buffer Busy Wait by Day # This

RE: sqlplus question

I don't want just 4. It's variable length and I want the actual number of valid bytes. Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 9:51 AM To: '[EMAIL PROTECTED]'; Carle, William T (Bill), ALCAS Subje

RE: sqlplus question

If you want only 4 bytes, us the SUBSTR function to take only what you need. SQL> select ename, job 2 from emp; SMITH CLERK ALLEN SALESMAN WARD SALESMAN JONES MANAGER SQL> set colsep '|' SQL> / SMITH |CLERK ALLEN |SALESMAN WARD |SALESMAN JONES |MANAGER S

RE: sqlplus question

The only method I know of is to concatenate the fields together in one column. If there is a way to have variable sized SQL*Plus column formatting, I'd love to see it...seriously...it would be cool. Until then... 1 select substr(ename,1,length(rtrim(ename))), job 2* from emp SQL> / SMITH

Re: RMAN implementation strategy

I want to add another point. After 7 years your tapes can be unreadable. If you use exports you can periodically restore them and backup them to a new tape. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, September 19,

Re: Privileges needed for truncate

Jack, It used to be DELETE ANY TABLE. I'm not sure if that has changed in recent versions. Long ago, I setup the following procedure to allow a specific table to be truncated, without out the DELETE ANY TABLE privilege. It must be owned by the owner of the table. I haven't dealt with thi

RE: Privileges needed for truncate

DROP ANY TABLE include the privilege TRUNCATE. But is not so secure. An ohher way is create a procedure to do the truncate base on user_table wich who is the owner of the tables. -Message d'origine- De: Jack van Zanen [mailto:[EMAIL PROTECTED]] Date: jeudi

RE: Privileges needed for truncate

Unfortunately drop any table. -Original Message- Sent: Thursday, September 19, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which privileges are needed (DBA is a bit O

sqlplus question

Howdy, I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are filled. Oracle recognizes that and if you select length(fld1) from the table, you will get 4. B

RE: RMAN implementation strategy

Sean Yes, remember that the real reason you keep the RMAN catalog on another system is not for disaster recovery, but for normal recoveries. The worst situation is where you keep the catalog in the instance you are backing up. The second worst situation is where the recovery catalog is in a sep

Re: RMAN implementation strategy

I use one recovery catalog for all of the databases I backup. I do a cold backup of the recovery catalog database once a week. It is in archivelog mode and I backup the archived logs with the database. I keep my recovery catalog database on a separate disk. I don't have a separate machine. I

RE: Apologies for Off-Topic Question - Where has Oracle-l-OT gone

Its still out there on Yahoo Groups. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 19, 2002 7:18 AMTo: Multiple recipients of list ORACLE-LSubject: Apologies for Off-Topic Question - Where has Oracle-l-OT gone ?Has the Off-T

from the business desk

"Meanwhile, Oracle's disclosure Tuesday that it expects its next quarter to be weak (with no sure signs of a recovery)..." "Oracle dropped 71 cents, or 7.9%, to $8.32." === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC

Re: Lost ofall redo logs

One correction...   The undocumented "_corrupted_rollback_segments" parameter does not take a TRUE/FALSE value setting.  It is another list of rollback segment names (similar to "rollback_segments" and "_offline_rollback_segments") which will be considered corrupted.  Roughly, the meaning of

RE: Staspack Grapher/Viewer ?

This one isn't free, it's charged on a per instance basis, looks quite nice though: http://www.geocities.com/alexdabr/ === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd |

Privileges needed for truncate

Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which privileges are needed (DBA is a bit OTT :-)) Try them one by one does not sound appealing at all TIA Jack === De i

RE: Lost ofall redo logs

This is very rare that one would loose every online log files for the instance. Hey, I don't think the advice here could be bad, it is the discretion of the user who is going to use it. KG and/or Arun, Anyways, I'm more interested in KG's comment about "you will have to do some more tricks to

Database Performance Tuning and Optimization: With Examples from Oracle 8I

Anyone know anything about this book that just showed up on Amazon's website?? Database Performance Tuning and Optimization: With Examples from Oracle 8I by Sitansu S. Mittra Publication date: October 2002 Publisher: Springer Verlag Pub (Computer Bks) Binding:Hardcover Subjects: Database man

RE: Staspack Grapher/Viewer ?

We use MRTG to produce graphs for data from different sources network stats, hardware stats, database stats. Maybe you could use it for statspack. -Original Message- Sent: Thursday, September 19, 2002 8:39 AM To: Multiple recipients of list ORACLE-L Does anyone have or know of a

RE: Oracle Installer not launching in NT -- solved

For your information, the workaround I used is to download oracle 9i client and install the 9i installer, then install oracle 8.1.7 software successfully. Thanks to all who response to my problems. Kitty -Original Message- [EMAIL PROTECTED] Sent: 17 September, 2002 11:03 AM To: Multiple

RE: Staspack Grapher/Viewer ?

http://www.statsviewer.narod.ru fantastic product. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.dida

RE: Query performance improvement ?

David - I'm assuming this query is being run interactively? - I recently posted a request for help on a query, and the winning solution was to add a FIRST_ROWS hint, so naturally at this point I'm convinced this will solve all performance issues. - Knowing how many rows are being returne

RE: BMC tables

> > they're from BMC's SQL Explorer product. > either you or ??? demo'd the product or own it. > Drop them if you want. If you were the one that tested SQL > Explorer, you can uninstall the tables using the product. > Thanks! drop table BMC_ISE_CASES cascade constraints ; drop table BMC_ISE_C

RE: Privileges needed for truncate

Title: RE: Privileges needed for truncate Alter any table Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any c

Re: Lost ofall redo logs

There is the other expensive avenue of calling in Oracle and the DUL team. It depends on the criticality of the data. A few years ago a former dba here had the experience and it is said to have cost a mere $20K. Maybe the data is worth more than that. On Wed, Sep 18, 2002 at 10:08:19PM -

RE: Why does my insert creates so many logs?

None. --- "Nicoll, Iain (Calanais)" <[EMAIL PROTECTED]> wrote: > Doesn't have any triggers does it? > > -Original Message- > Sent: Wednesday, September 18, 2002 8:39 PM > To: Multiple recipients of list ORACLE-L > > > Hi. > > A developer of mine is running a large insert as > select: >

RE: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NA

Title: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NADA on METASTINK I am actually using shutdown immediate - for testing I used shutdown abort just to speed up my testing on a database that could take it.  -Original Message-  

Re: Index question

> Testing against 8.1.7.4, the drop index was successful and an error was > reported by my long running query: > > ERROR: > ORA-08103: object no longer exists Is this because the index is locked by query only when it's used? From one side looks reasonable, but from another - no good someone can dr

Fw: Lost ofall redo logs

Oh yeah!  How could I forget:  make darn sure that you are working with Oracle Support actively, step-by-step, if you are in a scenario which might call for the use of these parameters.  It would be *disastrous* to start down this road if unnecessary, and there are other quirks when using th

Staspack Grapher/Viewer ?

Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City

Re: Lost ofall redo logsOTHER...

Joe T., When we'd recently posted positions to FATCITY you'd replyed;..the economy must be getting better (based on the job(s)posting. Yes,I agree.However,I'd never tried posting to Fcity.I've been placing SAS/Statisticians since 1993 and use SAS-L. *FYI., I didn't obtain any respon

RE: Lost ofall redo logs

I agree with you Joe. I would *never* use an undocumented parameter unless Oracle told me to (or unless I was testing something that I could recreate). Using these params on the advice of someone from this list is very dangerous. The larger question is, why are the redo logs not being backed up

RE: Tracking Temp Segment Usage and Event 10046

Title: Tracking Temp Segment Usage and Event 10046 Thanks Cary   One thing I noticed is some parameters referenced in that document are different in 9iR2 ... I guess Wolfgang is probably working on the 9iR2 version ...   It is a very nice paper ... Raj _

RE: Index question

Sorry for the mis-interpretation. I thought the question was if the same SQL statement is re-executed after dropping the index. regards naveen -Original Message- Sent: Thursday, September 19, 2002 5:28 PM To: Multiple recipients of list ORACLE-L The Query will be re-parsed. As soon as

Re: RMAN implementation strategy

Sean, I wasn't able to put our catalog database on another server, so after backups I export the catalog database and ftp the .dmp file to another machine. As far as the 7 year requirement, can you export the relevant data and save the .dmp file on tape for 7 years? Your biggest issue will

  1   2   >