Re: pct increase

Hi! You have to change the 'next extent' valuefor the table to make it fit into available free space. Oracle will calculate the next extent size based on both new value of 'pctincrease= 0' and current value of 'next extent' which is still 520 MB and there's no chunk that big. I believe

RE: SUPPRESS SQL STATEMENTS

set head off message off feedback off echo off _ David Kurtz Go-Faster Consultancy Ltd. tel: +44 (0)7771 760660 fax: +44 (0)7092 348865 mailto:[EMAIL PROTECTED] web: www.go-faster.co.uk PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba -Original Message-

My Proc may not be using bind vars.

Hello, I thought of giving this a go first before bouncing it to the gurus in the list. Basically, I wanted this procedure to be called from another 3rd party application with the parameter of a 'customer_key'. I was under the impression that I could force the select statement to use a 'bind'

RE: LMT and Fragmentation

Niall, I played around with autoallocate on 8.1.7 a while back and came to the same conclusions as yourself. Chris -Original Message- Sent: 13 October 2003 21:54 To: Multiple recipients of list ORACLE-L A week or so ago Jesse (I think) suggested a test to see whether auto-allocate

RE: encrypt traffic across internet?

Hmm I wonder what the Metalink Technicians would have to say on this. Patrice. -Original Message- Sent: Sunday, October 12, 2003 6:29 PM To: Multiple recipients of list ORACLE-L I have a question about using the port forwarding feature of ssh. The initial connection to the listener

RE: 10g new featuers seminars from oracle

The people who plan architecture and make purchasing decisions should go to the Oracle Technology Days etc. As a DBA I like those sessions too, but when I go I agree with Oracle then realize I can't tell my organization what to do. Recommending products is not enough, one has to plan, purchase,

RE: Concurrent Manager

Title: RE: Concurrent Manager But every time I open an ITar, Support freaks because we have ours configured with the managers on the middle tier (Windows might be the issue, but that isn't usually when they balk) and not on the database tier... and if you do a 2 tier install (at least as of

hrs to run catpatch.sql

Hi all .. Can anybody tell me how many hours it will take to run the patch catpatch.sql . I am planning to upgrade the server. My server info is given below BANNER Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit

DbVerify Output

Title: RE: Concurrent Manager All, We are in the middle of testing Tivoli Storage Manager and Rman here on a Sun Box. After a restore, we ran DbVerify and got the following results: DBVERIFY - Verification starting : FILE = /dba/u5000/osor/index_a/osos_indx301.dbf Block Checking: DBA =

Re: encrypt traffic across internet?

dont use windoze? :) joe Boivin, Patrice J wrote: Hmm I wonder what the Metalink Technicians would have to say on this. Patrice. -Original Message- Sent: Sunday, October 12, 2003 6:29 PM To: Multiple recipients of list ORACLE-L I have a question about using the port forwarding

software which monitoring diferences between instances ?

Hi Have Oracle some software for monitoring difrences between schemes in several servers ? Thanks Ota -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Reboot Solaris and Oracle 9i install

Basically the main difference is: init can change you among levels... while shutdown no! and... shutdown cannot take you into levels 2 and 3. check the -i option for the shutdown command. HTH JL --- Brian Dunbar [EMAIL PROTECTED] wrote: For some reason, my habit is to use the init commands

++ Help needed +++

Hi, I am an Oracle DBA, not failiar with Oracle APPS. But management put me into Oracle APPS DBA team. So I have to start from 0.Kindly Request you send me some guide lines to startup Oracle APPS DBA. Any documents, presentations, White papers and URLs are highly appreciated. Thanks in advance,

Re: software which monitoring diferences between instances ?

Ota: Take a look at Embarcadero's Change Manager. You can download a copy to use as a trial for a couple of weeks. www.embarcadero.com I was very impressed with the product. Good luck! Barb --- Otakar Mouèka [EMAIL PROTECTED] wrote: Hi Have Oracle some software for monitoring difrences

re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

John, I rebuild the FND_CONCURRENT_REQUESTS indexes every four months [and the table itself, occassionally]. This Saturday I will also be rebuilding some ALR indexes. Which WorkFlow Indexes do you rebuild ? Hemant At 11:44 AM 13-10-03 -0800, you wrote: Jared, Any indexes supporting a In-Today;

Re: software which monitoring diferences between instances ?

Princeton Softech has a very good solution. The URL is www.princetonsoftech.com. On 10/14/2003 10:19:25 AM, Otakar Mouka wrote: Hi Have Oracle some software for monitoring difrences between schemes in several servers ? Thanks Ota -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: hrs to run catpatch.sql

