Navigation |
archivesONLINE RESOURCE FOR HELP DESK SOFTWAREONLINE RESOURCE FOR HELP DESK SOFTWARE ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^ [link] Internal SQL statements tracerHi. Here is an utility I wrote and use, maybe someone else will find it useful too. Oracle SPY -- Dennis Yurichev <den...@conus.info> [link] This is win32 utility which intercepts internal Oracle RDBMS function calls to rpisplu(), kprbprs(), opiprs() and OCIStmtPrepare() - all these 4 functions used in internal SQL processing. All they are TERM setup problem with sqlplusHi system info: SQL*Plus: 10.2.0.1.0 Oracle Database 10g 10.2.0.1.0 problem: when I use my X terminal to connect to the server and use sqlplus I have no problems, but I have started using SSH and find that when I try to use the backspace or delete key that I get control characters appearing Eg SQL> this ^H How do you change log_archive_dest_X when using the DG Broker...?10.2.0.3 EE on Red Hat EL 4 How can you update the log_arc_dest parameters on a database which is managed by the Data Guard Broker... I've tried using the dgmgrl as follows: dgmgrl / DGMGRL> edit database "XXX" set property 'initialconnectidentifier'=<ne w setting>; but this makes no difference to the parameter. ORA-04021: timeout occurred while waiting to lock objectDear gurus, I had this message when i tried to export a schema, please tell me why this happens? i ran this script, exp schema/schema@sid file=schema.dmp thanks OracleXEHi there! will anyone help me with OracleXE? the problem: web server running Bitrix over OracleXE, web site is very small but DB size has reached the limit of 4Gb. Size of all tables, acordig to Oracle XE web interface is less then 300Mb but SYSAUX is more then 4Gb. what's wrong with it? how to find storage SQL%BULK_EXCEPTIONOracle 10.2.0.3.0 Windows 2003 Server I'm trying to write a procedure where I'd be passing in the SQL%BULK_EXCEPTIONS collection but I'm not having any luck. I tried defining a record type and then a table type based on that record to use in my parameter list but I received an error saying the SQL%BULK_EXCEPTIONS parameter was of a wrong type. |
SearchFree Online File ConvertersBrowse archivesRecent posts
|