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 ...
why dont i can change the log_buffer parameter dynamically by alter system command.ORA-02095: specified initialization parameter cannot be modified ...
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 ...
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 ...
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? ...
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). ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
our oracle is EE 8.1.7, OS is windows2000.I try to increase the size of the log_buffer parameter in the file init.orafrom 64000 to 512000, i found the problem (Illegal log buffer)from svrmgr i found the redo log size 73000the Question is: How can i increase the redo log size and log_buffer if possib ...
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 ...
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. ...
I have read that oracle writes the dirty buffers to disk on few conditions in which one of them is , 'When a shadow process must scan more than one-quarter of the db_block_buffer parameter' What does this mean exactly and what is the term shadow process refer ? Please explain... ...
here is a imp par file for a 8i database:FROMUSER=(B)TOUSER=(B)FILE=${TMP_FS}/XXX_impBUFFER=400000000LOG=XXXXXXXTABLES=(A.table1, A.table2.......)IGNORE=NCOMMIT=YI import selected tables from schema A, and all objects from B.is that OK, just double make sure. pls help have a check ...
in 9i we can modify shared pool size and db cache sizebut can we alter log_buffer parameter... anyway??? ...
I'm a bit confused on something I came across running 10.2.0.3 Standard edition using an spfile..If I query v$parameter for the value of the log_buffer parameter, it returns some strange value instead of the true value. For instance the query : select * from v$parameter where name = 'log_buffer'; re ...
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 ...
Could anyone please confirm that the following query that returns log buffer size is correct?select a.ksppinm name, b.ksppstvl value, a.ksppdesc description from x$ksppi a, x$ksppcv b where a.indx = b.indx and a.ksppinm = '_ksmg_granule_size'; The reason I ask is that log_buffer parameter in v$param ...
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 ...
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 ...
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 ...
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 ...
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) = ...
(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 ...
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 ...
For an Oracle 9i database:FOLLOWING ARE THE INITIALIZATION PARAMETERS SET AND THEIR VALUES:JAVA_POOL_SIZE=0SGA_MAX_SIZE=54Mdb_block_size = 2048DB_CACHE_SIZE=12Mshared_pool_size = 16Mlog_buffer = 8192WHEN I RUN THE FOLLOWING COMMANDSQL> show sgaTotal System Global Area 59080376 bytesFixed Size 282 ...
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 ...
We are experiences issues with 'log file sync' waits. Sometimes it's get so bad the db slows to a crawl and starts blocking processes and we need to bounce the application to get the database back to normal. I'm running Oracle 10g, i have three redo log files on the same disk as the datafiles. The f ...
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 ...
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 ...
I was asked to tune the import process which was started by a new dba.He started import last night and it is still running. the dump files are huge( around 12 gb+) and the import is dead slow.I have checked the logs, and v$ tables and found that the poor permance is because of the log_buffer paramet ...
SELECT name||' = '||value FROM v$sysstatWHERE name = 'redo log space requests';I am noticing 40+ space requests for some of my Oracle 9.2.0.5 databases. On another 7.3.4 DB I see this over 140 but this DB shutdown only on weekends so this cumulative value increases I presume.I have 20MB of 5 groups ...
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 ...
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 ...
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 ...
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 ...
to get the value of log_buffer. when I user command show parameter log in sqlplus ,the value it show is 32768 ,but if I select the value from v$sgastat,it is 66560.how can this happen ...
HiThe size of LOG_BUFFER initialization parameter is muliple of operating system block size or multiple of the database block size. ...
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 ...
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 ...
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 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 ...
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 ...
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 . ...
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 ...
I get this MySQL Alert when I startup my DB - why? I seach through the MySQL variables but does not find any 'cache' / 'rate' / 'hit' variable that I think it corresponds to ANYONE know how to tackle this alert /problme? I think the MySQL tool should give better advice how to fix this so the alert g ...