How can you reduce the space of TEMP datafile?

How can you reduce the space of TEMP datafile?
by

1 Answer

Answer :

Prior to Oracle 11g, you had to recreate the datafile. In Oracle 11g a new feature was introduced and you can  shrink the TEMP tablespace.
by

Related questions

What is a datafile?

Description : What is a datafile?

Last Answer : Every Oracle database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.

Can you make a Datafile auto extendible? If yes how?

Description : Can you make a Datafile auto extendible? If yes how?

Last Answer : YES. A Datafile can be auto extendible. Here's how to enable auto extend on a Datafile: SQL>alter database datafile '/u01/app/oracle/product/10.2.0/oradata/DBSID/EXAMPLE01.DBF' autoextend on; ... 'alter database datafile '|| file_name|| ' '|| ' autoextend on;' from dba_data_files; SQL>@runts

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

How can we reduce the network traffic?

Description : How can we reduce the network traffic?

Last Answer : Replication of data in distributed environment. - Using snapshots to replicate data. - Using remote procedure calls.

What view would you use to determine free space in a tablespace?

Description : What view would you use to determine free space in a tablespae?

Last Answer : DBA_FREE_SPACE

Is space acquired in blocks or extents ?

Description : Is space acquired in blocks or extents ?

Last Answer : In extents

Table Space,Data Files,Parameter File, Control Files

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

How will you monitor the space allocation ?

Description : How will you monitor the space allocation ?

Last Answer : By querying DBA_SEGMENT table/view.

How will you estimate the space required by a non- clustered tables?

Description : How will you estimate the space required by a non- clustered tables?

Last Answer : Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows ... add 10 % additional space to calculate the initial extent size for a working table.

How does Space allocation table place within a block ?

Description : How does Space allocation table place within a block ?

Last Answer : Each block contains entries as follows Fixed block header Variable block header Row Header,row date (multiple rows may exists) PCTEREE (% of free space for row updation in future)

How will you swap objects into a different table space for an existing database ?

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

What are the dictionary tables used to monitor a database space?

Description : What are the dictionary tables used to monitor a database space?

Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

