Re: ANALYZE question

Thanks all for your advice. Will check an option to do estimate. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 7:23 PM At the last Open World I attended a couple of sessions where the general advice

Re: where should i start to learn to become a DBA?

Shuan, Welcome. Being a DBA is not rocket science neither is it childs play. Reading, testing, experimenting on a dev instance is the way to go. We all started out at some point like you. We all do it and will continue to do so cos: we tend to forget, newer versions/ patches come out,

Re: Cursor Sharing| Soft Parsing

On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. No, code that uses bind variables need

Re: (memes) not making much headway with critiquing elitist dba

Life is full of paradoxes. On 24 Jul 2002 at 10:33, [EMAIL PROTECTED] wrote: What I cannot understand is why you left the fertilizer industry. Based on your commentary and the state of the economy I suspect demand could not keep up with your supply. Just kidding your posts are quite

Re: Rman duplicating failing when setting redo logs

Hi, U don't give much info,but... Could it be that you are duplicating without untill clause.. If so you may hit bug 2329702. (I did when testing all sorts of RMAN scenarios) There is a workaround but no fix yet

Re: Is Statspack a Security Problem?

Thanks Ian. Have a beer on me, you earned it with this info. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 11:51 PM Ian, You are likely to win the wager on this one. I discovered the public when i

RE: shutdown abort / startup restrict / shutdown vs. shutdown imm

I'm not saying that the shutdown abort *caused* the redo log corruption, but the code that writes redo logs is, like any other software, prone to bugs. Redo logs are only ever read during a recovery of one sort or another, so the code only really gets tested then, and if it fails, there is no

RE: Discoverer 9i: Export data to PDF gives internal error

Hi there! Here is the solution: I wrote there is a new connect window in the background - navigable but not editable. Some light on this ;-) ... I have five Oracle Homes on my PC, because I am testing new releases of Oracle software (e.g. Discoverer 9.0.2). The database connect is well defined

RE: where should i start to learn to become a DBA?

very well said Shuan... u have precisely said what and how ppl should go about the learning process...and as u have mentioned it does not apply to just beginners but experience ppl also.. as knowledge has no endwe have to keep learning and upgrading ourselves... In fact the practical aspect

Problem with Oracle manager for MTS

Hello, We are on Intel pentium 4 windows 2000 SP2 server. We tried to install oracle 8.1.6 client and no thing happened where we clicked on the SETUP button. We applied the patch 1507768 and every thing was okay, we could connect to the database (8.1.7.0 in AIX) via sqlplus. Now when we try to

script related query

Hi all ! I am a Delphi programmer. In our application we can modifying the design of reports at run time, we canput controls etc at run time. Now when we saved the report the setting of controls(includingdatawareness of controls) is saved as CLOB field in database. Next time when report

RE: SMP on windows2000

Thanks. I was thinking of the Oracle executable on Windows2000. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de

ORA-03113: end-of-file on communication channel. HELP !

Hi, We have a Unix user dcclive ( oracle database user ops$dcclive - os authentication ). I am able to connect my database using TNS Alias but not directly. when i start the database in the following way : After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and started the

Hot tables

Title: Message How is everyone identifying hot tables? In my tool box I have the following two scripts but I am looking for other options. How do you track frequently accessed tables? Script #1 - Author unknown: select obj_name, sum(decode(action_name,'SELECT',1,0)) sel

Re: where should i start to learn to become a DBA?

In my case, I was invited to a meeting attended by 6 people. The meeting room had 5 chairs. When the new CIO asked who wants to be the DBA?, I was the only one standing. P.S. I really wanted to be the systems programmer. From: shuan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple

Re: Cursor Sharing

Don, Sounds like you have a VP there who is willing to suffer pain to cure the disease. Many places don't have high-level people like that. Last place I worked I used CURSOR_SHARING=FORCE because the programmers didn't want to code prepared statements (most of the statements were select...

Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000

Title: Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000 Hello Guru's, Any ideas? I have installed Oracle 7.3.4.5.2 (7.3.4.0.0 + patchset 7.3.4.5.2) workgroup onto Windows 2000. Everything appears to have gone well, except that the Listener Service was not created automatically as

RE: where should i start to learn to become a DBA?

Well you started off in the best position for a DBA Martin, looking down on the rest of them :) John -Original Message- Sent: 25 July 2002 14:04 To: Multiple recipients of list ORACLE-L In my case, I was invited to a meeting attended by 6 people. The meeting room had 5 chairs. When

RE: Hot tables

Title: Message FROM METALINK: some quick starters: select disk_reads, sql_text from v$sqlarea where disk_reads 1 order by disk_reads desc; select buffer_gets, sql_text from v$sqlarea where buffer_gets 20 order by buffer_gets desc; Also, look at the following links:

RE: Cursor Sharing| Soft Parsing

Well, three times, right? I think it takes three parse calls before session_cached_cursors begins to help. But 3 is still O(1). Once per call is O(#executions). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database

oracle 9i

Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

AW: where should i start to learn to become a DBA?

Hi Lesson learned: Always bring camping chairs to meetings. Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] visit our website: http://www.bov.de subscribe to our newsletter:

BR solutions

Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce

Oracle Installer not launching in NT

Hi List, I saw a similar post to this in the last 2 weeks, but deleted it (oops) as I am in a unix shop. But I now have a client who is trying to install the oracle client on his nt box in order to demo our *product*. However, he can't get the installer to even launch. He thinks

NLS questions

Title: NLS questions Hi everybody, Ive been asked to incorporate the data from our remote sites in France, Portugal, Switzerland and Sweden into our existing data warehouse in the UK. I expect I'll have characterset and currency issues to deal with, but I've done very little with NLS. Are

RE: Oracle Installer not launching in NT

I had this problem last week. There is a bug when installing Oracle client 8.1.* onto a Pentium 4machine with a processor that is 1500mhz or faster. The workaround is to copy the client cd onto the machine, rename symcjit.dll to something else and then run the setup program from the pc.

RE: oracle 9i

We're doing that and haven't had any problems. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject:oracle 9i Hi All! We will use Oracle 9i db and

oracle failsafe

Looking for some white papers on this subject.

RE: Oracle Installer not launching in NT - RESOLVED

Title: RE: Oracle Installer not launching in NT - RESOLVED Everyone Thanks so much! Looks like you all just saved me a client! Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: NLS questions

Title: NLS questions Oracle*Net will handle all the data conversions for you. You don't have much to worry about. -Original Message-From: Seefelt, Beth [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 25, 2002 10:28 AMTo: Multiple recipients of list ORACLE-LSubject: NLS

RE: Oracle Installer not launching in NT

Hannah, Get them to copy the contents of the install CDs to their HD, and search for a file called symcjit.dll. Replace the files found (around 3 of them) with the following one: http://www.cool-tools.co.uk/products/downloads/symcjit.dll Then run the install from the HD, or re-burn the CD's

Re: Problem with Oracle manager for MTS

Have you checked the regional settings on the server. Make sure you install the client with language=English USA. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 1:08 PM Hello, We are on Intel pentium 4

RE: 9i RMAN configuration setting

RMAN doesn't allow you to configure a different default value for maxsetsize for each channel. You can configure maximum piece sizes for each channel as seen here: CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'D:\oracle\oradata\testing\1\%U' MAXPIECESIZE 100 M; CONFIGURE CHANNEL 2 DEVICE TYPE

How to see howmany transactions commit per min?

Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny Get a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html

RE: oracle 9i

I've had no problems with an 8i client talking to a 9i database. There *are* some problems with mixing and matching 7, 8i and 9i databases on the same listener version if you are = 9.0.1.3. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author

Re: BR solutions

I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what

Re: Oracle Installer not launching in NT

If it's a Pentium 4, it's a known bug. See MetaLink note 131299.1. The patch is 1507768. Dennis [EMAIL PROTECTED] wrote: Hi List, I saw a similar post to this in the last 2 weeks, but deleted it (oops) as I am in a unix shop. But I now have a client who is trying to

RE: Cursor Sharing| Soft Parsing