I have been testing the Oracle 9.2.0.4 patch on HP/UX dev box and have a open TAR. I ran into a bunch of problems relinking after applying the 9.2.0.4 patch on HP/UX. Oracle had me run RDA and gave me a list of missing OS patches, I still had the same errors they had me run RDA again and gave

RE: SUPPRESS SQL STATEMENTS

Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -Original Message- Sent: Monday, October 13, 2003 12:49 PM To: Multiple recipients of list ORACLE-L A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot

RE: Data Modelling Tools for a DBAs Job

Hi I have used S-Designer and ERWin in the past - both in development DBA roles. Don't recall exact features of S-Designer (was about 5 to 6 years ago) but remember it to be very useful. Have more recent experiences of ERWin and found it very useful. It is expensive but well worth the

RE: Data Modelling Tools for a DBAs Job

There is a nice tool for Linux...DBDesigner4... -Original Message- Sent: Tuesday, October 14, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Hi I have used S-Designer and ERWin in the past - both in development DBA roles. Don't recall exact features of S-Designer (was about 5

RE: SUPPRESS SQL STATEMENTS

The script is run from a cron job with a ksh script calling the sql from outside sqlplus. I've solved the problem by using sed to cull the offensive lines, but I should be able to use sqlplus formatting statements to give the correct results. I did include message off (from a previous email),

RE: Data Modelling Tools for a DBAs Job

I use Oracle Designer. Works great - I'm very happy with it. It does have w to much functionality for Database Design. But I ignore those parts of the product and use just what I need. Works for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent:

Re: software which monitoring diferences between instances ?

The only other tool that works on Oracle would be part of the CAST workbench suite of tools. there's a product for MS Sql server called AdeptSQL, and a toolset of perl scripts for Sybase called dbschema.pl that do similar jobs. Todd Ota: Take a look at Embarcadero's Change Manager. You can

continuously copy archive redo logfiles to tape

Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] Fat City Network Services--

Re: OEM Problem?

Ryan, If your goal is to drop the user, then the following should work: SQL drop user OEM_RYAN-2LE36OFJCE_OEMREP cascade; Alternatively, if you still want to connect to this user, the following should work too: SQL connect OEM_RYAN-2LE36OFJCE_OEMREP Then when prompted for the password, type

Re: continuously copy archive redo logfiles to tape

I'd try using backup software. There are only two utilities that work: 1) EMC/Legato Systems Legato Networker 2) Veritas Net*Backup 3) Spectralogic Alexndria backup. 4) Syncsort Backup 5) IBM Tivoli backup. 6) HP OmniBackup 7) CA Arcserve 8) BMC SQL*BackTrack On 10/14/2003 12:59:25 PM, Roger Xu

RE: SUPPRESS SQL STATEMENTS

Not recommended to include the password on the command-line -- you're then exposing it to other users (via ps, for example), particularly on UNIX systems. Adam Khedr, Waleed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 10:09 AM Please respond to [EMAIL PROTECTED] To Multiple

RE: Data Modelling Tools for a DBAs Job

Oracle designer is a full fledged CASE tool, so it does quite a bit more than design a database. I've checked out other DB design tools, even bougth Embarcadero. None of them are nearly as capable as Oracle Designer for designing Oracle databases. None of them seem to be as good at separating

!! Please Read!! Oracle-L subscriptions, spam and viruses

As all of you are quite aware, the past couple months have seen a huge influx of spam and viruses on the internet. This has had a huge impact on mail servers worldwide. I recently read of one university that was spending quite a bit of money to install new mail servers, all due to the increased

RE: Data Modelling Tools for a DBAs Job

I'm using it as well -- a bit quirky, and I don't particularly like its PL/SQL development interface, but for schema design-to-generation, it's decent. I still prefer ERwin. Adam Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 10:44 AM Please respond to [EMAIL

Re: DbVerify Output

When you say 'restore', what do you mean exactly? Are these the files straight off the tape? If these files are from a hot backup, and the database has not gone through media recovery, it isn't surprising that dbv has found errors. If after the recovery and you do this while the database is

RE: Data Modelling Tools for a DBAs Job

I couldn't agree more! It also has the Oracle Software Configuration Management (SCM) to rigorously version all those Repository objects. Maggie Respectfully, Maggie Tompkins - CAD SQA Corporate Applications Division Technology Services Organization - Kansas City Defense Finance and

Re: how to drop an oem repository?

ignore i figured it out. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 2:14 PM Subject: how to drop an oem repository? I dropped an oem repository using the oem configuration assistant. Im now

how to drop an oem repository?

I dropped an oem repository using the oem configuration assistant. Im now trying to use the GUI to create a new one. It says that I cannot create a new one, becuase another OEM 'service' exists. I dropped the user and the tablespace. How do i get rid of the service so i can make a new one?

