Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
There are 52 visitors online    
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Pete Finnigan's Oracle security weblog


Home » Archives » February 2005 » Another undocumented parameter in use (_ash_enable)

[Previous entry: "A password repository for Oracle"] [Next entry: "port 1521 and redirection"]

Another undocumented parameter in use (_ash_enable)

February 6th, 2005 by Pete


I saw a good post on the oracle-l list last week some time by Paul Drake that was titled "ASH droppings in bdump - 10.1.0.3 / win32". Paul asked about the fact his Windows server running Oracle 10.1.0.3 was generating hundreds of small trace files due to Active Session History (ASH). He said he is not using ASH and wanted to know how to turn off the trace file generation. The first response suggested that the old Oracle trace facility controlled by the parameter epc_disabled had gone and a new trace facility was now supplanted by a new trace controlled by a parameter called trace_enabled that if set to false will prevent trace file generation. John also supplied an interesting post to the thread that suggested using the hidden parameter _ash_enable to turn off Active Session History. John gave a useful piece of SQL that lists hidden parameters starting with _ash. Of course you should not usually use hidden parameters in production databases. But as usual I am interested in this post because of the undocumented element. Any use or confirmation of what an undocumented parameter does is always useful information in the security world. If during an audit you come across undocumented parameters being used its good to know potentially why.

Niall made a final post to the thread with an interesting answer that the only way to avoid the licensing issues in this case in a supported fashion is to set STATISTICS_LEVEL=BASIC as TYPICAL will enabled all the extra cost options.

Interesting thread!

February 2005
SMTWTFS
  12345
6789101112
13141516171819
20212223242526
2728     

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

Weblog Home
Weblog Archives


Home
Oracle Security Tools page
Oracle security papers
Oracle Security alerts

Web Development
SQL Server Security

RSS 1.0 FEED
RSS 2.0 FEED
Atom 0.3 FEED
Powered by gm-rss 2.0.0


Valid XHTML 1.0!