High disk , query values with Global non-prefixed Local indexes

Qs  Why the larger values of disk=45 , query = 525 when using Global indexes Non-prefixed local indexes VERSUS Local Prefixed indexes where dis = 0 query = 0 in the CASES below ? Qs How significantly can this affect the performance thruput ? CASE : Comparison with global

RE: Triggers - How expensive when set on heavily loaded tables ?

CASE - If Only 1 record is found in TABLE_1 (on the average) for 8 records INSERTED into TRAN_TBL Qs Is the Overhead of Checking the condition by the trigger also a significant portion OTHER than the actual execution by the trigger of INSERT into TABLE_2 on finding a match in TABLE_1? Any

indexing PDF's using intermedia (8.1.7), not happening

List, I have installed intermedia, and been using it for the last couple of weeks without nay problems, recently, after uploading a PDF documents in the blob column, i found out that the contents of PDF's are not being indexed !!! i have tried sync the index also.. all the other formats

RE: direct path write waits, please help

FYI The application that is causing the wait events is a third party product that really sucks (autocommit, no bind variables, bad data model, etc., etc.) We're on EMC Symmetrix. There are hardly any wait-io's measurable on AIX; the log file sync problem is not so much of a problem; moving to

RE: High disk , query values with Global non-prefixed Local ind

Vivek, Probably due to blocks being cached in memory. Those values are not high. Especially when you getting sub second response times. Regards Suhen -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]Sent: Wednesday, 30 July 2003 6:14 PMTo: Multiple recipients

ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: ORA-27101 RH linux 9 Oracle 9.2.0.3 Hi, I have above setup on my homebox. Every now and then I get Oracle error 27101, and have to restart the database. I can connect / as sysdba and select * from v$database though. Has anybody seen this happen before and may be able to help me

undo tablespace and rollback segments in oracle9i

I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL

Re: direct path write waits, please help

Hi! Either your 4 disk sorts are huge generating lot's of IO or there direct writes aren't because of sorting. They could be because NOCACHE LOB access for example (also CTAS and direct path insert). You should view 10046 level 8 output and check in which file are the IOs occurring. Tanel.

RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: Message 512Mb RAM 2Gb Swap space 10:44:37 up 2 days, 21:15, 4 users, load average: 0.00, 0.05, 0.03119 processes: 115 sleeping, 4 running, 0 zombie, 0 stoppedCPU states: 0.3% user 0.0% system 0.0% nice 0.0% iowait

RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.

LOL--I'm the sole ultraedit fan in a den of textpad users have had many conversations that start with the phrase yeah, but can your editor do this I was of the opinion that they were pretty much equal until someone (Dennis Williams?) wrote in reminding me of ue's ability to

RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: ORA-27101 RH linux 9 Oracle 9.2.0.3 Jack, ORA-27101: shared memory realm does not exist Oracle probably been aborted for some reason. Strangehow you can do a select * from v$database. How much memory and swap space you have configured. Regards Suhen -Original

Re: direct path write waits, please help

Could it be that hash joins account for the writes to TEMP without increasing the sort stats? Or 'group by' statements, perhaps? In a 10 minute interval, I can see no increase in the number of sorts to disk, but the writes and reads from v$tempstat increase by thousands. If that's the case,

Re: direct path write waits, please help

Hi! Group by is still doing sorting, and is accounted in sorts stats (unless an index scan wasn't used to get rows in desired order). But yes, hash joins don't increase sort stats by themselves. You should check 10046 level 8 output, find which SQL statement is doing direct path writes, then get

ORA 6501

Hi Friends , I have a procedure which inserts around 6 million records dynamically from one table to another . During the insertion process the oracle throwed ora 6501 program error . There is enough table space available and enough rollback segments are also available. Can you please

Re: direct path write waits, please help

Quote: Group by is still doing sorting, and is accounted in sorts stats (unless an index scan wasn't used to get rows in desired order). But yes, hash joins don't increase sort stats by themselves. end of quote I think you meant was usedin sted of wasn't used. Just like you said, is's all hash

RE: ORA 6501

It could be a problem with %type declaration. Senthil. -Original Message- Ramasubramanian, Shankar (Cognizant) Sent: Wednesday, July 30, 2003 6:05 PM To: Multiple recipients of list ORACLE-L Hi Friends , I have a procedure which inserts around 6 million records dynamically from

RES: ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: Message Have you tried to reconnect to the instance? Does the instance shuts down or your connection? Try changing the following parameters: Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX,

RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: Message Hi, Have tried to reconnect and get the error message 27101 (when using @sid logon) ** [EMAIL PROTECTED] admin]# cd /proc/sys/kernel[EMAIL PROTECTED] kernel]# cat sem250 32000 100 128[EMAIL PROTECTED] kernel]# cat

RE: upgrade to 9i

Title: Message See doc ID 214887.1 -Original Message-From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 5:54 PMTo: Multiple recipients of list ORACLE-LSubject: upgrade to 9i Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i .

RES: ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: Message The parameter shmmax (Shared Memory) is lower than the sugested. Please check: Yours: 536870912 Sugested: 2147483648 Sandro Augusto da Silva Technology Services Support NLA Technology Services Phone: +55 11 3398-8438 Fax: +55 11 3398-7522 -Mensagem

Any German here ? Character set

Title: Any German here ? Character set Hi List, could you please tell me wich Character Set you are using in your database ? Thank in advance! Philippe

optimizer parameters in Oracle 9.2

Hi all: I have been reading on the optimizer_ parameters for Oracle 9i - optimizer_max_permutation, optimizer_index_caching and optimizer_index_cost_adj. I have also been playing whith them and I can see that they affect the explain plans for some queries quite dramatically. Is there any

RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

Title: Message Damn your right, I need new glasses :-) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:14 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3

RE: Any German here ? Character set

Title: Any German here ? Character set WE8ISO8859P1, supports most western europe needs. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: NGUYEN Philippe (Cetelem) [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:04 AMTo: Multiple

Re: undo tablespace and rollback segments in oracle9i

Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select segment_name, tablespace_name from dba_rollback_segs; SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4

RE: Triggers - How expensive when set on heavily loaded tables ?

Hi Vivek, I'll try to share my experience. Impact of FOR EACH ROW trigger may be quite essential on heavily loaded tables, even if a trigger is just an empty body. This is the case when application uses array (batch in java) DML. Larger arrays (like 100) are impacted more. Number of LIO may be

RE: Any German here ? Character set

Title: Any German here ? Character set I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro support! Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, July 30, 2003 15:29To:

On TRUNCATE table does the indexes also get truncated.

Hello, When you truncate a table using:- TRUNCATE TABLE TEMP; does any of the indexes on the table also get truncated? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _

Re: Any German here ? Character set

I'm not German, but to my knowledge, all west European languages use ISO-8859-1. On 2003.07.30 10:04, NGUYEN Philippe (Cetelem) wrote: Hi List, could you please tell me wich Character Set you are using in your database ? Thank in advance! Philippe -- Mladen Gogala Oracle DBA -- Please see the

RE: 8.1.7.4 interim patch management strategy

Our strategy is to not apply them and migrate to 9iR2 instead. At least that's the plan for now, until we find out something won't work with 9i. It's probably cheaper to do in the long run, and it'll be supported thru 2005, unlike 8.1.7, which expires at the end of this year. Rich Rich Jesse

Re-2: Any German here ? Character set

Even better is ISO-8859-15, which contains the EURO-character. oli Original Message To: [EMAIL PROTECTED] I'm not German, but to my knowledge, all west European languages use ISO-8859-1. On 2003.07.30 10:04, NGUYEN Philippe (Cetelem) wrote: Hi List, could you

RE: optimizer parameters in Oracle 9.2

Paging Mr. GormanMr. Tim Gorman... I had wonderful luck with Tim's paper The Search for Intelligent Life in the Cost-Based Optimizer from: http://www.evdbt.com/papers.htm Enjoy! (And thanks again, Tim!) Rich Rich Jesse System/Database Administrator [EMAIL

RE: upgrade to 9i

I'd also suggest that you read the migration guide before you do any upgrade. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/30/2003 8:09 AM See doc ID 214887.1 -Original Message- Sent: Tuesday, July 29, 2003 5:54 PM To: Multiple recipients of list

nothing directly related to Oracle...but certainly relevant...

Title: nothing directly related to Oracle...but certainly relevant... http://story.news.yahoo.com/news?tmpl=story=/nm/20030729/tc_nm/tech_jobs_dc_1 the world is changing quickly. Chris Current DBA in-progress...future ???

AW: Any German here ? Character set

Title: Any German here ? Character set Hi That's exactly what we use. But it depends on what you have to support: If you have Oracle running on a Mainframe and your customer is Austrian, there is D8EBCDIC1141, which supports special local characters. Hope that helps, Stefan Stefan Jahnke

Re: optimizer parameters in Oracle 9.2

See http://www.evdbt.com/SearchIntelligenceCBO.doc Hemant At 06:04 AM 30-07-03 -0800, you wrote: Hi all: I have been reading on the optimizer_ parameters for Oracle 9i - optimizer_max_permutation, optimizer_index_caching and optimizer_index_cost_adj. I have also been playing whith them and I

Re: Any German here ? Character set

What about Polish? Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:59 AM I'm not German, but to my knowledge, all west European languages use ISO-8859-1. On 2003.07.30 10:04, NGUYEN Philippe (Cetelem)

RE: optimizer parameters in Oracle 9.2

Rich, thanks a lot. I just finished reading Tim's paper and it is truly enjoyable reading. I'm going to test his advices in a few moments. Gene --- Jesse, Rich [EMAIL PROTECTED] wrote: Paging Mr. GormanMr. Tim Gorman... I had wonderful luck with Tim's paper The Search for Intelligent

RE: Any German here ? Character set

Title: Any German here ? Character set Correct The difference between the P1 and P15 is P15 got P1 + euro support. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell:

Is it Veritas or is it smoke and mirrors? again

There seems to be some big confusion if Veritas is working or not... Based on Previous discussions this customer has the Oracle Veritas agent running, and they do nightly backups. How ever, I find absolutely NONE of the RMAN tables updated so they are not using RMAN. I also find that

Re: undo tablespace and rollback segments in oracle9i

The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did

RE: undo tablespace and rollback segments in oracle9i

hi , please look attached file ; -Original Message- Sent: Wednesday, July 30, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Bahar, Arslan Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select

RE: undo tablespace and rollback segments in oracle9i

yes . What should i do -Original Message- Sent: Wednesday, July 30, 2003 5:30 PM To: Multiple recipients of list ORACLE-L The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL

Re: Any German here ? Character set

ISO-8859-2, Same as Czech, Croatian, Slovenian and Slovak. On 2003.07.30 11:24, KENNETH JANUSZ wrote: What about Polish? Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:59 AM I'm not German, but to my

Re: Is it Veritas or is it smoke and mirrors? again

Michael Kline wrote: There seems to be some big confusion if Veritas is working or not... snip... Recovery has NEVER been tested. Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email:

AW: Any German here ? Character set

I'm a hundred percent sure that your German is about a bazillion times better then my yugoslavian. And I'm still trying to figure that beast called English ... and they don't even have Umlaute ;). Err, seriously, I'm from the German part that's closer to the Netherlands (great country, people are

RE: Is it Veritas or is it smoke and mirrors? again

Title: Message Hmmm, sounds like me and what will be my next issue, except I'll be using Veritas to backup to a SAN. I'll watch this thread closely. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original

Re: undo tablespace and rollback segments in oracle9i

If you are now running in manual undo mode and have created rollback segments, you can remove the undo segments. Verify that the segments are offline and you are not using them. Then drop the undo tablespace. This is the only way to get rid of them. [EMAIL PROTECTED] wrote: yes . What should

Re: buffer busy waits and v$filestat

Thanks, Mladen, for that helpful quick reply. The reason I ask is, one of our clients claims that they see a intermittent database performance degrade (queries get timed out), during times when the RMAN backup runs. Using an OS monitoring tool, they see a spike in I/O. The RMAN backups have 4

RE: Any German here ? Character set

When I studied German for two years in college (I've forgotten it all now), I kept thinking that the same person who invented all the goofy spelling in English (remember the joke about ghoti being pronounced fish?)**, also invented German grammar. No offense to anyone is intended. ** GH as in

RE: Triggers - How expensive when set on heavily loaded tables ?

10046 level-8 trace will show you exactly how much response time is consumed by the recursive SQL executing the trigger(s) (as well as details about why the response time was what it was). We have a 30-minute exercise in our Hotsos Clinic 101 in which you practice the act of interpreting exactly

RE: undo tablespace and rollback segments in oracle9i

Your attachment was removed by the list server. However, your direct e-mail to me had the following: SQL show parameter undo ; NAME TYPEVALUE --- --

Re: upgrade to 9i

No, that's the wrong way. The right way is to read first 3 pages, then try it out, using your production database, naturally, and when it fails, ask the questions on this list. Do not forget to put something like *** NEED URGENT HELP *** in the message subject, because that gives me an adrenaline

RE: buffer busy waits and v$filestat

Raj - You might also consider monitoring the I/O from the system side, until that you won't have the full picture. That is probably where the RMAN load would show up, and your instance would be indirectly affected. 4 channels sounds pretty heavy. Is this tuned for to keep a tape drive busy? We

Re: optimizer parameters in Oracle 9.2

Please be aware that the paper and presentation were written in the 8i timeframe. I swear I'll get it updated for 9i, but already 10G is looming and it's summer and the weather is nicesigh... on 7/30/03 8:24 AM, Gurelei at [EMAIL PROTECTED] wrote: Rich, thanks a lot. I just

Re: Any German here ? Character set

Just cover all bases and use UTF8 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: 8.1.7.4 interim patch management strategy

Always a difficult activity although the opatch utility available with 9i could prove a real benefit Most sites I have worked on don't have a policy as such but they only apply patches as and when necessary. The other difficulty is that out of say the 180 patches you mention, many may apply to

Re: Any German here ? Character set

Austrian? Local characters? I was fully convinced that Austrians speak German. As an inhabitant of ex-YU, I did a lot of shopping in Graz and even Munich. There wasn't much difference, even joo was the same. Mein Deutsch war ziemlich fliessend fruher, aber jetzt, Ich weiss nicht. God, do I hate

RE: optimizer parameters in Oracle 9.2

Tim Gorman scribbled on the wall in glitter crayon: Please be aware that the paper and presentation were written in the 8i timeframe. I swear I'll get it updated for 9i, but already 10G is looming and it's summer and the weather is nicesigh... and the 9i migration here is scheduled

Oracle Metalink

please tell me metalink is down and that they haven't revoked my membership! Shannon St. DennisDatabase AdministratorCity of Regina(306) 777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA

Linked Server and remote TNSNAMES

We have a SQL Server database that needs to link to an Oracle database. I have been able to successfully setup this linked server entry in SQL Server, but only when I am using a local TNSNAMES.ORA. We typically have all of our Win2000 machines point to a central TNSNAMES.ORA file that is on a

RE: On TRUNCATE table does the indexes also get truncated.

The simplest way to find out is to try it (on test box). Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Denham Eva Sent: Wednesday, July 30, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Hello, When you truncate a table using:- TRUNCATE TABLE TEMP; does any of

RE: On TRUNCATE table does the indexes also get truncated.

Hi, Truncate will not drop your index. It'll remove all the contents of the table and reset the HWM. senthil. -Original Message- Denham Eva Sent: Wednesday, July 30, 2003 8:29 PM To: Multiple recipients of list ORACLE-L Hello, When you truncate a table using:- TRUNCATE TABLE TEMP;

RE: Is it Veritas or is it smoke and mirrors? again

Even more scary was that when checking the readme.txt file, the last version mentioned as being supported with backup exec agent is 8.1.5... The exec says it's version 5.0.1, but the Readme says 1.2 for NT. I was told this morning, Oh yea, I never configured the agent yet... This is a potential

RE: optimizer parameters in Oracle 9.2

For the ignorant, what is 10G? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 12:30 PM To: Multiple recipients of list ORACLE-L

9i-OCP Question

Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks does Oracle recommend to keep the redo log files? 1. 8 2. 2 3. 1 4. 4 Which is the correct answer. TIA Senthil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Oracle Metalink

I can get in metastink Dave -Original Message-From: Shannon St. Dennis [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle Metalink please tell me metalink is down and that they haven't revoked my

RE: On TRUNCATE table does the indexes also get truncated.

Title: RE: On TRUNCATE table does the indexes also get truncated. of course indexes will not be dropped, but because table data gets truncated, there will be NO data in indexes either. Raj Rajendra dot

Re: On TRUNCATE table does the indexes also get truncated.

It's elementary my dear Eva: if it didn't get truncated, then the index entries would be pointing to the non-existant rows. So, the answer to your question is: yup. On 2003.07.30 10:59, Denham Eva wrote: Hello, When you truncate a table using:- TRUNCATE TABLE TEMP; does any of the indexes on

RE: Oracle Metalink

I think they don't like you, Metalink is UP and well. :( -Original Message-From: Shannon St. Dennis [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle Metalink please tell me metalink is down and

Re: optimizer parameters in Oracle 9.2

Tim, I noticed that, but still it is a great article and I'm looking forward to reading the updated version thanks for your help Gene --- Tim Gorman [EMAIL PROTECTED] wrote: Please be aware that the paper and presentation were written in the 8i timeframe. I swear I'll get it updated for 9i,

Re: Oracle Metalink

Your membership was eliminated. You are getting: MetaLink V2 - Error Message UNEXERR which means that you have been terminated. I'll be back. On 2003.07.30 12:29, Shannon St. Dennis wrote: please tell me metalink is down and that they haven't revoked my membership! Shannon St. Dennis

RE: Oracle Metalink

Title: Message works for me at 12:20pm EST on 07/30/2003 Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an

alter table exchage partition moves statistics?

Hi. The subject actually says it all. someone on my team did a quick test and it looked like the statistics have been moved by the alter table command along with the data. Is that what others experience? Are there situations where this is not the case? thanks gene

Re: 9i-OCP Question

The answer is 4. Of course, no one in the right mind would have 2 groups with 4 members each. On 2003.07.30 13:19, Senthil Kumar wrote: Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks does Oracle recommend to keep the redo log

Re: 9i-OCP Question

I will guess -- 1. - Kirti --- Senthil Kumar [EMAIL PROTECTED] wrote: Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks does Oracle recommend to keep the redo log files? 1. 8 2. 2 3. 1 4. 4 Which is the

Re: 9i-OCP Question

Why? What is the logic? Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 12:29 PM The answer is 4. Of course, no one in the right mind would have 2 groups with 4 members each. On 2003.07.30 13:19,

waiting for rdbms ipc reply from checkpoint

I'm writing on behalf of the other DBA here. He is trying to drop all objects in a schema. First he truncated all tables, and now is running a script to drop all tables. It is running very slowly. We turned on a 10046 trace, and by far (almost 100%) the largest wait is 'rdbms ipc reply'. Some of

Re: 9i-OCP Question

according to the 8i osborne ocp book, the answer is 2. From: Senthil Kumar [EMAIL PROTECTED] Date: 2003/07/30 Wed PM 01:19:31 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 9i-OCP Question Hi all, What is the correct answer for this? Q If you have 2 redo

Re: Oracle Metalink

I was able to login and go to most pages, response time was pretty bad though. - Original Message- From: Shannon St. Dennis To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 30, 2003 12:29 PM Subject: Oracle Metalink please tell me metalink

** table triggers

Hi, I have a two tables A and B. Both havea field expected_delay_now and when it gets updated by a userin either table I want update it in corresponding row in the other table. However when this update is as a result of a trigger (and not user updated)how do I skip the update thru the trigger???

** scope for package variables

Hi, I have a variable in a package and I am using it as a flag in another procedure and trigger. Depending on the flag some action will be done or skipped. Is it correct to assume that each user process (could be around 20 at a time) will have it's own value of the variable starting with the

RE: waiting for rdbms ipc reply from checkpoint

Henry Dictionary-managed tablespaces? (not locally managed or LMT) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L I'm writing on behalf of the other DBA

** how to check version and problems

Hi, How can I check the version for a installation without going into sqlplus. And to check if there are any problems with installation is it enough to check the install.log. Thank you. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: 9i-OCP Question

So, what do you need us for? On 2003.07.30 13:29, [EMAIL PROTECTED] wrote: according to the 8i osborne ocp book, the answer is 2. From: Senthil Kumar [EMAIL PROTECTED] Date: 2003/07/30 Wed PM 01:19:31 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 9i-OCP Question

Re: 9i-OCP Question

Answe is 4 disks . to keep each member on different disks . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:19 AM Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members

Re: ** table triggers

You can't. An update statement is what fires the trigger. Trigger cannot see where does the statement come from. May be you should rethink the overall design of the application? On 2003.07.30 13:59, A Joshi wrote: Hi, I have a two tables A and B. Both have a field expected_delay_now and when it

RE: Oracle Metalink

Title: Message It lets me login but can't display the opening page for my headlines. Allan -Original Message-From: Shannon St. Dennis [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle Metalink

RE: ** scope for package variables

Title: RE: ** scope for package variables RTFM The answer is listed in http://tinyurl.com/ij25 and http://tinyurl.com/ij2a and http://tinyurl.com/ij2d have fun. Raj Rajendra dot Jamadagni at nospamespn dot

Re: Re: 9i-OCP Question

i didnt ask the question. I was responding. what is up with the attitude? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/07/30 Wed PM 02:04:57 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: 9i-OCP Question So, what do you need us for? On 2003.07.30

RE: 9i-OCP Question

Nah, the answer is 42. :-) -Original Message- Sent: Wednesday, July 30, 2003 11:39 AM To: Multiple recipients of list ORACLE-L I will guess -- 1. - Kirti --- Senthil Kumar [EMAIL PROTECTED] wrote: Hi all, What is the correct answer for this? Q If you have 2 redo log groups

Re: ** table triggers

It sounds like this column belongs in a table that is the parent of tables A and B. [EMAIL PROTECTED] 07/30/03 02:09PM You can't. An update statement is what fires the trigger. Trigger cannot see where does the statement come from. May be you should rethink the overall design of the

Re: 9i-OCP Question

There are two reasons: 1) Redo log groups are never used simultaneously, so they can reside on the same disk. Log members should not be on the same disks for increased survivability. That gives us 2 groups with 4 members, each two members sharing the same device - 4 disks alltogether. 2)

RE: 9i-OCP Question

Title: RE: 9i-OCP Question depends ... that answer usually works April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Kirtikumar Deshpande

Trigger fires when WHEN clause evals to false?

Since I'm getting nowhere fast with Oracle Support, I'll try this here: While looking in V$DB_OBJECT_CACHE, we noticed an unpinned row-level trigger had been fired over 900K times. We compared this to other row-level triggers on the same table and noticed that the other triggers were only

RE: optimizer parameters in Oracle 9.2

I'll let y'all get the major bugs out (e.g. 8.1.3, 9.0.1), and I'll wait for the 10GX2 minipack... The second mouse gets the cheese. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original

Re: ** table triggers

Thanks Jay and Gogala for your help : Well these are old big tables and any re-design will be a bigger impact. . YEs i agreed the trigger will fire no matter what. What I am looking for is a check in the beginning of the trigger and then skip the rest of the trigger. Thank You Jay Hostetter

RE: 9i-OCP Question

I thought you need to preserve the groups, not (necessarily) the members. If you have each group on its own disk then if one disk goes, you've got a complete set of logs on the other. Or am I not thinking about this correctly? Cheers, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed

RE: 9i-OCP Question

I would say 4. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Senthil Kumar Sent: Wednesday, July 30, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many

Re: Any German here ? Character set

Any German here ? Character set I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro support! Yeah, and it has the Õ letter, which I believe is only used by Estonians ;) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET:

  1   2   >