oracle internet directory

Hi! Does anybody out there have any experience with the setup and implementation of Oracle Internet Directory in a 9.2 environment? This is 9.2 on HP-UX 11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL PROTECTED]

RE: How to drop a datafile ?

I don't beelive you can drop a datafile from a tablespace, you have to drop the tablespace, just reaize the datafile to 1M if space is the problem Regards From: Prem Khanna J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE:

Re: RE: How to drop a datafile ?

Thanx craig. but is there no way of dropping a datafile then ? Regards, Jp. 29-10-2003 18:24:25, Craig Richards wrote: I don't beelive you can drop a datafile from a tablespace, you have to drop the tablespace, just reaize the datafile to 1M if space is the problem Regards --

RE: How to drop a datafile ?

Hi, How about do these: 1. Create new tablespace 2. Move all objects from Old tablespace to new tablespace 3. drop old tablespace and delete the files 4. recreate the old tablespace with correct datafiles size 5. move all objects from new tablespace to redesign old tablespace 6. drop new

9i RAC on AIX 5L

Hi, Oracle 9.2.0.3 AIX 5L Anyone out there suffered serious performance issues with sorts to disk on this platform. we are using GPFS filesystems. The same query took about 16 minutes on a 8.1.7 database running on a small Tru/64 machine, the query on the p650/9.2.0.3 machine took over 6 hours

Date-based query Q

This is probably a no-brainer... We have some date-based data for which most days have several records but where some days have none. I'm COUNT()ing the number of records for each day (between day x and day y) and need a record set that also includes a row for those days which have no records:

Re: How to drop a datafile ?

The doc is right. You cannot drop a single datafile from a tablespace. --- Prem Khanna J [EMAIL PROTECTED] wrote: Guys, it's oracle 9.2.0.3/Win2K. say for some reason (NOT recovery): i want to drop a datafile from a tablespace which has more than 1 datafile.how to do it ? Doc 111316.1

Re: How to drop a datafile ?

Thanx Sinardy Rachel. so,the only way is as what Sinardy said. is that so ? Regards, Jp. 29-10-2003 19:44:25, Rachel Carmichael [EMAIL PROTECTED] wrote: The doc is right. You cannot drop a single datafile from a tablespace. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: Date-based query Q

You colud try joining to an in-line view something like SELECT :XDATE+(ROWNUM-1) DDATE FROM DBA_OBJECTS WHERE ROWNUM = (:YDATE - :xdate)+1 where dba_objects could be any table with enough rows to ensure you always covered the complete range. -Original Message- Aidan Whitehall Sent:

Re: How to drop a datafile ?

