partitioning option with parallel server

hi all, I have read this document on partitioning which says that partitioning cannot be implemented in clusters. I.2 Version 8: --- Partitioning is offered as

Ignore this post : partitioning option with parallel server

hi all, please ignore this post. My problem is solved. thanks Sathish -Original Message- Sent: Tuesday, February 12, 2002 1:33 PM To: '[EMAIL PROTECTED]' Importance: High hi all, I have read this document on partitioning which says that partitioning cannot be implemented in

Recall: partitioning option with parallel server

Sathish Tatikonda would like to recall the message, partitioning option with parallel server. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sathish Tatikonda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: ORA-29857

- Original Message - This command doesn't apply on DOMAIN INDEX. domain indexes are handled in a different manner - don't forget that a domain index consists of several tables and indexes u need to create a data storage for the index, and set proper attributes to it browse manuals

Re: partitioning option with parallel server

Sathish Tatikonda wrote: hi all, I have read this document on partitioning which says that partitioning cannot be implemented in clusters. [snip] This functionality is available for both indexes and tables, but cannot be implemented in clusters.

V_$SESSION question

Hi, my problem is as follows: I want do determine the machine name (and other info) from pl/sql,of the client from which i have logged in e.g. suppose i have logged from machine 'power_machine' as user 'puser' my pl/sql has info. that the current user

Re: high tkprof parse counts == real # of hard parses?

James, Admittedly, I am no JDCB expert, but I wouldn't expect to see the behaviour you see, in particular that each insert seems to produce a soft parse. Do you have a non-cached sequence? If you do, that's your reason - recursive SYS SQL is (almost) never cached, so your update to seq$ will

Re: What are the major difference between Oracle RAC and Parallel server?

Think of RAC as OPS v2, or probably more precisely, Cache Fusion v2. Older versions of OPS used to require carefully partitioning of a anticipated application across the nodes. In 8.1, this was lessened to some extent and even more so in 9. Thus in 9i, the claim is that you can run a standard

Rollback Segment Problem

All, The following is the pitiable scenario I am in and would really appreciate a bit of help : We were running a long running delete job which gave the following error : Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production

Re: V_$SESSION question

Ghadge,Sameer wrote: Hi, my problem is as follows: I want do determine the machine name (and other info) from pl/sql,of the client from which i have logged in e.g. suppose i have logged from machine 'power_machine' as user 'puser' my pl/sql has info. that the current user 'puser'

Re: White space compression in Oracle

Title: White space compression in Oracle Marc, There are subtle differences between CHAR and VARCHAR2 when it comes to comparison semantics as CHAR comparisons are blank padded, which VARCHAR2 are not. Thanks, Bjrn. Marc Perkowitz wrote: Beth, Actually, varchar2 is char with

RE: V_$SESSION question

A quick and easy way, though there may be better or even easier ways that the list will no doubt tell us about.. select distinct sid from v$mystat; HTH Mark -Original Message- Ghadge,Sameer Sent: 12 February 2002 09:53 To: Multiple recipients of list ORACLE-L Hi, my problem is as

Re: What are the major difference between Oracle RAC and Parallel server?

It is not completely true what others have said, that RAC is the same as OPS. RAC obviously builds on OPS, but there are quite a lot of enhancements to improve the cache coherency issues, and it is also expected that 9iR2 brings even more. Thanks, Bjørn. dist cash wrote: ORACLE 9i claim it

RE: Sql question

You have to realize that you need two occurences of table c, as you want to match values of different records. You can do this in various different ways. One of them is something like: select a.something,c.searchvalue from a , b , c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and

Re: V_$SESSION question

Hi If you whant the information in the session you can use the function SYS_CONTEXT ('USERENV', attribute) attribute := 'host' or 'ip_address' or some other of the 25 options look in the Oracle8i SQL Reference chapter 4 Ghadge,Sameer wrote: Hi, my problem is as follows:I want do

oracle forms -

Hi I need the foll. file urgently ,used in oracle forms D2KWUTIL.PLL pls mail me personally , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Table Locks

Hi all We are running on 8.0.5.2.1 database. Once we had a database creash and was restored. After that the users have been experiencing locks. What happens is when one user locks some rows, other users are also getting stuck. But they are not locking the same rows. We are looking at the code to

RE: V_$SESSION question

Depending on how you want to see SID. If you want to see the SID name then do SELECT instance FROM v$thread; Also a little cleaner method then below IMHO SELECT sid FROM v$mystat WHERE rownum=1; Rick

RE: Sql question

Zsolt, Try: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and and not exists(select 1 from c c1 where c1.b1 = c.b1

Re: high tkprof parse counts == real # of hard parses?

[Bjørn Engsig] Admittedly, I am no JDCB expert, but I wouldn't expect to see the behaviour you see, in particular that each insert seems to produce a soft parse. Do you have a non-cached sequence? If you do, that's your reason - recursive SYS SQL is (almost)

Fragmentation of data dictionary

Title: Fragmentation of data dictionary Hi! I was wondering whether the Oracle data dictionary gets fragmented and whether the dba needs to do something about it. E.g. if granting tons of rights through grants directly to a user (and later revoke them), does the data dictionary get

Re: wrong result from select

It works fine in 8.1.6.0.0, Sun Solaris 2.6: SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:01:22 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production SQL set echo on SQL

parallel execution

Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat

RE: Oracle Lite 8i as snapshot site

Dick - I believe that some replication is available in Standard Edition. My company is looking to put Oracle in remote sites, with some modest replication, and wanted to avoid the licensing penalty of EE. As I read the Oracle document

RE: parallel execution

DBA_TABLES.DEGREE? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Gramolini Sent: Tuesday, February 12, 2002 6:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which

RE: Fragmentation of data dictionary

Title: Fragmentation of data dictionary Helmut, X$ tables are NEVER stored in the disk. THey are just memory structures in the SGA and the contents are zeroed (are reset) when you shutdown the database. THey will not cause data dictionary fragmentation. Best Regards,K

RE: Table Locks

What is the PCTFREE setting for the tables? Hope it is not 0. Here is the quote form one of my article which explains this behavior --BEGIN QUOTE Each datablock will have an Interested Transaction List (ITL) that holds the transaction id of that block during the

default DB

Hi, I am new to Oracle DB. There is a m/c where already Oracle 8.1.7. I want to know the following info. a. How to login into Oracle thru sqlplus -how to know login and passwd? b. How to see what are the Databases already created. c. how to create a new Database d. Is

RE: parallel execution

dba_tables -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth --

RE: parallel execution

Check the dba_tables there is a column name degree if it is not default ie 1 then parallel executions on that table is turned on -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which

RE: Sql question

Thomas, NOT EXISTS and equals must be at least one Right ? That's not what Zsolt wants ... :-) -Oorspronkelijk bericht- Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 12 februari 2002 14:28 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Sql

RE: Table Locks

Sounds like you have run into the much annoying problem of missing foreign key indexes. I would check that out first I think. -Original Message- Mascranghe Sent: Tuesday, February 12, 2002 4:33 AM To: Multiple recipients of list ORACLE-L Hi all We are running on 8.0.5.2.1 database.

RE: parallel execution

Ruth, You can look in USER_TABLES/DBA_TABLES at the DEGREE column. This will give you the number of parallel processes to use for the table. It is also in the USER_INDEXES/DBA_INDEXES view. You can set this values by issuing an: Alter table {tablename} parallel 2; Hope this helps Tom

RE: wrong result from select

Hmmm...I've been executing this a script in TOAD, which seems to account for some differences. The really wierd thing in TOAD is that the SELECT acually WORKS CORRECTLY if I insert a COMMENT immediately after the ANALYZE statement! Of course, comments don't make a lick of difference in this for

Re: parallel execution

Hi, you should not see for the degree if it is in the HINT, you should see if is turned on for the instance ... there are some parameters like parallel_max_server,... Ciao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002

Upgrading from 8.0.5 to 8.1.7 - Please help

Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the

RE: parallel execution

How about DBA_TABLES where degree1? Best, Sergey -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution

Re: script to kill session

Here is a shell script I use in UNIX, restrict_and_kill. I included the sql command to build the sql with the kill commands, killuser_build. It excludes users with restricted session access and puts the database into restricted session mode. You can modify these scripts to suit your needs.

Moving Oracle Binaries from HP to SUN

Has anyone done the following: Create a db using Oracle Loaded on an HP Server - The datafiles, controlfiles, etc will be on EMC Later, Install the oracle binaries on a SUN Server, basically unplug the HP from the SYMM, and plug in the SUN and bring up the database. I was asked this

DSD

Title: Message Any good tool to reverse engineer a DSD either from a DDL or from a user that has full access to the schema, but not requiring to be logged in as the schema owner? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240

RE: White space compression in Oracle

Title: White space compression in Oracle Note VARCHAR and CHAR uses different comparison semantics. With CHAR the shorter one is padded with spaces up to the same length as the longer one and a byte by byte comparison is used. VARCHAR uses a none padded method. -Original

Re: White space compression in Oracle

Title: White space compression in Oracle Bjørn, Aren't those semantics all host language based? I haven't been working on Pro-X languages for a while, but I seem to recall that there were language options (switches, directives)on how the comparisons were done. Also, you could easily move the

Re: parallel execution

Ruth, If you are requesting info on parallel DML operations then you can look at the V$PQ_STSSTAT, V_PQSESSTAT, V$PQ_TQSTAT views that show the parallel executions are running in the database. Also the V$SESSION has a column called PDML_ENABLED to display if parallel DML is enabled for the

logon failure auditing

All, I would like to audit all the database users upon logon failure. I know that someone must have been implemented similar kind of auditing. Could you please share your information with me. At the same time I did create new profile and assign it to all the database users. This new profile

parallel execution

Thanks to everyone who helped me with this problem! Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: White space compression in Oracle

Well, if you are not able to change CHAR to VARCHAR2, then you can't do compression in Oracle. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: Oracle Lite 8i as snapshot site

My probem was, that Oracle Support still does not seem to be able to answer with a simple 'yes' or 'no', wether I can user Oracle Lite as a readonly snapshot site. The Oracle Lite documenation is only talking about EE as a must, but our cutomer has only SE licence. I would need only one way

Re: parallel execution

It does, Thanks! RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002 9:44 AM Ruth, You can look in USER_TABLES/DBA_TABLES at the DEGREE column. This will give you the number of parallel processes to use for the table.

Oracle Migration Utility

Can anyone advise me on using the migration utility? We are finally moving from 7.3.4 to 8.1.7. Has the utility worked well for you? Known bugs? Any info greatly appreciated. THe history, if you want to know. We have been stuck at 7.3.4 due to a lack of migration path for OPS on SGI equipment.

RE: Table Locks

If they are using DBMS_ALERT then since it uses dbms_lock, it could be possible that the locking problem is one of the application's making (not the database). I can't remember the specifics, but things like a long gap between signalling the alert and the subsequent commit rings a bell as a

Re: Moving Oracle Binaries from HP to SUN

Robert Pegram wrote: Has anyone done the following: Create a db using Oracle Loaded on an HP Server - The datafiles, controlfiles, etc will be on EMC Later, Install the oracle binaries on a SUN Server, basically unplug the HP from the SYMM, and plug in the SUN and bring up the

RE: Sql question

Remco, This is exactly what he wants - all records where the first one exists and the second one does not exist. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Thomas, NOT EXISTS and

Which certification for Oracle DBA ???

Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris administration or JAVA certification ? I have a 6+ years of Oracle, 4 years of Solaris experience and 6 months JAVA experience. What do the Oracle gurus at this list think ?

Re: DSD

Title: Message Any good tool to reverse engineer a DSD either from a DDL or from a user that has full access to the schema, but not requiring to be logged in as the schema owner? ERwin supports reverse engineering from DDL - http://www.cai.com/products/alm/erwin.htm

RE: parallel execution

Further to Waleed' response: Field name called 'degree'. if 1 then it invokes parallel process according to degree level defined if 2 will start 2 processes subject to maximum of parallel_max_servers defined in your init*.ora or in 8i depending on your other parallel settings..

Re: Upgrading from 8.0.5 to 8.1.7 - Please help

Obviously this WAS not a production database. If you were not aware that a new OS was being installed and that Oracle was being wiped out then step 1 Get a competent SA I do not know UNIX but I would think you have to re-install 8.0.5, do backup restore 8.0.5 datafiles,redo,controlfiles,etc.

RE: DSD

Not sure what you mean by DSD, but we provide a tool called the DataBee DBATool, that reads an export file, and generates all of the DLL for the objects within a schema, or the database on the whole (from a FULL export, generated with the ROWS=N option). You can then either document the DDL

RE: URGENT Help on tracking unauthorized login to Oracle Database

Title: RE: URGENT Help on tracking unauthorized login to Oracle Database To track users who tried and logged into the database : SQL audit session; I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

Fred, You can migrate your 805 to 817 directly. You really need to read the migration documentation - it is pretty straight forward, and will answer all your questions. You will be doing a migration on a test database first, right? - not the first time on a production database - right? You

Re: Which certification for Oracle DBA ???

It depends on which way you want your career path to go... administrator or developer? it really depends on what you want to do. Why not go for Oracle Master?? (big grin) -Joe --- Jason Rowski [EMAIL PROTECTED] wrote: Hi, I have just given my oracle 9i upgrade exam. I was wondering

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

Fred, Don't waste your time installing 8.0.5 unless you plan to go back to it some time in the future (Back to the Future?). Install 8.1.7 and patch to 8.1.7.2 (or higher). Copy your datafiles to the new system. Make sure that you copy them to the exact directory structure that existed

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

This is not a production database. It's just a reporting machine. Which document are you referring to? The migration guide for 8.0.5 or for 8.1.7? The 8.1.7 guide does not mention a migration process for a non-installed 8.0.5 software. Does this matter? Much thanks, -FS From: Mercadante,

RE: Which certification for Oracle DBA ???

Solaris. Languages come and go (flavor of the month like java), but servers will be there always. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: Jason Rowski [SMTP:[EMAIL

Re: Moving Oracle Binaries from HP to SUN

[Robert Pegram] Create a db using Oracle Loaded on an HP Server - The datafiles, controlfiles, etc will be on EMC Later, Install the oracle binaries on a SUN Server, basically unplug the HP from the SYMM, and plug in the SUN and bring up the database. What storage format? If using

RE: Which certification for Oracle DBA ???

May be to find a certified job that keeps you busy! -Original Message- Sent: Tuesday, February 12, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris

RE: URGENT Help on tracking unauthorized login to Oracle Database

Title: RE: URGENT Help on tracking unauthorized login to Oracle Database The SQL reference has some information... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074 HTH Tim -Original Message-From: Behar, Rivaldi [mailto:[EMAIL

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

So, why could you not do just what he is asking ?If you have all the files of the database (Cold Backup of everything), why could you not install the 8.1.7 code and then run the migration tool ? The installation of the Oracle Binaries does not touch the database at all. -Original

Re: Which certification for Oracle DBA ???

A quick question..What was the level of this upgarde test,in your opinion, and what level of preparation is required..I am planning to appear it in coming March/April 2002...for 9i OCP upgrade test. Based on your experience for Solaris, it is better to have certification of Solaris, IMH

Re: Upgrading from 8.0.5 to 8.1.7 - Please help

This is definitely not a production db. I was just told by Oracle that it is possible to migrate the 8.0.5 datafiles using 8.1.7 software. They say I do not need to install 8.0.5 on the new server. Finding instructions in a document covering this is not easy! -fs From: [EMAIL PROTECTED]

Re: Rollback Segment Problem

Is your tablespace fragmented as it is not finding contingous extent .. TRy to coalesce your subject tablespace and try... you can use following script to check whether coalesing is required or not.. If percent is 100 then coalesce it.. select substr(tablespace_name,1,10)TS_NAME,total_extents

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

Fred, Read the Migration guide for 817. If you want to take the chance of losing time, put your 805 db back on the machine and try a migration. If you have never performed a migration, I think you will either be incredibly lucky if it works ok, or you will be back-tracking (delete all the

RE: Sql question

Why not try MINUS Select x, y, z From tab Where condition=1 Minus Select x, y, z From tab Where condition=2; HTH, Bambi. -Original Message- Sent: Tuesday, February 12, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Remco, This is exactly what he wants - all records where the

Re: Upgrading from 8.0.5 to 8.1.7 - Please help

To REMOVE yourself from th is 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

Re: Moving Oracle Binaries from HP to SUN

Stephane, In the not so distant future, I think we might see a push to accomplish just what Robert is asking. With the growth of the need for speed and the decline in the economy, a lot of companies can not afford to purchase new machines and discard to old. If I was a company that had a few

Re: Oracle Migration Utility

Fred, I don't know how you can use the migration utility from one physical machine to another. I used the export,import method when going across platforms. Build the new database on the new server to your desired specs and then export the tables you want to move to the new database and import

Re: Moving Oracle Binaries from HP to SUN

Thanks for the responses. I thought exp/imp was the only way to go, but I feel much more confident now. That was also Oracle's response. BTW, I think they have changed their thinking on this issue anyway. Thanks, Robert Pegram - EDS Oracle DBA --- bill thater [EMAIL PROTECTED] wrote:

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

Fred, I'll respond this way. The odma makes its selection on the database to upgrade based on those available from oratab (with the old database $ORACLE_HOME). Also the odma default execution will want to start that database before it upgrades the datafiles. On top of that, I would want my test

optimizer_mode/optimizer_rule

What is the difference between optimizet_mode and optimizer_goal parameters? Are they being used interchangeably? I've rtmf-ed. It is not clear. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

Oracle Developer/DBA with Java Informatica Needed- White

White Plains, New York company is looking for a solid Oracle Developer/DBA who also has Java, Informatica, and ETL programming skills for it's I.T. staff. *Candidates who are not in the White Plains area must be willing to relocate themselves and have the ability to relocate quickly. No

Dedicated server memory usage 8.1.7 vs 7.3.4

We just recently migrated some production databases from 7.3.4 to 8.1.7.3 on AIX. We have noticed that the amount of memory per dedicated server process spiked from about 400k to 2m. Anybody have any ideas about why this occurs? Is this normal? Thanks -- Please see the official ORACLE-L

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

This is all covered in great detail in the 8.1.7 Migration Guide - Chapter 7 titled Upgrading from a Previous Version 8 Release to the New Oracle8i Release There is no need to install 8.0.5 on the target server. Just load the cold backup files, adjust init.ora and follow the steps from the

Re: URGENT Help on tracking unauthorized login to Oracle Database

Title: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi all, I have never done this particular activity but by following the clues given in this thread AND BY reading the documentation I was able to make this work. The steps I followed were. 1. change the initializaion

How to find out Oracle patch applied

Hi DBAs, I want to find out what Oracle patch installed. Someone just installed Oracle817 binary on our server but no 817 instance setup yet, so can't query v$version. Thanks James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Moving Oracle Binaries from HP to SUN

There have been a few posts in the past claiming that copying datafiles from HP to SUN and vice versa was okay. However, I never received anyone's reply when I asked them how many Production Databases they have transferred using this method. Experimenting is fine but one can't run business on

RE: Moving Oracle Binaries from HP to SUN

Or do like ORACLE says they are doing, and Cluster Intel Based Machines with LINUX. Then you can get rid of all those competing Hardware Vendors. -Original Message- Sent: Tuesday, February 12, 2002 13:39 To: Multiple recipients of list ORACLE-L Stephane, In the not so distant

Re: Moving Oracle Binaries from HP to SUN

haven't done it, and I don't think it can be done... the datafiles, while Oracle datafiles are still Unix OS files and you can't just copy a file created on HP to Sun and expect it to work. You'd have to export and import/rebuild the database --- Robert Pegram [EMAIL PROTECTED] wrote: Has

Re: wrong result from select

I tried the steps on 8.1.7.0.0 on Solaris 2.7, and it worked fine. Trying it on 8.1.7.2.0 provided the erroneous(??) results, but only after the table was analyzed. Has this been filed as a bug? Brian Scott Canaan wrote: It works fine in 8.1.6.0.0, Sun Solaris 2.6: SQL*Plus: Release

RE: How to find out Oracle patch applied

Load the Oracle Installer and click on Installed Products - will tell you every patch installed by the Installer, which are all the major ones . . . minor patches and one-off's that are installed via OS file copy will NOT show up. -bill -Original Message- Sent: Tue, February 12, 2002

Re: logon failure auditing

Hi Bob, 1. change the initializaion parameter audit_trail to be: audit_trail=db shutdown and restart database 2. connect to the database as a user that has the privilege AUDIT SYSTEM audit session whenever not successful at this point you can see these unsuccessful logins by monitoring the

RE: How to find out Oracle patch applied

Is there any Oracle file I can use Unix command strings to search for version/patch info? I don't have x-window session. James -Original Message- From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 3:02 PM To: Multiple recipients of list ORACLE-L

RE: parallel execution

Title: RE: parallel execution While on the topic, DEGREE VARCHAR2(10) The number of threads per instance for scanning the table What is a difference between '1' and 'DEFAULT'? SQL select degree, count(*) from user_tables group by degree; DEGREE COUNT(*) -- -- 1 598

RE: How to find out Oracle patch applied

In the $ORACLE_BASE/oraInventory/logs directory look for ' Patch' string in the installActions*.log files. You may find it there... Then you can view that install log file for more info. If those log files aren't there, then you are left with the Oracle Installer to tell you.. - Kirti

RE: Re[4]: Date format element rule change

Title: RE: Re[4]: Date format element rule change Jonathan, You are right. From FM: For input format models, format items cannot appear twice, and format items that represent similar information cannot be combined. For example, you cannot use 'S' and 'BC' in the same format string.

Re[4]: Date format element rule change

Alexander, Your example below is very helpful, and explains why I recalled that duplicating date elements was possible. I probably used TO_CHAR to test this in the past, while the other day I was using ALTER SESSION. My theory on why you can't duplicate elements when setting NLS_DATE_FORMAT is

RE: Rollback Segment Problem

Rafiq, While your script provides a lot of good information, it sure is slow on my system. It took 1:44 minutes while my script below took 420 mseconds. I was really surprised as my script has a self-join. Then I checked out dba_free_space_coalesced. It sure is complicated as it calls on two

RUN STORE PROCEDURE INSIDE A FUNCTION

Hi List, How can I run a store procedure inside a function? I have a store procedure to do some DML, and we can not run it from our application for some sort of limitation, only we can call function from application side, Is there any way to run this store procedure inside a function or some

RE: Rollback Segment Problem

Jerry, Thanks for sharing script. We might have better systems as timing was never be a issue. I just tested my script on 2 systems and it ran between 34.5 mseconds to 4.65 seconds...and on the basis of it is results we coalesce all such tablespaces. I prefer to keep pctincrease of tablespaces

Preperation for OCP 9i

Hi I used the book 'Oracle 9i : New features' by Robert Freeman. I had made extensive notes on Oracle 9i new features from Oracle 9i manuals also. If you are interested , I can post it online. The exam is at the same level as Oracle 8i upgrade exam. Thanks Jason --- Mohammad Rafiq [EMAIL

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

Good point. -Original Message- Sent: Tuesday, February 12, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Fred, I'll respond this way. The odma makes its selection on the database to upgrade based on those available from oratab (with the old database $ORACLE_HOME). Also the

Oracle Masters certification !!!

I don't want to go for Oracle Masters because of the compulsory training from Oracle. Why should I spend big money on training when I have real world experience. Thanks Jason --- Joe Raube [EMAIL PROTECTED] wrote: It depends on which way you want your career path to go... administrator

  1   2   >