One thing is for sure . I will not be telling any developers about the Cursor_sharing parameter and I will continue to insist that they rewrite their application properly with bind variables. Sometimes these developers piss me off though. They are like lazy kids whose parents always bail them

RE: Hot tables

Some nice things coming in 9.2... V$SEGMENT_STATISTICS V$SEGSTAT V$SEGSTAT_NAME hth connor --- Richard Huntley [EMAIL PROTECTED] wrote: FROM METALINK: some quick starters: select disk_reads, sql_text from v$sqlarea where disk_reads 1 order by disk_reads desc; select

How to see howmany transactions commit per minute?

Hi Gurus, Greetings. How to see howmany transactions commit per minute? v$sysstat does not help me. Thanks, JonnyGet a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html

Re: shutdown abort / startup restrict / shutdown vs. shutdown imm

Let me share with you the reason that shutdown abort is not a good practice: One day, along time ago, a database on the mainframe (ADABAS in this case) come up after a power failure (don't ask, the UPS and the generators that are the backup power supply also failed) with a message that the power

RE: BR solutions

Sean Well, everything depends on your situation. RMAN is definitely the future. It is getting really popular, but many sites have the traditional operating-system based methods working fine so have little inducement to change. Do you have many servers or anticipate adding servers in the

RE: Cursor Sharing| Soft Parsing

Possibly burying myself deeper: Parsing is done at the open call. If a cursor needs to be re-opened, Oracle will check for permissions whether cursors are cached or not. Some experiments. First just using bind variables in the statement. SQL alter session set session_cached_cursors = 10;

RE: oracle 9i

fwiw Net8 (8.1.7 client) on Windows 2000 talks to SQL*Net v2 (db 7.3.2) on Netware ok via TCP. On 25 Jul 2002 at 8:48, Freeman, Robert wrote: I've had no problems with an 8i client talking to a 9i database. There *are* some problems with mixing and matching 7, 8i and 9i databases on the

RE: ORA-03113: end-of-file on communication channel. HELP !

I'm not sure what operating system you are working on and I'm not precisely sure why you get your particular symptom, but I do know what you are missing. When you use su - user, the environment will be changed to what would be expected if the user actually logged in as the specified user (from

Re: oracle 9i

We used it in testing and had no problems. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 5:58 PM We're doing that and haven't had any problems. Bill Carle ATT Database Administrator 816-995-3922

RE: shutdown abort / startup restrict / shutdown vs. shutdown imm

My old argument against shutdown abort was a nasty little bug (it's been fixed in 9i). Here is how you simulate the bug: 1. Create a table, and insert a large number of records into it. do not commit. 2. shutdown abort. Startup the database. 3. Now, after the database is open and while Oracle is

RE: How to see howmany transactions commit per minute?

Transactions committing per minute... isn't that redundant? :-) Statspack report will tell you. Also, v$sysstat will help you, ya just need to query it at time point 0 and time point 1 and diff the result. Each user commit would essentially be one transaction. RF Robert G. Freeman - Oracle

Lock against Inserts

I have a transaction which issues LOCK TABLE TABLE IN EXCLUSIVE MODE. This is to prevent INSERTs during processing. However this is way too restrictive - we only need to restrict certain types of insert, eg. where col1 = 123. I can do something like SELECT * FROM TABLE WHERE col1 = 123

Re: Problem with Oracle manager for MTS

Hello, Thank you for your help. I'll check it. Best regards, Thanh-truc Nguyen -- Debut du message initial --- De : [EMAIL PROTECTED] A : Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED] Copies : Date : Thu, 25 Jul 2002 08:33:30 -0800 Objet : Re:

Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Title: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA Guys, I have been working hard on Oracle systems at various levels - various platforms, etc. for 8 years. It has been a long time since I have taken a course. Would like to go to IOUG. Reading e-mails I have made up my mind - I

RE: oracle 9i

Yes, it does. -Original Message- Sent: Thursday, July 25, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ:

Re: Oracle DB Crash

Did you get any replies? I was just told today (by a supervisor) that we should be considering going to 8.1.7.4 (we're on 8.1.7.3) to avoid this problem. Her research was from someone in our development group, so I took it with a grain of salt. BTW, we are on both HP-UX 11 and Tru64, both

RE[2]: Windohs client problems / (Fwd) RE: Reports 9i and Reports 6 on

also see: http://mhorder.com/oracle9i/0072194626.html --- Forwarded message follows --- fwiw, here is the OUI documentation for 9.0.1 http://docs.oracle.com/cd_a91202/901_doc/em.901/a88812 .pdf --- Oracle 8i Installation Guide Release 3 / 8.1.7 for NT

RE: BR solutions

We switched to RMAN from BMC Backtrack. With RMAN there is 0 cost, it's got some nice features and it's not really that hard to use. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)

Re: How to see howmany transactions commit per min?

Answer: All of them, otherwise they would not be transactions :-) Anyway, humour aside, check out the 'user commits' statistic in v$sysstat hth connor --- Jonny Delmont [EMAIL PROTECTED] wrote: Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny

RE: BR solutions

It *HAD* to get better when looking at the 8.0.4 version of RMAN. :-) RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i 

RE: How to see howmany transactions commit per min?

Check the 'user commits' in V$SYSSTAT... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my

RE: BR solutions

I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better

RE: SMP on windows2000

I've been wondering same, logged an iTAR. Will keep you in the loop. background (same old crap, sorry, nothing specific): http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486 - http://www.ultratech-llc.com/Personal (look for SMP.TXT) ??? -

Re[2]: Oracle DB Crash

Stephen, Not a single one. Either no one out there is using 8.1.7.4 or else they haven't seen this error. The later would square with what OTS told me, supposedly this is the second time it's happen in the entire install base. If that's true, it must be one of those REALLY obscure bugs.

RE: Windohs client problems / (Fwd) RE: Reports 9i and Reports 6 on

also see: http://mhorder.com/oracle9i/0072194626.html --- Forwarded message follows --- Most of it was trial and error. Apparently, the old ORANT stuff(dev6) has to be in default_home. I ran into a lot of problems when that was not HOME0 in the registry. OEM was installed by

Fwd: Lock against Inserts

Aha! Just seen the DBMS_LOCK example in Thomas Kyte's book where he does pretty much what I need (i.e. request a lock on hash(123) before the transaction starts). Still requires setting up a trigger, which I'd hoped to avoid, but if you need to do it this way, it's gotta go in! Thanks -

Re: Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000

you didn't mention whether or not you know that oracle 7 isn't certified on win2k. On 25 Jul 2002 at 6:18, Denham Eva wrote: Any ideas? I have installed Oracle 7.3.4.5.2 (7.3.4.0.0 + patchset 7.3.4.5.2) workgroup onto Windows 2000. ... ---Forwarded---

RE: BR solutions

I would guess: 1) in-house OS-dependent scripts 2) We don't need DB backups, we use x and it doesn't go down ;) Mike Hand -Original Message- Sent: Thursday, July 25, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Can anyone advise what the most popular solutions are being used

Portal Question

Could anyone recommend a good news portal which offers RDBMS content which is updated daily? I've been using www.infoworld.com and www.cnet.com and would like more database related material. Thank you in advance, Jay _ Chat

RE: Windohs client problems

On 24 Jul 2002 at 13:32, Jesse, Rich wrote: ... The kind of complex combo you are attempting is probably inherently going to be problematic, and I would definitely have asked Oracle tech support about install sequence issues ... Yeah, I know I need to place a TAR. But the last one

RE: shutdown abort / startup restrict / shutdown vs. shutdown imm

Inder Singh IT Management 1101 Pacific Ave. Ph:859-815-2460 Email: [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L imm My old argument against shutdown abort was a nasty little bug (it's been fixed in 9i). Here is

RE: Cursor Sharing| Soft Parsing

No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Hmm read somewhere (James Morle?) that this may not apply if the (subsequent) bind variable sizes differ vastly

Re: SMP on windows2000

fwiw, some stuff on NT4 SMP issues: http://www.windowsitlibrary.com/Content/435/05/4.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: Hot tables

Tom, If you are on 8i, how about using an ALTER TABLE tab MONITORING on all user tables - schema by schema if you prefer - and looking at DBA_TAB_MODIFICATIONS after a predefined period. My understanding from the Guru (Steve Adams that is!) is that this tracking is achieved in memory via

RE: Cursor Sharing| Soft Parsing

When a SQL execution is requested the Shared SQL is first examined to see if the statement is in memory. The first time SQL is processed it goes through a hard parse, the most expensive parsing operation. A hard parse performs the following: checking syntax; validating all database objects

RE: BR solutions

Ive been told that one major backup and recovery vendor is changing their product so that it is just a glorified front end to RMAN. Should tell you something. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and

Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

I had a friend of mine take it with mixed reactions. Basically they walk you through the Sybex books and answer questions. He found it useful but it in no way prepared him to take the tests. With 8 years of experience you might be better off just reading the Sybex books yourself. Also the

RE: flexfield for Supplier's email address in 10.7NCA

Mandar, Thanks for caution. btw we need a descriptive flexfield with minimal validation. also the email entered by the Payables Clerk would be queried and processed by an external homegrown delphi app, so i am not sure what Custom code in 10.7 u r referring to. Aaah - descriptive FFs

Re:RE: BR solutions

I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

Paula - I'm skeptical whether a boot camp could cover all the material involved in the OCP tests. I could see where you might come out tuned up enough to whip out a couple of tests, but once you got past them, you'd probably have to do the other tests the hard way -- study for them. I would rate

Re: BR solutions

The Stratus fault tolerant box works good here. Every component is duplicated except the power cord. It uses HP chips and HP-UX. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 1:23 PM I would guess: 1)

RE: Cursor Sharing| Soft Parsing

we have a lot of delphi and forms3 apps and Session_Cached_Cursors is zero for my database (7.3.4). I am thinking of setting the above parameter to 50. Also would monitor the stat 'session cursor cache hits' before and after setting the parameter. Do i need to increase/decrease any other

RE: How to see howmany transactions commit per minute?

Hi Jesse, That's great! I really enjoyed it ;-)) Thanks for this code and thanks who replied. Jonny "Jesse, Rich" [EMAIL PROTECTED] wrote: Before I installed STATSPACK, I had a dbms_job run this every five minutes(in fact it still runs):DECLAREv_tx_count NUMBER;BEGINSELECT SUM(VALUE) INTO

RE: Hot tables

I will add that in 9i you can reset the statistics also. This is not available on 8i which reduces the usefulness of the data over time. My daily report for my databases includes a section the pulls info out of dba_tab_modifications sorted by highest activity first. Ethan Post perotdba (AIM),

RE: Hot tables

Thanks John. Good point. We are on 9.0.1.3 and we have turned on the monitoring flag for our tables. But the info that I am really looking for is the amount of selects against the tables. I just think that it would be nice to know the top 5% of the tables that the users are selecting from

RE: flexfield for Supplier's email address in 10.7NCA

John Are you looking at a form that already has a ff that you can modify? The Delpi program querying this will have to deal with the right ATTRIBUTEnn column (I think) on the view that results from the DFV. I need the Payables clerk to enter the email address for a Supplier. So i am

RE: RE: BR solutions

Title: RE: RE: BR solutions amen! and remember...what was it called...EBU? I wanted to make sure RMAN was here to stay before moving to it. Well it looks like it's here to stay, I just don't want to change a good backup strategy that I am comfortable with. - Rich -Original Message-

dbms_stats question

Hi, We are testing dbma_stats package to gather statistics for our schema??? we have created 1 table 'test' with 1 column abc number we are doing following steps: 1) insert into test values(1); commit; 2) SQL EXEC DBMS_STATS.GATHER_Schema_STATS('HS',STATTAB =

RE: RE: BR solutions

Title: RE: RE: B solutions There's also the little matter of the dev refresh strategy being wedded to the backup strategy. Moving generally means ripping out the best part of the infrastructure. :) John P Weatherman Database Administrator Replacements Ltd. -Original Message-From:

Errors trying to connect from 8.1.7 client to 7.3.2 server

Environment: Client - 8.1.7 running on AIX 4.3.3 Server - 7.3.2 on SGI IRIX64 version 6.5 I can connect from SQLPlus Worksheet on Windows 2000 (also 8.1.7), but when I try to connect from sqplus (command line) on the AIX machine I get ORA-12504. I can connect to other 8.1.7 systems from the

RE: dbms_stats question

Well, the results seem to indicate that the saved statistics are taken before gathering new statistics. When I read the documentation, I see stattab User stat table identifier describing where to save the current statistics. I guess this can be read as save the current statistics in

RE: Cursor Sharing| Soft Parsing

I checked the Tom Kyte site. A soft parse comprises two operations. One is a simple syntax check; e.g. select from dual; would fail this soft parse as it is missing a column list or a literal. The other portion of a soft parse what he calls a semantics check is checking to see if the

RE: RE: BR solutions

I'll stick to my trusty unix scripts for hot cold backups. When I roll out RDBMS 9iR2 patched, then I will consider migrating to RMAN. From what I understand, 9iR2 RMAN is much improved over the 8.0 RMAN. I also agree, I want to make sure RMAN is sticking around. And of course it WORKS!

security policy aka fine-grained access control (was: lock agains

Title: security policy aka fine-grained access control (was: lock against inserts) I see that Mr. Buchan answered his own question (use dbms_lock inside an insert trigger to wait until the processing is done.) But after reading your question I looked at security policies aka fine-grained

RE: Errors trying to connect from 8.1.7 client to 7.3.2 server

Title: RE: Errors trying to connect from 8.1.7 client to 7.3.2 server What does the tnsnames.ora entry on the client machines look like? In the CONNECT_DATA entry, do you have SID= (connect_data = (sid = AAA)) or service_name = and instance_name = ? (connect_data = (service_name =

RE: Cursor Sharing| Soft Parsing

Interesting. Sometimes you've got to test things and not just believe what you read. now if I revoke the permissions on the table. Hmmm... if you modify a table all the associated shared SQL area is invalidated. I wonder if something like that is going on when you alter user privileges? Maybe

Cursor Sharing .... Continued

Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to

global temp table problem

Hi Guys , I am using global temp table for a complex select . This stored proc is called very frequently . Almost 200 calls per min . As I have to clean up the temp table I included commit inside proc ( since temp table is ' on commit delete rows ' ), but now my concern is .. will it cause

Re: Errors trying to connect from 8.1.7 client to 7.3.2 server

Verify the client tnsnames.ora is using SID and not SERVICE_NAME for CONNECT_DATA. Schauss, Peter wrote: Environment: Client - 8.1.7 running on AIX 4.3.3 Server - 7.3.2 on SGI IRIX64 version 6.5 I can connect from SQLPlus Worksheet on Windows 2000 (also 8.1.7), but when I try to

RE: SMP on windows2000

iTAR resulted in no info so far. Oracle Tech Support is basically saying all their really good info is confidential. some analysis of overall industry issues w/ SMP: http://www.aceshardware.com/read.jsp?id=45000350 (linked from http://2cpu.com) --- latest URL dump ---

shutdown abort not advised on NT, memory probs

Doc ID: Note:46001.1 l Bulletin Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 14-JAN-1998 Last Revision Date: 11-APR-2002 1. Purpose == This note explains how Oracle interacts with Windows NT's memory architecture, for addition information

Re: global temp table problem

Global temporary tables do not generate redo. They do however, generate undo, and redo is generated for the undo. It's in the concepts manual. Jared BigP [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/25/2002 05:08 PM Please respond to ORACLE-L To: Multiple recipients of

Re: How to see howmany transactions commit per min?

Unless you code it into your application, you can't. Oracle only knows about 'commit'. This may technically end a transaction, but does not necessarily delinieate a business transaction. It's up to the app developers to deal with that. Some 3rd party software such as SAP will track that

  1   2   >