Be aware and act accordingly 8-), that, if you need some brain food, that there is a chance to might want to register for the OakTable World mini conference during Oracle OpenWorld.
Agenda and Registration can be done via the following link: OakTable World
Hierbij nog dank voor allen die aanwezig waren bij de weer gevulde, informatieve & gezellige avond tijdens “Hotsos Revisited 2013″.
Wij presentatoren hebben genoten van het ambiance. Hier ook nog voor degenen die graag het nog een keer willen nalezen het presentatie materiaal van Toon, Jacco, Gerwin, Frits en mij…
Presentatie materiaal in alfabetische volgorde:
Hopelijk zien we jullie misschien weer tijdens de Masterclass over Oracle storage “Understanding storage met Oracle ACE Director James Morle” en anders hopelijk tot een volgende keer bij AMIS in Nieuwegein.
Marco
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning.
HTH
Marco
A customer of mine run out of memory due to much server processes of dedicated connected client sessions. As an alternative I tried to explain the options between DEDICATED and SHARED SERVER concepts as an initial attempt/workaround for the client software problems. Looking around on the internet for pictures and or newbie documentation, I found the following nugget on YouTube that explains the basics and how to address them.
Due to the fact that the XMLDB XDB Repository Architecture, which makes it possible to connect to the database via HTTP(s)/WebDAV en FTP, also makes use of the Oracle Shared Server Architecture (or referenced in the old days as MTS – Multi Threaded Server), this information is still very valid concerning those XDB Repository HTTP(s), WebDAV and FTP connections and/or APEX connections based on the PL/SQL Gateway (which is a part of the XDB Protocol Server functionality).
For my single instance databases, I configure a value of shared_servers=5, and most of the time that should be enough not to cause connection “hiccups” (clients “freeze” for a short while), and an appropriate value for LARGE_POOL_SIZE. Most of the time in a standard DBCA created database, the DISPATCHER parameter is already configured but not really active, because not a lot of people are aware of the XMLDB Repository access architecture and therefore don’t connect via this method. Also due to an enhancement request I once made during 11.1, HTTP(s)/WebDAV/FTP ports are not enabled via DBMS_XDB.SETHTTPPORT() and DBMS_XDB.SETFTPPORT(), that is, have both a value of 0.
On a production database you could decide to even get rid of the default setup by disabling DISPATCHER and SHARED_SERVER processes, if need be. As said, most of the times the DISPATCHER is enabled and though it doesn’t do any work, it will eat some of your CPU and memory resources. On a 10.x environment this will even be more likely. As I mentioned, my enhancement was honored from 11.1 and upwards, so…
The video talks about configuring DISPATCHER, SHARED_SERVER, LARGE_POOL_SIZE, etc. I never really tweak parameters before it is really needed. So one of the small pieces of advice I would give you, is that you should realize that, besides setting values to be able peak connection strains on the database, you should also realize that LARGE_POOL_SIZE (when set) will also automatically be used for other mechanisms like RMAN backup optimization. So while trying to figure out stuff like “sessions”, “circuit” etc value, keep in mind that this static LARGE_POOL_SIZE parameter, during peak moments, has to take into account stuff like RMAN backup windows/run times on that database.
HTH
Marco
Sorry, for those who where missing, or needed, some of the info here yesterday. Due to a small mishap regarding an incorrect URL update, some annoying redirects occurred.
:S
Als sluitstuk van de jaarlijkse Oracle OpenWorld conferentie brengt AMIS een whitepaper uit. Een handzaam document waarin het volledige verhaal van Oracle OpenWorld 2012 is gebundeld.
Een team van AMIS was tijdens de conferentie in oktober nadrukkelijk aanwezig; als sponsor, deelnemer, netwerker en spreker – en als aandachtig luisteraar en analist.
Zeven Oracle-specialisten van AMIS hebben deze whitepaper samengesteld waarin de visie, plannen en aankondigingen van Oracle zijn gebundeld. In het maar liefst 47 pagina’s dik document wordt niet alleen het verhaal van Oracle samengevat, maar geeft AMIS ook haar eigen duiding en waardering van het verhaal.
De whitepaper is hier gratis te downloaden.
Van 30 september tot 5 oktober is San Francisco weer het domein van tegen de 45.000 deelnemers aan de Oracle Open World en JavaOne conferenties. Ruim 2000 presentaties worden daar gehouden, in vele tientallen zalen in hotels en het Moscone Conferentie Center in downtown San Francisco, waaronder pakweg 20 door Nederlandse sprekers. Hoewel honderden Nederlandse bezoekers op deze conferentie aanwezig zullen zijn, zijn er natuurlijk ook veel ‘thuisblijvers’. Om deze groep (en iedereen die wel gaat) toch of alvast een voorproefje te geven, organiseert AMIS voor de vijfde keer de Preview sessie voor Oracle Open World en JavaOne – een avond waarop Nederlandse sprekers met een OOW en/of JavaOne verleden, heden of toekomst een presentatie houden, bijvoorbeeld als generale repetitie voor hun optreden in San Francisco.
Deze sessie is gratis toegankelijk. Aanmelden kan via de AMIS website: Preview Oracle Open World en JavaOne 2012. De deuren gaan open op dinsdag 18 september om 16.30, om 18.00 uur is er een maaltijd en rond 21.00 uur eindigen de laatste vier sprekers en openen we de bar.
Sprekers tijdens deze preview zijn: Steven Davelaar, Lonneke Dikmans, Ronald van Luttikhuizen, Jacco Landlust & Simon Haslam, Toon Koppelaars, Roel Hartman, Luc Bors, Kees Jan Koster, Frits Hoogland, Frank Houweling, Emiel Paaschens en Aino Andriessen. De onderwerpen varieren van diep technisch zoals JVM Transaction Monitoring en Database Multi-block reads tot meer front end gericht met bijvoorbeeld HTML 5 en APEX en ADF voor mobiele applicaties. Andere thema’s zijn database triggers, database gebaseerde web services, deployment van ADF applicaties, beheer van FMW infrastructuur, business rule validatie in SOA Suite met Schematron, fout-afhandeling in SOA Suite en performance optimalisatie van ADF applicaties.
Nota Bene: op dinsdag 16 oktober doen we verslag van Oracle Open World en JavaOne. In een sessie van pakweg 3.5 uur zullen we de belangrijkste aankondigingen, de trends en de sfeer, de nieuwtjes en berichten van achter de schermen en in de wandelgangen weergeven en duiden. In een avond ben je op de hoogte – alsof je er zelf in San Francisco bij bent geweest. Ook voor deze gratis sessie kan je je al inschrijven: Verslag van Oracle Open World & JavaOne 2012.
I hereby am following up on a small tradition, that I think I get going since 2006…An agenda overview of all things XMLDB you can do or see during this years Oracle Open World. Oracle Open World is the biggest IT conference nowadays in the world with 40.000+ thousand attendees and 1600+ sessions or workshops, so an overview regarding specific topics can be handy. 
If there is an update or something needs correction or added, please post it here. If you have any questions, meet me in one of those sessions, during the Hands-on Labs or ACE hangout OTN tent on Howards’ street.
HOL10055 – Oracle XML DB Hands-On Lab ===================================================================== This hands-on lab provides an introduction to using Oracle XML DB and XQuery to store and manage XML content stored in Oracle Database. It introduces the different kinds of XML storage and indexing offered by Oracle XML DB and shows how to optimize XQuery operations on XML content by selecting the correct storage and indexing model. The lab also provides an introduction to the XML features available in the latest version of Oracle Database, including the new XQuery Update standard. And it shows how to take full advantage of the latest XQuery standards, such as XQuery Full-Text, to develop applications that combine the power of Full-Text and XML-based indexes BOF9908 – Oracle XML DB BOF ===================================================================== This session provides you with an opportunity to get answers to your questions about Oracle XML DB from the development team, product management team, acknowledged independent experts, and fellow Oracle XML DB users. The goal is to have an open and frank discussion about how to get the best out of all the features of Oracle XML DB. The session gives you a chance to establish personal contact with the people who have firsthand experience with developing and delivering systems that make use of Oracle XML DB CON8443 – Simple Content Management with Oracle XML DB and Database Native Web Services ===================================================================== This session demonstrates the power of the Oracle XML DB repository. You will learn how to automate the processing of documents stored in the Oracle XML DB repository, using repository events, and how to combine XML, PL/SQL, and database native Web services with Ajax and JavaScript to create simple, effective applications that leverage the full power of Oracle XML DB and the Oracle XML DB repository. The session focuses on a sample application, called XFiles, and shows how it was created with a combination of XML, XSL, JavaScript Ajax, and PL/SQL CON8440 – Managing XML Content with the Latest-Generation Oracle XML DB ===================================================================== This session introduces the latest generation of Oracle XML DB technology. XML standards continue to evolve, and Oracle XML DB continues to provide the industry’s leading implementation of those standards. The latest version of Oracle XML DB provides support for two new exciting XML standards, XQuery-Update and XQuery-Full Text. You will learn how to use XQuery, XQuery-Update, and XQuery Full-Text to develop powerful XML-centric applications. The session also demonstrates how to optimize XQuery Full-Text operations with Oracle’s new XML full-text index. The presentation also introduces Oracle’s new midtier XQuery engine and the XQJ API, which enables Java developers to access the full power of Oracle’s XML technology CON3148 – Integrating XML by Using Oracle SQL Developer 3.1 and Oracle Database 11g Release 2 ===================================================================== Frequently during a project lifecycle, new technology is introduced that presents first-time challenges. This session describes a project using Oracle XML Database (Oracle XML DB) and discusses why Oracle XML DB was chosen, how it was used, and the technical issues encountered. The presentation covers several examples using XMLTYPE, CLOBs, Oracle XML DB methods, XMLAGG, XMLELEMENT, XMLFOREST, and dbms_xmldom. You will learn about methods, design considerations, and issues with Oracle XML DB. You will also take home working examples that you can copy and paste into your Oracle environment. Benefit from examples that use Oracle Database 11g Release 2 and Oracle SQL Developer 3.1. CON8442 – Design Guidelines and Performance Tuning for Storing XML in Oracle Database ===================================================================== This session examines techniques that can be used to optimize the performance of XML processing in Oracle XML DB. It looks at the different storage and indexing options and provides guidelines on when each should be considered. After establishing a framework for deciding how to store XML, the presentation considers the options available for indexing XML to ensure optimal performance of an XML-based application. The session also discusses how standard techniques such as partitioning and using parallel data manipulation language (PDML) can be used to scale XML processing on extremely large volumes of XML content and how Oracle XML DB can leverage the intelligent storage capabilities of Oracle Exadata. DEMOGROUNDS (Moscone South) XML Application Development: Oracle XML DB, Oracle XML Developer Kit ===================================================================== Oracle XML Database provides a high-performance, native XML storage and retrieval technology. It fully absorbs the W3C XML data model into the Oracle Database, and provides new standard access methods for navigating and querying XML. With Oracle XML Database, you get all the advantages of relational database technology plus the advantages of XML. Come and learn how to develop applications that take advantage of Oracle’s XML technology and the Oracle XML DB Repository. Oracle XML Database: Structured, Semistructured, and Unstructured XML ===================================================================== Oracle XML Database provides a high-performance, native XML storage and retrieval technology. It fully absorbs the W3C XML data model into the Oracle Database, and provides new standard access methods for navigating and querying XML. With Oracle XML Database, you get all the advantages of relational database technology plus the advantages of XML. Come and learn how to develop applications that take advantage of Oracle’s XML technology and the Oracle XML DB Repository.
Oracle’s OOW 2012 Content Catalog: https://oracleus.activeevents.com/connect/search.ww?event=openworld (use “XML DB” or “XMLDB” as search tag) Regards Marco
I saw, while fiddling with this site that a small anniversary was in order. Although I started blogging, as an alternative keeping at bay hundreds of SQL and shell scripts, somewhere in 2004 on the technology.amis.nl site, this site came to light around the 1st of April in 2007, 5 plus years ago.
Initially it was just a first time attempt, until, without real notice, Doug mentioned me on his site. From that moment on I had the idea that I couldn’t back down anymore and it become more serious.
The site has had its ups and downs and lately it, apparently, is bugged by the takeover of my old provider (www.speedxs.nl) and network alterations afterwards somewhere in November 2011 under the CBizz umbrella of things. The latter is now definitely shown by its negative response impact since that time via:
Click the picture to enlarge
Although this site is mainly about Oracle XMLDB items, I post also Oracle database, performance and other stuff here, like the occasional rants and fun or music interests… When looking back for example regarding a rant called “Reasons why not to Use Oracle VM“, which was mainly driven by the enormous out of proportion PR at that time, it’s fun to notice that nowadays I am big, big fan of Oracle VM. Of course there is still a lot to improve, but Oracle is making it a whole lot better, just like a huge amount of other (open-source) software.
Also direct hits are not the only thing that make “the count”.
Click the picture to enlarge
More and more people are using their mobile device or other apps to read the content, which is not always properly picked up by standard statistics services, which are more “page view” aware and not RSS feeds.
Click the picture to enlarge
The overall mobile app influence also on this site takes more and more hold, as people are using devices like their iPad more to read articles from people on the internet and probably this is not always via a browser but more often via apps like “Flipboard”
Click the picture to enlarge
Over time, you see interest for “Oracle 11g – XMLType Storage Options” take hold, but it’s beyond me why there is a Google Analytics drop after the 1st of March for this page. Anyway, the site was also once setup to help people with their (same as me) steep learning curve, so it’s good to see that people take advantage of the content here.
Click the picture to enlarge
In all, good to see that people are using the site as well, just like me to look things up from time to time, and is still growing in interest. Five years past start-up, crossed the 1/2 million boundary with 500 views on average per day.