Oracle Tips

Call (800) 766-1884 for Oracle support & training

Oracle Tips Archive

Donald K. Burleson

We also have Oracle9i new features support, Oracle9i RAC, and Oracle9i Real Application Clusters support. We do Oracle data warehouse support, Oracle10g consulting and Oracle data warehousing consulting.

Other Links:

Oracle10g Wait Event List

Oracle performance book

Oracle tuning book

Oracle RAC

Oracle TAF

Oracle Cluster Failover

Oracle HIPAA Compliance

Oracle GLB Compliance

Oracle Sarbanes-Oxley Compliance

Oracle Privacy

Oracle10g Privacy

Oracle replication

Oracle10g Replication

Oracle multimaster replication

Oracle materialized views

Oracle snapshot

Oracle10g SQLAccess

Oracle10g automatic database diagnostic monitor

Oracle10g automatic shared memory tuning

Oracle10g automatic storage management

Oracle10g XML database

Oracle10g streams

Oracle technical support Oracle cert training

util1

util6

util11

util16

util21

util26

Java Job Interview questions, Unix job. Java Job Interview

Oracle seminar training

Oracle9i migration, Oracle9i RAC Oracle RAC reference RAC documentation

Effective Oracle Advertising

Effective Oracle Product Advertising

Effective Oracle Services Advertising

Effective Oracle Advertisement

Effective Oracle Product Advertisement

Effective Oracle Services Advertisement

Effective Oracle Advertisements

Effective Oracle Product Advertisements

Effective Oracle Services Advertisements

sga1 sga2 sga3 sga4 sga5 sga6 sga7 sga8 sga9 sga10

Oracle 11i consulting 10g new features book oracle security oracle security scripts

custom oracle training & customized oracle training

oracle 10g training oracle 10g consulting ocp study

oracle emergency & emergency oracle support

scripts1 scripts2 scripts3 scripts4

oracons

sql1 sql2 sql3 sql4 sql5 oracle sql tuning

rac1 rac2 rac3 rac4 rac5 rac6 rac7 rac8 rac9 rac10

rac11 r12 rac13 rac14 rac15

oas1 oas2 oas3 oas4 oas5 oas6 oas7 oas8 oas9 oas10 oas11 oas12 oas13 oas14 oas15 oas16 oas17 oas18 oas19 oas20

perf1 perf2 perf3 perf4 perf5

sec1 sec2 sec3 sec4 sec5 sec6 sec7 sec8 sec9 sec10 sec11 sec12

ora1 ora2 ora3 ora4 ora5 ora6 ora7 ora8 ora9 ora10 ora11 ora12

rep1 rep2 rep3 rep4 rep5 rep6 rep7

pl_sql tuning plsql tuning pl_sql_performance plsql_perf

plsql_support plsql_support pl_sql_cons plsql_cons

oracle remote links

oracle unix consulting
unix oracle consulting

oracle unix support
unix oracle support

Oracle 10g

10g_120	10g_121	10g_122	10g_123	10g_124
10g_125	10g_126	10g_127	10g_128	10g_129
10g_130	10g_131	10g_132	10g_133	10g_134
10g_135	10g_136	10g_137	10g_138	10g_139

10g_266	10g_267	10g_268	10g_269	10g_270
10g_271	10g_272	10g_273	10g_274	10g_275
10g_276	10g_277	10g_278	10g_279	10g_280
10g_281	10g_282	10g_283	10g_284	10g_285
10g_286	10g_287	10g_288	10g_289	10g_290

10g_416	10g_417	10g_418	10g_419	10g_420
10g_421	10g_422	10g_423	10g_424	10g_425
10g_426	10g_427	10g_428	10g_429	10g_430
10g_431	10g_432	10g_433	10g_434	10g_435
10g_436	10g_437	10g_438	10g_439	10g_440

Oracle Replication

rep_26	rep_27	rep_28	rep_29	rep_30
rep_31	rep_32	rep_33	rep_34	rep_35
rep_36	rep_37	rep_38	rep_39	rep_40
rep_41	rep_42	rep_43	rep_44	rep_45
rep_46	rep_47	rep_48	rep_49	rep_50

rep_176	rep_177	rep_178	rep_179	rep_180
rep_181	rep_182	rep_183	rep_184	rep_185
rep_186	rep_187	rep_188	rep_189	rep_190
rep_191	rep_192	rep_193	rep_194	rep_195
rep_196	rep_197	rep_198	rep_199	rep_200

Oracle Physical Design

phys_26	phys_27	phys_28	phys_29	phys_30
phys_31	phys_32	phys_33	phys_34	phys_35
phys_36	phys_37	phys_38	phys_39	phys_40
phys_41	phys_42	phys_43	phys_44	phys_45
phys_46	phys_47	phys_48	phys_49	phys_50

Oracle Security Auditing

aud_26	aud_27	aud_28	aud_29	aud_30
aud_31	aud_32	aud_33	aud_34	aud_35
aud_36	aud_37	aud_38	aud_39	aud_40
aud_41	aud_42	aud_43	aud_44	aud_45
aud_46	aud_47	aud_48	aud_49	aud_50

aud_176	aud_177	aud_178	aud_179	aud_180
aud_181	aud_182	aud_183	aud_184	aud_185
aud_186	aud_187	aud_188	aud_189	aud_190
aud_191	aud_192	aud_193	aud_194	aud_195
aud_196	aud_197	aud_198	aud_199	aud_200

aud_326	aud_327	aud_328	aud_329	aud_330
aud_331	aud_332	aud_333	aud_334	aud_335
aud_336	aud_337	aud_338	aud_339	aud_340
aud_341	aud_342	aud_343	aud_344	aud_345
aud_346	aud_347	aud_348	aud_349	aud_350

aud_476	aud_477	aud_478	aud_479	aud_480
aud_481	aud_482	aud_483	aud_484	aud_485
aud_486	aud_487	aud_488	aud_489	aud_490
aud_491	aud_492	aud_493	aud_494	aud_495
aud_496	aud_497	aud_498	aud_499	aud_500

aud_626	aud_627	aud_628	aud_629	aud_630
aud_631	aud_632	aud_633	aud_634	aud_635
aud_636	aud_637	aud_638	aud_639	aud_640
aud_641	aud_642	aud_643	aud_644	aud_645
aud_646	aud_647	aud_648	aud_649	aud_650

Oracle Internals Monitoring

int_26	int_27	int_28	int_29	int_30
int_31	int_32	int_33	int_34	int_35
int_36	int_37	int_38	int_39	int_40
int_41	int_42	int_43	int_44	int_45
int_46	int_47	int_48	int_49	int_50

int_176	int_177	int_178	int_179	int_180
int_181	int_182	int_183	int_184	int_185
int_186	int_187	int_188	int_189	int_190
int_191	int_192	int_193	int_194	int_195
int_196	int_197	int_198	int_199	int_200

int_326	int_327	int_328	int_329	int_330
int_331	int_332	int_333	int_334	int_335
int_336	int_337	int_338	int_339	int_340
int_341	int_342	int_343	int_344	int_345
int_346	int_347	int_348	int_349	int_350

int_476	int_477	int_478	int_479	int_480
int_481	int_482	int_483	int_484	int_485
int_486	int_487	int_488

Java Job Interview

java_26	java_27	java_28	java_29	java_30
java_31	java_32	java_34	java_35	java_36
java_37	java_38	java_39	java_40	java_41
java_42	java_43	java_44	java_45	java_46
java_47	java_48	java_49	java_50	java_51

java_176	java_177	java_178	java_179	java_180
java_181	java_182	java_183	java_184	java_185
java_186	java_187	java_188	java_189	java_190
java_191	java_192	java_193	java_194	java_195
java_196	java_197	java_198	java_199	java_200

