Welcome to the home of one of Cincinnati's premier professional organizations, the Greater Cincinnati Oracle User Group (GCOUG). ABOUT US...

Sponsor GCOUG


Big Thanks to our Meeting Sponsors!


Vendor Sponsors Links

Ensure that a devoted audience of Oracle users sees your products via website advertising on the homepage of www.gcoug.org. This highly visible promotional vehicle enables your message to achieve a solid ROI for your campaign. Lean more by downloading the sponsorship brochure above.

Upcoming Meeting


No events to display at this time. Check back soon!

Ask Tom

  • Finding the number of rows in each table by a single sql

    hi tom i have a databse with 125 tables. i can find the total number of tables of the database by the sql select * from tab; now i would like to know the number of rows in each table of my database with out executing select count(*) from...; each time. please help me sincerely rajesh

  • Difference between Full Index Scans and Fast Full Index Scans

    Hi Tom, What is the difference between Fast Index Scan and Fast Full Index Scan ? As per oracle documentation, A full scan is available if a predicate references one of the columns in the index. The predicate does not need to be an index driver. A full scan is also available when there is no predicate, if both the following conditions are met: ? All of the columns in the table referenced in the query are included in the index. ? At least one of the index columns is not null. A full scan can be used to eliminate a sort operation, because the data is ordered by the index key. It reads the blocks singly. Fast full index scans are an alternative to a full table scan when the index contains all the columns that are needed for the query, and at least one column in the index key has the NOT NULL constraint. A fast full scan accesses the data in the index itself, without accessing the table. It cannot be used to eliminate a sort operation, because the data is not ordered by the index key. It reads the entire index using multiblock reads, unlike a full index scan, and can be parallelized. You can specify fast full index scans with the initialization parameter OPTIMIZER_FEATURES_ENABLE or the INDEX_FFS hint. Fast full index scans cannot be performed against bitmap indexes.A fast full scan is faster than a normal full index scan in that it can use multiblock IO and can be parallelized just like a table scan . I am not clear about this.Could you please clarify. Regards; Gopal

  • Converting CLOBS TO VARCHAR

    Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors

  • IN (vs) EXISTS and NOT IN (vs) NOT EXISTS

    Hi Tom, Can you pls explain the diff between IN and EXISTS and NOT IN and NOT EXISTS. Because I have read that EXISTS will work better than IN and NOT EXISTS will work better than NOT IN (read this is Oracle server tunning). Regards, Madhusudhana Rao.P

  • ORA-12560: TNS:protocol adapter error

    i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating ORA-12560: TNS:protocol adapter error what should i do? please help.. (scotttiger)

ONT Security Alerts