A database storage unit that groups related logical structures together.
-1
votes
1answer
30 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
68 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
43 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
114 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 ...
1
vote
2answers
803 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
47 views
Partition of tablespace
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
132 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
125 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
695 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
273 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
293 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
72 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
185 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
525 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
540 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
397 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
100 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
64 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
391 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
103 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
2k 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
491 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
478 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
991 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
146 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
792 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
1k 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
81 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
164 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
749 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 ...
