Find Answers

Filter Search Results
All Operating Systems:
All Products:

All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML "sqlerrm = ORA-20000: Unable to set values for index [index name]" errors during Data Pump import.
When users import Dimensions CM data into an Oracle 19 database via IMPDP, it may return the following messages: Processing object type DATABASE_EXPORT/ STATISTICS /MARKER [index name] : sqlerrm = ORA-20000: Unable to set values for index [index name]: does not exist or insufficient privileges
CMS-XML KM-Dim8: Tuning Oracle for best performance with Dimensions
Dimensions 6 contains the command pcms_dbstats. This is used to create statistics on all the database schema objects . This is documented in the DBA Guide but basically running pcms_dbstats -e system/<password> will estimate statistics on all the database schema objects.
CMS-XML Dim10: How to maximize oracle database performance
... tables and index statistics , preferably before ... ... indexes and compute statistics for a given ... it on the oracle server (or on an Oracle client PC) ... ... of the current object size) so ... ... tables containing large objects (BLOBs and ... ... and if the statistics are up to ... set cursor_sharing to force (unless the oracle version is less than 9.2.0.6 because of a bug) ... Alternatively, configuring Oracle 10.2 Automatic Memory Management:
CMS-XML KM-Dim7: Oracle Bug 90081 may cause Dr. Watson application errors or core dumps when importing a full system export of an Oracle 8.1.5 database.
DIM: Oracle Bug 90081 may cause Dr. Watson application errors or core dumps when importing a full system export of an Oracle 8.1.5 database. ... a. Export with STATISTICS =NONE. Eg: EXP SYSTEM/MANAGER FULL=Y STATISTICS =NONE ... c. Perform a FULL import rather than importing an individual users objects . If necessary the import can be to a dummy database in order to perform a user level export of the desired schema / objects .
CMS-XML MCLG: Creating and configuring an Oracle database instance for Collage with Oracle 9i or 10g
... creating a new Oracle database instance for Collage ... If the statistics are up to date, it should not cause full table scan unnecessarily. ... to force (unless the Oracle version is less than 9.2.0.6 because of a bug) ... Create a tablespace with block size of 32k, and move all the tables containing large objects (CLOB and BLOB datatype) in this new tablespace. It would be better to have this tablespace layed on its own physical disks apart from the rest of the database.
CMS-XML Dim2009: How to obtain a timed trace of Oracle queries to locate and tune specific problem queries
Determine the Oracle session that we ... ... “Connection Pooling Statistics ”. ... the Connection Pooling Statistics page, use ... Use Oracle sqlplus to locate the Oracle session for this ... ... Dimensions Connection Pooling Statistics page displays a ... ... >@< oracle -sid> ... , insure that Oracle timed_statistics ... ... logged in to Oracle as the SYSTEM ... ... the currently running Oracle , but will ... the next time Oracle is restarted it ... ... initiated from the Oracle SYS account then ... be initiated from Oracle SYSTEM account. ... use the following Oracle query while logged ... ... tracefile, the Oracle utility tkprof is ...
HTML SBM Version Diff
Differences Between Versions ... $IF( ORACLE ) - // Oracle now uses CLOBs ... ... ; // Oracle now uses CLOBs ... { var obj = elements[ ... ... function CheckParentRowVisibility( obj , label) { if ( obj == null ... ... ) { var obj = GetFieldByName( ... ; if ( obj == null ... + var obj = GetFieldByName( ... ... + if ( obj == null ... ... using $( obj ).html ... ... + jQuerySBM( obj ).html ... ... columnSort = new Object (); ... ... function GetParentElement( obj , tagName) ...
HTML SQL*Plus Report
OBJECTS SELECT ALL_ ... ... SELECT CTX_ OBJECTS SELECT CTX_ ... _ OBJECT _CONNECT SELECT ... ... EXECUTE DBMS_ STATS EXECUTE DBMS_ ... ... SELECT IMPDP_ STATS INSERT IMPDP_ ... ... _SRF EXECUTE ORA $BASE USE ... _NODES EXECUTE ORA _DM_ ... _BINNING EXECUTE ORA _KGLR7 ... _CHAR SELECT ORA ... _NT EXECUTE ORA _SI_ ... OBJECT EXECUTE SDO_ ... ... _TOPO_ OBJECT EXECUTE SDO_ ... ... EXECUTE SQL_ OBJECTS EXECUTE SQL_ ... ... _EXPORT_ OBJECTS SELECT TRANSPORTABLE_ ... OBJECTS INSERT USER_ ... OBJECTS SELECT USER_ ...
PDF Scaling and Optimization Guide
... "optimistic" locking method; they ... ... database server running Oracle , complete steps ... 2 Shut down Oracle . 3 Restart Oracle . ... 1 From the Administration Console, select Configuration Object Management | Data format & MIME types. ... 5 If you wish to display server pooling statistics , type the following command at the operating-system prompt (this can be done as either user root or dmsys) getpoolstats ... 5 If you wish to display server pooling statistics , type the following command at theoperating-system prompt
PDF Database Administrator’s Guide
This means that any other database objects owned by that user are also deleted. ...  Create a new empty Oracle database .  Populate a new empty Oracle database with PCMS_SYS user data. ...  Create a Dimensions database within an existing Oracle database and install generic process model from a specified file.  Maintain RDBMS statistics for Cost Based Optimization.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs