what's the exact meaning of those messages?

Hi, I found the following message from the alert.log: Sun Dec 29 22:35:42 2002 ARC0: Beginning to archive log# 3 seq# 126 ARC0: Failed to archive log# 3 seq# 126 Sun Dec 29 22:35:42 2002 ARCH: Completed archiving log# 3 seq# 126 It seemed the ARC didn't work in the begining of archive, but

[no subject]

hi, Wish u a very New Year Sudhakar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sudhakar Reddy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Physical reads

Hi All in list, I have taken the report.txt using utlbstat and utlestat. Can I assume that the physical reads value as number of physical I/Os to the disk happened? Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat

Re: Physical reads

Pradeep: It is NOT number of read request to the I/O sub-system. It is number of blocks read from the disk. Note that the physical read is not necessarily a physical read. There are chances the block could be from Memory (file system buffer cache). This happens when you have quick IO and/or a

RE: Physical reads

it means no. of DB blocks read from the disk. Regards Naveen -Original Message- Sent: Monday, December 30, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Hi All in list, I have taken the report.txt using utlbstat and utlestat. Can I assume that the physical reads value as

RE: Physical reads

If positive, yes ... - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 30 Dec 2002 01:23:44 Hi All in list, I have taken the report.txt using utlbstat and utlestat. Can I assume that the physical reads value as number of

RE: Physical reads -oops

Ooops. Read too fast. Blocks. You may be interested in checking against V$FILESTAT, where you have both actual 'numbers of requests' of reads/writes and 'numbers of blocks'. Dismally close on some databases, BTW. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of

Re: what's the exact meaning of those messages?

It's just that it couldn't complete archiving immediately, so it will do it asap. That delay (which seems very small from the numbers you show) can be decreased by either making archiving faster (faster disks? network? whatever...) or by archiving less (yeah, right, that sounds easy to do!).

Re: year 2059 problem

UNIX stores time as amount of seconds passed since the 1st of January 1970. Since it is 32-bit value in modern Unices, it can hold up to 2,147,483,648 or approximatively 68 years. The counteroverflows on 19th of January 2038 at 3:14:07 AM. People believe that all the hardware will be 64-bit

9i RAC and Backup/Recovery....

Title: 9i RAC and Backup/Recovery Hey guys- Anyone out there got any gotchas related to backup with RMAN within a 9i RMAN environment? Or better yet-any test scenarios that folks would like to see Thanks! Greg

Re: what's the exact meaning of those messages?

Check your backup script to see if it forces log switches (alter system archive log). If it does, you may be hitting bug 1377090. See note 119547.1. It is a message that you can ignore if it occurs during the alter system.. command. Jay Hostetter Oracle DBA D. E. Communications Ephrata,

Deleting some or all the child records from the child tables and

Hi List, How do I delete all/few lower level records based on the column value of the parent table through SQL or Pl/SQl? If so, could you please send me the SQL queries for the same? Please note that I cannot enforce the 'ON DELETE CASCADE' rule on the foreign key constraints. Any

Re:Killed status

First, find the 'killed' session is v$session and match the paddr with the addr in v$process to find the spid(system process id). I assume your running some sort of Unix, so then run a kill -9 on that spid. Now, take what you found in v$session and find the dumb bunny who has turned off their

columns with primary key constraint

Good Morning List, I am trying to build a query to display the following for any table column_name is_pk --- - COLUMN_1(PK-1) COLUMN_2(PK-2) COLUMN_3 COLUMN_4 COLUMN_5 COLUMN_6 I can get the two columns with (PK) with... select utc.column_name

RE: Enqueue Waits in Oracle Financials

John, I know this is an old topic, but Oracle Support proposed a patch and we finally got it tested. It looks like this enqueue wait goes away with the application of concurrent processing rollup patchset C 2385942. Thanks, Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA

Re: year 2059 problem

Hi I have just tested with 2037 on a linux (2.4.18) with rdbms 9.2.0.2 and this works. Lyndon Tiu wrote: Hmmm, anyone tried Linux Oracle with year 2059? -- Lyndon Tiu On Sunday 29 December 2002 08:28 pm, Amit Nargotra wrote: This strange problem we are facing while implemting

Re: Re:Killed status

