Oracle 10G introduced a new type of tablespace called a Bigfile Tablespace. When I read the 10G New Features manual and found out that you could create a terabyte sized datafile using the Bigfile...
I have taught hundreds of people how to administer Oracle during my career as an Oracle instructor. For those of you just entering this profession, here is my most sage piece of advice:
I thought I?d provide you with a couple of quick SQL*PLUS tips and tricks this week. Some of the features are new in 10G, while others are available in earlier releases. I think you?ll find them...
I thought I would deviate from my usual discussion on 10G technical topics for one blog. I?d like to talk about non-technical skill sets and the important role they play in our careers.
Let?s finish this series on 10G Data Pump by investigating the Data Pump Import utility. In this blog, we'll learn how to execute 10G Data Pump Import and take advantage of some of its more popular...
This is part three of a series on 10G Data Pump. In part one, we reviewed a few of the new features that make Data Pump Export and Import attractive alternatives to their ancestors, Export and...
Now that we have a general understanding of some of the features that 10G Data Pump provides, let?s peel back a few of the layers and see how this utility works. In this blog, we?ll take an...
Describing the Oracle Export and Import utilities as slow is like saying the Titanic sprung a small leak. Stories of Export and Import executions running for hours (and sometime days) are...
Correctly sizing online redo log files is critical if you want to achieve ?maximus database performis?. 10G Grid Control provides a redo log file sizing advisor that provides administrators with an...
Although I provided a quick demo on how to use 10G Grid Control?s SQL Access Advisor in an earlier blog, I think it may be beneficial for us to take a more in-depth look at this powerful utility. ...