A database storage unit that groups related logical structures together.
0
votes
1answer
49 views
Tablespaces in oracle
I understand that tablespace is a logical collection of tables and database objects. It could be made up of multiple data files (which is the physical collection of objects). Apart from this, what is ...
1
vote
1answer
32 views
Oracle, Create table with inline constraint declarations using a different tablespace
I have two questions about inline constraints declarations for Oracle tables:
Is it a bad practice? If so, why?
How could one declare a different tablespace for the primary key and index like it's ...
1
vote
1answer
49 views
db2 LUW help for an oracle user : create database hangs without any output, but database got created
I am new to db2 but have worked on oracle before. Trying to create a database and it succeeds, but the session where I issued a database creation command hangs.
I have installed db2 10.5 on a 64 bit ...
0
votes
1answer
47 views
Any advantage of creating table in temporary tablespace - Oracle
My on-site DBA told me to create the particular table on temporary tablespace.Is there any advantage of such action?
0
votes
1answer
70 views
DB2 LUW: Should temporary tablespaces share bufferpools with other tablespaces?
We are in the process of tuning a massive application our company has just written. Part of that tuning includes tuning the databases. We run DB2 LUW on AIX. Specifically we are at 9.7 Fix Pack 4 ...
-1
votes
1answer
58 views
How to put one table on one disk and anther table on another (a ramdisk)?
I need to build a database with one table stored on one disk and anther table stored on a different disk (a ramdisk).
Is it possible to do it?
As far as I know, using two separate databases, one ...
1
vote
1answer
457 views
Oracle database created whats next? Create Schema or Create Tablespace?
I'm a programmer that's being thrown to the DBA/Sysadmin island all by myself with a volleyball that I named Wilson. I'm trying to survive here.
I'm supposed to create a database for an application. ...
1
vote
1answer
103 views
Why we need auxiliary instance in TSPITR
Need help!
I've read Database Backup and Recovery User's Guide 11g but I can't uderstand why we need auxiliary instance to perform tspitr.
We can do complete recovery of tablespace within same ...
2
votes
1answer
249 views
DB2 Server Table Space Locked
At work we keep receiving the following DataException seemingly at random when one of our processes tries to write/access a table for one of our clients:
com.ibm.db.DataException: A database manager ...
2
votes
2answers
3k views
“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?
Earlier I created a user :
SQL>create user suhail identified by password
SQL>User created.
SQL>Grant create session,create table to suhail;
SQL>Grant Succeeded.
but when I login as ...
1
vote
1answer
63 views
Partition of tablespace [closed]
My postgres server is running in a windows server and three tablespace are created. Postgresql server is installed in C: drive and the tablespaces are in D: and E: drive. So how to take a backup and ...
2
votes
1answer
229 views
How to create Buffer Pool in Database dedicated only for ONE BIG table?
I have table TICKET with 400K records in database (DB2).
I wish to create one huge buffer pool which will be dedicated only to this one big table for faster response. What are the steps to do it?
...
1
vote
1answer
178 views
Oracle delete technique for table's segment size (data compactness)
I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before:
...
2
votes
1answer
2k views
Expanding system tablespace
I need to add new data file into the system tablespace because its running out of space. Are there any precautionary measures I should consider since this is a production environment?
3
votes
1answer
640 views
Moving postgresql data to different drive
I am using AWS as my cloud environment. I installed PostgreSQL on the same drive as my root instance volume. I have attached and mounted the second drive to my instance. Now I want to move all my ...
1
vote
1answer
465 views
Why is DBA_SEGMENTS presenting twice the amount of data than the DBA_TABLES?
I tried to compute the audit log table usage using the following steps:
Truncate all the audit log table data (i.e. AUD$)
Perform test case that inserts and update data, also delete statement but it ...
1
vote
1answer
100 views
How to measure improvement after splitting tablespaces into multiple disk volumes? (Oracle 10g AWR)
I have a recently released 10 000 user analytical application that is suffering from performance issues because of excessive amount of transactions. Apart from re writing many of the SQLs in the ...
1
vote
0answers
203 views
How do I import a dump for a deleted tablespace?
I'm trying to import a database dump, however I am encountering this error:
ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error:
ORA-00959: tablespace '_$deleted$5$0' does not ...
2
votes
5answers
729 views
Does 'Cities' deserve a separate table?
I have the following Customers table:
customer_id - int
company_name - nvarchar
street - nvarchar
city - nvarchar
comments - nvarchar
The app will only be used in part of one small country ...
2
votes
1answer
753 views
Drop user did not reduce size of tablespace file
I have a development environment in which I frequently copy a certain schema.
When I'm done with the copy, I will use OracleEM to drop that user/schema.
My problem is that this does not seem to ...
3
votes
1answer
574 views
DB2: Is it good to create the index table space to use 32 KB data page
I found our DB2 server configs all the index into one table space. And it then defines the table space to use 32kb data page. Is this good? How to judge it? Any advice is welcome.
2
votes
1answer
114 views
DB2: Is it good to create the LONG table space to use 32 KB data page
Our DB2 database(V9.7) has only defined one table space to store all the big object like xml.
And xml size could be different. Some are about 2kb average. And some are 7kb average.
So does it make ...
2
votes
1answer
69 views
Why does connecting to a database use tempspace?
Earlier today we had a problem logging into a database that had just been created automatically.
When on the actual box (Linux) sqlplus schema/pw, i.e. a local connection, was fine, though, it was ...
0
votes
2answers
2k views
In Oracle how do you move a Schema to a different Tablespace?
I noticed that a Schema has been created in the USERS Tablespace but our local rule is that it should be in a Tablespace by itself. In Oracle how do you move a Schema to a different Tablespace?
1
vote
1answer
520 views
Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces
Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size?
Even more, what should apply for ...
1
vote
1answer
141 views
file not found - how to remove its configuration?
I run oracle 10.2.0.5.
I have the following:
SQL> select file#, status, error, recover, tablespace_name, name
2 from v$datafile_header
3 where recover='YES'
4 or (RECOVER IS NULL AND ...
3
votes
1answer
3k views
What units used in DBA_TABLESPACE_USAGE_METRICS?
What units are used in the usage metrics (USED_SPACE and TABLESPACE_SIZE columns) described in Oracle's DBA_TABLESPACE_USAGE_METRICS static data dictionary view?
The Oracle Database Reference only ...
8
votes
2answers
597 views
Recovering logical space from a tablespace
I have a tablespace called DATA, and it is setup with auto-extend as false. This tablespace has two datafiles and is set up so it takes up 350 GB of physical space.
A week ago I queried ...
3
votes
2answers
584 views
Is Tablespace something like Logical Volume?
I'm confused about tablespaces in PostgreSQL. Is it something like LVM? I mean when disk is getting full, can we add another disk, format and then CREATE TABLESPACE tblspace LOCATION ...
3
votes
1answer
1k views
How can I delete a corrupted table space?
Problem:
On an Oracle 11.2g DB;
We have a corrupted TS that does not allow starting the database instance above mount state. The TS cannot be removed with standard methods (i.e., enterprise manager).
...
1
vote
1answer
155 views
Oracle block usage
I am wondering about a weird deadlock and after checking all other components I am considering it to be a INITRANS problem in Oracle 11.2.
Now three questions arose:
Is there some way of analyzing ...
3
votes
1answer
994 views
DB2 9.5 How to get tablespace monitor information?
How can I get information about tablespace in DB2 9.5?
I need to review information about if the autoresize option is enabled or disabled.
2
votes
1answer
2k views
How do I create a database+tablespace+user in Oracle 11gR2?
Good evening,
I'm trying to figure out how to create a database+tablespace+user in Oracle 11g.
I've tried some tutorials, but nothing seems to work.
I cannot find Database Configuration Assistant ...
1
vote
1answer
84 views
How can I measure the performance hit of tablespace autoextensions?
I'm not a DBA, nor is there a DBA on the project I'm currently working, so we have tablespaces with autoextend on next 6m. I have no idea if this is low, although I believe so.
I want to measure ...
2
votes
1answer
189 views
Tablespace consumed by views
I was in an SQL class where the instructor said "DBAs don't like it when users create views, because they will clobber tablespace."
Obviously, I understand that any schema object will consume some ...
3
votes
2answers
890 views
What are the benefits of using a different tablespace for a new user schema?
The tables in the schema are intended to be used read only and is only updated once each three month.
My question refers to
performance
maintenance (backup/restore, export/import)
What about the ...
