Choose different variables

Hallo, Can anyone tell me how I can send different variables into a procedure, depending on which action should take place? Please give me an example. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

RE: "Publishing" HTML

Do you have a web server running at all? I ask because I've created some java servlets that will provide a phone-book type page. It uses a table that's been created on the DB to store all the names and numbers etc, and then just does a select on it from within the .java code. It also has some HTML

Snapshot performance issue

I have a view based on the query below which is executed in a reasonable way on the master site but this same view takes hours on the snapshot site.  Any idea ?     CREATE OR REPLACE VIEW V_ENTITE_EMETTEUR2  AS  select /*+ ORDERED USE_NL(E A SI SY O LF MO AM MR ST) INDEX(E I_REF_EMETTEUR)*/

export user definitions

hi everyone can anybody help me with a script that recreates user definitions and the granted roles ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Solaris Hang

Hi all, My Machine Ultra 10 256 MB, Solaris 7 running : 0. Stand Alone workstation 1. Oracle 8.1.6 single dbwriter logwriter, noarchive 2. Hot Java 3. 3 Text Editors 4. 2 Terminals 5. 2 File Managers When I tried to copy 5 files into floppy my CDE frozen ? and my floppy "busy light" is stil

RE: Sql query

The query becomes perfect, if you replace ROW_NUMBER() BY DENSE_RANK(). --nIRMAL. > -Original Message- > From: Swapna_Chinnagangannagari > [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 9:05 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Sql query > > H

RE: Would you use 9i?

Title: Would you use 9i? Hi Christopher It's great that you are starting a new company. Could you tell me the about the employment oppurtunities in your company ;-)       Rgds, Sachin Puri Oracle Development and Administration Solutions Inc      -Original Message-From

RE: export user definitions

Do a full export ( without data, rows=n ) and import with indexfile option. You can see all the information including users. HTH, Rajesh -Original Message- Sent: Monday, September 10, 2001 1:45 PM To: Multiple recipients of list ORACLE-L hi everyone can anybody help me with a script

RE: Do fast full index scans do physical disk reads?

Ian, I'll look at compressing the index. Does that only work on unique indexes or can you do it on non-unique multi-column indexes as well? Thanks, Cherie

Re: Oracle job ???

Janet, Check the OTN - Skills Market place, Headhunter.net, DBAJobs.com, the Denver newspapers on line. I have seen some adds for the Denver area a few times. Good Luck, Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 09/08/01 01:05AM >>> Hi all, I'm trying to find an Oracle DBA position in Denver. Does

v_$session HELP...

Hi all, Can someone tell me who are those users that identified by null value in username column SQL> SELECT username from v_$session where osuser='dba'; USERNAME --- SYS SYS 8 rows selected. Thank you Sinardy -- Please see the official ORACLE-L FAQ: htt

RE: export user definitions

Rajesh, I am afraid indexfile option will not show such information. If using exported dump file is opted for such information, then it has to be extracted using either 'strings' command (UNIX) or by importing using the show=y log= option. The logfile will then have to be edited to fish out the

RE: collections / records / index-by, etc - long, sorry

Title: RE: collections / records / index-by, etc - long, sorry Thanks Prakash, but can I use FORALL with this object?  I don't think so.  Correct me if I'm wrong. Thank you Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From:   Bala, Prakash [SMTP:[EMAIL PROTECTED]] Se

RE: DYNAMIC SQL - Please mod request to trap error when insert fa

Al, did you issue a "set serveroutput on" before you tried executing the procedure to see if your proc worked ok? your procedure looks ok, the only other thing I would check is to run the select statement outside of the proc to be sure that records are selected ok. one other thing - depending o

RE: Do fast full index scans do physical disk reads?

Rarely would you need to compress an index. Compression of an index is perfect for a case as follows: Table 1 Col1Col2 Col3 -- 45100 1 25 124 34423 04 124 24643252 06

RE: export user definitions

Thanks a lot for correcting me,I just remembered the basic idea and missed the real stuff ( SHOW=Y AND LOG=) Too Busy with some bugsNpatches of 8.1.7 ;-)) Rajesh -Original Message- Sent: Monday, September 10, 2001 4:10 PM To: [EMAIL PROTECTED]; Rajesh Dayal Rajesh, I am afraid ind

RE: v_$session HELP...

The background processes. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford

RE: v_$session HELP...

Title: RE: v_$session HELP... The background processes.  I exclude these sessions when viewing activity in the database with my sessions script. Lisa Koivu Oracle Databug Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From:   Sinardy [SMTP:[EMAIL PROTECTED]]

RE: DYNAMIC SQL - Please mod request to trap error when insert fa

George ... After insert you need a commit somewhere ... preferable after the dbms_sql.execute only then number of rows actually written to the database will increase. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni

Re: v_$session HELP...

They are the Oracle background process, pmon,smon,reco, etc. Look at the username and program and you can see who they are. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 8:55 AM > Hi all, > > Can someone t

query for top customer

how to write a query to find top 3 customer based on their sales . eg. TABLE A customer sales A100 100 A101 200 A102 105 A103109 A104108 RESULTS should be.. A101 200 A103109 A104108 Thanks in advance Brajesh

Re: Choose different variables

On Monday 10 September 2001 01:05, [EMAIL PROTECTED] wrote: > Hallo, > > Can anyone tell me how I can send different variables into a procedure, > depending on which action should take place? Please give me an example. > Roland Roland, Can you provide more information? This is rather sparse an

RE: export user definitions

nope, not using the indexfile definition you won't. That way all you'll see are table and index create statements. if you do a full import, using show=y and log= you will get a file that contains ALL statements that would recreate your database. They aren't particularly readable as oracle bre

RE: v_$session HELP...

select program as well and all will be revealed Regards Lee -Original Message- Sent: 10 September 2001 13:56 To: Multiple recipients of list ORACLE-L Hi all, Can someone tell me who are those users that identified by null value in username column SQL> SELECT username from v_$sess

RE: db engines VS flat files

Highly depends. If your reading the data sequentially, then flat files will be faster, unless you have many multiple users. If your sorting, or doing complex things with the data, then Oracle will most likely be faster. Oracle will also allow security and integrity of the data. "Do not criti

RE: v_$session HELP...

Title: Message I have a decent script on my site www.vampired.net which is a glorified WHO.It takes this in account, and does some formatting as well to make it all pretty. Also, sniped and killed sessions are shown seperately in the second results. I believe it is under user/objects   "Do n

RE: dbms_jobs

>Less keystrokes, yes, but the long version is less likely >to generate questions like 'What do those numbers mean?' :) There in the books :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christoph

Re: db engines VS flat files

In addition to Greg's comments I would like to add that anyone suggesting flat files for 50 gig of data is probably not at all familiar with database technology. Perl is an excellent language for manipulating data, but it is not a database engine. 50 gigs of data is totally unmanagable as flat

Re: v_$session HELP...

the background processes that run oracle -- pmon, smon, dbwr etc >From: "Sinardy" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: v_$session HELP... >Date: Mon, 10 Sep 2001 04:55:34 -0800 > >Hi all, > >Can someone tell me w

Re: v_$session HELP...

Those are background processes. This should clear it up for you. Jared select b.name, s.sid, s.serial#, s.status, s.machine, s.osuser, substr(s.program,1,20) client_program, s.process client_process, substr(p.program,1,20) server_program, to_char(p.spid) spid,

Re: current procedure that is executing

If these are in house modifiable procedures, you could use DBMS_APPLICATION_INFO to cause the package/procedure name to appear in v$session. Here are details: http://www.oradoc.com/ora817/appdev.817/a76936/dbms_app.htm#999107 Jared On Sunday 09 September 2001 19:15, Suhen Pather wrote: > Lis

Licensing??

Hi, Can someone explain how the named-user licensing works? Also, has concurrent usage licensing gone away? We have a need for an additional database to use for mapping/geo-coding purposes. The primary application will periodically perform a query against this new database to "look up" some mapp

RE: query for top customer

Hi, Try this query: select customer,sales from tablea x where 3 > (select count(*) from tablea y where y.sales > x.sales) order by x.sales desc; Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Monday, September 10, 2001 8:30 AM To:

RE: query for top customer

SELECT customer,sales FROM (SELECT customer,sales FROM table_a ORDER BY sales DESC) WHERE rownum < 4; Must be running at least 8i for this to work Rick -Original Message- Sent: Monday, September 10, 2001 9:30 AM To: Multiple recipients of list ORACLE-L how to write a qu

