SGA And PGA Size Allocation?

Nov 21, 2012

I Have a server System Configuration with

RAM size: 16GB Ram & Hard disk Size of 1TB.

I Installed Oracle 11g R2 in the server SystemI want to Allocate Dedicated Memory for oracle..How Should i calculate the Memory size of SGA+PGA for good Performance..

View 2 Replies


ADVERTISEMENT

RAC & Failsafe :: LUNS Allocation To RAC

Dec 18, 2011

We are planning the RAC installations. We are allocate 3TB on HP SAN Storage to be used to setup rac environment with 2 nodes.

Question.

1. Do we accept one 3 TB from SAN engineers or ( Which RAID)
2. Multiple Luns totality to 3 TB.
3. Remember this is 11g R1 OCR and VOTING DISK cannot be managed by ASM.

View 3 Replies View Related

Allocation Unit And Striping Attribute

Dec 21, 2012

difference between stripe attribute and the AU size.The ASM distributes the data in AU in the disk, and what the role of strip size in this case?

View 2 Replies View Related

Performance Tuning :: Memory Allocation In 11 G?

Jun 10, 2013

I am using 11g version, and trying to understand the Memory Allocation.

1) The new feature Memory target parameters are dynamic? is in it? But when I set with the ALTER SYSTEM... it was not changed, then I had to restart the DB.

2) With the new 2 parameters (MEMORY_MAX_TARGET, MEMORY_TARGET), the SGA_MAX_SIZE parameter should be 0, right? But in my case, the SGA_MAX_SIZE value is automatically assigned.

View 5 Replies View Related

PL/SQL :: Calculating Inconsistency In Associate Allocation?

Oct 17, 2012

[URL] ...... Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product

I have the following table

CREATE TABLE  "ALLOCATEASSOCIATES"
   (     "PROJID" VARCHAR2(30) NOT NULL ENABLE,
     "ASSOCIATEID" NUMBER(*,0) NOT NULL ENABLE,
     "ALLOCATIONSTARTDATE" DATE,
     "ALLOCATIONPERCENT" NUMBER(*,0),
    
[code]...

Given that
1. An associate must be allocated to at-least and a maximum of 100% at any given point of time
2. User selects 2 dates between which inconsistency of allocation needs to be displayed

If the end user selects 1st Apr 2012 and July 31st 2012 between which reports needs to be generated, am looking for the following output

ASSOCIATE_ID FROM_DATE TO_DATE ALLOCATION_INCONSISTENCY
2 01-APR-12 15-APR-12 75
2 16-APR-12 15-JUN-12 25
2 16-JUN-12 30-JUN-12 50

The Allocation_Inconsistency denotes that the associate has a deficit of allocation between the 2 dates. The associate with ID 2 has a deficit of 75% of allocation from 1st Apr 2012 till 15th Apr 2012. Similarly 25% deficit between 16th Apr 2012 and 15th June 2012 and so on so forth. However, there is no allocation deficit for the month of July as he is allocated 100% for this month and hence is not appearing in the expected output.

View 5 Replies View Related

Oracle SGA Components Manual Allocation

May 13, 2013

Phyical memory : 420G My database version : 11.2.0.3 running on linux machine.

Memory_target = 200G . I would like to allocate this value to following SGA components. I don't want to automatic memory management enabled. how to split 200G for following components. Is there any percentage for each components ?

db_cache_size
db_recycle_cache_size
db_keep_cache_size
large_pool_size
java_pool_size
shared_pool_size
pga_aggregate_target
streams_pool_size
log_buffer

View 10 Replies View Related

Allocation Of Memory In Standard 10g Or 11g Install

Jan 17, 2013

I wanted to know what is the standard memory allocation for SGA & PGA in a normal installation of Oracle database 10g or 11g? Are the figures of 270M and 90M standard for a 10g or 11g installation using automatic memory management feature?

View 9 Replies View Related

SQL & PL/SQL :: Rows To Columns With Dynamic Allocation Column Names

Nov 16, 2012

I want the output from two tables with rows to columns and generate dynamic basing on the columns.

For example: Table A (a1) , Table B(a1,b1)

Data: A B
------ ----
a1 a1 b1
--- ---- ----
1 1 x
2 1 y
3 2 a
2 b
2 c

o/p: Columnname col_1 col_2 col_3
-----------------------------------------------
a1 b1_1 b1_2 b1_3
----- ---------------------
1 x y
2 a b c

Columns should be generated based on the second table second column.

View 18 Replies View Related

Server Administration :: Change Space Allocation For Character Columns In Database

Oct 24, 2012

I want to change space allocation for character columns in my database, So it will store them as 'CHAR' and not 'BYTE'.my character set is

SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';
VALUE
----------------------------------------------------------------
AL32UTF8
SQL> alter system set NLS_LENGTH_SEMANTICS='CHAR' scope=both;

System altered.I bounced the instance just to make sure

System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Connected to an idle instance.

SQL>
SQL>
SQL> startup
ORACLE instance started.
[code].....

And then I want to see that when I create a table with some varchar2 column,The space for it will be allocated by chars, and not by bytes! However, when I run a check of create table, this is what I get:

SQL> drop table check_char;

Table dropped.

SQL> create table check_char (some_name varchar2(10));

Table created.

SQL> select a.char_used
2 from all_tab_columns a
3 where table_name='CHECK_CHAR'
4 and a.owner='SYS';

C
-
B
SQL>

What is the reason for space allocation to remain in BYTES and not CHAR, or what else I can check?

View 4 Replies View Related

Backup & Recovery :: RMAN-12010 / Automatic Channel Allocation Initialization Failed

Nov 15, 2011

while executing a clone script i got the below error : -

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/15/2011 20:07:34
RMAN-12010: automatic channel allocation initialization failed
RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog

Here i understand that RMAN couldn't find which SPFILE to use to restore the target DB.

How do i check for the DB_UNIQUE_NAME in recovery catalog?

The proposed solution that i found was Use the FOR DB_UNIQUE_NAME option to specify the name of the instance whose parameter file you want to restore. how to implement this in my clone script?

View 7 Replies View Related

Server Utilities :: Estimate Size Of FlatFile Based On Table Size?

May 8, 2013

We are planning to export the table data to a file pipedelimited. How do i estimate the size of the FlatFile based on the table size? or avg rowlength

View 3 Replies View Related

Server Administration :: How To Reduce Size Of TEMP DBF File Size

Apr 13, 2011

I am using oracle 8.1.5 database and my temp01.dbf file size is increased upto 19.8 GB now i want reduce its size .

View 13 Replies View Related

Size Of Database

Aug 24, 2009

i have few questions to ask.

1)How to find out the total size of my database.

