“505” – Synchronized Key usage not allowed for the AUA.
Apex logs password#
auth/invalid-session-cookie-duration Just make sure you setup your Named Credential using OAuth Authentication to start with rather than password authentication.
Apex logs how to#
Martin shows us how to get started with archiving this data. Start reading related documentation here. So thank you, Oracle APEX team, for continuing to baking such a resourceful feature into the product. With this I can do things like measure how often a page 3 is opened from page 1 vs page 2. Proof that people are in fact using your application.įrom 5.x it also logs the Request value, allowing more granularity than ever before. Proof that the application 'isn't running slow', well, the database is certainly ok. Proof that a user has ( or hasn't) opened a particular page. Now APEX gives me this information out-of-the-box, and also tells me how long it spent working on each result. Using this information, we could communicate with the business about how often how many people really are using those 'super important' Forms. We had a pre-form trigger that would log who opened which Form when. It all reminds me of the first time I remember implementing such a practice in Oracle Forms. OracleJET Plots Pretty Popular Page PerformanceĪnother favourite of mine plots performance over time, allowing me to target specific pages. This starts by day - guess where the weekend is? I've taken this information to produce a range of drillable reports, starting with a beautiful OracleJET chart.
A higher average that maintains a low median can indicate outliers, while a raised median really should be looked at.įundamentally, we're asking - should I choose to tune a 3 second page that runs once a day, or tune a 1 second page that runs thousands of times a day? Here I've also highlighted the Median column, since that too can be an indicator. This report multiplies how many times certain pages were loaded by how long it took to load, so ordering gives weight to those pages consuming overall time. I think the first report worth noting is By Weighted Page Performance.
Oracle provides some out of the box under Administration -> Monitor Activity. We can combine this information to produce a wealth of information. How APEX Builder dashboard knows who's been the busiest developer It's enabled in your Oracle APEX applications by default, and inserts a record in a log table every time APEX renders a page, or a dynamic action interacting with the database thanks to a PL/SQL or Refresh action.Įvery time a user opens a page, you know when, who, what, why, and how long it took to generate. This year I'd like to lay down my love for a supply of data every APEX developer has access to: apex_workspace_activity_log. Last year I missed the boat - too busy preparing for some holidays. The first year I talked about Dynamic Actions. Everything gets a special day these days, and thanks to Tim Hall's encouragement, you can enjoy a vibrant display of appreciation for what the Oracle Developer Community embraces about the technology they use daily.