Problem with netasst dbastudio

recently i posted mail here about problem installing oracle 8.1.7 on mandrake 9.0. well i managed to install it - it was a mising file when installing the glibs patch. now i have created a database, created listener, configured naming methods and everything. finally i imported a entire database

error configuration database oracle 9.2.0 on Redhat 7.3

hi all, I need your help, I have a problem while configuration database progress. while progress until 46% I got a error message like this : ORA-12705: invalid or unknown NLS parameter value specified after that I can continue the configuration. anybody could help me? Thank you Regards, pomin

Buffer_Pool KEEP

Title: Buffer_Pool KEEP Hi all, Is there any way / script to find whether the tables kept in KEEP Buffer pool performing fine i.e. do they really need to be in the KEEP buffer pool or should they be removed. Tables that I want to check are in the buffer pool for over 6 months and I want to

Re: can't create database

Am Mit, 2003-03-12 um 21.14 schrieb [EMAIL PROTECTED]: I've had this problem on linux. Best and fastest solution: reboot the server. There is a memory issue preventing you from starting oracle. I just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and now I can start the

Ftp command

Hallo, anyone whom can tell me how to write ftp command to connect to a port at an ip-address? Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Using the /*+ append */ insert hint

Hi all, In a discussion with an Oracle rep last week it was suggested we use the /*+ append */ insert hint to allow some inserts to use direct-path. The suggestion is interesting - the business logic won't have any problems with the limitations this implies. Has anyone had any experience with

RE: Backup Strategy

So what are you doing this afternoon after you have mastered the SQL Server gui this morning? -Original Message- Sent: 15 March 2003 09:44 To: Multiple recipients of list ORACLE-L I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they

Re: Using the /*+ append */ insert hint

I can't say in regards to 7.3.x or 8.0.x, but in an 8.1.7.4, I've traced a complete snapshot refresh and seen that Oracle is using an insert /*+ append */. Good, bad, or otherwise, someone at Oracle believes in it. I will say that it is very likely the hint will just be ignored if not

RE: Backup Strategy

Good one. :-) Jack -Original Message- Sent: maandag 17 maart 2003 11:29 To: Multiple recipients of list ORACLE-L So what are you doing this afternoon after you have mastered the SQL Server gui this morning? -Original Message- Sent: 15 March 2003 09:44 To: Multiple recipients

RE: Comparing strings whilst ignoring some characters

Title: RE: Comparing strings whilst ignoring some characters Mark, you should look at replace() function ... not translate ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any

Re: Comparing strings whilst ignoring some characters

Mark, Use TRANSLATE to convert the characters you don't want to whitespace and then use REPLACE to remove the whitespace. 1 select 'the 9 cats', replace(translate('the 9 cats', '0123456789', ' '), ' ') 2* from dual SQL / 'THE9CATS' REPLACE -- --- the 9 cats thecats -- Daniel

AW: Backup Strategy

John, teh scripts are still there (with a small correction) :) http://www.oracle-dba.com/rman/ Milen -Ursprüngliche Nachricht- Von: Hallas, John, Tech Dev [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. März 2003 11:29 An: Multiple recipients of list ORACLE-L Betreff: RE: Backup

AW: Problem with netasst dbastudio

Hi Milen. I had the same problemson my Linux box. On the console type ps -ef | grep jre . Normally I see a lot of zombie jre's [defunc]. Kill them all wich killall -9 jre (I hope that no other application using JRE is running at that time ;) ). Then try to start netasst or dbastudio again. It

RE: Comparing strings whilst ignoring some characters

How about: REPLACE('the cat', ' ', '') Istifad -Original Message- Sent: 17 March 2003 05:40 To: Multiple recipients of list ORACLE-L Hi Everyone, I have a common problem and whilst I can remember solving it in the past I'm drawing a mental blank this time... I need to look for

RE: Using the /*+ append */ insert hint

From experience, do not use the APPEND hint for singular inserts. You will get tons of wasted space. Only use it for bulk inserts such as INSERT INTO .. SELECT FROM, sqlldr, PL/SQL bulk inserts and the like. Converting from buld inserts without the append hint to bulk inserts with the append

RE: Sizing Indexes - URGENT

Jai I couldn't follow all the details of your calculation. I would have expected to see a calculation for the number of rows per block. Once you know how many rows you can pack into a block, then you can estimate the number of blocks you will need. Maybe you have it in there and I just

RE: Buffer_Pool KEEP

Hussain I wish there was. I hope someone will reply with a good method. First, add up all the blocks for the tables and their indexes you have assigned to the KEEP pool. Some of them may have grown over the past months and you may not have enough space allocated for all of them. Check the BHR

RE: Using the /*+ append */ insert hint

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Connor McDonald Sent: Monday, March 17, 2003 13:34 To: Multiple recipients of list ORACLE-L Subject: Re: Using the /*+ append */ insert hint APPEND came in at 8.0 so it will work there. The hint can

Re: Comparing strings whilst ignoring some characters

translate the chars you want to ignore to (say) '@' then replace the @ with null hth connor --- Mark Richard [EMAIL PROTECTED] wrote: Hi Everyone, I have a common problem and whilst I can remember solving it in the past I'm drawing a mental blank this time... I need to look for

RE: Autoallocate (was Re: LMT monitoring)

Alex If you do not specify the UNDO TABLESPACE when creating the database then AUTOEXTEND is set to ON. I was able to alter that to OFF. The point of the UNDO is that it is automatically managed by Oracle. If you can't cope with that, or you decide that doesn't work well for you, then you

Re: db file scattered read

If 14706+3 is one extent and another extent begins at 14710, it will NOT read 14706+8. A DB_FILE_MULTIBLOCK_READ will not span extents. Hemant At 09:04 AM 14-03-03 -0800, you wrote: Here is a part of trace file . I am finding that oracle is trying to read 8 or 3 or 7 blocks at a time . But block

Re: Using the /*+ append */ insert hint

APPEND came in at 8.0 so it will work there. The hint can be very useful, but it works best with unindexed tables (that are set to NOLOGGING). If tables are indexed, then you still might get some benefit but the gains are not as dramatic. Of course, anything in NOLOGGING mode often requires a

RE: Using the /*+ append */ insert hint

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Toepke, Kevin M Sent: Monday, March 17, 2003 13:24 To: Multiple recipients of list ORACLE-L Subject: RE: Using the /*+ append */ insert hint From experience, do not use the APPEND hint for singular

Re: Sizing Indexes - URGENT

Are you actually going to use the formula ? And I thought that Oracle had dropped the formua from recent versions of its RDBMS documentation [8.1 and upwards]. The only real way you can get an approximation [not the exact projection] of the size is to load some data and then analyze the tables.

ORA-27100: shared memory realm already exists

I am getting the message shown below when running the cron job which restarts the database after shutdown for a cold backup: SVRMGR ORA-27100: shared memory realm already exists IBM AIX RISC System/6000 Error: 17: File exists Operating system is AIX 4.3 Oracle version is 8.1.7. When I list my

RE: ORA-27100: shared memory realm already exists

Title: RE: ORA-27100: shared memory realm already exists Firstly , make sure that when you shutdown, the database is actually shutdown ... my guess is the db isn't shutting down. (Thanks to Kyle) use http://oraperf.sourceforge.net/SGA/sgaid.sh to see which shared memory segment is used by

Re: Sizing Indexes - URGENT

Jai, The formula you are using is reasonably accurate, but not very useful. One of the main problems I have found with this approach is that the number of rows is not usually known. The business side and designers might have an idea of data sizes, but the reality is that most times they are

keep pool

