Oracle Any limit for imports BUFFER parameter ??

Does the import parameter BUFFER take the memory from the free systemmemory ?If so, if i do have a free memory of 2GB in my RAM, how much can i allocate for imp's BUFFER parameter? Is there any limit ??TIA,J J ...

Oracle BUFFER parameter in export

we know that BUFFER parameter in exportbuffer_size = rows_in_array * maximum_row_sizebut how/where can I find the rows_in_array and maximum_row_sizePlease help me ...

Oracle recordlength & buffer parameter in IMP

In IMPORT of oracle we specify 2 parameter 1. recordlength2. buffer1. How much maximum size we can spercify for those parameter to fasten the IMPORT process? Also on which thing those values depends?2. Also how much time will it save if we specify those parameters? e.g. If any IMPORT takes 10 Hours ...

Oracle Buffer parameter is better than direct=y

When I tried to export a history table that has 40 million rows & weighs 11GB, direct=y parameter is taking double the time compared to buffer=16000000 parameter.exp uname/pwd@testdb file=/oradata/uat2.dmp buffer=16000000 statistics=none tables=(ALL_TXNS_MMDD) buffer=16000000 22 Minutesdirect=y ...

Oracle Tune redo log buffer parameter

Following is output of v$sysstat 1 select name, value from v$sysstat2* where name in ('redo log space requests' , 'redo entries' )SQL> /NAME VALUE ---------------------------redo entries 115878459.000000000000redo log space requests 4458.000000000000 The ratio of these two value is around 3.84.My ...

Oracle imp parameter .............

just i want some information about import parameter BUFFER what is mean by buffer parameter imp <userid>/<pass> file=abc.dmp buffer=10000 i can't understand buffer parameter ? why use ...

Oracle imp of LONG RAW Table fails

the old problem once again, but i couldn´t find a real solution for that.I´m trying to transfer my tables with the exp/imp utilities. One of this tables has a LONG RAW column (this table has about 5 million rows). The export of the tables finishes successfully. The import hangs at about 3 mill ...

Oracle import Buffer

we are in 9i.what is the default value for BUFFER parameter of imp command ?In utilities documentation for 9i page 2-18 it is said :buffer_size = rows_in_array * maximum_row_sizeNote: See your Oracle operating system-specific documentationto determine the default value for this parameter.But I can n ...

Data Buffer Error

I am trying to replicate an archiving process that is not working correctly in a third party software. What I am trying to do is to copy all records prior to a given date and transfer them into a clone of the original data file. Then delete them from the original file.The partially completed stateme ...

Passing Buffer by reference

Can someone explain to me why the following code gives an error (at least in 8.3).Buffer buf = null   void writeToBuf(Buffer &refBuf, string writeStr) { if (null(refBuf)) { refBuf = create() refBuf = "" }   refBuf += writeStr "\n" }   writeToBuf(buf, "Test ...

Oracle Import Buffer Question

I'm using Oracle 9i. Are there any rules of thumb on what value to set the "buffer" parameter to when running an import? Should this be a percentage of the SGA, total system memory, etc? We run an import that takes appx. 6 hours to run each night, so trying to find a good buffer size to use. ...

passing byte[] array from C# to c++ unsigned char*buf com function parameter

i have a function in c++ com that gets an unsigned char *buffer parameter.when i use the dll in c# this function expects 'ref byte' parameter.how do i pass a byte[] buffer as a parameter to the c++ function and receive it as an unsigned char *buffer in the c++ function ?* already tried IntPTR , the ...

Oracle Buffer Too Small Error

Hello, I have the following stored procedure that supports unicode with utl_file. When I run it it tells me that my buffer parameter is too small. It works fine using the non unicode path. Any help solving this is greatly appreciated. Here is the code. Thank you.The error is at line 77, which I beli ...

Does IBM Judges your Test 701 as its Trial Exam?

Below is a list of questions from trial Test 701 Exam. Among 35 questions, standard answers provided for the four of them make me confused. Does IBM marks your real Test 701 like it provides the standard answers for its trial Exam? Please check as the following:13.Which of the following is TRUE of D ...

fasten the import and export process

Let's have a nice conclusion :-)How to fasten the import and export process (provided that CPU and Memory is enough ):following are my idea , For Export :A. Change archivelog mode to nonarchivelog modeB. Set Buffer parameter to big enough (Buffer=10M) For Import :A. Change archivelog mode to nonarch ...

BUTIL problem

I'm trying to use butil to clone a btrieve 6.15 datafile for Lytec 2001 ... Lytec did not include butil with their app ... I was able to find butil 7 but not one referencing 6.15 ... so I tried 7 ... all I got was 3 errors ... BUTIL-14: the file that caused the error is north34.dat and BUTIL-100: Mi ...

Poor Performance

HiI need to know if this performance is under expected, the situation is this:I have a input flat file with 1536 field (| delimiter a average size aprox 4Kb)a transformation and a Sybase IQ 12 Load, in the transformacion a 40% of the field have a call of a rutine whit this code:IF TRIM(Par_Valor) = ...

Exception when reading a REG_MULTI_SZ value

(1)I am using "RegOpenKeyEx" , open the registryret=RegOpenKeyEx( HKEY_LOCAL_MACHINE,"System\\CurrentControlSet\\Control\\Lsa",0,KEY_QUERY_VALUE,&hKey);(2) then I use "RegQueryValueEx" with data parameter(second last parameter) as zero, to get the size of data in fi ...

Oracle keeping sequences in sync

Sequences are used to generate primary/foreign keys in our production database. We must maintain the sequence values from production while merging all of the structures (i.e., DDL, DCL, DML) from the development database and all of the data from the production database. If there were only 1 or 2 seq ...

how do you send a file using winsock

im tring to create a simple ftp client. i can connect to an ftp server but i dont know how to send a file. ive been tring to use the send function i dont think im using it right. so how exactly do i let the send function know what file i want to send? the file information is suppose to go into the b ...

Oracle ORA-01461 when importing a dump file

I'm running into a ora-01461 error when I try to import a dump file that I have received from a customer.I have read the notes on metalink regarding possible workarounds for this issue and I have tried all those that I can apply.The table in question has two VARCHAR2(4000 BYTE) columns.What I have t ...

string handling over winsock

all, i'm writing a very simple client-server app and i just want to send some text string from the client to the server and vice-versa but both client and server recives some random unexpected ascii characters appended to the string i sent.here's the full client code://#include <stdio.h>#inclu ...

Oracle How to create a Blob with binary numbers

I need to translate, in a pl sql procedure, a cobol procedure that creates a binary file containing a list of 7 digits numbers (3 bytes for every number).Is it possible to write a blob cointaining a list of 3 byte numbers ??Is the DBMS_LOB.WRITE(lob_loc IN OUT BLOB,amount IN BINARY_INTEGER,offset IN ...

Oracle Can we change log_buffer parameter online e.g. when all users are working..

Can we change log_buffer parameter online e.g. when all users are working.. ???What is relation between redo buffer in sga and log_buffer parameter ? SQL> show sgaTotal System Global Area 3758096384 bytesFixed Size 1983152 bytesVariable Size 553655632 bytesDatabase Buffers 3187671040 bytesRedo Bu ...

Oracle why i cant change log_buffer parameter dynamically

why dont i can change the log_buffer parameter dynamically by alter system command.ORA-02095: specified initialization parameter cannot be modified ...

Oracle What is the optimal size for log_buffer parameter

By default, oracle 10gR2 database takes 14,408K as value for log_buffer parameter. I think this is a quite big value. Has it some effect on performance? Should I make it smaller? ...

Oracle Should I resize the value of LOG_BUFFER parameter to a larger one?

Should I resize the value of LOG_BUFFER parameter to a larger one?The transaction of the application is invoking the job once every 5 seconds. The action is inserting more than 14MB of data into 3 tables. The current LOG_BUFFER value is 14MB (Oracle default). ...

I get invalid value INTERPRETED for parameter plsql_compiler_flags error for Imp.

We upgraded the oracle client on our server from 9.2.0.1 to 9.2.0.4.Now when we try to do an imp on the server,we get this errorIMP-00003: ORACLE error 96 encounteredORA-00096: invalid value INTERPRETED for parameter plsql_compiler_flags, must be from among AFFINITY, COMPILATION, SCHEDULING, MESSAGI ...

Buffer as a parameter

Hi, i am trying to use a buffer before sending it to a canvas, and I am having problems finding out how to set the buffer as a parameter in one of my classes. Im doing this:void Muestrate(BufferedGraphics ^buffer);This is the same way i used to set a canvas a parameter, although it wont work with th ...

Oracle ORA-06502 character stung buffer too small: OUT parameter

Me again (doh!),have the following stored proc:PROCEDURE TestErrorOut(o_SqlCode OUT NUMBER, o_SqlErrM OUT VARCHAR2, o_TestErrorOutCur OUT ThisRefCursor)IS v_ReturnString VARCHAR2(255) DEFAULT NULL; BEGINOPEN o_TestErrorOutCur FORSELECT * FROM ALAN_TESTLOTSTATUS; o_SqlCode := 9;--SELECT 'TRUE' INTO o ...

Send a buffer as a parameter

Hi, i am trying to use a buffer before sending it to a canvas, and I am having problems finding out how to set the buffer as a parameter in one of the methods from a classs. Im doing this:void Muestrate(BufferedGraphics ^buffer);This is the same way i used to set a canvas a parameter, although it wo ...

Oracle ASM Buffer Cache - which parameter is responsible for this?

Env: Oracle 10.2.0.4.0 on Windows 2003 R2 32 bitIn one of my testing databases, I saw this. Rest all databases (development and testing) do not have the component "ASM Buffer Cache". SQL> select component, current_size, user_specified_size from v$sga_dynamic_components;   COMPONENT CURRENT_S ...

Oracle how to create a buffer by passing a just polygonpopints as a parameter

this query about oracle spatial...please tell me how to create a buffer around a single polygon data.. by passing single polygon co-ordinates as aparameter..ex: for a point the following works..select * from TEMIS where SDO_INSIDE(TEMIS.GEOMETRY ,SDO_GEOM.SDO_BUFFER(SDO_GEOMETRY(2001,32643 ,SDO_POIN ...

Oracle Does buffer cache size matters during imp process ?

sorry for maybe naive question but I cant imagine why do Oracle need buffer cache (larger = better ) during inserts only (imp process with no index creation) .As far as I know insert is done via pga area (direct insert) .Please clarify for me .DB is 10.2.0.3 if that matters . ...

Buffer cannot be null. Parameter name: buffer

Sub retrievepic()Dim conn As New SqlConnection("data source=.\sqlexpress; integrated security=true; attachdbfilename=|datadirectory|\WAIS.mdf; user instance=true;")Dim cmd As New SqlCommand("select ImageData from ImagesStore where ImageId=@ImageId", conn)cmd.Parameters.AddWithVal ...

Oracle IMP tool: function of parameter ignore?

during using of IMP tool appeares this message ignore?yes or notWhat does it mean? ...

Oracle Buffer pool parameter vs LRU/MRU

I know that in the database buffer cache , the following parameters define the sizes of the caches for buffers :– Default : DB_CACHE_SIZE– Keep : DB_KEEP_CACHE_SIZE– Recycle: DB_RECYCLE_CACHE_SIZEAnd also I know LRU and MRU also works in this regards .Now my ques is , when the "keep pool" and ...

Oracle Buffer Pool Question regarding db_nk_cache_size parameter

If I set db_nk_cache_size parameter to db_16k_cache_size=50M then I create a tablespace using blocksize=16k, will all block objects in the tablespace be automatically pooled in my 16k cache? Matt ...

Oracle Import problem (IMP-00020)

I have the following error message when importing a table :IMP-00020: long column too large for column buffer size (22)The problem (a bug ?) is that the table has no long column at all. Oracle recomend to try to increase the value of the parameter BUFFER but it has no effect.The version of the expor ...

Oracle EXP/IMP over SQLNet

I need to export and then import a 25G database. Due to security restrictions we need run the export and then the import from our desktop over SQLNet. Are there any tips on specific exp/imp parameter settings to optimize this process?My first attempt has taken nearly 48 hours for the import. I set t ...

Oracle IMP utility question: Getting ORA-19815 on import

I am in the process of trying to import a 19g database. I was able to export the database no problem.I matched up the users and tablespace setup on the new database instance on the other server (Windows Server 2003 btw with oracle 10g).Now, upon import, I saw these messages in my alert.log:********* ...

How to do the imp for multiple export files for Oracle 7.3.4

I have use split and generated multiple export files :xaa xab xac xad xae xaf xag xah xai. Could you help me with the following questions:1) colud you tell me how to do imp from multiple xaa,aab,xac.. very much appreciated if exactly syntax provided2) how can I change the following script to split a ...

Oracle IMP-00032: SQL statement exceeded buffer length

10.2.0.4 on RH 5.2 RACAfter deciding to go ahead with legacy export and import as mentioned in my previous thread.http://forums.oracle.com/forums/message.jspa?messageID=4092303#4092303Export went fine with following detailsThe schema size of SCHEMA1 is 28GB and its dump size is around 14.8GB took 50 ...

Oracle Parameter LOG_BUFFER

a litte question about parameter LOG_BUFFER.I thought all the time, that the modified data are immediately written to the redo log files by the LGWR, if a value is changed. But in the documentation for parameter LOG_BUFFER stands:LOG_BUFFER specifies the amount of memory (in bytes) that Oracle uses ...

Oracle log_buffer in spfile different than show parameter

Oracle 11.1.0.7:Today we upgraded from Oracle 10.2.0.4 and saw poor performance. ADDM was complaining about log buffer space. So then I looked at the configs.Earlier configuration had 14M of log_buffer but when I do show parameter I see 3407872. Why is it so different? What am I missing here? Is it ...

Buffer Pool

1. I updated the Buffer Pool in database configure parameterupdate db cfg for sample using buffpage 50002. Then I went to control center to check the Buffer Pool in SAMPLE, but I found the buffer pool size was still 1000, not the new 50003. I created a new buffer pool for SAMPLE in Control CenterCre ...

Ring Buffer

I wanted to develop a Ring buffer in C++ for dynamic memory allocation. I have the following specifications. I just dont get the concept and also the implementation. Would be great if someone can help me with this with a code example.A Read Pointer and a Write Pointer point to a memory location of a ...

Copy std::vector<Vertex> memory to Vertex Buffer

I recently started using std::vector<Vertex> instead of Vertex* and I am not sure how I am supposed to copy the memory to the buffer. Here is the code I had:VOID* pVoid; // the void pointer//Copy the vertices to the bufferv_linelist_buffer->Lock(0, 0, (void**)&pVoid, 0); // lock the ver ...

Parameter for DB2 ODBC

I have a tricky problem I'm fighting with since a long time.We have a very old db2 installation (DB2 5.2) on a old AIX 4.3 system.This system contains the data of an old product management system.Now the time is finally comming that we want to kill this old system.We want to export all the data from ...

Overflow buffer in 9.5

In 8.2, https://www-304.ibm.com/support/docv...id=swg21223978Memory Changes in DB2 UDB Version 8.2If you set the instance_memory database manager configuration parameter to AUTOMATIC, the database manager calculates the amount of instance memory needed for the current configuration. The database man ...