Database Versus System Statistics

Aug 26, 2011

In the article regarding gathering CBO Statistics, it states: QUOTE When an Oracle database is created, a job will be scheduled that will generate the database statistics for you. You will still need to collect system statistics however, as these are not collected by the automatic statistics gathering mechanism.

what is the difference between "database statistics" and "system statistics"? In other words, do I need to run this script for each schema owner in my 10g/11g instance?

variable whoami varchar2(20);
begin
select user into :whoami from dual;
end;
exec dbms_stats.gather_schema_stats( -
ownname => :whoami, -
options => 'GATHER AUTO', -
estimate_percent => 15, -
cascade => true).

View 2 Replies


ADVERTISEMENT

Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)

Sep 13, 2013

we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?

View 3 Replies View Related

Server Administration :: Gathering Database Statistics?

Sep 3, 2013

,I need to view database statistics after executing SQL> exec dbms_stats.gather_database_stats;is that really possible? how to check it?

View 7 Replies View Related

Server Administration :: Stale Statistics In Oracle Database?

Jun 7, 2012

Is there any script that give us output of all Stale Statistics in Oracle Database

View 8 Replies View Related

Database Control Versus Enterprise Manager

Mar 11, 2012

I always thought that Database control and Enterprise manager was synonyms...But I am reading a mock about OCA exam and there it said:

QUOTE You just can apply the pacth binaries using the Database Control and with the oPatch utility, but not with the Enterprise Manager...

But to me Database Control and Enterprise Manager are the same thing...

Are there difference between them?

View 1 Replies View Related

Server Administration :: Refreshing Stale Statistics In Oracle Database?

Apr 21, 2010

the importance of refreshing the stale statistics in oracle database and also how often we should do this?

View 3 Replies View Related

Real Application Clusters :: How To Export Database Statistics From Production To Staging

Jun 7, 2013

i am using 11.2.0.3.0 version db on Linux x86 64-bit...how to export the database statistics from Production to staging .

View 9 Replies View Related

Hibernate Optimistic Locking Versus Database Isolation Levels

Jan 26, 2013

Among Hibernate optimistic locking & Database Isolation levels, which one to use? Which gives the better consistency, concurrency and scalability. I read in couple of links that Isolation level will suffer if there is a huge load on the application with multiple users access the appliation at the same time, moreover in islation levels normally we need to look for READ_COMITTED and NON_REPEATABLE_READ to get a better performance? Whether these are true? Whether we can use both Hibernate optimistic locking(version & timestamp) & Database Isolation levels in the same application? What are the implications using these? Which one will be preferred over the other and when?

View 2 Replies View Related

Precompilers, OCI & OCCI :: PRO*C Compiler Version Versus Database Version

Oct 15, 2010

We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.

if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.

Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.

View 3 Replies View Related

Security :: Audit Vault Versus Database Vault

Jan 21, 2011

compare the database vault and audit vault. Is there any relation between them.

Moreover How could I connect two different databases(hosted on Host1 and Host2) Using a Third system having 10g vault installed.

View 8 Replies View Related

Forms :: Picture In Database Or System Folder

Oct 5, 2010

Where should one store pictures in database or read it straight from a folder stored in hard disk and why (performance talking)?

View 4 Replies View Related

OLE DB :: How To Fetch Host Database In System To Run Web Application

Nov 4, 2012

i am having database in server and i have to run my web application in client machine. how to set the connection of server database in web.config file.

View 1 Replies View Related

Forms :: Difference Between System.current_item And System.cursor_item?

Apr 1, 2012

We have system.current_item and system.cursor_item.....

both represent the same....

like this we have few other system variables also .....

what is the main difference between current_item and cursor_item?

View 2 Replies View Related

CPU System Time (percentage) For Multi Core System?

Aug 21, 2012

couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not

CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)

View 1 Replies View Related

Windows :: Installation Process Trying To Create Database On System

Dec 7, 2010

I'm trying to install Oracle10g in win7 Home premium. It is installing but problem is when installation process trying to create database on the system, a message is appearing which telling that ORA-12546:TNS:permission denied.

View 1 Replies View Related

SQL & PL/SQL :: Interfacing Data From Oracle Database To External System

Feb 24, 2012

I have an issue with the text area column(Column name-Text) while interfacing the data from oracle database to external system.The data in database is saved as:

This is test entry for commentfield.
testing the script
Pre-production
23-FEB-2012

We want all the line breaks to replaced with a space or a comma. to implement this i have used to simple select as :

Select Replace(text,chr(10),'')
From paymemo
where referencepkey = (select pkey from paymain where ID = 'DED-520074 505354DN6 2012-02-04 00:06:48');

This is not working because of type conversion issues.

View 6 Replies View Related

SQL & PL/SQL :: Created Trigger On Database Level In System Schema

Jun 10, 2010

I have created trigger on database level in system schema. While i am creating new tables in system schema, trigger logged the entry but when i am creating table in scott schema it is not working for that.

CREATE OR REPLACE TRIGGER ddltrigger
AFTER DDL ON DATABASE
BEGIN
INSERT INTO aud_log
(user_name, ddl_date, ddl_type, object_type,
owner, object_name
)
VALUES (ora_login_user, SYSDATE, ora_sysevent, ora_dict_obj_type,
ora_dict_obj_owner, ora_dict_obj_name
);
END;