How do I find used/free space in a TEMPORARY tablespace? (for DBA

Description : How do I find used/free space in a TEMPORARY tablespace? (for DBA

Last Answer : Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view: SELECT tablespace_name, SUM (bytes used), SUM (bytes free) FROM V$temp_space_header GROUP BY tablespace_name;

How does one coalesce free space?(for DBA)

Description : How does one coalesce free space?(for DBA)

Last Answer : SMON coalesces free space (extents) into larger, contiguous extents every 2 hours and even then, only for a short period of time. SMON will not coalesce free space if a tablespace's default storage ... from SELECT TS#, NAME FROM SYS.TS$; You can get status information about this process by se

What is Automatic Management of Segment Space setting?

Description : What is Automatic Management of Segment Space setting?

Last Answer : Oracle9i New Feature Series: Automatic Segment Space Management Automatic Segment Space Management (ASSM) introduced in Oracle9i is an easier way of managing space in a segment using bitmaps. It ... . ASSM can be specified only with the locally managed tablespaces (LMT). Oracle uses bitmaps

Is a temperature fluctuation like this possible, or is the temp reader on my car malfunctioning?

Description : Is a temperature fluctuation like this possible, or is the temp reader on my car malfunctioning?

Last Answer : The rain storm caused the coolant in the radiator to cool down more than you are used to. When the thermostat opened up, the cooler coolant made the temp gauge go down. Your temp gauge reads ... sure it doesn't read in centigrade/Celsius? If it was Fahrenheit it would read about 180 degrees.

Human Extremeties Temp Well Below Ambient?

Description : Human Extremeties Temp Well Below Ambient?

Last Answer : Poor circulation frequently can cause such a feeling. You might want to mention this to your doctor so they can check your circulation. I find taking a Vitamin E capsule every morning helps my circulation. Welcome to Fluther!!!

What is the proper way to drink sipping ******, room temp, or on the rocks?

Description : What is the proper way to drink sipping Whisky, room temp, or on the rocks?

Last Answer : answer:Personal choice. You forgot spring/branch water. You can also sip whiskey with a splash of water, room temp or with ice. How to Drink Whiskey

Should I apply for another job since I've been a temp for a year?

Description : Should I apply for another job since I've been a temp for a year?

Last Answer : I would go ahead and start looking now. It always seems easier to find a job when you have a job. You also can be a little more picky since you won't be desperate to get just any job. In ... give him an ultimatum. Don't even tell him you are looking elsewhere. You may find yourself without a job.

Should I still look for other work if I accepted a temp-to-hire position?

Description : Should I still look for other work if I accepted a temp-to-hire position?

Last Answer : Also, do most places wait until you’re completely permanent until your vacation/sick time off hours start accruing??

Thermostat in my car was changed and the temp. gauge still rises, what can my problem be?

Description : Thermostat in my car was changed and the temp. gauge still rises, what can my problem be?

Last Answer : There are a lot of different things that could cause this: clogged radiator, bad water pump, problem with the AC compressor, and many more. There isn't enough information to give a good diagnosis. The fact that ... . It's a good idea to get it checked anyway, so that the engine doesn't blow up.

Is 96.8 body temp normal?

Description : Is 96.8 body temp normal?

Last Answer : answer:I sure hope you mean Fahrenheit, because if it is then it's just 1 degree below 37-the normal body temperature. You probably have some sort of mild poisoning I'm guessing. ... temperature) that are related to stomach pains. Alcohol poisoning causes hypothermia-have you been drinking a lot?

Career advice needed - temp to perm situation?

Description : Career advice needed - temp to perm situation?

Last Answer : Tell the truth.

For how long and at what temp do I bake chicken breasts?

Description : For how long and at what temp do I bake chicken breasts?

Last Answer : Wrap in foil, 400 degrees for 30 mins.

How long does it take for Brazillian Cherry Hardwood flooring to acclimate to room temp before installed?

Description : How long does it take for Brazillian Cherry Hardwood flooring to acclimate to room temp before installed?

Last Answer : The longer the better, but at least a week.

What are some good Temp Agencies for tech companies in Los Angeles?

Description : What are some good Temp Agencies for tech companies in Los Angeles?

Last Answer : This one is pretty good. I worked for them in Florida.

How do taxes work when you use an online temp/assistant service?

Description : How do taxes work when you use an online temp/assistant service?

Last Answer : Yes, you can handle that as a business expense. You put it in Schedule C, which you file for your business to determine profit or Loss.

Take a temp job I love or stay at my internship I started two weeks ago?

Description : Take a temp job I love or stay at my internship I started two weeks ago?

Last Answer : answer:In the current job market, stay with the internship. A favorite quote of mine is: It is not important that you do what you love, so much as you love what you do.

High white cell count, abdominal pain & high temp?

Description : High white cell count, abdominal pain & high temp?

Last Answer : Wow, I would be very upset at not being listened to. These symptoms can mean anything from kidney stones to an ectopic pregnancy. You need to get a second opinion.

Who should I call to find temp work for Thanksgiving?

Description : Who should I call to find temp work for Thanksgiving?

Last Answer : Maybe check craigslist? Or go around asking stores in person, even call if you’d like. Places may be looking for a few weeks or around a month of temp work vs. a few days. However it never hurts to try!

My temp. is at 98.1, and i have chills. yesterday i had a fever of 100.4. then today after lowering it shot back up to 101 degrees. what does that mean?

Description : My temp. is at 98.1, and i have chills. yesterday i had a fever of 100.4. then today after lowering it shot back up to 101 degrees. what does that mean?

Last Answer : Are you taking medicine like ibuprofen or tylenol for the fever? Also, are you sick? Or you just have a fever?

Why do fish need to be brought into room temp water?

Description : Why do fish need to be brought into room temp water?

Last Answer : Because the water that they came from was room temp, the water in the bag is room temp and if you drop a fish in different temp water you could shock it and kill it.

Why does the temp of water matter when washing clothes?

Description : Why does the temp of water matter when washing clothes?

Last Answer : With certain temperatures the fabric reacts by shrinking, fading etc. It really depends what you’re washing. What is it? – and I can refine my answer.

I am getting unemployment, if I can get freelance work (which will temp. decrease my weekly check) will that increase the length of time I can receive it?

Description : I am getting unemployment, if I can get freelance work (which will temp. decrease my weekly check) will that increase the length of time I can receive it?

Last Answer : Yes. This just happened to us (different state, but these rules are the same). There is an amount you have “banked,” if you will. When you work and your benefit is reduced, your still have the balance available. So when you run out of work, and you can reopen your claim.

In NYC, which temp agency have you recently worked for and really liked? (and, if you feel like saying, about how much did you make?)

Description : In NYC, which temp agency have you recently worked for and really liked? (and, if you feel like saying, about how much did you make?)

Last Answer : Here is a good place to find reviews for Temp Agencies in New York. http://www.tempcity.com/discus/messages/2/2.html

IT temp-to-hire contract positions, are they worth the risk?

Description : IT temp-to-hire contract positions, are they worth the risk?

Last Answer : answer:Go to the interview and see what sense you get of the company and of the people you'd be working with. That may decide things even faster than the contract terms. The usual reason for contract to hire ... risk. If either one is a maybe or a no, then you should think twice about it.

Why don't refrigerated foods spoil as quickly as food at room temp?

Description : Why don't refrigerated foods spoil as quickly as food at room temp?

Last Answer : That is correct most bacteria don’t multiply at lower temperature as rapidly. Specificly at temps below 40 degrees they really slow down or go dormant.

What are the best Mac/PC Temp agencies out there?

Description : What are the best Mac/PC Temp agencies out there?

Last Answer : http://losangeles.zami.com/employment_agency

How do you find temp agencies?

Description : How do you find temp agencies?

Last Answer : Google, Yellow pages, newspaper

How can I retreive a file that I mistakenly saved to a temp file?

Description : How can I retreive a file that I mistakenly saved to a temp file?

Last Answer : I’m not sure how you could save it as a temp file. Have you tried checking the recently opened files. I believe it is under File in Word.

What is better: room temp water or ice water?

Description : What is better: room temp water or ice water?

Last Answer : Room temp. I got sensitive teeth and i love to gulp water down

I MUST MOVE MY DAYLILIES ON SEPT 1ST IN KY TEMP IS 98 CAN IT BE DONE?

Description : I MUST MOVE MY DAYLILIES ON SEPT 1ST IN KY TEMP IS 98 CAN IT BE DONE?

Last Answer : Need Answer

low temp for cauliflower plants ?

Description : low temp for cauliflower plants ?

Last Answer : Need Answer

what is low temp for plumeria?

Description : what is low temp for plumeria?

Last Answer : Need Answer

when do I prune a rose bush that got caught in ice and freezing temp

Description : when do I prune a rose bush that got caught in ice and freezing temp

Last Answer : Need Answer

Should I pick my green tomatoes if the temp is 55°

Description : Should I pick my green tomatoes if the temp is 55°

Last Answer : Sounds like it is time to take them off. It needs to be at least 70 degrees for them to ripen correctly. Some people made tomatoes pickled or green relish. Fried green tomatoes are great and easy to make.

at what temp will my begonias be harmed?

Description : at what temp will my begonias be harmed?

Last Answer : 30 Degrees? Yes it will be best if you cover your plants in plastic when the sun is out that way they stay warm during the night, and are still alive in the morning -Birdy

should i cover my petunias when the temp drops to 3 degrees

Description : should i cover my petunias when the temp drops to 3 degrees

Last Answer : Yes and make sure they are well watered beforehand.

what is the temp of Neptune does Neptune have water you can drink?

Description : what is the temp of Neptune does Neptune have water you can drink?

Last Answer : the temp of Neptune is -360 f and Neptune does have drinking water that humans can drink Neptune is a really good place to explor over your life it is the best place ever my dad went past Neptune in his ... and i am not lying about all of this fun stuff to learn the world is a big place to explor.

my home furnac will run and stop at the right temp but will not come back on later

Description : my home furnac will run and stop at the right temp but will not come back on later

Last Answer : Need Answer