Discussion Locked
An Expert's Guide To Oracle
0 helpful
203 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
blog root
203 replies
by lewisc1
I'm an optimist and I was raised to not say anything if I couldn't say something nice. Now that's not to say I'm going to say something nice if I don't have something nice to say. I just won't say...
by lewisc1
You unlock this data with the key of Oracle. Beyond it is another dimension - a dimension of indexes, a dimension of queries, a dimension of code. You're moving into a land of both performance and maintenance, of money and...
by lewisc1
Final part of a 4 part series on objects in Oracle. This entry concentrates on creating object tables and object views.
by lewisc1
This entry is not about Oracle or databases. If you like to surf the web or if you blog, you'll enjoy reading this....
by lewisc1
EWeek and other media outlets are reporting that Oracle has changed (or is clarifying) its licensing with multi-core CPUs....
by lewisc1
This is a quickie entry. I'm troubleshooting a new error. In some ways week 2 is better than week 1. At least I have all of the data loaded now....
by lewisc1
The week has really just begun but my current project started to really take off on Saturday. I'm knee deep in queries and tuning at this point. When last I wrote, I was having a dreaded ORA-00600. I'm still getting...
by lewisc1
Wow. Friday is finally here. The testing is almost done. Isn't it? Oh. I need to extend for another week to do additional memory sizing tests? IBM is going to love hearing that....
by lewisc1
I've never seen a memory configuration like this and probably never will again. I just had to post this. If you have a bigger memory pool, post your startup stats....
by lewisc1
The basic Data Manipulation Language (DML) commands that have been in use over the years are Update, Insert and Delete. They do exactly what you expect: Insert adds new records, Update modifies existing records and Delete removes records....
by lewisc1
Well, has it really been a month of testing already? How long have I been doing this? Let's see, about 3 weeks before ODTUG and 3 weeks after preparing for the prototype and then 4 weeks navigating around various bugs...
by lewisc1
I was just re-reading my previous post and I don't think I ever said WHY I was doing this prototype. I mean, this was a huge investment of my time as well as support from several SAs and one of...
by lewisc1
I've written some in the past about Oracle and XML. A couple of days ago, some coworkers had a requirement and I created a simple example to show them one possible solution. I thought I would share that here. The...
by lewisc1
EDB 2005 is now in general availability. I downlaoded it Wednesday night and installed it Thursday....
by lewisc1
Hi all. While I was working on my prototype recently, I spent a lot of time telecommuting. I had a better connection (no proxy) and a faster computer at home. I find that I really enjoyed working from home and...
by lewisc1
I was recently thinking about Oracle and PHP. Actually I was thinking
about Oracle and open source in general. The link to the left there
used to be to Oracle's Open Source Developer center. Anyway, that got
me to thinking...
by lewisc1
Hi all. This is going to be a busy week for me....
by lewisc1
Quick overview of what a database is and what Oracle is. A quick description of Oracle's toolset.
by lewisc1
Article comparing the ease of installation between Oracle 10g, MySQL 5.0 and PostgreSQL 8.0.
by chilango02
I like the evaluation method shown there --of course, extending it to
many other aspects such as cost, standards-compliance, functionality,
available support...
But, to really be useful for an actual decision, I strongly recommend
to add a weighting value for each one of the factors. Is the ease of
installation a key aspect t for my specific needs? Then I assign it a
value of 10; Cost is not so important? Let's give it a 7; Ease of
installation is not important at all, so I give it... a 0? a 1?
That way you will have not a generic table, but one that pretty much gives the answers that your project is asking for.
by lewisc1
Discussion about basic SQL commands.
by lewisc1
Well, I have Internet access again. We moved into our new house on Sunday. I owe it all to a bunch of friends who got together and helped us move. It was only about 50 miles but we sure own...
by lewisc1
Thank you for all of your comments. I appreciate them. I have not heard from any of my family in New Orleans or Mississippi. I've been calling every number I know....
by lewisc1
I found my Mom! Actually, she found me. She called me last night from West Monroe, La. On Monday, the hurricane hit and by noon, the water was waist high in her house. She grabbed my nephew and they hiked...
by lewisc1
I recently had the opportunity to attend a one-day TOAD user group in Tampa, FL. I was afraid it would either just be a marketing ploy or that it would be so basic that I wouldn't find it useful. In...
by lewisc1
I recently had the opportunity to attend a one-day TOAD user group in Tampa, FL. I was afraid it would either just be a marketing ploy or that it would be so basic that I wouldn't find it useful. This is the second and final part.
by lewisc1
This is a quick update on my take about some of the recent news from Oracle and some of my opinions about Katrina and its aftermath....
by lewisc1
Oracle, the database, already supports PL/SQL. It also supports Java internally. Using ODBC, JDBC or OCI, it supports most other languages. So why make a big deal out of PHP support? What's so great about PHP? What is ZEND? I...
by lewisc1
I'm back. Sorry to be such a slacker lately. Things have just been really busy around here. I finally have my home network back up (mostly, I lost a web server) after the move. I really like my new house...
by lewisc1
A review of the Toad For MySQL Freeware IDE.
by lewisc1
It's the weekend so I'm writing about fun stuff. Not Oracle. Not that Oracle can't be fun. Saturday night was the perfect night to get some writing done. My son was in bed; my wife was watching her shows in...
by lewisc1
In part 1 of this series I covered Associative Arrays and Record types. Today I will be covering Varrays and Nested Tables....
by lewisc1
A good friend and coworker of mine gave his resignation notice recently. He's going to be going to a great job that I think will challenge him and give him some super opportunities. I wish him the best! That got...
by lewisc1
This is just a note about how everyone in my family is faring after Katrina and Rita. Is this the year of the catastrophe? The last 12 months have been awful. From the tsunami last December to the floods in...
by lewisc1
In part 1 of this series I covered Associative Arrays and Record types. In Part 2, I covered Varrays and Nested Tables. Today I will be covering Sparse Arrays, Bulk Collect and the FORALL command....
by lewisc1
This is just a head's up for those of you in the US. Have you heard of FACTA, the Fair and Accurate Credit Transactions Act? At it's most basic, it means you get a free credit report, from the three...
by lewisc1
Instead of providing an interesting solution to a SQL question, I'm looking for a solution to an interesting SQL query. heh...
by lewisc1
Welcome to AnswerLewis. Last week I asked a question. This week I think I have the answer....
by lewisc1
This is just an update on EnterpriseDB. It's been a while since I posted anything (EDB General Availability). This is just a quick update and some info from Andy Astor, the CEO of EnterpriseDB, on the acquisition of InnoDB by...
by lewisc1
In May, I posted an entry, How to Interview an Oracle Developer. This was a popular entry back then and seems to keep coming up, even now. Yesterday I got a comment on it from a reader, rash. Based on...
by lewisc1
So close and yet so far. On October 13, I posted a question. I followed that up with an answer. Turns out, that answer was incomplete....
by lewisc1
Have you heard about the VMWare player? VMWare Player allows you to run a pre-built virtual machine on any windows or Linux PC....
by lewisc1
Yesterday I wrote about finding VMWare Player, VMWare Player - How sweet it is, a free virtual machine for running pre-built environments. I installed it and played with the browser appliance while I downloaded the pre-built Oracle 10gR2 RAC on...
by lewisc1
Just about everybody is blogging about Oracle 10g Express, the new free version of Oracle (still in beta). The first I saw is here on Wim Coekaert's blog: oracle express edition. It looks like Oracle express is almost exactly what...
by lewisc1
I "attend" webinars on a somewhat frequent basis. I can usually catch them around lunch time (I'm on the east coast), and since I don't have to travel it sometimes works out better than a live, in person seminar. Of...
by lewisc1
Just another quick note about EDB and Oracle XE. The Java Developer's Journal has an article that kind of ties into my entry a few days ago, Oracle Express - EDB Killer?....
by lewisc1
I want to thank IT Toolbox's resident PostgreSQL guy, Josh Berkus, for a great history lesson, Of Railroad Barons and Crippleware. An interesting read....
by lewisc1
Oracle RAC & Grid Tuning with Solid State Disk, sub-titled: Expert Secrets for High Performance Clustered Grid Computing is a pretty specific book covering RAC and how it can make the most of Solid State Disk (SSD). The goal of...
by lewisc1
This is the second and final part of a review of Oracle RAC & Grid Tuning with Solid State Disk, sub-titled: Expert Secrets for High Performance Clustered Grid Computing, a part of the Rampant Press, Oracle In-Focus series....
by lewisc1
This is a response to a response to a response to an entry by Josh Berkus. To me, this thread (or debate or whatever) is exactly what blogging is all about: sharing differing viewpoints and opinions. In this particular debate,...
by lewisc1
I'm battling the flu this week and have not been able to write much. I hope this entry will make sense to someone not enjoying a fever. I was laying around thinking about XML and how my current project is...
by lewisc1
IBM announced a new version of DB2 called Viper. It looks like it's mostly a response to XML DB. It stores XML natively and you can access XML with SQL and XQuery. It also looks like it has optimizations and...
by lewisc1
I found an interesting article, World's largest commercial Linux data warehouse runs Oracle Database. It's interesting to note that the current record holder is a 100 Terabyte database. They say that's triple the previous record holder, which was also Oracle....
by lewisc1
Just read this article in networkworld. It's an interview with the CEO of SAP. He talks about Oracle and several other topics. I thought it would be of interest to many of you....
by lewisc1
In this entry, I'm going to cover how to encode, compress and encrypt a text string for inclusion in an XML document. XML by its definition is a human readable, text format. It is a series of fields (elements) and...
by lewisc1
Christmas comes early for me this year. And strangely enough, it was dying computers that started it all. When I made the move to my new house, one of my older servers died. Not long after that, the wife's laptop...
by lewisc1
When I moved into my house, before I had my broadband account setup, I noticed that my wife had her laptop running and was surfing the internet. After a little research, I found that there was a linksys router running...
by lewisc1
Oracle Buzz Episode 1, Nov 2005 The Oracle Buzz is my take on the news, trends and topics that have the bloggers blogging in the world of databases. I concentrate mainly on the Oracle world but I'll also cover other...
by lewisc1
I was asked by a friend of mine how he could access the XE databases that he has. There's one on a server, one on a co-worker PC and one on his desktop. All of them are called XE. He's...
by lewisc1
It was a very busy week and weekend for me so instead of finishing the database links article I'm writing, I thought I would try to answer some questions that have been posted to some of my past articles....
by lewisc1
The question I probably receive most is how to create XML so that it can be accessed via ftp, http or even from the desktop and tools like MS Word. XML DB can do this and it's pretty easy to...
by lewisc1
There is a new security book out called Cryptography in the Database: The Last Line of Defense. It's written by Kevin Kenan and published by Addison-Wesley Professional....
by lewisc1
The Oracle Buzz is my take on the news, trends and topics that have the bloggers blogging in the world of databases. I concentrate mainly on the Oracle world but I'll also cover other topics that interest me. I'm back!...
by lewisc1
What is a Link? A database link is the way Oracle allows you to connect from one database to another. There are several types of links and I will discuss each of those. Database links are also used in heterogeneous...
by lewisc1
Whatever your holiday of preference, I hope you have a great one. My family (wife and 2 year old son) and I are leaving today to go for a visit to New Orleans. It's our first time back since Katrina...
by lewisc1
Hi all. Thanks for your comments and emails during the holiday. I had a very busy vacation. It was non-stop from the day we got there to the day we left. I'm working on a podcast about my trip and...
by lewisc1
This entry is the first of a two part review of the book Oracle Streams, High Speed Replication and Data Sharing by Madhu Tumma. In this review, I will list what topics are covered by this book, a chapter by...
by lewisc1
Happy New Year! 2005 had its ups and downs but overall was a pretty good year for me. One of the best things was this thing called blogging. I hope you're finding this site useful. My goal is to provide...
by lewisc1
This entry is the second of a two part review of the book Oracle Streams, High Speed Replication and Data Sharing by Madhu Tumma. In the first part, I included the topics covered and the chapter by chapter overview of...
by lewisc1
Today's entry is all about growth in 2006. Where will the career go this year; what do I need to do to make it happen; and what will we make of this blog....
by lewisc1
Hi all. Work and side projects have me overwhelmed this week. As I mentioned earlier this week, I'm working on a couple of presentations. Of course work seems to keep intruding on all of my fun....
by lewisc1
Technorati Profile I'm doing to for Technorati. I thought I had already done this but it appears it didn't take. Thanks, LewisC...
by lewisc1
Have you ever needed to get to a database but didn't have the TNS entry for it? Would you like to connect to a database and have no idea what TNS, or more importantly the TNSNAMES.ORA file, is? Today's entry...
by lewisc1
The question I am asked most frequently, by far, is how to go about starting a career in the Oracle world. This entry starts a new series of articles about how to go about learning Oracle and starting a new...
by lewisc1
The Oracle Developer Tools User Group (ODTUG) is putting on a virtual conference called Desktop Conference 2006. The conference is sponsored by the BI/DW SIG and it runs Feb 21-23. I will be making a couple of presentations. I'll be...
by lewisc1
So you want to learn "ORACLE". What exactly does that mean? What do you WANT to do?...
by lewisc1
In this, the third part of this series, I will answer a few more FAQs. I will follow this entry with one more on this topic and then I will move back to my technical articles....
by lewisc1
TOra is an open source, Linux and windows database IDE that functions a lot like TOAD. Several of my co-workers really like it, mainly because it runs under Linux, which TOAD does not....
by lewisc1
How did that happen? There I was just minding my own bidness, when work jumped up and smacked me with the busy stick. Which is better than the time I got hit with the ugly stick but that's another story....
by lewisc1
VMware cuts VMware Server price to zero VMWare is releasing a free, entry level virtualization product for Windows and Linux....
by lewisc1
Sophos recently blogged about weak passwords and the hashing mechanism in Oracle. Today I wanted to discuss how easy it is to ensure strong passwords in your database....
by lewisc1
I had an abstract accepted for ODTUG Kaleidoscope 2006 in Washington DC in June....
by lewisc1
Today I read a post by Mark Rittman that reminded me why I make his blog a regular read. Today he wrote about Understanding Oracle OLAP Memory Management. It's a fairly brief post considering he discusses the PGA, SGA, UGA,...
by lewisc1
News from CNET: Oracle outlined its integration plans for Siebel Systems on Thursday, with 2,000 job cuts among the most notable tasks at hand. It goes on to say that most of the layoffs will be Oracle people, not Siebel:...
by lewisc1
Yahoo posted a reuters article on an Oracle Filing with the SEC, Oracle sees third-quarter revs up 17 pct to 19 pct....
by lewisc1
Business week has a great article, Oracle's Open-Source Shopping Spree. In the article it talks about Oracle buying three different open source software companies, the biggest of which may be JBoss. I didn't know any of the three were on...
by lewisc1
A database appliance? From Oracle? I must have slept through that announcement!...
by lewisc1
Now that you know where to start, what you want to do and you have some beginning steps, what is the secret to getting the job? I'll do my best in today's post to answer that question. This is the...
by lewisc1
I am frequently asked different questions about PL/SQL, XML, getting started, methodologies, etc and have decided to bring all of that together into a set of posts. I will build a utility package to help me debug and test my...
by vdragos_2000
As I want to know more about PL/SQL and XML I am very interested in this.
by lewisc1
Unrelated to Oracle and databases but somewhat related to technology in general: Madville ran an article today, OMNI Poll: What will 2007 be like? (From 1987). It's an opinion poll by Omni magazine from 1987. It's neat how right and...
by lewisc1
Oracle SQL Developer, i.e. Raptor, Early Adopter Release 4.1 was posted on Feb 17. SQL Developer is the new Oracle SQL and PL/SQL GUI....
by lewisc1
Hey, if you enjoy my blog, please nominate me for the IT Toolbox Community Choice Awards. It only takes a minute or so. Unfortunately, I will be out of town with no internet access during the voting period. The ODTUG...
by lewisc1
Well, the presentation is over. I hope people enjoyed it. I can't tell; there's not much feedback in a virtual conference. I really thought a virtual conference would be better for a first timer like myself but now I think...
by lewisc1
I just finished my second, and final, presentation for the ODTUG Desktop Conference 2006: Implement Security and Audit in Oracle 10g . Well, I have to say I think yesterday went better than today. I asked for open audio to...
by lewisc1
I never thought I would say this but it looks like Oracle Enterprise Manager can now manage SQL Server, BizTalk, Commerce Server and Active Directory. Check out the EWeek article, Oracle Adds .Net, Windows Server Support to Enterprise Manager....
by lewisc1
Hello everyone. My wife and I are taking a much needed vacation. This time there are no relatives to go see or conferences to attend. We're heading out to the caribbean for 7 days on Legend of the Seas....
by lewisc1
I'm back! What a great vacation. If you're in the market for a cruise I can definitely recommend Royal Caribbean and its 7-day western Caribbean trip. Take a look at some pictures. I'm going to be posting a day by...
by lewisc1
I'm catching up on all the news I missed last week and ran across this essay: "Software released under an open source license" is no longer news. An interesting read. I like his comment about open source databases....
by lewisc1
I have an article on the OTN XE Home page, Oracle Database 10g Express Edition: Not Just for Learners. How cool is that!...
Trending After Hours posts
Sort by Trending
0 helpful
10 replies
0 helpful
2 replies
0 helpful
3 replies
Discussion
Hello everyone
0 helpful
3 replies
Discussion Locked
Designing Websites for Clear Mobile Viewing
0 helpful
1 reply