Oracle Block Size :: Larger vs. Small data block – OTN Forum

Oracle Block Size :: Larger vs. Small data block – OTN Forum
Very informative thread which gives you an idea about different opinions from senior oracle guru’s about choosing an appropriate block size.
Well, for setting up Database block size, I always go with Vendor Application team with the proposals, as they are the best to decide which one to use with their application.
My recent setups, I stick to 8K in size, and it’s the default from Oracle as well. I need to concentrate more on this, from now.

emctl resetTZ agentTZ

rac1-> emctl resetTZ agentTZ
set to US/EasternOracle Enterprise Manager 10g Database Control Release 10.2.0.4.0Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.Updating /u01/app/oracle/product/10.2.0/db_1/rac1_devdb1/sysman/config/emd.properties...Time zone set to US/Eastern.
To complete this process, you must either:
connect to the database served by this DBConsole as user 'sysman', and execute:
SQL> exec mgmt_target.set_agent_tzrgn('rac1.mycorpdomain.com:3938','US/Eastern')
-- or --
connect to the database served by this DBConsole as user 'sys', and execute:
SQL> alter session set current_schema = SYSMAN;SQL> exec mgmt_target.set_agent_tzrgn('rac1.mycorpdomain.com:3938','US/Eastern')

***************************************************************
rac1-> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 9 17:27:37 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter session set current_schema = SYSMAN;
Session altered.
SQL> exec mgmt_target.set_agent_tzrgn('rac1.mycorpdomain.com:3938','US/Eastern')
PL/SQL procedure successfully completed.
SQL>
rac1-> emctl start dbconsole devdb1TZ set to US/EasternOracle Enterprise Manager 10g Database Control Release 10.2.0.3.0Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.http://rac1.mycorpdomain.com:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control ............................. started
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/rac1_devdb1/sysman/log

Oracle Forum - that i always like to see updates

1. URGENT URGENT PLZ READ B4 OTHERS VERY URGENT NO TIME WASTERS
Replies: 508 - Pages: 34 [ 1 2 3 4 5 Next ] - Last Post: Feb 18, 2008 1:23 PM by: RACER

2. Larger vs. Small data block
Replies: 451 - Pages: 31 [ 1 2 3 4 5 Next ] - Last Post: Jul 13, 2008 10:44 PM by: Niall Litchfield

Critical Patch Update - July 2008

CPU Patch for July released