Turning on auditing on a physical standby database may be preferred when you want to audit the queries against the read only standby database. Obviously it's not possible to keep audit records on standby database by setting audit_trail to DB or DB_EXTENDED. Because the database is read-only and the aud$ table is just being synchronized with the primary aud$. So the DB or DB_EXTENDED setting on a physical standby database doesn't cause any auditing. When we open an 11g physical standby database in Read Only mode, the AUDIT_TRAIL parameter changes to OS automatically. What you'll see on the alert log will be:

AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access

Setting the audit_trail to OS works for a standby database but there's no option as OS_EXTENDED, so if you need sql_text and sql_bind info, this will not be the solution for you. The only solution that records sql_text and sql_bind will be XML_EXTENDED. This setting will produce xml files under audit_file_dest. 

The problem in this point will be querying the audit records. Here comes the view V$XML_AUDIT_TRAIL which reads the XML files on the fly into memory when queried. Database used to maintain a txt file (adx_.txt) which keeps track of the XML audit files for this reason. However, starting with the list of the xml audit files is dynamically obtained when V$XML_AUDIT_TRAIL is queried. 

In the MOS note 879305.1 (ORA-00600[kzaxgfl:lowmem] when ADX file has dangling entries) this change was stated as:

Starting with release, the usage of the ADX file has been removed. The ADX global, generic file is no longer maintained in the adump destination. Consequently, starting with this release, the manual maintenance of the ADX file is no longer needed. 
More precisely: From, the xml index file is dynamically created before creating the xml file list.
This file is specific to the process as opposed to generic index file present is older versions and will have the PID suffix with the index filename.
Once the operation is done, this file is deleted.
This file should never be manually managed - removing or changing the process specific file manually can result in the error investigated in this note or in ORA 600 [KZAXGFL:IDX]
Note 1392161.1 Queries on XML Audit Trail Views Crashes With: ORA 600 [KZAXGFL:IDX] 

Obviously it was not a brilliant idea to keep xml file list in a text file which cannot track the changes when you delete xml files from filesystem in time, thus cause ORA-600 errors. Hereby this behaviour is changed with

Anyway, to get to the main point, we can query V$XML_AUDIT_TRAIL on the standby to find out the audit records. In my case, i prepared a shell script running on the primary which connects to primary database, queries the standby V$XML_AUDIT_TRAIL via db link and insert into a table on primary, then deletes the xml files on the standby server. With this way it's possible to filter the audit data on the xml files when inserting into database. It's also possible to create need-based indexes which will speed up your audit queries or partition the table for administrative purposes.