Re: v_$session HELP...

Background processes identified by null value in username column. Igor - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 8:55 AM > Hi all, > > Can someone tell me who are those users that identified by null value

Re: export user definitions

On Monday 10 September 2001 02:45, [EMAIL PROTECTED] wrote: > hi everyone > > can anybody help me with a script that recreates > user definitions and the granted roles ? > > thanks > > g.g. kor > rdw ict groningen Someone asked this just a couple of weeks ago. That script will recreate a user.

RE: Sql query

Nirmal, And what about "ties" and the double (or triple or more) summation that would occur? The reason for *not* using DENSE_RANK or RANK for this query is the way they handle ties -- assigning the *same* rank to values with the same value. This nature would make it difficult, for example, if y

Re: Passing a parameter containing a space to sqlplus

I have just found a reference to the below question within Metalink - You need to quote the string as follows: '"WORD1 WORD2"' Apologies for my premature posting. Best Regards, Barry. Hi gurus, I'm trying to pass a parameter from unix into a sqlplus script. The parameter contains a space,

RE: v_$session HELP...

The sessions where username is null are generally the Oracle background processes. You can confirm this by also checking the TYPE column for 'BACKGROUND'. Jon Walthour -Original Message- Sent: Monday, September 10, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Hi all, Can som

Re: dbms_jobs

On Monday 10 September 2001 06:35, Christopher Spence wrote: > >Less keystrokes, yes, but the long version is less likely > >to generate questions like 'What do those numbers mean?' :) > > There in the books :) Geez Chris, of course they're in the books. That doesn't stop people from asking. :

RE: query for top customer

Try this... DECLARE CURSOR c_sales IS SELECT * FROM sales ORDER BY sales desc; r_sales c_sales%rowtype; l_count NUMBER := 0; BEGIN OPEN c_sales; DBMS_OUTPUT.PUT_LINE( 'Customer' || ' ' || 'Sales' ); WHILE l_count < 3 LOOP FETCH c_sales INTO r_sales; DBMS_OUTPUT.PUT_LI

RE: How do you audit a DBA?

So you've had a mass DBA exodus too? We're currently at 50% (3/6) of the Oracle DBA staffing levels we had a year ago and have finally gotten permission to add one more person. Hmm, if anyone is looking for a job in Jersey City near the PATH train with lots of bureaucracy and paperwork but occasi

RE: export user definitions

what kind of options you use in 'strings' command? There is one option like 'strings -a | -'. When I tried this option on dump file, it didn't work. Thanks in advance! Lucy Lin On Mon, 10 Sep 2001, Deshpande, Kirti wrote: > Rajesh, > I am afraid indexfile option will not show such informat

Re: Do fast full index scans do physical disk reads?

On Monday 10 September 2001 05:50, [EMAIL PROTECTED] wrote: > Ian, > > I'll look at compressing the index. Does that only work on unique indexes > or can you > do it on non-unique multi-column indexes as well? You can compress unique and non-unique indexes. You may get better compression fro

Re: db engines VS flat files

well so start to bite your tonge :-) because yes there are some very large collections of datas stored as flat text files, so do bite it and do it very hard because this large amounts of datas may almost doble the size every year... and most of them are being searched and manipulated with per

RE: dbms_jobs

Yeah, just say RTFM :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01

shutdown immediate hangs

I have Oracle 8.1.7 running on windoze NT 4.0. Every night I have a script that kicks off a cold backup. Part of the script issues the command SHUTDOWN IMMEDIATE which normally works just fine before I actually copy my files. However, periodically the "shutdown immediate" command does not wor

Re:Licensing??

Walter, First question, where are all of the astrological signs? Their needed to understand Oracle's pricing schemes in the first place. Now names users is exactly that. You have to be able to put an employee name next to a database connection, as I understand it. Since it sounds like

Re: Passing a parameter containing a space to sqlplus

Barry Make sure that your substitution variable is in single quotes '&1' and then pass the parameter in single quotes, (or in single quotes surrounded by double quotes) hth chaim Barry Deevey <[EMAIL PROTECTED]>@fatcity.com on 09/10/2001 11:15:25 AM Please respond to [EMAIL PROTECTED] Sen