Re: how to drop an oem repository?

Ryan... try this: 1.- Backup your $ORACLE_HOME/sysman/config directory files 2.- Delete them (or rename them, as you wish). 3.- Try again your DBCA. HTH JL --- Ryan [EMAIL PROTECTED] wrote: I dropped an oem repository using the oem configuration assistant. Im now trying to use the GUI to

RE: SUPPRESS SQL STATEMENTS

Use the silent option -S in sqlplus -Original Message- Sent: Tuesday, October 14, 2003 12:29 PM To: Multiple recipients of list ORACLE-L The script is run from a cron job with a ksh script calling the sql from outside sqlplus. I've solved the problem by using sed to cull the offensive

Re: Perl DBI and Activestate 5.8.0

Yes, there are compatibility issues. ActiveState does not keep their DBD::oracle up to date. The second hand reason I've been given is the believe there are some licensing issues, but as the Oracle libs are not linked in, I don't know what they mean. try ftp://ftp.esoftmatic.com/outgoing/DBI

Re: My Proc may not be using bind vars.

For a better understanding of cursors and bind variables, check out this paper by Bjorn Engsig: http://www.miracleas.dk/tools/Miracle_2_cursor.pdf Jared Ross Collado [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 02:49 AM Please respond to ORACLE-L To:Multiple

RE: Reboot Solaris and Oracle 9i install

init 3 is useful for updating a system, as it eliminates a lot of extraneous stuff that you may not want running. Or even init 1 (single user mode ) if necessary. Jared Brian Dunbar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/13/2003 05:54 PM Please respond to ORACLE-L To:

question on multibyte character storage

Hi, We are planning on storing 2-byte characterset in our UTF8 database. If I store a single two-byte character in a varchar2 column, do I need to declare the column as VARCHAR2(1) or VARCHAR2(2)? As far as I know since it's a UTF8 database, a VARCHAR2(1) should be sufficient, right? Thanks.

RE: SUPPRESS SQL STATEMENTS

-Original Message- Johan Muller A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as

Re: question on multibyte character storage

would anyone care to take a whack at this? thanks. From: Paul Drake 14-Oct-03 19:52 Subject: sqlnet.expire_time support in 9.2 on NT (w2k) RDBMS Version:: 9.2.0.4Operating System and Version:: MS W2K Advanced Server SP4Error Number (if applicable):: Server Net Version:: 9.2.0.4Client Operating

Oracle Designer data model?

Is there any documentation (particularly a schema diagram) of the Oracle Designer data model, with comments? I'm doing a lot of work with the repository, particularly in cross-workspace reconciliation, and knowing the internals would help immensely. Thanks, Adam -- Please see the official

RE: continuously copy archive redo logfiles to tape

Well, Backtrack is working well, in fact we will buy it for our new DB2 environment since we are quite happy with it in the Oracle environment. What is the other one working ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel.

Database just stops

Title: Message I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash

Re: question on multibyte character storage

sorry about posting that not under its own thread. Pd[EMAIL PROTECTED] wrote: would anyone care to take a whack at this? thanks. Do you Yahoo!? The New Yahoo! Shopping - with improved product search

RE: Database just stops

Title: Message This probably sounds like Oracle Support but I'dstart by patchingto 8.1.7.4.1. Regards, Gudmundur -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron L.Sent: 14. október 2003 20:14To: Multiple recipients of list

Re: Database just stops

Title: Message define 'just stops'. A specific user cant do anything. CAn any users log in? are you in archive log mode? If so this is possibly a sign that your archiver cant keep up with the amount of redo to archive. - Original Message - From: Smith, Ron L. To:

Re: Database just stops

So, what happens when you try to connect internal? I haven't worked with 8.1.7 database for eternity (since 8/4/03) but I believe that syntax is something like: svrmgrl CR connect internal CR Furthermore, did you notice existence of beautiful files named something like *SMON*.TRC or *PMON*.TRC

Re: Database just stops

Title: Message When you mean by "stops" - do u mean you are not able to connect any more from sql*net ? or even the current sessions hang ? Are you running this in archivelog mode ? Is it possible that the database is in archivelog more and the archiver is not running ? Babu -

RE: Database just stops

Title: Message Hi Ron... You need to poke it and find out what's it's doing... I'd start with the following Metalink notes... Note 175006.1 Note 215858.1 Note 61552.1 They cover diagnosing database hanging issues... SYSTEMSTATE AND HANGANALYZEDUMPS OH MY! Good luck... Tim

Re: Database just stops