export the data (make sure you get all the data) drop the tablespace and recreate it import the data --- Prem Khanna J [EMAIL PROTECTED] wrote: Thanx Sinardy Rachel. so,the only way is as what Sinardy said. is that so ? Regards, Jp. 29-10-2003 19:44:25, Rachel Carmichael [EMAIL

dbms_system.ksdwrt

Hi everyone, Does anyone know if this previously undocumented procedure and its associates for outputting timestamp etc were available on Oracle 7. I have searched and could not find any indications soundly for or against this. I do not have access to 7.3.4 at present to check myself. I need to

RE: How to drop a datafile ?

Well, you an actually move all your objects from this datafile into a different datafile (read it as different TS) and then offline drop the datafile. This will ensure that users don't get the error 'xxx.dbf file is currently inacessible' message. Cheers! Venu -Original Message- Prem

Re: Date-based query Q

Hello Aidan, I ran into a similar situation once, except that I needed a row not for every day, but for every month. My solution at that time was, in fact, to create a table with a row for each month for the next hundred years (only 1200 rows). I also wrote (and documented) a small program to

Re: Re: How to drop a datafile ?

if you have a tablespace with 10 datafiles. can you drop just one datafile? From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/10/29 Wed AM 08:04:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: How to drop a datafile ? export the data (make sure you get

Re: Re: How to drop a datafile ?

disregard my question. i saw it in an earlier post. sorry i have several hundred emails this morning. i missed it. From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/10/29 Wed AM 08:04:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: How to drop a datafile ?

RE: Re: How to drop a datafile ?

Just to reiterate what Rachel has already said (further down the page in your own email) . The doc is right. You cannot drop a single datafile from a tablespace -Original Message- Sent: 29 October 2003 13:14 To: Multiple recipients of list ORACLE-L if you have a tablespace with 10

Re: 9i RAC on AIX 5L

Hi, Question: did you note much I/O when running the sort ??. In AIX it's usefull to make some modifications in paging space behavior in order to reduce I/O contention ad let the ORACLE SGA be in main memory instead on paging space. Try this: Apply the latest Maintenance Level of AIX 5 Take

RE: 9i RAC on AIX 5L

--_=_NextPart_001_01C39E23.C16EC754 Content-Type: text/plain Thanks, Lots of IO but our S.As assure me (alongwith IBM themselves) that everything is set up correctly Regards Lee -Original Message- Sent: 29 October 2003 13:44 To: Multiple recipients of list ORACLE-L Hi,

RE: 9I RAC corporate standard.

9iRAC on Tru64 is a breeze. And Tru64 is True Cluster File System. One of the diminishing breed of people still upgrading databases on Tru64 ! Hemant At 03:39 PM 28-10-03 -0800, you wrote: Well, we evaluated 9iRAC on some cheap-o Linux boxes as a proof-of-concept, with the hardware idea based on

RE: dynamic sql problem

Thanks for all those who answered Using authid current_user in package has solved my problem. With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) # : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]

RE: RE: Date-based query Q

Same idea as what Iain suggests, dreadful implementation : SQL select trunc(ukdate) ukdate, count(*) from test 2 group by trunc(ukdate); UKDATE COUNT(*) -- -- 01/01/2003 5 02/01/2003 6 04/01/2003 6 SQL get x 1 select y.full_ukdate ukdate,

Re: Refresh option for Materialized view , want to use it during refresh - for

Thanks, Arup. Your advice is always good. David From: Arup Nanda [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Refresh option for Materialized view , want to use it during refresh - for Date: Tue, 28 Oct 2003 12:09:25

SQL and PL/SQL tuning template document required urgently

Hi there, Does any body have a template for proactive and reactive query tuning which can be used as a guideline/report while tuning simple, medium complex and complex SQL queries and PL/SQL stored procedures? If so, can you please forward the same to me please? If not, can anybody

RE: SQL and PL/SQL tuning template document required urgently

How about: http://www.oreilly.com/catalog/orsqltunpr/ Oracle SQL Tuning Pocket Reference, by one of our esteemed partners - Mark Gurry. Mark -Original Message- Ranganath K Sent: 29 October 2003 14:24 To: Multiple recipients of list ORACLE-L Hi there, Does any body have a

RE: 9I RAC corporate standard.Jamadagni, Rajendra [Rajendra.Jamadagni@espn.com]

What hardware did you get 9Irac running on? Thanks Raj, Brian Spears Database Services [EMAIL PROTECTED] DC4 (614)577-2677 DC3 (614)415-1398 Limitedbrands TECHNOLOGY SERVICES -Original Message- Jamadagni, Rajendra Sent: Tuesday, October 28, 2003 9:39 PM To: Multiple recipients

RE: oracle internet directory

Helmut, I suppose I have experience, not good, since I am currently trying to implement it as a test on out test server which is 9.2.0.4 on HP-UX 11. I played with OID v2 (Oracle 8i) and gave up and despite getting OID v3 setup and working, I decided to tidy up the multiple Oracle Contexts I

Re: Clone db 9.2 on AIX 5L

I did it yesterday on AIX 5L 9.2.0.4, no problem at all Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: RE: Date-based query Q

How about this? SELECT col_date, SUM(COUNT) FROM ( SELECT ukdate, COUNT(*) COUNT FROM tomtest GROUP BY ukdate UNION SELECT ADD_MONTHS(TO_DATE('12012002','mmdd'),ROWNUM) dba_month,0 FROM DBA_OBJECTS WHERE ROWNUM 13) GROUP BY ukdate Tom Mercadante Oracle Certified

Re: SQL and PL/SQL tuning template document required urgently

the only book out there that is any good is High Performance Tuning by Guy Harrison. Ignore the part where he says that a cursor with an update in the loop can be faster than using an update with where exists. That is inaccurate. the rest is solid. unforunately its not that simple. How you

64-bit LInux

Anybody used 64 bit linux? Can you send me your hardware specs? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jerome Roa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

8.0.5 standard edition

By any chance does anyone know where I can download this?? Long story but I need to downgrade a database from 8.0.5 enterprise to standard edition. The admins can't find the standard CD. I have been looking on oracles site but have not found it yet. I guess I wouldn't expect to since it is

When would we see optimizer_mode=NONE in V$SQLAREA ?

I noticed in an 9.2 instance that a number of entries in V$SQL, V$SQLAREA showed up with OPTIMIZER_MODE=NONE [there were others with CHOOSE] I can understand that it might be NONE if someone has done an ANALYZE or DBMS_STATS or executed DDL and the SQLs are invalidated. But do you normally

RE: comparison HP-san vs netapp

Dick, Mathew Thanks for your responses. It helped making clear our choice in convincing mng We will go for an HP-Eva3000 san solution. We have only a 100Mb network and this makes clear for all cost-minded people we have to make additional investments such that a netapp solution is

RE: Re: SQL and PL/SQL tuning template document required urgently

Ryan, 'can be faster' is rarely inaccurate. It all depends. SF - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 29 Oct 2003 06:49:33 the only book out there that is any good is High Performance Tuning

RE: dba interview questions

What was all of that about swallows, anyway? And Bambi, didn't your last name formerly end with an s? It's great to have you back on the list, in any event. --- Bellow, Bambi [EMAIL PROTECTED] wrote: Kirti -- I've had that experience too. I generally start a telephone interview hopping

RE: oracle internet directory

I have OID (with replication) up and running smoothly on Windows 2000 / Oracle 9.2.0.4. Of course, I've forgotten how I did it, but your questions may jog my memory. -Original Message- Sent: 29 October 2003 08:19 To: Multiple recipients of list ORACLE-L Hi! Does anybody out

RE: SQL and PL/SQL tuning template document required urgently

Ranganath Since you mentioned proactive and reactive query tuning, I think the philosophy with which one approaches the tuning exercise means everything. Wrong philosophy and you spend your time spinning your wheels. All of us have only a limited amount of time to devote, so the best approach

RE: 9I RAC corporate standard.

I couldn't agree more, after the pains of an initial install (i.e. steep learning curve), I was able to create/re-create a test environment in 1-2 days. That included moving hardware around, setting up the SAN, installing the O/S, patching it, installing 9.2.0.1 rac, then patching that to

sqlplus prompt question in 9i

Hi: With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and added set termout off col site_name noprint new_value site_name_new select 'SQL ' site_name from dual; selectuser || substr(proc.program, instr(proc.program,'@'), instr(proc.program,' ')

RE: Perm job opening in MA

LOL! Mladen, I think you are missed on off-topic list -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Tuesday, October 28, 2003 8:54 PM To: Multiple recipients of list ORACLE-L Don't get me wrong, I've recently changed positions and am not interested,

Re: oracle internet directory

Hi Helmut: I have setup and configured OID for 8.1.7, 9.0.1.4 and 9.2.0.4. Also had to do a conversion from 8.1.7 to 9.2.0.4. The conversion was a real nightmare. Major bug with the bulkload.sh. If you need it I have a step by step conversion doc. Everything I have done has been on AIX

RE: ** database configuration assistant scripts

Jacques, Yes. Thank you.Please send the scripts for both versions. You can send them to me directly or to the list. Your help is greatly apreciated. Jacques Kilchoer [EMAIL PROTECTED] wrote: If you're interested I can send you the sample batch files and scripts I use to create databases on

Re: sqlplus prompt question in 9i

You could just use login.sql instead, on a per user basis. If you don't want login.sql to be used, just edit or unset SQLPATH. Maybe other options available for this in 9i. A perusal of the sqlplus manual may prove useful. Jared Guang Mei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: RE: SQL and PL/SQL tuning template document required urgently

the original poster sent me an email stating that he doesnt want a book or documentation, he just wants some sort of short cut template. i replied that if one exists its garbage. He didnt respond. A side note, it seems to be in vogue to recommend advanced books like carrie millsap's and tom

Re: dbms_system.ksdwrt

Yes, it works on 7.3.4, tested it just now. Jared Pete Finnigan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/29/2003 05:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:dbms_system.ksdwrt Hi

Re: RE: Perm job opening in MA

it means you need to be able to handle stupid questions without losing your temper. the best people to ask on this are the hardware support guys. They get the true 'gems', when it comes to stupid questions. They should provide training to oracle dba's on the topic. I was at a conference

RE: How to drop a datafile ?

That won't actually do what you're implying. Checking the docs would prove helpful. From the SQL ref: If the database is in NOARCHIVELOG mode, you must specify the DROP clause to take a datafile offline. However, the DROP clause does not remove the datafile from the database. To do that, you

Re: sqlplus prompt question in 9i

As a further FYI- We do not allow anything to be placed in glogin.sql. It can screw up anything supplied by oracle, ie, upgrade scripts. A local login.sql is the best way to go. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. --

rewriting query without using UNION

Hi, I wonder if there's a better way of writing the query below. Basically, I would like to return employee records where employee name='JOSE' + all employees in deptno=50. My query can have multiple 'OR' criterias where the next criteria maybe returning all employees with salary6 in

Re: RE: Perm job opening in MA

On 10/29/2003 12:29:35 PM, [EMAIL PROTECTED] wrote: I was at a conference resently and I saw a video of a performance analyst helping a client. The performance analyst grabbed the keyboard and beat the client senseless. not exactly the kind of solution they are looking for... It's

RE: RE: SQL and PL/SQL tuning template document required urgently

Ryan - Thanks for updating us on the status with the user. As to what we recommend to novice users, as a practical matter, unless the poster makes their experience or lack thereof clear, I just have to make an assumption. In this case, since the poster was talking about guidelines and templates,

RE: Date-based query Q

Thanks for everyone's help with this one, btw. In the end I bit the bullet and added a dates table. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards

Re: Perm job opening in MA

ha ha ha ha ha ha ha ;) -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 5:54 PM Don't get me wrong, I've recently changed positions and am not interested, but what are phone skills? I know how to use a phone, and I

Automatic Undo Management Memory management in 9i

Fellow Listers, Could you please share your experience with Automatic Undo Management and Automatic Memory Management. Would you recommend it? One of the Sr. DBAs here suggested not to implement automatic memory management in 9.2.0.3 but wants to implement it in 9.2.0.4. His suggestion that

RE: Clone db 9.2 on AIX 5L

Thankyou all who have responded to this... as it turns out the parameters for shared_pool /large_pool were to large for the receiving machine after I decreased the values to a minimal size I was able to recreate the instance. Thanks again John -Original Message- Joan Hsieh Sent:

Re: RE: SQL and PL/SQL tuning template document required urgently

Neither Tom Kyte's nor Cary Millsap's books are too advanced for beginners. In the case of Tom's book, they may have to ponder things a bit, and actually try the code for themselves to get a good understanding. So what? That's how you learn. Regarding Cary's book, what's so hard about it?

Re: rewriting query without using UNION

I don't see why would query with multiple unions necessarily degrade performance, but here is another way for writing your query: select e.id, e.name, d.deptname from emp e, dept d where e.deptno=d.deptno and ( e.name='JOSE' or d.deptno=50) / That would be a union of all employees from the

RE: RE: SQL and PL/SQL tuning template document required urgently

i guess i jumped to conclusions, but i took it from the level of his questions. 'basic template' = looking for shortcut = what people look for when they are new to something and want to get started quick = not always a bad idea. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/10/29 Wed

Re: rewriting query without using UNION

from basic set theory: union = OR intersect = AND select e.id, e.name, d.deptname from emp e, dept d where e.deptno=d.deptno and e.name='JOSE' or d.deptno = 50; From: Linda Wang [EMAIL PROTECTED] Date: 2003/10/29 Wed PM 12:54:26 EST To: Multiple recipients of list ORACLE-L [EMAIL

RE: rewriting query without using UNION

select e.ID, e.NAME, d.DEPTNAME from EMP e, DEPT d where e.DEPTNO = d.DEPTNO and (e.NAME = 'JOSE' or d.DEPTNO = 50); -Original Message- Sent: Wednesday, October 29, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Hi, I wonder if there's a

RE: RE: Perm job opening in MA

Title: RE: RE: Perm job opening in MA Ryan, Thank you for that accurate explanation as to what excellent phone skills are. I just got to my email and have not had a chance to respond. I appreciate your assistance. Regards, John -Original Message- From: [EMAIL PROTECTED]

2G trace files

I'm tracing a session with 10046 event level 8. Here's the method I use: sys.dbms_system.set_sql_trace_in_session( p_sid, p_serial#, TRUE ); sys.dbms_system.set_bool_param_in_session(p_sid, p_serial#, 'timed_statistics', true); /* Max dump file size is 2G */

RE: RE: SQL and PL/SQL tuning template document required urgently

The biggest problem I have with Cary's (and Jeff's!) book is patience. There's constant mention of which I'll show you in Chapter 6 and so forth and it pains me to keep on reading from where I am so's I don't get too distracted and forget the important concepts I was just reading. :) I also have

Re: ** database configuration assistant scripts

When creating a custom database, DBCA has an option to save the database creation scripts. Have Fun :) A Joshi wrote: Hi, I am using database configuration assistant to create a NT database. Is there a way I can get the scripts used in the creation? I clicked on the template but do not

RE: 2G trace files

set mdfs=unlimited Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original

Re: 2G trace files

Sounds like an OS limit. What OS is this on? Quintin, Richard [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/29/2003 10:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:2G trace files I'm tracing a

RE: RE: SQL and PL/SQL tuning template document required urgently

As an author, let me just add that it pains US to have to say which I'll show you in ... Books are laid out in some sort of order although readers don't always read from chapter 1 straight through to the end. If we were to go off on every tangent so as not to say see such and thus later, a

Re[3]: SQL and PL/SQL tuning template document required urgently

Wednesday, October 29, 2003, 12:59:34 PM, you wrote: DWSams Publishing puts a User Level rating on their books. Maybe we DW should ask O'Reilly to do the same. How about that Jonathan? I don't know that we've ever thought of doing that, and I think the practice would be frought with problems.

RE: RE: Perm job opening in MA

for a fair contracting rate, I could offer training? since Im apparently a renowned expert on the subject. From: John Spencer [EMAIL PROTECTED] Date: 2003/10/29 Wed PM 01:44:33 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Perm job opening in MA Ryan,

Re: RE: SQL and PL/SQL tuning template document required urgently

jared you have been doing this for what 10-15 years now? take someone with little to know background in this field and little to no technical experience. tom kytes book is rough and dense from their perspective. soemtimes people forget how far removed they are from the true beginner. There is

RE: 2G trace files

Set the dump file size to unlimited. -Original Message- Sent: Wednesday, October 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L I'm tracing a session with 10046 event level 8. Here's the method I use: sys.dbms_system.set_sql_trace_in_session( p_sid, p_serial#, TRUE );

ORA-4031 error help.

Hello List, Need some help in resolving ORA-4031 error message. We are using Lawson and for last few days users are getting ORA-4031 error 2-3 times a day in LAWSON log files but there is no error message in alert log file or any trace file. Both shared pool and large pool is set to 1GB. Below

Re: 2G trace files

Richard, Are you sure that you are targeting your diagnostic efforts appropriately? If all users are using dedicated servers, then each trace file should only have the info for one session. If your interval for a statspack report is an entire week, its going to be pretty tough to find the

Re: 9I RAC corporate standard.

I tried installing RHAS 2.1 ($60 duhveloper edition), but it's so old (based on RH7.2) that it couldn't identify our newish hardware (Intel D845 MB). Just for the record, Redhat Enterprise Linux 3 is available now. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Re: RE: Perm job opening in MA

In case there is doubt, I was just kidding. Please, don't make me feel guilty. I picked on the excellent phone skills because phone is such a ubiquitous device that everybody knows how to use it. Actually, in my 42 years of walking through this valley of tears, I cannot recollect ever meeting

Re: ORA-4031 error help.

Well, you neet to check the full error, because otherwise there's no way to tell if you are running low on shared or large pool. The view that shows space usage in both places in v$sgastat. I suggest you start looking there. Maybe your third-party application doesn't use bind variables and is

Re: RE: SQL and PL/SQL tuning template document required urgently

They really dont know anything and it REALLY is that hard for them. Hence the lies on their resumes. ;) OK, enought cynicism. For now. Maybe it is hard. I guess I just don't agree that they shouldn't just dive in and sink or swim. And yes, I've been doing this a while, but there are still

RE: 2G trace files

If I set max_dump_file_size greater than 2G I get an error. Perhaps I should be more specific: sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 'unlimited'); gives: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Re: 2G trace files

Yes. I'm tracing a single session. What made you think I wasn't? What does statspack have to do with this? 2G is not such a large amount... On Wed, 2003-10-29 at 14:44, Paul Drake wrote: Richard, Are you sure that you are targeting your diagnostic efforts appropriately? If all

bitmap index not used

Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has 7131413 rows, of which 7125290 are null for the column in question, the rest of the rows are unique values. There is a histogram on this column, it has 2 buckets. A select statement using this column in the where clause

Re: dbms_system.ksdwrt

Thanks very much for testing it Jared, Much appreciated Pete In article [EMAIL PROTECTED] disys.com, [EMAIL PROTECTED] writes Yes, it works on 7.3.4, tested it just now. Jared -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists

RE: ORA-4031 error help.

Avnish, 4031 (as well as 0155 and 1652) are considered 'user' errors and will NOT be logged in the alert.log by default. You could add the following into your init.ora to capture them: (Make sure that you keep *all* event lines together, including previous ones in the init file, otherwise only

RE: 9I RAC corporate standard.

H...interesting... http://ftp.redhat.com/pub/redhat/linux/enterprise/3/en/os/i386/SRPMS/ Me and a coworker are pondering rolling our own RHASESLESELSESES3 package for RAC testing... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

Re: bitmap index not used

Which version of the database? Do you have any special setup? Any optimizer parameters on either session or system level? On 10/29/2003 03:09:39 PM, Josh Collier wrote: Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has 7131413 rows, of which 7125290 are null for the

RE: ORA-4031 error help.

Full error message is ORA-04031: unable to allocate 4032 bytes of shared memory (large pool,unknown object,session heap,frame segment)) I am already monitoing both shared pool and large pool free memory every 30 minutes and there is no issue with that. As I mentioned below Oracle is not

RE: RE: SQL and PL/SQL tuning template document required urgently

The structure we chose for this thing was that we wanted a marginally technical decision-maker to be able to read Parts I and III without giving up. Therefore, any time there was an opportunity for a technical tangent, the rule was explain it (later) in the reference section. I figured Part II

Re: RE: SQL and PL/SQL tuning template document required urgently

not sure its about sink or swim. I think its more productive for them to start with basic stuff and get grounded in that first. Saves time. Saves frustration and they learn faster. From: [EMAIL PROTECTED] Date: 2003/10/29 Wed PM 02:54:25 EST To: Multiple recipients of list ORACLE-L [EMAIL

RE: RE: SQL and PL/SQL tuning template document required urgently

I tried reading a Harry Potter book backwards once. It was fun, and actually made a bit of sense. --Walt Weaver Bozeman, Montana On Wed, 2003-10-29 at 12:19, Rachel Carmichael wrote: As an author, let me just add that it pains US to have to say which I'll show you in ... Books are

RE: 2G trace files

I believe that is a limitation with that procedure. If you are tracing your own session, use Alter session set max_dump_file_size=unlimited; Otherwise set it at the system level during your trace Alter system set max_dump_file_size=unlimited; If necessary, reset it after your large trace has

Re: sqlplus prompt question in 9i

I had same problem with 9i, what I did is at the begining of the dbstarup or stop script, I mv the glogin.sql to _old, at end of scripts I mv back to the original name. Joan Guang Mei wrote: Hi: With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and added set

Re: 9I RAC corporate standard.

At least it has a decent kernel now coming with it (and probably soon supported by Oracle) - 2.4.21. Pls let me know on your success installing it, I'll probably start experimenting with the 64bit version on couple of Itanium boxes (connected to Symmetrix ;) soon. Tanel. - Original Message

Re: When would we see optimizer_mode=NONE in V$SQLAREA ?

Hi! Yep, when SQL is invalidated, it's optimizer mode goes to "none", as far as I've seen. It's the same with PL/SQL stored procs, when their dependencies change, or when the procedure is loaded but not executed due to incorrect parameter number or types, etc, the optimizer_mode remains

RE: ORA-4031 error help.

Make sure you are pinning your large and often executed packages, triggers, procedures, etc in the shared pool (should be done at startup). That will help eliminate fragmentation. select 'execute dbms_shared_pool.keep('||chr(39)|| owner||'.'||name||chr(39)||','||chr(39)||

RE: bitmap index not used

version 8.1.7.4 optimizer parameters are default. -Original Message- Sent: Wednesday, October 29, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Which version of the database? Do you have any special setup? Any optimizer parameters on either session or system level? On

RE: ORA-4031 error help.

How often does the error occur? How many sessions are connected when the error occurs? What is the status of the shared pool reserved? If you flush the SGA does the error clear for a period? Also, in 8i there used to be a bug that required setting _db_handles_cached=0 Regards, -Daniel --

Re: ** database configuration assistant scripts

Chip, I am not able to find the option. Can you tell in detail. I am doing a custom database creation on NT version 9.2. Thanks for your help.Chip [EMAIL PROTECTED] wrote: When creating a custom database, DBCA has an option to save the database creation scripts.Have Fun :)A Joshi wrote: Hi, I am

RE: 2G trace files - solved...sort of

Thanks to everyone who responded. It turns out initialization parameter max_dump_file_size was set to *20M* and the trace files were getting cut off at that point. I didn't look at the ls closely enough and thought it was getting cut off at 2G. Apparently the init parameter overrides the

Re: ORA-4031 error help.

The standard question would be Have you made any recent changes to code, patches, parameters, etc? But I saw cursor_space_for_time = true in your init.ora and you've increased open_cursors from 500 to 750 few days ago, these can cause excessive memory usage for example. Also, you might want to

RE: ORA-4031 error help.

Do you have cursor_sharing set? Long term : Have the developers use bind variables. Short term identify the sql doing the most damage by looking at sql being reparsed etc. Fix them to use bind variables if possible. About alert.log some errors go to alert.log some errors do not. Do you have

RE: sqlplus prompt question in 9i

Joan: Thanks for the reply. This would work if dbstart is called when starting instance. But if I do it manually (although not often I would say), I need to remember this and do it by hand. Also I think you only need to do it with dbstart script, not dbshut. Guang -Original Message-

  1   2   >