-
Partitioning and Oracle licenses
One reader asks expert Scott Rosenberg from Miro Consulting about partitioning Oracle software licenses.
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata.
-
Examining mobile applications for J.D. Edwards
Oracle recently announced some new mobile apps for J.D. Edwards. Expert Al Marmero talks about their benefits and potential drawbacks.
-
Making Monday the start of the week in Oracle SQL
One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week.
-
Does storing documents in a database hinder performance
One reader asks if it is the best practice to store a document inside an Oracle database.
-
Improve the Media Recovery Process in Oracle Data Guard
One reader asks expert William Cullen why the Media Recovery Process (MRP) in Oracle Data Guard shouldn't be used in multi-node Real Application Clusters (RAC) environments.
-
Creating and retrieving a binary large object (BLOB)
One reader asks how to create and retrieve a binary large object (BLOB), and SQL expert Karen Morton gives some comprehensive advice and tips.
-
Creating a virtual SQL table for date values
One reader asks how to use SQL to track his company employees' absentee days, and expert Dan Clamage suggests creating a virtual table.
-
Oracle SQL: Using the analytic rank function
Expert Karen Morton explains how to use a simple analytic rank function to sort through a group of golf scores.
-
Oracle licensing with logical partitions (LPARs)
One reader asks about what Oracle licensing his organization must have if they have an environment with two LPARs with one active node.
-
Itanium's core factor affects Oracle DR licensing
One reader asks about licensing Oracle Database 11g on the company's Itanium-based HP servers, and a discussion on Oracle's processor core factor table ensues.
-
Using inline view to better query joined tables
One reader asks how to best query data from two joined Oracle tables.
-
Oracle license requirements in DR scenarios
One reader asks whether they need an Oracle license to back up their database to tape.
-
SQL query for sorting through ID columns
A reader asks Oracle expert Karen Morton how to query a group of rows based on their text columns.
-
Replacing text strings in an employee name column
One reader asks how he can change occurrences of "LL" to "LX" in an employee name column.
-
Avoiding and fixing mutating table errors
PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error.
-
Oracle temporary tablespace too large
One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large.
-
Mirroring in Oracle RAC and Data Guard
A reader asks a question about mirroring on Oracle RAC using Data Guard.
-
Copy Oracle Database but with no data
One reader asks how he can make a copy of his Oracle Database but not have any data in it, for test purposes.
-
Object privileges in Oracle database security
A reader asks a question about the GRANT OPTION as it relates to object privileges in Oracle database security.
-
Oracle licensing on Oracle Database Standard Edition
One reader asks two questions about licensing Oracle Database Standard Edition.
-
Hyperion update has issues with migrating Essbase data
One reader asks how to properly migrate Essbase data when upgrading from Hyperion 9.3.1 to 9.3.3 and then 11.1.2.1.
-
Oracle third-party support has benefits, drawbacks
Expert Al Marmero describes the pluses and minuses of Oracle third-party support. Cost, quality and potential litigation are all key considerations.
Submit a question to our experts