Tag Info

Hot answers tagged

4

As always: it depends. However in most cases the default values are adequate. The business requirement of handling 50 concurrent inserts (transactions) alone does not imply the need for setting INITRANS 50. Are they really that concurrent? Will the duration of the transactions overlap each other so they really happen at the same time? All the 50? INITRANS ...


4

It gives an error: ORA-01790: expression must have same datatype as corresponding expression From the documentation for UNION: The corresponding expressions in the select lists of the component queries of a compound query must match in number and must be in the same datatype group (such as numeric or character). Tested at SQLFiddle


2

You have a few options: Transactional replication: this has been around for quite some time and works nicely within its narrowly defined scenario. Unfortunately, the use of non-SQL Server subscribers is deprecated. Change data capture + SSIS: this is the Microsoft recommended solution. It's a bit more involved than replication (to me anyway) but it's also ...


2

Yes, you can specify the SQL_ID. The usage would be something like this: SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('gwp663cqh5qbf',0)); To find the SQL IDs for the current session, you'll first need to get the SID for your session, and then search v$session for the related SQL_IDs: select sys_context('USERENV','SID') from dual; select SQL_ID from ...


1

This error code [ORA-01654] means the server has failed to allocate an extent of the required number of blocks for an index segment in the specified tablespace. As you have said you have got 13 datafiles in your tablespace, you are using small file tablespace. In order to get rid of this error you can simply add data file using ALTER TABLESPACE ADD DATAFILE ...


1

In addition to someone doing full table locks, there are two other things that I can think of. If you have a table where there are several columns that have a parent child relationship to the same column in a child table and if the child column is not indexed, then indexing it could help. I had a case with an online content management system that had ...


1

It may depend on whether you are using connection pooling or not. Also, do you realise LOGON and LOGOFF for a session are recorded in the same audit row? So here the LOGON is showing how many are still logged on right now. Consider the following scenario. SQL> connect / SQL> select ACTION_NAME, username, count(*) from dba_audit_session group by ...



Only top voted, non community-wiki answers of a minimum length are eligible