Blog Aggregator - Amardeep Sidhu

After yesterday’s presentation, I’m really happy the one today (Listening In: Passive Capture and Analysis of Oracle Network Traffic).  It seems everyone got a lot out of it and that there’s definitely some meat in this subject in both the protocol-level-detail and in recognizing, diagnosing, and repairing network-related issues.
For those of you who gave me your […]

Jeff Rothschild of Facebook’s “A Match Made in Heaven? The Social Graph and the Database”
Taking a look at the social graph and what it means for the database.
The social graph:
At it’s heart it’s about people and their connections.
Learning about people who are in your world.
Can be a powerful tool for accelerating the use of an […]

Identity 2.0: A world that’s simple, safe and secure.
Who is the Dick on My Site? by Dick Hardt (Sxip Identity Corporation)
Quotes:
“Really, data is about people. It’s really identity data.”
“Identity helps you predict behavior.”
“Identity is who you are.”
“Identity is also what you like.”
“Identity enables you to uniquely identify somebody.”
“There are things that other […]

It is quite common for Oracle Tech support, while troubleshooting any 11i E-Business Suite Self Service Applications (SSWA) related error messages, to ask to enable debug logging in JServ configuration files.
The procedure to enable debug logging in JServ is to update following line in file $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties from log=false to log=true, and then bounce Apache […]

Yesterday’s keynote panel on “Scaling MySQL — Up or Out?”
Directly download the 310MB wmv file (not if you are on the conference wireless please!), or watch it in your browser via streaming — simply click the “play” link on this page.
Keith Murphy managed to take painstaking notes with all the facts and figures. […]

I’ve just posted an article on SecureFiles in Oracle 11g. It looks like Oracle have done a pretty good job of improving LOBs in 11g. Depending on the LOB contents, and provided you can cope with the processing overhead, you can certainly save some serious space using the compression and deduplication options. Anyone who’s used […]

Complete refresh of a single materialized view used to do a truncate and insert on the mview table until 10G. Starting with 10G the refresh does a delete and insert on the mview table. This guarantees that the table is never empty in case of an error, the refresh process became an atomic operation.

There is another difference between 9.2 and 10G in the refresh process, which I have realized when

Liveblogging: Extending MySQL by Brian “Krow” Aker
Brian wins the award for “most frequent great quotes during a talk”.
Before MySQL 5.1 a UDF was the only way to extend MySQL.
All you need in a UDF is: init() execute() deinit()

my_bool id3_parse_init(UDF_INIT *initid UDF_ARGS *args, char *message)

UDF_ARGS tell you about incoming args
char *message is the output […]

In 3 words:
They already do.
MySQL Enterprise is more than just a binary. http://mysql.com/products/enterprise/ has the details on the other features MySQL Enterprise includes.
One of these features is the MySQL Enterprise Monitor, which is closed source, proprietary alerting software.
So when bloggers make statements such as:
MySQL will start offering some features (specifically ones related to […]

Aside from 4 missing slides (due to rearranging them this morning), and a couple missing C files, I think it went OK.  Stephan, Brian, et al., thank you for the advice, ideas, and discussion, it will help me clean this presentation and software up for further use.
Also, having now completed the session, I was hoping […]