63 Responses so far.

  1. Unknown says:

    This blog having the details of Processes running. The way of runing is explained
    clearly. The content quality is really great. The full document is entirely
    amazing. Thank you very much for this blog.
    Web Designing Training in Chennai

  2. kalai says:

    Great tips, and awesome way to get exert tips from everyone – you are the master of content.

    Best Dot Net Training Institutes in Chennai

  3. Unknown says:

    Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.

    Salesforce Training in Chennai

  4. Jeffy says:

    Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..!!
    seo company in india
    Digital Marketing Company in india

  5. Aasha says:

    This blog having the details of Processes running. The way of runing is explained clearly. The content quality is really great. The full document is entirely amazing. Thank you very much for this blog.

  6. Very much useful article. Kindly keep blogging

    JavaScript Training Courses

  7. You’re doing great work. In this blog we can get useful information. Thanks for posting this blog....................Please Click Here to Get best Oracle Institute Details.

  8. sushma says:

    Hey Really Thanks for sharing the best information regarding category,hope you will write more great blogs.
    Oracle Fusion Financial Online Training

  9. harsha says:

    Really thanks for sharing such a wonderful blog.
    Oracle Fusion Taleo Online Training

  10. leela says:

    Really very helpful article, Thank you for sharing interesting blogs.

    Oracle Fusion Technical Online Training

  11. Very interesting blog Really excellent information and thank you for giving your valuable information Oracle Fusion SCM Online Training

  12. Awesome post. your article is really informative and helpful for me and other bloggers too Oracle Fusion HCM Online Training

  13. Anonymous says:

    Nice blog..! I really loved reading through this article. Thanks for sharing such an amazing post with us and keep blogging... Well written article - Thank You for Sharing with Us pmp training in velachery | project management certfication in chennai | project management training institute in chennai

  14. harry says:

    read this above post its very greatful for me thanks sharing this post ,great post.

    visit our web

  15. Blazer says:

    These ways are very simple and very much useful, as a beginner level these helped me a lot thanks fore sharing these kinds of useful and knowledgeable information. outdoor game

  16. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Big Data Hadoop Course | Big Data Hadoop Certification Training
    Big Data and Hadoop Online Training | Big Data Hadoop Training

  17. Great article and lovely post. I would like to congratulate you on your post and I want to tell you that I am also here to promote or we can say for digital marketing.

    Troubleshoot QuickBooks Error Code C=387
    QuickBooks Error Code C=343
    QuickBooks Error Code 12517

  18. Excellently written article, if only all bloggers offered the same level of content as you, the internet would be a much better place. Really great post, Thank you for sharing this knowledge.

    Troubleshoot QuickBooks error 1723
    Troubleshoot QuickBooks Error 41
    Merge the QuickBooks Company file

  19. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information.

    QuickBooks Supported With Window 10 | QuickBooks Error H101, H202, H303 and H505 | QuickBooks Has Stopped Working Error

  20. Thanks for sharing blog
    How to overcome error c=387
    QuickBooks offers a huge set of services like payroll services, managing reports and records. Such magnificent features help businesses in their accounting and finance works. For such software which is used on such a large scale by thousands of organizations, it sometimes becomes very hard for QuickBooks to maintain its server all the time. QuickBooks releases its update regularly so that all its users get the best experience. But, it may experience few errors like Error code C=387. This error may be because of a corrupted registry entry, it may also arise due to template issues of invoices

  21. Nice & Informative Blog !
    A prestigious accounting software, QuickBooks, has been designed to make the -flow of accounting painless and hassle-free. However, this software is also prone to technical issues like QuickBooks Error 12152 dial 1-855-977-7463.

  22. Appreciating the hard work you put into your website and in depth information you present...

    How to Fix QuickBooks Error Code C=343
    QuickBooks Desktop Error C=387
    QuickBooks Error C=272

  23. sri says:

    ring this informative content.,
    Leanpitch provides online training in Scrum Master Certification during this lockdown period everyone can use it wisely.
    Join Leanpitch 2 Days CSM Certification Workshop in different cities.

    Scrum master certification online

    CSM certification online

  24. sri says:

    Thanks for sharing this informative content.,
    Leanpitch provides online training in Scrum Master Certification during this lockdown period everyone can use it wisely.
    Join Leanpitch 2 Days CSM Certification Workshop in different cities.
    CSM online training

    CSM training online

  25. Greetings to all men, the name is Laxmi Sharma and I am a 19-year-old independent call girl and high profile college girl too. I would love to seduce in a very sensual way and consider it my pleasure.
    Call girl
    Call girl number
    Call girl WhatsApp
    Call girls
    Call girls for party
    Call girls number
    Call girls WhatsApp
    Erotic massage
    Escort service
    Female call girls service
    Hotel call girls
    Incall girls
    Outcall girls
    personal service
    Call girl
    Call girl number

  26. Ian Bell says:

    On the basis of Geography, the Global Compact Cars Market is classified into North America, Europe, Asia Pacific, and the Rest of the world. The Compact Cars Market, mainly driven by a developing electric Compact Cars Market in the regions, is predicted to play a major role in the years to come in Western Europe, Asia Pacific, as well as North America. As a result of the demand for compact automobiles, the APAC is forecast to achieve significant growth, driven by high demand from India and China. Over the predicted period, MEA, Latin America, and Eastern Europe are expected to increase immensely.

  27. Awesome Blog !!get easy yet feasible solutions at quickbooks phone number for quickBooks Error occurs due to internal issues inside the software

  28. Quickbooks Balance sheet is out of balance is the issue that occurs when your accounts and liabilities and expenses don't match. The following article is designed in such a way that users can easily eradicate QuickBooks balance sheet out of balance, and Moreover you can contact QuickBooks error support team via 800-579-9430.

  29. QuickBooks error ol 301 is a banking connection error which raised due to the various reason either the bank server not allowed to connect with QuickBooks or QuickBooks has an issue connecting with the bank. So if you are wondering how to resolve Error Ol 301 in QuickBooks, So read the following article and moreover, you have the option to dial our data service team number 800-579-9430.

  30. Is your showing <a href="https://qbdataservicesupport.com/blog/quickbooks-error/balance-sheet-out-of-balance-in-quickbooks-now-what/QuickBooks balance sheet out of balance</a> error and clueless How to troubleshoot it? If you are looking for a precise solution, then I would suggest you follow the given article link where our experts have added feasible solutions and Further you can also connect with data service experts via 800-579-9430.

  31. Is your showing QuickBooks balance sheet out of balance error and clueless How to troubleshoot it? If you are looking for a precise solution, then I would suggest you follow the given article link where our experts have added feasible solutions and Further you can also connect with data service experts via 800-579-9430.

  32. QuickBooks won't open on startup is the issue that can lead due to various reasons, and Damaged QBWUser.ini is one of the most common reasons. Hence we have shared some technical guides on How to resolve QuickBooks Desktop not opening. Moreover, You can connect with the QuickBooks Data service professionals via 800-579-9430.

  33. Very rarely do QuickBooks users go for the data conversion service, and As it is a concern of data, you must hire someone skilled in QuickBooks data conversion service. To know further about our service then either visit the website or contact our experts via 800-579-9430.

  34. qbcfmonitorservice keeps stopping and showing an Error message QBCFMonitorService Not Running On This Computer, and You cannot open any company file. The Firewall program or antivirus is blocking your QBCFMonitorservice file from running to resolve the Error we ask you to follow the given article. Further, you can also contact us via 800-579-9430.

  35. QuickBooks Running slow is the issue that occurs due to the lack of resources from the system end of the damaged company file. In The Following article, we have shared tips and tricks on How to resolve QuickBooks running very slow. For more details, you can also Dial our Toll-Free helpline number 800-579-9430.

  36. Error 6XXX is very common But among them QuickBooks Error 6000 77 is most common error which you can encounter or face while working on QuickBooks Desktop and Next Moment. QuickBooks shows Error 6000 77 and If you are Looking for helpline hand in order to fix it, Then Follow the guide and Fix Error 6000 77 with ease. Apart from troubleshooting you can call us via 800-579-9430.

  37. My QuickBooks is Running Verry Slow, and still, everything seems correct? If So, then there are certain settings that might be incorrect and causing QuickBooks Running slow problem. Thus, we have shared an article where we have added steps to resolve QuickBooks crashing or running slow problems with ease. Moreover, you can have Dial our Helpline number 800-579-9430.

  38. QuickBooks Running slow issue very rarely occurs in QuickBooks and The reason for the error Running slow is You are using a Computer which is not meeting the minimum system requirement to run QuickBooks. The following article where we have shown a proper guide on How to start troubleshooting My QuickBooks Running slow and Moreover you can contact 800-579-9430.

  39. QuickBooks was unable to back up the company file error you may encounter while creating a new backup file from your company file. And If you are looking for the guide that will assist you in fixing the QuickBooks backup failed issue and For further query and doubts you can contact the QB data service team at 800-579-9430.

  40. QuickBooks Payroll Error PS038 users may face when sending the paychecks or using the direct deposit. The most apparent reason behind the QuickBooks Error PS038 is online stuck paychecks, which do not allow you to use further QuickBooks. So follow the article to understand troubleshooting of Error PS038 and Moreover you can also reach out to experts via 800-579-9430.

  41. QuickBooks Payroll Error 40001 user may face while setting up payroll or sending the paychecks, and This occurs due to the damaged in the QuickBooks files or you haven't updated your QuickBooks for the past couple of months. In the following blog Post, we have incorporated some of the most useful ways to resolve QuickBooks Error 40001, and You can also connect with experts via 800-579-9430.

  42. QuickBooks has stopped working / not responding when opening the company file or switching into multi-user mode can occur in QuickBooks Desktop. The reason for the error not responding can be either the QuickBooks file is damaged or QuickBooks is installed on very low-end pc. The following article is meant to assist user in order to resolve QuickBooks Error has stopped working and Moreover you can contact us via 800-579-9430.

  43. QBDBMgrn not running on this computer error user may face when QuickBooks database server manager QBDBMgrn.exe service stopped working. This article is designed to help QuickBooks users to mend QBDBMgrn not running problem with ease and you can also connect with experts at 800-579-9430.

  44. Hey! Mind-blowing blog. Keep writing such beautiful blogs. In case you are struggling with issues on QuickBooks Error 7149, dial QuickBooks Customer Support Phone Number at +1(855)-738-0359 . The team, on the other end, will assist you with the best technical services.

  45. QuickBooks error 6190 is one most common error that occurs when the network descriptor file is damaged or TLG is not syncing with the Company file. If you are tired of troubleshooting Error 6190 in QuickBooks but have not succeeded well then I would suggest you contact the data service team at 800-579-9430 then will help you to assist in fixing it.

  46. QuickBooks Error 1603: Sorry we can't let you to install due to the damage in the windows installer and If you have already tried to fix Error code 1603 But got no success. Therefore we have shared an Article which is packed with solutions that will gonna resolve Error 1603 in your QuickBooks with ease and Moreover you can connect with experts at 800-579-9430.

  47. Thanks for sharing this., logo design

  48. logo design that is really an great web

  49. I am not sure where you’re getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for great info I was looking for this information for my mission.

  50. John says:

    Amazing Content!!!!

  51. This Company File needs to be updated QuickBooks 2023 issue mainly arise, If you're are trying to use older version of company file into new system, Thus we have shared a full guide on how to fix it, However you can also avail the Data services QuickBooks for QuickBooks Missing PDF Component.

  52. Resolving the QuickBooks rebuild error 213 can be an easy task if you know what is causing it and what is the best solution in that case. You will notice this problem when you start to run the QuickBooks verify data utility. This is one of those features that helps you in resolving and detection of any kind of data discrepancy in the software.

    If You See This issue Then You Can Solve It :-
    QuickBooks Payroll Error PS060
    quickbooks error Code 350

  53. This is referred to as QuickBooks Company File Monitoring Service, executed from the qbcfmonitorservice.exe file. Usually, you can find the file related to the service inside the “C:\Program Files\Common File\Intuit\QuickBooks” folder Subsequent article is incorporated with some of the most effective techniques to resolve qbcfmonitorservice not running On This Computer, Still we recommend you to contact QuickBooks Support Team at +1-855-738-0359 while applying the below mention solutions”

  54. QuickBooks 6129 : when the verification of the database connection fails or QB tries to access company files, We shall take you through the details of quickbooks error code 6129 and how it can be fixed with a few simple steps. For immediate and help and assistance resolving the same, Find in-depth details and a step-by-step guide in our blog to resolve the issue at +1-855-738-0359

  55. Alok says:

    "Thank you for sharing this informative and insightful post. I found it [interesting/relevant/helpful] and appreciate the effort put into creating it. Keep up the great work!"

    hotel management colleges in Nainital

  56. Excellent post. Thanks for sharing such great and helpful info with us.Keep it up. I appreciate this informative post.Want to know about QuickBooks Visit here.
    How to Download and Fix Errors from QuickBooks Tool Hub

  57. QuickBooks also has many different functions like electronic funds and time tracking options for employees. It has always proved to be useful for its users. Sometimes, QuickBooks face errors due to some technical issues. In this article, we will discuss how to import the charts of accounts in QuickBooks desktop. Import your Charts of Accounts into QuickBooks

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -