For more information about the site, see the Site Index

• Where to start learning Oracle basics for career
• Import of database dump takes 13 hours
• How to dump SQL Server database with Oracle data
• Configure two listeners without RAC in Oracle
• How to perform Oracle replication
• Slow query performance for customer with large data volume
• ORA-03297 when trying to resize tablespace
• The MAX of two MAX values in SQL
• SQL CHECK constraints to validate table inserts
• Migrate Oracle 10g database from Linux to AIX
• ORA-01445 error with exp command
• What happens if there is no log switch for a long time?
• Procedure compiles but does not execute
• Point-in-time recovery on production database
• ORA-27102 error after increasing memory
• Re-create data dictionary without disturbing database
• Find size occupied by millions of rows without VSIZE function
• Users have unlimited tablespace system privileges
• No reduction in size of tablespace after moving schemas
• Rename a table with import utility in Oracle
• How to clone an Oracle database
• TNS listener consuming a lot of memory
• Why not assign users default and temporary tablespaces?
• Cannot log in to issue a STARTUP command
• The ALTER TABLE statement
• NOT EXISTS with a correlated subquery
• Obtaining COUNTs for males and females in one SQL query
• Difference between Oracle RAC and Data Guard
• Oracle licensing policy for educational institutes
• DBA time tracking and change management
• Oracle job advice: ERP or Oracle apps?
• What to do after hiring an unqualified candidate
• Improve performance of SQL query
• Impact on apps of migration from Oracle 8 to 10g
• Using /var/opt/oracle/oratab
• Error in invoking target install of makefile
• Errors installing Database Configuration Assistant
• SMON process consuming 100% CPU
• Matching one column value to part of another in SQL
• Clone production database to different OS
• Recover deleted database from data files, control files
• Interview questions about managing an Oracle database
• Import Oracle 9i dump from Windows to Unix
• Syntax for export utility in Oracle 9i
• The running total self-join
• Using GROUP BY to collapse rows
• Number of rows in two tables
• Performing backups with Oracle RAC and ASM
• See tablespace utilization/database size without DBA privileges
• Total Oracle CPU time
• Performance issues with upgrade to Oracle 10g database
• Retrieve last row inserted into table in Oracle
• Tool in Oracle 10g to keep track of execution of queries
• Impact of Oracle 9i upgrade on Java front end
• What do database architects do?
• Information on OUI (Oracle Universal Installer)
• Problems connecting to iSQL*PLUS
• Tools to manage multiple Oracle 10g databases
• Are Oracle 10g and VB 6.0 compatible?
• Migrate Oracle 9i data on Sun to 10g on Windows
• How to encrypt stored passwords in Oracle 8i?
• ORA-01103 error during Oracle 10g startup
• Connect to Oracle 9i through client
• Etrust Antivirus changing Oracle parameters
• Move tables from system tablespace to users tablespace
• Cannot create services in Oracle 9i
• Separate database for each client in Oracle 10g
• Relationship between schema and datafile in Oracle
• How to increase SGA_MAX_SIZE in Oracle
• Help optimizing a SQL query
• Simple SQL query takes longer than usual
• Using RAID 5 with Oracle Database
• Oracle DBA training and courses
• Remove fragmentation of tables and indexes in Oracle
• SQL to calculate days to next status change
• Does SUM discard rows that have 0 values?
• UPDATE only rows which match another table in SQL
• Too many reads on inserts
• Pros and cons of ALL_ROWS optimizer
• DBMS JOB Configuration error in RAC system
• Hint in view code to force use of index
• Is my database using SPFILE or PFILE?
• How to delete tens of millions of rows from table
• Find out if a query used an index
• Oracle performs full table scan in one database
• Overlap of jobs on server
• Checkpointing during hot backup
• CREATE PUBLIC SYNONYM with EXECUTE IMMEDIATE
• Closing connections to Oracle database takes too long
• ORA-00204 and ORA-07373 errors during database recovery
• Critical Patch Update for CRS home
• Migrate cold backup files from HP-UX to Windows
• Errors while trying to restore dropped tablespace
• Using redo logs to restore to point of failure
• Recover database not running in archive log mode
• Running out of semaphores
• Using DBMS_STATS to generate statistics in Oracle 10g
• Upgrade Oracle 8.1.7.4 database to Oracle 10.2.0.3 on AIX
• TNS listener components not working after upgrade
• How many database instances can be created?



• More