Re[2]: db engines VS flat files

Allow me to interject something from antiquity as well. I have the displeasure to work with an old database called TurboImage from HP. I would place it somewhere between a flat file and a real database engine. The reason being that it stores data in flat files that are accessed via turboimage i

Passing a parameter containing a space to sqlplus

Hi gurus, I'm trying to pass a parameter from unix into a sqlplus script. The parameter contains a space, i.e. "JOB SERVER" I have tried passing it with both single and double quotations, but the sql script only accepts the first word in the string. It works fine if the parameter does not cont

Script for checking temp usage

Does anybody have a script that will tell you which session_ids are using temp and how much they are using? We occasionally get runaway sessions that don't release temp and this would allow us to easily locate the offending session. I've already checked OraMag and used google with no significant

RE: Logging into Windows 2000 "Advanced" Server - Solved, Thanks

Thanks folks, The SET command was what I needed. It turns out that the network folks installed some new software on the server and somehow trashed the Oracle environment. Even though I manually set my environmental variables, I still was unable to connect to the instance. Oracle support told

Re: query for top customer

SELECT a.customer, a.sales FROM (SELECT customer, sales FROM a ORDER BY sales desc) a WHERE rownum<4; would do the trick... - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED

Re: query for top customer

works on 8.1.7 SELECT * FROM (Select * from tableA order by sales) where rownum<4; - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 4:30 PM > how to write a query to find top 3 customer > based on their sales . > eg. > T

Oracle, security & the USAF?

Some of you may be interested in this: -- 1251. AFRL successfully completes Oracle test program ROME, N.Y. (AFPN) -- Air Force Research Laboratory engineers here successfull

RE: How to organize oracle directories in Unix ?

As long as your mount points are not sharing disks from the same volume group you are correct. However, its expensive to write to RAID 5 which is why you will usually see raid 0+1 instead. -Original Message- Sent: Sunday, September 09, 2001 7:55 AM To: Multiple recipients of list ORACLE

RE: v_$session HELP...

Actually background processed are identified by "BACKGROUND" in the type column and happen to have a null in the username. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Or

RE: manage oracle on SAP system

Typo. Alex Hillman -Original Message- Sent: Friday, September 07, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Alex, Are you joking or it's a typo ? but I like Iracle (Irate+Oracle ??:) SAP DBA... - Kirti > -Original Message- > From: Hillman, Alex [SMTP:[EMAIL PR

RE: Last time an Index was used..

Wow, that's a nice feature. Any idea what the overhead is for this (not that we'll be moving to 9i for at least a year)? Jay Miller -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L Under 9i MONITORING USAGE | NOMONITORING USAGE

RE: export user definitions

Kirti, I found problem with strings on HP-UX. If create table line is long it cuts it. In Oracle Financials create tables scripts are very long and while converting dmp file to txt file it cuts a lot of stuff. Do you know any work around for this problem. I never observed this problem with NCR

(Fwd) RE: How do you audit a DBA?

trying again... --- Forwarded message follows --- The destination address you specified for your message could not be reached because of a locking problem. Your message is being returned to you so that you can resend it if you desire. The locking problem should be resolved within a few

RE: query for top customer

SELECT B.CUSTOMER, B.SALES FROM (SELECT CUSTOMER, MAX(SALES) FROM SALES) B WHERE ROWNUM < 4 Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Oracle DBA Enviado el: Monday, 10

RE: query for top customer

Good grief! Here's me publishing war-n-peace to solve a problem that takes 4 lines of code...that's the last time I go out both nights at the weekend!! ;) Please ignore my overly-engineered email when it finally arrives... -Original Message- Sent: 10 September 2001 16:10 To: Multiple re

RE: db engines VS flat files

I think it's one of those things that if you have to ask then... -Original Message- Sent: Sunday, September 09, 2001 12:40 PM To: Multiple recipients of list ORACLE-L I would like to know your opinion about the developments under for example perl for handling large amounts of datas (se

RE: Oracle, security & the USAF?

Is this happening or happened? "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelm

RE: db engines VS flat files

Huh? Doesn't the irs use flat files? :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street No

OT: Anybody heard of...

