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 derfloh 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. ThomVF

    UDB AIX replication

    Considering using UDB V8 replication AIX-to-AIX. I wanted to do a check with some of you who may have implemented it, to see if there was a positive pattern of stability, accuracy, etc. (versus being error-prone) with this product before I start charging head-in. Thanks Thomas V. Flaherty...
  2. ThomVF

    how can i calculate the buffer write ratio?

    Try reading into "MTTR Advisory" in the Performance Tuning Guide: Mean Time to Recover (MTTR) Advisory Starting with Oracle9i Release 2 (9.2), MTTR advisory is available to help you evaluate the effect of different MTTR settings on system performance in terms of extra physical...
  3. ThomVF

    materialized view - subquery not allowed

    What refresh method are you trying to use? Please provide some sample code.... Thomas V. Flaherty Jr. Birch Hill Technology Group, Inc. http://www.birchhillgroup.com
  4. ThomVF

    ORACLE9i Recursive SQL error with Partitioned tables

    ...or view does not exist I checked and the partition was there and I could successfully select the count from that partition using: select count(*) from <table> partition (<partition>); I also tried adding the &quot;RESUSE STORAGE&quot; to the truncate option but that did'nt change anything...
  5. ThomVF

    Materialized Views

    Anyone have any useful experience with MVs in 9iR2? I cannot get a FAST refresh to work with an Outer-Join non-Aggregate MView. The Explain_MView results say &quot;the unique constraints does not exist on the join columns of the inner table&quot; when I clearly have a Primay Key (Unique)...
  6. ThomVF

    Using Aggregation in SQL queries from VB to Action Request System

    Your syntax looks ok. The fact that you have quotes around the column with spaces is a good thing. Have you tried aggregating on a different column...one that has a name with no spaces, just in case that's the problem? If so, maybe your ODBC driver is outdated? Thomas V. Flaherty Jr. Birch...
  7. ThomVF

    Alter sequence

    In order to reset the starting number, you have to drop and recreate the sequences. You cannot do this using ALTER SEQUENCE. Thomas V. Flaherty Jr. Birch Hill Technology Group, Inc. http://www.birchhillgroup.com
  8. ThomVF

    agregate fctions for Strings?

    Since you dont know how many words there are in each message (I'll also assume that each Message can have a variable number of words), you probably have to do this in a procedural fashion. I can show the pseudo-code/logic but I do not know Access well enough to tell you it can be done. It...
  9. ThomVF

    oracle instance running ??

    A quick check on Solaris is: $ ps -aef | grep pmon ecomdbdev50% ps -aef | grep pmon oracle 1609 1 0 Sep 06 ? 0:00 ora_pmon_<instance> As you can see, any results that come back will tell you what instances are running. If you cannot connect, this is one way. Thomas V...
  10. ThomVF

    RWRBE60.exe error

    Another FAQ entry... http://bizforums.itrc.hp.com/cm/QuestionAnswer/1,,0x32234b3ef09fd611abdb0090277a778c,00.html Thomas V. Flaherty Jr. Birch Hill Technology Group, Inc. http://www.birchhillgroup.com
  11. ThomVF

    RWRBE60.exe error

    Seems to be coming from Dr. Watson, related to possible incompatibility with printer drivers? http://www.orafaq.com/msgboard/windows/messages/747.htm Thomas V. Flaherty Jr. Birch Hill Technology Group, Inc. http://www.birchhillgroup.com
  12. ThomVF

    Migrating an 8.0.5 database to 8.1.6

    I suggest you also go through this manual carefully. http://www.znow.com/sales/oracle/server.816/a76957/migupgra.htm#6967 Tom Thomas V. Flaherty Jr. Birch Hill Technology Group, Inc. http://www.birchhillgroup.com
  13. ThomVF

    Migrating an 8.0.5 database to 8.1.6

    Some help with manually migrating from 805 to 816 (my preferred method). I personally don't see a need to export/import to migrate: http://www.bijoos.com/oratom/ot_200101.htm Also, a bug affecting some upgraders to 8.1.6 http://www.evdbt.com/upg816bug.txt Tom Thomas V. Flaherty Jr. Birch...
  14. ThomVF

    Explain Plan

    Not sure how far you have gone, so I'll start from square-1. You need to create the PLAN_TABLE, which holds the execution plan details for a query you want to analyze. The script to do this is found in: $ORACLE_HOME/rdbms/admin/utlxplan.sql Once you have this table in place, you need to add...
  15. ThomVF

    Analyze statistics

    You can use the following procedures from within the DBMS_STATS package to view statistics: DBMS_STATS.GET_COLUMN_STATS DBMS_STATS.GET_INDEX_STATS DBMS_STATS.GET_TABLE_STATS Thomas V. Flaherty Jr. Birch Hill Technology Group, Inc. http://www.birchhillgroup.com
  16. ThomVF

    Analyze statistics

    You can use the DBMS_STATS package to view the statistics stored in the data dictionary or in a statistics table. You can also query these data dictionary views for statistics in the data dictionary: Table stats: select user_stats,last_analyzed,num_rows,blocks,avg_row_len from...
  17. ThomVF

    Performance

    ...CPU): This example assumes you have 4 or more CPUs ==================================================== ALTER SESSION ENABLE PARALLEL DML; insert /*+ parallel(table1,4) */ into table_1 select /*+ parallel(table2,4), parallel(table3,4) */ tbl2.column_a, tbl3.column_b...
  18. ThomVF

    DB creation problem

    From: http://developer.netscape.com/docs/manuals/pubxpert/pub25/Gs/ndxBOracleInst.htm Edit the /etc/system file to allocate shared memory and semaphores for Oracle. Choose a value for shminfo_shmmax that is appropriate for your machine and the memory you want to use for Oracle shared memory...
  19. ThomVF

    Ora-1654 unable to extend index by 12800 in tablespace

    From ORACLE docs: ORA-01654 unable to extend index string.string by string in tablespace string Cause: Failed to allocate an extent for index segment in tablespace. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. The tablespace where...
  20. ThomVF

    List of Required Items in a DB

    For a robust, good relational design, you need 3 tables (you can show the data from these 3 tables in a single form but do not confuse data design with application/form design - they are 2 entirely different things). Table#1: Employee EmpNumber -- this is the key value, a 'natural' key if...

Part and Inventory Search

Back
Top