Hi Tom,

Can u please provide the sample programs of Stresm in oracle 10g (using two database)I need the coding for how to create databse also.(Fully solved sample program in stem by step procedure)

Thanks and Regards

P.rajasekar

 Lire l'article

  Ask Tom MOST RECENT ARTICLES

These are the questions on Ask Tom that have the most comments

Voir toute l'actualité

16 septembre 2009 : Tricky Trigger Question

I have a trigger for insert on a table. The trigger works like this: if inserting in the id range of 1000000, insert the same line with an id of 20000000. for example: table named test with columns id, notes. id is a primary key and (...)

16 septembre 2009 : 9i: gather_schema_stats, 'GATHER STALE' vs. 'GATHER AUTO'

Tom, what's the difference between 'gather stale' and 'gather auto'? How does auto determine which objects to analyze? Is the *_tab_modifications still being used? Auto seems to pick up on changes much faster than stale... If all tables (...)

16 septembre 2009 : Steps in Tuning

Hi Tom, In one of your followup, you had mentioned that you need to look for queries that perform a large number of logical I/Os. But my understanding is that an I/O is considered as logical I/O if I/O involves a memory access and not a (...)

16 septembre 2009 : Recovery Manager ; Backup/Restore Issue

I tested the following without a catalog database and with a catalog database. 1> The database is in Archivelog Mode. 2> Used the following Recovery Manager scripts to take a full backup. run allocate channel c1 type disk; (...)

15 septembre 2009 : SAN and Oracle databases

Hello Tom, I know this is my second question in a span of a few minutes. I wanted to get a feel from the user community of the best practices in laying out a SAN for the database. Where do the redo logs go? Does one set stay on the SAN (...)

15 septembre 2009 : PreparedStatement Question

Tom, We got the following error yesterday. Error:ORA-04031: unable to allocate 4036 bytes of shared memory. And so I read your responses to these types of questions and understood the importance of using preparedstatements for dynamic (...)

14 septembre 2009 : Recovery following loss of all controlfiles

Tom, I've just put together a hands-on course for new DBAs in order that they can practice various backup and recovery scenarios. Our current techniques are based on UNIX Korn shell scripts (RMAN is a future direction, but not here yet). (...)

9 septembre 2009 : Unused OBJECTS