All righty, guys thanks for the reply. - Original Message - To: shuan.tay(PCI¾G¸R³Ô) [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 30, 2002 8:46 PM First, find the 'killed' session is v$session and match the paddr with the addr in

Re: Was: Rebuilding Indexes, Now: KEEP INDEX

but if you direct load dups into a table with a unique cons/index, won't the index be left as 'UNUSABLE' thus necessitating an index rebuild anyway. If the index was non-unique, then this is not a problem, but in this case, you don't need KEEP INDEX anyway. Happy New Year Cheers Connor ---

Any Collaboration Suite or 9iAS listservers?

Does anyone know of any Collaboration Suite or 9iAS specific listservers? I tried subscribing to the webcys_l listserver but it appears to be inactive. TIA Michael D. Gilly Sr. email: [EMAIL PROTECTED]

Setting up raw partition on Linux

Dear List: I am not an unix admin nor I know a lot about Linux, however I need to setup RAC on Linux, I am confused about setting up raw partitions for RAC. On the Linux installation Disk setup screen, I can create new partition, however I don't know what type I should use for the raw partition,

Re: Was: Rebuilding Indexes, Now: KEEP INDEX

Yes, but at least the index definition will be preserved so that you could do a simple ALTER INDEX ... REBUILD rather than finding and firing off a script. Particularly useful if you have a lots of partitioned indexes. Arup - Original Message - To: Multiple recipients of list ORACLE-L

Re: Was: Rebuilding Indexes, Now: KEEP INDEX

yes but :) It's a partitioned index. Yes, the partition goes into an UNUSABLE state. If I drop the constraint without keep index and without saving off the statement to rebuild it properly, I drop the ENTIRE index and I end up with a non-partitioned index in the schema owner's default tablespace

RE: Those Pesky Little Audit Files (ora_99999.aud)

Depending on the OS, we had created a batch job to simply delete these aud files after a specific amount of time. You may want to implement a similar process. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL

Re: 9i RAC and Backup/Recovery....

I don't know from experience, but I have been told be those who have used it, that it is pretty much like 8i. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 30, 2002 7:56 AM Hey guys- Anyone out there got any gotchas

Memory leak in OCI call

HI. I am using OCIConnectionPoolCreate to establish Connection with database. When i run through purifier its showing Leak. The traces are as follows MLK: 128 bytes leaked at 0x1b7c830 This memory was allocated from: malloc [rtlib.o]

Re: 8.1.7 with *what* version of Portal??

Add one more thing, you need to make sure to install oracle jvm and intermedia before you install the portal. otherwise, portal won't work without these feafures. Joan Hemant K Chitale wrote: Portal is part of iAS. iAS 1.0.2.X, preferably 1.0.2.2.2, runs Portal 3.0.9.X.X [base version

Re: Rebuilding Indexes...

Jared, thanks for the asktom article, very interesting reading - I'm not 100% sure I agree with him though.I just recently went through the exercise to rebuild our indexes into locally-managed tablespaces and I saved over 100GB of space through the rebuild process - as an example I had a 51GB

Re: Memory leak in OCI call

Are you making any calls to OCIConnectionPoolDestroy anywhere in your program? HI. I am using OCIConnectionPoolCreate to establish Connection with database. When i run through purifier its showing Leak. The traces are as follows MLK: 128 bytes leaked at 0x1b7c830

Re: Oracle.exe , CPU running at near 85%

Rick, Shot in the dark =8-) If Context (a.k.a. InterMedia) is involved I've seen a CPU pegged at 90% with a web app doing a dynamic text query using CONTAINS and a '-' minus operator. They actually didn't know about the '-' query op...they ended up searching the text string input and replacing

Tales Of Big Hammer #10046 (AKA event 10046)

Title: Tales Of Big Hammer #10046 (AKA event 10046) On Friday our application support person called me and said User is getting a ORA-1403 error in one form. I should mention that this is complex. And I need a solution immediately. So, I gave them the hammer (with the sql string to put in

RE: columns with primary key constraint

Hi Steve, Are you looking for something like this?: SELECT utc.table_name, utc.column_name ,DECODE(NVL(ucct.cln, ' '), ' ',' ', '(PK-'||ucct.pos||')') is_pk FROM user_tab_columns utc, ( select uc.table_name tn, ucc.constraint_name cn, ucc.column_name cln, ucc.position pos

rebuilding indexes, the tests

Okay, I did 4 different tests, as follows: in each test I created a partitioned table. Test 1 -- create a unique partitioned index, then create a primary key constraint with the same columns Test 2 -- create a non-unique partitioned index, then create a primary key constraint with the same

Re: Rebuilding Indexes...

The space saving is good if you are not planning on doing much more with those indexes (ie dml). The space saving might be very very bad if there is lots of dml to come. If you're indexes reached equilibrium during normal operation of (say) 70% used, and then you rebuild them with (say) pctfree

RE: columns with primary key constraint

Charu, This is exactly what I was looking for. I will try to modify this now to include an (FK) for any column with a foreign key constraint. Thanks for the extra pair of eyes. Happy New Year all! Steve --- Charu Joshi [EMAIL PROTECTED] wrote: Hi Steve, Are you looking for something like

Re:

sudhakar Reddy wrote: hi, Wish u a very New Year Sudhakar You are not taking risks :-). Very wise. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network

RE: columns with primary key constraint

Title: RE: columns with primary key constraint SELECT /*+ no_merge(utc) no_merge(ucct.uc) no_merge(ucct.ucc) */ utc.owner ,utc.table_name ,utc.column_name ,DECODE(ucct.constraint_type, 'P',DECODE(NVL(ucct.cln, ' '), ' ',' ','(PK-['||ucct.cn || '] ' || ucct.pos||')'),'') is_pk

this doesn't look right

As part of the process of making sure that null/not null constraints are consistent across development/staging/production, I'm looking at the dba_cons_columns table. Now, as far as I know, column_names are limited to 30 characters, correct? If so, why is the column_name column in dba_cons_columns

RE: this doesn't look right

Title: RE: this doesn't look right I think it is to accommodate sys.attrcol$.name column ... In our 9202, it has references to Spatial objects ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion

Re: this doesn't look right

Rachel DBA_CONS_COLUMNS is a view. DECODE is applied against attrcol$.name -- which is varchar 4000. Kind Regards, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Rachel Carmichael wrote: As part of the

Re: this doesn't look right

It might be for a new feature, two_page_long_columnames=true ;-) Rodd On Mon, 2002-12-30 at 14:23, Rachel Carmichael wrote: As part of the process of making sure that null/not null constraints are consistent across development/staging/production, I'm looking at the dba_cons_columns table.

Re: this doesn't look right

Varchar2(4000) is coming from sys.attrcol$ table. dba_tab_columns does not have a join this table. I am sure there are people on this list who'll enlighten me about contents of sys.attrcol$ table. select u.name, c.name, o.name, decode(ac.name, null, col.name, ac.name), cc.pos# from

Re: this doesn't look right

Looking at contents of attrcol$ , name column can have more than 30 characters since it seems to be joining 2 attributes OBJ#INTCOL# NAME -- -- -- 45149 41 USER_DATA.AGENT_ADDRESS 45149 42 USER_DATA.AGENT_PROTOCOL

RE: EXCESSIVE PGA MEMORY 9i

Title: RE: EXCESSIVE PGA MEMORY 9i Guys, Installed a database - currently doing an upgrade to 9.0.2.2 following instructs in README that says to open migrate then run catpatch.sql. The database is using excessive amounts of memory for process global area. I reduced pga_aggregate_target from

Re: Rebuilding Indexes...

Ditto. Conner did a better job of stating it than I was going to. :) Jared On Monday 30 December 2002 11:08, Connor McDonald wrote: The space saving is good if you are not planning on doing much more with those indexes (ie dml). The space saving might be very very bad if there is lots of

Re: Tales Of Big Hammer #10046 (AKA event 10046)

Title: Tales Of Big Hammer #10046 (AKA event 10046) Generally you won't find "err=1403" text in the raw ".trc" file. Instead, if you carefully examine the FETCH lines, you'll see "r=0" (i.e. zero rows returned) in amongst all the other statistics. Very very difficult to catch and often

Merry Christmas Happy New Year 2003

hi, Merry Christmas and Happy New Year 2003 God Bless You All Po Min -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: root INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

Re: this doesn't look right

I know it's a view. I'm just curious as to why one is varchar2(30) and one is varchar2(4000) when the column names in a constraint are the same ones in a table and should, in theory, be the same size --- Vladimir Begun [EMAIL PROTECTED] wrote: Rachel DBA_CONS_COLUMNS is a view. DECODE is

Re: Memory leak in OCI call

Yes I am using OCIConnectionPoolDestroy. -Naren Tim Gorman [EMAIL PROTECTED] on 12/30/2002 11:03:41 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Narendra Donthineni/HSSBLR) Are you making any calls to

Re: this doesn't look right

ah, that goes along with the you can make the file name any length now feature in Windows :) --- Rodd Holman [EMAIL PROTECTED] wrote: It might be for a new feature, two_page_long_columnames=true ;-) Rodd On Mon, 2002-12-30 at 14:23, Rachel Carmichael wrote: As part of the process of

Re: this doesn't look right

while it's interesting that one view has the column name coming from attrcol$ while the other comes from col$, that doesn't answer the basic question of WHY --- Shaleen [EMAIL PROTECTED] wrote: Varchar2(4000) is coming from sys.attrcol$ table. dba_tab_columns does not have a join this table.

Re: this doesn't look right

but the name you see in dba_cons_columns doesn't show the user_data. part! --- Shaleen [EMAIL PROTECTED] wrote: Looking at contents of attrcol$ , name column can have more than 30 characters since it seems to be joining 2 attributes OBJ#INTCOL# NAME -- --

Re: this doesn't look right

In case of object tables, the constraints are defined on the most primitive of the objects. For instance, you have a table MYTAB defined on an object type MYTYPE1 which references in MYTYPE2. An attribute of MYTYPE2, ATTR1 has the constraint defined as not null. In this case the column_name in

Re: this doesn't look right

Rachel Carmichael wrote: I know it's a view. I'm just curious as to why one is varchar2(30) and one is varchar2(4000) when the column names in a constraint are the same ones in a table and should, in theory, be the same size Rachel, I've replied Rodd's message with self-explanatory example,