Re: TNSPING
Hi Those are the times to get the reply from the remote machines back. 10 msec is the fastest (at the moment) but may depend on network as well. Jack Seema Singh [EMAIL PROTECTED]@fatcity.com on 15-01-2002 21:40:26 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi When I run tnsping servername on web server .Some of server shoe at bottom OK (10 msec) some of them are OK (50 msec) and some of them are OK (100 msec) What this meaning is? Which server is faster one? Thanks -Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SAME, WAFL and RAID
May I please have a copy of this paper? Thanks -Original Message- Sent: Wednesday, January 16, 2002 00:38 To: Multiple recipients of list ORACLE-L Hi, WAFL is Write Anywhere File Layout... Its the file lay out used by snapshot supported storege Devices(NetApp Storege Etc), This is completely different from a RAID. A RAID is a system which may or maynot be h/w controlled. But WAFL is the Low level file layout of the Storege system. In any one wants i hv the paper or Hutchinston with me on WAFL which i can give u Regards OraEtM!! _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eswar the MAD INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle8i and LDAP
Hello All We are now in the process of adding LDAP to oracle 8.1.6. I had a talk just yesterday with a guy that works on LDAP. he said: NT LDAP has problems. Better go with OID or Novell LDAP. 1) For your knowledge. 2) Can anybody share their own experience on the subject. Thanks Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 16, 2002 1:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle8i and LDAP Take a look at this article on using OID with older versions of Oracle: http://www.oracle.com/oramag/oracle/01-jan/index.html?o11o8i.html Jared On Tuesday 15 January 2002 15:00, Ben Poels wrote: Hi Well I have partially answered my own question. I see in the Net8 manual that it can use an LDAP server to replace Oracle Names and lookup connect strings for service names. However I am still not sure if Oracle8i can authenticate a username and password in an LDAP. If it can, does anyone know how it queries the LDAP. What I really want to know is whether Oracle has any specific requirements that an LDAP server would need to be able to handle. This will help us choose an Oracle compatible LDAP. I have found a chart indicating that OID is included with Oracle9iAS EE. -Original Message- Sent: Tuesday, January 15, 2002 4:02 PM To: Multiple recipients of list ORACLE-L Hi Does Oracle8i come with any built in LDAP functions or do you have to write your own functions to search and update an LDAP directory? Does the Oracle Internet Directory come with Oracle8i or is purchased separately? Thanks. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SAME, WAFL and RAID
I think that you just run into : RAIC: Redundant Array of Independent Consultants. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 16, 2002 2:01 AM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID Yea, they were talking about clustering all right. sure uh huh right Whatever! -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 6:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID New one I heard at our local Oracle office : RAIP = Redundant Array of Independent Processors (Those guys were talking about NT Clustering... ) -Original Message- From: Mohan, Ross [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 4:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID SAME = 'stripe and mirror everthing' BHT = 'butylated hydroxytoluene' -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID Great ! Thanks for the info.. - Kirti -Original Message- From: Nick Wagner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID good question... RAID and WALF -- see below. SAME... no idea... RAID - (from http://www.uni-mainz.de/~neuffer/scsi/what_is_raid.html ) What does RAID stand for ? In 1987, Patterson, Gibson and Katz at the University of California Berkeley, published a paper entitled A Case for Redundant Arrays of Inexpensive Disks (RAID) . This paper described various types of disk arrays, referred to by the acronym RAID. The basic idea of RAID was to combine multiple small, inexpensive disk drives into an array of disk drives which yields performance exceeding that of a Single Large Expensive Drive (SLED). Additionally, this array of drives appears to the computer as a single logical storage unit or drive. The Mean Time Between Failure (MTBF) of the array will be equal to the MTBF of an individual drive, divided by the number of drives in the array. Because of this, the MTBF of an array of drives would be too low for many application requirements. However, disk arrays can be made fault-tolerant by redundantly storing information in various ways. Five types of array architectures, RAID-1 through RAID-5, were defined by the Berkeley paper, each providing disk fault-tolerance and each offering different trade-offs in features and performance. In addition to these five redundant array architectures, it has become popular to refer to a non-redundant array of disk drives as a RAID-0 array. WAFL (from the NetApp website) The WAFL (Write Anywhere File Layout) file system and the following features deliver enterprise-class availability: Consistency points. Always a consistent file-system image on disk, even after unplanned shutdowns. Virtually eliminates the need to run time-consuming file-system checks. Snapshot technology. Snapshots are near-instantaneous, transparent, read-only, online copies of the active file systems. Up to 31 Snapshots can be maintained for each data volume. Users can quickly recover deleted or modified files without administrative assistance or restore from tape backup. The Snapshot function requires minimal disk space and causes no disruption of service. Snapshots can be backed up to other media while users are modifying the active file system to minimize business disruption. SnapRestore software. Allows any system to revert back to a specified data volume Snapshot for instant file-system recovery. Terabytes can be recovered in minutes, rather than hours, without going to tape. The software also greatly facilitates scenario testing as well as providing disaster recovery and virus protection. Easy, cost-effective clustering. Safeguards against hardware failures by automatic filer takeover. Gives users continuous access to data. SnapMirror software. Provides remote mirroring at high speeds over a LAN or WAN. The asynchronous mirroring can be used for disaster recovery,
RE: problem with 9i import
This seems strange. Can you catch all the session duet(imp prompts and you answers) and post them in the list? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 10:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: problem with 9i import Hi, I guess i really don't understand. The way i did this import in the first place is in the command prompt I navigated to the folder that i had the exp.dat stored in and then I typed username/password then I typed imp expdat.dmp and then the rest came up on prompts. After seeing your reply I changed it to username\password@orcl then after that the rest doesn't give you much options. It came out the same.Could you please let me know the exact syntax to do this. i am just an Oracle student that wants to import all my tables and stuff from my Oracle 8i to Oracle 9i on my home PC. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: [Fwd: [Fwd: Re: ora-00600 error]]
The ora-600 12333 occurs in the two task layer, if it receives a function code or argument, that is unexpected or invalid. Normally,the arguments after [12333] identify some details about this, and there are a few metalink notes relevant. The 12333 will always be followed by an ora-3106. In your case with the three [0] arguments, this is a bit weird. I've seen a previous case before and I was speculating, the there were errors or bad data being received either from SQL*Net or from the TCP/IP (or whatever networking) software. I also had other indications (such as weird process state dumps in the trace file), that indicated some sort of corruptions. However, I couldn't verify this. Thanks, Bjrn. Original Message Subject: Re: ora-00600 error Date: Tue, 15 Jan 2002 10:35:35 -0800 From: Glenn Stauffer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] This comes up with an application that I manage. The error is a generic one which indicates that there is a problem in the communication between the client and the server process. In my situation, a Forms application, this occurs most often when a session gets timed out after being inactive for more than 10 hours. When they try to continue working with the Forms application, they get an error message on their screen and the Ora-00600 [12333] error gets logged on the server.GlennOn Tuesday 15 January 2002 10:20 am, you wrote: I am getting an ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []error. How do I find out what is causing this problem?-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Glenn Stauffer INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo 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).
RE: RE : Table partition on part of a field
I thought about it, but there are many update programs and my first inclination is to leave the design as is. We are talking about PORTING application and I do not want to add design changes as well. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 11:02 PM To: Multiple recipients of list ORACLE-L Subject: RE : Table partition on part of a field Make it two fields 6 3 Partition on 3 And create a view to concatenate the two fields into one Regards, Waleed -Original Message- Sent: Tuesday, January 15, 2002 12:50 PM To: Multiple recipients of list ORACLE-L Hello All I need to create a partitioned table base on the last three digits on 9 digits number. Create table test (zip_and_city_code number(9)); The zip code is 6 digits and the city code is 3 digits. The design is from an application that used btrieve and is now ported to Oracle. (I would not allow this design if it was a new system). I want to group every city records into its own partition. First I tried to use range partitioning based on a function on the field and it does not work. Then I thought about using hash partitioning using my own hash function but could not find where I can use my own hash function. Any help to implement this @#$% design will be really appreciated. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: dynamic views in 8.1.6
$)CYes. Look at the list of required init.ora settings to be applied after migrating/upgrading an Apps 10.7/11 database to 8.1.7 when upgrading to Apps 11i ! [pasting from the Apps 11i Upgrade manual] Set init.ora file parameters In your init.ora file, set the following parameters to the values indicated. Restart your database for the new parameters to take effect. _complex_view_merging = true _fast_full_scan_enabled = false _like_with_bind_as_equality = true _new_initial_join_orders = true _optimizer_mode_force = true _optimizer_undo_changes = false _or_expand_nvl_predicate = true _ordered_nested_loop = true _push_join_predicate = true _push_join_union_view = true _sort_elimination_cost_ratio = 5 _table_scan_cost_plus_one = true _trace_files_public = true _use_column_stats_for_function = true _sqlexec_progression_cost = 0 aq_tm_processes = 1 always_anti_join = NESTED_LOOPS always_semi_join = NESTED_LOOPS db_block_buffers = 5000 db_files = 500 db_file_multiblock_read_count = 8 dml_locks = 500 enqueue_resources = 5000 log_buffer = 1048576 log_checkpoint_interval = 10 log_checkpoint_timeout = 72000 max_enabled_roles = 40 nls_date_format = DD-MON-RR nls_language = american nls_numeric_characters = ., nls_sort = binary nls_territory = america open_cursors = 500 optimizer_features_enable = 8.1.7 optimizer_max_permutations = 2000 optimizer_mode = rule optimizer_percent_parallel = 0 parallel_min_servers = 0 processes = 75 query_rewrite_enabled = true row_locking = always shared_pool_reserved_size = 3000 shared_pool_size = 3 sort_area_size = 256000 timed_statistics = true Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Mogens N)*rgaard [EMAIL PROTECTED] 16/01/2002 09:15 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: dynamic views in 8.1.6 _might_be_running_apps = true commit; Mogens Stephane Faroult wrote: Oracle DBA wrote: we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal _stop_messing_with_undocumented_parameters=TRUE -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: limit user CPU usage
If you are using 8i , you can setup Resource Manager. For more info about this subject see Oracle Administrator´s Guide. HIH, Antonio Belloni Carle, William TTo: Multiple recipients of list ORACLE-L (Bill), [EMAIL PROTECTED] ALINF cc: [EMAIL PROTECTED]Subject: RE: limit user CPU usage om Sent by: root@fatcity. com 15/01/02 16:30 Please respond to ORACLE-L Hi, You can set up a profile to set resource limits and have the user use that profile. This is explained in the Oracle Administrator's Guide. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 15, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Hi, Guys, Is there some parameters or user-profile prometers in Oracle can limit user CPU usage? I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU. I know the SQL is bad, but before developer change it, Is there something I can do? Any suggestion will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RMAN backup and restore Q?
Hi All,
I'm in the process of figuring out the workings of RMAN and created 2 test
databases.
TEST1 = catalog database
TEST2 = target database
I have created the catalogs and registered the database with the catalog.
I than mad a full backup of the database TEST2 (is in Archivelog mode)
with the following syntax
**BACKUP
rman EOF
connect target rman/rman@test2
connect catalog rman/rman@test1
run {
allocate channel d1 type disk;
backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus'
database;
}
EOF
*
which created the database backup OK
When I try the restore however I get ORA 19753 cannot obtain exclusive
enqueue for datafile 1.
RESTORE*
rman EOF
connect target rman/rman@test2
connect catalog rman/rman@test1
run {
allocate channel d1 type disk;
restore database;
recover database;
alter database open;
}
EOF
**
Checking the database TEST2 showed a shared MR lock in the v$lock view on
all tablespaces.
What am I doing wrong here?
TIA
Jack
===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst
Young is neither liable for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.
===
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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 Performance monitoring tools.
Since EMC took over MAMBA seems to have disappeared ... any ideal where to get hold of the copy for eval (if it is still available?) Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, January 15, 2002 7:01 PM To: Multiple recipients of list ORACLE-L Chuan, Mamba is a good tool, that can be downloaded from www.luminate.com Also check out Spotlight from www.quest.com Regards $uhen *2 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 : Table partition on part of a field
'instead of' trigger on he view may help with inserts/updates. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 4:05 AM I thought about it, but there are many update programs and my first inclination is to leave the design as is. We are talking about PORTING application and I do not want to add design changes as well. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 11:02 PM To: Multiple recipients of list ORACLE-L Subject: RE : Table partition on part of a field Make it two fields 6 3 Partition on 3 And create a view to concatenate the two fields into one Regards, Waleed -Original Message- Sent: Tuesday, January 15, 2002 12:50 PM To: Multiple recipients of list ORACLE-L Hello All I need to create a partitioned table base on the last three digits on 9 digits number. Create table test (zip_and_city_code number(9)); The zip code is 6 digits and the city code is 3 digits. The design is from an application that used btrieve and is now ported to Oracle. (I would not allow this design if it was a new system). I want to group every city records into its own partition. First I tried to use range partitioning based on a function on the field and it does not work. Then I thought about using hash partitioning using my own hash function but could not find where I can use my own hash function. Any help to implement this @#$% design will be really appreciated. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: designer6i vs. designer2000
Andrea, Designer 6i is the newest one - release 3. You can actually download it from OTN. Designer2000 was renamed to 6i after the Y2K hysteria calmed down (and Uncle Larry got on his i bandwagon). Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:05 AM To: Multiple recipients of list ORACLE-L Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: designer6i vs. designer2000
Hi Andrea, Designer 6i is the latest release of the Designer products. I would recommend you learn this release. Designer 2000 is probably still in use in a FEW places, but little new work should be done in this release. John [EMAIL PROTECTED] wrote: Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RMAN backup and restore Q?
Jack,
What is the status of your target database?
Try having it in startup mount status rather than startup open.
The other thing you should do is to backup your control file (using Rman)
with every database backup. I do this as my last step with every backup so
that the latest changes within the control file are also saved.
Hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, January 16, 2002 7:25 AM
To: Multiple recipients of list ORACLE-L
Hi All,
I'm in the process of figuring out the workings of RMAN and created 2 test
databases.
TEST1 = catalog database
TEST2 = target database
I have created the catalogs and registered the database with the catalog.
I than mad a full backup of the database TEST2 (is in Archivelog mode)
with the following syntax
**BACKUP
rman EOF
connect target rman/rman@test2
connect catalog rman/rman@test1
run {
allocate channel d1 type disk;
backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus'
database;
}
EOF
*
which created the database backup OK
When I try the restore however I get ORA 19753 cannot obtain exclusive
enqueue for datafile 1.
RESTORE*
rman EOF
connect target rman/rman@test2
connect catalog rman/rman@test1
run {
allocate channel d1 type disk;
restore database;
recover database;
alter database open;
}
EOF
**
Checking the database TEST2 showed a shared MR lock in the v$lock view on
all tablespaces.
What am I doing wrong here?
TIA
Jack
===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst
Young is neither liable for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.
===
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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 dev/test schema generation tool.
Hi List, I'd like to take the opportunity to ask if any of you would be interested in testing a copy of a new tool that is available through Cool-Tools (from a company called Net2000 Ltd. run by another of our list members Dale Edgar) *free of charge*. We are looking for people to test it out, and provide feedback/constructive criticism. Interested? Read on.. The tool is called the DataBee DBATool (a subset of a chargeable tool called DataBee, that creates referentially intact subsets of production databases) which was broken away from the main product, as it's a pretty handy tool in it's own right. It reads a standard Oracle export file (created with the ROWS=N option) and processes the contents. Once the export file is loaded, the database DDL is easily accessible via a user interface. Here are some of the features: -- View various DDL components (or groups of components) in a neatly formatted and intuitive manner. Create dependent object scripts. For example, the DDL for a table and all of its associated indexes, primary keys, synonyms etc can be viewed at the press of a button. Generate drop, truncate (including foreign key disables and re-enables) or recompile scripts for any DDL object or group of objects. Generate SQL scripts that can recreate the DDL for a schema. Write the DDL out as HTML pages. The HTML pages are presented in an intuitive and interlinked tree structure that can be accessed by any web browser. Easily strip storage clause and tablespace information from table and index DDL. Create rule files which can manipulate the DDL in a consistent and reproducible manner (such as changing tablespace storage for Tables / indexes etc.). -- If you would be interested in testing this out (or just having a copy as it's *FREE*) then send a message to me off the list, and I will send you a download URL on our web site so that you can grab yourself a copy (let's keep these off the list please). If you do have any further questions about the tool, then direct them to the list (we could all learn something) and either myself or Dale will try to answer your questions. Thanks for your time, Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Maximum number of redo log members
I believe that the only way to see that information is to do an alter database backup controlfile to trace as it is stored only in the controlfiles. This was true in 7.3 and 8.x --- Sinard Xing [EMAIL PROTECTED] wrote: Hi all, Where to find information about my MAXLOGMEMBERS, MAXLOGFILES ? I mean which views or tables (DD) to query from. Note: Oracle doc said see your operating system-specific Oracle documentation, which is I don't have any : ( Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: dynamic views in 8.1.6
Yes,
There is an article on moving to CBO for 11i by
Ahmed Alomari where there is a discussion on the mentioned
parameters.
Also 3-4 of these undocumented parameters are infact documented in the
oracle documentation (which metalink has promptly dissociated itself with)
!!
Nevertheless if some of the gurus can explain what is that they try to
observe
while incorporating any of the undocumented parameters, it'll be quite
enlightening
to a lot of us.
TIA,
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 3:30 PM
Subject: Re: dynamic views in 8.1.6
: $)CYes.
:
: Look at the list of required init.ora settings to be applied after
: migrating/upgrading
: an Apps 10.7/11 database to 8.1.7 when upgrading to Apps 11i !
: [pasting from the Apps 11i Upgrade manual]
:
: Set init.ora file parameters
: In your init.ora file, set the following parameters to the values
: indicated. Restart
: your database for the new parameters to take effect.
: _complex_view_merging = true
: _fast_full_scan_enabled = false
: _like_with_bind_as_equality = true
: _new_initial_join_orders = true
: _optimizer_mode_force = true
: _optimizer_undo_changes = false
: _or_expand_nvl_predicate = true
: _ordered_nested_loop = true
: _push_join_predicate = true
: _push_join_union_view = true
: _sort_elimination_cost_ratio = 5
: _table_scan_cost_plus_one = true
: _trace_files_public = true
: _use_column_stats_for_function = true
: _sqlexec_progression_cost = 0
: aq_tm_processes = 1
: always_anti_join = NESTED_LOOPS
: always_semi_join = NESTED_LOOPS
: db_block_buffers = 5000
: db_files = 500
: db_file_multiblock_read_count = 8
: dml_locks = 500
: enqueue_resources = 5000
: log_buffer = 1048576
: log_checkpoint_interval = 10
: log_checkpoint_timeout = 72000
: max_enabled_roles = 40
: nls_date_format = DD-MON-RR
: nls_language = american
: nls_numeric_characters = .,
: nls_sort = binary
: nls_territory = america
: open_cursors = 500
: optimizer_features_enable = 8.1.7
: optimizer_max_permutations = 2000
: optimizer_mode = rule
: optimizer_percent_parallel = 0
: parallel_min_servers = 0
: processes = 75
: query_rewrite_enabled = true
: row_locking = always
: shared_pool_reserved_size = 3000
: shared_pool_size = 3
: sort_area_size = 256000
: timed_statistics = true
:
:
: Hemant K Chitale
: Principal DBA
: Chartered Semiconductor Manufacturing Ltd
:
:
: Mogens N)*rgaard [EMAIL PROTECTED] 16/01/2002 09:15 AM
: Sent by: [EMAIL PROTECTED]
:
: Please respond to ORACLE-L
:
: To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
: cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
: Subject: Re: dynamic views in 8.1.6
:
:
:
:
:
:
:
:
: _might_be_running_apps = true
:
: commit;
:
: Mogens
:
: Stephane Faroult wrote:
: Oracle DBA wrote:
: we have added these parameters in the init.ORA file .
: query_rewrite_enabled=true
: _complex_view_merging=true
: _push_join_predicate=true
: optimizer_max_permutations=79000
: _use_column_stats_for_function=true
: _like_with_bind_as_equality=true
: _push_join_union_view=true
: _ordered_nested_loop=true
: _or_expand_nvl_predicate=true
:
: after these changes all the dynamic views created by developers
: have stopped
: working .
:
: our database is running on aix 4.3.3 and its in MTS mode .
:
: Will appreciate quick response.
:
: thanks in advance .
:
: brajesh jaiswal
:
:
: _stop_messing_with_undocumented_parameters=TRUE
:
:
:
:
:
:
: --
: Please see the official ORACLE-L FAQ: http://www.orafaq.com
: --
: Author:
: INET: [EMAIL PROTECTED]
:
: Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
: San Diego, California-- Public Internet access / Mailing Lists
:
: 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).
:
åy« ±ç
ê ~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+¦¶¬
«-j £«b
Ñèëjع·¬µ«Z²×Ê«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ§' ¥ú+¹¹bpíz¹Þµ§ zË?1¨¥x ËlND0åDÊ«±é_~º¶¬¨¥x%ËlzwZCY²Æ zÚ ËFº»j×·'(z-xEÀ
;)zYb
.+-êîjwbØ^ë,j86Énuæ¥w¢{Zx§CRP Ä.í
éÚê ¨¥x%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm
áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*') ²æìr¸x
Re: Oracle8i and LDAP
I believe OID is licensed seperately - it is for Oracle 9i Enterprise Edition. On Tuesday 15 January 2002 04:01 pm, you wrote: Hi Does Oracle8i come with any built in LDAP functions or do you have to write your own functions to search and update an LDAP directory? Does the Oracle Internet Directory come with Oracle8i or is purchased separately? Thanks. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: designer6i vs. designer2000
Alas, the last time I looked, the OTN download for Designer was missing. The latest is Des6i release 4, which it said was 'coming soon' Simon Anderson Andrea, Designer 6i is the newest one - release 3. You can actually download it from OTN. Designer2000 was renamed to 6i after the Y2K hysteria calmed down (and Uncle Larry got on his i bandwagon). Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:05 AM To: Multiple recipients of list ORACLE-L Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RMAN backup and restore Q?
What version of the database are you using? My info here is based on 8.1.7.
I connect to my databases as internal to do the backups. I fire up RMAN with either
one of these commands:
rman target / catalog rman/rman@test1 (SID must be set correctly)
rman target internal/pwd@test2 catalog rman/rman@test1
I'm not sure why you have an rman user in test2, unless you set up a second catalog so
that you can backup your first catalog.
To test your restore, shutdown test2 and delete all the .dbf, .log, .arc, and .ctl
files. Then startup nomount the test2 database. Then try this:
rman target internal/pwd@test2 catalog rman/rman@test
run {
allocate channel ch1 type disk;
restore controlfile;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}
If you did a hot backup, you may need your archivelog backups. This command backs up
the archivelogs:
run
{
allocate channel ch1 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch1 kbytes=100; # Limit sets to 1 Gb.
backup archivelog until time 'sysdate-1/24' delete input;
backup archivelog from time 'sysdate-1/24';
}
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
[EMAIL PROTECTED] 01/16/02 07:25AM
Hi All,
I'm in the process of figuring out the workings of RMAN and created 2 test
databases.
TEST1 = catalog database
TEST2 = target database
I have created the catalogs and registered the database with the catalog.
I than mad a full backup of the database TEST2 (is in Archivelog mode)
with the following syntax
**BACKUP
rman EOF
connect target rman/rman@test2
connect catalog rman/rman@test1
run {
allocate channel d1 type disk;
backup full format '/data/oracle/BACKUP/rman_%d_%t_%U.bus'
database;
}
EOF
*
which created the database backup OK
When I try the restore however I get ORA 19753 cannot obtain exclusive
enqueue for datafile 1.
RESTORE*
rman EOF
connect target rman/rman@test2
connect catalog rman/rman@test1
run {
allocate channel d1 type disk;
restore database;
recover database;
alter database open;
}
EOF
**
Checking the database TEST2 showed a shared MR lock in the v$lock view on
all tablespaces.
What am I doing wrong here?
TIA
Jack
===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst
Young is neither liable for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.
===
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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.com
--
Author: Jay Hostetter
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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
Oracle 8.1.7 install error
I keep getting the following error while trying to install Oracle 8.1.7 on my NT server. There is over 1G of freespace on the drive. If I say ignore, the installer continues to run. Any ideas? Error in writing to file c:\winnt\system32\ctl3d32.dll Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle8i and LDAP
From Metalink NOTE: 155416.1 QUICK INSTALL OF OID 3.0.1 - Oid 3.0.1 is bundled with Oracle9i Enterprise Edition on the latest cd pack. NOTE: OID 3.0.1 part of 9.0.1 CD PACK is under special licensing for a 2 USER license for strict use with 9i single signon solution only as indicated in the following note in the RELEASE NOTES I am almost 100% certain that this is also true for V8.1.6 V8.1.7 HTH YMMV HAND! Glenn Stauffer wrote: I believe OID is licensed seperately - it is for Oracle 9i Enterprise Edition. On Tuesday 15 January 2002 04:01 pm, you wrote: Hi Does Oracle8i come with any built in LDAP functions or do you have to write your own functions to search and update an LDAP directory? Does the Oracle Internet Directory come with Oracle8i or is purchased separately? Thanks. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 I'm as busy as a one armed wall paper hanger! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: designer6i vs. designer2000
Designer 4 is here since some monthes, you have to download patch 4a from metalink. Tamas Szecsy -Original Message- Sent: Wednesday, January 16, 2002 14:45 To: Multiple recipients of list ORACLE-L Alas, the last time I looked, the OTN download for Designer was missing. The latest is Des6i release 4, which it said was 'coming soon' Simon Anderson Andrea, Designer 6i is the newest one - release 3. You can actually download it from OTN. Designer2000 was renamed to 6i after the Y2K hysteria calmed down (and Uncle Larry got on his i bandwagon). Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:05 AM To: Multiple recipients of list ORACLE-L Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Why doesn't Oracle kill dead connections?
Much of this is controlled through Oracles SQL*Net product. It needs to be configured. It also depends on what version of the database you are using. Oracle8.0/8i and beyond have mechanisms called profiles (oracle7 had them as well but didnt work well) that can assist in dead connection detection. The problem with Web-based dead connection is that if the application server retains the connection, the stuff will work. However, if the application server has started the SQL/PL/SQL process and then goes off to do other work, and return back, the dead connection stuff may disconnect you by accident. Guess it is trial and error. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Sona [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 7:20 PM To: Multiple recipients of list ORACLE-L Subject: Why doesn't Oracle kill dead connections? Hi I have a Reporting appliaction. The reports are run from the browser . The reports are basically Pl/SQL packages .the request is made from the browser and then communicated to the database thru OAS .(oracle application server) which acts as web server. The problem is when a user executes a report (i.e. hits the RUN button) and then closes the broser before the execution of the report is completed.Oracle still contimues running the query in the database. The session still remains ACTIVE in the database even though the client has closed the connection (i.e. the user has closed the browser). Is there any way to force Oracle to kill the session when the user closes the browser? TIA
Re: Oracle 8.1.7 install error
Ron, Does the dll already exist from a prior install failure? If it is NOT an NT dll then move it to another location and try the install again. Check the permissions and ownership on the file and make sure that you can overwrite it. Ron, ROR mª¿ªm [EMAIL PROTECTED] 01/16/02 09:10AM I keep getting the following error while trying to install Oracle 8.1.7 on my NT server. There is over 1G of freespace on the drive. If I say ignore, the installer continues to run. Any ideas? Error in writing to file c:\winnt\system32\ctl3d32.dll Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -Received: from CONNECT-MTA by galotter--- 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.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: designer6i vs. designer2000
They are just different tools of the same product and not one I would choose to learn if all I wanted to learn was data modeling. It is a tool that is best used for the complete life cycle, from process modeling, all the way to generating your code. Unless you are committed to doing that (with maybe the exception of the first step) you really do not get very much benefit from the tool. Its best used with larger projects. That being said, since I know the tool and used to have it in-house, I would use it just for data modeling. Its not an easy tool to learn. When I started using it was the days of CASE 5.1 and moved up in versions. It really is best to bring in an expert if you are going to start using for a project. We brought one in that was just there to guide us in using the tool. His sole purpose. And we would have died without him. -Original Message- Oracle Sent: Tuesday, January 15, 2002 10:05 PM To: Multiple recipients of list ORACLE-L Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 8.1.7 install error
I get a lot of those when installing on NT. I usually go into explorer, rename the existing file to .old and hit Retry and the install continues on. Sometimes that won't work if the file is truly locked by another process. In that case you have to find who has locked the file. I use the HandleEx tool available from www.sysinternals.com to find out which process has the file locked and stop it before continuing the installation. -Original Message- Sent: Wednesday, January 16, 2002 9:10 AM To: Multiple recipients of list ORACLE-L I keep getting the following error while trying to install Oracle 8.1.7 on my NT server. There is over 1G of freespace on the drive. If I say ignore, the installer continues to run. Any ideas? Error in writing to file c:\winnt\system32\ctl3d32.dll Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Forms hint text font size
Is there a way to specify a custom font size for Forms 6i hint text associated with a field? I notice that it is possible for ToolTips, but not for Hint Text. I just posted to the ODTUG listserv but usually they reject my e-mails because I am not a member. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
SQL Loader Direct Load - Problem with Index Rebuild
Hi, Okay, this is the second time this has happened and while I have a guess I'd appreciate any feedback on the issue. Last night during a direct load to one of our datawarehouse tables 4 of the index partition rebuilds failed with the following errors (the remaining partitions were fine, as were all the other indexes): index EIS.IDX_BKP_TRANS_DATE partition BOOK2001OCT was made unusable due to: ORA-01652: unable to extend temp segment by 320 in tablespace TS_BOOKKEEPING_FACT_IDX index EIS.IDX_BKP_TRANS_DATE partition BOOK2001NOV was made unusable due to: ORA-01658: unable to create INITIAL extent for segment in tablespace TS_BOOKKEEPING_FACT_IDX index EIS.IDX_BKP_TRANS_DATE partition BOOK2001DEC was made unusable due to: ORA-01658: unable to create INITIAL extent for segment in tablespace TS_BOOKKEEPING_FACT_IDX index EIS.IDX_BKP_TRANS_DATE partition BOOK2002JAN was made unusable due to: ORA-01658: unable to create INITIAL extent for segment in tablespace TS_BOOKKEEPING_FACT_IDX I was able to manually rebuild the index partitions with no problem. There are currently 1,881 free extents of the size 320 blocks in that tablespace. The entire index (including all partitions) only takes up 473 extents. We have degrees=1 on the index. There's a metalink Forum thread (ORA 1652 During Direct Load) where a similar problem occurred. It seems to imply each index may be claiming 2x it's required space while being rebuilt and that SMON might not clean up that space right away. This could certainly have caused there to be not enough space available if it required the tablespace to be 2x the size of *all* the indexes. In that case the fact that SMON cleaned it up before I did the manual rebuild would explain why the latter worked. Looking at the tablespace I see that it is currently almost 2x the size so it's possible that's why I had avoided the problem for the last few months. Has anyone else had this problem and is there a workaround short of dropping the indexes before the load and recreating them? I'd rather avoid that since it's usually only a few partitions that need to be rebuilt. I'm on Oracle 8.1.6.3, Solaris 2.6. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Reporting database with Time Finder
Hi! Oracle 8.1.7 on AIX, on EMC discs boxes which are synchronized with SRDF. At the target site, we have BCV volumes. We want to open reporting database on a daily basis. Now we can open target database with the same AIX volume group as the primary database. My question is do you have experience in renaming AIX volume group, so we can have two databases on the same machine (SRDF target and BCV)? We have some experience in doing that manually, but we're interested in having some scripts. Please help. TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Which Character set?
I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 Performance monitoring tools.
Title: RE: Oracle Performance monitoring tools. What's the current price tag of Quest's Spotlight? Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming -Original Message- From: Suhen Pather [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 7:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Performance monitoring tools. Chuan, Mamba is a good tool, that can be downloaded from www.luminate.com Also check out Spotlight from www.quest.com Regards $uhen DBA gurus, I am just curious about what the performance tuning and monitoring tools you are using besides OEM. Your sharing is highly appreciated. Chuan Zhang Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Calling a procedure from a procedure
Remove the word execute. Within PL/SQL you do not need EXECUTE. That is a SQL*Plus command. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Lance Prais [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:57 AM To: Multiple recipients of list ORACLE-L Subject: Calling a procedure from a procedure I need to execute a procedure with in a loop of another. I need to pass a variable to the second procedure. I am using Execute, looks like this: Execute Primus_Dump_TEST_2(Solution); Getting this error: PLS-00103: Encountered the symbol PRIMUS_DUMP_TEST_2 when expecting one of the following: := . ( @ % ; The symbol := was substituted for PRIMUS_DUMP_TEST_2 to continue. I am using Toad as my editor. I am doing it as follows: Open Primus_solution; loop /* Add next three lines */ fetch primus_solution into solution; exit when primus_solution%NOTFOUND; dbms_output.put_line (Solution); Execute Primus_Dump_TEST_2(Solution); End LOOP; Close Primus_solution;
RE: Reporting database with Time Finder
Sonja, that is a very interesting question. I have tested the source/target scenario under Digital Unix. We did come across a command that allowed you to mount the devices with the same name on the same server with a mount /ignore(?). There may well be a ruse to rename the whole battle ship. It becomes very tricky when you wish to mount the target database and the reporting db on the same server. Already the database will have the same id as PROD unless you are going to rename it and all your physical files. So to mount it once is fine on the same server. You would IMHO save a lot of complexity by mounting it on another server. Yes I know its extra cost For a penny. Peter -Message d'origine- De : Sonja ehovic [mailto:[EMAIL PROTECTED]] Envoy : mercredi 16 janvier 2002 16:57 A : Multiple recipients of list ORACLE-L Objet : Reporting database with Time Finder Hi! Oracle 8.1.7 on AIX, on EMC discs boxes which are synchronized with SRDF. At the target site, we have BCV volumes. We want to open reporting database on a daily basis. Now we can open target database with the same AIX volume group as the primary database. My question is do you have experience in renaming AIX volume group, so we can have two databases on the same machine (SRDF target and BCV)? We have some experience in doing that manually, but we're interested in having some scripts. Please help. TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE : Table partition on part of a field
One thing to consider is adding a field to the table for the three positions and have a trigger fire to insert the substr from the other field. It will slow things down, but would give you the field needed to do the partioning. Terry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:06 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE : Table partition on part of a field I thought about it, but there are many update programs and my first inclination is to leave the design as is. We are talking about PORTING application and I do not want to add design changes as well. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 11:02 PM To: Multiple recipients of list ORACLE-L Subject:RE : Table partition on part of a field Make it two fields 6 3 Partition on 3 And create a view to concatenate the two fields into one Regards, Waleed -Original Message- Sent: Tuesday, January 15, 2002 12:50 PM To: Multiple recipients of list ORACLE-L Hello All I need to create a partitioned table base on the last three digits on 9 digits number. Create table test (zip_and_city_code number(9)); The zip code is 6 digits and the city code is 3 digits. The design is from an application that used btrieve and is now ported to Oracle. (I would not allow this design if it was a new system). I want to group every city records into its own partition. First I tried to use range partitioning based on a function on the field and it does not work. Then I thought about using hash partitioning using my own hash function but could not find where I can use my own hash function. Any help to implement this @#$% design will be really appreciated. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Calling a procedure from a procedure
I need to execute a procedure with in a loop of another. I need to pass a variable to the second procedure. I am using Execute, looks like this:Execute Primus_Dump_TEST_2(Solution); Getting this error:PLS-00103: Encountered the symbol "PRIMUS_DUMP_TEST_2" when expecting one of the following: := . ( @ % ;The symbol ":=" was substituted for "PRIMUS_DUMP_TEST_2" to continue. I am using Toad as my editor. I am doing it as follows: Open Primus_solution; loop /* Add next three lines */ fetch primus_solution into solution; exit when primus_solution%NOTFOUND;dbms_output.put_line (Solution);Execute Primus_Dump_TEST_2(Solution); End LOOP; Close Primus_solution;
mystery cartesian join
Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = 1 / Here is the output from the tkprof: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, :SYS_B_0 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = :SYS_B_1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.71 1.68 3114 3540 4 1 --- -- -- -- -- -- -- total4 0.71 1.68 3114 3540 4 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 (SITEMON) Rows Row Source Operation --- --- 1 NESTED LOOPS 2 MERGE JOIN CARTESIAN 2VIEW V_SI_LAST_FAQ_LOG 2 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID SI_LOG 3629 INDEX RANGE SCAN (object id 3281) 2SORT JOIN 1 TABLE ACCESS FULL SI_MONITOR 1 TABLE ACCESS BY INDEX ROWID SM_LOG_TYPE 2INDEX UNIQUE SCAN (object id 3318) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 1 NESTED LOOPS 2MERGE JOIN (CARTESIAN) 2 VIEW OF 'V_SI_LAST_FAQ_LOG' 2 SORT (ORDER BY) 1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SI_LOG' 3629INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SI_LOG_INT_IDX' (NON-UNIQUE) 2 SORT (JOIN) 1 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SI_MONITOR' 1TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SM_LOG_TYPE' 2 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SM_LOG_TYPE_PK' (UNIQUE) Here is the syntax from my view (v_si_last_faq_log): SELECT error_id last_error_id, interface_id, error_type_id, ewhen, request_time FROM si_log WHERE last_faq_log = 'Y' ORDER BY error_id / Any help would be appreciated. Thanks in Advance ReedK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Calling a procedure from a procedure
I believe you don't need the execute within pl/sql --- Lance Prais [EMAIL PROTECTED] wrote: I need to execute a procedure with in a loop of another. I need to pass a variable to the second procedure. I am using Execute, looks like this: Execute Primus_Dump_TEST_2(Solution); Getting this error: PLS-00103: Encountered the symbol PRIMUS_DUMP_TEST_2 when expecting one of the following: := . ( @ % ; The symbol := was substituted for PRIMUS_DUMP_TEST_2 to continue. I am using Toad as my editor. I am doing it as follows: Open Primus_solution; loop /* Add next three lines */ fetch primus_solution into solution; exit when primus_solution%NOTFOUND; dbms_output.put_line (Solution); Execute Primus_Dump_TEST_2(Solution); End LOOP; Close Primus_solution; __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Calling a procedure from a procedure
Lance, just remove the word 'execute' -Original Message-From: Lance Prais [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 10:57 AMTo: Multiple recipients of list ORACLE-LSubject: Calling a procedure from a procedure I need to execute a procedure with in a loop of another. I need to pass a variable to the second procedure. I am using Execute, looks like this:Execute Primus_Dump_TEST_2(Solution); Getting this error:PLS-00103: Encountered the symbol "PRIMUS_DUMP_TEST_2" when expecting one of the following: := . ( @ % ;The symbol ":=" was substituted for "PRIMUS_DUMP_TEST_2" to continue. I am using Toad as my editor. I am doing it as follows: Open Primus_solution; loop /* Add next three lines */ fetch primus_solution into solution; exit when primus_solution%NOTFOUND;dbms_output.put_line (Solution);Execute Primus_Dump_TEST_2(Solution); End LOOP; Close Primus_solution;
RE: Calling a procedure from a procedure
Dont use the execute. Primus_Dump_TEST_2(Solution); Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Lance Prais Sent: Wednesday, January 16, 2002 9:57 AM To: Multiple recipients of list ORACLE-L Subject: Calling a procedure from a procedure I need to execute a procedure with in a loop of another. I need to pass a variable to the second procedure. I am using Execute, looks like this: Execute Primus_Dump_TEST_2(Solution); Getting this error: PLS-00103: Encountered the symbol PRIMUS_DUMP_TEST_2 when expecting one of the following: := . ( @ % ; The symbol := was substituted for PRIMUS_DUMP_TEST_2 to continue. I am using Toad as my editor. I am doing it as follows: Open Primus_solution; loop /* Add next three lines */ fetch primus_solution into solution; exit when primus_solution%NOTFOUND; dbms_output.put_line (Solution); Execute Primus_Dump_TEST_2(Solution); End LOOP; Close Primus_solution;
call vs execute - stored procedures
I am working up a script to run the dbms_stats.gather_database_stats() procedure and have run into something for which I haven't yet found an explanation. Maybe someone here can tell me why I can run dbms_stats.gather_database_stats from Python like this (Perl would be similar, I believe, since I found the fix in a Perl list archive) cursor.execute(BEGIN dbms_stats.gather_database_stats(); END; ) but not like this: cursor.execute(call dbms_stats.gather_database_stats()) Call works for other stored procedures, dbms_utility.analyze_schema() for instance, but not for dbms_stats. So, what's the difference? Thanks, Glenn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT -: SQL BackTrack info
Title: Message I am looking for some guidance from people who use this product. Is it a value add to the organization or not. If possible also let me know how in the hell does it do a online object extraction from the backup. Would appreciate all your comments and recommendations Thx Gautam
Re: Which Character set?
Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT -: SQL BackTrack info
It was a good product when owned by Data Tools. It is now owned by BMC, and the support is poor. My experience with this tool is as of December 2000. As far as object extraction, it did not work as of December of 2000. They had been claiming that it would for some time, but the DBA in charge of the product at our shop could not get it to work. Jared Gautam_Reddy@D ell.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: OT -: SQL BackTrack info om 01/16/02 08:55 AM Please respond to ORACLE-L I am looking for some guidance from people who use this product. Is it a value add to the organization or not. If possible also let me know how in the hell does it do a online object extraction from the backup. Would appreciate all your comments and recommendations Thx Gautam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: mystery cartesian join
It's impossible to precisely determine where the cartesian product is coming from with out knowing the primary keys of the si_monitor and sm_log_type slt tables. If your join does not include all columns of the parent table(s), there is the possibility of a cartesian product. ( it's data dependant ) Jared Kempf, Reed rkempf@rightn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ow.com cc: Sent by: Subject: mystery cartesian join [EMAIL PROTECTED] om 01/16/02 09:10 AM Please respond to ORACLE-L Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = 1 / Here is the output from the tkprof: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, :SYS_B_0 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = :SYS_B_1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.71 1.68 3114 3540 4 1 --- -- -- -- -- -- -- total4 0.71 1.68 3114 3540 4 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 (SITEMON) Rows Row Source Operation --- --- 1 NESTED LOOPS 2 MERGE JOIN CARTESIAN 2VIEW V_SI_LAST_FAQ_LOG 2 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID SI_LOG 3629 INDEX RANGE SCAN (object id 3281) 2SORT JOIN 1 TABLE ACCESS FULL SI_MONITOR 1 TABLE ACCESS BY INDEX ROWID SM_LOG_TYPE 2INDEX UNIQUE SCAN (object id 3318) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 1 NESTED LOOPS 2MERGE JOIN (CARTESIAN) 2 VIEW OF 'V_SI_LAST_FAQ_LOG' 2 SORT (ORDER BY) 1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SI_LOG' 3629INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SI_LOG_INT_IDX' (NON-UNIQUE) 2 SORT (JOIN)
RE: designer6i vs. designer2000
And interestingly enough, a DBA could be much more productive with CASE 5.1 and Forms 3 than would ever be possible on the GUI versions. Jared Kimberly SmithTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ksmith2@myfirs cc: tlink.netSubject: RE: designer6i vs. designer2000 Sent by: [EMAIL PROTECTED] m 01/16/02 06:55 AM Please respond to ORACLE-L They are just different tools of the same product and not one I would choose to learn if all I wanted to learn was data modeling. It is a tool that is best used for the complete life cycle, from process modeling, all the way to generating your code. Unless you are committed to doing that (with maybe the exception of the first step) you really do not get very much benefit from the tool. Its best used with larger projects. That being said, since I know the tool and used to have it in-house, I would use it just for data modeling. Its not an easy tool to learn. When I started using it was the days of CASE 5.1 and moved up in versions. It really is best to bring in an expert if you are going to start using for a project. We brought one in that was just there to guide us in using the tool. His sole purpose. And we would have died without him. -Original Message- Oracle Sent: Tuesday, January 15, 2002 10:05 PM To: Multiple recipients of list ORACLE-L Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list,
Re: call vs execute - stored procedures
Glenn, I believe that CALL needs to be terminated with a semicolon. Jared Glenn Stauffer stauffer@swart To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hmore.educc: Sent by: Subject: call vs execute - stored procedures [EMAIL PROTECTED] m 01/16/02 08:55 AM Please respond to ORACLE-L I am working up a script to run the dbms_stats.gather_database_stats() procedure and have run into something for which I haven't yet found an explanation. Maybe someone here can tell me why I can run dbms_stats.gather_database_stats from Python like this (Perl would be similar, I believe, since I found the fix in a Perl list archive) cursor.execute(BEGIN dbms_stats.gather_database_stats(); END; ) but not like this: cursor.execute(call dbms_stats.gather_database_stats()) Call works for other stored procedures, dbms_utility.analyze_schema() for instance, but not for dbms_stats. So, what's the difference? Thanks, Glenn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: mystery cartesian join
Reed, Please reply to the list as well. I don't seen any key information here. And taking a closer I caught the part about this join being done on views. Joining views can be problemetic. You need to ensure that the joins in a view ( if any ) are correct, and that all columns of the primary key are available from the view. These columns then need to be used to fully qualify the join. Jared Kempf, Reed rkempf@rightn To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ow.com cc: Subject: RE: mystery cartesian join 01/16/02 10:36 AM Jared, Thanks for the quick response. Here is some more information. The problem is that the query is taking 1.6 seconds to complete when I think it should take milliseconds to complete. Here are the structures of the 2 tables. I check my indexes and keys and all appear to OK. desc si_monitor (the interface_id is a foreign key) This table has 1500 rows in it and does not grow that fast. Name Null?Type - INTERFACE_ID NUMBER(10) ERROR_CHECKVARCHAR2(1) ERROR_TIME DATE MONITORVARCHAR2(1) TIMEOUT_VALNUMBER(3) BROKEN_OK VARCHAR2(1) desc sm_log_type (the error_type_id is the primary key) This table has a static 14 rows in it. Name Null?Type - ERROR_TYPE_ID NOT NULL NUMBER(8) SHORTNAME NOT NULL VARCHAR2(30) WARN_TIME NUMBER ERROR_TIME NUMBER WARN_EMAIL VARCHAR2(4000) ERROR_EMAILVARCHAR2(4000) WARN_TEXT VARCHAR2(4000) ERROR_TEXT VARCHAR2(4000) WARN VARCHAR2(1) F_WARN VARCHAR2(1) DESCRIPTIONVARCHAR2(250) Thanks again. ReedK -Original Message- Sent: Wednesday, January 16, 2002 11:21 AM To: [EMAIL PROTECTED] Cc: Kempf, Reed It's impossible to precisely determine where the cartesian product is coming from with out knowing the primary keys of the si_monitor and sm_log_type slt tables. If your join does not include all columns of the parent table(s), there is the possibility of a cartesian product. ( it's data dependant ) Jared Kempf, Reed rkempf@rightn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ow.com cc: Sent by: Subject: mystery cartesian join [EMAIL PROTECTED] om 01/16/02 09:10 AM Please respond to ORACLE-L Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm,
RE: Re: Which Character set?
We use WE8ISO8859P1 as a corporate standard for all databases globally with no problem. Haven't tried UTF8 yet though. Jim Ron Thomas [EMAIL PROTECTED] wrote: Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to set DBWR_WRITE_PROCESSES in Oracle8i?
Thanks Kirti and Paul for the reply. The instance is up for only 3 days. We know there are very heavy inserts in the database. Yes, There are high waits for 'buffer busy waits' event in V$SYSTEM_EVENT view. But I didn't see 'buffer busy waits' in V$SESSION_EVENT. I may try to increase the freelist to 12(I don't know whether it helps, anyway we have 12 Java threads insert data into the same table concurrently). Thanks, Chris --- Deshpande, Kirti [EMAIL PROTECTED] wrote: How long has the instance been up? It appears that the application is trying to read the same data blocks /or more sessions are trying to update the same data block or the free lists may need to be set properly to support concurrent INSERTs. So, before changing anything for DBWR process, I would suggest to check the top wait events from V$SYSTEM_EVENT view. You may see high waits for 'buffer busy wait' event. If so, I would trace it further using V$SESSION_EVENT and V$SESSION_WAIT (P1, P2 values) to find out the 'hot' segment and the file. You may have to review the pctfree, freelists, extent sizes etc. to address 'buffer busy waits'. For all you know, it could be just an application issue in scheduling the processes properly. And to answer your question about setting DBWR_WRITE_PROCESSES(actually the parameter is DB_WRITER_PROCESSES) you may want to check out Note# 97291.1 on Metalink. It has some good information. HTH, - Kirti -Original Message- Sent: Tuesday, January 15, 2002 7:16 PM To: Multiple recipients of list ORACLE-L Hi, gurus: The database is oracle8.1.7.2.1 on win2k machine with 1 CPU and two hard drives. When I query v$waitstat, I got the following: CLASS COUNT TIME -- -- -- data block 246901435 132690159 segment header 4869 8018 undo block 20986 38476 undo header 1895 1556 seems like I need to set DBWR_WRITE_PROCESSES to a higher number, what number should I choose, 2 or bigger? Also, what other problems can you see from the last query, other than we need to add some more RBS? Thanks, Chris Harvest. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: mystery cartesian join
Title: RE: mystery cartesian join are the joins themselves correct? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: mystery cartesian join It's impossible to precisely determine where the cartesian product is coming from with out knowing the primary keys of the si_monitor and sm_log_type slt tables. If your join does not include all columns of the parent table(s), there is the possibility of a cartesian product. ( it's data dependant ) Jared Kempf, Reed rkempf@rightn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ow.com cc: Sent by: Subject: mystery cartesian join [EMAIL PROTECTED] om 01/16/02 09:10 AM Please respond to ORACLE-L Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = 1 / Here is the output from the tkprof: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, :SYS_B_0 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = :SYS_B_1 call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.71 1.68 3114 3540 4 1 --- -- -- -- -- -- -- total 4 0.71 1.68 3114 3540 4 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 (SITEMON) Rows Row Source Operation --- --- 1 NESTED LOOPS 2 MERGE JOIN CARTESIAN 2 VIEW V_SI_LAST_FAQ_LOG 2 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID SI_LOG 3629 INDEX RANGE SCAN (object id 3281) 2 SORT JOIN 1 TABLE ACCESS FULL SI_MONITOR 1 TABLE ACCESS BY INDEX ROWID SM_LOG_TYPE 2 INDEX UNIQUE SCAN (object id 3318) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 1 NESTED LOOPS 2 MERGE JOIN (CARTESIAN) 2 VIEW OF 'V_SI_LAST_FAQ_LOG' 2 SORT (ORDER BY) 1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SI_LOG' 3629 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SI_LOG_INT_IDX' (NON-UNIQUE) 2 SORT (JOIN) 1 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SI_MONITOR' 1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SM_LOG_TYPE' 2 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SM_LOG_TYPE_PK' (UNIQUE) Here is the syntax from my view (v_si_last_faq_log): SELECT error_id last_error_id, interface_id, error_type_id, ewhen, request_time FROM si_log WHERE last_faq_log = 'Y' ORDER BY error_id / Any help would be appreciated. Thanks in Advance ReedK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: mystery cartesian join
This may be a STAR schema execution plan where Oracle joins dimensions and use Nested loop + index to join it to the fact. Some times it's very efficient but if you do not like it I think there is a parameter in init.ora that disables it. Regards, Waleed -Original Message- Sent: Wednesday, January 16, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = 1 / Here is the output from the tkprof: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, :SYS_B_0 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = :SYS_B_1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.71 1.68 3114 3540 4 1 --- -- -- -- -- -- -- total4 0.71 1.68 3114 3540 4 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 (SITEMON) Rows Row Source Operation --- --- 1 NESTED LOOPS 2 MERGE JOIN CARTESIAN 2VIEW V_SI_LAST_FAQ_LOG 2 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID SI_LOG 3629 INDEX RANGE SCAN (object id 3281) 2SORT JOIN 1 TABLE ACCESS FULL SI_MONITOR 1 TABLE ACCESS BY INDEX ROWID SM_LOG_TYPE 2INDEX UNIQUE SCAN (object id 3318) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 1 NESTED LOOPS 2MERGE JOIN (CARTESIAN) 2 VIEW OF 'V_SI_LAST_FAQ_LOG' 2 SORT (ORDER BY) 1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SI_LOG' 3629INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SI_LOG_INT_IDX' (NON-UNIQUE) 2 SORT (JOIN) 1 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SI_MONITOR' 1TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SM_LOG_TYPE' 2 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SM_LOG_TYPE_PK' (UNIQUE) Here is the syntax from my view (v_si_last_faq_log): SELECT error_id last_error_id, interface_id, error_type_id, ewhen, request_time FROM si_log WHERE last_faq_log = 'Y' ORDER BY error_id / Any help would be appreciated. Thanks in Advance ReedK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Re: Which Character set?
Ron, Can you elaborate on the pains you are having getting UTF8 working correctly? We are preparing to convert some databases to UTF8. I'd appreciate any specific details that you can provide. We are using 8.1.7.2 and 9.0.1 on Sun Solaris 2.6. Cherie Machler Oracle DBA Gelco Information Network Ron Thomas rthomas@hyper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com.com cc: Sent by: Subject: Re: Which Character set? [EMAIL PROTECTED] om 01/16/02 10:55 AM Please respond to ORACLE-L Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Re: FW: new to DBA
*warning* if using the following material on human subjects, do not get in ears of damagers, they are usually already obstructed beyond repair, but in case some use of the ears can be redeemed, the use of said product would simply make the effort to get damagement to listen all that much harder. any other body cavity is ok. http://www.geocelusa.com/r/tds/min_exp_foam.php excerpts: Geocel Minimal Expanding Foam Sealant is a single component polyurethane foam designed to fill gaps, cracks, etc. ... Geocel Minimal Expanding Foam Sealant is an isocyanate/ polyol prepolymer foam. Ingredients include surfactants for emulsion stabilization, a fire retardant ... 4. Apparent Density (ASTM D 1622) 1.7 pcf [note: this is approximately the same as you average damager's brain, so consider it as a replacement material if emptiness is observed, per local project requirements] ... Surface preparation: All surfaces to be foamed should be clean, free of dust, dirt, oil or similar materials. Application: Sealant should be applied in well ventilated area, or with respiratory protection. For best results, use sealant with sufficient atmospheric humidity. Deep, dry, cavities may need to be moistened before application. However, too much wetness will interfere with adhesion. Fill the lowest part of the cavity first. Fill cavities only 50% full. Temperature of the surface to be foamed should be 23° F. to 95° F. (-5° C. to 35° C). ... No maintenance is required. If Sealant is damaged remove damaged area of foam and reseal with Minimal Expanding Foam Sealant. ... Geocel representatives throughout the United States are available to provide technical assistance. Geocel Corporation's technical staff and laboratory facilities are equipped to respond to specific requests. For further information and/or applications testing, call 800-348-7615. On 15 Jan 2002 at 21:00, [deleted for privacy] wrote: To: [EMAIL PROTECTED] Date sent: Tue, 15 Jan 2002 21:00:55 -0800 OK, I don't even want to know how you know about that site;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Eric D. Pierce Sent: Tuesday, January 15, 2002 4:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: new to DBA ORACLE-L Digest -- Volume 2002, Number 015 -- From: Dwayne Cox [EMAIL PROTECTED] Date: Mon, 14 Jan 2002 10:45:07 -0500 Subject: Re: new to DBA ... Oh, and have fun! something you might need for meetings with damagement: http://www.fishock.com/catalog/5prods.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT -: SQL BackTrack info
We have been using it for about 5 years on both Unix and NT. We have it connected to Netbackup to handle the tapes. We love it. I agree that the support is not what it used to be but we hardly ever need support. Although, the last time we called we got a support person that knew more about Oracle than we did and knew SQL Backtrack inside and out. It's a great tool! Ron Smith Kerr-McGee Corp -Original Message- Sent: Wednesday, January 16, 2002 10:55 AM To: Multiple recipients of list ORACLE-L I am looking for some guidance from people who use this product. Is it a value add to the organization or not. If possible also let me know how in the hell does it do a online object extraction from the backup. Would appreciate all your comments and recommendations Thx Gautam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: mystery cartesian join
Reed, What is the structure of the SI_LOG table (the one being accessed by the view). Furthermore, what is a MERGE JOIN CARTESIAN - anybody? I am thinking that this is normal, in that the query was broken up into two distinct parts, and the results of those parts should be MERGE JOIN CARTESIAN to get the correct results. Anybody? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Reed, Please reply to the list as well. I don't seen any key information here. And taking a closer I caught the part about this join being done on views. Joining views can be problemetic. You need to ensure that the joins in a view ( if any ) are correct, and that all columns of the primary key are available from the view. These columns then need to be used to fully qualify the join. Jared Kempf, Reed rkempf@rightn To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ow.com cc: Subject: RE: mystery cartesian join 01/16/02 10:36 AM Jared, Thanks for the quick response. Here is some more information. The problem is that the query is taking 1.6 seconds to complete when I think it should take milliseconds to complete. Here are the structures of the 2 tables. I check my indexes and keys and all appear to OK. desc si_monitor (the interface_id is a foreign key) This table has 1500 rows in it and does not grow that fast. Name Null?Type - INTERFACE_ID NUMBER(10) ERROR_CHECKVARCHAR2(1) ERROR_TIME DATE MONITORVARCHAR2(1) TIMEOUT_VALNUMBER(3) BROKEN_OK VARCHAR2(1) desc sm_log_type (the error_type_id is the primary key) This table has a static 14 rows in it. Name Null?Type - ERROR_TYPE_ID NOT NULL NUMBER(8) SHORTNAME NOT NULL VARCHAR2(30) WARN_TIME NUMBER ERROR_TIME NUMBER WARN_EMAIL VARCHAR2(4000) ERROR_EMAILVARCHAR2(4000) WARN_TEXT VARCHAR2(4000) ERROR_TEXT VARCHAR2(4000) WARN VARCHAR2(1) F_WARN VARCHAR2(1) DESCRIPTIONVARCHAR2(250) Thanks again. ReedK -Original Message- Sent: Wednesday, January 16, 2002 11:21 AM To: [EMAIL PROTECTED] Cc: Kempf, Reed It's impossible to precisely determine where the cartesian product is coming from with out knowing the primary keys of the si_monitor and sm_log_type slt tables. If your join does not include all columns of the parent table(s), there is the possibility of a cartesian product. ( it's data dependant ) Jared Kempf, Reed rkempf@rightn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ow.com cc: Sent by: Subject: mystery cartesian join [EMAIL PROTECTED] om 01/16/02 09:10 AM Please respond to ORACLE-L Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = 1 / Here is the output from the tkprof:
RE: How to set DBWR_WRITE_PROCESSES in Oracle8i?
Title: RE: How to set DBWR_WRITE_PROCESSES in Oracle8i? Since I didn't see this yet, I thought I might add it in. Try increasing the PCTFREE, perhaps there are two many transactions happening in the same block, and oracle is locking the entire block until the other transaction if finished. I know this is pretty common on multi-threaded updates, and PCTFREE is a great fix, but I'm not sure how much of a performance gain it will be for inserts. Another thing, partition the table, so that the physical disk does not get hammered. It could just be IO limitations. In this case, 12 partitions each set up for a java load would work perfectly... or you might just want to hash partition it. -Original Message- From: CC Harvest [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to set DBWR_WRITE_PROCESSES in Oracle8i? Thanks Kirti and Paul for the reply. The instance is up for only 3 days. We know there are very heavy inserts in the database. Yes, There are high waits for 'buffer busy waits' event in V$SYSTEM_EVENT view. But I didn't see 'buffer busy waits' in V$SESSION_EVENT. I may try to increase the freelist to 12(I don't know whether it helps, anyway we have 12 Java threads insert data into the same table concurrently). Thanks, Chris --- Deshpande, Kirti [EMAIL PROTECTED] wrote: How long has the instance been up? It appears that the application is trying to read the same data blocks /or more sessions are trying to update the same data block or the free lists may need to be set properly to support concurrent INSERTs. So, before changing anything for DBWR process, I would suggest to check the top wait events from V$SYSTEM_EVENT view. You may see high waits for 'buffer busy wait' event. If so, I would trace it further using V$SESSION_EVENT and V$SESSION_WAIT (P1, P2 values) to find out the 'hot' segment and the file. You may have to review the pctfree, freelists, extent sizes etc. to address 'buffer busy waits'. For all you know, it could be just an application issue in scheduling the processes properly. And to answer your question about setting DBWR_WRITE_PROCESSES(actually the parameter is DB_WRITER_PROCESSES) you may want to check out Note# 97291.1 on Metalink. It has some good information. HTH, - Kirti -Original Message- Sent: Tuesday, January 15, 2002 7:16 PM To: Multiple recipients of list ORACLE-L Hi, gurus: The database is oracle8.1.7.2.1 on win2k machine with 1 CPU and two hard drives. When I query v$waitstat, I got the following: CLASS COUNT TIME -- -- -- data block 246901435 132690159 segment header 4869 8018 undo block 20986 38476 undo header 1895 1556 seems like I need to set DBWR_WRITE_PROCESSES to a higher number, what number should I choose, 2 or bigger? Also, what other problems can you see from the last query, other than we need to add some more RBS? Thanks, Chris Harvest. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE
RE: mystery cartesian join
Here is the structure of the underlying base table si_log table. I also do not know what a MERGE CARTESIAN JOIN is. The data returned is correct and the tkprof output looks OK except for the elapsed time the query took and the cartesian join portion. desc si_log Name Null?Type - ERROR_ID NOT NULL NUMBER (PK) ERROR_TYPE_ID NOT NULL NUMBER(8) (FK) to sm_log_type slt EWHEN NOT NULL DATE INTERFACE_ID NOT NULL NUMBER (FK) to si_interfaces si REQUEST_TIME NUMBER LAST_LOG VARCHAR2(1) FAQ_REQUEST_TIME NUMBER LAST_FAQ_LOG VARCHAR2(1) ReedK -Original Message- Sent: Wednesday, January 16, 2002 12:23 PM To: '[EMAIL PROTECTED]' Cc: Kempf, Reed Reed, What is the structure of the SI_LOG table (the one being accessed by the view). Furthermore, what is a MERGE JOIN CARTESIAN - anybody? I am thinking that this is normal, in that the query was broken up into two distinct parts, and the results of those parts should be MERGE JOIN CARTESIAN to get the correct results. Anybody? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Reed, Please reply to the list as well. I don't seen any key information here. And taking a closer I caught the part about this join being done on views. Joining views can be problemetic. You need to ensure that the joins in a view ( if any ) are correct, and that all columns of the primary key are available from the view. These columns then need to be used to fully qualify the join. Jared Kempf, Reed rkempf@rightn To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ow.com cc: Subject: RE: mystery cartesian join 01/16/02 10:36 AM Jared, Thanks for the quick response. Here is some more information. The problem is that the query is taking 1.6 seconds to complete when I think it should take milliseconds to complete. Here are the structures of the 2 tables. I check my indexes and keys and all appear to OK. desc si_monitor (the interface_id is a foreign key) This table has 1500 rows in it and does not grow that fast. Name Null?Type - INTERFACE_ID NUMBER(10) ERROR_CHECKVARCHAR2(1) ERROR_TIME DATE MONITORVARCHAR2(1) TIMEOUT_VALNUMBER(3) BROKEN_OK VARCHAR2(1) desc sm_log_type (the error_type_id is the primary key) This table has a static 14 rows in it. Name Null?Type - ERROR_TYPE_ID NOT NULL NUMBER(8) SHORTNAME NOT NULL VARCHAR2(30) WARN_TIME NUMBER ERROR_TIME NUMBER WARN_EMAIL VARCHAR2(4000) ERROR_EMAILVARCHAR2(4000) WARN_TEXT VARCHAR2(4000) ERROR_TEXT VARCHAR2(4000) WARN VARCHAR2(1) F_WARN VARCHAR2(1) DESCRIPTIONVARCHAR2(250) Thanks again. ReedK -Original Message- Sent: Wednesday, January 16, 2002 11:21 AM To: [EMAIL PROTECTED] Cc: Kempf, Reed It's impossible to precisely determine where the cartesian product is coming from with out knowing the primary keys of the si_monitor and sm_log_type slt tables. If your join does not include all columns of the parent table(s), there is the possibility of a cartesian product. ( it's data dependant ) Jared Kempf, Reed rkempf@rightn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ow.com cc: Sent by: Subject: mystery cartesian join [EMAIL PROTECTED] om 01/16/02 09:10
Raw I/O
Hi all I am looking for some real life opinions about Oracle raw I/O - are people using it, is there really a performance gain? Any other pros, cons? I have seen some info on Metalink but real life often is quite different... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to set DBWR_WRITE_PROCESSES in Oracle8i?
Chris, You should see the waits in V$SESSION_EVENT as well, as these are rolled in to the V$SYSTEM_EVENT. You have to query V$SESSION_EVENT when these thread are active. And you will have to query it repeatedly as it reports waits as and when session encounters some. I would also consider the impact on all the indexes for table where data is getting inserted. It will cause contention if all these processes are inserting index entries in the same general area. Reverse indexing may help some. I can comment much, as I have not yet used them in a production setup. Good luck, - Kirti -Original Message- Sent: Wednesday, January 16, 2002 12:48 PM To: Multiple recipients of list ORACLE-L Thanks Kirti and Paul for the reply. The instance is up for only 3 days. We know there are very heavy inserts in the database. Yes, There are high waits for 'buffer busy waits' event in V$SYSTEM_EVENT view. But I didn't see 'buffer busy waits' in V$SESSION_EVENT. I may try to increase the freelist to 12(I don't know whether it helps, anyway we have 12 Java threads insert data into the same table concurrently). Thanks, Chris --- Deshpande, Kirti [EMAIL PROTECTED] wrote: How long has the instance been up? It appears that the application is trying to read the same data blocks /or more sessions are trying to update the same data block or the free lists may need to be set properly to support concurrent INSERTs. So, before changing anything for DBWR process, I would suggest to check the top wait events from V$SYSTEM_EVENT view. You may see high waits for 'buffer busy wait' event. If so, I would trace it further using V$SESSION_EVENT and V$SESSION_WAIT (P1, P2 values) to find out the 'hot' segment and the file. You may have to review the pctfree, freelists, extent sizes etc. to address 'buffer busy waits'. For all you know, it could be just an application issue in scheduling the processes properly. And to answer your question about setting DBWR_WRITE_PROCESSES(actually the parameter is DB_WRITER_PROCESSES) you may want to check out Note# 97291.1 on Metalink. It has some good information. HTH, - Kirti -Original Message- Sent: Tuesday, January 15, 2002 7:16 PM To: Multiple recipients of list ORACLE-L Hi, gurus: The database is oracle8.1.7.2.1 on win2k machine with 1 CPU and two hard drives. When I query v$waitstat, I got the following: CLASS COUNT TIME -- -- -- data block 246901435 132690159 segment header 4869 8018 undo block 20986 38476 undo header 1895 1556 seems like I need to set DBWR_WRITE_PROCESSES to a higher number, what number should I choose, 2 or bigger? Also, what other problems can you see from the last query, other than we need to add some more RBS? Thanks, Chris Harvest. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
Re: Which Character set?
Given- - Oracle Applications 11.5.4 - HPUX 11.0 - Support for English, Brazilian Portuguese, and Simplied Chinese required UTF8 - DB, forms, reports, and Apache servers all run with NLS_LANG=American_America.UTF8 Problems- - Any Oracle reports generated require printing via a utility called pasta to handle the UTF8 characters. - Any sql*plus reports will need to be either filtered using iconv to convert to a code set that the printer understands, or a convert( column, 'WE8ISO8859P1') function will need to used for ever column on the extract. - Dev 2000 patch set 6 cleared up a lot of initial problems with forms. - We still have some nagging java codeset exceptions when a form is generated as UTF8. The biggest issue is with the 3 tier archetecture, and the servers running UTF8, the data returned from the database is going to coded UTF8. No printer that I know of supports this encoding and it must first be converted before printing. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... Cherie_Machler @gelco.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Which Character set? om 01/16/02 12:05 PM Please respond to ORACLE-L Ron, Can you elaborate on the pains you are having getting UTF8 working correctly? We are preparing to convert some databases to UTF8. I'd appreciate any specific details that you can provide. We are using 8.1.7.2 and 9.0.1 on Sun Solaris 2.6. Cherie Machler Oracle DBA Gelco Information Network Ron Thomas rthomas@hyper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com.com cc: Sent by: Subject: Re: Which Character set? [EMAIL PROTECTED] om 01/16/02 10:55 AM Please respond to ORACLE-L Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
RE: Raw I/O
Real life opinion from me: Yes, Oxford is using it. Yes, it is faster. Yes it makes it practically impossible to backup without a 3rd party backup tool. Yes, it is boring to chew raw vs. cooked debate over and over again. Why doesn't someone come up with something new and not yet discussed topic like RAID implementations and oracle? -Original Message- Sent: Wednesday, January 16, 2002 2:37 PM To: Multiple recipients of list ORACLE-L Hi all I am looking for some real life opinions about Oracle raw I/O - are people using it, is there really a performance gain? Any other pros, cons? I have seen some info on Metalink but real life often is quite different... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: mystery cartesian join
Title: RE: mystery cartesian join Maybe the optimizer thinks there's a many-to-many relationship between si_log and sm_monitor? Try putting in an ORDERED hint and see if that helps. Jeff T. -Original Message- From: Kempf, Reed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: mystery cartesian join Here is the structure of the underlying base table si_log table. I also do not know what a MERGE CARTESIAN JOIN is. The data returned is correct and the tkprof output looks OK except for the elapsed time the query took and the cartesian join portion. desc si_log Name Null? Type - ERROR_ID NOT NULL NUMBER (PK) ERROR_TYPE_ID NOT NULL NUMBER(8) (FK) to sm_log_type slt EWHEN NOT NULL DATE INTERFACE_ID NOT NULL NUMBER (FK) to si_interfaces si REQUEST_TIME NUMBER LAST_LOG VARCHAR2(1) FAQ_REQUEST_TIME NUMBER LAST_FAQ_LOG VARCHAR2(1) ReedK -Original Message- Sent: Wednesday, January 16, 2002 12:23 PM To: '[EMAIL PROTECTED]' Cc: Kempf, Reed Reed, What is the structure of the SI_LOG table (the one being accessed by the view). Furthermore, what is a MERGE JOIN CARTESIAN - anybody? I am thinking that this is normal, in that the query was broken up into two distinct parts, and the results of those parts should be MERGE JOIN CARTESIAN to get the correct results. Anybody? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Reed, Please reply to the list as well. I don't seen any key information here. And taking a closer I caught the part about this join being done on views. Joining views can be problemetic. You need to ensure that the joins in a view ( if any ) are correct, and that all columns of the primary key are available from the view. These columns then need to be used to fully qualify the join. Jared Kempf, Reed rkempf@rightn To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ow.com cc: Subject: RE: mystery cartesian join 01/16/02 10:36 AM Jared, Thanks for the quick response. Here is some more information. The problem is that the query is taking 1.6 seconds to complete when I think it should take milliseconds to complete. Here are the structures of the 2 tables. I check my indexes and keys and all appear to OK. desc si_monitor (the interface_id is a foreign key) This table has 1500 rows in it and does not grow that fast. Name Null? Type - INTERFACE_ID NUMBER(10) ERROR_CHECK VARCHAR2(1) ERROR_TIME DATE MONITOR VARCHAR2(1) TIMEOUT_VAL NUMBER(3) BROKEN_OK VARCHAR2(1) desc sm_log_type (the error_type_id is the primary key) This table has a static 14 rows in it. Name Null? Type - ERROR_TYPE_ID NOT NULL NUMBER(8) SHORTNAME NOT NULL VARCHAR2(30) WARN_TIME NUMBER ERROR_TIME NUMBER WARN_EMAIL VARCHAR2(4000) ERROR_EMAIL VARCHAR2(4000) WARN_TEXT VARCHAR2(4000) ERROR_TEXT VARCHAR2(4000) WARN VARCHAR2(1) F_WARN VARCHAR2(1) DESCRIPTION VARCHAR2(250) Thanks again. ReedK -Original Message- Sent: Wednesday, January 16, 2002 11:21 AM To: [EMAIL PROTECTED] Cc: Kempf, Reed It's impossible to precisely determine where the cartesian product is coming from with out knowing the primary keys of the si_monitor and sm_log_type slt tables. If your join does not include all columns of the parent table(s), there is the possibility of a cartesian product. ( it's data dependant ) Jared Kempf, Reed rkempf@rightn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ow.com cc: Sent by: Subject: mystery cartesian join [EMAIL PROTECTED] om 01/16/02 09:10 AM Please respond to ORACLE-L Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = 1 / Here is the output from the tkprof: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, :SYS_B_0 * (sysdate -
RE: mystery cartesian join
A MERGE CARTESIAN JOIN is one of the new paths the optimizer can take in Oracle 8(i?) If you really, truely are not missing a join clause, the following may be what is happening Basically, what Oracle does is perform a cartesian product (CT) on 2 tables via a merge-join operation. Generally one of the tables is extremely small (a couple datablocks or less) Then the resulting CT is joined with the rest of the tables are joined in. Yes, Virginia, Oracle sometimes voluntarily performs a CT as part of its optimization logic. I've seen it be the optimal join path for a large query and I've seen it suck the life out of a query. HTH Caver -Original Message- Sent: Wednesday, January 16, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Here is the structure of the underlying base table si_log table. I also do not know what a MERGE CARTESIAN JOIN is. The data returned is correct and the tkprof output looks OK except for the elapsed time the query took and the cartesian join portion. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Database Views
I would like get your opinion on what would be the best way provide access to data across multiple databases on just on Node (database). One way that I have tried is create a view on one database that reads tables across remaining four databases using Dblinks. Let us say there is a table called CUSTOMER that resides on five databases, in order to make it easier to generate reports, a combined view can be created with dblinks on these tables using UNION ALL on one database. Only concern I have is that when using Dblinks, Oracle might copy the entire remote table to the local database and then retrieve the data based on where clause. This might be a significant performance issue especially if the tables are very BIG. If there are better ways to accomplish this or any ideas on this one will be greatly appreciated. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Which Character set?
There is also a problem with 8.0.5 Client software not being happy with the ISO8859 part 15 characterset. The symptoms are that of either not displaying certain characters or displaying spurious chars (whatever is in the given code page for the given value from the database...) The only thing that is gained in Part 15 from that of Part1 is the Euro symbol. Martin http://oracle-rescue.com -Original Message- Sent: 16 January 2002 16:55 To: Multiple recipients of list ORACLE-L Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Raw I/O
Hey now, be nice :-). The best thing is to point people towards the archives. Martin http://oracle-rescue.com -Original Message- Mladen Sent: 16 January 2002 19:57 To: Multiple recipients of list ORACLE-L Real life opinion from me: Yes, Oxford is using it. Yes, it is faster. Yes it makes it practically impossible to backup without a 3rd party backup tool. Yes, it is boring to chew raw vs. cooked debate over and over again. Why doesn't someone come up with something new and not yet discussed topic like RAID implementations and oracle? -Original Message- Sent: Wednesday, January 16, 2002 2:37 PM To: Multiple recipients of list ORACLE-L Hi all I am looking for some real life opinions about Oracle raw I/O - are people using it, is there really a performance gain? Any other pros, cons? I have seen some info on Metalink but real life often is quite different... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 calculate user load on the system
Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ... I have been asked a simple question, and I am stumped ... Given a set of users, how to calculate the load they are putting on the system when using our application (CPU, MEMORY etc). We have 8161 running on DGUX (yeah, I know ...) Forms application, Oracle Reports, SQR reports, sql scripts, and two traffic using db_links with couple of other databases. Is anyone doing this? What is the best approach? Thanks in advance for your ideas ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 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: Using procedures instead of coding update/insert
That was me who made that statement about prepared statements being faster than stored procedures. It was not a general statement.. As my e-mail states, we have done some testing. Our test included inserts into more than 10 different tables on different system configurations (Sparc solaris-E-4500 oracle8i, oracle8i on linux and 8i on NT). We did use bind variables for both stored procedures and prepared statements but found prepared statements to be faster for inserts and deletes. The only thing we did not use was bulk binding and that we can not use based on our project requirements. Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: mystery cartesian join
Hey guys you have not heard about STAR SCHEMA execution plan? -Original Message- Sent: Wednesday, January 16, 2002 1:48 PM To: Multiple recipients of list ORACLE-L This may be a STAR schema execution plan where Oracle joins dimensions and use Nested loop + index to join it to the fact. Some times it's very efficient but if you do not like it I think there is a parameter in init.ora that disables it. Regards, Waleed -Original Message- Sent: Wednesday, January 16, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am selecting from. I have also recently rebuilt my indexes and analyzed all tables. One other point is that I am joining across schemas by way of synonyms. The si_monitor table resides in a separate schema. H? Here is my query: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, 86400 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = 1 / Here is the output from the tkprof: SELECT vslfl.error_type_id error_type_id, vslfl.interface_id, sm.error_check, :SYS_B_0 * (sysdate - sm.error_time) err_secs, slt.warn, slt.shortname FROM v_si_last_faq_log vslfl, si_monitor sm, sm_log_type slt WHERE vslfl.interface_id = sm.interface_id AND vslfl.error_type_id = slt.error_type_id AND vslfl.interface_id = :SYS_B_1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.71 1.68 3114 3540 4 1 --- -- -- -- -- -- -- total4 0.71 1.68 3114 3540 4 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 (SITEMON) Rows Row Source Operation --- --- 1 NESTED LOOPS 2 MERGE JOIN CARTESIAN 2VIEW V_SI_LAST_FAQ_LOG 2 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID SI_LOG 3629 INDEX RANGE SCAN (object id 3281) 2SORT JOIN 1 TABLE ACCESS FULL SI_MONITOR 1 TABLE ACCESS BY INDEX ROWID SM_LOG_TYPE 2INDEX UNIQUE SCAN (object id 3318) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 1 NESTED LOOPS 2MERGE JOIN (CARTESIAN) 2 VIEW OF 'V_SI_LAST_FAQ_LOG' 2 SORT (ORDER BY) 1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SI_LOG' 3629INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SI_LOG_INT_IDX' (NON-UNIQUE) 2 SORT (JOIN) 1 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SI_MONITOR' 1TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'SM_LOG_TYPE' 2 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SM_LOG_TYPE_PK' (UNIQUE) Here is the syntax from my view (v_si_last_faq_log): SELECT error_id last_error_id, interface_id, error_type_id, ewhen, request_time FROM si_log WHERE last_faq_log = 'Y' ORDER BY error_id / Any help would be appreciated. Thanks in Advance ReedK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this
RE: OT -: SQL BackTrack info
Its a great product for the price. I have used it in and out for 5 years internationally and truly it is the best backup/recovery product we have. There are some pros and cons to using the tool: Pros: 1. Great product, works brilliant works all the time. 2. Upgrades are simple. Cons: 1. Price 2. Support is a mess(most of the time) 3. You have to read the whole manual to understand it. Never skip pages on that. 4. FOLLOW THEIR INSTURCTIONS. MOST IMPORTANT. NO PRESUMPTIONS ALLOWED. Whether it is to install or deinstall, You have to follow their step by step instructions for it to work properly. We tried several ways for the product to work properly and finally surrendered to the manual. ORACLE DBAs - We cannot use the oracle technique for SQL B/T My 2 cents Srikanth -Original Message- Sent: Wednesday, January 16, 2002 1:14 PM To: Multiple recipients of list ORACLE-L We have been using it for about 5 years on both Unix and NT. We have it connected to Netbackup to handle the tapes. We love it. I agree that the support is not what it used to be but we hardly ever need support. Although, the last time we called we got a support person that knew more about Oracle than we did and knew SQL Backtrack inside and out. It's a great tool! Ron Smith Kerr-McGee Corp -Original Message- Sent: Wednesday, January 16, 2002 10:55 AM To: Multiple recipients of list ORACLE-L I am looking for some guidance from people who use this product. Is it a value add to the organization or not. If possible also let me know how in the hell does it do a online object extraction from the backup. Would appreciate all your comments and recommendations Thx Gautam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Valuthur, Srikanth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Which Character set?
Ron, Thanks for taking time to provide this detailed reply. It is quite helpful. Cherie Machler Gelco Information Network Ron Thomas rthomas@hyper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com.com cc: Sent by: Subject: Re: Which Character set? [EMAIL PROTECTED] om 01/16/02 01:56 PM Please respond to ORACLE-L Given- - Oracle Applications 11.5.4 - HPUX 11.0 - Support for English, Brazilian Portuguese, and Simplied Chinese required UTF8 - DB, forms, reports, and Apache servers all run with NLS_LANG=American_America.UTF8 Problems- - Any Oracle reports generated require printing via a utility called pasta to handle the UTF8 characters. - Any sql*plus reports will need to be either filtered using iconv to convert to a code set that the printer understands, or a convert( column, 'WE8ISO8859P1') function will need to used for ever column on the extract. - Dev 2000 patch set 6 cleared up a lot of initial problems with forms. - We still have some nagging java codeset exceptions when a form is generated as UTF8. The biggest issue is with the 3 tier archetecture, and the servers running UTF8, the data returned from the database is going to coded UTF8. No printer that I know of supports this encoding and it must first be converted before printing. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... Cherie_Machler @gelco.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Which Character set? om 01/16/02 12:05 PM Please respond to ORACLE-L Ron, Can you elaborate on the pains you are having getting UTF8 working correctly? We are preparing to convert some databases to UTF8. I'd appreciate any specific details that you can provide. We are using 8.1.7.2 and 9.0.1 on Sun Solaris 2.6. Cherie Machler Oracle DBA Gelco Information Network Ron Thomas rthomas@hyper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com.com cc: Sent by: Subject: Re: Which Character set? [EMAIL PROTECTED] om 01/16/02 10:55 AM Please respond to ORACLE-L Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I
RE: mystery cartesian join
Thanks for the insight. I will rewrite my query to not use the view and see if the optimizer is more friendly with the execution plan. Thanks also to SteveO for the rewrite idea. ReedK DBA from Montana -Original Message- Sent: Wednesday, January 16, 2002 1:04 PM To: Multiple recipients of list ORACLE-L A MERGE CARTESIAN JOIN is one of the new paths the optimizer can take in Oracle 8(i?) If you really, truely are not missing a join clause, the following may be what is happening Basically, what Oracle does is perform a cartesian product (CT) on 2 tables via a merge-join operation. Generally one of the tables is extremely small (a couple datablocks or less) Then the resulting CT is joined with the rest of the tables are joined in. Yes, Virginia, Oracle sometimes voluntarily performs a CT as part of its optimization logic. I've seen it be the optimal join path for a large query and I've seen it suck the life out of a query. HTH Caver -Original Message- Sent: Wednesday, January 16, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Here is the structure of the underlying base table si_log table. I also do not know what a MERGE CARTESIAN JOIN is. The data returned is correct and the tkprof output looks OK except for the elapsed time the query took and the cartesian join portion. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to calculate user load on the system
Raj - I found your question a bit unclear. Did you mean: - For 10 users, our application requires 50% of a 300-mhz CPU - There are two groups of users on the system. How do I figure out how many resources group A would use. I just thought you might get better assistance by clarifying your question. Thanks Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 2:27 PM To: Multiple recipients of list ORACLE-L Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ... I have been asked a simple question, and I am stumped ... Given a set of users, how to calculate the load they are putting on the system when using our application (CPU, MEMORY etc). We have 8161 running on DGUX (yeah, I know ...) Forms application, Oracle Reports, SQR reports, sql scripts, and two traffic using db_links with couple of other databases. Is anyone doing this? What is the best approach? Thanks in advance for your ideas ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Partitions
List, If we use partitioning for a big tables after finish development, do we have to change the code for accessing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Lookup Table Usage
Hi, Oracle 7.3.4 on Unix. The database has dozens of little lookup tables. I'd like to cache those used the most. Is there a way to see how often a table is queried? Thanks, Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to calculate user load on the system
Dennis, Actually we have N users on the system where N is a variable. Of that I have a certain group of users, I need to monitor and see how much load they put on the system. The idea is out on N total users on the system, X number of users use only one part of application 95% of the time (because it is their job). So, If I get some kind of metric (numbers ... numbers) then we might think of spinning these users and their application to another box in their own instance. They can talk to our application by db links, so that won't be a problem. I am looking for some kind of metric to either prove the need for another box and instance or otherwise. Hopefully this time it is little bit clear ... TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 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: Partitions
The latter. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, January 16, 2002 3:07 PM To: Multiple recipients of list ORACLE-L List, If we use partitioning for a big tables after finish development, do we have to change the code for accessing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
snapshot too old
Hi At time of export i am getting following error EXP-8: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 6 with name R03 too small Please suggest Thanks -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
procedure error
Why in toad when I try to create a stored proc where I drop and create a table I get the following error: PLS-00103: Encountered the symbol "DROP" when expecting one of the following: begin function package pragma procedure subtype type use an identifier a double-quoted delimited-identifier cur Here is my code: CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLE VARCHAR2 (3498), OWNER VARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCE VARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks VARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIED DATE, ALERT VARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_WEEK VARCHAR2 (255), NO_LINKS_LAST_MONTH VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; end; /
Freeable memory
All, In trying to solve some Library Cache latch contention issues, I've been stumped on the following issues: 1) Do freeable chunks get coalesced during an ALTER SYSTEM FLUSH SHARED_POOL. 2) If freeable chunks are freed when a session disconnects, is there a way to determine chunks per session? The idea here is better memory management through better session management. I've aleviated the majority of latch contention by altering the _kgl_latch_count parameter, but haven't addressed what I think is the root cause: an oversized shared pool. I've found scripts that show the amount of memory occupied by the sql area and library cache, and most if the memory is in freeable chunks. Before downsizing the shared pool, I'd like to have a better understanding of how these chunks are managed. Regards, Mike G -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Ghelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: procedure error
You need to use 'Dynamic SQL' in order to drop and create tables. -Original Message-From: Lance Prais [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 4:36 PMTo: Multiple recipients of list ORACLE-LSubject: procedure error Why in toad when I try to create a stored proc where I drop and create a table I get the following error: PLS-00103: Encountered the symbol "DROP" when expecting one of the following: begin function package pragma procedure subtype type use an identifier a double-quoted delimited-identifier cur Here is my code: CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLE VARCHAR2 (3498), OWNER VARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCE VARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks VARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIED DATE, ALERT VARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_WEEK VARCHAR2 (255), NO_LINKS_LAST_MONTH VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; end; /
RE: How to calculate user load on the system
Take a look at V$SYSSTAT. I'm not sure if it's the answer because your question specifies a set of users. V$SYSSTAT includes all users not just a particular set. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 12:27 PM To: Multiple recipients of list ORACLE-L Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ... I have been asked a simple question, and I am stumped ... Given a set of users, how to calculate the load they are putting on the system when using our application (CPU, MEMORY etc). We have 8161 running on DGUX (yeah, I know ...) Forms application, Oracle Reports, SQR reports, sql scripts, and two traffic using db_links with couple of other databases. Is anyone doing this? What is the best approach? Thanks in advance for your ideas ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to calculate user load on the system
Raj - I don't know DGUX, but if the users each have their own system login, the system administrator may be able to help. With forms, that may not help. From my experience, there isn't any ready way within Oracle. Another idea might be to sample the system load and number of users for each group from time to time and try to correlate system load by group. I've never tried that, though. If you have a test system, you could have group 1 run some representative work and measure the system load, then have group 2 run some representative work. That might give you a closer idea. Another thought. DB links can produce inefficient results. Are you sure that moving them to another system won't produce worse results? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 3:31 PM To: Multiple recipients of list ORACLE-L Dennis, Actually we have N users on the system where N is a variable. Of that I have a certain group of users, I need to monitor and see how much load they put on the system. The idea is out on N total users on the system, X number of users use only one part of application 95% of the time (because it is their job). So, If I get some kind of metric (numbers ... numbers) then we might think of spinning these users and their application to another box in their own instance. They can talk to our application by db links, so that won't be a problem. I am looking for some kind of metric to either prove the need for another box and instance or otherwise. Hopefully this time it is little bit clear ... TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
FW: Oracle Un@@#Breakable
It depends on what the meaning of the word unbreakable is ... Check http://www.securityfocus.com/news/309 HTH Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *1 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
RE: Partitions
what do you mean the latter Jack -Original Message- Sent: Wednesday, January 16, 2002 2:00 PM To: Multiple recipients of list ORACLE-L The latter. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, January 16, 2002 3:07 PM To: Multiple recipients of list ORACLE-L List, If we use partitioning for a big tables after finish development, do we have to change the code for accessing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: procedure error
try changing CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP to CREATE OR REPLACE PROCEDURE Primus_Report AS BEGIN Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Lance Prais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 17/01/2002 07:35 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:procedure error Why in toad when I try to create a stored proc where I drop and create a table I get the following error: PLS-00103: Encountered the symbol DROP when expecting one of the following: begin function package pragma procedure subtype type use an identifier a double-quoted delimited-identifier cur Here is my code: CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLE VARCHAR2 (3498), OWNER VARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCE VARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks VARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIED DATE, ALERT VARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_WEEKVARCHAR2 (255), NO_LINKS_LAST_MONTH VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; end; / -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
RE: Lookup Table Usage
Jerry - If they are stored in separate tablespaces, it would be easy. However, we DBAs tend to not keep small code tables in separate tablespaces. You can dump v$sqltext to an O.S. file and search for these table names to get an idea of how often they are used. On Unix, for example, grep can tell you how often a text string occurs. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Hi, Oracle 7.3.4 on Unix. The database has dozens of little lookup tables. I'd like to cache those used the most. Is there a way to see how often a table is queried? Thanks, Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: procedure error
DROP and CREATE are DDL functions ... you have to use DBMS_SQL package or Native Dynamic SQL (execute immediate) statement to achieve this. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Lance Prais [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 4:36 PMTo: Multiple recipients of list ORACLE-LSubject: procedure error Why in toad when I try to create a stored proc where I drop and create a table I get the following error: PLS-00103: Encountered the symbol "DROP" when expecting one of the following: begin function package pragma procedure subtype type use an identifier a double-quoted delimited-identifier cur Here is my code: CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLE VARCHAR2 (3498), OWNER VARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCE VARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks VARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIED DATE, ALERT VARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_WEEK VARCHAR2 (255), NO_LINKS_LAST_MONTH VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; end; / *1 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
Re: snapshot too old
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 23:55 Hi At time of export i am getting following error EXP-8: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 6 with name R03 too small please refer to http://www.ixora.com.au/tips/admin/ora-1555.htm for a good explanation of the problem and the ways to avoid it hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Lookup Tables
I have about 50 lookup tables in my database(we are in the middle of design) just want to check with you guys if define all these lookup as IOT is there any advantage also do I have to put all the Primary Key for these lookup tables in separate Tablespace or NOT? asking for performance issue during the joining lookup tables data tables. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to calculate user load on the system
Thanks Dennis, Ian, Yes, that is another approach ... right now I am looking at what I can do within Oracle. As for DB links, very little stuff goes across for this application, so would not be a bottleneck right now. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *1 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
RE: OT -: SQL BackTrack info
Ok, you guys are really missing the support issue. :) The support is very bad. Yes, you don't need it often. But when you do need it, they don't have it. SQL*Backtrack is normally run as a menu to the back end tools. As I recall, even most of the commands used in cron for scheduled backups are wrappers to the back end tools. There are recovery situations that cannot be peformed from the SQL*Backtrack menu. If you run into one of those, and cannot figure it out, support will be unable to help you. They know how to use the menu mode, and that's about it. Just after leaving a previous job where SQL*Backslack is still in use, a tablespace in the data warehouse was trashed. It took 30+ days to recover it. This is mostly due to inept support from BMC. They like to do a lot of finger pointing, such as 'Your Legato indexes need rebuilt', even though that does not fix the problem. It used to be a great tool, and probably still is. I would not but it based simply on support issues. Jared Smith, Ron L. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: RE: OT -: SQL BackTrack info Sent by: [EMAIL PROTECTED] om 01/16/02 11:13 AM Please respond to ORACLE-L We have been using it for about 5 years on both Unix and NT. We have it connected to Netbackup to handle the tapes. We love it. I agree that the support is not what it used to be but we hardly ever need support. Although, the last time we called we got a support person that knew more about Oracle than we did and knew SQL Backtrack inside and out. It's a great tool! Ron Smith Kerr-McGee Corp -Original Message- Sent: Wednesday, January 16, 2002 10:55 AM To: Multiple recipients of list ORACLE-L I am looking for some guidance from people who use this product. Is it a value add to the organization or not. If possible also let me know how in the hell does it do a online object extraction from the backup. Would appreciate all your comments and recommendations Thx Gautam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: procedure error
Peter, That won't work either. DROP and CREATE commands can only be executed in a procedure via dynamic SQL. Such as the older DBMS_SQL package, or the newer and much easier to use EXECUTE IMMEDIATE. Jared Peter.McLarty@ mincom.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: procedure error om 01/16/02 02:15 PM Please respond to ORACLE-L try changing CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP to CREATE OR REPLACE PROCEDURE Primus_Report AS BEGIN Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Lance Prais [EMAIL PROTECTED] To:Multiple recipients of Sent by: [EMAIL PROTECTED]list ORACLE-L [EMAIL PROTECTED] cc: Fax to: 17/01/2002 07:35 AM Subject:procedure error Please respond to ORACLE-L Why in toad when I try to create a stored proc where I drop and create a table I get the following error: PLS-00103: Encountered the symbol DROP when expecting one of the following: begin function package pragma procedure subtype type use an identifier a double-quoted delimited-identifier cur Here is my code: CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLEVARCHAR2 (3498), OWNERVARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCEVARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks
RE: mystery cartesian join
Try putting in an ORDERED hint and see if that helps. Good call! The following link is a discussion of a similar nature, and the cartesian product was eliminated through the use of the 'ordered' hint. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=126013.999 Jared Thomas Jeff ThomasJe@tce. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: mystery cartesian join [EMAIL PROTECTED] om 01/16/02 11:56 AM Please respond to ORACLE-L Maybe the optimizer thinks there's a many-to-many relationship between si_log and sm_monitor? Try putting in an ORDERED hint and see if that helps. Jeff T. -Original Message- Sent: Wednesday, January 16, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Here is the structure of the underlying base table si_log table. I also do not know what a MERGE CARTESIAN JOIN is. The data returned is correct and the tkprof output looks OK except for the elapsed time the query took and the cartesian join portion. desc si_log Name Null?Type - ERROR_ID NOT NULL NUMBER (PK) ERROR_TYPE_ID NOT NULL NUMBER(8) (FK) to sm_log_type slt EWHEN NOT NULL DATE INTERFACE_ID NOT NULL NUMBER (FK) to si_interfaces si REQUEST_TIME NUMBER LAST_LOG VARCHAR2(1) FAQ_REQUEST_TIME NUMBER LAST_FAQ_LOG VARCHAR2(1) ReedK -Original Message- Sent: Wednesday, January 16, 2002 12:23 PM To: '[EMAIL PROTECTED]' Cc: Kempf, Reed Reed, What is the structure of the SI_LOG table (the one being accessed by the view). Furthermore, what is a MERGE JOIN CARTESIAN - anybody? I am thinking that this is normal, in that the query was broken up into two distinct parts, and the results of those parts should be MERGE JOIN CARTESIAN to get the correct results. Anybody? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Reed, Please reply to the list as well. I don't seen any key information here. And taking a closer I caught the part about this join being done on views. Joining views can be problemetic. You need to ensure that the joins in a view ( if any ) are correct, and that all columns of the primary key are available from the view. These columns then need to be used to fully qualify the join. Jared Kempf, Reed rkempf@rightn To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ow.com cc: Subject: RE: mystery cartesian join 01/16/02 10:36 AM Jared, Thanks for the quick response. Here is some more information. The problem is that the query is taking 1.6 seconds to complete when I think it should take milliseconds to complete. Here are the structures of the 2 tables. I check my indexes and keys and all appear to OK. desc si_monitor (the
Re: Lookup Table Usage
Use database auditing. Lookup 'audit' in the SQL manual. Jared Whittle Jerome Contr NCITo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Jerome.Whittle@sco cc: tt.af.milSubject: Lookup Table Usage Sent by: [EMAIL PROTECTED] 01/16/02 01:20 PM Please respond to ORACLE-L Hi, Oracle 7.3.4 on Unix. The database has dozens of little lookup tables. I'd like to cache those used the most. Is there a way to see how often a table is queried? Thanks, Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to calculate user load on the system
Title: RE: How to calculate user load on the system Database Load ... is the main target at this time ... Thanks Tony, Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 5:53 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: How to calculate user load on the system Raj, sorry for me being confused. Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)? Tony *1 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
RE: How to calculate user load on the system
Title: RE: How to calculate user load on the system Raj, sorry for me being confused. Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)? Tony -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to calculate user load on the system Dennis, Actually we have N users on the system where N is a variable. Of that I have a certain group of users, I need to monitor and see how much load they put on the system. The idea is out on N total users on the system, X number of users use only one part of application 95% of the time (because it is their job). So, If I get some kind of metric (numbers ... numbers) then we might think of spinning these users and their application to another box in their own instance. They can talk to our application by db links, so that won't be a problem. I am looking for some kind of metric to either prove the need for another box and instance or otherwise. Hopefully this time it is little bit clear ... TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
RE: snapshot too old
Seema, The ORA-1555 snapshot too old occurs when export tries to construct a read consistent view of your data from rollback segments, which has been overwritten or reused for new transactions. Other sessions are updating data while the export is running in consistent mode (using consistent = Y) To avoid the ORA-1555 - use consistent=N (default) - use larger rollback segments - increase the number of rollback segments - do exports during quieter periods ie. when not many users are manipulating data Regards $uhen Hi At time of export i am getting following error EXP-8: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 6 with name R03 too small Please suggest Thanks -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