View 3 Replies View Related

Server Administration :: Clone Database Cannot Be Connected After System Reboot

Oct 21, 2010

1. I installed oralce with Service_Name=DB1 it works fine,

2. I created another database with dbca named DB2,

3. I connected both system/password@db1 and system/password@db2 without any problem,

4. After rebooting the computer I can connect only the first database DB1 which I installed with Oracle installation. But, I can not connect to the 2nd database which I created with dbca. Error Message Shows: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

DB1 has no problem I can connect to that, but I can not connect to DB2 after rebooting the system. Now I need to know how to connect to DB2.

Quote:

connection messages:
oracle@pc ~]$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 21 12:51:43 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: SYSTEM@DB1
Enter password:

[code]....

View 9 Replies View Related

Forms :: Uploading Image Which Is Not Database Item From Operating System?

Sep 13, 2010

uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.

I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;

But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.

View 1 Replies View Related

Server Utilities :: System Crashed / Dump Database Into PC To Test And Enhance It?

Feb 5, 2013

My system crashed .

I have an application on the server .

I have installed oracle 10g .

how I can dump the database into my PC to test it , and enhance it.

View 9 Replies View Related

Data Guard :: Standby Database - Failure In Processing System Parameters

Dec 6, 2010

I am trying to create standby database on second machine ie. not on my machine. For this i have made added the required parameters in the pfile of the primary database but when I am trying to startup the database using the new pfile I am receiving some errors.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile='E:oracleproduct10.2.0db_1databaseinitden1.ora'
LRM-00101: unknown parameter name 'L0G_ARCHIVE_DEST_2'
ORA-01078: failure in processing system parameters
SQL>

Below are the parameters of my pfile:

*.core_dump_dest='E:oracleproduct10.2.0/admin/den/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='den'
*.db_recovery_file_dest='E:oracleproduct10.2.0/flash_recovery_area'

[code]....

View 10 Replies View Related

Performance Tuning :: Tune Data Coming From Legacy System Into Oracle Database

May 22, 2012

Customer is sending data from legacy system (Source) with the web service which in turn calls a package lying on Oracle server (Target). Now this package is simply inserting data passed by legacy system into master staging table in Oracle database. When they started this process in Sept 2011 then 4 lack records were inserted into staging table. In Oct 11 it was 0 records Nov 11 it was 2 lack records, Dec 11 it was 1 lack records, in Jan 12 it was 1 lac records, Feb 12 73k records, Mar 12 0 records, Apr 12 52k records.

As we see that number of records inserted in the table got reduced with time.. what should be the starting point here since web service is calling that package on the fly, how can i enable trace for that package? I cannot replicate this is Dev as this process is only working in PROD.

View 6 Replies View Related

Server Administration :: Database File System Architecture For Data Warehouseing Application

Mar 14, 2011

Which is the best possible way of configuring the Physical file structure in case of Data Warehouseing application?

I mean to ask you Multiplexing of the data file or control file is required. Or any best possible way to configure Physical file structure.

View 1 Replies View Related

Server Administration :: Database To Startup With PFile - Failure In Processing System Parameters

Feb 8, 2011

I successfully created a DB manually with PFILE.

I want the DB to startup with SPFILE at next login.So i fired the below command.

CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.

But it shows the error as below:

ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.

View 20 Replies View Related

Recovery Manager (RMAN) :: Duplicate Database From ASM To Non-ASM File System To Remote Machine

Aug 30, 2012

I have oracle 11.2.0.3.0 in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?

Can i keep the database name as ASMDB in another Machine ?

View 9 Replies View Related

How To Get I / O Statistics On ASM Diskgroup

Jan 21, 2011

How can we check the I/O statistics on a ASM diskgroup?

Do we have any command which can be run @ sqlplus prompt after logging into the asm instance?

What steps can we take to increase the Read speed and the write speed on the ASM diskgroup.

View 1 Replies View Related

How To Import Questionable Statistics

May 16, 2011

I want to take the statistics of my Production database and import to my local database, to calculate the Production statistics.I have used the statistics=compute, to export statistics. In the log file, for some tables, there was a waring like "exp-00091 exporting questionable statistics"

Is this dump will be useful for me to calculate production statistics?What option i have to use while importing statistics=recalculate or statistics=safe?

View 5 Replies View Related

SQL & PL/SQL :: How To Compute Statistics On Index

Aug 28, 2010

1) Why we need to do Compute Statistic on index.

2) Is it only for optimizer to make a better plan?

3) If yes, which means, optimizer will not able to collect statistic by itself?

4) if I'm not collect statistic, then optimizer will do it or skip.

View 5 Replies View Related

Incremental Statistics Gathering?

Sep 12, 2012

am having Oracle 9i RAC on IBM AIX .

I have large partitioned tables ( 4 partitions are added every month ). Is is possible to collect Incremental Statistics Gathering on these objects ( 9i ). If I collect stats with Ggranularity => ALL and ESTIMATE_PERCENT =100 the stats are accurate but it takes so much time .

One way may be to collect stats as Ggranularity => PARTITION for each new partition ( this quite fast ). but what about the Global Table Stats?

View 7 Replies View Related

Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved