There has been some big new security items added to 12cR1 such as SHA2 in DBMS_CRYPTO, code based security in PL/SQL, Data Redaction, unified audit or even privilege analysis but also as I hinted in some previous blogs there are….[Read More] Pos…
Category Archives: Uncategorized
It has been a few weeks since my last blog post but don’t worry I am still interested to blog about Oracle 12c database security and indeed have nearly 700 pages of notes in MS Word related to 12c security….[Read More] Posted by Pete On 28/08/13…
We have just updated PFCLScan our companies database security scanner for Oracle databases to version 1.2 and added some new features and some new contents and more. We are working to release another service update also in the next couple….[Read M…
We released version 1.3 of PFCLScan our enterprise database security scanner for Oracle a week ago. I have just posted a blog entry on the PFCLScan product site blog that describes some of the highlights of the over 220 new….[Read More] Posted b…
A recent question on the OTN database forum included an execution plan that prompted one reader to ask: “but where has the existence subquery gone?” Here’s the original question showing the query, and here’s the later response showing the plan that prompted the question. There were three possible reasons why that question may have been […]
Monday I wrote on tnsping.exe inconsistencies. Actually there is one good thing in having Oracle Client on Windows looking in the current directory first : you can set one tnsnames for a specific shortcut ! It is quite a viable alternative to .bat files with set TNS_ADMIN=path. Demo : First I create a small EXE […]
Seasoned Oracle ADF developers will be familiar with the ADF Logging framework, an instrumentation API that you can use to surface what your application is doing behind the scenes, mainly as a debugging aid. The ADF framework itself uses the ADF Logging framework to produce copious logs showing what the framework actually does for you.
Admittedly reading the logs, either your’s or Oracle’s can be a rather tedious process. Let’s admit it, reading text files with 1000 of lines of output isn’t what we signed up for when we joined the exciting world of the IT industry. Arguably reading the logs can also be like drinking from a fire hose too, there’s just too much information to digest.
To make your life a little easier as a developer, Oracle’s JDeveloper includes the Oracle Diagnostic Log Analyzer which is a visual tool included in the IDE designed to allow you to search, filter and read the logs in a structured fashion.
A superb addition to the Oracle Diagnostic Log Analyzer is the ADF Request Analyzer. The ADF Request Analyzer is not just designed to assist you read the logs, but restructures the logs to represent the JSF & ADF lifecycle on each request. In other words it moves from a flat line by line log structure which doesn’t really represent the flow or logic of how each request is processed, to showing you visually in a tree structure the different phases of the lifecycle processing the request.
Interjecting with one of the main benefits I see from a personal perspective, the ADF Request Analyzer takes that dry JSF lifecycle you read about in books but never really understood as it was all theoretical, and now shows you the runtime representation of the lifecycle so you really get to see what gets processed when.
For customers who don’t know about this tool, the ADF product management team has released a new ADF Insider video on the ADF Insider Essentials YouTube channel entitled the Oracle Diagnostic Log Analyzer – ADF Requests and the JSF Lifecycle. To make it a little more realistic than “here’s the tool and you should use it”, the video attempts to show you some real running scenarios, as well as how you would use it in a production environment.
We hope you find this useful. As can be seen Oracle’s ADF Product Management team continue to commit to providing customers comprehensive learning collateral on your ADF endeavours, with the ADF Insider Essentials channel, ADF Architecture TV, ADF Mobile Academy and much more.
Image courtesy of artur84 / FreeDigitalPhotos.net
With the holiday season fast approaching (or is it slow?), data bloggers have already adopted a festive mood, and this Log Buffer edition jubilantly captures and reflects that, and much more. Oracle: On December 4, 2013, Oracle will host a customer webcast to acquaint customers with the Oracle SuperCluster M6-32, Oracle’s most powerful engineered system…
In the previous post about in-memory parallel execution I described in which cases the in-mem PX can kick in for your parallel queries. A few years ago (around Oracle 22.214.171.124 and Exadata X2 release time) I was helping a customer with their migration to Exadata X2. Many of the queries ran way slower on Exadata compared […]
This post applies both to non-Exadata and Exadata systems. Before Oracle 11.2 came out, it was true to say that Oracle Parallel Execution slaves always do direct path reads (bypassing buffer cache) when doing full segment scans. This should not be taken simplistically though. Even when you were doing full table scans, then yes the […]