Hi List , I have a 8.1.6 db running on hp-ux 2 cpu . currently it has default db block lru latches ( i guess this should be 1 since oracle sets it to cpu/2 ) . Now I want to configure keep pool . Which will requires at least 1 lru latches . So I need to specify db block lru latches 1 (

RE: Excessive SQL*Net message from client waits

Title: RE: Excessive SQL*Net message from client waits I recently worked on tracing and tuning a process where developer retrieved one row, did a bunch of pl/sql stuff and update ... lather, rinse and repeat. There were a lot of SQL*Net message from/to client. I finally opened up the

Re: Standby errors

Rather than doing an ALTER SYSTEM SWITCH LOGFILE only, issue an ALTER SYSTEM ARCHIVE LOG NEXT I actually do an ARCHIVE LOG NEXT, SWITCH LOGFILE and also have a sleep in the backup-script, which then proceeds to copy all but the *last* archivelog out to tape ! Hematn At 06:19 AM 14-03-03 -0800, you

Re: Oracle Client Software Version

You can still use the 8i client. You _should_ plan and start upgrading your clients to 9i. If you were running TAF in 8iOPS, you should test TAF between the 8iclients and 9iRAC -- although it does work. Hemant At 01:15 PM 10-03-03 -0800, you wrote: We are in the process of moving from 8/8i to 9i

RE: Using the /*+ append */ insert hint

The append hint works since Oracle 8 if my memory is good. I've used the append hint with tables in nologging mode to load a lot of data very fast. It works well. You must do a backup afterwards. If the hint is not supported, it should be ignored, like when you make a typo in the hint's name.

Re: Buffer_Pool KEEP

Title: Buffer_Pool KEEP how about looking at v$bh and match the objectid with dba_tables (objects) . Also look at v$sgastat for keep pool . -ak - Original Message - From: Hussain Ahmed Qadri To: Multiple recipients of list ORACLE-L Sent: Monday, March 17, 2003

Re: AW: Backup Strategy

Not entirely(as the owner of that website). there is a .zip file there, it has a key, it was placed there for someone and right now, i'm not ready to give out the key, so dont bother downloading the .zip file. The work is still in progress and is not quite ready for prime time. joe John,

RE: can't create database

Hi, This site has a good description of how to use the ipcs and ipcrm commands to clean up these left-over memory segments following the shutdown. I've found that using the technique shown on this site minimizes the need to reboot when this problem occurs. Hope this helps, Joe Johnson, OCP

Re: log buffer space

I've just tried a different test, along the following lines, which seems to confirm that LGWR is triggered when the buffer is about 1/3 full. Set log_buffer to an easy number such as 600K. Create table with one column of a nice large size, e.g. varchar2(1000); Take snapshot of redo size, redo

Re: Excessive SQL*Net message from client waits

Bear in mind that when you are talking about a load process, your client is another computer program, and should not (you hope) need any think time. This is the one case where the SQL*Net message from client is a threat rather than (as statspack puts it, I think) an idle event. Regards

Re: Autoallocate (was Re: LMT monitoring)

Yet another reason for avoiding Automatic Undo - one little accident can haunt you for ages. It's also a major pain to find out exactly what does go on in extreme cases because of the massive delay between UNDO becoming redundant and smon dropping it. Regards Jonathan Lewis

RE: db file scattered read

How can you tell that DB_FILE_MULTIBLOCK_READ will not span extents? I was unable to confitrm that on Metalink. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: db file

empty blocks

Does blocks and empty_blocks gives correct info even if I dont run statistics ? thanks, -ak

RE: Sizing Indexes - URGENT

The voice of reason! Thanks Dan. How many times have I been asked for an estimate of an index size (including every tiny overhead and spare byte) without knowing how many rows will be inserted. So they need an exact calculation based on a very rough estimate. As a result my calculation method has

insert stmt disk reads

In sqlarea I am finding some insert statements with high disk reads . why would an insert statement will generate disk reads ? Any idea . -ak

RE: Sizing Indexes - URGENT

Daniel - Excellently put. The other factor you can usually only estimate is the row size, until you get some test data. The old engineer in me says that if you can only guess at the row size and number of rows, then don't pretend the exact formula is going to do much for you. I started with a

RE: log buffer space

Jonathan: I have just sent a mail which has the test statistics. I would appreciate your comments on that.. Alternatively, people who are curious may want to test the log writer writing habits using the event 10046^8. KG Best Regards, K Gopalakrishnan -Original Message- Lewis

Urgent!!! Web Form and Report

Hi All, I would really appreciate if someone can help me. I am calling a report from a form. It works well on Client/Server but on the Web it takes lots of time and hangs. Unfortunately it doesn't display any errors. This is how I built the When-button-pressed code: (This is a sample test

Re: can't create database

On Mon, Mar 17, 2003 at 07:03:43AM -0800, Joe Johnson wrote: Hi, This site has a good description of how to use the ipcs and ipcrm commands to clean up these left-over memory segments following the shutdown. I've found that using the technique shown on this site minimizes the need to reboot

Re: Standby errors

Hi I would recommend that to use the 'alter system archive log current;' since this command don't return until the database has finished to archive the redo logfile. Hemant K Chitale wrote: Rather than doing an ALTER SYSTEM SWITCH LOGFILE only, issue an ALTER SYSTEM ARCHIVE LOG NEXT I actually

Re: Comparing strings whilst ignoring some characters

This is a job for regular expressions, which make this job easy. Run $ORACLE_HOME/rdbms/admin/pubpat.sql and privpat.sql to create the owa_pattern packages. Here are some examples I keep around. Jared declare tstr varchar2(100) := 'this contains tabs multiple spaces

RE: db file scattered read

Mladen, I guess the rdbms kernel will be passing the startblock-stop block addresses and will be passing to the readv (or pread?) system calls. A single multiblock read can not read two different sets (!) of contiguos blocks.. Or I am thinking in the different direction?? Best Regards, K

RE: db file scattered read

Title: RE: db file scattered read it does not. Try it out. The blocks in a multi-block read have to be contiguous and Oracle can not guarantee that if the read would span an extent boundary. I suppose Oracle could check, but that would likely incur more overhead than you'd possibly save

Re: insert stmt disk reads

Partial List Foreign Key Validation Primary Key Validation Reading blocks on the freelist for insert Before Insert/After Insert Triggers -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with

RE: empty blocks

AK Nope. Only analyzing the table sets these columns. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 17, 2003 10:27 AM To: Multiple recipients of list ORACLE-L Does blocks and empty_blocks gives correct info even

ORA-01578 data block corrupted on standby

Hi, all. I'm trying to manually create a standby database on Solaris 2.6 Oracle 8.0.5.2.1 The vendor for our application provided a script that uses the command alter index idx rebuild tablespace tblspace NOLOGGING; for all of their application indexes. When I test the standby (copy datafiles,

RE: Autoallocate (was Re: LMT monitoring)

IME the 'trouble' of managing rollback segments is grossly exaggerated. They rarely cause me any trouble. Only errant programmers cause me problems. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/17/2003 06:28 AM Please respond to ORACLE-L To:

RE: insert stmt disk reads

How about foreign key constraints? - going to the parent table to see if the value exists. Tom Mercadante Oracle Certified Professional -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 17, 2003 12:22 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: insert stmt disk reads

Constraint validations? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/17/2003 11:22 AM In sqlarea I am finding some insert statements with high disk reads . why would an insert statement will generate disk reads ? Any idea . -ak -- Please see the official

RE: db file scattered read

When I come to think of it, my question was not very smart. RDBMS can use multiblock read only to read contiguous blocks. If the blocks are in two different extents, they're not contiguous. Sorry for asking, hopefully the fact that it's Monday can explain my somewhat diminished capabilities.

Re: log buffer space

KG, I got the direct mail much quicker than the list mail - but I'll just echo the doubt I raised in the original. If you use 10046 level 8 to watch for log writer writes, I would expect you to see writes that could be of an almost arbitrary size. Assume a 3MB log buffer - we 'know' that

RE: Autoallocate (was Re: LMT monitoring)

I agree. once they are established, and you determine the size of them, you hardly ever have to touch them again. (rollback segments - not errant programmers!) :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 17, 2003 12:59 PM To: Multiple

Re: insert stmt disk reads

Do you have many indexes on your system ? A table insert often results in index updates; and for large tables with many indexes you usually find that some of the index leaf blocks have to be read from disk. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Now available One-day tutorials:

RE: Autoallocate (was Re: LMT monitoring)

Jared - When it comes to comparing databases, a lot comes down to perception. Oracle would like to market itself to small sites that don't even have a DBA, otherwise if forfeits those accounts to Microsoft. Now, when the MS salesperson says Oracle takes a lot more maintenance, and nobody knows how

Oracle in the news

From the Robert X. Cringely column in InfoWorld: Oracle slammed and exposed Although Microsoft catches a lot of heat for using rival software within its own walls, it was discovered recently Oracle uses Microsoft's SQL Server database, among other things. That's right, and chief Larry Ellison

RE: Autoallocate (was Re: LMT monitoring)

With power comes complexity. Personally, I can't think of exceptions to that rule. Maybe someone else can. Sizing rollback segments is usually a non-issue, but there's always plenty of other stuff going on to keep me busy. :) ( Watch out, here comes another car analogy, though I haven't

Re: Oracle in the news

Oh, this is just too much. Oracle contracting out to a SQL Server shop to save $$. Hell just froze over. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/17/2003 11:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: Autoallocate (was Re: LMT monitoring)

Excellent analogy Jared! Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 17, 2003 1:36 PM To: [EMAIL PROTECTED] Cc: DENNIS WILLIAMS Importance: High With power comes complexity. Personally, I can't think of exceptions

Best way to secure underlying tables in a view

Hi All, I have a view made of 4 tables with different owners. I want to grant users select privs on that view but I do not want them to select on underlying tables. What is best approach? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL

Re: AW: Problem with netasst dbastudio

This didn't help. no processes were running, no processes were killed. maybe it's something else. now i've noticed (i don't know if it was there before) the dbastudio returns this: java.lang.reflect.InvocationTargetExceptionjava.lang.StackOverflowError Cannot launch application

