Oracle FAQ

Oracle DBA FAQ

This FAQ is prepared based on Q&A from the several Oracle related news groups.Topics

Auditing, Security or User(A)
Installation, Starup and Shutdown(I)
Backup and Restore(B)
Export/import, backup/restore data(E)
Oracle Enterprise Manager(OEM)(O)

Network(N)
Parameter file(F)
Performance Tuning(X)
Other Oracle Links
Misc(M)

SQL*PLUS(S)
Store Procedure(P) and PL/SQL
Table(T)
Views(V)
Replication(R)

Auditing, Security or User(A)

How to audit user logins?(a1)
How to track user activity?(a4)
Where is the password file?(a7)
How to get connect time and logon time?(a10)
How to set system privilege?(a13)

How to handle the password?(a2)
Is dropping table logged?(a5)
What is the default password?(a8)
How to set archive mode?(a11)
How to use OS passwd?(a14)

How to change password for Internal?(a3)
How to disable archive log?(a6)
How to login as sysdba?(a9)
How to grant execute to packages?(a12)
What is the password file?(a15)

Network(N)

How to start listerner?(n1)
How to debug database link(dblink)?(n4)
How to connect to different database?(n7)
Why it takes long time to connect?(n10)
How to stop of outputing into listener.log file?(n13)
How to use NFS mounted device?(n16)
SQLNET and firewall(n19)
How to solve net8 config problems?(n22)

How to check Intelligent Agent?(n2)
What is tnsnames.ora file?(n5)
Why SQL*Net is slow?(n8)
SQL*NET and ODBC(n11)
Why connection is so slow for Oracle NT?(n14)
What happens if a listener is restared?(n17)
SQL*NET listens on more than one IP(n20)

How to query remote database?(n3)
SQL*NET vs Net8 for Oracle8(n6)
Why cannot connect using Service Discovery?(n9)
Database link(n12)
Why listerner has memory leak?(n15)
How to prevent automatic disconnection?(n18)
How to set db_domain?(n21)

Misc(M)

Why pick CHAR over VARCHAR2?(m1)
Which datafile a table is in?(m4)
How to lock multiple rows?(m7)
What is differ of 8.0.4 and 8.0.5?(m10)
How to convert from Char to number?(m13)
How to find Oracle Instance Names?(m16)
Should I use long interger?(m19)
Lost rollback files(m22)
Commit question(m25)
How to send e-mail from within Oracle?(m28)
How to read multiple rows using ODBC?(m31)
How to use cursor in Oracle?(m34)
How to change NLS_SESSION_PARAMETER? (m37)
How to get date interval?(m40)
How to get constraint values?(m43)
How to release row lock?(m46)
How to UPPERCASE data automatically?(m49)
How to identify my session?(m52)

What a instance means?(m2)
What is Redo Log?(m5)
How to know version of Oracle?(m8)
Oracle e-certification(m11)
What is kproc process in Oracle8 AIX?(m14)
Oracle and NT event log file(m17)
How to handle change computer name?(m20)
How REDO log works?(m23)
How to generate random number with Oracle?(m26)
How date is stored in Oracle?(m29)
Temp segment(m32)
How to disable rollback segment?(m35)
How to silence svrmgrl?(m38)
What is the difference between Oracle 8 and Oracle 8 Enterprise?(m41)
What are top 5 responsibilities of a DBA?(m44)
How to set NLS_DATE_FORMAT?(m47)
How to handle large database in NT?(m50)
How to set/change date format?(m53)

What are extents?(m3)
Where is sqldba in Oracle 8.0.4?(m6)
How to mount database exclusively?(m9)
Oracle Statistics(m12)
How to break a lock?(m15)
Data file timestamp(m18)
What is Enterprise Edition offering?(m21)
How big a rollback segment sould be?(m24)
How to find the difference between dates?(m27)
How many cursor can be opened in Oracle?(m30)
Licensing questions (m33)
How to load data from DB2 to Oracle?(m36)
How to move control files?(m39)
How to find database character set?(m42)
How to set rollback segment grow automatically?(m45)
What is NVL function?(m48)
How to integrate Oracle with e-mail?(m51)

Table(T)