Anbody heard of a contract agency in the uk called Cyren? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patrick Mullen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acce

Re: Script for checking temp usage

try this query: SELECT s.username, s.serial#, s.sid, u.tablespace, u.contents, u.extents, u.blocks FROM v$session s, v$sort_usage u WHERE s.saddr=u.session_addr; Lucy On Mon, 10 Sep 2001, Jenkins, Michael wrote: > Does anybody have a script that will tell you which session_ids are using >

RE: Script for checking temp usage

Michael - I've had similar problems (although the pain isn't high enough for me to get in there and fix them yet). To do this I've set up a cron job to check every 15 minutes. The script I run is: set lines 100 pages 87 column username format a10 column tablespace format a6 heading 'TBSP' col

Re: "Publishing" HTML

Below is the solution that was implemented & is now in production. Scott Graves wrote: > > To produce a simple page, at the sqlplus prompt type "set markup html on" > then issue your query and spool it to a file. > #!/usr/bin/ksh # Formats a simple webpage for an emergency call list. # . ${H

RE: query for top customer

Hi thomas, You use correlated sub-query for that, it's quite simple than ur stuff: select * from emp a where &n >= (select count(distinct sal) from emp b where a.sal <= b.sal) order by sal desc; --- [EMAIL PROTECTED]> ed Wrote file afiedt.buf 1 select * from emp a where &n >= (select count(

RE: Do fast full index scans do physical disk reads?

You cannot compress single column unique indexes. The rule is: you can compress up to n-1 columns of a unique index where n = the number of columns in the index. A multi-column compressed index should, for maximum effect, have as its leading column the one with greatest number of repeated va

RE: ORA-6502: numeric or value error. 8.1.5, NT

Ok, let's try this again. The limitation that I mentioned below about Excel is not true. We finally got the ColdFusion developer to look at this problem, after I finally convinced everyone that this is not an Oracle or Excel issue. The CF developer immediately knew the answer. Apparently,

RE: Script for checking temp usage

Have you looked at v$sort_usage? (8i only) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street

RE: Last time an Index was used..

Not much at all, you can use monitoring in Oracle 8i. Since it only writes the changes every few hours, it has very monitor impact. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spe

RE: export user definitions

Mohammed, No, I have not found a solution for it. IBM-AIX does that too. I have several tables with partitions, and the ddl for it is never complete, if I used strings. So I use it for things that do not have long SQL statements. For others, I use scripts or 3rd party tools. Regards, - Kirti D

[Fwd: Re: patch question]

Thanks, Joe, I read the notes. It seems can go either way. I reinstalled the 817 base again. My next question puzzled me, should I upgrade database first 816-> 817, then apply the patch, or apply patch goes first? Maybe it goes either way. But I'd like to hear some advice first. Joan O

RE: Do fast full index scans do physical disk reads?

Actually you can create compressed indexes upto the size of the columns. In other words, the last column in a concentated index can be compressed. Although most practice does not. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a

Re:RE: Oracle, security & the USAF?

Last time I looked it up 'completes' was past tense, as in history. Dick Goulet Reply Separator Author: Christopher Spence <[EMAIL PROTECTED]> Date: 9/10/2001 8:25 AM Is this happening or happened? "Do not criticize someone until you walked a mile

Re: Script for checking temp usage

Since 8.X joining v$sort_usage and v$session. In 7.X Metalink had an script that I enclose. When the query is running, you can issue a query over v$session_wait. Looking for the event 'db file sequential read' where p1 includes all the files of the temp tablespace. Regards. --- "Jenkins, Mic

RE: shutdown immediate hangs

Dave, Worth Checking - Sometimes the OracleAgent service or the OracleDataGatherer service, if running, will cause the SHUTDOWN IMMEDIATE to hang. Try shutting such services down by including a 'net stop OracleAgent..' etc. in your script, just before you issue the SHUTDOWN IMMEDIATE. HTH Vik

RE: ms acces

Oracle's Migration Workbench will do what you need, if you're on Oracle Client 8.1.7 or newer. > -Original Message- > From: agc [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 06, 2001 2:59 PM > To: Multiple recipients of list ORACLE-L > Subject: ms acces > > > is there any tool

RE: export user definitions

Thanks...for update... MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 10 Sep 2001 10:10:19 -0800 Mohammed, No, I have not found a solution for it. IBM-AIX does that too. I have several tables with partitions, and the ddl fo

RE: Cloning Database failed

Unfortunately I'm not using RMAN. If I can find the space somewhere I'll test recreating the control file route and create it with just a few tablespaces. -Original Message- Sent: Friday, September 07, 2001 2:07 PM To: Multiple recipients of list ORACLE-L If you are using rman try doin

RE: shutdown immediate hangs

Dave: The message in the alert log means that there are uncommitted transactions. During a shutdown immediate uncommitted transactions are rolled back and Oracle must wait until this rollback is complete before the db can be actually shut down. You could do a shutdown abort, but then you would h

Re: db engines VS flat files

Since we're not in a meeting, I don't have to bite my tongue. 'Context sensitive indexing' comes to mind. Jared agc

Re:RE: shutdown immediate hangs

Jon, One correction, shutdown immediate waits till all uncommitted transactions are committed or rolled back. The client session must do one or the other, otherwise the shutdown hangs waiting for the end user. This is a good example of where setting the idle time in user_profiles is a good

What's wrong with this query

Hey list, Can anyone tell me what's wrong with this query? many thanks, select /*+ INDEX(b)*/ distinct d.batch_number , d.document_number , d.entry_user_id , d.document_type_id , d.document_processed_date , b.batch_media_id, d.return_Method_Id from submitter_batch b , document d ,

Re: shutdown immediate hangs

Dave, We've periodically had this problem with various jobs that were running at the time of the shutdown immediate. I try to isolate the cause by killing the various processes I still see running via ps -ef | grep SID. Sometimes the problem has been our RMAN backup that is running, sometimes

RE: RE: Oracle, security & the USAF?

I wonder what was the result of their findings. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton St

Re:RE: shutdown immediate hangs

On Mon, 10 Sep 2001, [EMAIL PROTECTED] wrote: > One correction, shutdown immediate waits till all uncommitted > transactions are committed or rolled back. The client session must > do one or the other, otherwise the shutdown hangs waiting for the > end user. No, that's shutdown transactional.

RE: What's wrong with this query

Title: RE: What's wrong with this query Your hint is wrong.  You have to tell it what index to use.  example  /*+ index (table_alias index_name) */ Remember hints, if they are wrong, will just be ignored. Your execution plan seems OK.  It's returning an awful lot of rows ... Lisa Koivu Or

RE: Do fast full index scans do physical disk reads?

The restriction is on unique indexes. 1* select column_name from dba_ind_COLUMNS where INDEX_NAME = 'WOLO_PK' SQL> / COLUMN_NAME PERSON_ID INSTITUTION_CODE ALTER INDEX CASEPUPPY.WOLO_PK REBUILD COMPRESS 2 TABLESP

RE: db engines VS flat files

Biting your tongue is no fun, I just say what I think. Which happens to be a whole lot of nothing. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-57

RE: db engines VS flat files

jey man take it easy... just a joke.. nothing serious... On Mon, 10 Sep 2001, Christopher Spence wrote: > Date: Mon, 10 Sep 2001 11:40:41 -0800 > From: Christopher Spence <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: db engines VS flat files >

RE: Interesting News..

No. I'm more interested in what happens to the customer. [via ORACLE-L Digest -- Volume 2001, Number 251] > -- > > From: "Walthour, Jon (GEAE, Compaq)" <[EMAIL PROTECTED]> > Date: Fri, 7 Sep 2001 06:50:52 -0400 > Subject: RE: Interesting News.. > > Eric: > >

Concepts Manual

Am I blind, or did Oracle omit the Concepts Manual from http://docs.oracle.com? I am going to do a search in Technet. Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiqu

Re: Hardware requirements when migration oracle from NT to Linux

one of these might work: http://www.stanford.edu/dept/news/report/news/gifs%20archive/smserver.jpg - or: http://www.compulab.co.il/486core.htm [via ORACLE-L Digest -- Volume 2001, Number 251] > > -- > > From: Schoen Volker <[EMAIL PROTECTED]> > Date: Fri, 7 Se

RE: db engines VS flat files

I know it was, but I was serious :) "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North,

  1   2   >