(7 comments, 168 posts)
Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance.
He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).
Home page: http://blog.gralike.com
Posts by Marco Gralike
A small enhancement, but what a golden nugget! At least that’s what I think.
It is now possible in Oracle 12c to export data via a view. I my realm, Oracle XMLDB, that can be an interesting feature to export stored XML content in a relational format and import it, for example, in a relational table/environment. Let me show you how.
Lets create an XMLTYPE table and insert some XML into it: (more…)
The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a small overview (sneak peek) into this great new tool for, for example, database performance tuning, hereby some pictures to create some appetite. I created some have load on my database, to make it a bit more interesting…Main Menu
The main menu has a section for “Configuration”, “Storage”, “Security” and “Performance” (more…)
Oracle DB Express is the new replacement for Oracle DB Console in the Oracle 12c database. Here are some first steps to get started.
Oracle DB Express makes use of what is called the “XDB Protocol Server”, which among others supports the Oracle APEX standalone PL/SQL Gateway. For people who are unknown still how to set this up, hereby some ideas how to get started with this cool new administrative alternative.
First enable the HTTP functionality of the XDB Protocol Server. You are allowed to do this via the SYS account or have the XDBADMIN role.
- Check if it is enabled via:
Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in the new feature section of the Oracle XMLDB Developers Guide for Oracle 12c:
Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and there is no option not to include it when you create Oracle Database. It is automatically installed when you create a new database or (if not existing already) when you upgrade an existing database to Oracle Database 12c Release 1 (126.96.36.199).
…and a bit further on… (more…)
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:
- Marco Gralike – Creating Structure in Unstructured Data (pdf-3,6MB)
- Gerwin Hendriksen – “Method GAPP” Used to Mine OEM 12c Repository and AWR Data (pdf-7,6MB)
- Frits Hoogland – About Multiblock Reads (pdf-4,3MB)
- Toon Koppelaars – SQL Plan Management (pdf-3,1MB)
- Jacco Landlust – Lessons Learned while Pushing the Limits of SecureFiles (pdf-1,1MB)
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.
AMIS is spending a lot of effort keeping our people up-to-date with the latest knowledge needed to help our customers the best way we can. Traditionally we also always try to share our knowledge with customers and others, via social media or conferences, and while abroad learning from others at the same time. It is not always possible to go to those international events to learn from the best, so that’s why we invite, from time to time, those special people over here in Holland. After being able to organize special sessions with Oracle ACE Directors Doug Burns, Pete Finnegan and others, I am now honored to announce a two day masterclass with Oracle ACE Director James Morle on Thursday 6th and Friday 7th of June 2013.