What is max length of a tablename?(t1)
Which table has fields infor about an index?(t4)
Is it going to save space to use VARCHAR2 instead of CHAR?(t7)
How to solve locking problem?(t10)
How to drop a column of a table?(t13)
How to find length of a number?(t16)
How to find total space size?(t19)
How to recover data dictionary?(t22)
How to drop schema?(t25)
What is the opposite of ASCII function?(t28)
How to get current sequence number?(t31)
What is maximum for primary key?(t34)
How to find tablespace information?(t37)
How to view primary keys for a table?(t40)
Which column should have index?(t43)
How to find out last time a table accessed?(t46)
How to create temporary table?(t49)
How to determine table usage with query?(t52)
How to bypass rowid?(t55)

Temperary table space(t2)
How to know the space a table takes?(t5)
How to set the format of DATE?(t8)
Can I name a primary key?(t11)
How to create SEQUENCE?(t14)
Where the constraint name comes from?(t17)
How to change contents of primary key?(t20)
How to rename a tablespace?(t23)
How to get current space of a table?(t26)
Primary Key and Constraint(t29)
How to change column size?(t32)
What is max size of varchar?(t35)
How to find out last time a table updated?(t38)
Why got error to create primary key?(t41)
How to specify the default database?(t44)
How to find index and primary key?(t47)
Numeric datatype question(t50)
How to update table statistics?(t53)
Table more than 255 columns(t56)

Max Extents reached(t3)
Do I have to use SEQUENCE?(t6)
How to find a table's primary key?(t9)
How to insert a black into a non-NULL column?(t12)
Table extents(t15)
What kind data type available?(t18)
How to move a table from a tablespace to another?(t21)
Storage Structure(t24)
How to change the column order?(t27)
How to create a public table?(t30)
How nested tables,trigger work?(t33)
How to find right EXTENTS?(t36)
How to set the sequence?(t39)
What is the serial type in Oracle?(t42)
How to calculate segment size?(t45)
How to use bitmap index?(t48)
Is there cascading delete function in Oracle?(t51)
How to delete all rows from table without drop it?(t54)
How to monitor table usage?(t57)

Views(V)

Is it a bug with V$SQLAREA table(v1)?
How to create this view?(v4)
Why creating view failed?(v7)

Which user dba views belong to?(v2)
How to get full sql of a view?(v5)
How to make X views available to user?(v8)

How to create views?(v3)
How to re-create views?(v6)
Question about v$parameter(v9)

Installation, Starup and Shutdown, control file, data file(I)

How to create a database?(i1)
How to start an instance?(i4)
How to create and start first instance after install Oracle on NT?(i7)
Why Oracle refuse to start?(i10)
How to create a new instance in AIX?(i13)
How to utilize the RAID set?(i16)
What the permission a datafile should be?(i19)
Why rollback segment is too small?(i22)

How to stop and start instances from batch?(i2)
How to install multiple Oracle?(i5)
Linux installaton 1(i8)
Linux installation 2(i11)
Physical disk vs logical drives(i14)
Why getting some error after install?(i17)
How to move database to another machine?(i20)

Why snapshot is too old?(i3)
Oracle server for NT or Unix?(i6)
What is a datafile?(i9)
What is Oracle Async I/O?(i12)
How to drop a database?(i15)
What is the difference between startup exclusive and startup mount exclusive?(i18)
What are these errors when install in AIX?(i21)

Backup and Restore,Export/import, Redo log file(B)

How to use RECOVER?(b1)
Is any size limit when using export?(b4)
Which utility to use and load file?(b7)
What is the importing sequence?(b10)
SQL*Loader Question(b13)
How to export a file bigger than 2GB?(b16)
How to do online backup?(b19)
Can I delete archived redo log files?(b22)
Problem with redo logs(b25)

Why import takes so long?(b2)
How to import only stored procedure?(b5)
How to recreate Oracle environment with data?(b8)
What is the relation between SGA and import utility?(b11)
How to generate a insert file?(b14)
How to use sqlloader with date mask?(b17)
How to work with SQL*Loader and trigger?(b20)
How to improve performance of archive log mode?(b23)
How to insert many records in short time?(b26)

How to use sqlload and skip columns?(b3)
Why it is so slow when loading?(b6)
When to use SQL*Loader?(b9)
Why losing space when deleting records?(b12)
How to improve performance of import?(b15)
SQL*Loader and CSV file(b18)
What is incremental import/export?(b21)
How to find size of tablespace from export file?(b24)
How to recover database after a crash?(b27)

SQL*PLUS(S) and Query

How to connect internal?(s1)
Is any way to set num of failed attempt?(s4)
Query Challenge 1(s7)
How to run SQL*Plus script in batch?(s10)
How to excute SQL script from a command file?(s13)
How to use sysdate?(s16)
How to get error return code to Unix?(s19)
How to use escape char in a query?(s22)
How to find duplicates?(s25)

How to compare a date to sysdate?(s2)
How to select first row of a table?(s5)
SQL question(s8)
Case sensitive(s11)
Why SYSDATE shows wrong time?(s14)
How to get excution time of selecting from table?(s17)
How to use sequence and ordered query?(s20)
How to call stored procedure in SQL*PLUS?(s23)
How to take floor of date?(s26)

How to use days between function?(s3)
How to set prompt?(s6)
How to use cascade delete?(s9)
How to insert values having quote?(s12)
How to show instance name in SQL*PLUS?(s15)
How to do array fetch and array insert?(s18)
How to use where in query?(s21)
How to select based on summary?(s24)

Oracle Enterprise Manager(OEM)(O)

Why get error "Failed to authenticate"?(o1)

Why job execution got problem with OEM?(o2)

How to do batch jobs using OEM?(o3)

Store Procedure(P), Packages, PL/SQL and Trigger

How to get sysdate in SP?(p1)
How to change sysdate?(p4)
Can PL/SQL return multiple results?(p7)
How to get output from trigger?(p10)
Which index Oracle is using?(p13)
What is the diff between SP and package?(p16)
How to check the size of SP?(p19)
How to pass variable to a procedure?(p22)
How to use host command in PL/SQL?(p25)

How to get new sequence number?(p2)
How to dynamicly create table name?(p5)
How to get all stored procedure?(p8)
How to select from mutilple schema in SP?(p11)
How to compile a ProC program?(p14)
How to pass table name to SP?(p17)
How to use SP?(p20)
Triger, SP and tablespaces(p23)
How to use truncate table in PL/SQL?(p26)

Auto-commit in Stored Procedure(p3)
How to call *.exe program in SP?(p6)
Cany trigger and Store Procedure run by itself?(p9)
How to check query time in PL/SQL?(p12)
How to update a trigger?(p15)
How to get this function?(p18)
How to get dynamic PL/SQL?(p21)
How to use DBMS_JOB?(p24)

Parameter file(F)

Rollback segment(f1)
How to set ARCHIVELOG?(f4)
How to determine DB_BLOCK_SIZE?(f7)

What is default tablespace?(f2)
Contraol file quesiton(f5)
What is proper size of SGA?(f8)

How to check the parameter from table?(f3)
How to change dbname of startup database?(f6)
What parameter _disable_logging for?(f9)

Performance Tuning(X)

Why is NT/Oracle is so slow?(x1)
Performance and hard drive(x4)
What is relation of datafile size and performace?(x7)
Why DBWR is slow?(x10)

Why it SQL take so long?(x2)
Block size and performance(x5)
How to re-org the tablespace?(x8)

Why insert takes so long?(x3)
What is the fast way to scan table?(x6)
Performance using raw vs. file(x9)

Replication(R)

What is the usage of snapshots?(r1) How to use replication? How to set up the replication?

Other Oracle Links

Oracle Home Page
Oracle TechNet
Oracle Government and Education E-certification
Oracle Magazine Oracle Assist -- a discussion club
DBA and Pokey Bootlegs
JL Oracle Home Page -- An Expert view of Oracle database engine
Oriole Corp -- Oracle scripts and others
Free Oracle scripts in Oriele
OraPub -- Tech Papers, tools and others
Oracle on Linux -- Doc about installation
Savant -- Oracle Diagnostics Tools
GJ's Software -- OraCodes, OraSQL and others
[Back Top]
Please e-mail your comments to [email protected]

Hosted by www.Geocities.ws