java_326	java_327	java_328	java_329	java_330
java_331	java_332	java_333	java_334	java_335
java_336	java_337	java_338	java_339	java_340
java_341	java_342	java_343	java_344	java_345
java_346	java_347	java_348	java_349	java_350

Java Job non-tech

non_26	non_27	non_28	non_29	non_30
non_31	non_32	non_33	non_34	non_35
non_36	non_37	non_38	non_39	non_40
non_41	non_42	non_43	non_44	non_45
non_46	non_47	non_48	non_49	non_50
non_51	non_52	non_53	non_54	non_55
non_56

Network Administrator

net_26	net_27	net_28	net_29	net_30
net_31	net_32	net_33	net_34	net_35
net_36	net_37	net_38	net_39	net_40
net_41	net_42	net_43	net_44	net_45
net_46	net_47	net_48	net_49	net_50

Oracle Disk I/O Tuning

disk_26	disk_27	disk_28	disk_29	disk_30
disk_31	disk_32	disk_33	disk_34	disk_35
disk_36	disk_37	disk_38	disk_39	disk_40
disk_41	disk_42	disk_43	disk_44	disk_45
disk_46	disk_47	disk_48	disk_49	disk_50

Oracle Disk I/O Tuning

Volume Management	Metadata Caching
Cluster File System	PolyServe Matrix Server
Direct I/O	Oracle Disk Manager

RAC	Disk Manager
RAC Database	File Descriptors Indentifiers
External Tables	ASM

Oracle Home	ASM Oracle-managed Files
RAC	Direct I/O Asynchronous
TruCluster Server	Direct Buffered I/O

CDSL	Non-blocking I/O
CFS RAC	ASM Kernalized
CFS RAC	Asynchronous I/O

Oracle SQL & CBO Internal

Cost-based Optimizer Internal	Universal Existential Qualifiers
Existence Queries Correlation	For All For Each Qualifiers
Correlation Query	Universal Qualifier

Correlated Query EXISTS	Outer Middle Inner Query
EXISTS Query	Universal Qualifier Existential Qualifier
HAVING Clause	Outer Query Middle Query

Subquery Query	Middle Query Inner Query
Subquery Correlated	Outer Query Tuple Row
IN EXISTS Correlated Query	Outer Middle Inner Query

Correlated Uncorrelated Query	EXISTS NOT EXISTS Clause
EXISTS Clause	For All Query
IN EXISTS Clause	Outer Query Join Null Condition Equi-Join

Oracle SQL & CBO Internal

External Table Performance				Merge Command External Tables
External Table Performance				Merge Command Hash Join
External Table Parallels				External Table

Parallels db_file				Stored Outlines dba_outlines
Export Data				dbms_outline
Oracle Internal Loader				dba_outlines dba_outline Hints

Multi-table Insert External Tables				Oracle10g New SQL Language Features
Multi-table Insert				Oracle 10g Grouped Table Outer Join
Standard Insert				Grouped Table Outer Join

Standard Insert External Tables				Increased Number Aggregates Query Remote
Multi-table Insert				Remote Stored Functions Select Statements
Merge Command				SELECT Statements
Top Job Answers
TopJob1	TopJob2	TopJob3	TopJob4	TopJob5	TopJob6	TopJob7	TopJob8
TopJob9	TopJob10	TopJob11	TopJob12	TopJob13	TopJob14	TopJob15	TopJob16

Webmaster Job Interview
Webmaster1	Webmaster2	Webmaster3	Webmaster4	Webmaster5	Webmaster6
Webmaster7	Webmaster8	Webmaster9	Webmaster10	Webmaster11	Webmaster12
Webmaster13	Webmaster14	Webmaster15	Webmaster16	Webmaster17	Webmaster18
Webmaster19	Webmaster20	Webmaster21	Webmaster22	Webmaster23	Webmaster24


Webdesigner Job Interview
Webdesigner1	Webdesigner2	Webdesigner3	Webdesigner4	Webdesigner5	Webdesigner6
Webdesigner7	Webdesigner8	Webdesigner9	Webdesigner10	Webdesigner11	Webdesigner12
Webdesigner13	Webdesigner14	Webdesigner15	Webdesigner16	Webdesigner17	Webdesigner18
Webdesigner19	Webdesigner20	Webdesigner21	Webdesigner22	Webdesigner23	Webdesigner24
Webdesigner25

s66 s67

gridbook1 gridbook2 gridbook3 gridbook4 gridbook5 gridbook6 gridbook7 gridbook8 gridbook9

oracle backup script
oracle backup scripts
oracle cron script
oracle cron scripts
oracle crontab script
oracle crontab scripts
oracle dictionary script
oracle dictionary scripts
oracle performance script
oracle performance scripts
oracle recovery script
oracle recovery scripts
oracle script
oracle scripts
oracle scripts2
oracle shell script
oracle shell scripts
oracle sql script
oracle sql scripts
oracle sql tuning script
oracle sql tuning scripts
oracle tuning script
oracle tuning scripts
oracle unix script
oracle unix scripts
oracle v$ script
oracle v$ scripts
unix oracle script
unix oracle scripts

UNIX Job Interview

Security File System Integrity Tool	DNS Servers Network Request
Intrusion Detection System	UDP TCP
ARP Cache Poisoning	Solaris System IP Network

VPN Technology	TCP Sequence Number Prediction
Security DMZ	Domain Name UNIX Servers DNS Primary Zone
Linux Directory Entries	Network Services Port Numbers Telnet SSH FTP

Networking Ports Open	Routing Table UNIX System
Subnet Mask Default Class	UNIX System Ping Subnet
Class C IP Network IP Address	Telnet Session UNIX System Prompt

MAC Address	System Administration Default Partitioning Scheme
Linux Router Subnets	Disk Management Boot Block Super Block Logic
Networking MTU	Hard Disk UNIX System

J2EE Job Interview

Qualifications Transport Protocol	J2EE Service API Transactions
Enterprise Information System	Java Database Connectivity JDBC API
Standard Architecture Enterprise	JDBC Packages

Containers J2EE Architecture	JDBC Connection
Modeling Tool	JDBC No Suitable Driver Error
Large Small Applications	JDBC Connection Object

Transaction	JDBC ResultSet Object While Loop
ACID Transactions	JDBC getXXX Methods Class Values
JAR Files Platform Independent	JDBC ResultSet Method

CORBA Object Request	JDBC ResultSet Object
Remote Method Invocation RMI	JDBC ResultSet Method
Asynchronous Messaging	JDBC Pooled Connection Objects

oracle_consulting_services

Programmer Job Interview

Java Interview Signed Integral Data Types	Java Software Development Kit SDK
Throw Able Class Complete	SDK Environmental Variables
System.out.println System.out.print	CLASSPATH

String Object Operator	CLASSPATH JVM Java Class
String Initialization	CLASSPATH JRE
Variable Constant	JDK Minimal Profiler

+ Operator Strings	Premature Optimization
Characters Java Identifier	Garbage Collector Memory
String Integer	Command-line SDK Messages Interpreter

String Byte	Tuning Application Computer Resources
String Long	Default Profiler
Java Tuning Interview Java Software	Results File Profile

Oracle 10g Grid Computing

Grid Computing Oracle Pure Play Grid	Oracle Streams Data Pump Grid Environment
Grid-enable Scope Size	Grid Control OEM Globus Tool Kit
Real Application Clusters	Globus Tool Kit Globus Resource

Data Virtualization Data Grid	MDS Grid Index Information Service
Grid Control Application Server	Very Large Database VLDB
Database Server Storage Management	Real Application Clustering

Oracle 10g Database Application Server	Online Real-Time Access Corporate Data
Automatic Storage Management ASM	Cluster Technology Cache Fusion
Clusterware Infiniband Intercon	Cluster Technology Applications

Database Resonance Cluster	RAC Database Single Multi Instance
Job Scheduler Oracle Resource Manager	RAC Cluster Database Shared Systems
Data Provisioning Oracle Streams	Parallel Server OPS Cache Fusion

Oracle 10g Grid Computing with RAC

Grid Computing RAC Application Deployment	RAC Grid Suitability
Online Transaction Processing Users DW	SAP Real Application Clusters
Simplifying OLTP Data Warehousing DW	Clusters Oracle RAC SAP

Simplifying MCOD VLDB E-business	Deployment SAP MCOD
RAC Suitability Scalability Shared Servers	Performance Considerations Siebel
Cache Fusion Horizontal Scalability	Siebel e-business RAC

Unpredictable Loads	Oracle eBusiness Suite Applications
Unpredictable Load	Oracle eBusiness Suite
High Availability Transparent Application	Middleware Software

OLTP Application Exclusive Specific Data	JDBC Connectivity JDBC Thin Driver
Data Warehousing Applications Parallel	Keyword-Value Pair List JDBC Thin Driver
Data Warehousing DW Real Applications	JDBC Oracle Call Interface Driver

Deployment Parallel Instance Groups	JDBC Server-Side Internal Driver Java
Parallel Instance Groups	WebLogic RAC Database tnsnames.ora
	Application Deployments Suitability

Oracle 10g Grid Computing with RAC

Grid Integration Technologies Architecture	RMAN Convert Files
Framework Control ASM	v$transportable Tablespaces
Grid Enabling Portable Clusterware	RMAN Convert Tablespaces

Infiniband Interconnect Database	Transportable Tablespaces Cross-Platform
Database Resonance Job Scheduler	Transportable Tablespaces RMAN
Cross-Platform Transportable	Bigfile Tablespace Smallfile

Platform Endianness	Bigfile Tablespace ROWID
Transporting Tablespaces Platform Endianness	ROWID Data Dictionary
Cross-Platform Transportable Tablespaces	Bigfile Tablespace ROWID

RMAN Convert Clause	Data Pump Utilities dbms_datapump
RMAN Convert Clause	Data Pump Utilities External Table
RMAN Convert Clause Restrictions	Master Table

Web Master Job Interview

t_webmasterjob_25_html_tag_	t_webmasterjob_37_n12br_function_
t_webmasterjob_26_quotation_marks_	t_webmasterjob_38_integer_time_
t_webmasterjob_27_post_get_method_	t_webmasterjob_39_$_post_superglobal_

t_webmasterjob_28_php_array_	t_webmasterjob_40_cookie_
t_webmasterjob_29_array_function_	t_webmasterjob_41_dreamweaver_
t_webmasterjob_30_key_numbers_	t_webmasterjob_42_png_gif_files_

t_webmasterjob_31_php_tags_	t_webmasterjob_43_title_page_
t_webmasterjob_32_standard_data_types_	t_webmasterjob_44_image_web_page_
t_webmasterjob_33_php_variables_	t_webmasterjob_45_broken_links_

t_webmasterjob_34_dot_operator_	t_webmasterjob_46_database_systems_
t_webmasterjob_35_counted_loops_	t_webmasterjob_47_dreamweaver_url_
t_webmasterjob_36_type_specifiers	t_webmasterjob_48_url_parameter_

Web Master Job Interview

t_webmasterjob_145_java_j2ee_	t_webmasterjob_157_programs_imports_
t_webmasterjob_146_java_certifications_	t_webmasterjob_158_command-line_utility_
t_webmasterjob_147_relational_database_	t_webmasterjob_159_name_method_jvm_

t_webmasterjob_148_application_servers_	t_webmasterjob_160_main_method_
t_webmasterjob_149_java_development_	t_webmasterjob_161_signed_integral_
t_webmasterjob_150_version_control_	t_webmasterjob_162_java_applications_

t_webmasterjob_151_highest_education_	t_webmasterjob_163_system.out_
t_webmasterjob_152_public_classes_	t_webmasterjob_164_string_object_
t_webmasterjob_153_statements_declarations_	<