Tag Info

Hot answers tagged

4

Assuming that your database character set is AL32UTF8 (if there is a difference between the two, this is almost certainly your character set) and that all the data is characters that exist in the US7ASCII character set ("english" might constitute more than that depending on the definitions we're using) there won't be any noticable performance differences ...


3

This is in fact a bug: Materialized View Log (Mlog$) Index Not Created in its Default Tablespace (Doc ID 1959658.1). Excerpt: The index created when a materialized view log is created appears to be created in the user's default tablespace rather than the same tablespace as the MV log table. Additionally, if the user has no quota on their default ...


3

In the simplest case, when you restore a database, you tell RMAN to recover it to the most recent point in time by applying all the redo (archived and online) that is available. That will re-apply any statements that were executed during normal database operations including things like dropping tables and deleting data. If you want to restore a database to ...


2

The Instant Client is easier to install and more lightweight. It doesn't even need to be installed, you can just unzip it and use it. You don't need an Oracle Home either. On the other hand, it does not support deprecated features like Oracle Names. If you don't need any feature the instant client omits, I suggest you use it. It looks like you are covered ...


1

Are you using Enterprise Edition? It looks like this is a EE feature: http://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm CTRL + F the docs and search for result cache and supported editions.


1

The only difference between the two queries is that the 2nd will always return 1 row. Even if the table is empty or just has 0 rows with reference=X, the result will be 1 row with null in the min(date) column. The first query will return no row in this case. The and rownum=1 is useless and does not affect anything for the specific query. Test at SQLfiddle. ...


1

You can use a hierarchical query to generate a sequence of dates, something like this: insert into my_table (my_date_column) select dt + (level - 1) from (select date '<your start date>' dt from dual) connect by dt + (level - 1) <= date '<your end date plus 1 day>'; Date arithmetics: dt + (level - 1) -- are smart enough to know when one ...


1

The lsnrctl utility sends commands to the listener process. If one sends the stop command to a listener process, the process shuts down. The listener program does not kill the process, but the process shuts down. If a unix process shuts down its process id will be removed from the process list. All fgiles locked or opened by the process will be closed by the ...


1

The procedure is described in the Remote Startup of a Database Instance part of admin guide for BS2000/OSD (I can't find this part in the Linux docs...). Essentially what you do is: Create an Oracle password file for your database if you haven't already done so Add a static registration for your instance in its listener Set the instance parameter ...


1

You can query v$sqlarea, which holds sql history for a little longer than v$sql (holds info only about current running sql). Both have similar columns, but depending on the report you want to extract, you might wanna join v$sqlarea with other views. But V$sqlarea is also limited to a period of time, and if you need to go more in depth, the view is ...


1

You link to a FAQ that says The Instant Client libraries occupy a virtual address space that is equal to the size of the files. However, only frequently used error messages from the libraries occupy physical memory. Under most cases, the physical memory load is a few kilobytes despite the larger reserved virtual address space This isn't saying ...



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