Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jocave

    best practices for security and multiple databases

    There are a couple of options you can use here... 1) Externally authenticated users. Rather than having Oracle managed passwords, user accounts are set up to accept credentials presented by the operating system (i.e. the client Windows machine) to authenticate the user. 2) Oracle Internet...
  2. jocave

    How to cut resources to a particular PROCEDURE ?

    My understanding, though, is that profiles follow the user executing the procedure, not the procedure itself. Thus, if SUPER_USER and LOW_RESOURCE_USER both execute a procedure owned by SUPER_USER, their respective profiles will control the priority, not the profile of the object owner.
  3. jocave

    character Set

    Note that the ALTER DATABASE command will fail unless the target character set is a strict superset of the source character set.
  4. jocave

    How to cut resources to a particular PROCEDURE ?

    Profiles are user-based, not object-based.
  5. jocave

    character Set

    Unless AR8MSWIN1256 is a strict superset of WE8ISO8859P1 (and I don't believe it is), I believe you'll have to create a new database instance and do a full export and import.
  6. jocave

    Oracle ODBC Problem

    It appears that you need to update your MDAC. The ODBC Driver Manager that's part of your current MDAC install doesn't know that ODBC 3.52 is a valid version of the ODBC API. You can grab the latest version of the MDAC from http://www.microsoft.com/data Also, if you have the 9.2 Oracle...
  7. jocave

    Java wrapped around C++

    I'd tend to be wary about performance as well. There's a non-trivial overhead for every JNI call, which may tend to make operations that are normally very cheap significantly more expensive. Justin
  8. jocave

    Creating a multi-Valued table in Oracle ver > 8.15 using SQL PLUS

    The standard approach would be to have a separate detail table for this sort of thing, i.e. Table emp has a primary key empno Table emp_phone has a column empno, a foreign key to the emp table, and a phone number column If an employee has only one phone number, there would be only one row in...
  9. jocave

    altering RBS datafiles and rollback segments to avoid ORA-1555

    Why would you be eliminating the optimal option? In most situations I've seen, I'd be for increasing that value, not decreasing it. What sort of activity is your database doing? Are you sure you understand why the ORA-01555 errors are happening? Justin
  10. jocave

    Accessing other databases

    There are a couple of options. First, you can install Oracle Heterogenous Services/ Oracle Transparent Gateway. This allows Oracle to create a database link to non-Oracle databases which you can query just like any other database link. Second, if Interbase provides a type 4 (thin) JDBC...
  11. jocave

    Oracle Client Install

    Start at http://otn.oracle.com (at some point, you'll need a free account if you don't already have one). - Click on the Downloads link in the upper right-hand corner nav bar - Click on the Oracle 9i database (or Oracle 8i if that's the flavor you're after) - Choose the proper operating system -...
  12. jocave

    Advantage of explicite over implicite cursor

    Actually, if anything, implicit cursors will tend to be faster, though this difference is likely to be miniscule. Tom Kyte has a couple of discussions on this http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1205168148688...
  13. jocave

    Oracle Client Install

    For Windows, Oracle does provide a separate client-only download option that's significantly smaller than the full-blown install. You can create a response file for the Oracle Universal Installer that will allow the OUI to be run without human intervention. If you use InstallShield to install...
  14. jocave

    Oracle ODBC Question

    The other option, if there is a type 4 (thin) JDBC driver for Paradox, is to load that driver into Oracle's JVM and write Java stored procedures to access the data. Justin
  15. jocave

    Book for a newbie to Oracle

    What, exactly, are you looking to do with Oracle? Are you looking to learn how to be a DBA? How to develop PL/SQL applications? What sort of a background do you have-- Are you coming from another relational database? Are you familiar with other languages? Did you take some database theory...
  16. jocave

    N single thread processes having better perf than 1 process N threads

    I believe that the OCI_THREADED attribute is required in this situation (but someone taking a detailed look at the OCI Programmer's Reference on http://tahiti.oracle.com might well prove this belief wrong). I would generally think that a 7-8% performance loss would be about right for 4 threads...
  17. jocave

    N single thread processes having better perf than 1 process N threads

    What sort of performance difference are we talking about-- 5% or 50%? In general, since OCI would have to have some sort of locking or synchronization on the environment's data structures, I'd expect that N threads would behave slightly worse than N processes, but that it wouldn't be a...
  18. jocave

    TNSNAMES.ora and SQLNet.ora

    All Oracle's documentation is available at http://tahiti.oracle.com. The 9i Net Services Administrator's Guide http://otn.oracle.com/pls/db92/db92.show_toc?partno=a96580&remark=drilldown&word=tnsnames.ora will have all the information you could hope for. Justin

Part and Inventory Search

Back
Top