2)what is dblink and how to find out the same.

View 5 Replies View Related

Row Size Of Two Different Row In Table?

Sep 13, 2011

One of my user is asking to give me the size(bytes) of row 39 and size(bytes) of row 49 of a table ZETR.

as i am not aware of how to collect size(bytes) for a particular row.

View 3 Replies View Related

RMAN Backup Size?

Apr 18, 2012

I have Oracle database.I take rman backup everyday.Also I set a scheduled backup script.But scheduled backup size is 166MB,but if I take manual rman backup(rman>backup database) this backup size will 2.8GB.This backup isn't incremental backup.

I wrote 3 batch script.Finally this backup script call

backup script:

run
{
backup database plus archivelog delete input format 'C:\db_11g_backup\backup\oracle_scheduled_backup\backups\%d_%t_%s.rman';

[Code]...

View 2 Replies View Related

Increasing Data Size

Oct 3, 2013

How to increase ASM DATA free size? I tried deleting expired backups and old archive logs which are backed up more than one time. Still no success ..

View 1 Replies View Related

SQL & PL/SQL :: Nvarchar2 Maximum Size

May 11, 2011

I'm having some issues with my NVarchar2 columns that I want to solve

My current NLS_CHARACTERSET is 'AL16UTF16', and therefore I can only create NVarchar2 columns with an maximum extension of 2000 bytes. But I do need a column with 4000 bytes length. How can I create an 4000 NVarchar2 column?

(I do not want to use a CLOB column...only a NVarchar2)

View 5 Replies View Related

SQL & PL/SQL :: How To Know The Block Size Of A Table

Jul 12, 2011

AS of we know that we can get the number of blocks occupied by data in a table by querying the user_tables Data Dictionary.

My questions are,

1.)how to know if i want the each block size ?(i.e each block size either it is 4kb or 8kb or 16kb..)?

2.) Is the block size is same for all blocks in a table and in Database or it varies?

3.)The block size is DB dependent or Table dependent or Machine dependent(32-bit, 64-bit and OS)?

View 5 Replies View Related

Forms :: Getting Size Of Image In 6i?

May 17, 2013

I have a form that loads an image. Before storing the image on the database, I want to verify the size of the image. If the image is 0kb, I want to pop up a warning message and fail the load into the database.

I am using Forms 6i Version 6.0.8.23.2

View 5 Replies View Related

SQL & PL/SQL :: How To Find OS Block Size

Oct 25, 2002

I find posted and written in many places that the DB block size should be a multiple of the OS block size. I can't find any information, however, on how to find what the OS block size is for an OS. How to find the OS block size for Windows and UNIX systems (Solaris, Linux, and HP-UX)?

View 4 Replies View Related

What Will Be Initial Extent Size

Oct 29, 2010

I've read the documentation that describes the storage management.I create a tablespace as:

CREATE TABLESPACE MY_TABLESPACE_NAME
DATAFILE 'path/filename1.dbf' SIZE 3000M AUTOEXTEND ON NEXT 200M MAXSIZE 4000M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
BLOCKSIZE 8k
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