Re: Autoallocate (was Re: LMT monitoring)

No.. that should be: With great power comes great responsibility. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Now available One-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html )

RE: Standby errors

Actually, the command to force the switch is: alter system switch logfile; alter system archive log all; I did not set the script up, I just inherited it. THe thinking is, since a hot backup and log switch is going to be done anyway, why not ftp the archive logs after the switch, but as

optimizer_mode=FIRST_ROWS

All, I've run into the following queries hanging when ran on a database with the optimizer_mode set to FIRST_ROWS. If the optimizer_mode is CHOOSE, no problems. When set to FIRST_ROWS both queries show never-ending wait events for direct path read. I killed the sessions before they finished

Re: Autoallocate (was Re: LMT monitoring)

Which is followed by: Absolute power corrupts absolutely. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: optimizer_mode=FIRST_ROWS

Karen, Are you on version 8? I imagine so given the problem you are seeing. By using FIRST_ROWS you are forcing the optimizer to use CBO even when there are no statistics. Most likely you have no stats on your sys objects (and this is a good thing) and thus the execution plan the CBO is

RE: optimizer_mode=FIRST_ROWS

Karen It sounds as if these queries don't work well with the optimizer goal set to FIRST_ROWS. Essentially you are forcing the optimizer goal. Is there a particular reason you have FIRST_ROWS in your init.ora as your optimizer goal? My guess is that when you allow the optimizer to CHOOSE, it

