Oracle create tablespace segment space management manual

ORACLE-BASE - Oracle Automatic Segment Space Management

I was in a meeting yesterday and a guy asked if there was a way to track changes to database parameters (sometimes ed parameters by us old guys). They had a script that prompted for a parameter name and did a dump of all entries for the specified parameter.

Create tablespace for other user oracle - Stack Overflow

I thought for a second and said I didn’t think there was any sort of built in mechanism for doing that, no history table that I was aware of. So you could easily see where a change had occurred.

<b>Create</b> <b>Tablespace</b>

Virtual memory - pedia

Then one of the other guys in the meeting said, “oh yeah, we do that by looking at the AWR table that has the list of non-default parameter settings” (that table is WRH$_PARAMETER by the way). Looks like this: @parm_hist Enter value for pname: star_transformation_enabled SNAP_ID TIME PARAMETER_NAME VALUE ---------- --------------- -------------------------------------------------- -------------------- 2232 25-SEP-09 00 star_transformation_enabled FALSE 2233 25-SEP-09 01 star_transformation_enabled FALSE 2234 25-SEP-09 02 star_transformation_enabled FALSE 2235 25-SEP-09 03 star_transformation_enabled FALSE 2376 01-OCT-09 00 star_transformation_enabled FALSE 2377 01-OCT-09 01 star_transformation_enabled FALSE 2378 01-OCT-09 02 star_transformation_enabled FALSE 2379 01-OCT-09 03 star_transformation_enabled FALSE 2380 01-OCT-09 04 star_transformation_enabled FALSE 2381 01-OCT-09 05 star_transformation_enabled FALSE 2382 01-OCT-09 06 star_transformation_enabled FALSE 2383 01-OCT-09 07 star_transformation_enabled FALSE 2384 01-OCT-09 08 star_transformation_enabled FALSE 2385 01-OCT-09 09 star_transformation_enabled FALSE 2386 01-OCT-09 10 star_transformation_enabled FALSE 2387 01-OCT-09 11 star_transformation_enabled FALSE 3900 02-DEC-09 23 star_transformation_enabled TRUE 3901 03-DEC-09 00 star_transformation_enabled TRUE 3902 03-DEC-09 01 star_transformation_enabled TRUE 3903 03-DEC-09 02 star_transformation_enabled TRUE 3904 03-DEC-09 03 star_transformation_enabled TRUE 3905 03-DEC-09 04 star_transformation_enabled TRUE 3906 03-DEC-09 05 star_transformation_enabled TRUE 3907 03-DEC-09 06 star_transformation_enabled TRUE ...

Oracle CREATE TABLESPACE Tips

Of course my first thought was “that’s nice, but most systems only have a few weeks of history in AWR”.


Oracle create tablespace segment space management manual:

Rating: 95 / 100

Overall: 94 Rates