• Deiby Gómez (Oracle ACE, Guatemala) and YV Ravikumar (OCM, India) have written another Article in OTN Spanish for Latin America:


    Article Name: Todo lo que tienes que saber sobre COMMON y LOCAL en Oracle Database 12c


    http://www.oracle.com/technetwork/es/articles/idm/common-local-12c-2190666-esa.html


    Thank you very much to my co-author YV RaviKumar Ocm and Thanks to Oraworld-team for the support.

    Todo lo que tienes que saber sobre COMMON y LOCAL en Oracle Database 12c

    Por Deiby Mauricio Gómez  y Yenugula Venkata RaviKumar (OCM) 


    Publicado en Abril 2014

    Bienvenidos de nuevo colegas de Oracle Latinoamérica, es de mucho agrado para nosotros seguir contribuyendo con nuestros artículos a la comunidad Oracle, hemos trabajado constantemente en traerles contenido de calidad, con el cual puedan aprender lo que la versión 12c nos trae de una manera eficaz y eficiente, con ejemplos claros y concisos, con teoría fundamental y con muchas experiencias listas para compartir. Como bien saben, la arquitectura de la base de datos Oracle en su versión 12c ha sufrido muchas mejoras, ahora ya se puede hablar de “Pluggable Database”, de “Container” y de “SEED”. Para quienes ya están adentrados en estos nuevos conceptos de “multitanent” ya estarán al tanto de que una base de datos de tipo “CDB” puede contener desde cero a hasta 253 “Pluggable Databases” incluyendo el “SEED”.  A la base de datos que aloja todas las bases de datos internas se le denomina  “CDB$ROOT” y a las bases de datos internas se les denominan “Pluggable Database” o “PDB”, el “PDB$SEED” también es una PDB, pero la diferencia es que solo puede estar abierta en modo lectura y es utilizada como una plantilla para crear nuevas PDB.

    Ver el articulo completo aqui:

    http://www.oracle.com/technetwork/es/articles/idm/common-local-12c-2190666-esa.html

     

    facebooktwitterlinkedinmailby feather
  • El día jueves 10 de abril del 2014 tuve la oportunidad de poder compartir una conferencia de la base de datos Oracle en la Universidad Nacional Atónoma de Nicaragua (UNAN) en Managua, Nicaragua. 

    A dicha conferencia asistieron más de 50 estudiantes de las carreras universitarias "Ingenieria en Ciencias y Sistemas" e "Ingenieria en Ciencias de la Computación" de dicha universidad. Esta conferencia fué muy entretenida y varios estudiantes participaron con preguntas las cuales enriquecieron la conferencia. 

    Agradezco mucho al Lic. Roberto Solis y al Master Juan de Dios Bonilla por la oportunidad brindada en dicha casa de estudios universitarios.

    Descarga la presentación aqui: Administración Básica de Oracle DB 11g y 12c

    A continuación comparto unas fotografias:

    2014-04-10-0016 2014-04-10-0018 2014-04-10-0035_Q1 2014-04-10-0038 20140410_150000

     

     

     

     

     

     

     

     

     

    facebooktwitterlinkedinmailby feather
  • "No solo de Oracle vive el hombre, sino también de cada movimiento de peon que sus manos realizan". Deiby Gómez.

    • Universidad de San Carlos de Guatemala CAMPEON en Ajedrez de JUDUCA 2014 Nicaragua 
    • Deiby Gómez medalla de oro en el 5to Tablero.

     

    1004873_732366293451470_6051552386521094115_n

    facebooktwitterlinkedinmailby feather
  • Oracle Technology Network
    Oracle ACE Program Newsletter
    By ACEs, For ACEs April 2014

    Oracle ACE Spotlight Dan Hotka, Oracle ACE DirectorDanHotka

    Dan Hotka is an Oracle ACE Director and a Training Specialist who has over 36 years in the computer industry and over 30 years of experience with Oracle products. His experience with RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of Oracle. He has written 12 Oracle books and over 200 published articles. He is frequently published in Oracle trade journals, blogs, and speaks at Oracle conferences and user groups around the world.

    Dan has enjoyed his vendor jobs over the years, his first one 
    trained him in both Oracle and Unix. As with many folks, Oracle Corp provided a great start to his career path. He still has the PC Oracle v4 three book doc set with its six 5 1/4 diskettes! He met fellow ACE Director Tim Gorman when working for Oracle Consulting in the early 1990's. Dan enjoys the travel that comes with his work. It has allowed him to explore many parts of the world where he met many interesting people along the way.

    One of Dan's favorite hobbies is retoring cars (2 VW bugs and now an Isetta). He also spends time gardening, woodworking, doing home renovation projects on his 75 year old home, hanging out with his aging dad, and playing with his first grandchild! Dan has 3 adult children with his wife of 36 years. Life is good.

    Oracle ACE Program News

    Welcome New Oracle ACEs

    Initiated March 2014

     Name  Location Focus
    Rene AntunezOracle ACE Mexico DB
    Uli BethkeOracle ACE Ireland BI
    Stewart BrysonOracle ACE United States BI
    Karen CannellOracle ACE United States DB
    Jim CzuprynskiOracle ACE United States DB
    Ric Van DykeOracle ACE United States DB
    Maris ElsinsOracle ACE Latvia Apps
    Anar GodjaevOracle ACE Azerbaijan DB
    Doug GaultOracle ACE United States DB
    John HurleyOracle ACE United States DB
    Maxym KharchenkoOracle ACE United States DB
    Vishal PathakOracle ACE Australia BI
    Zoran PavlovicOracle ACE Serbia DB
    Ronald Vargas QuesadaOracle ACE Costa Rica DB
    Manuel RosaOracle ACE Portugal OFM
    Tsubasa TanakaOracle ACE Japan AMySQL

    Our First 10 Oracle ACE Associates have been Initiated!

    Congrats to our first group of Oracle ACE Associates! Thank you Oracle ACE and ACE Directors for all of your nominations. We value your input and appreciate your help with nominations. Keep them coming.

    Oracle ACE Dinner at Collaborate 2014

    Collaborate 14, April 7-11, Las Vegas will be here in soon! If you haven't registered yet, there's still time. Don't miss out on the fun you will have networking and catching up with your peers throughout the week.

    You are also invited to join us at the Oracle ACE dinner on Mon, Apr 7, 7:00 p.m. at Canaletto Ristorante. Please RSVP here if you haven't already done so.

    Call for Papers

    Oracle OpenWorld | Sep 28-Oct 2, 2014 | San Francisco, CA
    Submission Deadline: April 15

    JavaOne | Sep 28-Oct 2, 2014 | San Francisco, CA
    Submission DeadlineApril 15

    OAUG Connection Point AppsTech | July 22-23, 2014 | Pittsburgh, PA
    Submission Deadline: April 20

    Call for Articles

    UKOUG Oracle Scene Magazine | Summer Edition
    Submission deadline: April 11

    Learn How to Plug Into the Internet of Things

    A global network of billions of devices sharing data is opening up unprecedented business opportunities. How well positioned is your company to take advantage of this seismic shift? Join Oracle, our partners and customers on Thursday, April 24 to learn how turn the Internet of Things into real business value. Register now.

    New Mobile Persistence Video

    Check out this video showing a new extension to build a mobile app with local persistence, sync to data on the server, via a SOAP/REST service. The supporting details blog post can be read here.

    Interested in Writing?

    If you have the enthusiasm for communicating technical ideas and concepts, have a valuable experience or a technical skill that you're keen to share with readers, you should give serious consideration to authoring a book or becoming a technical reviewer. Please contactsheila.cepero@oracle.com for more details.

    >back to the top

    Oracle ACE Watch

    NEWS

    JAVA 8 is available for download!

    Java 8 is finally here and ready for download. If you missed the Java 8 launch last week, check it out on demand.

    As ACE Director and Java Champion Markus Eisele points out, it's been a long wait for Java 8 – exactly 2 years, 7 months, and 18 days after the release of Java 7. Here is a brief overview about his personal highlights of this long journey.

    Here's another celebratory blog post by ACE Director Lucas Jellema on his thoughts around the general availability of Java 8.

    Last but not least, Manning Publications created a Java 8 video about"First-class functions in Java 8". There is also a standing 38% discount code which is valid for all eBooks, pBooks and MEAPs. Enter code:vturma01 at checkout.

    ODTUG APEX Theming Competition 2014

    You still have time to create APEX themes and have them viewed by the entire international APEX community. ACE Director Martin D'Souza and Oracle ACE Christian Rokitta will be part of the judging panel. The winner will be crowned 2014 ODTUG APEX Theme Developer of the Year during the Kscope conference, June 22-26. Submission deadline May 15th. Learn more here.

    NEW ARTICLES

    OTN: Speedy Perception versus Speedy Reception: Smart Asynchronous Interactions, written by ACE Director Lucas Jellema

    Oracle Magazine: TECHNOLOGY: Consolidated Database ReplayPlaying Nice Together, written by ACE Director Arup Nanda

    OTN: Using COMSTAR and ZFS to Configure a Virtualized Storage Environment, written by Oracle ACE Alexandre Borges (in Spanish)

    OTN: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 1) (Part 2) (Part 3), co-authored by Oracle ACE Deiby Gómez Robles (in Spanish)

    OTN: Recomendaciones de administración de Oracle SOA Suite 11G. Parte 2 de 2, written by Oracle ACE Rolando Carasco (in Spanish)

    OTN: Oracle 12c y Hadoop para mejor almacenamiento y procesamiento de datos, written by Oracle ACE Wissem El Khlifi (in Spanish)

    OTN: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 1) (Part 2) (Part 3), co-authored by Oracle ACEs Deiby Gómez Robles and David Siqueira (in Portuguese)

    OTN: Oracle Exadata Database Machine: "Write-Back Flash Cache"co-authored by Oracle ACEs Deiby Gómez Robles and David Siqueira (in Portuguese)

    VIDEOS & PODCASTS

    VIDEO: Part 2: Real Time BI, Episode 18, ODI

    Real Time BI with ACE Directors Stewart Bryson and Kevin McGinley. Episode 18 – This is Part 2 of their conversation with Oracle ACE Uli Bethke from Sonra and Alex Shlepakov from Accenture. They continue discussing all things ODI, including the new version 12c, comparisons to other ETL tools, ODI in the BI Applications, and integration with the world of Hadoop. View Part 1.

    VIDEO: User Experience

    OTN Community Video Interview with Oracle ACE Director Lucas Jellema, solution architect and CTO at AMIS Sercvices, and Oracle Applications User Experience VP Jeremy Ashley where they discuss theevolution of User Experience.

    VIDEO: Analysing Parallel Execution Skew

    New series of video tutorials brought to you by ACE Director Randolf Geist on the topic of "Analysing Parallel Execution Skew". The initial part of the series is a brief introduction into the topic and here's a supportingblog post

    BLOG POSTS

    Oracle 12c SQL & PL/SQL New Features Q&A

    Oracle ACE Ami Aharonovich provides the transcript of his Q&A from the Oracle Database 12c SQL and PL/SQL new features webinar.

    Improving ADF UI Table CRUD Functionality with Auto Focus

    This post written by ACE Director Andrejus Baranovskis provides a general method on Improving and tuning ADF applications performance.

    ORACLE DATA GUARD SWITCHOVER VIA DGMGRL VS. #EM12C

    Oracle Data Guard can switchover between Primary database and Physical Standby database from the command line and then from OEM12c. Read more in Oracle ACE Bobby Curtis' blog. In a different post, Bobby provides insight into how using DCLI can help run commands across all the nodes of the Exadata.

    What's New with Oracle Data Mining?

    ACE Director Brendan Tierney shares some tips about ODM including:
    ODM Graph Node new feature
    Changing the bar chart format in Explore Node
    - Issues with using latest release of ODM
    - And a Bonus: ORE 1.4 New Parallel feature

    XREF on a Text Member in Planning
     
    This post written by Oracle ACE Celvin Kattookaran talks about how to perform an XREF on a text measure.

    Recurring Conversations – Incremental Statistics

    Doug Burns, ACE Director, writes about a few forgotten fundamentals of using Oracle 11g Incremental Global Stats that can cause confusion the first time you try to use them. Part 1Part 2Part 3.

    Flashback Fail?

    Read this post written by ACE Director Jonathan Lewis on why a typical database implementation may fail in less than 4 years.

    Jonathan also provides part 1 in a series of interpreting Execution Plans.

    DBA skills are among the Top 10 IT skills for 2014

    Yes, that is true, but ACE Director Julien Dontcheff also shares other factors on why the DBA profession falls on top of the lists of hiring and salary surveys.

    Live from the 1st Annual World Wide Data Vault Consortium

    ACE Director Kent Graziano had the priviledge of speaking at the 1st annual world wide Data Vault Consortium. Here's his daily wrap of the 3-day event. Day 1Day 2, Day 3.

    Oracle EBusiness Suite R12 is one of the globally used ERP systems

    Oracle ACE Lakshmi Sampath describes the steps involved in setting up UMX Role based Access control (RBAC) to allow viewing other user's request in R12.

    Live Blog – Oracle & AMIS User Experience Event

    Live blog covering the User Experience day organized jointly by Oracle Applications User Experience team and AMIS, ACE Director Lucas Jellema. Check out the slides from the event.

    New Version Of XPLAN_ASH Utility

    A minor update 4.01 to the XPLAN_ASH utility is available for downloadhere in ACE Director Randolf Geist's blog.

    Dynamic Resource Mastering in 12c

    In his blog, Riyaj Shamsudeen talks about new features in RAC and dynamic remastering and discussed important differences between 11gand 12c database versions. In a separate post, he shares the guiding principles while diagnosing performance issues in a RAC database.

    Oracle Business Rules (in Spanish)

    Using Oracle Business Rules is rules-oriented to express in a very simple pattern. This post written by Oracle ACE Rolando Carrasco provides an overview of how to represent the rules and how to use them.

    ROOT CAUSE CORRECTIVE ACTION REPORTS

    This post written by Oracle ACE Chris Foot provides a detailed description of the Root Cause Corrective Action process and associated documentation for commonly found issues.

    Oracle ACE Out and About
    • Speaking at Collaborate14 (Apr 2014)
      Over 65 Oracle ACE and ACE Directors
       
    • Speaking at OUGN (Apr 2014)
      Martin Bach - ACE Director, DB
      Doug Burns - ACE Director, DB
      Lonneke Dikmans - ACE Director, OFM
      Markus Eisele - ACE Director – OFM, Java
      Tim Gorman - ACE Director, DB
      Tim Hall - ACE DIrector, DB
      Roel Hartman - ACE Director, DB
      Heli Helskyaho - ACE Director, DB
      Debra Lilley - ACE Director, Apps
      Connor McDonald - ACE Director, DB
      Martin Nash - Oracle ACE, DB
      Kellyn Pot'Vin - ACE Director, DB
      Mark Rittman - ACE Director, BI
      Brendan Tierney - ACE Director, BI
      Jim Czuprynski - ACE Director, DB
      Cary Millsap - ACE Director, DB
       
    • Speaking at SOUG (Apr 2014)
      Christian Antognini - ACE Director, DB
       
    • Speaking at UKOUG Availability Infrastructure & Mgmt SIG(Apr 2014)
      Jason Arneil - Oracle ACE, DB
       
    • Speaking at EMEA Partner Community Forum (Apr 2014)
      Julian Dontcheff - ACE Director, DB
      James Anthony - Oracle ACE, DB
      Andreas Chatziantoniou - Oracle ACE, OFM
       
    • Speaking at Enterprise Data World (Apr 2014)
      Kent Graziano - ACE Director, DB
       
    • Speaking at EMEA PeopleSoft Roadshow (Apr 2014)
      Graham Smith - ACE Director, Apps
       
    • Speaking at OAUG Connection Point (Apr 2014)
      Barbara Matthews - Oracle ACE, Apps
       
    • Speaking at TROUG BI&DW SIG (Apr 2014)
      Gurcan Orhan (+organizer) – ACE Director, DB
      Gökhan Atil - Oracle ACE, DB
      Zekeriya Besiroglu - Oracle ACE, DB
       
    • Speaking at DevNation (Apr 2014)
      Markus Eisele - ACE Director, OFM/Java
       
    • Speaking at MySQL Japan UG (Apr 2014)
      Ronald Bradford - ACE Director, MySQL
       
    • Speaking at COUG (Apr 2014)
      Martin D'Souza - ACE Director, DB
       
    • Speaking at Hyperion/BI Solutions SE Conference (Apr 2014)
      Glenn Schwartzberg - ACE Director, BI
       
    • Speaking at Heartland OUG (Apr 2014)
      Susan Behn - Oracle ACE, Apps
      Dan Hotka - ACE Director, DB
       
    • Speaking at AOUG (Apr 2014) (May 2014)
      Christian Pfundtner - Oracle ACE, DB
       
    • Speaking at Jax Day (May 2014)
      Torsten Winterberg - ACE Director, OFM
      Adam Bien - ACE Director, OFM/Java|
       
    • Speaking at DOAG ExaDay (May 2014)
      Andreas Chatziantoniou - Oracle ACE, DB
      Bjoern Broehl - ACE Director, DB
       
    • Speaking at SROUG (May 2014)
      Dan Morgan - ACE Director, DB
       
    • Speaking at Paris Oracle Meetup (May 2014)
      Christian Antognini - ACE Director, DB

    >back to the top

    Architect Corner

    Podcast: Big Data Architecture, Part 2

    This OTN ArchBeat Podcast virtual discussion panel is part 2 of how Oracle Database fits into a Big Data Architecture, and shares insight on one of the more persistent problems in technology adoption. The panel includes Oracle ACE Director and Hadoop expert Gwen Shapira and Oracle Big Data Handbook authors. Listen to part 1.

    >back to the top

    Upcoming Events
    • OUGN
      Apr 3-5, 2014 | Oslo, Norway
    • Collaborate14
      Apr 7-11, 2014 | Las Vegas, NV
    • COUG
      Apr 17, 2014 | Calgary, Canada
    • Heartland OUG 
      Apr 24, 2014 | Omaha, NE
    • JAX Day 
      May 12-16, 2014 | Mainz, Germany
    • SROUG
      May 28-30, 2014 | Arandelovac, Serbia
    • OUGF
      June 5-6, 2014 | Espoo, Finland
    • Kscope14
      June 22-26, 2014 | Seattle, WA

      For a list of all upcoming Oracle events, click here.

    >back to the top

    Oracle ACE Quick Links

    Oracle ACE Directory

    Oracle ACE Nomination Forms

    Oracle ACE Google Map

    Follow @oracleace on Twitter. Hashtag #oracleace

    Join the Oracle ACE group on Facebook

    Join the Oracle ACE group on LinkedIn

    Oracle Blogs

    Oracle Technology Network

    OTN Discussion Forums

    Oracle Wiki

    Oracle.com

    subscribe
    Subscribe to Oracle newsletters
    What Are You Doing?
    Have you published an article? Are you speaking somewhere? Promote yourself here!
    Comments? Suggestions?

     

    Hardware and Software Engineered to Work Together
    facebooktwitterlinkedinmailby feather
  • Understanding ITL:

    1. Many rows can be in the same block.
    2. The number of the Slots in the ITL is set by INITRANS in the “CREATE TABLE” sentence.
    3. Every Slot has “row id” and “transaction id”. It means the transaction id that is touching the row, and the information of that row. 
    4. MAXTRANS is deprecated after 10g. After 10g the ITL can has until 255 Slots automatically, if there are free space in the block.

    A block without rows and with INITRANS=1
     

    1

     

     

     

     

     

     

    A block with 3 rows and with INITRANS=1 (no locks)

    2

     

     

     

     

     

     

    Update table set a=b where row=row1;
    A block with 3 rows and with INITRANS=1 (1 lock)

    3

     

     

     

     

     

     

    Update table set a=b where row=row2;

    A block with 3 rows and with INITRANS=1 (1 slot added automatically) (2 locks)

    4

     

     

     

     

     

     

    Conclusion about ITL:

    • When a transaction is touching a row and that row doesn’t have any lock, that transaction will use a new slot.
    • When a transaction is touching a row that is locked by another transaction, the transaction can’t use a new slot and it will wait for "enq: TX – row lock contention"
    • When a transaction is touching a row in the same block, and slots can’t be created because of no space, the transaction will wait for “ITL wait” 

    Practicing the symptoms:

    SQL> create table dgomez.B (id number not null primary key,value varchar2(20)) INITRANS 1 tablespace dgomez;

    Table created.

    Note: Tablespace DGOMEZ is “Segment space management = AUTO” because in MIHPPPRD the tablespace HPPPUB_DATA is AUTO.

    SQL> insert into dgomez.B values
      2  (1,'dgomez');

    1 row created.

    SQL> insert into dgomez.B values
      2  (2,'gomez');

    1 row created.

    SQL> insert into dgomez.B values (3,'robles');

    1 row created.

    SQL> insert into dgomez.B values (4,'mauricio');

    1 row created.

    SQL> commit;

    Commit complete.

    SQL> select * from dgomez.B;

            ID VALUE
    ———- ——————–
             1 dgomez
             2 gomez
             3 robles
             4 mauricio

    Session 31:
    SQL> update dgomez.B set value='mod' where id=1;

    1 row updated.

    Session 30:
    SQL>  update dgomez.B set value='mod2' where id=1;
    …(it hangs)

    Note: Locking the same row.  The session 31 will use a new slot. The session 30 can’t use a new slot and has to wait with “enq: TX – row lock contention”

    Session 100:
    SQL> SELECT sid, p1raw, p2, p3
    FROM v$session_wait
    WHERE wait_time = 0
    AND event = 'enq: TX – row lock contention';  2    3    4

           SID P1RAW                    P2         P3
    ———- —————- ———- ———-
            30 0000000054580006     655382        230


    SQL> select state, event, wait_class from v$session where sid=30;

    STATE               EVENT                          WAIT_CLASS
    ——————- —————————— —————————————-
    WAITING             enq: TX – row lock contention  Application


    How many row locks have had?

    SQL> SELECT owner, object_name, subobject_name, value
    FROM v$segment_statistics
    WHERE statistic_name='row lock waits'
    AND value > 0
    ORDER BY 4 DESC;  2    3    4    5

    OWNER                          OBJECT_NAME                    SUBOBJECT_NAME                      VALUE
    —————————— —————————— —————————— ———-
    DGOMEZ                         B                                                                      1

    Session 39:
    SQL> update dgomez.B set value='mod2' where id=2;

    1 row updated.

    Session 40:

    SQL> update dgomez.B set value='mod3' where id=2;
    …(it hangs)

    Note: Locking the same row.  The session 39 will use a new slot (two slots so far). The session 30 can’t use a new slot and has to wait with “enq: TX – row lock contention”

    How many row locks have had?

    SQL> SELECT owner, object_name, subobject_name, value
    FROM v$segment_statistics
    WHERE statistic_name='row lock waits'
    AND value > 0
    ORDER BY 4 DESC;  2    3    4    5

    OWNER                          OBJECT_NAME                    SUBOBJECT_NAME                      VALUE
    —————————— —————————— —————————— ———-
    DGOMEZ                         B                                                                      2

    Note: Two row locks so far.

    How many rows there are per block?

    SQL> SELECT count(*) as "Rows per Block" FROM dgomez.B
    WHERE
    dbms_rowid.rowid_block_number(rowid) = (SELECT min(dbms_rowid.rowid_block_number(rowid)) FROM dgomez.B)
    /
      2    3    4  Press Return to Continue

    Rows per Block
    ————–
                4

    Note: All the rows are in the same block.

    What is the block where the locked rows are?

    SQL> SELECT row_wait_obj#,
      row_wait_file#,
      row_wait_block#,
      row_wait_row#
    FROM v$session
    WHERE sid in (SELECT sid
    FROM v$session_wait
    WHERE wait_time = 0
    AND event = 'enq: TX – row lock contention');  2    3    4    5    6    7    8    9
    Press Return to Continue

    ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
    ————- ————– ————— ————-
            13842              5             132             0

    We will create a dump file in order to analyze that block:

    SQL> alter system dump datafile 5 block 132;

    System altered.

    (dump file)
    Block header dump:  0×01400084
    Object id on Block? Y
    seg/obj: 0×3612  csc: 0×00.6c2e8  itc: 2  flg: E  typ: 1 – DATA
         brn: 0  bdba: 0×1400080 ver: 0×01 opc: 0
         inc: 0  exflg: 0

    Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
    0×01   0×0005.01c.000000eb  0x00c00f8c.0039.24  –U-    8  fsc 0×0000.0006c2fc
    0×02   0×0008.00c.000000e7  0x00c000f2.0049.05  C—    0  scn 0×0000.0006c2e8
    bdba: 0×01400084
    data_block_dump,data header at 0x7f7aa867b064
    ===============

    Note: itc means how many slots there are. There are two slots, do you remember why? If not, please come back to the section “practicing the symptoms“

    Touching another row in the same block:

    Session 50:
    SQL>  update dgomez.B set value='mod2' where id=4;

    1 row updated.

    SQL>

    Note: so far, there are 3 rows touched in different sessions. Do you know how many slots should have? Yes, 3.

    We will create a dump file in order to analyze that block:

    SQL> alter system dump datafile 5 block 132;

    System altered.

    (dump file)
    Block header dump:  0×01400084
    Object id on Block? Y
    seg/obj: 0×3612  csc: 0×00.6c436  itc: 3  flg: E  typ: 1 – DATA
         brn: 0  bdba: 0×1400080 ver: 0×01 opc: 0
         inc: 0  exflg: 0

    Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
    0×01   0×0003.00f.000000ea  0x00c010db.003e.15  —-    1  fsc 0×0001.00000000
    0×02   0x000a.001.000000e7  0x00c00d3f.0040.0d  —-    1  fsc 0×0000.00000000
    0×03   0×0007.001.000000e3  0x00c01646.0039.2c  —-    1  fsc 0×0005.00000000
    bdba: 0×01400084
    data_block_dump,data header at 0x7fa896df7a7c
    ===============

    Note: there are 3 slots used and created automatically.

    Conclusion:

    • If you are touching a same row then the second transaction will hang with 'enq: TX – row lock contention'
    • if you are touching differents rows but those rows are in the same blocks, it depends if there are ITL Slots enough.
    • if there are no ITL Slots enough, so the transactions will wait for "ITL wait".
    • How to improve the ITL waits?

      • Increasing the PCTFREE in order to have more space for ITL Slots.

      • After increase the PCTFREE, move the table or recreate it.

    ​​Reference used: http://www.proligence.com/itl_waits_demystified.html

     

    facebooktwitterlinkedinmailby feather
  • My second article in English published on OTN. 


    Oracle Exadata Database Machine – Write-Back Flash Cache

    http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash-2179184.html


    by Deiby Gómez (Oracle ACE, Guatemala) and YV Ravikumar (OCM, India)

    Thank you very much to my co-author YV RaviKumar Ocm

    I'm very proud of be a member of Oraworld-team

    Oracle Exadata Database Machine – Write-Back Flash Cache 

    Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments. 

    Since its availability in 2008, Oracle Exadata has evolved from a data warehousing machine to a powerful solution for consolidation. With the addition of many features from version to version, the machine has become efficient in handling Data warehousing and OLTP workloads together. Achieving Extreme performance is always the goal for Exadata and its new features like Smart Scan, Smart Flash Cache, and Smart Flash Logging have made it possible. The latest feature, Write back flash cache, is another addition to the key enablers of Exadata’s Extreme Performance which again the combination of Hardware (Flash Drives) and Software (Exadata Storage Server Software) engineered together.

    Complete article here:

    http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash-2179184.html

    facebooktwitterlinkedinmailby feather
  • An Insight into Oracle Flex ASM and Its Benefits



    Introduction

     

    Oracle Real Application Cluster (RAC) is a well-known product among Oracle’s solutions to maintain high availability of your business data. Oracle RAC allows the work load to be shared among all the cluster nodes, with N-1 tolerance configuration in case of node failures, where N is the total number of nodes. Oracle RAC is constantly improving on every version and this time was not different. The new 12.1.0.1 version incorporates two properties called “Flex ASM” and “Flex Cluster” that gives support to the demand requirements on Cloud Computing oriented environments.

    Oracle RAC 12c introduces two new concepts:

    Hub Nodes: They are connected among them via private network and have direct access to the shared storage just like previous versions. These nodes are the ones that access the Oracle Cluster Registry (OCR) and Voiting Disk (VD) directly.

    Leaf Nodes: These nodes are lighter and are not connected among them, neither access the shared storage like the Hub Nodes. Each Leaf Node communicates with the Hub Node that is attached to, and its connected to the cluster via the Hub Node that is linked to.

    complete article here:

    http://www.oracle.com/technetwork/articles/database/flexasm-flexcluster-benefits-odb12c-2177371.html

    facebooktwitterlinkedinmailby feather
  • Portuguese version:

    Deiby Gómez (Oracle ACE) from Guatemala and Yenugula Venkata Ravikumar (Oracle Certified Master) from India have written an article (3 parts) in Spanish about Oracle Exadata Database Machine, also these articles will be published in Portuguese and English. Guatemala and India are working together to improve knowledge in Latin America.

    Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 3)

    Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 2)

    Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 1)

    facebooktwitterlinkedinmailby feather
  • Deiby Gómez (Oracle ACE) from Guatemala and Yenugula Venkata Ravikumar (Oracle Certified Master) from India have written an article (3 parts) in Spanish about Oracle Exadata Database Machine, also these articles will be published in Portuguese and English. Guatemala and India are working together to improve knowledge in Latin America.

    Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 1)
    http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-de-datos-parte1-2166616-esa.html
    Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 2)
    http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte2-2167445-esa.html
    Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 3)
    http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte3-2167449-esa.html

    facebooktwitterlinkedinmailby feather

Sígueme

¿Qué buscas?



ORAWORLD TEAM


Deiby Gómez (Guatemala) ACE & OCP
YV Ravikumar (India) OCM
Nassyam Basha (India) Oracle Author & OCP
Alex Zaballa (Brazil) ACE & OCM
David Siqueira (Brazil) ACE & OCP



Nombre: Deiby Gómez
Lugar de Trabajo: Xerox Guatemala.
Pasatiempos: Ajedrez.
Twitter @hdeiby

Perfil en Oracle LAD



Certificaciones:
- Oracle Linux Certified Implementation Specialist.
- Oracle Database 11g Administrator Certified Professional.
- Oracle Database 12c Administrator Certified Professional.
- Oracle Service Oriented Architecture Infrastructure Implementation Certified Expert.
- Oracle Exadata Database Machine Administrator.
- Oracle RAC 11g and Grid Infraestructure Administrator