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 partitioned index INDEX: on sol_id, tran_date, gl_sub_Head_code and crncy_code, globally partitioned on range of tran_date TABLE: GST table with 10 million rows, with 2 equal partitions on range of tran_date Query: Select queries with key, returning 500 rows. select crncy_code into :b0 from gst_part where (((sol_id=:b1 and tran_date=:b2) and gl_sub_head_code=:b3) and crncy_code=:b0) call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.12 0.35 46 526 0 0 Execute 500 0.04 0.03 0 0 0 0 Fetch 500 0.01 0.01 16 2000 0 500 --- -- -- -- -- -- -- total 1001 0.17 0.40 62 2526 0 500 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 5 (SYSTEM) Rows Row Source Operation --- --- 500 PARTITION RANGE SINGLE PARTITION: KEY KEY (cr=2000 r=16 w=0 time=10503 us) 500 INDEX UNIQUE SCAN OBJ#(26318) PARTITION: KEY KEY (cr=2000 r=16 w=0 time=9188 us)(object id 26318) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 500 PARTITION RANGE (SINGLE) PARTITION:KEYKEY 500 INDEX (UNIQUE SCAN) OF 'IDX_GL_SUB_HEAD_TRAN_PART' (UNIQUE) PARTITION:KEYKEY CASE 1: Comparison with non-prefixed index INDEX: Non-prefixed on sol_id, tran_date, gl_sub_head_code and crncy_code TABLE: GST table with 10 million rows with 2 equal partitions on range of tran_date select crncy_code into :b0 from gst_part where (((sol_id=:b1 and tran_date=:b2) and gl_sub_head_code=:b3) and crncy_code=:b0) call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.12 0.34 42 422 0 0 Execute 500 0.02 0.03 0 0 0 0 Fetch 500 0.03 0.07 14 2000 0 500 --- -- -- -- -- -- -- total 1001 0.17 0.45 56 2422 0 500 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 5 (SYSTEM) Rows Row Source Operation --- --- 500 PARTITION RANGE SINGLE PARTITION: KEY KEY (cr=2000 r=14 w=0 time=70754 us) 500 INDEX UNIQUE SCAN OBJ#(26279) PARTITION: KEY KEY (cr=2000 r=14 w=0 time=69432 us)(object id 26279) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 500 PARTITION RANGE (SINGLE) PARTITION:KEYKEY 500 INDEX (UNIQUE SCAN) OF 'IDX_GL_SUB_HEAD_TRAN_PART' (UNIQUE) PARTITION:KEYKEY CASE 2: Comparison with prefixed index INDEX: on tran_date,sol_id, gl_sub_head_code and crncy_code TABLE: GST table with 10 million rows with 2 equal partitions, on range of tran_date select crncy_code into :b0 from gst_part where (((sol_id=:b1 and tran_date=:b2) and gl_sub_head_code=:b3) and crncy_code=:b0) call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.00 0.00 0 0 0 0 Execute 500 0.02 0.02 0 0 0 0 Fetch 500 0.02 0.04 16 2000 0 500 --- -- -- -- -- -- -- total 1001 0.04 0.07 16 2000 0 500 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 5 (SYSTEM) Rows
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 percentage proportion ratios of Checking Overhead TO execution ( INSERT ) overhead ? Any Docs , Links on such ? Thanks -Original Message- Sent: Thursday, July 24, 2003 8:42 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Qs 1) Whenever an Account ID is transacted - INSERT occurs into a table TRAN_TBL as part of the transaction , Additionally the Account ID is checked for existence in another table say TABLE_1 . If found , a record is inserted into yet another table say TABLE_2 . Qs. Operations involving TABLE_1 TABLE_2 if managed using triggers , How expensive in CPU performance will it be ? NOTE - TRAN_TBL undergoes very large volumes of Concurrent OLTP INSERT transaction . Qs 2) If an alert is to be raised on addition of a new record to TABLE_2 :- a) Can trigger be used ? b) Should a cron job running every 5 min. look at TABLE_2 based on the time criteria generates the alert ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 (word,ppt' etc) are indexed
automatically (m running the ctxsrv)
the ctxsys.ctx_index_errors tables show the
following error when i try to index...
DRG-11101: failed to open file
C:\WINNT\TEMP\drgut27
i have searched metalink, and it says to create a
new filter.. i did that too..
SQL exec
ctx_ddl.create_preference('myfilter', 'USER_FILTER');
SQL exec
ctx_ddl.set_attribute('myfilter', 'command', 'auto_filt.bat');
SQL create index idx_documents on
documents(blob_content)INDEXTYPE is ctxsys.contextparameters
('filter myfilter section group ctxsys.html_section_group');
but still the PDF's do not appear in index !!!, all
metalink docs point to ORA_HOME/ctx/bin directory !!
but i could not locate the directory on my NT
server !!! very wierd indeed...
again.. the indexing works for all other formats...
other than PDF's
TIA
Rahul
The
information contained in this email and its attachments if any may contain
privileged and confidential information intended only for the attention of
the recipient(s) specified. If you are not a recipient , any forwarding ,
disclosure , photocopying , distribution or use of the information in any
way is prohibited . If you have received this email in error , please email
us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522
8775.-
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 raw volumes for the redologs should put the log file sync waits down in the top-n. Indeed, the direct path writes have a neglible effect on overall response time. I just want to get a good understanding of the 'direct path writes'. sorts (disk) =4 physical writes direct = 2,444,555 physical writes = 2,470,809 Those are statistics gathered in a two hour interval. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 29 Jul 2003 10:14:29 -0800 But, I would like to know how this seemingly high wait for 'direct path write' is affecting the overall response time. (ResponseTime = WaitTime + ServiceTime) If the 'CPU used by this session' is not considered in light of these wait times, aren't you getting ready to bark at the wrong tree? - Kirti --- John Kanagaraj [EMAIL PROTECTED] wrote: Hans, Now let me guess Your disks are all RAID 5, right? And you possibly are bottlenecking on CPU as well? It is clear from the Top 5 that writes are an issue across the board, to TEMP (direct path write), Redo (log file sync) and DB files (db file parallel writes). Creating a RAID 1 set of disks and moving at least the TEMP, RBS, Redo (and Arch if present) to this will definitely help. John Kanagaraj Phone: 408-970-7002 (W) Fax: 408 327 3086 (Call/Email prior to fax) -Original Message- Sent: Tuesday, July 29, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- direct path write 304,867 35,925 49.83 log file sync 145,015 23,441 32.52 db file sequential read11,3703,684 5.11 file open 9813,326 4.61 db file parallel write 1,8933,115 4.32 You'll notice that 'direct path write' is the most expensive one in the list. I cannot find enough info on the net about this wait event, therefore I'm asking the real experts. What events in Oracle trigger this wait event? In what way is this event different from db file parallel write? I mostly read comments that suggest lots of sorting and parallallel queries. However, most sorts are done in memory and degree = 0 for all tables. Any suggestions are very welcome. Thanks, Hans de Git __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 of list ORACLE-LSubject: 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 partitioned index INDEX: on sol_id, tran_date, gl_sub_Head_code and crncy_code, globally partitioned on range of tran_date TABLE: GST table with 10 million rows, with 2 equal partitions on range of tran_date Query: Select queries with key, returning 500 rows. select crncy_code into :b0 from gst_part where (((sol_id=:b1 and tran_date=:b2) and gl_sub_head_code=:b3) and crncy_code=:b0) call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.12 0.35 46 526 0 0 Execute 500 0.04 0.03 0 0 0 0 Fetch 500 0.01 0.01 16 2000 0 500 --- -- -- -- -- -- -- total 1001 0.17 0.40 62 2526 0 500 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 5 (SYSTEM) Rows Row Source Operation --- --- 500 PARTITION RANGE SINGLE PARTITION: KEY KEY (cr=2000 r=16 w=0 time=10503 us) 500 INDEX UNIQUE SCAN OBJ#(26318) PARTITION: KEY KEY (cr=2000 r=16 w=0 time=9188 us)(object id 26318) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 500 PARTITION RANGE (SINGLE) PARTITION:KEYKEY 500 INDEX (UNIQUE SCAN) OF 'IDX_GL_SUB_HEAD_TRAN_PART' (UNIQUE) PARTITION:KEYKEY CASE 1: Comparison with non-prefixed index INDEX: Non-prefixed on sol_id, tran_date, gl_sub_head_code and crncy_code TABLE: GST table with 10 million rows with 2 equal partitions on range of tran_date select crncy_code into :b0 from gst_part where (((sol_id=:b1 and tran_date=:b2) and gl_sub_head_code=:b3) and crncy_code=:b0) call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.12 0.34 42 422 0 0 Execute 500 0.02 0.03 0 0 0 0 Fetch 500 0.03 0.07 14 2000 0 500 --- -- -- -- -- -- -- total 1001 0.17 0.45 56 2422 0 500 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 5 (SYSTEM) Rows Row Source Operation --- --- 500 PARTITION RANGE SINGLE PARTITION: KEY KEY (cr=2000 r=14 w=0 time=70754 us) 500 INDEX UNIQUE SCAN OBJ#(26279) PARTITION: KEY KEY (cr=2000 r=14 w=0 time=69432 us)(object id 26279) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 500 PARTITION RANGE (SINGLE) PARTITION:KEYKEY 500 INDEX (UNIQUE SCAN) OF 'IDX_GL_SUB_HEAD_TRAN_PART' (UNIQUE) PARTITION:KEYKEY CASE 2: Comparison with prefixed index INDEX: on tran_date,sol_id, gl_sub_head_code and crncy_code TABLE: GST table with 10 million rows with 2 equal partitions, on range of tran_date select crncy_code into :b0 from gst_part where (((sol_id=:b1 and tran_date=:b2) and gl_sub_head_code=:b3) and crncy_code=:b0) call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.00 0.00 0 0 0 0 Execute 500 0.02 0.02 0 0 0 0 Fetch 500 0.02 0.04 16 2000 0 500 --- -- -- -- -- -- -- total 1001 0.04 0.07 16 2000
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 with this.?? The only thing that I can see is a trace file (I don't know if this is from the same time as when the database stopped serving requests) from the archiver. There is nothing in the alert log whatsoever. Is it normal behaviour that logswitches are recorded to trace files?? I have stopped the archiver process to see if that makes the problem go away. * [EMAIL PROTECTED] bdump]$ ls alert_Ora92.log ora92_arc0_2583.trc ora92_arc0_2674.trc ora92_arc0_10031.trc ora92_arc0_2597.trc ora92_arc0_2710.trc ora92_arc0_10498.trc ora92_arc0_2629.trc ora92_arc0_2842.trc ora92_arc0_10533.trc ora92_arc0_2634.trc ora92_arc0_5115.trc ora92_arc0_10557.trc ora92_arc0_2651.trc ora92_arc0_8432.trc ora92_arc0_14874.trc ora92_arc0_2657.trc ora92_arc0_8607.trc [EMAIL PROTECTED] bdump]$ cat *14874* /oracle/oradata/admin/Ora92/bdump/ora92_arc0_14874.trc Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production ORACLE_HOME = /oracle/app/product/9.2.0 System name: Linux Node name: Linux Release: 2.4.20-18.9 Version: #1 Thu May 29 07:08:16 EDT 2003 Machine: i686 Instance name: Ora92 Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 14874, image: [EMAIL PROTECTED] (ARC0) *** SESSION ID:(7.1) 2003-07-30 09:24:33.995 - Created archivelog as '/data/oradata/Ora92/archive/1_57.dbf' [EMAIL PROTECTED] bdump]$ df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/hdc2 10078852 7872268 1694596 83% / /dev/hdc1 99043 14310 79619 16% /boot none 256892 0 256892 0% /dev/shm /dev/hdc4 66542832 6880604 56282028 11% /data [EMAIL PROTECTED] bdump]$ ls -l /data//oradata/Ora92/archive/ total 8124 -rw-r- 1 oracle dba 452096 Jul 27 13:33 1_55.dbf -rw-r- 1 oracle dba 1085952 Jul 28 08:56 1_56.dbf -rw-r- 1 oracle dba 6752256 Jul 30 09:24 1_57.dbf [EMAIL PROTECTED] bdump]$ PARAMETER SETTINGS: *.background_dump_dest='/oracle/oradata/admin/Ora92/bdump' *.compatible='9.2.0.0.0' *.control_files='/oracle/oradata/Ora92/control01.ctl','/oracle/oradata/Ora92/control02.ctl','/oracle/oradata/Ora92/control03.ctl' *.core_dump_dest='/oracle/oradata/admin/Ora92/cdump' *.db_block_size=8192 *.db_cache_size=8388608 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='Ora92' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='Ora92' *.java_pool_size=0 *.large_pool_size=8388608 *.log_archive_dest_1='LOCATION=/data/oradata/Ora92/archive' *.log_archive_format='%t_%s.dbf' *.log_archive_start=true *.nls_date_language='DUTCH' *.nls_language='DUTCH' *.nls_numeric_characters=',.' *.open_cursors=300 *.pga_aggregate_target=25165824 *.processes=150 *.query_rewrite_enabled='FALSE' *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_reserved_size=4194304 *.shared_pool_size=8388608 *.sort_area_size=2097152 *.star_transformation_enabled='FALSE' *.timed_statistics=TRUE *.undo_management='AUTO' *.undo_retention=10800 *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/oracle/oradata/admin/Ora92/udump' *** TIA Jack
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 PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:34 AM
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 raw
volumes for the redologs should put the log file sync waits down in the
top-n.
Indeed, the direct path writes have a neglible effect on overall response
time. I just want to get a good understanding of the 'direct path writes'.
sorts (disk) =4
physical writes direct = 2,444,555
physical writes = 2,470,809
Those are statistics gathered in a two hour interval.
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 29 Jul 2003 10:14:29 -0800
But, I would like to know how this seemingly high wait for 'direct path
write' is affecting the
overall response time. (ResponseTime = WaitTime + ServiceTime)
If the 'CPU used by this session' is not considered in light of these wait
times, aren't you
getting ready to bark at the wrong tree?
- Kirti
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Hans,
Now let me guess Your disks are all RAID 5, right? And you possibly
are
bottlenecking on CPU as well? It is clear from the Top 5 that writes
are
an
issue across the board, to TEMP (direct path write), Redo (log file
sync)
and DB files (db file parallel writes). Creating a RAID 1 set of disks
and
moving at least the TEMP, RBS, Redo (and Arch if present) to this will
definitely help.
John Kanagaraj
Phone: 408-970-7002 (W)
Fax: 408 327 3086 (Call/Email prior to fax)
-Original Message-
Sent: Tuesday, July 29, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Please help me tune this i/o related wait event. This is my 8.1.6
statspack
top-5 wait list:
Top 5 Wait Events
~ Wait
%
Total
Event Waits Time (cs)
Wt
Time
---
direct path write 304,867 35,925
49.83
log file sync 145,015 23,441
32.52
db file sequential read11,3703,684
5.11
file open 9813,326
4.61
db file parallel write 1,8933,115
4.32
You'll notice that 'direct path write' is the most expensive one in the
list. I cannot find enough info on the net about this wait event,
therefore
I'm asking the real experts.
What events in Oracle trigger this wait event? In what way is this
event
different from db file parallel write?
I mostly read comments that suggest lots of sorting and parallallel
queries.
However, most sorts are done in memory and degree = 0 for all tables.
Any suggestions are very welcome.
Thanks,
Hans de Git
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
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 99.6% idleMem: 513788k av, 506088k used, 7700k free, 0k shrd, 117192k buff 386908k actv, 39520k in_d, 9728k in_cSwap: 2097136k av, 22708k used, 2074428k free 257980k cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND15439 root 15 0 1164 1164 864 R 0.3 0.2 0:00 0 top 1 root 15 0 104 88 52 S 0.0 0.0 0:06 0 init 2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd 3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd 4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd_CPU 9 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush 5 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kswapd 6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/DMA 7 root 15 0 0 0 0 SW 0.0 0.0 5:18 0 kscand/Normal 8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/HighMe 10 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated 11 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd 15 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald ** Strange indeed. Jack Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 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 Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]Sent: Wednesday, 30 July 2003 6:44 PMTo: Multiple recipients of list ORACLE-LSubject: 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 with this.?? The only thing that I can see is a trace file (I don't know if this is from the same time as when the database stopped serving requests) from the archiver. There is nothing in the alert log whatsoever. Is it normal behaviour that logswitches are recorded to trace files?? I have stopped the archiver process to see if that makes the problem go away. * [EMAIL PROTECTED] bdump]$ ls alert_Ora92.log ora92_arc0_2583.trc ora92_arc0_2674.trc ora92_arc0_10031.trc ora92_arc0_2597.trc ora92_arc0_2710.trc ora92_arc0_10498.trc ora92_arc0_2629.trc ora92_arc0_2842.trc ora92_arc0_10533.trc ora92_arc0_2634.trc ora92_arc0_5115.trc ora92_arc0_10557.trc ora92_arc0_2651.trc ora92_arc0_8432.trc ora92_arc0_14874.trc ora92_arc0_2657.trc ora92_arc0_8607.trc [EMAIL PROTECTED] bdump]$ cat *14874* /oracle/oradata/admin/Ora92/bdump/ora92_arc0_14874.trc Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production ORACLE_HOME = /oracle/app/product/9.2.0 System name: Linux Node name: Linux Release: 2.4.20-18.9 Version: #1 Thu May 29 07:08:16 EDT 2003 Machine: i686 Instance name: Ora92 Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 14874, image: [EMAIL PROTECTED] (ARC0) *** SESSION ID:(7.1) 2003-07-30 09:24:33.995 - Created archivelog as '/data/oradata/Ora92/archive/1_57.dbf' [EMAIL PROTECTED] bdump]$ df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/hdc2 10078852 7872268 1694596 83% / /dev/hdc1 99043 14310 79619 16% /boot none 256892 0 256892 0% /dev/shm /dev/hdc4 66542832 6880604 56282028 11% /data [EMAIL PROTECTED] bdump]$ ls -l /data//oradata/Ora92/archive/ total 8124 -rw-r- 1 oracle dba 452096 Jul 27 13:33 1_55.dbf -rw-r- 1 oracle dba 1085952 Jul 28 08:56 1_56.dbf -rw-r- 1 oracle dba 6752256 Jul 30 09:24 1_57.dbf [EMAIL PROTECTED] bdump]$ PARAMETER SETTINGS: *.background_dump_dest='/oracle/oradata/admin/Ora92/bdump' *.compatible='9.2.0.0.0' *.control_files='/oracle/oradata/Ora92/control01.ctl','/oracle/oradata/Ora92/control02.ctl','/oracle/oradata/Ora92/control03.ctl' *.core_dump_dest='/oracle/oradata/admin/Ora92/cdump' *.db_block_size=8192 *.db_cache_size=8388608 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='Ora92' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='Ora92' *.java_pool_size=0 *.large_pool_size=8388608
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 open/edit/save a file on a remote host via ftp. It appears that tp does that only w/a supporting batch file (yuck!). Imagine my delighted cackling, having proven once and for all that ue is the one true windows text editor... 8^) It's never been an issue for me ... tightVNC being the wonderful beast it is, I've gotten used to in-place editing through a vnc session. Big benefit being that a dropped session can be picked up again ... not easy if your FTP transfer fails :-). That said, I can see the benefits of bringing the mountain to you :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]Sent: Wednesday, 30 July 2003 6:44 PMTo: Multiple recipients of list ORACLE-LSubject: 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 with this.?? The only thing that I can see is a trace file (I don't know if this is from the same time as when the database stopped serving requests) from the archiver. There is nothing in the alert log whatsoever. Is it normal behaviour that logswitches are recorded to trace files?? I have stopped the archiver process to see if that makes the problem go away. * [EMAIL PROTECTED] bdump]$ ls alert_Ora92.log ora92_arc0_2583.trc ora92_arc0_2674.trc ora92_arc0_10031.trc ora92_arc0_2597.trc ora92_arc0_2710.trc ora92_arc0_10498.trc ora92_arc0_2629.trc ora92_arc0_2842.trc ora92_arc0_10533.trc ora92_arc0_2634.trc ora92_arc0_5115.trc ora92_arc0_10557.trc ora92_arc0_2651.trc ora92_arc0_8432.trc ora92_arc0_14874.trc ora92_arc0_2657.trc ora92_arc0_8607.trc [EMAIL PROTECTED] bdump]$ cat *14874* /oracle/oradata/admin/Ora92/bdump/ora92_arc0_14874.trc Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production ORACLE_HOME = /oracle/app/product/9.2.0 System name: Linux Node name: Linux Release: 2.4.20-18.9 Version: #1 Thu May 29 07:08:16 EDT 2003 Machine: i686 Instance name: Ora92 Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 14874, image: [EMAIL PROTECTED] (ARC0) *** SESSION ID:(7.1) 2003-07-30 09:24:33.995 - Created archivelog as '/data/oradata/Ora92/archive/1_57.dbf' [EMAIL PROTECTED] bdump]$ df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/hdc2 10078852 7872268 1694596 83% / /dev/hdc1 99043 14310 79619 16% /boot none 256892 0 256892 0% /dev/shm /dev/hdc4 66542832 6880604 56282028 11% /data [EMAIL PROTECTED] bdump]$ ls -l /data//oradata/Ora92/archive/ total 8124 -rw-r- 1 oracle dba 452096 Jul 27 13:33 1_55.dbf -rw-r- 1 oracle dba 1085952 Jul 28 08:56 1_56.dbf -rw-r- 1 oracle dba 6752256 Jul 30 09:24 1_57.dbf [EMAIL PROTECTED] bdump]$ PARAMETER SETTINGS: *.background_dump_dest='/oracle/oradata/admin/Ora92/bdump' *.compatible='9.2.0.0.0' *.control_files='/oracle/oradata/Ora92/control01.ctl','/oracle/oradata/Ora92/control02.ctl','/oracle/oradata/Ora92/control03.ctl' *.core_dump_dest='/oracle/oradata/admin/Ora92/cdump' *.db_block_size=8192 *.db_cache_size=8388608 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='Ora92' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='Ora92' *.java_pool_size=0 *.large_pool_size=8388608 *.log_archive_dest_1='LOCATION=/data/oradata/Ora92/archive' *.log_archive_format='%t_%s.dbf' *.log_archive_start=true *.nls_date_language='DUTCH' *.nls_language='DUTCH' *.nls_numeric_characters=',.' *.open_cursors=300 *.pga_aggregate_target=25165824 *.processes=150 *.query_rewrite_enabled='FALSE' *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_reserved_size=4194304 *.shared_pool_size=8388608 *.sort_area_size=2097152 *.star_transformation_enabled='FALSE' *.timed_statistics=TRUE *.undo_management='AUTO' *.undo_retention=10800 *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/oracle/oradata/admin/Ora92/udump' *** TIA Jack
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, then I think I should increase sort_area_size and/or
hash_area_size (memory is not an issue...). Please correct me if i'm wrong.
Would it be beneficial to change optimizer_index_caching or
optimizer_index_cost_adj to force Oracle into using more nested loops?
Don't get me wrong: I'm all against throwing hardware at an application that
is so poorly written. But we've past that point, the supplier will not
change its behaviour, and from a functional point of view, the end-users are
very satisfied. Bummer..
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 30 Jul 2003 01:24:24 -0800
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.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:34 AM
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 raw
volumes for the redologs should put the log file sync waits down in the
top-n.
Indeed, the direct path writes have a neglible effect on overall response
time. I just want to get a good understanding of the 'direct path
writes'.
sorts (disk) =4
physical writes direct = 2,444,555
physical writes = 2,470,809
Those are statistics gathered in a two hour interval.
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 29 Jul 2003 10:14:29 -0800
But, I would like to know how this seemingly high wait for 'direct path
write' is affecting the
overall response time. (ResponseTime = WaitTime + ServiceTime)
If the 'CPU used by this session' is not considered in light of these
wait
times, aren't you
getting ready to bark at the wrong tree?
- Kirti
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Hans,
Now let me guess Your disks are all RAID 5, right? And you
possibly
are
bottlenecking on CPU as well? It is clear from the Top 5 that writes
are
an
issue across the board, to TEMP (direct path write), Redo (log file
sync)
and DB files (db file parallel writes). Creating a RAID 1 set of disks
and
moving at least the TEMP, RBS, Redo (and Arch if present) to this will
definitely help.
John Kanagaraj
Phone: 408-970-7002 (W)
Fax: 408 327 3086 (Call/Email prior to fax)
-Original Message-
Sent: Tuesday, July 29, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Please help me tune this i/o related wait event. This is my 8.1.6
statspack
top-5 wait list:
Top 5 Wait Events
~ Wait
%
Total
Event Waits Time (cs)
Wt
Time
---
direct path write 304,867 35,925
49.83
log file sync 145,015 23,441
32.52
db file sequential read11,3703,684
5.11
file open 9813,326
4.61
db file parallel write 1,8933,115
4.32
You'll notice that 'direct path write' is the most expensive one in
the
list. I cannot find enough info on the net about this wait event,
therefore
I'm asking the real experts.
What events in Oracle trigger this wait event? In what way is this
event
different from db file parallel write?
I mostly read comments that suggest lots of sorting and parallallel
queries.
However, most sorts are done in memory and degree = 0 for all tables.
Any suggestions are very welcome.
Thanks,
Hans de Git
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
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 execution plan for these statements to see whether they are using hash joins (since you are on 8.1.6, it can be bit problematic, because execution path information is stored in raw trace file starting from 8.1.7 AFAIK. Problematic in sense that, when doing explain plan under regular session, some session parameters might be different than using the application). But if you find out, that statements with hash join execution plans are the ones waiting on direct path access on temp datafiles, you should also enable event 10104 at level 1 to get hash join trace information. Maybe your statistics are not up to date, that CBO thinks based on ancient statistics it's good idea to hash join because one row set is fairly small, but when it starts building hash build partitions, they actually don't fit into hash area, and some of the partitions have to be written to temp. Check under PHASE 1 in 10104 trace, how many total build partitions you got and how may of them fit into memory. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:14 PM 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, then I think I should increase sort_area_size and/or hash_area_size (memory is not an issue...). Please correct me if i'm wrong. Would it be beneficial to change optimizer_index_caching or optimizer_index_cost_adj to force Oracle into using more nested loops? Don't get me wrong: I'm all against throwing hardware at an application that is so poorly written. But we've past that point, the supplier will not change its behaviour, and from a functional point of view, the end-users are very satisfied. Bummer.. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 30 Jul 2003 01:24:24 -0800 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. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:34 AM 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 raw volumes for the redologs should put the log file sync waits down in the top-n. Indeed, the direct path writes have a neglible effect on overall response time. I just want to get a good understanding of the 'direct path writes'. sorts (disk) =4 physical writes direct = 2,444,555 physical writes = 2,470,809 Those are statistics gathered in a two hour interval. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 29 Jul 2003 10:14:29 -0800 But, I would like to know how this seemingly high wait for 'direct path write' is affecting the overall response time. (ResponseTime = WaitTime + ServiceTime) If the 'CPU used by this session' is not considered in light of these wait times, aren't you getting ready to bark at the wrong tree? - Kirti --- John Kanagaraj [EMAIL PROTECTED] wrote: Hans, Now let me guess Your disks are all RAID 5, right? And you possibly are bottlenecking on CPU as well? It is clear from the Top 5 that writes are an issue across the board, to TEMP (direct path write), Redo (log file sync) and DB files (db file parallel writes). Creating a RAID 1 set of disks and moving at least the TEMP, RBS, Redo (and Arch if present) to this will definitely help. John Kanagaraj Phone: 408-970-7002 (W) Fax: 408 327 3086 (Call/Email prior to fax) -Original Message- Sent: Tuesday, July 29, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~ Wait % Total Event
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 elaborate what could be the problem for this error. Regards, Shankar This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com
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 joins. It's a production system; I can only peek via the perfstat schema, but I know the application and instance well enough. Case closed, as far as I'm concerned. Thank you all for the input. Regards, Hans de Git Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 30 Jul 2003 03:59:23 -0800 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 execution plan for these statements to see whether they are using hash joins (since you are on 8.1.6, it can be bit problematic, because execution path information is stored in raw trace file starting from 8.1.7 AFAIK. Problematic in sense that, when doing explain plan under regular session, some session parameters might be different than using the application). But if you find out, that statements with hash join execution plans are the ones waiting on direct path access on temp datafiles, you should also enable event 10104 at level 1 to get hash join trace information. Maybe your statistics are not up to date, that CBO thinks based on ancient statistics it's good idea to hash join because one row set is fairly small, but when it starts building hash build partitions, they actually don't fit into hash area, and some of the partitions have to be written to temp. Check under PHASE 1 in 10104 trace, how many total build partitions you got and how may of them fit into memory. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:14 PM 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, then I think I should increase sort_area_size and/or hash_area_size (memory is not an issue...). Please correct me if i'm wrong. Would it be beneficial to change optimizer_index_caching or optimizer_index_cost_adj to force Oracle into using more nested loops? Don't get me wrong: I'm all against throwing hardware at an application that is so poorly written. But we've past that point, the supplier will not change its behaviour, and from a functional point of view, the end-users are very satisfied. Bummer.. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 30 Jul 2003 01:24:24 -0800 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. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:34 AM 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 raw volumes for the redologs should put the log file sync waits down in the top-n. Indeed, the direct path writes have a neglible effect on overall response time. I just want to get a good understanding of the 'direct path writes'. sorts (disk) =4 physical writes direct = 2,444,555 physical writes = 2,470,809 Those are statistics gathered in a two hour interval. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 29 Jul 2003 10:14:29 -0800 But, I would like to know how this seemingly high wait for 'direct path write' is affecting the overall response time. (ResponseTime = WaitTime + ServiceTime) If the 'CPU used by this session' is not considered in light of these wait times, aren't you getting ready to bark at the wrong tree? - Kirti --- John Kanagaraj [EMAIL PROTECTED] wrote: Hans, Now let me guess Your disks are all RAID 5, right? And you possibly are bottlenecking on CPU as well? It is clear from the Top 5 that writes are an issue across the board, to TEMP (direct path write), Redo (log file sync) and DB files (db file parallel
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 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 elaborate what could be the problem for this error. Regards, Shankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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, Linux Intel, and Sun Solaris 2-20 Installation Guide Perform the following steps to modify the kernel parameters by using the /proc file system. 1. Log in as the root user. 2. Change to the /proc/sys/kernel directory. 3. Review the current semaphore parameter values in the sem file by using the cat or more utility. For example, using the cat utility, enter the following command: # cat sem The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM, and SEMMNI parameters. The following example shows how the output appears: 250 32000 32 128 In the preceding output example, 250 is the value of the SEMMSL parameter, 32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM parameter, and 128 is the value of the SEMMNI parameter. 4. Modify the parameter values by using the following command syntax: # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value sem Replace the parameter variables with the values for your system in the order that they are entered in the preceding example. For example: # echo 100 32000 100 100 sem 5. Review the current shared memory parameters by using the cat or more utility. For example, using the cat utility, enter the following command: # cat shared_memory_parameter In the preceding example, the variable shared_memory_parameter is either the SHMMAX or SHMMNI parameter. The parameter name must be entered in lowercase letters. 6. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMAX parameter, enter the following command: # echo 2147483648 shmmax 7. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMNI parameter, enter the following command: Setup Tasks to Perform as root User # echo 4096 shmmni 8. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMALL parameter, enter the following command: # echo 2097152 shmall 9. Write a script to initialize these values during system startup, and include the script in your system init files. 10. Set the File Handles by using ulimit -n and /proc/sys/fs/file-max. # echo 65536 /proc/sys/fs/file-max ulimit -n 65536 11. Set the Sockets to /proc/sys/net/ipv4/ip_local_port_range # echo 1024 65000 /proc/sys/net/ipv4/ip_local_port_change 12. Set the Process limit by using ulimit -u. This will give you the number of processes per user. ulimit -u 16384 The parameters in the following table are the minimum values required to run Oracle9i with a single-database instance on Linux. See Also: Your system vendor's documentation for more information on script files and init files. Sandro Augusto da Silva Technology Services Support NLA Technology Services Phone: +55 11 3398-8438 Fax: +55 11 3398-7522 -Mensagem original- De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 06:39 Para: Multiple recipients of list ORACLE-L Assunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 512Mb RAM 2Gb Swap space 10:44:37 up 2 days, 21:15, 4 users, load average: 0.00, 0.05, 0.03 119 processes: 115 sleeping, 4 running, 0 zombie, 0 stopped CPU states: 0.3% user 0.0% system 0.0% nice 0.0% iowait 99.6% idle Mem: 513788k av, 506088k used, 7700k free, 0k shrd, 117192k buff 386908k actv, 39520k in_d, 9728k in_c Swap: 2097136k av, 22708k used, 2074428k free 257980k cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND 15439 root 15 0 1164 1164 864 R 0.3 0.2 0:00 0 top 1 root 15 0 104 88 52 S 0.0 0.0 0:06 0 init 2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd 3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd 4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd_CPU 9 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush 5 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kswapd 6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/DMA 7 root 15 0 0 0 0 SW 0.0 0.0 5:18 0 kscand/Normal 8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/HighMe 10 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated 11 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd 15 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald ** Strange indeed. Jack Original Message- From: Suhen Pather [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: 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
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 shmmax536870912[EMAIL PROTECTED] kernel]# cat shmmni4096[EMAIL PROTECTED] kernel]# cat shmall2097152[EMAIL PROTECTED] kernel]# ulimit -u4095[EMAIL PROTECTED] kernel]# cat /proc/sys/net/ipv4/ip_local_port_range1024 65000[EMAIL PROTECTED] kernel]# cat /proc/sys/fs/file-max65536[EMAIL PROTECTED] kernel]# Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 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, Linux Intel, and Sun Solaris 2-20 Installation Guide Perform the following steps to modify the kernel parameters by using the /proc file system. 1. Log in as the root user. 2. Change to the /proc/sys/kernel directory. 3. Review the current semaphore parameter values in the sem file by using the cat or more utility. For example, using the cat utility, enter the following command: # cat sem The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM, and SEMMNI parameters. The following example shows how the output appears: 250 32000 32 128 In the preceding output example, 250 is the value of the SEMMSL parameter, 32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM parameter, and 128 is the value of the SEMMNI parameter. 4. Modify the parameter values by using the following command syntax: # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value sem Replace the parameter variables with the values for your system in the order that they are entered in the preceding example. For example: # echo 100 32000 100 100 sem 5. Review the current shared memory parameters by using the cat or more utility. For example, using the cat utility, enter the following command: # cat shared_memory_parameter In the preceding example, the variable shared_memory_parameter is either the SHMMAX or SHMMNI parameter. The parameter name must be entered in lowercase letters. 6. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMAX parameter, enter the following command: # echo 2147483648 shmmax 7. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMNI parameter, enter the following command: Setup Tasks to Perform as root User # echo 4096 shmmni 8. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMALL parameter, enter the following command: # echo 2097152 shmall 9. Write a script to initialize these values during system startup, and include the script in your system init files. 10. Set the File Handles by using ulimit -n and /proc/sys/fs/file-max. # echo 65536 /proc/sys/fs/file-max ulimit -n 65536 11. Set the Sockets to /proc/sys/net/ipv4/ip_local_port_range # echo 1024 65000 /proc/sys/net/ipv4/ip_local_port_change 12. Set the Process limit by using ulimit -u. This will give you the number of processes per user. ulimit -u 16384 The parameters in the following table are the minimum values required to run Oracle9i with a single-database instance on Linux. See Also: Your system vendor's documentation for more information on script files and init files. Sandro Augusto da SilvaTechnology Services SupportNLA Technology ServicesPhone: +55 11 3398-8438Fax: +55 11 3398-7522 -Mensagem original-De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 06:39Para: Multiple recipients of list ORACLE-LAssunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 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 99.6% idleMem: 513788k av, 506088k used, 7700k free, 0k shrd,
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 . Thanks, -ak Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it.
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 original- De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 09:59 Para: Multiple recipients of list ORACLE-L Assunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 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 sem 250 32000 100 128 [EMAIL PROTECTED] kernel]# cat shmmax 536870912 [EMAIL PROTECTED] kernel]# cat shmmni 4096 [EMAIL PROTECTED] kernel]# cat shmall 2097152 [EMAIL PROTECTED] kernel]# ulimit -u 4095 [EMAIL PROTECTED] kernel]# cat /proc/sys/net/ipv4/ip_local_port_range 1024 65000 [EMAIL PROTECTED] kernel]# cat /proc/sys/fs/file-max 65536 [EMAIL PROTECTED] kernel]# Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax) Thx -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 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, Linux Intel, and Sun Solaris 2-20 Installation Guide Perform the following steps to modify the kernel parameters by using the /proc file system. 1. Log in as the root user. 2. Change to the /proc/sys/kernel directory. 3. Review the current semaphore parameter values in the sem file by using the cat or more utility. For example, using the cat utility, enter the following command: # cat sem The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM, and SEMMNI parameters. The following example shows how the output appears: 250 32000 32 128 In the preceding output example, 250 is the value of the SEMMSL parameter, 32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM parameter, and 128 is the value of the SEMMNI parameter. 4. Modify the parameter values by using the following command syntax: # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value sem Replace the parameter variables with the values for your system in the order that they are entered in the preceding example. For example: # echo 100 32000 100 100 sem 5. Review the current shared memory parameters by using the cat or more utility. For example, using the cat utility, enter the following command: # cat shared_memory_parameter In the preceding example, the variable shared_memory_parameter is either the SHMMAX or SHMMNI parameter. The parameter name must be entered in lowercase letters. 6. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMAX parameter, enter the following command: # echo 2147483648 shmmax 7. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMNI parameter, enter the following command: Setup Tasks to Perform as root User # echo 4096 shmmni 8. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMALL parameter, enter the following command: # echo 2097152 shmall 9. Write a script to initialize these values during system startup, and include the script in your system init files. 10. Set the File Handles by using ulimit -n and /proc/sys/fs/file-max. # echo 65536 /proc/sys/fs/file-max ulimit -n 65536 11. Set the Sockets to /proc/sys/net/ipv4/ip_local_port_range # echo 1024 65000 /proc/sys/net/ipv4/ip_local_port_change 12. Set the Process limit by using ulimit -u. This will give you the number of processes per user. ulimit -u 16384 The parameters in the following table are the minimum values required to run Oracle9i with a single-database instance on Linux. See Also: Your system vendor's documentation for more information on script files and init files. Sandro Augusto da Silva Technology Services Support NLA Technology Services Phone: +55 11 3398-8438 Fax: +55 11 3398-7522 -Mensagem original- De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 06:39 Para: Multiple recipients of list ORACLE-L Assunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 512Mb RAM 2Gb Swap space 10:44:37 up 2 days, 21:15, 4 users, load
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 guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 The parameter shmmax (Shared Memory) is lower than the sugested. Please check: Yours: 536870912 Sugested: 2147483648 Sandro Augusto da SilvaTechnology Services SupportNLA Technology ServicesPhone: +55 11 3398-8438Fax: +55 11 3398-7522 -Mensagem original-De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 09:59Para: Multiple recipients of list ORACLE-LAssunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 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 shmmax536870912[EMAIL PROTECTED] kernel]# cat shmmni4096[EMAIL PROTECTED] kernel]# cat shmall2097152[EMAIL PROTECTED] kernel]# ulimit -u4095[EMAIL PROTECTED] kernel]# cat /proc/sys/net/ipv4/ip_local_port_range1024 65000[EMAIL PROTECTED] kernel]# cat /proc/sys/fs/file-max65536[EMAIL PROTECTED] kernel]# Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 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, Linux Intel, and Sun Solaris 2-20 Installation Guide Perform the following steps to modify the kernel parameters by using the /proc file system. 1. Log in as the root user. 2. Change to the /proc/sys/kernel directory. 3. Review the current semaphore parameter values in the sem file by using the cat or more utility. For example, using the cat utility, enter the following command: # cat sem The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM, and SEMMNI parameters. The following example shows how the output appears: 250 32000 32 128 In the preceding output example, 250 is the value of the SEMMSL parameter, 32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM parameter, and 128 is the value of the SEMMNI parameter. 4. Modify the parameter values by using the following command syntax: # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value sem Replace the parameter variables with the values for your system in the order that they are entered in the preceding example. For example: # echo 100 32000 100 100 sem 5. Review the current shared memory parameters by using the cat or more utility. For example, using the cat utility, enter the following command: # cat shared_memory_parameter In the preceding example, the variable shared_memory_parameter is either the SHMMAX or SHMMNI parameter. The parameter name must be entered in lowercase letters. 6. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMAX parameter, enter the following command: # echo 2147483648 shmmax 7. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMNI parameter, enter the following command: Setup Tasks to Perform as root User # echo 4096 shmmni 8. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMALL parameter, enter the following command: # echo 2097152 shmall 9. Write a script to initialize these values during system startup, and include the script in your system init files. 10. Set the File Handles by using ulimit -n and /proc/sys/fs/file-max. # echo 65536 /proc/sys/fs/file-max ulimit -n 65536 11. Set the Sockets to /proc/sys/net/ipv4/ip_local_port_range # echo 1024 65000
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 recipients of list ORACLE-LSubject: 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
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 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: 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 PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 few (in one of the recent cases - 3) times larger. This is due to Oracle cannot optimize array DML IO once trigger is there. Such applications do not scale well. Impact is much less noticeable when no batch is employed. HTH Vadim -Original Message- Sent: Wednesday, July 30, 2003 4:24 AM To: Multiple recipients of list ORACLE-L ? 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 percentage proportion ratios of Checking Overhead TO execution ( INSERT ) overhead ? Any Docs , Links on such ? Thanks -Original Message- Sent: Thursday, July 24, 2003 8:42 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Qs 1) Whenever an Account ID is transacted - INSERT occurs into a table TRAN_TBL as part of the transaction , Additionally the Account ID is checked for existence in another table say TABLE_1 . If found , a record is inserted into yet another table say TABLE_2 . Qs. Operations involving TABLE_1 TABLE_2 if managed using triggers , How expensive in CPU performance will it be ? NOTE - TRAN_TBL undergoes very large volumes of Concurrent OLTP INSERT transaction . Qs 2) If an alert is to be raised on addition of a new record to TABLE_2 :- a) Can trigger be used ? b) Should a cron job running every 5 min. look at TABLE_2 based on the time criteria generates the alert ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gorbounov,Vadim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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: Multiple recipients of list ORACLE-LSubject: RE: 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 recipients of list ORACLE-LSubject: 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
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! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mandar A. Ghosalkar [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 5:55 PM To: Multiple recipients of list ORACLE-L Subject: 8.1.7.4 interim patch management strategy Hello All, There are 188 interim patches after 8.1.7.4 patchset. I know that 8.1.7.4 is the last patchset. 1. What methods/strategy do you'll have for installing patches on a 8.1.7.4 64 bit hp-ux 11.11 database? 2. Is there opatch for 8.1.7.4? AFAIK opatch is only for 9i. 3. Should one install all the applicable patches (around 180 individual patches)? pessimistic (wait for the bug to hit and db to crash) optimistic (install applicable patches) 4. How to manage the interdependencies between these 180 individual patches? 5. Can we create a hp unix patch depot like thing for all these oracle patches? pls dont advise putting an enhancement request and upgrading to 9i/10i :-) Thanks, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 please tell me wich Character Set you are using in your database ? Thank in advance! Philippe -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: 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 guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 ORACLE-L Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -ak Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht-Von: Grant Allen [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 30. Juli 2003 16:50An: Multiple recipients of list ORACLE-LBetreff: RE: 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: Multiple recipients of list ORACLE-LSubject: RE: 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 recipients of list ORACLE-LSubject: 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
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 can see that they affect the explain plans for some queries quite dramatically. Is there any guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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) 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 official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: 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 guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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: (+27) 82 655 2466 Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED]] Sent: 30 July 2003 16:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: 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, Dick Sent: Wednesday, July 30, 2003 15:29 To: Multiple recipients of list ORACLE-L Subject: RE: Any German here ? Character set WE8ISO8859P1, supports most western europe needs. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: NGUYEN Philippe (Cetelem) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: 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 This email and all contents are subject to the following disclaimer: "http://www.didata.com/disclaimer.asp"
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 the alert log has no references what so ever to "alter tablespace xyz begin backup" and the "... end backup"... While the agent is there and working, I sure see no signs that anything is happening as far as a REAL backup. It's Oracle 9i, but even that, I would think is going to leave some "hints" that all the hooks are working and backup is occurring. Recovery has NEVER been tested. Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
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 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 PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
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 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 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: 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 PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com encoded content removed -- binaries not allowed by ListGuru
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 PROTECTED] wrote: 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 PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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: [EMAIL PROTECTED] Web: www.b2bsol.com The two are related. If recovery has never been properly tested, you don't know if your backups (veritas, rman, ksh/sql scripts) are working. Period. End of story. I've encountered enough software/hardware problems to not trust that an 'error free' backup will be recoverable. If the database is not being taken down, or tablespaces are not being put into backup mode, or RMAN is not being used, I'd suspect that none of the backups are recoverable. Daniel The DBA's job is not to backup the database, but to recover it. Finkbegin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
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 less stiff ;)), so if I go to Austria, I need a pocket translator. And now, working in Switzerland doesn't make things better. Nice mountains, I only wish I understood what the people say ;). To get back to the topic: I'm converting data in Switzerland from Mainframe (VSAM/DB2) to Oracle, and they actually have some extra characters (to my surprise). Stefan -Ursprüngliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 30. Juli 2003 17:29 An: Multiple recipients of list ORACLE-L Betreff: 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 writing in German without umlauts and scharfes S! On 2003.07.30 11:14, Stefan Jahnke wrote: 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 Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.bov.de http://www.bov.de/ Abonnieren Sie unseren Newsletter: http://www.bov.de/enews http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Grant Allen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 30. Juli 2003 16:50 An: Multiple recipients of list ORACLE-L Betreff: RE: Any German here ? Character set I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro support! Ciao Fuzzy :-) -Original Message- Goulet, Dick Sent: Wednesday, July 30, 2003 15:29 To: Multiple recipients of list ORACLE-L WE8ISO8859P1, supports most western europe needs. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 30, 2003 10:04 AM To: Multiple recipients of list ORACLE-L 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 official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Message-From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: 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 the alert log has no references what so ever to "alter tablespace xyz begin backup" and the "... end backup"... While the agent is there and working, I sure see no signs that anything is happening as far as a REAL backup. It's Oracle 9i, but even that, I would think is going to leave some "hints" that all the hooks are working and backup is occurring. Recovery has NEVER been tested. Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
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 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 PROTECTED] wrote: 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 PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
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 channels writing to disk, and as such, I/O is to be expected. I generated statspack reports during the times the backup runs, and the tablespace I/O summary does show high avg reads/ms. Also, I see higher than normal total waits in the tablespace I/O summary. This, I guess, should be the buffer busy wait events, though I dont see it amongst the top 15 wait events. Also, the data block waits in v$waitstat spikes during this backup. So, I was wondering if I these wait events are the real cause of the I/O spike? Thanks Raj Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hia.net cc: Sent by: Subject: Re: buffer busy waits and v$filestat [EMAIL PROTECTED] ity.com 07/29/2003 05:49 PM Please respond to ORACLE-L Buffer busy wait has a different correlation with v$filestat and I/O. Buffer busy wait simply means that the buffer you're waiting for is pinned by somebody else. There are 3 classic situations: 1) DBWR hasn't finished writing to the disk yet. 2) Block is locked by another node (OPS, RAC). 3) RMAN is writing the block. That's right, RMAN locks (pins) blocks in memory, otherwise it couldn't ensure consistent backup. That is the reason why RMAN doesn't need alter tablespace begin backup command. To make the long story short, there is a note on metalink (Note:155971.1) with an appropriate title: Resolving Intense and Random Buffer Busy Wait Performance Problems. Buffer busy waits are usually a consequence of I/O subsystem not being to provide enough throughput to the database. What can you do with v$filestat? You can find where are your hot spots and fix the problem. On 2003.07.29 17:24, [EMAIL PROTECTED] wrote: Folks, Say a session issues a read request, and finds another session already reading the block into the buffer cache. If this session waits N ms on a buffer busy waits event, does this N ms of wait get added to the read times in v$filestat? Or is the readtim in v$filestat purely physical I/O? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 tough O as in women TI as in motion -Original Message- 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 ;). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 this kind of trace data. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- VIVEK_SHARMA Sent: Wednesday, July 30, 2003 3:24 AM To: Multiple recipients of list ORACLE-L ? 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 percentage proportion ratios of Checking Overhead TO execution ( INSERT ) overhead ? Any Docs , Links on such ? Thanks -Original Message- Sent: Thursday, July 24, 2003 8:42 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Qs 1) Whenever an Account ID is transacted - INSERT occurs into a table TRAN_TBL as part of the transaction , Additionally the Account ID is checked for existence in another table say TABLE_1 . If found , a record is inserted into yet another table say TABLE_2 . Qs. Operations involving TABLE_1 TABLE_2 if managed using triggers , How expensive in CPU performance will it be ? NOTE - TRAN_TBL undergoes very large volumes of Concurrent OLTP INSERT transaction . Qs 2) If an alert is to be raised on addition of a new record to TABLE_2 :- a) Can trigger be used ? b) Should a cron job running every 5 min. look at TABLE_2 based on the time criteria generates the alert ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 --- -- undo_management string MANUAL undo_retention integer 900 undo_suppress_errors boolean FALSE undo_tablespace string rbs SQL SQL select segment_name, tablespace_name from dba_rollback_segs; SEGMENT_NAME TABLESPACE_NAME -- -- SYSTEM SYSTEM _SYSSMU1$ RBS _SYSSMU2$ RBS _SYSSMU3$ RBS _SYSSMU4$ RBS _SYSSMU5$ RBS _SYSSMU6$ RBS _SYSSMU7$ RBS _SYSSMU8$ RBS _SYSSMU9$ RBS _SYSSMU10$ RBS SEGMENT_NAME TABLESPACE_NAME -- -- RBS01 RBS RBS02 RBS RBS03 RBS RBS04 RBS RBS05 RBS RBS06 RBS 17 rows selected. SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; USN NAME STATUS -- -- --- 0 SYSTEM ONLINE 11 RBS01 ONLINE 12 RBS02 ONLINE 13 RBS03 ONLINE 14 RBS04 ONLINE 15 RBS05 ONLINE 16 RBS06 ONLINE 7 rows selected. --- So, it is clear that RBSnn were created in an undo tablespace titled RBS. To remove system managed undo segments (_SYSSMUn$) one must drop the undo tablespace itself. But, in your case, you will first have to: 1. Create a new, normal tablespace, say, rollback_ts, to hold new rollback segments (do not create it using create undo tablespace ) 2. Create required rollback segments (rbs07, rbs08 etc) in rollback_ts. 3. Bring them all online. 4. Offline RBS01 to RBS06 and drop them. 5. Drop tablespace RBS. Modify init.ora parameter as required. Hope this helps. - Kirti --- [EMAIL PROTECTED] wrote: 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 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 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
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 rush. On 2003.07.30 11:14, Freeman Robert - IL wrote: 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 ORACLE-L Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -ak Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 haven't had any noticed any interference, but since we're backing up to disk, we just use a single channel. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 30, 2003 10:49 AM To: Multiple recipients of list ORACLE-L 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 channels writing to disk, and as such, I/O is to be expected. I generated statspack reports during the times the backup runs, and the tablespace I/O summary does show high avg reads/ms. Also, I see higher than normal total waits in the tablespace I/O summary. This, I guess, should be the buffer busy wait events, though I dont see it amongst the top 15 wait events. Also, the data block waits in v$waitstat spikes during this backup. So, I was wondering if I these wait events are the real cause of the I/O spike? Thanks Raj Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hia.net cc: Sent by: Subject: Re: buffer busy waits and v$filestat [EMAIL PROTECTED] ity.com 07/29/2003 05:49 PM Please respond to ORACLE-L Buffer busy wait has a different correlation with v$filestat and I/O. Buffer busy wait simply means that the buffer you're waiting for is pinned by somebody else. There are 3 classic situations: 1) DBWR hasn't finished writing to the disk yet. 2) Block is locked by another node (OPS, RAC). 3) RMAN is writing the block. That's right, RMAN locks (pins) blocks in memory, otherwise it couldn't ensure consistent backup. That is the reason why RMAN doesn't need alter tablespace begin backup command. To make the long story short, there is a note on metalink (Note:155971.1) with an appropriate title: Resolving Intense and Random Buffer Busy Wait Performance Problems. Buffer busy waits are usually a consequence of I/O subsystem not being to provide enough throughput to the database. What can you do with v$filestat? You can find where are your hot spots and fix the problem. On 2003.07.29 17:24, [EMAIL PROTECTED] wrote: Folks, Say a session issues a read request, and finds another session already reading the block into the buffer cache. If this session waits N ms on a buffer busy waits event, does this N ms of wait get added to the read times in v$filestat? Or is the readtim in v$filestat purely physical I/O? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 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 PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: 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 guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 [EMAIL PROTECTED] etelem.frTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Any German here ? Character set .com 07/30/2003 08:04 AM Please respond to ORACLE-L Hi List, could you please tell me wich Character Set you are using in your database ? Thank in advance! Philippe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 a specific executable and therefore over write each other. The other problem is where many databases share a single OH. Applying a patch to one database impacts them all and requires a lot more testing, outage and overall management. The only clean way is to have a new OH for each patch install, this is not very practicable No easy answer I am afraid but I would only be applying patches when absolutely necessary John -Original Message- Sent: 29 July 2003 23:55 To: Multiple recipients of list ORACLE-L Hello All, There are 188 interim patches after 8.1.7.4 patchset. I know that 8.1.7.4 is the last patchset. 1. What methods/strategy do you'll have for installing patches on a 8.1.7.4 64 bit hp-ux 11.11 database? 2. Is there opatch for 8.1.7.4? AFAIK opatch is only for 9i. 3. Should one install all the applicable patches (around 180 individual patches)? pessimistic (wait for the bug to hit and db to crash) optimistic (install applicable patches) 4. How to manage the interdependencies between these 180 individual patches? 5. Can we create a hp unix patch depot like thing for all these oracle patches? pls dont advise putting an enhancement request and upgrading to 9i/10i :-) Thanks, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 writing in German without umlauts and scharfes S! On 2003.07.30 11:14, Stefan Jahnke wrote: 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 Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.bov.de http://www.bov.de/ Abonnieren Sie unseren Newsletter: http://www.bov.de/enews http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Grant Allen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 30. Juli 2003 16:50 An: Multiple recipients of list ORACLE-L Betreff: RE: Any German here ? Character set I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro support! Ciao Fuzzy :-) -Original Message- Goulet, Dick Sent: Wednesday, July 30, 2003 15:29 To: Multiple recipients of list ORACLE-L WE8ISO8859P1, supports most western europe needs. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 30, 2003 10:04 AM To: Multiple recipients of list ORACLE-L 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 official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 for early next year... so do we go with 9i or 10G or whatever is out at the time? and can we even get there from here? and what will it do to all the old business objects code we still run because nobody know how to regenerate it? i think i'm going outside for a walk.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Knowledge of what is does not open the door directly to what should be. If one asks the whence derives the authority of fundamental ends, since they cannot be stated and justifed merely by reason, one can only answer: they exist in a healthy society as powerful traditions, which act upon the conduct and aspirations and judgements of the individuals; they are there, that is, as something living, without its being necessary to find justification for their existence. They come into being not through demonstration but through revelation, through the medium of powerful personalities. One must not attempt to justify them, but rather to sense their nature simply and clearly. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 file server using ifile (in the local tnsnames). For example: ifile=//cluster01\apps\oracle\sqlnet\tnsmaster.ora this works for SQL*Plus only Using the above ifile entry in the local TNSNAMES file, I am able to connect to databases from this box using SQL*Plus. However, my SQL Server linked server reports a ORA-12154: TNS:could not resolve service name. If I change my ifile entry to use a local tnsnames file, I no longer get this error from SQL Server. For example: ifile=c:\oracle\ora920\network\admin\tnsmaster.ora this works for SQL*Plus and SQL Server SQL Plus works for both scenarios. SQL Server works only for the second scenario. What has me stumped is that SQL*Plus works, but SQL Server does not. I think it might be some type of network rights issue, but I have not confirmed it. Does anybody use SQL Server to link to an Oracle database, using a TNSNAMES file that is remote? Thanks, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 the indexes on the table also get truncated? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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; 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! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 new customer that we hope to take on for tuning and DBA work.. They are not sure if they are doing all the right things... Trying to find a politically correct way to say, Uh... NO! You're not. I'm like those who say I'm from Missouri, show me. If they can back up, if they can keep it 100% invisible, they need to prove to me that one can actually recover. To me these are cold backups taken on a LIVE database and someone would have to prove to me differently. When I was Ops Mgr my operators once stopped doing backups because it took too long... I put up a 10 foot banner that said NO BACKUP IS EXACTLY THAT! and said if it ever happened again, I'd be glad help them find a job. Except for shear stupidity from induhviduals I've not lost a table or database in years. And on those following, I think Oracle is migrating towards the RMAN interface for Legato and Veritas as the preferred method... I've just finished a Legato site with about 10-15 databases and once you get all the wrinkles ironed out, it works pretty slick. I've even got the RMAN cleaning itself out based on what Legato wants to keep retention wise. If Legato purges it, so do I from RMAN. It's not bad. Legato came to put it under the scheduler and when he saw what all my scripts were doing including emailing the reports and tracking things, they kept my scripts and decided that they did better than using the scheduler. They weren't all that much magic, but a LOT of help from Robert's book... THANKS ROBERT! Maks. -Original Message- Daniel Fink Sent: Wednesday, July 30, 2003 11:44 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] Web: www.b2bsol.com The two are related. If recovery has never been properly tested, you don't know if your backups (veritas, rman, ksh/sql scripts) are working. Period. End of story. I've encountered enough software/hardware problems to not trust that an 'error free' backup will be recoverable. If the database is not being taken down, or tablespaces are not being put into backup mode, or RMAN is not being used, I'd suspect that none of the backups are recoverable. Daniel The DBA's job is not to backup the database, but to recover it. Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Subject: 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 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 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 PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: 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 guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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
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 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 Message- From: Senthil Kumar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 30, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Subject: 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; 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! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
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 the table also get truncated? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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
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, 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 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 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 PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: 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 guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Database Administrator City 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 -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 opinion is an art ! -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Metalink 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 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 __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
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 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 correct answer. TIA Senthil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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, 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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 the waits had elapsed times in seconds. When I looked at the p1 value (pid) and queried v$process, it turned out that this session was waiting for a reply from CHECKPOINT. Why is a user process communicating with ckpt? The actual number of checkpoints in the system are minimal (right now the instance has been up for ~40minutes [he just bounced it to try some stuff], and the number of background checkpoints completed is 1, the number of DBWR checkpoints is 4). I did find something by Jonathan Lewis on extent-based checkpointing (www.jlcomp.demon.co.uk/extent.html). The db flushes all blocks related to the object from the buffer cache prior to dropping the table. He said this changed in Oracle8 (we are running 8.1.7.4). Also, changing the tablespace to READ ONLY should prevent flushing of the buffer cache. The other DBA here said he tried this to no avail. Any clues? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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
** 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??? Thanks Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
** 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 initialized value??? Or will one session affect the value of other sessions. What is the best way to initialize? Else what is a way to have a process wide flag which can be used to determine if certain actions can take place. I really have no other criteria to distinguish. Thank You all... Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
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 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 the waits had elapsed times in seconds. When I looked at the p1 value (pid) and queried v$process, it turned out that this session was waiting for a reply from CHECKPOINT. Why is a user process communicating with ckpt? The actual number of checkpoints in the system are minimal (right now the instance has been up for ~40minutes [he just bounced it to try some stuff], and the number of background checkpoints completed is 1, the number of DBWR checkpoints is 4). I did find something by Jonathan Lewis on extent-based checkpointing (www.jlcomp.demon.co.uk/extent.html). The db flushes all blocks related to the object from the buffer cache prior to dropping the table. He said this changed in Oracle8 (we are running 8.1.7.4). Also, changing the tablespace to READ ONLY should prevent flushing of the buffer cache. The other DBA here said he tried this to no avail. Any clues? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
** 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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 gets updated by a user in 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??? Thanks - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
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 com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: A Joshi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 30, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Subject: ** 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 initialized value??? Or will one session affect the value of other sessions. What is the best way to initialize? Else what is a way to have a process wide flag which can be used to determine if certain actions can take place. I really have no other criteria to distinguish. Thank You all... Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
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 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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 with 4 members each, how many disks Q 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 gets updated by a user in 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??? Thanks - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software -- Mladen Gogala Oracle DBA **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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) It's because I say so and I'm an 8i OCP. On 2003.07.30 13:44, KENNETH JANUSZ wrote: 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, 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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 30, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Subject: 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 correct answer. TIA Senthil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
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 executed around 1000 or 2000 times. From knowledge of the business, it would seem that the latter is much more believable. The major difference between this trigger and the others is that the others all have a column declared in the FOR UPDATE clause of the trigger. For example, here's the header of the trigger in question: CREATE OR REPLACE TRIGGER QT_BLAH_BLAH_IU AFTER INSERT OR UPDATE ON my_table FOR EACH ROW WHEN (NEW.commodity_code != OLD.commodity_code OR OLD.commodity_code IS NULL) ...while the other triggers would also contain an OF my_column clause immediately following AFTER INSERT OR UPDATE. The table contains about 200K rows. Having this trigger fire 900K times is highly unlikely, given the WHEN clause. According to Oracle8i Application Developer's Guide - Fundamentals, about the WHEN clause of a row-level trigger: If the expression evaluates to TRUE for a row, then the trigger body is fired on behalf of that row. However, if the expression evaluates to FALSE or NOT TRUE for a row (unknown, as with nulls), then the trigger body is not fired for that row. The same manual also says: If a triggering statement specifies UPDATE, then an optional list of columns can be included in the triggering statement. If you include a column list, then the trigger is fired on an UPDATE statement only when one of the specified columns is updated. If you omit a column list, then the trigger is fired when any column of the associated table is updated. This leaves me a little confused as to what exactly fires when with a trigger. I know that bug 1764313 says the execution count is inaccurate, but if anything that bug would suggest that the 900K rows is LOW and not HIGH like we've seen. I guess my real question is what part of a trigger is loaded when. Is there a difference between the trigger and the trigger body when it comes to executions? How is this difference shown the V$DB_OBJECT_CACHE or V$SQLAREA for that matter? Is the distinction similar to PACKAGE vs. PACKAGE BODY? BTW, if it matters, we're currently on 32-bit 8.1.7.4.0 on 64-bit HP/UX 11.0. TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Subject: 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 for early next year... so do we go with 9i or 10G or whatever is out at the time? and can we even get there from here? and what will it do to all the old business objects code we still run because nobody know how to regenerate it? i think i'm going outside for a walk.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 [EMAIL PROTECTED] wrote: 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 cannotsee where does the statement come from. May be you should rethink the overalldesign 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 gets updated by a user in 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??? Thanks - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site! design software-- Mladen GogalaOracle DBA**DISCLAIMERThis e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jay HostetterINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
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 Martin IT Extension 8487 -Original Message- Sent: Wednesday, July 30, 2003 11:10 AM To: Multiple recipients of list ORACLE-L 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 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 disks Q 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 -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
