Resize Exadata /u01 Filesystem

For those of you whom have never performed this type of activity, please reference the Oracle Support document 1357457.1. 1) Grab the current sizing of /u01 filesystem [root@DM01DB01 ~]# df -h |grep -i u01 Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGExaDb-LVDbOra1 99G 16G 78G 17% /u01 2) Stop your oracle databases, oracle crs, monitoring […]

Hugepages on Exadata? Yes and No… part3

Finally after over 6 weeks got a response back regarding hugepages on Exadata. Yes, hugepages is supported on Exadata platforms, with no changes from a standard linux platform. ie.. while it’s supported, there is nothing specific to exadata in it’s setup. There it has been stated by MOS that it will be supported. I really […]

Oracle Database – Enterprise or Standard Edition

Here are some questions to ask yourself, your team or your company: How large is your company?What is the budget?How many databases on the server?How many cpus/cores on the server?DEV, TEST, QA or PROD?Does your company allow 3rd party applications to monitor your database? These are questions that need to be asked.  Oracle Enterprise Edition […]

NLS_DATE_FORMAT – RRRR or YYYY

This question has been asked recently and here is my input. RRRR and YYYY essentially perform the same function.  Both accept a 4 digit year. The exception is with RRRR.  It will also accept a 2 digit year.  This allows you to store 20th century dates in the 21st century by using the last 2 […]

Tracing concurrent request and creating TKPROF

I) Generate Trace File 1) Enable Tracing for the Concurrent Program a) select the ‘Enable Trace’ Checkbox 2) Turn on Tracing a) Login as a user with ‘system administrator’ responsibility b) Navigate: Profiles > System c) Query Profile Option ‘Concurrent: Allow Debuggin’ d) Set profile to ‘YES’ 3) Run Concurrent Program with Tracing Turnv On […]

Disabling NUMA parameter

Reasons to disable NUMA 1) To prevent NUMA from using high percentage of cpu 2) To imrove filesystem utility performance on linux subsystem How to disable the NUMA parameter 1. Issue the following commands in sqlplus to disable NUMA: alter system set “_enable_NUMA_optimization”=FALSE scope=spfile; alter system set “_db_block_numa”=1 scope=spfile; 2. grep -i numa $ORACLE_HOME/dbs/spfilerelp.ora and […]