As the extent management is local, does it mean that any storage clause of the objects (tables, indexes etc.) placed in it isn't taken into consideration? I mean in a case of placing a table in the mentioned tablespace that has a storege parameters defined as follows:

CREATE TABLE MY_TABLE(
...
)
TABLESPACE MY_TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 100M
NEXT 20M
MINEXTENTS 1
MAXEXTENTS 50
BUFFER_POOL DEFAULT
)

1. what will be the initial extent size? 1M or 100M?
2. what will be the next extent size? 1M or 20M?
3. will the maxextents parameter be taken into consideration?
4. when i'm sure the tablespace is dedicated to keep only one object [MY_TABLE], what should be the relation between the initial datafile size [filename1.dbf] and the initial extent size? Should they be iqual or doesn't matter?
5. as the SEGMENT SPACE MANAGEMENT is AUTO, the PCTFREE param doesn't make sense, right?

View 1 Replies View Related

Performance Tuning :: SGA-MAX-SIZE To More Than 2G?

Aug 10, 2011

I am running Oracle 10.2.0.1.0 on MS Windows 2003 server 64-bit with 16G RAM.

Here is the findings for my Oracle database.

SQL> select * * from v$sgainfo;
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 1293560 No
Redo Buffers 7094272 No
Buffer Cache Size 830472192 Yes

[code]...

I find that the SGA component "Buffer Cache" is decreasing from the start "1.8G" and down to now 0.8G. On the other hand, the component "Shared Pool" is increasing from the start 0.3G to now 1.2G. I noticed that there are 100 operations of shrinking of "Buffer cache" and growth of "Shared Pool" in Oracle every day.Is it a indicator that I should raise up the SGA_MAX_SIZE?

I tried to increase the SGA_MAX_SIZE to 4G. But I cannot start the Oracle afterward.Is it a limitation of MS Windows(OS) or Oracle?I set the SGA_MAX_SIZE to 3G. This time, I can startup Oracle.What is the optimum/maximum I can set to SGA_MAX_SIZE?Is there any adverse effect/concern when setting the SGA_MAX_SIZE more than 2G?

View 6 Replies View Related

SQL & PL/SQL :: By Default Buffer Size?

Apr 30, 2013

What is By Default Buffer size in Oracle ......?

View 4 Replies View Related

Minimum Size For Db_recovery_file_dest_size

Apr 25, 2013

i am trying to enable flashback on in my database and i am getting the below error.

idle> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38708: not enough space for first flashback database log file

my db_recovery_file_dest_size is 1g. If i change it to 20g i am able to "alter database flashback on".

Why does a size of 1g give this proble? Any simple steps or recommendation that i am missing? Or is the size of the DB which impacts the db_recovery_file_dest_size also?

idle> select *from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

View 14 Replies View Related

Undo Tablespace Size

Jun 6, 2012

At a time my 20 GB undo tablespace was full. So i increased the tablespace size upto 48 GB. Then i saw 45 GB was used. Then i changed undo_retention=60. After that am seeing that 48 GB is full.

1) why it's happened?
2) Here what is the effect of undo_retention=60
3) How to resolve?.

View 15 Replies View Related

Database Size Required For SOA?

Jun 19, 2012

I will be installing SOA Suite with OSB in Exalogic for testing. It is not for the production environment and very simple application will be used for testing. Database admin asked me what size database would be required but I did not find clear answer in the documentation anywhere.

View 0 Replies View Related

How To Increase Table Size

Oct 14, 2012

I have table and it's size is full when i'm inserting records , records are not inserting , How can i increase table size

View 8 Replies View Related

Size Of Tables And Corresponding Indexes

Dec 13, 2012

Does size (number of rows) of table and corresponding indexes have influence on INSERT operations (bigger table - slower insert)?

I supposed that if select returns the same rows in small and big table, there will be no difference in performance?

View 4 Replies View Related

Redo Logs Size

May 28, 2013

is it Any way I can put the size of my redo log (During Install Oracle DB 11.1.0.7 )

I mean during installtion .??? becouse its by default 50 MB I need to be 200MB

View 10 Replies View Related

How To Limit The Table Size

Oct 9, 2012

I have a problem with one table.. First of all:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

The problem table resides in a locally managed tablespace. About 10 millions records is added in this table every day. After 36 hours all these records moved to another (partitioned) table, so the size of data in the problem table always about 75 Gb. But the size of table is reached 157 Gb today, and it still growing. The results of dbms_space.space_usage are showed below:

Size of blocks with:

0-25% free space: 4726784
25-50% free space: 17301504
50-75% free space: 24920064
75-100% free space: 102418669568
full blocks: 54761594880Thus, a lot of blocks have 75-100% free space but the table constantly growing: during last 9 days the size increased from 123 to 157 Gb.

how to stop the table growing? It there any way to limit the table size in locally managed tablespace?

View 20 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved