toolkit.rdbms-insight.com
Natalka's Oracle DBA Toolkit - Useful Links
http://toolkit.rdbms-insight.com/linkys.php
Natalka's Oracle DBA Toolkit. Helpful Advice and Scripts. Where to Go for Help. Oracle 9i R2 Documentation. Oracle 10g R1 Documentation. Documentation" for a very useful undocumented PL/SQL applied package, DBMS SYSTEM. Windows System Error Codes. Oracle Locking Survival Guide. This is the best Oracle Locking page I've seen. It's clear, comprehensive, provides examples, well organized - just great. Oracle Client/Server Interoperability Matrix. Oracle on Windows Administration Page. With us on his blog.
toolkit.rdbms-insight.com
Natalka's Oracle DBA Toolkit
http://toolkit.rdbms-insight.com/scripts.php
Natalka's Oracle DBA Toolkit. DB Creation and Configuration. Space and Object Monitoring. Delete duplicates from a table. Use DBMS SCHEDULER to schedule jobs. Set up X forwarding over SSH. Necessary for installs, OEM, etc. Extract SID, Host, Port, etc. from Names Server data. In nice tabular format. Extract a tnsnames.ora from Names Server region database. Harness the power of dbms job.SUBMIT. Eg to run a job every Tuesday and Thursday at 1:45. Starting and Stopping the Oracle Service (Windows). Check yo...
toolkit.rdbms-insight.com
Natalka's Oracle DBA Toolkit
http://toolkit.rdbms-insight.com/publs.php
Natalka's Oracle DBA Toolkit. For the latest on my articles, publications and presentations, check out the News. Section of my home page. RAC / High Availability. 10gR2 New Features: RAC Enhancements. On OraFAQ.com, Jan. 2006. To Manage Your 10g RAC Database. On OraFAQ.com, Aug. 2005. On OraFAQ.com, Jul. 2005. Write Time Zone Aware Code in Oracle. On DevX.com, Feb. 2006. The Oracle 10g Data Pump API Speeds Up the ETL Process. On DevX.com, Jan. 2006. On DevX.com, Nov. 2005. On OraFAQ.com, Oct. 2005.
toolkit.rdbms-insight.com
Natalka's Oracle DBA Toolkit
http://toolkit.rdbms-insight.com/quicktips.php
Natalka's Oracle DBA Toolkit. How to close a database link:. Alter Session Close Database Link. Or DBMS SESSION.CLOSE DATABASE LINK (dblink VARCHAR2);. JDBC Connect String (Thin):. JDBC Connect String (Thin) with Load Balancing / Failover:. To enable load balancing or failover, stuff the entire (DESCRIPTION= ) from the tnsnames.ora into the "host" field of the JDBC connect string, like this:. Warning: WebLogic says that (LOAD BALANCE=YES) can cause problems. (FAILOVER=YES) should be fine. Mts dispatchers...
toolkit.rdbms-insight.com
Natalka's Oracle DBA Toolkit
http://toolkit.rdbms-insight.com/index.php
Natalka's Oracle DBA Toolkit. This is a collection of scripts, tips, and tricks that I use as an Oracle database administrator, analyst and architect. Scripts for DB administration and programming, in the following categories:. Space and object monitoring. Quick one-liners, examples of correct syntax and configuration. How to close a database link. JDBC Connect String (Thin). Enable SQL statement tracing. Create PFILE from SPFILE, or vice versa. Move a LOB segment or its associated index.
sqlfail.com
SQL puzzles: Which tree am I? – SQLfail
http://www.sqlfail.com/2015/03/30/sql-puzzles-which-tree-am-i
Musings on Oracle and life via the medium of SQL. Database design resources: My reading list. SQL Brainteasers: Guess the Card Game. SQL puzzles: Which tree am I? The following SQL statements are all clues to the names of trees:. Mammals; - #2. Type = 'second person'. Eatomic number = 47. Can you guess them all? Put your answers in the comments :). Where content like :this post;. SQL Brainteasers: Guess the Country. Guess the Film Part 2: Clues to 6 More Films in SQL Form. Posted by Chris Saxon. Correct,...
SOCIAL ENGAGEMENT