Oracle
in [SQL]
|
dbms_stats.gather_schema_stats with the option gather_auto Hi, is there a possibility to use the dbms_stats package on schema level to just see which tables would be affected by the gather_auto option? I want first see which tables would be analyzed depending on the output I want to start the dbms_stats package for this schema, or maybe just for some less tables of th... 24 Jun 2008 11:16
Splitting Double Quoted String with Delimiters to Single Quoted character arrays. Hi, I need to create a function that does the following. I/P is "LONDON,CHICAGO,SANFRANCISCO" O/P is 'LONDON','CHICAGO','SANFRANCISCO' This is the function that i require. The function must be able to run even with a select statement. and also with user defined parameters... like... join(assuming this ... 23 Jun 2008 09:38
How can I alter the parameter nls_sort I used "alter system set nls_sort = binary_ci scope = spfile" to change the default value of the parameter nls_sort.Then I restarted the service of the database instance.I saw the instance value has changed.Now the problem is when I create a new connection the value of nls_sort was not binary_ci but binary.I don't ... 24 Jun 2008 04:06
Unifying Temp table behavior across oracle, mssql Hi, I have an java application with a common persistence layer that now has the need for temporary tables. The need has arisen basically because we often need to do IN on large java arrays, and are hitting the bounds on the IN (1, 2, ... 1000s) for both oracle (max 2000 items in an in expression) and mssql (our... 23 Jun 2008 14:47
Heteregenous connections client ==> oracle database ==>sqlserver On Fri, 20 Jun 2008 09:57:13 -0700, Mark D Powell wrote: Chris, if you have both database versions 8.1.x and 9.x running on the same server I would just use the 9.x listener to listen for all databases. We have always just used the highest version listener to handle all databases on the server so unless ... 21 Jun 2008 14:48
Account to install Oracle with on Windows platform On Jun 12, 7:25 pm, sybra...(a)hccnet.nl wrote: On Thu, 12 Jun 2008 13:34:55 -0700 (PDT),macdba321 <macdba...(a)gmail.com> wrote: Folks, I have always worked on Sun/HP platforms in the past. There it was clear to install the Oracle kernel under an "Oracle" OS account, as opposed to root. ... 2 Jul 2008 10:51
Identifying the MML used for a particular backup set Is there any way to determine from the RMAN catalog what MML was used to create a backup set? We are in the process of switching from TDPO to Net Backup and have both sets of libraries installed. Some of my DBID's have changed over time due to RMAN duplications and this has caused some backup sets to be abandon... 23 Jun 2008 11:41
Ideas on why linux OEL 5.1 server is re-booting? On Jun 13, 8:17 pm, hpuxrac <johnbhur...(a)sbcglobal.net> wrote: One of the systems we are testing on is a quad core xeon 32 gig ram running OEL 5.1 64 bit. I have both 10.2.0.4 64 bit and 11g 64 bit. Using EMC Clariion and ASM. The ASM is running 11g and the database 10.2.0.4. It is a single instance n... 20 Jun 2008 09:09
10G Grid Control Agent Problem Hi, I currently have a Windows 2003 Server running 10G Grid Control Release 4. This will be used to monitor 5 Solaris servers running Oracle 9208. I manually installed the management agent onto one of the solaris servers (thought it was easier than deploying as there are only 5 agents required) and it registe... 24 Jun 2008 21:35
Listing successfull RMAN backups from RC On Jun 10, 4:37 am, wagen...(a)yahoo.com wrote: Hi, Oracle10g 10.2.0.1 (32 bit) - Recovery Catalog version Oracle10g 10.2.0.2 (64 bit) - target database version RHEL AS 4.4 I have a requirement to query the RECOVERY CATALOG schema DIRECTLY and determine the LAST SUCCESSFUL FULL DB backup. I tried ... 20 Jun 2008 08:08 |