Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
recycle and keep buffer in other tablespace block sizes

recycle and keep buffer in other tablespace block sizes

2004-07-21       - By J.Velikanovs@(protected)

Reply:     1     2     3     4     5     6     7     8     9     10     >>  

I have found the error.
SYS:jozh > select count(*) from v$bh where OBJD=10047;

COUNT(*)
-- ---- --
69

SYS:jozh >


Jurijs
9268222
============================================
http://otn.oracle.com/ocm/jvelikanovs.html






J.Velikanovs@(protected)
Sent by: oracle-l-bounce@(protected)
21.07.2004 19:13
Please respond to oracle-l

To: oracle-l@(protected)
cc:
Subject: Re: recycle and keep buffer in other tablespace
block sizes


SYS:jozh > @(protected)
Parameters vai dala no ta :db_block_size
NAME VALUE
-- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
db_block_size 8192

SYS:jozh > @(protected)
Parameters vai dala no ta :db_2k_cache_size

NAME VALUE
-- ---- ---- ---- ---- ---- ---- ---- -- -- ---- ---- ---- ---
db_2k_cache_size 0


SYS:jozh > CREATE TABLESPACE TEST2K
SYS:jozh > DATAFILE 'D:\ORACLE\ORADATA\JOZH\TEST2K.ora ' SIZE 5M
SYS:jozh > BLOCKSIZE 2K;
CREATE TABLESPACE TEST2K
*
ERROR at line 1:
ORA-29339 (See ORA-29339.ora-code.com): tablespace block size 2048 does not match configured block
sizes


have added db_2k_cache_size=10M to init.ora


SYS:jozh > @(protected)
Parameters vai dala no ta :db_2k_cache_size

NAME VALUE
-- ---- ---- ---- ---- ---- ---- ---- -- -- ---- --
db_2k_cache_size 12582912

SYS:jozh > CREATE TABLESPACE TEST2K
SYS:jozh > DATAFILE 'D:\ORACLE\ORADATA\JOZH\TEST2K.ora ' SIZE 5M
SYS:jozh > BLOCKSIZE 2K;

Tablespace created.

SYS:jozh > create table test2ktab (n number) tablespace test2k;

Table created.

SYS:jozh > begin
SYS:jozh > for f in 1..10000 loop
SYS:jozh > insert into test2ktab values (f);
SYS:jozh > end loop; commit;
SYS:jozh > end;
SYS:jozh > /

PL/SQL procedure successfully completed.

SYS:jozh >


have removed db_2k_cache_size from init.ora

SYS:jozh > select DATA_OBJECT_ID from dba_objects where object_name =
'TEST2KTAB ';

DATA_OBJECT_ID
-- ---- ------
10047

SYS:jozh > select count(*) from test2ktab;

COUNT(*)
-- ---- --
10000

SYS:jozh > select count(*) from v$bh where OBJD=100047;

COUNT(*)
-- ---- --
0

Any ideas?
Where I go wrong?


Jurijs
9268222
============================================
http://otn.oracle.com/ocm/jvelikanovs.html






J.Velikanovs@(protected)
Sent by: oracle-l-bounce@(protected)
21.07.2004 18:39
Please respond to oracle-l

To: oracle-l@(protected)
cc:
Subject: Re: recycle and keep buffer in other tablespace
block sizes


Good point :)
I am going to check.

Jurijs
9268222
============================================
http://otn.oracle.com/ocm/jvelikanovs.html






"Juan Carlos Reyes Pacheco " <jreyes@(protected) >
Sent by: oracle-l-bounce@(protected)
21.07.2004 18:23
Please respond to oracle-l

To: <oracle-l@(protected) >
cc:
Subject: Re: recycle and keep buffer in other tablespace
block sizes


Hi Jurijs, thanks,
my default block size is 8K
If have a table in a 2k tablespace with the flag to be cached in the keep
pool.
How it is cached?
It takes 8K???? in the keep cache
Could you please give more information :)

-- ----Original Message-- ----

From: oracle-l@(protected)
Date: 07/21/04 11:00:14
To: oracle-l@(protected)
Subject: Re: recycle and keep buffer in other tablespace block sizes

Those are hidden! Try:
__DB_2K_KEEP_CACHE_SIZE
__DB_2K_RECYCLE_CACHE_SIZE

Just joken ;)
There no K/R/D for diferent block sizes. Just one cache per block size ;)

Jurijs
9268222
============================================
http://otn.oracle.com/ocm/jvelikanovs.html






"Juan Carlos Reyes Pacheco " <jreyes@(protected) >
Sent by: oracle-l-bounce@(protected)
21.07.2004 16:57
Please respond to oracle-l

To: <oracle-l@(protected) >
cc:
Subject: recycle and keep buffer in other tablespace block
sizes


Hi list I 'm investigating this,
if your default blocksize is 8k, and you create a tables using 2k block
you have the
ALTER SYSTEM SET DB_2K_CACHE_SIZE = 100M;
to set the size for this block cache

But how do you set the keep and recycle size for this block size
There are none of this parameter.
ALTER SYSTEM SET DB_2K_KEEP_CACHE_SIZE = 1M;
ALTER SYSTEM SET DB_2K_RECYCLE_CACHE_SIZE = 1M;

Thank you

Juan Carlos Reyes Pacheco
OCP
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --



-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --



-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --



-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --



-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --