Wednesday, May 31, 2006

Free e-book "1000 Java Tips"

"1000 Java Tips" eBook is huge collection of big and small Java programming articles and tips. You need latest version of Acrobat Reader to be able to read it, because the content is digitally signed. The size of "1000 Java Tips" e-Book is 856 pages of A4 format!

Take your copy here [35MB].

Saturday, May 27, 2006

Tips & Tricks

Q.: How to see installed options like Oracle Text,OLS etc.
A.: select * from v$option

Read more

On my XE the result was:
(54 rows returned)

Real Application ClustersFALSE
Advanced replicationFALSE
Bit-mapped indexesFALSE
Connection multiplexingTRUE
Connection poolingTRUE
Database queuingTRUE
Incremental backup and recoveryTRUE
Instead-of triggersTRUE

Oraspeed 2.7

Oraspeed 2.7 has been released.
Features: Using this Oracle IDE you can write and test Queries. Create, Compile, Execute and Debug your PL/SQL Programs. Execute Anonymous PL/SQL Blocks. Create/Edit Database object using advanced wizards. TKProf, PL/SQL Profiler, Parent Child Tables Data Explorer,Built-in reports, BLOB Editor and much more.

Interesting thing is how these products compare to Oracle's free SQLDeveloper or Qwest's TOAD. Any comments?

Project Lockdown by Arup Nanda

Article Abstract:

(Arup Nanda) Imagine that you have just landed a new job as a DBA. On your first day, you hear rumors of an impending security audit driven by Sarbanes-Oxley requirements. You need to get to know your environment as soon as possible, so you know where to look and understand when to take immediate or preventive action.


Thursday, May 25, 2006

DBA Interview Questions

  1. Explain how you would restore a database using RMAN to Point in Time?
  2. How does Oracle guarantee data integrity of data changes?
  3. Which environment variables are absolutely critical in order to run the OUI?
  4. What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
  5. Why does Oracle not permit the use of PCTUSED with indexes?
  6. What would you use to improve performance on an insert statement that places millions of
    rows into that table?
  7. What would you do with an "in-doubt" distributed transaction?
  8. What are the commands you?d issue to show the explain plan for "select * from dual"?
  9. In what script is "snap$" created? In what script is the "scott/tiger" schema created?
  10. If you?re unsure in which script a sys or system-owned object is created, but you know it?s in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
  11. How would you configure your networking files to connect to a database by the name of DSS which resides in domain
  12. You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
  13. I have my backup RMAN script called "". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
  14. Explain the concept of the DUAL table.
  15. What are the ways tablespaces can be managed and how do they differ?
  16. From the database level, how can you tell under which time zone a database is operating?
  17. What?s the benefit of "dbms_stats" over "analyze"?
  18. Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
  19. You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
  20. How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

from deep Internet

Saturday, May 20, 2006

DB2 Universal Database Version 8.2 for Linux HOWTO

DB2 Universal Database Version 8.2 for Linux HOWTO is intended for anyone interested in installing and using 32-bit IBM DB2 Universal Database on Linux. The information found in this document is based on experiences installing and configuring DB2 UDB Version 8.2.

Friday, May 19, 2006

Freeware Veritas Storage Foundation Basic 4.1

Veritas Storage Foundation Basic
is a free-license version of Storage Foundation, with an optional support subscription. Storage Foundation Basic combines the industry-leading Veritas File System and Veritas Volume Manager, offering a complete solution for heterogeneous online storage management.

System Requirements:
Storage Foundation Basic 4.1 is currently available on Solaris and Linux platforms:
Solaris 10 x64
Red Hat Enterprise Linux 4 32 and 64-bit (Xeon, EM64T and AMD Opteron)
Red Hat Enterprise Linux 4 64-bit (Itanium2)
Novell SUSE SLES 9 32 and 64-bit (Xeon, EM64T and AMD Opteron)
Novell SUSE SLES 9 64-bit (Itanium2)

Veritas Storage Foundation Basic
jest darmową wersją znanego na całym świecie pakietu Storage Foundation. Wersja Basic łączy w sobie cechy Veritas File System and Veritas Volume Manager - dzięki czemu stanowi kompletne rozwiązanie dla ochrony danych.

Tuesday, May 09, 2006

ApEx 2.2 Evaluation

Looks like the ApEx folks have an Evaluation Version of ApEx 2.2. There are also some new icons and themes... more and more.

Apex 2.2 update

Here are some other new or improved features in APEX 2.2:
  • Application Deployment Packaging
  • Component Attributes Screens (eg Regions, Items, Computations, & Processes)
  • Copy Application Feature
  • Finder Utility
  • Monitoring - Application Reports
  • Timestamp support
  • Report Attributes Page
  • Improved Page Debug Messages
  • Re-Ordering Widgets
  • Online Help