dba-oracle.com
Foreign key on delete cascade tips
http://www.dba-oracle.com/t_foreign_key_on_delete_cascade.htm
Search BC Oracle Sites. Foreign key on delete cascade tips. Oracle tips by Burleson. January 6, 2015. Can you give me some tips on when to implement the. Feature of a foreign key constraint? Depends on the design of your application. You have three choices for managing deletes on Oracle foreign key constraints:. Add foreign key (col1). On delete no action;. Add foreign key (col1). On delete restrict;. Add foreign key (col1). On delete cascade;. However, you can also implement on delete cascade. And you d...
dba-oracle.com
Materialized View Fast Refresh Performance Tips
http://www.dba-oracle.com/t_materialized_view_fast_refresh_performance.htm
Search BC Oracle Sites. Materialized View Fast Refresh Performance Tips. Oracle Tips by V.J. Jain. Materialized View Fast Refreshes are Slow. By VJ Jain, July 2015 ( varun.jain@varunjaininc.com. Varun Jain, Inc. (an Oracle Partner). A materialized view that is verified to be fast refresh should update relatively fast. But what happens when there are few changes to the master table, no network issues, no aggregation in the snapshot query and the refresh still runs slow? And DBMS ADVISOR.TUNE MVIEW. Provid...
dba-oracle.com
Optimize Oracle SQL*Loader (sqlldr) Performance
http://www.dba-oracle.com/t_optimize_sql_loader_sqlldr_performance.htm
Search BC Oracle Sites. Optimize Oracle SQL*Loader Performance. Is flexible and offers many options that should be considered to maximize the speed of data loads. These include:. Use Direct Path Loads. The conventional path loader essentially loads the data by using standard insert statements. The direct path loader ( direct=true. Sql must be executed. Disable Indexes and Constraints. Use a Larger Bind Array. Parameter. The bind array's size is equivalent to the number of rows it contains ( rows=. Availa...
dba-oracle.com
BC: USA's largest independent provider of Oracletraining
http://www.dba-oracle.com/training.htm
Search BC Oracle Sites. BC - Oracle Training Experts. Burleson Oracle training wrote the book on custom Oracle training classes. Our instructors have authored more than 50 bestselling Oracle books and our instructors have dedicated their professional careers to training Oracle professionals. Custom Oracle Training Classes. Oracle eBusiness Suite Training. Download Oracle Training Catalog. We Guarantee Your Oracle Training Success. All Burleson Oracle Training instructors are seasoned Oracle professionals...
dba-oracle.com
Avoiding bad Oracle advice on the web
http://www.dba-oracle.com/t_avoiding_bad_Oracle_advice_internet_web.htm
Search BC Oracle Sites. Avoiding bad Oracle advice on the web. Oracle tips by Burleson. April 20, 2015. Avoiding bad Oracle advice on the web. As a matter of practical reality, we must now take the time to evaluate the credibility of any Oracle technical content that you find on the web. Are the publications of an Oracle "Expert" the pontification of an experienced consultant or the ruminations of an elementary-school dropout? Frankly, we need to know. We m ust beware of dangerous Oracle impostors. The b...
dba-oracle.com
Professional dress code and Tattoos
http://www.dba-oracle.com/dress_code_tattoos.htm
Search BC Oracle Sites. Professional dress code and Tattoos. Business Tips by Burleson Consulting. With today's strong interest into Body Art, the question arises as to how people with tattoos can advance within American professional careers. Some corporations maintain a strict policy against visible tattoos, especially companies that must make a good impression on the general public. Tattoos have a curious history. Today, a prejudice still exists within corporate America about tattoos. Don't kid yoursel...
dba-oracle.com
Wait events with v$system views
http://www.dba-oracle.com/concepts/query_wait_events.htm
Search BC Oracle Sites. Wait events with v$system views. Oracle Tips by Burleson Consulting. What waits are occurring in your database? In our final example of the power of the V$ tables, we can see what waits are happening in our database. Waits are conditions where a session is waiting for something to happen. Waits can be caused by a number of things from slow disks, to locking situations (like the one we saw above) to various kinds of internal Oracle contention. 3 From v$system wait class. Commit 892...
dba-oracle.com
Oracle SQL*Plus Copy Command
http://www.dba-oracle.com/tips_oracle_copy_examples.htm
Search BC Oracle Sites. Oracle SQL*Plus Copy Command. Oracle Tips by Burleson Consulting. NOTE: MOSC Note 171870.1 says that the COPY command is deprecated as of Oracle 10g, use data pump instead . . The SQL*Plus COPY command can copy data between two databases via SQL*Net. The preferred method of doing this is to use SQL*Plus on the host where the database resides. If performing the copy. Command from a client SQL*Net connection, the data is transferred through the client machine. The action can include:.
dba-oracle.com
Oracle Portal Support Training & Consulting
http://www.dba-oracle.com/developer/dev_Oracle%20_Portal_support_consulting_training.htm
Search BC Oracle Sites. Oracle Portal Support and Training. BC provides complete support for Oracle Portal. From a one-time issue to complete Portal development, BC provides Oracle Portal support and consulting customized to your needs. You choose your level of Oracle Portal support:. BC Portal consultants can quickly customize your existing application to enable Oracle's powerful web features. Burleson is the American Team. Anyone considering using the services of an Oracle support expert should indepen...
dba-oracle.com
Oracle UNIX consulting
http://www.dba-oracle.com/unix_oracle_consulting.htm
Search BC Oracle Sites. Expert Oracle UNIX Consulting. BC offers expert Oracle and UNIX consulting services for all dialects of UNIX, including HP-UX, IBM AIX, Sun Solaris and Linux. All Oracle UNIX services are performed by a Oracle Certified professional with more than a decade of IT experience. We offer instant remote Oracle UNIX support via ssh and VPN and can help with any Oracle UNIX issues, including emergency recoveries. Oracle installation on UNIX. UNIX Oracle performance monitoring and tuning.