Antonio Alvarado Hernández's Library tagged tip →  View Popular

A personal blog from a freelance Oracle DBA, with interesting Oracle resources, tips and tricks.

boulayp.free.fr - Preview

database Oracle tip trick script utility blog resource to:Oracle

Oracle Corporations developer Vadim Tropashko has some interesting notes on tuning Oracle SQL queries that compare the contents of two tables, showing several SQL solutions and their performance with
(tags: trick tip table sql resource oracle database c

www.dba-oracle.com/_set_to_join_sql_parameter.htm - Preview

trick tip table sql resource database compare article to:Oracle Burleson

Oracle provides table and index maintenance tools (Oracle 10g online reorganization) for a very good reason. To keep Oracle running super-fast, Oracle chose not to incur the overhead of coalescing ta
(tags: tuning tip resource oracle maintenance databas

www.dba-oracle.com/ligent_10g_DBA_maintenance.htm - Preview

tuning tip resource maintenance database coalescing article to:Oracle Burleson

Oracle SQL tuning is a phenomenally complex subject. Entire books have been written about the nuances of Oracle SQL tuning; however, there are some general guidelines that every Oracle DBA follows in
(tags: tuning trick tip sql resource performance oracl

dba-oracle.com/art_sql_tune.htm - Preview

tuning trick tip sql resource performance database article to:Oracle Burleson

Oracle stored procedures and triggers are faster than traditional code, which leads to an increase in popularity. As application code moves away from external programs and into the database engine, DB
(tags: using trick tip stored resource procedure orac

www.dba-oracle.com/art_proc.htm - Preview

using trick tip stored resource procedure database article to:Oracle Burleson

Tired of hunting around in File Types to re-associate your files? Heres an easier way to re-associate your files to the Windows XP defaults.
(tags: windows trick tip restore resource fix file association article)

www.dougknox.com/...xp_easy_file.htm - Preview

windows trick tip restore resource fix file association article

The files listed here are all ZIP files, which contain a REG (Registry) file to fix up broken file association.
(tags: windows trick tip restore resource fix file association article)

www.dougknox.com/...file_assoc.htm - Preview

windows trick tip restore resource fix file association article

Here’s another new site from Chris Coyier. He loves reading books about design, so he’s made a little site to help immortalize the great little quotes he comes across. There aren’t a ton of them up th
(tags: web tutorial trick tip template resource howto

css-tricks.com - Preview

web tutorial trick tip template resource howto development design css article

Your how-to guide for Google with Google tutorials, tips for using Google and advice.
(tags: tutorial trick tip technology site resource news internet hack google)

www.googletutor.com - Preview

tutorial trick tip technology site resource news internet hack google

Google Analytics provides some great information about what is happening on your website. But what if you want to take it to the next level? Thanks to the many smart people who have created these wond
(tags: web trip traffic tip resource metric hack goog

www.grokdotcom.com/...google_analytics_hacks - Preview

web trip traffic tip resource metric hack google article analytics

Oracle has improved the cost-based Oracle optimizer in 9.0.5 and again in 10g, so one of the most common causes of bad performance right after moving to 10g are related to environmental parameter sett
(tags: tuning tip resource release oracle migration d

www.dba-oracle.com/_performance_after_upgrade.htm - Preview

tuning tip resource release migration database article 10g to:Oracle Burleson

The Oracle STATSPACK utility (and its successor, AWR), is one of the most exciting Oracle enhancements. This article will introduce you to the STATSPACK and AWR utility and show you how to put it to
(tags: tip statspack resource rdbms performance oracle

dba-oracle.com/art_statspack.htm - Preview

tip statspack resource rdbms performance monitor database article to:Oracle

These tips will show you the differences between Mac OS X and other flavors of Unix; help you find the bits that resemble the Unix you are used to; and even feather your nest with ports of popular ope
(tags: unix tip resource macos article apple)

www.macdevcenter.com/...macforunix.html - Preview

unix tip resource macos article Apple

Because all Oracle databases retrieve and store data, the relative cost of physical disk access is an important topic.
(tags: tuning tip resource performance oracle io database article)

www.dba-oracle.com/art_builder_io_speed.htm - Preview

tuning tip resource performance io database article to:Oracle

If you dont want to use dbms_redefinition, or the CTAS statement is one method for reorganizing an Oracle table or moving the table to another tablespace.
(tags: tip table resource reorganize oracle database create article)

www.dba-oracle.com/t_create_table_select_ctas.htm - Preview

tip table resource reorganize database create article to:Oracle

Theres one thing all Windows users have in common: They all want the OS to run faster. Here are five ways to turn your tortoise PC into a hare.
(tags: windows tweak trick tip resource post performance)

www.cnet.com/8301-13880_1-9868480-68.html - Preview

windows tweak trick tip resource post performance

This site contains useful code snippets in various programming languages. I use this site as my "little programming book" and I simply made it available to others. There is no "company&
(tags: vbscript tip snippet resource powerbuilder javascript java ho

www.rgagnon.com/howto.html - Preview

vbscript tip snippet resource powerbuilder javascript howto example Javascript Java

Shows how to emulate the "rank" OLAP function (as Oracle, DB2 & SQL Server 2005) on MySQL 5
(tags: tip sql resource rank olap mysql function emulation article analytic)

www.oreilly.com/6969 - Preview

tip sql resource rank olap mysql function emulation article analytics

This article will examine the realities of hardware advances and show how the Oracle systems manager can make an intelligent decision about when to move to faster hardware platforms.
(tags: upgrade tip resource rdbms oracle hardware database article)

www.dba-oracle.com/t_hardware_upgrade.htm - Preview

upgrade tip resource rdbms hardware database article to:Oracle

(tags: windows tweak trick tip resource knownlege article)

www.dougknox.com - Preview

windows tweak trick tip resource knownlege article