Blowing the dust off the ol' blog to note that I'll be at Oracle's OpenWorld/JavaOne/Develop extravaganza in San Francisco next week. Two things I am scheduled...
Blowing the dust off the ol' blog to note that I'll be at Oracle's OpenWorld/JavaOne/Develop extravaganza in San Francisco next week. Two things I am scheduled to be doing:A webcast with OTN's Rick Ramsey at 10:30 AM (Pacific) on TuesdayA session at the "Unconference" at Hotel Parc 55 at 3 PM on TuesdayBoth of these sessions are on Solaris 11 deployment. Webcast will probably be pretty high-level, hopefully a bunch of Q&A. At the unconference session I'm planning to dive...
Blowing the dust off the ol' blog to note that I'll be at Oracle's OpenWorld/JavaOne/Develop extravaganza in San Francisco next week. Two things I am scheduled to be doing:A webcast with OTN's Rick...
Phoronix published a sensationalist article last week claiming that my regular e-mail updates of our biweekly builds somehow signified some out of the ordinary...
Phoronix published a sensationalist article last week claiming that my regular e-mail updates of our biweekly builds somehow signified some out of the ordinary newsworthy event, without bothering to do even the most basic of fact checking. While I pointed this out in their forums within hours of publication, I'm still seeing it cited by other web magazines that don't bother to fact check, as well as in various e-mails and blogs, so am publishing a more complete explanation...
Phoronix published a sensationalist article last week claiming that my regular e-mail updates of our biweekly builds somehow signified some out of the ordinary newsworthy event, without bothering to...
I was asked how to obtain the arguments to a program other than your own without executing the command pargs. The answer is procfs. psinfo has a...
I was asked how to obtain the arguments to a program other than your own without executing the command pargs. The answer is procfs. psinfo has a field,pr_psargs, containing the first 80 characters of the command line arguments. But some programs, especially java programs, have more than 80 characters. It so happens that psinfo contains pr_argv which contains the address of a vector of pointers to the character string for each argument. This address is in the address space of...
I was asked how to obtain the arguments to a program other than your own without executing the command pargs. The answer is procfs. psinfo has a field,pr_psargs, containing the first 80 characters...
The Sun Storage F5100 Flash Array and Sun Flash Accelerator F20 PCIe Card help accelerate I/O bound applications such as databases. The following are some of...
The Sun Storage F5100 Flash Array and Sun Flash Accelerator F20 PCIe Card help accelerate I/O bound applications such as databases. The following are some of the guidelines to identify Oracle database objects that can benefit by using the flash storage. Even though the title explicitly states "Oracle", some of these guidelines are applicable to other databases and non-database products. Exercise discretion, evaluate and experiment before implementing these recommendations as...
The Sun Storage F5100 Flash Array and Sun Flash Accelerator F20 PCIe Card help accelerate I/O bound applications such as databases. The following are some of the guidelines to identify Oracle database...
Few clarifications before we start.Difference between 240K and 500K EE PeopleSoft NA Payroll benchmarksNot too long ago Sun published PeopleSoft NA Payroll 240K...
Few clarifications before we start.Difference between 240K and 500K EE PeopleSoft NA Payroll benchmarksNot too long ago Sun published PeopleSoft NA Payroll 240K EE benchmark results with 16 job streams and 8 job streams. First of all, I want to make sure everyone understands the fact that PeopleSoft NA Payroll 240K and 500K EE benchmarks are two completely different benchmarks. The 240K database model represents a large sized organization where as 500K database model...
Few clarifications before we start.Difference between 240K and 500K EE PeopleSoft NA Payroll benchmarksNot too long ago Sun published PeopleSoft NA Payroll 240K EE benchmark results with 16 job...
It is well known that the entire shared pool can be flushed with a simple ALTER SYSTEM statement.SQL> ALTER SYSTEM FLUSH SHARED_POOL;System altered.What if the...
It is well known that the entire shared pool can be flushed with a simple ALTER SYSTEM statement.SQL> ALTER SYSTEM FLUSH SHARED_POOL;System altered.What if the execution plan of a single SQL statement has to be invalidated or flushed out of the shared pool so the subsequent query execution forces a hard parse on that SQL statement. Oracle 11g introduced a new procedure called PURGE in the DBMS_SHARED_POOL package to flush a specific object such as a cursor, package, sequence,...
It is well known that the entire shared pool can be flushed with a simple ALTER SYSTEM statement.SQL> ALTER SYSTEM FLUSH SHARED_POOL;System altered.What if the execution plan of a single SQL statement...
.. unless you are working with a database that is largely read-only or if the new index is supposed to be fixing a critical performance issue with no side...
.. unless you are working with a database that is largely read-only or if the new index is supposed to be fixing a critical performance issue with no side effect(s).Two topics covered in this blog entry with plenty of simple examples: Why creating new indexes on a heavily modified table may not be a good idea? and How to identify unused indexes?Read on.Indexes are double-edged swords that may improve the performance of targeted queries, but in some cases they may accidentally...
.. unless you are working with a database that is largely read-only or if the new index is supposed to be fixing a critical performance issue with no side effect(s).Two topics covered in this blog...
Our overhaul of Solaris installation in the Caiman project is a large undertaking with many facets. As we've just published a design draft on derived...
Our overhaul of Solaris installation in the Caiman project is a large undertaking with many facets. As we've just published a design draft on derived manifests, this seems to be a good opportunity to discuss scripting in the Automated Installer (AI). Before proceeding further, I recommend reviewing Stephen's old post on scripting in the packaging system, pkg(5): a no scripting zone.When Jumpstart was designed back in the early 90's, its philosophy was largely an extension...
Our overhaul of Solaris installation in the Caiman project is a large undertaking with many facets. As we've just published a design draft on derived manifests, this seems to be a good opportunity to...
Jay came into my office last week complaining his mouse was grabbed by a client and wouldn't let him click in any windows, but he couldn't tell which one. He...
Jay came into my office last week complaining his mouse was grabbed by a client and wouldn't let him click in any windows, but he couldn't tell which one. He remembered I said I had a script to find this out, but hadn't told him where it was. So I logged into his workstation, su'ed to root and ran a couple commands: root@overthere:~# ps -ef | grep Xorg jacotton 881 880 0 Apr 08 vt/2 274:24 /usr/bin/Xorg :0 -nolisten tcp -br -auth /var/run/gdm/auth-for-gdm-O_aWTb/datab...
Jay came into my office last week complaining his mouse was grabbed by a client and wouldn't let him click in any windows, but he couldn't tell which one. He remembered I said I had a script to find...
