RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4

Yet surprisingly naive in the use of Internet lists :-) -Original Message- Sent: 31 October 2001 01:00 To: Multiple recipients of list ORACLE-L Bill, I'm a 3 year DBA with SAP Basis, NT Admin, and Unix admin experience. If you come across something in Northern Colorado, please let

RE: Script for next_extent of objects = free space available

Try this query to show objects whose next extent is larger than the largest free extent in the respective tablespace. set linesize 120 col owner format a10 col segment_name format a20 col type format a7 col tablespace format a15 select a.tablespace_name tablespace, segment_type

Oracle on NT startup question

Dear list ! If my NT server (which runs an Oracle instance) gets rebooted accidentally, how can i bring up the Oracle services without starting up the instance ? I want to startup the instance with a script later . I'm interested in an answer for both Oracle 8.0.5 and 8.1.7 on NT4. Thanks in

RE: Script for next_extent of objects = free space available

Hi Gerardo, I notice that in your script the free space is also derived from dba_free_space (same as my script). Although I issued the command alter database set autoextend on next ??M for the datafile, the table dba_free_space does not reflect this changes. Any other advice ? Thanks. Regds,

RE: Oracle on NT startup question

Hi Zhangxiangli! Thanks for your reply ! Tried what U've suggested , unfortunately it brings up the service and therefore starts the instance. I need something to start the service but not to startup the instance. Thanks a lot ! -Original Message- Sent: Wednesday, October 31, 2001

Re: Snapshot

Hi, A snapshot is basically a view with a table at the back-end so that the view data does not have to be calculated real time. They have called it materialized view in the 8i version which is a better description of what it is. Jack Hamid Alavi [EMAIL PROTECTED]@fatcity.com on 30-10-2001

RE: recovery database!!

Hi, If you have all datafiles (system at least) you can use them to make a clone using the create controlfile command. I suggest you look up the documentation on cloning databases. example: we clone w/o the temporary tablespace (very big in production not needed in test)

NLS Support in Oracle..

Hi Gurus, We want to develop a multi-lingual application where the user would have entered some data(NVARCHAR2) and some other user would like to view it in a different language. So, I wud like to know how to enter NVARCHAR2 data in any language and query the same data in any other language. How

RE: Problem with DBMS_SQL - Long and probably annoying

The owner of the package/tables is the one actually doing the execute so permissions is not the issue in this case. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 8:13 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Kimberly, A bit of a long shot here

RE: Script for next_extent of objects = free space available

Hi, I have this Space Bound object script that will list every table that can not allocate it's next extent. It will not list tables in tablespace that is set to autoextent. This is not entirely correct as you may have set an upper limit to the auto extent (if you feel like adding it in please

RE: Oracle on NT startup question

Hi, What kind of service you refering to Listeners ? lsnrctl start To start databse wihtout instance startup nomount Sinardy -Original Message- Sent: Wednesday, 31 October 2001 5:35 PM To: Multiple recipients of list ORACLE-L Dear list ! If my NT server (which runs an Oracle

RE: NLS Support in Oracle..

I think you need some kind of function as translator to achieve that, my guru said is verydifficult (almost not possible for people like me ??!?!?!!!) to change database NLS. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Arul kumarSent:

RE: Oracle on NT startup question

the previous I think can be apply for both versions -Original Message- Sent: Wednesday, 31 October 2001 5:35 PM To: Multiple recipients of list ORACLE-L Dear list ! If my NT server (which runs an Oracle instance) gets rebooted accidentally, how can i bring up the Oracle services

Re: NLS Support in Oracle..

So, I wud like to know how to enter NVARCHAR2 data in any language Create utf8 database. and query the same data in any other language. How easy it is? Use Unicode to retrieve data. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL

RE: Oracle on NT startup question

Title: RE: Oracle on NT startup question Hi You will have to use the oradim utility to remove the current service. Then recreate the service using the parameter -STARTTYPE SRVC. This then causes the system to start only the service and not the instance. [-STARTTYPE SRVC | INST | SRVC,

what is the fastest way to update a big table with more than 50000 rows and 20 columns

hi guys, i have a big problem in updating an oracle 8i 1.7 database table with more than 5 rows and 20 columns. The problem is: i have another table with approximately 17000 rows and 12 columns. The latter one holds newer data, and most of them have the same primary key as the

Alter different session

Hello Is it possible to alter different session or can I change parameters only of my own session (using 'alter session ...') What priviledges do I need to do it? Is there a procedure to do it? (like dbms_system.set_ev for events) Kind regards Ivo Libal -- Please see the official

Re: Oracle database users

Hi Pruthvi, Actually speacking , the limit should be the No. of USER Licences purchased for yr Oracle s/w. but Oracle allows to exceed that number. hope this may help u. regards, Arul. Pruthvi wrote: Hi, How many users can be created in a Oracle database? Thanx in advance, Pruthvi

RE: what is the fastest way to update a big table with more than

yilmaz, First of all, your query is probably performing a full table scan on each table because of your use of the TRIM function. Remove this. Secondly, why join the two tables together? Just query the table with the newer data in a loop, and update the older table like this: declare

Re: Oracle on NT startup question

Try to set registry entry ORA_%SID%_AUTOSTART to FALSE in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 4:35 AM Dear list ! If my NT

RE: what is the fastest way to update a big table with more than 50000 rows and 20 columns

UPDATE join a SET a.source = (SELECT b.source FROM cs b WHERE b.totid = a.totid); Rick -Original Message- Sent: Wednesday, October 31, 2001 7:15 AM To: Multiple recipients of list ORACLE-L rows and 20 columns hi guys, i

Re: what is the fastest way to update a big table with more than 50000 rows and 20 columns

Try this: update cs c1 set c1.source = ( select j.source from join j, cs c where trim(j.totid)=trim(c.totid) and j.source is not null) where trim(c1.totid)=trim(c.totid); Should be faster, at least because you don't have to switch between PL/SQL and SQL. Also, do you

RE: Problem with DBMS_SQL - Long and probably annoying

Kimberly, Look closely at the following statement - put more debug statements in this area to show the exact sql statement you are trying to parse. The SELECT portion looks fine to me - provided that all of the columns do exist in the tables you reference. My guess is that the problem is in

RE: Alter different session

I don't think this is possible because few of the session level settings will reside in PGA and it will be bit difficult to intrude in to this private memory. I am not aware of any events or hidden commands to do that Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868

Re: Oracle database users

on one site we created over 60,000 user accounts with no problems but is that what youreally want to know or do you want to know how many users you can have active in the database at one time? --- Pruthvi [EMAIL PROTECTED] wrote: Hi, How many users can be created in a Oracle database?

Re: Oracle database users

http://www.itsystems.lv/gints/oracle_limits.htm Second row from the beginning ;) Although You will face hardware limitations much sooner And remember about licensing ;) Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/

Re: what is the fastest way to update a big table with more than 50000 rows and 20 columns

are all the rows in the newer table also in the older one? you seem to be unnecessarily complicating your life. why not just do the script below. You are also forcing Oracle to read the ENTIRE larger table since you are performing a function on the id in the update statement. If there is anyway

Re: IOT - comment about high writes

I think, IOTs are fine with high writes (meaning 'inserts'), when new records inserted in sequential order (artificial PK, or PK of DATE type). I am using them successfully. Otherwise, IOTs could be a performance problem with high 'updates' (if record length changes), or records inserted not in

Re: what is the fastest way to update a big table with more than

thanks Mercadante, actually i have to use trim() function because the type of join.totid (varchar2(255) and type of cs.totid (char(255) are different.So when i compare those two values my program can never find an equal value.I tried to change both of htem to char(8) , but i am having an error

Re: Oracle on NT startup question

My understanding is that the instance is the service. Can you start the instance without a mounted database? Andrey

RE: Problem with DBMS_SQL - Long and probably annoying

Kimberly, Taking your code, passing the parameters you did, and taking a look at the SQL statement that is built, you end up with this in your WHERE CLAUSE: AND a.shift IN A AND a.equipment_id IN 1408 If shift is a varchar2 column, which by passing the value of A I assume it is, you need

Oracle 8.1.6 silent install

Hi All, I have a question relating to silent installs of Oracle 8.1.6 on Solaris 8. I have managed to get the response file working correctly and everything seems to be working okay. The problem is that I can't seem to find any varible (in the response file) that will allow me to specify

Multiple languages Datawarehouse

Hi, Anybody has built a multi-languages datawarehouse ? The star schema is quite pure so only the data in the dimensions needs to be in french and in english. Up to now the query tool is Oracle Discoverer. Anybody has done this ? = Stéphane Paquette DBA Oracle, consultant entrepôt de

Re: Oracle database users

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 14:40 Hi Pruthvi, Actually speacking , the limit should be the No. of USER Licences purchased for yr Oracle s/w. but Oracle allows to exceed that number. and what if

RE: RAM Disks, redo logs, and beer

Walt, The SDS guys have a few neat utilities that'll help you decide what your hot files are...with some DBA magic, you can figure out what your hot tables in those files are. Make a new, small hot tablespace, and put it on the ramdisk. And yes, with all the failsafes built into the

RE: what is the fastest way to update a big table with more than

When you create the new table with char(8), I would use varchar2(8) but, do a trim when inserting into the new table because in your old table since it is char(255) it is blank padded so you are trying to put length of 255 into a length of 8. HTH Rick -Original Message- Sent: Wednesday,

Oracle on NT startup question - SOLVED

Thanks a lot to all who replied !!! -Original Message- Sent: Wednesday, October 31, 2001 3:20 PM To: Multiple recipients of list ORACLE-L Try to set registry entry ORA_%SID%_AUTOSTART to FALSE in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME Igor Neyman, OCP DBA [EMAIL PROTECTED] -

Re:RE: Oracle Browser 2

David, OK, first off the Oracle sales droid and pre-sales droid came in to do the install of the product (9iAS Enterprise Edition which BTW, you HAVE to have the Enterprise edition or else you don't get the WEB based tool). The install manual said it would need 6GB of HP-UX disk to install

Re: Oracle database users

Yes thanks for the reply. I need to create database users in the oracle database. These users will be used as login for my application. I wanted to know how many i can create Pruthvi - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday,

Re: what is the fastest way to update a big table with more than

You'd be better of, having both: join.totid and cs.totid - as varchar2(255). Thus, you will not have to use trim(). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 8:50 AM thanks

Re: what is the fastest way to update a big table with more than 50000 rows and 20 columns

if i don't use trim, my program can't compare those two totids since one of them is char 255 and the other varchar2 255. In both case without using trim it can't find any totid values (e.g : i am testin with the folowing sql: select * from join where totid='00037201'; and i am gettitng (no

Re: what is the fastest way to update a big table with more than 50000 rows and 20 columns

not all of them, nearly 16000 rows have the same totid now i am trying to get rid of that trim(). thanks for any help cheers :) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 9:45 PM 5 rows and 20 columns are all

UTF8

Hi, We are currently using NVARCHAR2 datatype to store our unicode data. We were told that if we use database character set as UTF8 then we can unicode data in varchar2 columns and can avoid NVARCHAR2 datatype as we have some application issues with using NVARCHAR. Is this true that we can

how to enable FGAC ?

Hi I want to implement Fine-grained access control feature in my database. i run select * from v_$option and see in my database Fine-grained access control is having value false.Let me know how to enable this feature at Database end? Thanks Seema

Stored Procedures Question

I received the DDL SQL script (approx. 11,000 lines of code) to generate a database from our other office in Malaysia. Along with this script I got another file with approx. 720 files called stored procedures with the suffix .PRC, .PKB, .PKS, .FNC. AND .TRG. When I go to generate the DB using

RE: RAM Disks, redo logs, and beer

Thanks for the info, Ross. We have a tablespace set up on the RAM disk, we know what the hot files are, and we've moved some of'em to the RAM disk (it's not big enough to move all of'em there). Now we're just gonna sit back and watch all the great performance stats roll in. :) FWIW, the SQL is

Re: UTF8

It is true. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 11:15 AM Hi, We are currently using NVARCHAR2 datatype to store our unicode data. We were told that if we use

Re: UTF8

Yes, I have it and no problem. JP On Wed 31. October 2001 17:15, you wrote: Hi, We are currently using NVARCHAR2 datatype to store our unicode data. We were told that if we use database character set as UTF8 then we can unicode data in varchar2 columns and can avoid NVARCHAR2 datatype as we

RE: how to enable FGAC ?

Seema, FGAC, which is supported by the supplied PL/SQL package DBMS_RLS (Row Level Security), is only available in Oracle8i Enterprise Edition. Even if you just have Standard Edition, you can get a lot of similar benefit by using Application Context, which you would need to use anyway to

RE: Stored Procedures Question

Ken, To see exactly how the stored procedure files will be used, you'll need to examine the DDL script to find out how they're called. That might tell you which directory in which to put them. If you have to run them manually, do it after the DDL script finishes. Execute (from SQL*Plus) all

RE: RAM Disks, redo logs, and beer

Walt, Could you please let the list know about your results? I tried RAM disk on an NT system to see if we could improve batch processing throughput. It was a miserable failure - it made no difference at all. Our conclusion at the time was that Oracle was doing everything it could to maximize

RE: RAM Disks, redo logs, and beer

Hey Walt, How about using the RAMDISK on your gaming pc. I'll bet it would scream. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4

Robert, Maybe, maybe not. If someone on this list can give me a lead to a position in northern Colorado, then the extra exposure would be more than welcome. I was laid off a couple of weeks ago and I'm finding DBA jobs in this area hard to come by which is a completely different situation

Messy Messy SQL

I've been asked to review some troublesome SQL queries, and since I don't know what to do with this one, I thought I'd see what you all can come up with. They are doing the following: select A.value 1, C.value2, A.value3 from Table A, Table B, Table C where A.id = B.id and B.id = C.id and

Oracle Licensing Scheme

I can't seem to find anything clear on licensing rates at Oracle's site anymore. Maybe it's my eyes, but I just couldn't find it. Only thing I saw was their claim that they have now changed their licensing scheme to user and cpu units but I wanted the the rates. I need to know, besides (or

Re: Messy Messy SQL

Jeff, That's a pretty silly way to store zip codes. Could you create a zipcode-id table, where you break out each zip and its id? Then search that table and join back to table a? Or, if you're at 8i, and if you only get up to a really small number (like the 3 you display) of zips in a combined

FW: Problem with DBMS_SQL - Long and probably annoying

Thanks to those who replied. Of course the answer was simple but for some reason I thought the code was right in the whole quote thing. I did need to have quotes get passed in on the third and forth parameter. I plan on rewriting the code anyway as I have not found a single reason as to

RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4

Similar situation here. I was on the layoff list at my company when I'm the only Oracle guy and Unix guy in the whole company. Upper management is making some poor business decisions here. I managed to survive but they had to bring back all the accountants they laid off. This place is nuts! I

(Fwd) [oracle-l-OT] New file uploaded to oracle-l-ot [1989 denormalization]

Jared folks, follow up on the 1989 article in _Database Programming and Design_ magazine by Ulka Rodgers. I did a graphic file scan: http://groups.yahoo.com/group/oracle-l-ot/files/UlkaRodgersDenormalization The ERDs should be better than the fax version. brgrds, ep --- Forwarded

Re: Messy Messy SQL

Thanks - I was thinking about breaking it out as well, but thought there might be some trick out there from SQL For Smarties or something. [EMAIL PROTECTED] 10/31/01 11:37AM Jeff, That's a pretty silly way to store zip codes. Could you create a zipcode-id table, where you break out each zip

Re:Messy Messy SQL

Jeff, First point is to look at the from clause and compare it to the where clause. In your case the driving table is table C but the first portion of the where clause to be evaluated is on table A. On top of that table B is totally useless since you've no useful reference to it. Try

DATABASE CREATION SCRIPT

Hi, We will appreciate if someone can send a script that can be used to creata a oracle database on unix . We need to give these script as batch file to developer so that they can create database. Oracle version is 8.1.7 OS sun solaris 2.8 Thanks -Harvinder -- Please see the official

Re: Oracle Licensing Scheme

George: I'm not a sales guy, so I would definitely talk to Oracle for the most current pricing/configuration info (as well as discounts). However, as of the 10/19/2001 price list, the costs are $15K/CPU for Standard Edition and $40K/CPU for Enterprise Edition. The named user licenses for the

RE: DATABASE CREATION SCRIPT

Just run the dbassist program and have it save off to a file instead of executing it. I am of course, assuming you have oracle installed since you are going to be creating a database. -Original Message- Sent: Wednesday, October 31, 2001 10:55 AM To: Multiple recipients of list ORACLE-L

Oracle Financials DBAs Needed Boston area..

Great company that is headquartered in the Boston area, has a need for several Mid and Sr. level Oracle Financials DBAs * Candidates outside Massachusetts can be considered but no relocation assistance is provided. However, in addition to excellent benefits, the company offers a lucrative

Re:DATABASE CREATION SCRIPT

My initial reaction is: Since when do developers create database instances! If you as the DBA are not doing that job, what use are you? Dick Goulet Reply Separator Author: Harvinder Singh [EMAIL PROTECTED] Date: 10/31/2001 10:55 AM Hi, We will

RE: DATABASE CREATION SCRIPT

Here's mine. The sid is obviously EST. The will need to create the init.ora file first and you may want to add redo log mirrors. _ #!/bin/sh # Be sure $ORACLE_HOME is defined. # Define Instance ORACLE_SID=EST export ORACLE_SID # Use sqlplus (svrmgrl being phased out in

RE: Oracle 7 documentation - Good One

Are you sure? I wasted time trying to find some minor documentation (platform specific release notes?) there a while ago, and after complaining that I couldn't find it, others said everything *isn't* there. Frustrating considering that they have a huge number of CD packs etc that appear to

Re: ORACLE-L Digest -- Volume 2001, Number 304

sorta like: Denormalize *THIS* ORACLE-L Digest -- Volume 2001, Number 304 -- From: Farnsworth, Dave [EMAIL PROTECTED] Date: Tue, 30 Oct 2001 06:28:21 -0600 Subject: RE: Spam - Re: Oracle Training from InterTrain Be sure to add them to the OT list for some

RE: Oracle Licensing Scheme

George - To clarify your other question, one reason Oracle developed CPU pricing was for Internet access. This way you don't need to worry about how many people on the planet will be accessing your database. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent:

RE: Oracle 7 documentation - Good One

no offense.. just a sincere question. are people still using o7 out there? talking to oracle support regarding ECS must a be real pain in the butt as i guess they might have stopped supplying patches for o7. in our shop people are jittery continuing on 816 as its de-supported from TODAY

Arch configuration -- I/O stuck

Hi list, Oracle 7.3.4 HP-UX log_archive_buffer_size=32 (redo log blocks = 1K) log_archive_buffers=4 Filesystem based (no direct I/O) I've been detecting that my box gets stucked eventually for some time. When this happens I can't do even a ls (it actually executes it but it takes

RE: DATABASE CREATION SCRIPT

Title: RE: DATABASE CREATION SCRIPT -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] We will appreciate if someone can send a script that can be used to creata a oracle database on unix . We need to give these script as batch file to developer so that they

Re: ORACLE-L Digest -- Volume 2001, Number 304

HELP ORACLE-L Digest -- Volume 2001, Number 304 -- From: Mohan, Ross [EMAIL PROTECTED] Date: Tue, 30 Oct 2001 15:27:13 -0500 Subject: RE: ORACLE-L Digest -- Volume 2001, Number 303 Makes me wonder if they're full of shit, I think Eric meant to say. --

Re: ORACLE-L Digest -- Volume 2001, Number 304

Eric D. Pierce wrote: HELP summer help, and some are no help at all. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You

RE: RE: Oracle Browser 2

Wow. Thanks for your effort here Dick. Sounds like quite an ordeal. At least I'll know some problems to look for if my company decides to try Discoverer! David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919)

RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4

Upper management is making some poor business decisions here. HA! You should see it here... Patrick === Patrick Housholder Sr. Staff Engr Sim Fleet. United Airlines Flight Training Center Denver CO *-Original Message- *From: [EMAIL PROTECTED]

Re: Oracle 7 documentation - Good One

Deepak Thapliyal wrote: no offense.. just a sincere question. are people still using o7 out there? talking to oracle support regarding ECS must a be real pain in the butt as i guess they might have stopped supplying patches for o7. yup, we're still using it, even have one running 7.2.2. and

RE: Oracle 7 documentation - Good One

Deepak, We use Oracle 7.3.4 for Novell. It is stable, works for what is currently needed, and I still pay the support cost as a just incase protection. I have not had any updates in 3 years or troubles either. We are testing 8.1.7 on Linux as a preliminary step to new database when we migrate

RE: Oracle 7 documentation - Good One

Deepak, There are still a lot of sites out there using Oracle Apps 10.7 which uses 7.3.4 as the backend. Although one could migrate to 8.1.7 at the backend and retain the 10.7 frontend until July 2003, officially 7.3.4 when used in this config will still be 'supported' - without ECS though.

UNIX Shell to monitor redo log space

Before I start creating a 'NEW' script, does anyone have a shell script (and willing to share) that will monitor redo log space and when it fills to a certain level will issue the 'Alter System Archive Log To 'xxx' command in order not to have the instance become quiescent. TIA Al Rusnak

RE: Oracle 7 documentation - Good One

Title: RE: Oracle 7 documentation - Good One Deepak, My main shop is almost all 7.x. The reason is all the Oracle bases are being replaced with sqlserver and they didn't want to go through the pain for bases that won't be here much longer. They are now going to 8.1.7 with what's left

RE: Oracle 7 documentation - Good One

I have 7.3.4 databases that we have no intention of upgrading. and 8.1.6 databases that I wille eventually get around to upgrading. --- Deepak Thapliyal [EMAIL PROTECTED] wrote: no offense.. just a sincere question. are people still using o7 out there? talking to oracle support regarding

RE: Oracle 7 documentation - Good One

I still have one database running Oracle7. No choice though. Its actually causing me a lot of trouble due to one bug and well, the vendor app is horrible but its ok. We are replacing it with a new and improved version that needs 10.20 and Oracle 8.0.5. Yah for improvements:-( Oh yeah, if I

Re: Synonyms can be VERY bad for performance

Because we were in first_rows, queries against the data dictionary were optimized in first_rows mode rather than rule. This was despite us not having any statistics on system or sys objects. Is this standard behavior? What about the warnings not to analyze SYS because it's optimized for

Re:RE: RE: Oracle Browser 2

David, In it's current incarnation I'd recommend against it. Dick Goulet Reply Separator Author: David Wagoner [EMAIL PROTECTED] Date: 10/31/2001 12:05 PM Wow. Thanks for your effort here Dick. Sounds like quite an ordeal. At least I'll

Re: Messy Messy SQL

It would be easy to get the values if they were all like the first format, because I could use 'substr(A.zips,1,5) = '55514'' The substr() would still cause the index to not be used. But if they were all in this format you could eliminate the leading % wildcard character, and as you mention

RE: Oracle 7 documentation - Good One

Yeah, we still have a server on 7.1.3, mostly because we have some C reports, and the C compiler has changed enough in 8 to require that we would have to rewrite them, which we don't have the budget for. At 11:55 AM 10/31/01 -0800, you wrote: no offense.. just a sincere question. are people

RE: RE: RE: Oracle Browser 2

Discoverer did what it was supposed to do . but it did it in a VERY UGLY MANNER. You should have seen the Crap SQL it returned for its queries... I would have expected a product written BY ORALCE FOR ORACLE to be written in such a way that it returned the best SQL that could be generated.

RE: Java in the database

Jared, How many of 2.5 mln pages per hour are actually generated by Perl vs. are just static pages? I use Perl too (http://www.bbgunstore.com -- my creation :-) takes about 5 mln pages a month) but it does not scale as well as EJB, COM+, etc... Just curious... Thanks, Val Gamerman.

Backing up a database on WindowsNT

I have two databases on Windows NT that are Oracle 8.1.7. ArcService is the method of backup for our NT Servers. We installed the Oracle Agent for backing up the database as I do not have space to copy it to disk first. One of the features we are using in the database is tempfile's with

11.5.4 Easy Question (?)

Friends -- Our pesky users are having problems logging on from the Web front end of Oracle Financials. This was working just fine 10/25 when the last pesky user successfully logged in. Since then, the box (Tru64 v5.1) has been bounced, and we have started the following scripts successfully...

Re:RE: Oracle 7 documentation - Good One

Regina, Are those reports written with OCI or Pro*C? We had a miserable time with some of our machine control programs because those engineers used OCI. On the other hand those of us who used Pro*C had it very easy. Dick Goulet Reply Separator

RE: 11.5.4 Easy Question (?)

What exactly happens? What is the problem? Anything in the log files for Oracle, listener, OS, Apache? -Original Message- Sent: Wednesday, October 31, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Friends -- Our pesky users are having problems logging on from the Web front end

Re: Stored Procedures Question

Stored procedures will most typically be used by an application that uses the database. If the application does not use them explicitly, then there is most likely implicit use via triggers (ie triggers call procedure etc) hth connor --- Ken Janusz [EMAIL PROTECTED] wrote: I received the DDL

Re: how to enable FGAC ?

Do you have standard or enterprise edition of Oracle ? hth connor --- Seema Singh [EMAIL PROTECTED] wrote: Hi I want to implement Fine-grained access control feature in my database. i run select * from v_$option and see in my database Fine-grained access control is having value

RE: 11.5.4 Easy Question (?)

The error is that the database login failed. There is nothing in the bdump alert log of any interest and no entries whatsoever in the tns alert log or in $APPLLOG. No clue where to look for Apache stuff... Bambi. -Original Message- Sent: Wednesday, October 31, 2001 4:41 PM To:

RE: 11.5.4 Easy Question (?)

Bambi, Have passwords been changed on the Apps side, but not in the config files? Apps is notorious for hard coding passwords in a variety of files Can you check the wdbsvr.app under $APACHE_TOP/modplsql/cfg? Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen

RE: 11.5.4 Easy Question (?)

search ML on db hang states they recommend taking system and process state dumps in such situations. did not work in our case one time where we had a situation where even internal connection was refused. no freakin error in alert or bdump. finally ended up having to kill pmon and other oracle

RE: Value of bind variables in tkprof

Mike - Haven't used this, so I will be interested in how you come out. If you set trace level to 4 or 12, as in alter system set timed_statistics = true alter session set events '10046 trace name context forever, level 4' Then the trace file that is produced should have your bind values. I'm

  1   2   >