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:52
In 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:18
A 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:56
Want to know the inner secret of being an ADF Ninja. Awesome video! ... [read more]

Case Study: Swedish Rail Operator SJ Increases Revenue and Customer Satisfaction Using CRM

2010-02-08 13:52:54
What 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:41
A 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:24
You'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
SuccessIn2010_E20.jpgBy 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:18
I 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:40
I 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:23
A 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]

Business Intelligence Offers the Promise of Widespread Benefits, Yet Many Challenges Remain

2010-02-08 11:45:32
Ness 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:15
I 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:47
In 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:51
Oracle'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:13
Upcoming 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:06
This 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:28
A 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:29
Oracle 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:25
All 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]

Introducing tpce-like workload for MySQL

2010-02-08 09:30:44
We 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:19

Training on Oracle Database SQL Trace Filed under: ... [read more]

UKOUG - Northern Server Tech Day 2010

2010-02-08 09:04:14
The 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:13
Chris 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:50
When 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]

PL/SQL Best Practices

2010-02-08 08:59:47

PL/SQL Best Practices Filed under: ... [read more]

Common Mistakes in Oracle PL/SQL Programming

2010-02-08 08:50:33

Common Mistakes in Oracle PL/SQL Programming Filed under: ... [read more]

Oracle Trading Community Architecture (TCA)

2010-02-08 08:47:36

Trading 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:00
The 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:59

What 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:00
The 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:00
Mysql로 변환하려 함. % 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:00
Take 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:00
By 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:00
How 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:44
One 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:00
If 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:00
Warning: 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]

Magnus Hagander: Time management by (somebody elses) press-releases

2010-02-08 08:07:00
A 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:48
Just 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]

Tale of a strange quirk in apex session state initialization

2010-02-08 07:57:31
Always 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:00
It 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]
 1 2 3 4 5 6 >>  Last › Total pages: 2775