Top 10 Articles - User's Choice
Latest 50 Articles
Top Speed - Queries per Second
2010-02-08 22:54:00
Today I reached 109k Queries per Second. I was quite impressed by it.
Some background on the situation.
I developed some stored procedures to process some rather large tables we had in our database.... [read more]
Bookmarkable page with parameters
2010-02-08 16:04:52In the old fashioned world of JSP's, this was textbook. Somehow in the ADF world of hierarchical scopes, we might have lost touch with the nuts and bolts. So here's revisiting the basics - ADF style.
I should first mention, Frank Nimphus has an excellent viewlet on ... [read more]
32-bit to 64-bit database migration tips: OLAP upgrade
2010-02-08 15:33:18A while ago, I had the opportunity to migrate an E-Business Suite database (Apps version 12.0.4, database version 10.2.0.4) from 32-bit Linux to 64-bit Linux. It's a straightforward process, outlined in My Oracle Support Note 471566.1: Migrating Oracle E-Business Suite R12 from Linux 32-bit to Lin... [read more]
ADF Coding Ninja
2010-02-08 14:37:56Want to know the inner secret of being an ADF Ninja. Awesome video!
Case Study: Swedish Rail Operator SJ Increases Revenue and Customer Satisfaction Using CRM
2010-02-08 13:52:54What do you do when faced with looming competition due to industry deregulation and an uncertain economy? You focus on the customer...which is exactly what Swedish rail operator SJ did to substantially increase revenue per customer through personalized customer experiences. Like many businesses, SJ realized that a large portion of its revenue came from a small b... [read more]
Random Things: Volume #13
2010-02-08 13:25:41A brief respite for me...I get to work remotely this week.
Admittedly I have gotten into the habit, finally, of traveling, so it's a little strange to be home (never thought I would say that). There is no shortage of respect from me for those who travel all the time. It's a hard life.
OBIEE Performance
Our Usage Tracking reports are a tad slow and I've been looking into the logs trying to decipher them. Unlike the ... [read more]
v-Commerce?
2010-02-08 13:00:24You've heard of e-commerce and m-commerce, but how about v-commerce? A company called Pixazza is trying to make images displayed on the web act like a product catalog where anyone can click on an object within the picture to buy it for themselves. How many times have you seen an image and wanted to know where you could buy the products shown? If Pixazza has its way, the entire web could be a giant billboard for products. ... [read more]
Success in 2010: Realizing the Benefits of Enterprise 2.0
2010-02-08 12:56:37
By now, you're probably well aware of Enterprise 2.0 and can most likely define what it is. But if you are anything like most business users or IT professionals, you may struggle wit... [read more] AJAX based select list in APEX
2010-02-08 12:41:18I looked through the Web for a simple way using a select list with dynamic data exchange inside my APEX application. What I found was just amazing (Thanks to Scott):
ajax-select-list-code-generator for APEX
Select list code generator... [read more]
MySQL/Oracle XE integration: Invalid identifier problem
2010-02-08 12:28:40I linked a MySQL table into an OracleXE database (Short How to) and discovered a really strange behavior. When I tried an usual select about the MySQL table from my sqlplus client an error occurred: ORA-00904: "last_name": Invalid identifier
Here the whole description:... [read more]
Edition name as a property for JDBC thin client
2010-02-08 12:14:23A question on Edition-Based Redefinition appeared on the OTN forum: The purpose is to try to upgrade an app in production. For most application users they will keep using the pre-upgrade app connecting to the old edition by default, while at the same time some UAT users will test out the post-upgraded app on the new [...]... [read more]
Information Builders Helps PGPD Predict When Crime will Occur and Project Crime Trends
2010-02-08 12:00:00]]>... [read more]
Business Intelligence Offers the Promise of Widespread Benefits, Yet Many Challenges Remain
2010-02-08 11:45:32Ness Technologies survey of more than 140 firms reveals industry-wide shortfalls of over 50% in results achieved from BI initiatives.
To read the full press release, click here.
]]>... [read more]
How PostgreSQL protects against partial page writes and data corruption
2010-02-08 11:36:15I explored two interesting topics today while learning more about Postgres. Partial page writes PostgreSQL's partial page write protection is configured by the following setting, which defaults to "on": full_page_writes (boolean) When this parameter is on, the PostgreSQL server writes the entire content of each disk page to WAL during the first modification of ...... [read more]
How to make two distributed web apps talk using foreign JNDI concept.
2010-02-08 11:12:47In the present day scenario, we often tend to use webservice for the client-server interaction in distributed environment.Nevertheless, the foreign jndi concept is often used wherever legacy system is involved.
NB: Wherever server is being talked about, you should assume it as WebLogic server.
A brief outline about JNDI : The Java Naming and Directory Interface (JNDI) is a Java API for a directory that allows Java software clients to di... [read more]
Oracle extends BTM and SOA Mgt through Amberpoint acquisition
2010-02-08 11:06:51Oracle's acquisition of Amberpoint extends it's capabilities around Business Transaction Monitoring (BTM), SOA Management and SOA Governance into it's SOA products offering.
Read the following resources for more info
Benefits of the combination from Richard Sarwal, Sr VP, Product Deve... [read more]
Webcast: Data Collections and ATP
2010-02-08 11:04:13Upcoming Webcast
Title: Data Collections and ATP
Date: February 10, 2010
Time: 11:00 am EST, 8:00 am PST, 16:00 GMT
Product Family: Value Chain Planning
... [read more]
YouTube: Security & Compliance with Oracle Database 11g
2010-02-08 10:59:06This short YouTube video outlines how Oracle Database 11g can help customers address their Data Privacy, Insider Threats and Regulatory Compliance challenges - without having to make costly, time-consuming changes to their business applications. ... [read more]
Oracle Database Support Stages
2010-02-08 10:44:28A common question that comes up at customer visits and Oracle Database 11g events is "what are the various stages of Oracle's Lifetime Support"? And a related question is always "what type of support/fixes come with each support stage"? The answer to both these questions can be found on Oracle's Lifetime Support Policy published here on oracle.com/support. It's also wort... [read more]
Oracle to Acquire AmberPoint
2010-02-08 10:23:29Oracle announced this morning that it is acquiring AmberPoint, the leading vendor of SOA management solution. Amberpoint is widely recognized as the Cadillac in the SOA management space, especially with its ability to enforce policies that help improve application performance and security, and to diagnose transactions not only within a composite application, but also across different applications. There had been speculations for a long time whether AmberPoint wanted to stay indepe... [read more]
Premier Support for Oracle Application Server 10g ends December 2010
2010-02-08 10:21:25All E-Business Suite systems administrators should review the Oracle Lifetime Support brochures on the Oracle Lifetime Support website regularly. In particular, EBS sysadmins should monitor changes to the following documents:
Lifetime Support Policy: Oracle Technology Pro... [read more]
The Java Comercial that Didn't Made it to the Super Bowl
2010-02-08 09:36:18Check it out here.
Introducing tpce-like workload for MySQL
2010-02-08 09:30:44We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that's just single workload. That's why we are looking into different benchmarks, and one
of them is TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration. You can download it from our Lauchpad Percona-tools project, it's
bzr branch lp:~percona-dev/perconatools/tpcemysql Important ... [read more]
Training on Oracle Database SQL Trace
2010-02-08 09:05:19Training on Oracle Database SQL Trace Filed under: ... [read more]
UKOUG - Northern Server Tech Day 2010
2010-02-08 09:04:14The UKOUG is once again running the Northern Server Technology Day.This is the 5th year we have run the event and this year it is taking place on 29th April at the Hilton Hotel, Leeds.This annual event is aimed at DBA’s and Developers in the North of England and delivers a full day of server tech presentations.If anybody is interested in presenting at this event then please contact either myself ... [read more]
links for 2010-02-08
2010-02-08 09:01:13Chris Tomkins: Domain Value Maps in Oracle Service Bus Chris Tomkins shares some options for handling domain value mapping in Oracle Service Bus. (tags: oracle ... [read more]
Why Sustainabilty Reporting Matters
2010-02-08 09:00:50When I attended college pursuing my major in Accounting, I remember my finance professor saying that a corporation's sole responsibility is to increase shareholders' wealth. That was many moons ago; the world today is very different. We have definitely become a more environmentally and socially aware culture. Driving hybrids is considered cool, paper-less billing is common place, recycling is en vogue, and many companies are offering carbon offset credit... [read more]
MEGA Introduces IT Planning Capabilities to Enterprise Architecture Solution
2010-02-08 09:00:00]]>... [read more]
Common Mistakes in Oracle PL/SQL Programming
2010-02-08 08:50:33Common Mistakes in Oracle PL/SQL Programming Filed under: ... [read more]
Oracle Trading Community Architecture (TCA)
2010-02-08 08:47:36Trading Community Trading Community is defined as a group of entities taking part in commerce. Trading Community includes both persons and organizations. Entities in Trading Community may play roles other than Seller and Buyer such as Partner, Contact, Dealer, Distributor, Agent, Influencer, etc Filed under: Oracle Functional <... [read more]
WEBii.net News & Tips » Why so static? The difference between ...
2010-02-08 08:40:00The Wordpress software uses a combination of PHP code and a mySQL database in order to dynamically generate web pages. PHP is a server-side scripting language, which means that all the processing is done on the web server, as opposed to ...... [read more]
11i – Oracle E-Business Suite Custom Library – Oracle forms
2010-02-08 08:39:59What is Custom Library? Allows extensions and enforce business rules to Oracle Application without modifying the standard code. This is done using the Oracle development tool Oracle Forms 6i . Filed under: Oracle Functional ... [read more]
Concatenate rows with a PostgreSQL aggregate function « SQL Brain
2010-02-08 08:35:00The Smoosh FUNCTION concatenates two input strings, with a supplied delimiter in the middle; The Smoosh AGGREGATE just tells PostgreSQL to call the Smoosh FUNCTION for each row, and that it's of type text. Neat, eh? ...... [read more]
JOSSO : Opensource Web SSO 설치 및 설정 - 네이버 블로그 :: 포스트 ...
2010-02-08 08:30:00Mysql로 변환하려 함. % VARCHAR2 타입은 오라클에만 있음. Mysql에서는 VARCHAR로 변환 % Mysql에서 foreign key를 지원하려면, 반드시 ENGINE=INNODB 이라고 지정해줘야 한다. 디폴트 디비 타Ǿ... [read more]
Some Abstract Type!: Don't forget the COMMIT in MySQL
2010-02-08 08:29:00Take the Python Database Interfaces for MySQL. PEP-249 says that, by default, auto-commit should be turned off. You could turn it back on, but it's good practice to be explicit and commit in your code. Remember the Zen of Python! ...... [read more]
ID Flow - Photo ID Card Software software review | Free software ...
2010-02-08 08:25:00By including a standalone networkable database feature as well as one-click connectivity to a vast range of other databases such as Microsoft Access, Microsoft Excel, MySQL, FoxPro, and Dbase, ID Flow Photo ID Card Software makes ...... [read more]
Alan 42 Multi Modifikation How To Count & Sort Multiple Columns In ...
2010-02-08 08:23:00How to count & sort multiple columns in 1 MySQL table? - alan 42 multi modifikation. And so on. Hi, can count only one column in my table but I have the columns 14 below and the same for each record in my database and classified on the ...... [read more]
Copyrights and wrongs
2010-02-08 08:16:44One of the issues I have with the Free Software approach is that advocates have habit of throwing the baby out with the bathwater when discussing issues that they see as in any way negative to free software. I was reminded of this while reading Bradley M. Kuhn’s criticism of Mark Shuttleworth’s ... [read more]
How To Build A Website For Users To Register? What Kind Of Hosting ...
2010-02-08 08:13:00If you want to make a log in system you will need some sort of a data base(MySQL works yes) and then you'll also need a way to have your server communicate with the clients and process their data(that would be PHP). ...... [read more]
MySQL Fatal Error
2010-02-08 08:13:00Warning: mysql_query(): Unable to save result set in /home/updown/public_html/engine/classes/mysql.class.php on line 74. MySQL Fatal Error ...... [read more]
Selena Deckelmann: Unlocking the clubhouse: cultural resistance and learning communities
2010-02-08 08:07:10
I finished reading “... [read more] Magnus Hagander: Time management by (somebody elses) press-releases
2010-02-08 08:07:00A while back I submitted a couple of talks for PG-East 2010 in Philly, and over the past couple of weeks I've been nagging the organizers semi-frequently to get some pre-info on whether I've been accepted or not, since flight prices started to climb fairly rapidly. The site clearly says information that the information will be av... [read more]
ADF Code Corner on Twitter !
2010-02-08 08:03:48Just in case … you are worried about missing bits of information about Oracle JDeveloper and ADF you feel uncomfortable saying “If I had known this before it would have saved me …” you don’t have time to frequently browse OTN you enjoy technical stuff more than knowing what Paris Hilton did last week you want to know more than o... [read more]
SwiftKnowledge Gives Customers Powerful, Web-Based, Ad-Hoc BI Capabilities
2010-02-08 08:00:00]]>... [read more]
Tale of a strange quirk in apex session state initialization
2010-02-08 07:57:31Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.Today was a good day because i finally managed to allocate some time and get to the bottom of an old standing issue that I've been encountering at intermittent times during the last five or six years spent developing applications with Apex:how come that sometimes page item initialization ... [read more]
Tracker | Shaolinkungfushoes07.dnsalias.org
2010-02-08 07:57:00It is written in the PHP scripting language and works with MySQL, MS SQL, and PostgreSQL databases and a webserver. Follow Santa as he makes his magical journey! Possibly Related Posts: ...... [read more]
Subscribe to relationalnews.com