You’ve got a big table…you want to add an index. Will you have enough space ?
Well, its not perfect but you can a reasonable approximation using DBMS_SPACE
SQL> drop table T purge; Table dropped. SQL> create table T nologging as 2 select d.* from dba_objects d, 3 ( select 1 from dual connect by level <= 100 ) 4 / Table created. SQL> select num_rows from user_tables where table_name = 'T'; NUM_ROWS ---------- SQL> set serverout on SQL> declare 2 x int; 3 y int; 4 begin 5 dbms_space.CREATE_INDEX_COST( 6 'create index ix on T ( owner, object_type, object_id)' 7 ,used_bytes=>x 8 ,alloc_bytes=>y); 9 dbms_output.put_line(x); 10 dbms_output.put_line(y); 11 end; 12 / 366481370 528482304 PL/SQL procedure successfully completed.
So not statistics, the estimate is about 500MB. Now we calculate stats
This is a reposting with some updates of a post from a couple of years ago. It is a huge decision to make at the beginning of a project as to which language to use and why. As the founder of Slideshare said when asked if he regretted not using Java instead of Ruby his response was that the question was mute, that he wouldn’t even be there talking if he had use Java. Sure Java would have scaled better and Ruby had concurrency issues but Slideshare would not have succeeded, at least not as fast, or possibly not even existed had they used Java.
Related is a discussion of functional programming verses object oriented programming
As several bloggers have already pointed out, column order changes when you start playing with invisible columns, for example
Delphix is a finalist for UKOUG partners of the year!
Finalists: UKOUG finalists for partner of the year
Vote here : UKOUG parnter of the year awards 2013
Also on the list are fellow Oaktable related organizations Scalabilities and Enkitec
What are your key reasons for choosing this category?
In new releases, its often the little things that really catch my attention.
Like this one…. I love it
SQL> alter system set enable_ddl_logging = true; System altered. SQL> create table t ( x int ); Table created. SQL> drop table t purge; Table dropped. SQL> host cat ddl_cdb12.log diag_adl:create table t ( x int ) diag_adl:drop table t purge
(Back to the Previous Post in the Series) As many readers of this blog are probably aware, Oracle Corporation has released Oracle Database 126.96.36.199 so far for the Linux, Solaris, and Windows platforms. Oracle Database 188.8.131.52 may be downloaded from Oracle’s OTN website. This article is not about Oracle Database 184.108.40.206, at least not specifically about that […]
This is not a complete how-to, because I do not think its warranted…you pretty much click Next Next Next (which in itself is a credit to the product)
But one thing to note – on the few machines I’ve installed it on, the installer gets to 100% and then just sits there for a LONG time.
If you click on the "Details" button, you’ll see the location of the installer log. The long pause is in the "Saving Inventory" phase…
So my advice is – just be patient. It will (eventually) get to the "Installation finished" message
A friend was recently describing Agile to me…I stress, not Agile the principle, but Agile the way its been implemented at their site…I thought I’d share it with you