-
Backup and recoveries of Oracle RAC 10gR2
An Oracle user asks expert Brian Peasland a few questions about taking a backup and recovery for RAC 10gR2.
-
How to recover a control file
An Oracle user asks how to recover their control file in the case of media failure.
-
The USING BACKUP CONTROLFILE clause in Oracle commands
An Oracle user asks how a command with the USING BACKUP CONTROLFILE clause works.
-
How to use the OPatch Utility in Oracle
Expert Brian Peasland explains how to use the OPatch Utility to find the CPU patch level applied to the particular database.
-
Normalizing a crosstab table
SQL expert Rudy Limeback explains how to use a UNION query to normalize a crosstab table.
-
SQL for hourly totals for the last 48 hours
SQL expert Rudy Limeback explains to an Oracle user how to user asks how to generate datetimes or use left outer join to get hourly totals for the last 48 hours in SQL.
-
LEFT OUTER JOIN to a MIN/MAX row
An Oracle user asks SQL expert Rudy Limeback how to use a LEFT OUTER JOIN with a MIN/MAX condition.
-
How to implement a ref cursor called in a stored procedure
Expert Brian Peasland explains how and when to implement a ref cursor called in a stored procedure.
-
Export dump with files larger than 2 GB
An Oracle user asks how to create an export dump with files larger than 2 GB.
-
How can I solve the ORA-4030 error?
An Oracle user asks how to solve the ORA-4030 error: out of process memory .
-
What is Unix shell scripting?
Oracle expert Brian Peasland explains about Unix shell scripting.
-
How to get history of modified data from Oracle databases
An Oracle user asks how to get the history of data modified from an Oracle database.
-
Performing a backup with table locks
An Oracle user asks if a backup can be performed when there are table locks on certain fields.
-
How to move data faster with a database link
Oracle expert Brian Peasland explains how to move data across a database link to speed up an import.
-
Why am I getting the ORA-00381 error when initializing the parameter?
An Oracle user asks why they are getting the ORA-00381 error when initializing the parameter.
-
Performance issues in Oracle 9i
An Oracle user asks if upgrading their database to 10g will help solve performance and space management issues in Oracle 9i.
-
What is the difference between an instance and mounting in Oracle?
An Oracle user asks what the difference is between an instance and mounting.
-
Benefits of a 3NF level of normalization
An Oracle user asks expert Brian Peasland his general opinion regarding normalizing data in an Oracle database.
-
Moving a table with a LOB column
An Oracle user asks if anything different has to be done when moving a table with a LOB column.
-
In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?
An Oracle user asks if the number of columns in a table affect the performance during SELECT/INSERT/UPDATE.
-
Perfect the Oracle RMAN duplicate 10g command
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
-
Do SQL arithmetic without using arithmetic operations
Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
-
Managing SQL parent table-child table relations
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.