Hi Tom, We are in a process of removing unused objects(tables/functions/procedures/packages) from the database. Is there any script(suggestions) or short-cut method to find these unused objects(tables/functions/procedures/packages not used (...)

9 septembre 2009 : ora-hash

Hi Tom, I came across one of the Oracle 10G built-in packages called ORA-HASH. I can use it as I would DBMS_OBFUSCATION_TOOLKIT, I believe. Could you, please, give me an example where this package would be most useful. Also, I can't find this (...)

8 septembre 2009 : OLEDB Provider

Sir, Greetings. I would just like to know what is the current release of the OLEDB Provider for Oracle? Do you have any sample codes for visual basic on how to use this OLEDB Provider for Oracle. Thanks. Vince Crismer C. Villena (...)

8 septembre 2009 : Execute SQL Select statement stored in a table.

Hi Tom, I have done the following create table sql_statement(sqlid integer, sqlstmt clob, isselect varchar2(1)) begin insert into sql_statement(sqlid, sqlstmt, isselect) values(1, 'insert into dept(deptno, dname) values(:1,:2)', (...)

8 septembre 2009 : Migration on another server

Hello i wanna know how can i migrate my db (10g or 9i) from current server to another server?(only for changing hardware and server not upgrade software or ...) as i know i can't clone like oracle application (this is a single database with own (...)

8 septembre 2009 : Questions on PCTFREE...

Hi Tom, I have some questions for u... 1. How to calculate pctfree & pctused values before allocating for a table 2. How does PCTFREE value affect row chaining & row migration 3. How to load & retrieve an Image in Oracle Database Thanks a (...)

8 septembre 2009 : Window from pl/sql it's is possible ?

Hello Tom, my english not good, by i try to ask. I need show dialog window using pl/sql procedure. I can do this, and how i can do this if is possible ? I think is possible because exist RAISE_APPLICATION_ERROR, by in my Window i need two button (...)

8 septembre 2009 : Regarding MMR

Hi Tom, Good Day. In my company, in order to replicate data from one database to another, the team has implemented MMR (Multi-Master Replication). However, after implementing this, there seems to be a huge performance issue. For completion of (...)

8 septembre 2009 : Performance - top N query

Hi, Here We are executing a query which returns top 2 salaries dept wise from emp. Query:select sal,deptno from emp a where 2>(select count(sal) from emp where deptno=a.deptno (...)

8 septembre 2009 : Oracle9i, init.ora isn't working

Tom, I've just installed Oracle9i. I changed my init.ora settings but they don't seem to be changing. For example, I set the db_cache_size and shared_pool to a new value and restarted but my SGA size didn't change at all. What's going (...)

7 septembre 2009 : Regarding Partitions

Hi Tom, Good Day. That was a real awesome work you are doing Tom. In my company, there is a product division which has database in Oracle 10g. One of the tables has more than 6 million records and DBA suggested to implement partition. When (...)

7 septembre 2009 : Using CASE/DECODE in constraint

I have created a unique index on a table. Create Unique Index xyz on TableName(Case When col1='T' Then col2 else col3 End); I want to make it defferable to be executed on commit. but i know this option is not available in Idex creation. If I (...)

7 septembre 2009 : accept multiple input from SQL*Plus

Hi, i am writing a PL/SQL block and my requirement is to accept multiple inputs at run time,the number of inputs will be provide at run time eg. 1. enter number: 2 then it will accept 2 number Enter first number: 45 enter secound number (...)

7 septembre 2009 : How to install APEX

I want to learn Oracle Application Express I have download the zip file form oracle APEX site. But unable to understand how to install it in my PC Pleas help me.

7 septembre 2009 : Performance of cascading delete

Dear Tom, I have some questions regarding delete from parent/child tables: 1) When I have a child table partitioned on the foreign key (and a locally partitioned index over that key), will any locks caused by deleting from parent table affect (...)

7 septembre 2009 : Regarding Parallel DML and Usage of Hints

Hi Tom, Good Day. When I was about to tune an application in the current company, I came across this statement in AWR report. INSERT /*+ PARALLEL */ INTO TRADES VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , (...)

7 septembre 2009 : Converting Vertical Rows Into Horizontal Rows

Hi Tom, Good Day. I have an issue, which requires your expert suggestions and comments. In my company, the developers have created a table which is of the following format: Customer Name, Identifier-1, Identifier-2 (other columns are also (...)

7 septembre 2009 : 11g release 2 new features

Hi Tom, Oracle has just shipped 11g release 2 for Linux on OTN. What are your favorites features of release 2 with respect to release 1 ? Thanks.

5 septembre 2009 : Resource Manager

I have read that if a resource consumer group has meore than one plan directives referring to it , it may have more than one max_estimated_exec_time. The Database Resource Manager will then choose the most restrictive of all of incoming (...)

5 septembre 2009 : GetPrivateProfileString call from PLSQL

Hi Tom, I can't read text file in Unicode format, can you help me ? I have problems when I read ini file (text unicode format). In my program, I created a library : create or replace library kernel32 as 'C:\Nist\lib\kernel32.dll'; and (...)

5 septembre 2009 : Monitoring Alert file

Dear Tom, I would like to monitor ORA- messages on a Db whithout having access to the filesystem (to the alert file...) Is there a view which allows that or do you have an idea ? Thanks for your help Marc

3 septembre 2009 : regaring IOTs

Hi Tom, I read your discussions on IOTs in this forum, those are very interesting .In my application i have seen nearly 10 to 20 tables which are having (compoisite primary key (3 to 5 columns) + (1 to 3) columns other than primary key (...)

3 septembre 2009 : Rownum quey with sorting

Hi Tom, I have a query which return millions of record,(as a result of inner join). I am not sure whether the client application will be able to handle these many records at once. I want to partition the query result in a few sets, and (...)

3 septembre 2009 : Explain plan over DB-Link

Hello Tom, this is the first time I'm able to put a question. Thank you! My problem is, that I'm sending a statement via DB-link and I want to know, what execution plan this statement invokes on the remote database Something like (...)

3 septembre 2009 : join double-counting

Tom, I am joining two tables. Table CHARGE can have zero or more rows for each row on the EVENT table. I need to sum up a column from each table, and what is making it interesting is that the group by does not include my join column. If I do a (...)

3 septembre 2009 : DML & Database Trigger

Hi Tom, When a Database trigger invoked by a DML, and when the trigger fails, would the changes of DML will be committed or rolledback?? Thanks, Kandy Train

3 septembre 2009 : SQL*Loader data from first record must be inserted in all rows

Hi. Some data in the first record of my text file (a date), has to be inserted in all rows of the table. How do I create a CTL file for this? The first row of the text-file goes e.g. HEAD20091001. The date (2009-10-01) relates to all the rest of (...)

3 septembre 2009 : Dynamic alter sequence in stored procedure fails

To change an existing sequence via SQLPlus : SQLPLUS>CREATE SEQUENCE HIBERNATE_SEQUENCE START WITH 1000; SQLPLUS>SELECT HIBERNATE_SEQUENCE.NEXTVAL FROM DUAL; NEXTVAL : 1000 SQLPLUS>ALTER SEQUENCE HIBERNATE_SEQUENCE INCREMENT BY 100; (...)

3 septembre 2009 : Consolidating small databases into RAC / 2 Instance environment

Our company is trying to bring around 10 small databases( 1GB) each with its own application, into RAC 11G environment - The idea is to move all these small databases as separate schemas in 1 database, 2 instances /2 node RAC Environment. My (...)

2 septembre 2009 : embedding a variable in a string

After running a proc I wrote I get this error: ORA-01756: quoted string not properly terminated I am writing SQL as a string so that I can embed variables into the the string, like: v_sql := 'insert into... select... etc'; I then execute (...)

2 septembre 2009 : Shared Server connection

Hello Tom, Using shared server conection where do *_AREA (i.e. Hash Area, Sort Area) located? in UGA or PGA if it is located in Process PGA then each call to server may be serve by different server process then who would the new process (...)

2 septembre 2009 : Converting Longs to LOBS

How to I convert my long columns into LOBS?

2 septembre 2009 : SQL In Presentation Layer

Hi tom, We are writing a small application. Which has few screens (Can say as master screens ). The main operation is generally like Add, Modify, Delete and Search. So generally each master screen is goint to be associated with a master table. (...)

2 septembre 2009 : Datafile error and Log Archive

Dear Tomacle, Hope you are well. I have 2 questions: 1. If I want to backup Database in Archive log mode, do I need to backup only archive logs and control files? Do I need redo log files? But I must backup full database ( Offline (...)

2 septembre 2009 : Code Reviews between Java Developers and DBA

Hi Tom, This is a somewhat 'mature' shop, but we are just now in the process of establishing policies, etc. regarding the DBA role in code reviews (and design reviews) with the Java Developers. It is a given that the DBA's should review all (...)

2 septembre 2009 : Getting Foreign and Primary Key syntax from the Database

Hai Tom, Need your help in getting the following syntax. This is the example output which I would like to use for my Database Tables. Are there any built in procedures to be used if so what are they and how to use them. Can this data be (...)

2 septembre 2009 : Shared Nothing (db sharding)

I was recently pointed to the article about DB Sharding (Shared Nothing). http://www.dbta.com/Articles/Editorial/Trends-and-Applications/Database-Sharding--The-Key-to-Database-Scalability--55615.aspx It seems to me a bit like Sharding to Oracle (...)

1er septembre 2009 : Constraints or Triggers

Hi Tom, We have two third-party application, lets us call them appA and appB, data is transferred from app A to B, some columns in appA have length larger than columns in appB because of which sometimes we get the following ORA-12899: value (...)

1er septembre 2009 : Index Organized Tables - when not to use it

Dear Tom, I have a question about Index Organized Tables while reading your book - "Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions". I understand there are situations where IOT has its advantage over (...)

1er septembre 2009 : Performance of IN and ANY

HI Tom This has been a doubt for me from long time, In performance wise which is better among IN and =ANY. why most people tend to use IN rather than =ANY when both does the same. Can you please let me know what is internal logic oracle uses when (...)

1er septembre 2009 : disable/enable indexes every day

Dear Tom, I have a daily process which inserts into table A from table B (table B is accessed via a dblink). In order to make this process fast I am doing this in a package 1. execute immediate 'disable A indexes' 2. insert...

1er septembre 2009 : Executing static insert queries stored in a table in a procedure...

I am currently working on a Oracle procedure that runs 30+ insert queries on a database and populate another database after some calculations are done on the source data. Storing these long insert queries in my procedure will make it very (...)

1er septembre 2009 : Database

Hai Tom, Are there any options in utl_smtp package so that a mail will come back to the sender if mail has not been delivered to the receipient.?

1er septembre 2009 : Queries with OR

Hi Tom, I have a huge table (non-partitioned) with about 400 Million records in it. The structure of table is Create table t_link ( ID Number(38) Primary key, TID1 Number(38) Not null, TID2 Number(38) Not null, Amt (...)

1er septembre 2009 : RMAN MetaData Storage in Controlfile

The question is does 100% RMAN metadata reside in the controlfile even when you are using the RMAN catalog? The question is does 100% RMAN metadata reside in the controlfile even when you are using the RMAN catalog? We are trying to see if (...)

29 août 2009 : internal logic of distinct clause

I have 2 questions for you TOM: 1. ) when a query has a distinct clause on a clomun and the same column is used in the order by clause, will oracle order the data first and eliminate the duplicate or will it eliminate the duplicate records and (...)

29 août 2009 : How to enforce conditional unique on multiple columns

Hi, Tom, I have a table create table project (project_ID number primary key, teamid number, job varchar2(100), status number(1)); status=1 means it is an active project, otherwise it is (...)

27 août 2009 : ora-4068

HI TOM, Tnx for this oppurtunity again, Can You explain how does the ORA-4068 occurs and how can I go about it? How does oracle manages the freelist (8i) on LMT's? And how can we track the freespace, used space, and fragmentation on (...)

27 août 2009 : Explaining tablespace

Hi Tom, I am sorry if this question is stupid. I have read the Oracle doc several times but don't understand local managed & dict managed tablespace definitions.Could you explain more clearly? Thank you very much.

26 août 2009 : v$sqltext issues

Tom, I'd like to see the complete sql_text of statements in the shared pool. v$sql and v$sqlarea only show the first 1000 bytes, but v_$sqltext has the entire statement in 64 byte chunks. I can get what I want with either of (...)

25 août 2009 : capturing business logic validation errors using log_errors

Hi Tom, I have some data that I need to validate with business logic while moving it from a set of tables to a single table. I'm able to use an insert as select statement to get the data from the set of tables to the single table, and I want to (...)

13 août 2009 : PI and CR image of datablocks

Hi Tom, When does Oracle Instance create a Past Image of a datablock and when CR image of datablock in its buffer cache ? Would you please explain it with a small example? Thanks Sukhendu

13 août 2009 : Confusion surrounding "buffer busy waits" and "read by other session" wait events

Tom - I'm investigating a relatively minor but attention-getting issue that occurs from time to time around my workplace. I observe a few dozen identical queries (select only - no DML) generated by an Oracle Financials concurrent program being (...)

13 août 2009 : Help with Master -detail query.

Hi Tom, Is there a way we can do this in a efficient way using SQL: Take the case of the standard DEPT and EMP tables in scott schema. DEPT is the master table and EMP is the detail table: How to write a query that will give me the result (...)

13 août 2009 : high water mark

Tom: when i insert lots of data in a table and later on delete most of them, high water mark is high, if it is possible for me to deallocate those space? if so, can you tell me how? I know i can use alter table tableA deallocate (...)

12 août 2009 : Rolling count of difference

I have a table: create table t ( b date, c varchar2(30) ); with this data in it: insert into t values ( to_date( '01-jan-2004'), 'XXX' ); insert into t values ( to_date( '01-jan-2004'), 'YYY' ); insert into t values ( (...)

12 août 2009 : 10g - CBO only? What if "optimizer_goal=RULE"

Tom, We ship our product with Oracle databases in it to non-DBA customers environment. Our databases (multi-master replication) are still running RBO. We plan to move to 10g and I am trying to determine how to make the migration smooth (...)

12 août 2009 : Are private synonyms bad for performance?

Tom I have all tables in schema x and all users connect to the database as user y. I have created private synonyms owned by user y for every table owned by x. As a result, instead of select * from x.t1, users just have to type select * from (...)

8 août 2009 : What is the meaning of SQL*Net message from client

Can you please help interpreting this output? OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------ -------- ---------- ---------- ---------- (...)

8 août 2009 : Physical read

Hello Sir, http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:742710700346992804 In the above reply you does not change the default value of sort area retianed so its default to 65K (=sort_area_size) so when data is (...)

8 août 2009 : data encryption package

Tom: Would you please provide some examples for how to use dbms_obfuscation_toolkit ? -Thx -Reji

8 août 2009 : How do I determine how much storage will be required for NUMBER(p, s)?

Oracle Database SQL Language Reference states, "Each NUMBER value requires from 1 to 22 bytes." I was curious how much space a NUMBER(10, 0) would take, so I did: SQL> create table t (a number(10, 0)) 2 / Table created. SQL>...

8 août 2009 : Order by dbms_random.value

Hi tom, To display the random order of rows every time , I give SQL> select object_id from user_objects order by dbms_random.value It displays what I wanted. but if I give SQL> select object_id from user_objects order by .88439942 (...)

8 août 2009 : Balancing Instances and schemas

Dear Tom, In your literature I have read "each box deserves its own database", meaning is better to have a single instance running in a box than more. Is it safe to generalize that if I have say 100 schemas, it is better to have a single (...)

7 août 2009 : Database Help by Tom

Dear sir I need to know. How to Export table data in excel sheet through PL/SQL in oracle.

7 août 2009 : checking if all the tables in a schema are being used for something

Background: Database: Oracle 10.2.0.3 Platform: Windows 32 and 64 Bit Tom, Forgive me if I am asking a dumb question. Given a schema, I am trying to find out if every table in a schema is being used for something. When I say (...)

7 août 2009 : Sorting operation

Hello sir, yesterday i had ask question as below http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1855706000346866091 what happen when my sort area retained size is 0 (i.e. not set), will oracle spill to temp before (...)

6 août 2009 : Log of switchover/failover/open

What data dictionary view can be used to determine the number of times that a switchover/failover/open has occurred for a standby database?

6 août 2009 : In-house Oracle proxy versus Oracle client software

I have recently joined an application project that added database support for Oracle back around 8i. At that time, a decision was made to avoid installing the Oracle client software on every machine that ran the application. A decision was made (...)

6 août 2009 : Bookmark Followups too

Hi Tom, A short 'enhancement request' this time: It would come in very very handy for various reasons if it would be possible to bookmark followups as well, just like the reviews. Do you think that could become reality whenever a new (...)

6 août 2009 : Object relational impedance mismatch

What are your thoughts on the so called "object relational impedance mismatch"? http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch This seems to fuel the mentality that for an object oriented application to work people need (...)

6 août 2009 : or-IN-UNION

Hello Sir, with repect to below reply can in is equivalent to union all is that correct? http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1857846400346035462 Thanks

6 août 2009 : IF MY CONTROL FILE LOSS THEN HOW I RECOVER.

I LOST MY CONTROL FILE . I HAVE NO BACKUP HOW I RECOVER TH DATABASE. PLZ ANSWER ME .

6 août 2009 : Sql query/Function fto prevent insertion of data in a table if any rows has existing data

Hi, I have to write a sql query .The requirement is :I have a table called customer in which 4 columns are present cust_id (Primary key) Stock_Number cus_date Account_Number Now from my java code(Sql query is embedded in java code) I (...)

6 août 2009 : How can I get information of success or failure for individual record during bulk update and insert while using Pro*C

How can I get information of success or failure for individual record during bulk update and insert while using Pro*C. For instance, I have a table T1, which has 1000 records initially. In the application, the data buffer contains 1200 records (...)

6 août 2009 : Oracle SQL a declarative language?

Hello Tom, I have a general question about SQL query language, more specific to Oracle's SQL. Here is what wikipedia has to say: http://en.wikipedia.org/wiki/Declarative_programming "In computer science, declarative programming is a (...)

6 août 2009 : How to design Complete AskTom Offline

Hi Tom, Can you please guide me as to how to design AskTom website internally on my end with my Database and front end application so that I have access to it and It can take say daily feeds from your real website. What would be the (...)

6 août 2009 : Multiple production databases in a RAC cluster,

Hello, Our management is inclining towards sharing two production databases on a 3-node RAC cluster. Each node is very powerful in terms of capacity (like memory and CPU). The intention is to have RAC capabilities for both the databases. Each (...)

6 août 2009 : update using rownum

Hello Sir, say for example: update t set id=40 where id=1 and rownum=1 so when i select * from t where id in (1,40) will i get the first row with id=40? thanks

6 août 2009 : SQL Query

Good afternoon Tom, Recently I got a request, where two column values in a table should be displayed under one column. I know, with using UNION clause we can display the two column values under one column. Is there any (...)

6 août 2009 : Oracle not using Funcion based indexes after creation

Hello Tom, I have created two function based indexes on one table. when i try to run the query, expecting that it will use the FBI, it is not. It is doing a FTS again.I have set the appropriate parameters in the database. Not sure why the sql (...)

6 août 2009 : Definition of SQL statement execution

When we run a trace and TKPROF on a query (a select statement), we see timing information for three phases: 1. Parse 2. Execute 3. Fetch Can you clarify exactly what it means to "execute" a statement? The manual entry for TKPROF: (...)

6 août 2009 : Sorting operation

Respected Sir, I have learned lots from your site, thanks for your help to oracle community. 1)I have question regarding the sort operation in query, when the sort operation is performed as per sort_retain_* parameter oracle spill the (...)

5 août 2009 : 11g Apex Email not working from Sqlplus

Hi Tom, I can successfully send email from Apex application using apex_mail.send. When I try to use the same from sqlplus it gives the following Error BEGIN apex_mail.send (p_to => 'test@test.com', (...)

5 août 2009 : Is there some sort of nesting limit for correlated subqueries?

create table con ( content_id number); create table mat ( material_id number, content_id number, resolution number, file_location varchar2(50)); create table con_groups (content_group_id number, content_id number); insert into con (...)

5 août 2009 : SQL Loader - how to skip column in data file

I have a data file with the following data into table: 1,2,3 4,5,6 7,8,9 The table looks like this: SEQUENCE_NUM NUMBER(10), NUM1 NUMBER(10), NUM2 NUMBER(10), NUM3 NUMBER(10) I have a control (...)

5 août 2009 : spool file

I need to spool to a fixed length flat file. I have address line column with polish characters in the column,output of the file varies for each line because of the polish characters how to maintain length of column consistent.

5 août 2009 : dbms_xplan.DISPLAY_CURSOR versus SQL Trace!

I was reading Karen Morton's paper "Managing Statistics for Optimal Query Performance" http://karenmorton.blogspot.com/2009/02/new-paper-and-cj-date-advert.html and was enthralled by the idea that with DBMS_XPLAN.DISPLAY_CURSOR I can see (...)

5 août 2009 : index

Tom: I have a question regarding index. can you explain me in detail what the following means. If the index is a concatenation of multiple columns and one of the columns contains a NULL value, the row will be in the index column (...)

5 août 2009 : Archive log across network

Under windows 2000, is it safe to map a drive from another server to multiplex archived redo logs. Say I have drives D-H available on server A and then map drive N from server B, modify my init.ora to include an optional destination to N: (...)

4 août 2009 : granting GRANT ANY ROLE

Hi Tom, I have a user that will be the responsible for granting and revoking application's roles to others users (this user will be the application's administrator) . This task will be done using a package, and I've granted "GRANT ANY ROLE" (...)

29 juillet 2009 : WHy Some Database Envirenment I must user .world??

I have some confuse about Database TNS. Cause Some Database I must use .world after connection name to connect to database. If I not enter .world it error "can't resolve service name"

28 juillet 2009 : RMAN Multi Level Backups

Hi Tom, Is it possible to have multiple levels within incremental backups: e.g. level = 0 (monthly or quarterly - full backup) level =1 (weekly - from full back to eow) level =2 (daily) The reason I ask is - we have a 2.5 TB database and (...)