RE: insert stmt disk reads

insert into ... select * from .. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 17, 2003 12:22 PMTo: Multiple recipients of list ORACLE-LSubject: insert stmt disk reads In sqlarea I am finding some insert statements with high disk reads . why

Re: Autoallocate (was Re: LMT monitoring)

yes, well, that too. :) Jonathan Lewis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/17/2003 12:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Autoallocate (was Re: LMT monitoring)

Re: insert stmt disk reads

I dont have any foreign key const on the table . Yes but there are two indexes on this table . Would that cause this high disk reads ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:14 AM Constraint validations?

RE: keep pool

AK Since I don't see where anyone posted a reply to your question, here are the lines I added to my init.ora to implement the keep and recycle pools. This is a 4-CPU system. It took me awhile to understand that you need to increase the latches, but not by much. db_block_buffers = 20

Re: Best way to secure underlying tables in a view

One way: Create user view_owner... as all 4 table owners: grant select on table_name to view_owner with grant option; as view_owner create view whatever as 4 table join here grant select on whatever to whomever HTH Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/17/2003 12:03

migration

Hi Friends, Iam migrating data from 7.3.2 to 8.1.7.4 with exp/imp, when Iam importing into 8.1.7.4 Iam getting silly errors like IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX TTIITM009001$IDX1 ON TTIITM009001 I checked in metalink and other sites for help,

OCFS/Linux/RHAS problem

Playing with RAC on Linux. load_ocfs fails with many unresolved symbols Linux RHAS (developer version) uname -a returns 2.4.9-e.5 #1 Metalink states that it's certified RAC O/S When I run load_ocfs it fails and complains about many unresolved symbols. It could be due to the downloaded

Re: migration

How about checking out the part of the import log where it tells you which character sets are being used? Jared Peter R [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/17/2003 03:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: Autoallocate (was Re: LMT monitoring)

Stepping back into reality briefly: With great power comes great licensing fees, great amounts of advertising literature, great demands from superiors to reduce costs by migrating to SQL Server, great loads of paperwork-stuff unrelated to the job at hand... Gee, great! :-) --- [EMAIL

RE: Using the /*+ append */ insert hint

Greetings from sunny Perth, Western Australia This is why the www.oracledba.co.uk hasn't been updated for a while, the UK ISP won't let me dialup from abroad, so I'm trying to find a workaround :-( Left UK in Jan, spent a month in Canada, got back to Perth in Feb, got married in 110 degree heat,

RE: optimizer_mode=FIRST_ROWS

Thanks Bruce Dennis for your replies. The init.ora is set to FIRST_ROWS because statistics are always current for the application tables and testing showed that the plans generated in that optimizer mode offered better overall response times than with CHOOSE. I think the idea about hinting the

DB crashed with ORA-4030 on DBW0 process

Our database crashed over the weekend with the following lines from the trace. ORA-00449: background process 'DBW0' unexpectedly terminated with error 4030 ORA-04030: out of process memory when trying to allocate bytes (,) ORA-04030: out of process memory when trying to allocate 8512 bytes (pga

how to get metalink user name ??

Hello, my client has oracle v8.1.6 and v9.0.1. we need to access metalink now. at http://metalink.oracle.com, Customer Support Identifier (CSI) is required to register. where how can we get a CSI ? can any customer having a licensed copy of oracle access metalink ? if so , what is the

Re: how to get metalink user name ??

(my understanding is that) if you are paying any kind of support contract with oracle (bronze etc) you have access to metalink. Contact support on the phone and they should be able to tell you the various details hth connor --- oracle ora [EMAIL PROTECTED] wrote: Hello, my client has

From Microsoft Access to Oracle

Hello list, I want to create a new form in Access where user input will be thereand the data entered i have to store it in Oracle database. Can anyone of you guide me in doing this..How ??? Thanks and Regards, Santosh

Inband and Outband Net8 question

Hi all, I have question about Inband break, please help me understand this Oracle said: There are 2 types of breaks: - Inband breaks: are transmitted as part of regular data traffic using the normal protocol read and write functions. These breaks are symply queued. - Outband breaks: are

Re: how to get metalink user name ??

hello scott, You will get the metalink support in the following ways: 1. your organization should be partner to Oracle 2. your organization should take Annual support contract from Oracle If you have the any of the above , then go to metalink.oracle.com and find out the CSI number to

ORacle Applications mailing list

Hi all, Can any one tell about the Oracle Applications(E-Business suite) mailing list. Thanks rukmini