Re: Global Stats

It's not correct, check metalink -- there is a note about that. -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. K Gopalakrishnan wrote: Kirti: I think the interval is changed to 5 minutes from 3 hours starting

RE: Global Stats

Hi Kirti: THe algorithm is slightly differnt in 9i. In 8i SMON queries the dictionary (dba_tab_modifications) in once in 3 hours to get the stale stats, and then the stats are flushed to the dictionary from the SGA and the dictionary is updated . The operation is reverse in 9i. THe stats are writt

RE: books recommendations

I forgot to ask you! Is it free download?? -Original Message- Sent: Thursday, January 30, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Hi harvinder Can you please point me to the High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability [DOWN

ORA-04098 Problem - Any Ideas??

Title: ORA-04098 Problem - Any Ideas?? Hello List, I get this error when trying to drop and index, this as the schema owner. ERROR at line 1: ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed re-validation The system is Oracle 817 on Win2000 Does anyone know how to fix t

Queries Help

Hi List, I need the queries for the following requirements. Can anybody help me please? 1. A table has two columns "Code" and "Type". Form a query to swap the values of these columns. 2. A table contains empid, salary, mgr_id. Form a query to select the employees who have the salary more t

RE: Advice needed on PL/SQL code

Thanks all, this is helpful information for my boss, who wants to schedule a procedure to bulk copy data between tables on a regular basis. For my own problem, I should have been more specific in my example, but I was thinking more about my boss' issue than my own. (What a great employee I am!)

RE: Global Stats

Gopal, I should have waited a bit longer.. It was about 12 minutes, when I replied... Okay, I will test it out tomorrow.. It's getting late :( Now, go eat your lunch.. it's about lunch time for you... :) Regards, - Kirti -Original Message- From: K Gopalakrishnan [mailto:[EMAIL P

RE: Global Stats

X$KG, Are you certain? What platform? Just did a small test on Win 2000. It's been over 10 minutes and no new info in user_tab_modifications. Secondly, Lisa is running 8i. So she is stuck with this ~3 hour delay :( Thirdly, if the interval is really going to be 5 minutes, why bother with a

forms6i question

Hi All , Can anyone tell me if there is any handle or cursor to a block record buffer ,which I can access in forms6i. my requirement is to restrict user from entering duplicate records in the block while inserting'em (but before saving them). As soon as user enters the row TAB's out I want to chec

RE: books recommendations

Hi harvinder Can you please point me to the High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability [DOWNLOAD: ADOBE READER] by Geoff Ingram thanks in advance Banarasi Babu -Original Message- Sent: Wednesday, January 29, 2003 3:49 AM To: Multiple re

RE: Global Stats

Kirti: Sorry for the typo. It is 15 minutes. --- K Gopalakrishnan <[EMAIL PROTECTED]> wrote: > Kirti: > > I think the interval is changed to 5 minutes from > 3 hours starting from 9i (rel2?). > > > > Best Regards, > K Gopalakrishnan > > > > > -Original Message- > Kirti > Sent: W

RE: Global Stats

Kirti: I think the interval is changed to 5 minutes from 3 hours starting from 9i (rel2?). Best Regards, K Gopalakrishnan -Original Message- Kirti Sent: Wednesday, January 29, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Lisa, Monitoring, by itself, does not fire any aut

RE: Global Stats

Lisa, Monitoring, by itself, does not fire any automatic analyze. It simply montiors the DML activity on the monitored table and counts inserts/deletes/upates. Those counts may not be 100% accurate, but are very close. These can be viewed in dba_tab_modifications, and are dumped there by SMON e

RE: internal datatype codes - sovled

Thanks a lot. I found it in the OCI programmer's guide too. That list seems to be more complete. Rich --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a97269/pc_15ody > .htm#11204 > > -Original Message- > Sent: Wednesday, Janu

RE: Re: Re: to much time to execute query

> >Thanx Jared. That query waz pretty fast (0.78 >secs). Next time i wuld avoid using nested queries >where joins can do the job. > >regards >Tc > Wrong conclusion. Jared gave you the best and simplest solution, but Sony implicitly pointed to your error. Missing join condition. Regards, Stepha

RE: Return the first row only

> Hi Ranganath, > > select 'shipment' table_name,ce.display_name,st.timestamp, sequence > from shipment_timestamp st, customer_event ce, xm_field xm > where shipment_id = 10402344721477 > and ce.CUSTOMER_MOT_ID = 1040130035205 > and xm.field_id = ce.field_id > and st.event_id = xm.event_id > an

RE: Problem on P4 intel servers

Thanks a lot Mark for your complete explanation. Rgrds, Sony > -Original Message- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 5:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Problem on P4 intel servers > > symcjit.dll is "Syma

RE: strange behaviour of sequence

Hi Oraora, I try the same thing like you did, SQL> create sequence testseq start with 1; Sequence created. SQL> create table testtab (text char(10)); Table created. SQL> begin 2for i in 1 .. 5 loop 3 insert into testtab values('BREAD'||testseq.nextval); 4end loop; 5co

Re: Re: Strange behaviour of sequence

thanks a lot everybody. i have changed the sequence to NOCACHE. Regards, Prem Khanna J. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

TNS name lookup failure with SAP

Help!   I ftp'ed the oracle client libraries from one system to another, with a totally different SID.  I renamed and edited all the profiles for the user ID's, but the client software cannot seem to communicate with the server.  The error messages appear to indicate a TNS name lookup failur

Strange Problem: ORA-00020 Max Processes

Title: "Take Care of your DBAs" I'm curious if anyone has run into this error before or can provide somethings I can look into to resolve. system: SAP HR Oracle 8.1.7.4.1 M$ 4.0 svc pack 6a   On Sunday, I applied some NT patches to the OS and rebooted the server. The last one was security ro

RE: Examples of dbms_job.submit intervals and arguments

Bob, Try Tom Kyte's web site: http://asktop.oracle.com. Search for dbms_job. There are some good examples. - Kirti -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wed 1/29/2003 4:44 PM To: Multiple recipients of list ORACLE-L Cc: Subject:

Re: SQL question

[EMAIL PROTECTED] wrote: I can do a COUNT(DISTINCT ename || job), but that doesn't seem to be elegant way of doing it. elegant = simple, concise, easy to understand. Looks elegant to me. Jared, it just looks that that... CONCAT = || yet another function call, yet another piece of code, y

Top Team / Ascential Software

We are looking at these 2 vendors to help us in a 10.7 to 11.5.8 Oracle Applications data migration. Anyone had experience with them? Also, what is the address for the Applications list serve? Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class

Re: STATSPACK

Jared, You've got all the knowledge, for real! Is there a possibility of performance decrease when running statspack in Oracle 8.0.5? Thanks, Viktor  [EMAIL PROTECTED] wrote: No, but you can run the 8.1.6 version.There's a couple of special scripts for doing so.http://www.oracle.com/oramag/oracle/

RE: "Take Care of your DBAs"

Yeah! Way to go Charlie. (Just rubbing in the salt for you East-coasters shivering in the snow!) John Kanagaraj (Enjoying 60's in the Silicon Valeey North of Charlie@San Diego) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003

RE: Debate on rc commands Solaris and Oracle

Rao, And where did you read that 'shutdown abort' is not recommended? This is another myth that has been busted a while ago. A shutdown abort followed by a startup restrict and a normal shutdown is the way to go when dealing with rogue sessions that open a connection and never shutdown. In such c

RE: "Take Care of your DBAs"

Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work & likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND!

RE: "Take Care of your DBAs"

Montana is a bit of a drive from California but where do I sign up? If you add mountain biking, my sons would come along... Kip Bryant |Although I might resemble that remark, I still welcome the opportunity to |take fellow DBA's on a hike/hunt/fish expedition in Big Sky country. But you |have

RE: internal datatype codes

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a97269/pc_15ody .htm#11204 -Original Message- Sent: Wednesday, January 29, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Hi, Where can I find documentation on "internal datatype codes"? I thought it's in the Pro*C/C++

RE: Rogue TNSNAMES.ORA files Revisited

Brian, I used the following command - a grep of 'access' is pasted below: (I should mention that we use Oracle Name Service, so after getting to the proper sqlnet.ora, you will not see access of the tnsnames.ora. John truss -f sqlplus '/ as sysdba' > truss.out 2>&1 < -Original Message-

RE: "Take Care of your DBAs"

Although I might resemble that remark, I still welcome the opportunity to take fellow DBA's on a hike/hunt/fish expedition in Big Sky country. But you have to bring your own pepper spray and bear bells Rick Weiss -Original Message- Sent: Wednesday, January 29, 2003 3:30 PM To: Multiple r

Examples of dbms_job.submit intervals and arguments

All I need to get a better understanding of the arguments to dbms_job.submit particulay the interval although all parameters would not hurt. Ive searched online and at tahiti but I couldn't really find "good" examples of usage Can someone point me in the right direction? Or provide exam

RE: Replication..

My understanding is that Basic replication is "readonly snapshot". Anything above that, including updatable snapshot is advanced replication. Richard -Original Message- Sent: Wednesday, January 29, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Paul - That is not my understanding

RE: "Take Care of your DBAs"

Title: RE: "Take Care of your DBAs" Yeah, the good old days. :)  We even had tournaments with other dot coms.  And foos ball too.   -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 4:55 PMTo: Multiple recipients of list ORACLE-LSu

RE: "Take Care of your DBAs"

Lisa - Some of us became DBAs because we realized we would never be able to feed our families on our physical abilities. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 29, 2003 3:55 PM To: Multiple

internal datatype codes

Hi, Where can I find documentation on "internal datatype codes"? I thought it's in the Pro*C/C++ dev guide, but can't locate it. This code tells you like: NUMBER is 2, etc. Thanks in advance. Rich __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. A

RE: Getting started with OLAP/multi-dimensional databases

Jeremy - A good starting point is Ralph Kimball's stuff. He doesn't get too technical, but he does a good job of providing the "big picture". He has a lot of articles posted on his web site: http://www.ralphkimball.com His books are really good as well. Dennis Will

RE: STATSPACK

See: http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html and related articles. Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Stephen Andert [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, January 29, 2003 3:49 PM > To: Multiple recipients o

Re[2]: Re[2]: Peoplesoft & Oracle

Dave, We turned it off way back prior to implementation. Our biggest problem with the way PeopleSoft does database users is compounded by the fact that way too many of our users write their own scripts and/or use Access to create their own reports. That means that they needed public synonyms

RE: Rogue TNSNAMES.ORA files Revisited

Thanks, John. Just out of curiousity - for those of us who aren't Unix experts - what options did you use for truss to obtain that info.?? Brian -Original Message- Kanagaraj Sent: Wednesday, January 29, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Brian, The order in which the

RE: STATSPACK

Ruth, I run statspack on our 8.0.6.0 instance...however rather than running statsrep.sql I run statsrep80.sql...I think I downloaded from Tim Gorman's site http://www.evdbt.com/ or maybe http://www.oraperf.com/index.html marc Navignat International Oracle DBA -Original Message- Sent:

RE: Netbackup client configuration info

Excluding files: i hv a file on my client, which lists oracle database files not to be backedup (?) by other file backup jobs. i use hot for oracle. the file name defines for which job ("earth_os" ) it is applied /usr/openv/netbackup/exclude_list.earth_os check this link for excluding files fr

RE: "Take Care of your DBAs"

Title: RE: "Take Care of your DBAs" I used to play Ping Pong with the sysadmins and the app architect...  aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -Original Message- From: [EMAIL PROTE

RE: Replication..

Paul - That is not my understanding. If you look in the Oracle guide that shows the differences between Standard Edition and Enterprise Edition, Standard has something named "Basic Replication", and Enterprise has "Advanced Replication". Advanced means multimaster replication. Basic means snapshots

Getting started with OLAP/multi-dimensional databases

Title: Getting started with OLAP/multi-dimensional databases I'm more and more getting involved with OLAP projects, and I have to admit I'm not at all familiar with such things as star schemas, clustered tables, reporting cubes, and the like. Since I'd like to rectify this situation, and makin

RE: Need help and documentation on moving database from Unix to W

Thanks everybody I have performed it on a smaller test machine and will do the production database import/export tonight. Regards Shiva -Original Message- Sent: Wednesday, January 29, 2003 2:00 PM To: Multiple recipients of list ORACLE-L W Shiva First I would suggest you consider

RE: STATSPACK

Ruth, I've heard people talk about "downgrading" the statspack scripts to earlier versions, but I've never done it. Try searching "downgrade STATSPACK" on Metalink and OTN for starters. Good luck Stephen >>> [EMAIL PROTECTED] 01/29/03 12:59PM >>> I believe that an 8.1.7 statspack can run on an

Re: SQL question

> I can do a COUNT(DISTINCT ename || job), but that doesn't seem to be elegant > way of doing it. elegant = simple, concise, easy to understand. Looks elegant to me. Jared "Charu Joshi" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/29/2003 10:19 AM Please respond to ORACLE-L

RE: HP-UX 11i/8.1.7/DB Link Question

Mike, The listener.log provides a ton of information if handled properly. I used a Perl program to process this.. Basically, you have to look for connections from the set of identified hosts that connect to the database. 16-NOV-2002 12:55:18 * (CONNECT_DATA=(SID=)(GLOBAL_NAME=X)(CID=(PRO

Re: STATSPACK

No, but you can run the 8.1.6 version. There's a couple of special scripts for doing so. http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html Jared "Ruth Gramolini" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/29/2003 10:53 AM Please respond to ORACLE-L

RE: Global Stats

were you wrong? I dunno, you're doing all the research. ;) It was just a suggestion. :) Jared "Koivu, Lisa" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/29/2003 07:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

RE: SQL question

Title: RE: SQL question The non-working code in your example should be select count(*) from (select distinct ename,job from emp) / It appears that cound takes only one parameter ... not two. Raj __ Rajendra Jamadagni      MIS, ES

RE: Perl - Was Unix time conversion function

This sounds cool. You will of course share this, won't you? Re "Jareds_tools" - I just made a suggestion and got my name in the code. :) Jared "Jesse, Rich" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/29/2003 07:30 AM Please respond to ORACLE-L To: Multiple recipient

Netbackup client configuration info

Hello everyone, For Tivoli (TSM) backups there is a file called inclexcl on each backup client, which lists the directories which are included and excluded for backup..(along with their management classes)..I was wondering if there is a similar file in netbackup configuration which can give the s

RE: STATSPACK

Ruth - I think you can, but you must run the 8.1.7 scripts there. Do you have the 3 Oracle magazine articles that introduced STATSPACK? I think this was mentioned there. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 29, 2003 12

RE: "Take Care of your DBAs"

"shooting hoops"? Just out of curiosity, how many people on the list have a group of DBAs at their company that they shoot hoops with? Some good points, some odd ones. I'll echo Patrice's sigh (as someone who enjoys both parts of the job). Jay -Original Message- Sent: Wednesday, Ja

Re: Replication..

I believe that "Advanced Replication" was just a name change, introduced in either Oracle8 or Oracle8i. PB --- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote: > The person I know who can answer this is the guy who was Mr > Replication > in Cary's SPG-group from the beginning, namely Dominic Delmolino.

RE: Re[4]: undo tablespace

Title: RE: Re[4]: undo tablespace I think it might be a typo, or I've not had enuf coffee yet today, but the nologging on b.table2 wouldn't impact the redo logging; nologging on a.table1 would, tho... > -Original Message- > From: Breno A. K. Magnago [mailto:[EMAIL PROTECTED]] > Sent:

RE: SQL question

Title: RE: SQL question Elegant or not, here's how I'd do it select count(*) from (select distinct ename, job from emp); -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Subject: SQL

Re: SQL question

And, can you have two columns as arguements for COUNT? I guess its either one column or rows +Rachna - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 1:19 PM > Hello Listers, > > How to find out the COUNT of DISTIN

RE: SQL question

Title: RE: SQL question Joshi, SELECT count(*) FROM (SELECT count(*)   FROM flight_legs   GROUP BY d_actual_time, event_type); SELECT count(*) FROM (SELECT DISTINCT d_actual_time, event_type   FROM flight_legs ); The first one took about 37 seconds in returning

10046 Tracing ...

Title: 10046 Tracing ... Has anyone used ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE/TRCA.zip yet? I found it today and seems to be a nice utility. Sweet ... and it works even if you are not running Oracle apps. It is probably a better tkprof interface, but intuitive ..

RE: Rogue TNSNAMES.ORA files Revisited

Brian, The order in which the TNS connection searches are performed can also easily be determined by using the 'truss' command on Solaris. I used this to prove my case to a PHB of a smart-aleck Developer who was side-stepping our move to an Oracle Name Service in a prior assignment. I see what yo

RE: Perl

Perl People, Boy that sounds like a blast from the past with the purple people eater... There is an interesting Perl hot backup script at http://www.searchDatabase.com/tip/1,289483,sid13_gci876060,00.html Not understanding Perl yet and liking to keep things simple, The code seems link and complex

RE: SQL question

Charu, The COUNT() function requires a single expression. "ename, job" is not a valid expression. "ename||job" is a valid expression since it will return a single value. Another alternative would be select count(*) from (select distinct ename, job from emp); Dan Fink -Original

RE: Perl

> -Original Message- > Is it better/faster than a ksh script? -- Whether you use perl or ksh, the main purpose of the script is to build a command line and run it for whatever backup method you are using. After that, virtually all of the time is use

RE: STATSPACK

I believe that an 8.1.7 statspack can run on an Oracle8 or higher database. Dave -Original Message- Sent: Wednesday, January 29, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3 instance?

RE: Base conversion

Danny & Thilaga, You might find this useful. ;-) ...JIM... >>> [EMAIL PROTECTED] 1/28/03 2:10:28 PM >>> Here ya go: create or replace package radix is /* base code courtesy of Thomas Kyte */ function to_base( p_dec in number, p_base in number )

RE: Debate on rc commands Solaris and Oracle

Title: RE: Debate on rc commands Solaris and Oracle Paula,   Shutdown abort is not recommended as the file checkpointing is not done during shutdown abort.  If you need to perform shutdown abort, then, it is preferred to bring up the db with startup restrict (so that the users wouldn't connec

RE: Need help and documentation on moving database from Unix to W

Shiva First I would suggest you consider whether this is a good use of your client's money. This is a somewhat complex task that will be a good learning experience for you personally, but may cost the client. You should also consider how you will be able to confirm the quality of your work once

RE: Rogue TNSNAMES.ORA files Revisited

Title: RE: Rogue TNSNAMES.ORA files Revisited Yup ... learned it the hard way !! At-least AIX is *normal* (fingers crossed). Raj __ Rajendra Jamadagni  MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed

Re: off topic: iostat -x in linux

> In linux, it seems difficult, I have tried linux iostat and sysstat-iostat, >non of them seems to work properly with util column in iostat report. Though no >activity on the server at all, iostat always report utilization of the partitions >100% Why? > I also searched google and fo

HP-UX 11i/8.1.7/DB Link Question

Hi Everyone! I have been tasked with finding out how often connections are made between databases using DB links. Does anyone know of a tracking or auditing tool, or perhaps a audit methodology, that would provide this information? Thanks, Mike --- ==

Perl scripts for hot backup

Here is a link that I found for a Perl script for hot backups. Just have seen a bunch of chatter about perl on the list lately so just wanted to throw this out in case someone finds it useful. http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci857677,00.html Dave -- Please see the off

9iR2 standby databae archiving location

Has anyone run into this problem... I created a standby database using RMAN and have found that there is an archiving location defined for this standby database, log_archive_dest_11 which points to the $ORACLE_HOME/dbs directory. I didn't define a logging destination 11 and there isn't one define

STATSPACK

Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3 instance? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http:/

Re: Need help and documentation on moving database from Unix to W2K

Why do they want to move to W2k? Was it running too quickly for them under Unix? ;^) You can use export/import to move the database. Hopefully the database isn't very big. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 1/29/2003 12:59 PM, Baswannappa, Shiva <[EMAIL PROTECTED]> wrote:

RE: Need help and documentation on moving database from Unix to W

1. Install software on W2K 2. Configure DB appropriately 3. Take a cold backup from your Unix DB    3.1 Make 4 copies, 1 for actual usage, one stand-by two for off site backup 4. Import on W2K database 5. Start Database, add a dollop of Whipped Cream and enjoy ...   Raj ___

Rogue TNSNAMES.ORA files Revisited

A few days (or was that weeks??) ago, someone posted some problems they were having connecting to a database defined in their tnsnames.ora file.  The problem was resolved when they found out that there was a ‘rogue’ tnsnames.ora file residing in the same directory as the binary.  The binary

SQL question

Hello Listers, How to find out the COUNT of DISTINCT values of multiple columns? For eg. SQL> SELECT DISTINCT ename FROM emp; -- This works. SQL> SELECT COUNT(DISTINCT ename) FROM emp; -- So does this. SQL> SELECT DISTINCT ename, job FROM emp; -- And this too. SQL> SELECT COUNT(DISTINCT ename

Need help and documentation on moving database from Unix to W2K

Hi Gurus   I am not a DBA, but  I have request from client to move their oracle 8.1.6 database from a Unix server to W2K. Can somebody lead me to documentation in moving entire DB or any other resource that will help me accomplish the task?   Thanks a ton in advance   Regards Shiva Baswann

Re[4]: undo tablespace

Mike, What type of operation are you performing on your table? INSERT INTO A.TABLE1(COL1,COL2) SELECT COL1,COL2 FROM B.TABLE2@DB_LINK; I think that command support the NOLOGGING.Is is correct ? The table B.TABLE2 and all indexes are in NOLOGGING Option. -- Breno A. K. Magnago

RE: Re[4]: undo tablespace

Breno, There is your problem. Don't try to solve it by trying to eliminate undo. I have run into that situation several times. The key is to set up the database management processes to handle the situation. Things to think about: 1) Increase the size of the device where archive_dum

RE: Perl

Title: RE: Perl Thanks a bunch ...   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 clod can have facts, b

RE: Re[2]: undo tablespace

AFAIK, in 8i+ tablespaces can be created with the"NOLOGGING" clause LOGGING | NOLOGGING Specify the default logging attributes of all tables, indexes, and partitions within the tablespace. LOGGING is the default. The tablespace-level logging attribute can be overridden by logging specificatio

Export Oracle data to Excel

Some of you will no doubt be interested in this: http://www.knownow.com/cworld/dm/excel.html Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Problem on P4 intel servers

The problem was with lower versions of the database. The newer version of symcjit.dll are included on the newer media. I am not sure what version started to include the correct dll version. I am guessing 9i release 1. Don Bricker Database Administrator / System Administrator Illinois Environment

RE: Problem on P4 intel servers

I believe the problem affects only 8i. 9i is ok. -- Lyndon Tiu Quoting "Jesse, Rich" <[EMAIL PROTECTED]>: > I completely forgot all about this, but the install I just > completed went > without a hitch. I'm running Win2K SP3 (bleah) and installed > 9.2.0.1.0 > downloaded from OTN last night.

Re: Database Too Slow - Suggestions???

What is Buffer Cache Hit Ratio? LC Hit RAtio? What's the hardware? Run top or mpstat or sar to get the system stats... We had seen somewhat somilar bstat estat data... +Rachna - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 29,

Re: Upgrade 8.1.6 - 8.1.7 Patch 4

Upgrade 8.1.6 to 8.1.7 and then apply the patch. Read the docs carefully before applying the patch it is an ugly puppy. --- [EMAIL PROTECTED] wrote: > Im doing an upgrade from 8.1.6. to 8.1.7.4. > Is there any benfit of doing the upgrade from 8.1.6 > to 8.1.7, using > ODMA then patching to 8.

Re[4]: undo tablespace

Dan, Is the generation of redo (and archived logs) causing the system to halt due to the archive_dump_dest filling up? YES I'll work to minimize this situation. Thanks. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 1:19:50 PM, you wrote

RE: "Take Care of your DBAs"

Title: "Take Care of your DBAs" I love this article.  I forwarded it to damagement too because they haven’t been showing enough love for the DBAs lately ;-).       Best regards,   David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkw

RE: Re[2]: undo tablespace

I agree in principal with Dan's thesis, but I'll add something. Don't do things that generate unnecessary undo and redo, either. One common example is SQL that updates a column to a value that it already contains. For example, we see things like setting a flag='y' without checking that the flag d

Re: Re[2]: undo tablespace

breno, i believe the 'no logging' option only applies to data that is direct loaded into your tables therefore, you may be able to bypass logging if you used sqlldr or 'create table as select' good luck, steve "Breno A. K. Magnago" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/29/2

Re: toad question

Only 'Execute' right should be enough. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-2576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] "Jeffrey Beckstrom" <[EMAIL PROTECTED]> gcrta.org Sent by: [EMAIL PROTECTED] 29.01.2003 15:48 Please res

RE: Problem on P4 intel servers

I completely forgot all about this, but the install I just completed went without a hitch. I'm running Win2K SP3 (bleah) and installed 9.2.0.1.0 downloaded from OTN last night. Is it possible that someone (perhaps in SP3) fixed this? Rich Rich Jesse System/Database

Re: [Q] grant select on "column level security" failed?

Create a view (including only columns you want user1 to see) and let user1 use this view instead of table. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 10:24 AM > > I tried

RE: Re[2]: undo tablespace

You're correct in saying that your undo blocks are protected by your redo files. What type of operation are you performing on your table? I ask because only a small subset of commands support the NOLOGGING feature; the remainder will generate redo as usual. If you're not using a syntax that supp

RE: Debate on rc commands Solaris and Oracle

Title: RE: Debate on rc commands Solaris and Oracle System Administrator says he doesn't trust that the rc commands will stop if the database doesn't want to shutdown and even if it does would want to shutdown with scripts beforehand so that a DBA could connect and resolve the issue.  Other DB

  1   2   >