Ron, Its highly likely that if you were to open a TAR on this, that the analyst would recite the following: "please apply the currently supported patchset" - which would be 8.1.7.4.1. Unfortunately, there are numerous security fixes that have been made available that are not in a full patchset

RE: question on multibyte character storage

Elain, If you are using Oracle9i then I would recommend that you change to character semantics vs. byte semantics so that Oracle will take care of this and make your life, and especially the life of your developers, much easier. It will also ensure that many logical bugs that are only

space taken up by number data types

I could have swarn I read that Precision with number data types effects how much space is reserved in the database. So number(38) and number(3) reserve different amounts of space. Here is a link from Tom Kyte in 1998 saying the opposite. Is what he says still true?

Re: Database just stops

Title: Message i ran into this problem with DOM objects.we were loading them in memory and taking up so much memory the only way to even access the database was through connect internal. couldnt connect any other way. had to shutdown abort. I cant find any notes on it though. -

RE: Database just stops

Title: Message If the archive destination is full then for sure the database will stop but it will not crash. It's probably a bug, you should probably go to 8.1.7.4. Talking about database stop, I just did an audit at a client site, during my spare time. The top3 SQL: The first onewas

RE: Database just stops

Title: Message Thanks for the replies. The server admin fessed up and said he had bounced the server a few times to do some software installs. Thanks! Ron -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 4:10 PMTo:

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

Hemant, This applies on 11i only. I would rebuild all indexes supporting the WF_ITEM_ACTIVITY_STATUSES and WF_ATTRIBUTE_VALUES tables. I have been working on some AOL table(space) problems in the background and noticed that in 11i by default, we are not be purging _all_ the WF data that we should

Re: space taken up by number data types

Tom's right. It's been this way since at least 7.0.12 Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 02:09 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:space taken up by number data types

RE: space taken up by number data types

Yes, T.Kyte is still right J Space is not reserved for NUMBER type, it is variable length column. Amount of space occupied depends on particular number, which is stored in the column. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED]

Re: space taken up by number data types

Ryan wrote: I could have swarn I read that Precision with number data types effects how much space is reserved in the database. So number(38) and number(3) reserve different amounts of space. Here is a link from Tom Kyte in 1998 saying the opposite. Is what he says still true?

RE: space taken up by number data types

Title: RE: space taken up by number data types Jared, Ryan, Number data types does not reserved any space. Amount of used spaced depend on the stored value. For the same value size is the same, however, look at Steve Adams' site or run this test and see: drop table t; create table t (n1

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

John What about gl_interface table indexes? I think indexes on all *interface( tables must be rebuild on a regular interval...I was building indexes on gl_interfaces and fnd_request* tables on monthly basis. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

** increasing size for a partitioned table key field

Hi, I am getting this error ORA-14060 while modifying a column in partitioned table. The table is partitioned on that column.Is there a workaround or any other alternative. Thanks Do you Yahoo!? The New Yahoo! Shopping - with improved product search

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

Rafiq, John What about gl_interface table indexes? I think indexes on all *interface( tables must be rebuild on a regular interval...I was building indexes on gl_interfaces and fnd_request* tables on monthly basis. Indeed the interface tables suffer as well. I would suggest a TRUNCate of

Re: Resource for index

Dear Stephane, At first, my apologize by the word Resource, it was the first word that I found out and wrote it. The case is that this command +0 , you can put it in the sentence line of where and the sintaxe is correct. Oracle executes the statment and don't gives error message. My doubt is :

Re: Resource for index

The +0 is simple arithmetic... Since the value is a number they add zero to the value to trick the optimisor into thinking the index is useless without actually changing the value. I guess alternatives would be *1 (multiply by one), /1 (divide by one) and -0 (subtract zero). For text based

question about ordering in a table

If I have a table that does not have any indexes or keys. If I insert 10 records. Will there ever be a case that when I do a select on that table without an 'order by' clause that the result set will return in a different order? Assume the table is read only. No DML is performed on it. So

Re: question about ordering in a table

Obviously the official line is ordering of results is unpredictable without an order by clause. An easy way to upset the order of results I believe is to add a parallel setting to the table - then you can have multiple reads occuring at once and I'm not sure how results are merged. At the end

RE: re Rebuilding Indexes in Oracle Apps

John At my location I was not finding those tables without rows so simple truncate was not the easy option. However, from time to time I was truncating them by removing rows into temp type of tables and placing those rows back. However, index rebuilding was more practical under that situation.

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

Hi, I do rebuild index for table AP_INVOICES_ALL but it seems that no effect on extents. select owner, segment_name, tablespace_name, count(*), sum(bytes) 2 from sys.dba_extents 3 where segment_name like 'AP_INVOICES_N3' and tablespace_name='APX' 4 group by owner, segment_name,