Reputation
5,066
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 15 29
Newest
 Enlightened
Impact
~273k people reached

5h
comment Oracle RAC takes forever dropping tables
Not normal tables, dictionary and fixed object stats. See the dbms_stats package.
1d
comment Oracle RAC takes forever dropping tables
Truncate. (Not that truncating is blazing fast, but you avoid some of the cost, and avoid the cost of re-creating them the next time the ETL job runs. And since creating the tables is in the "hot path" for your jobs, you might gain a bit of time on the process.) But that was a general comment, if it's for that sort of purpose, not really objectionable. Did you run the stats?
2d
comment Oracle RAC takes forever dropping tables
Check that your dictionary and fixed object stats are up to date. But dropping tables is expensive, and the time it takes shouldn't really matter - that's not something you should be doing regularly on a prod system.
2d
comment How to determine how much storage space a column takes in Oracle?
Not if you don't tell it to. There are various options for that depending on your scenario and your budget. Index compression works like you describe though.
2d
comment What is a good size to accommodate a single-use database for a small application?
Of course it's feasible. There's dozens of MySQL hosting providers out there already doing that (for free, or cheap, or not cheap; with different shapes, sizes and guarantees). Size is entirely up to you, but if you don't have a more precise use-case than that, then you'll have to take a guess and start with that.
2d
comment What is a good size to accommodate a single-use database for a small application?
I'm sorry your question isn't answerable. There's no such thing as an average database (in terms of size or complexity). And to handle "arbitrary many", you need infinite resources (cpu/ram/disk). You'll need to define your goals much more precisely, and once you've done that you'll have your sizing.
2d
answered How to determine how much storage space a column takes in Oracle?
2d
revised How to determine how much storage space a column takes in Oracle?
Please don't paste images unless it is necessary. Images aren't searchable.
Apr
28
revised Switching from Oracle database to Ubuntu
This is not a forum. If you want to leave an email address, put it in your profile.
Apr
28
comment Switching from Oracle database to Ubuntu
I'm sorry your question doesn't make sense. Ubuntu is an operating system, not a database.
Apr
28
comment LOAD DATA statement not working in Oracle SQL Developer
How are you running this? It's a sql*loader control file, you can't just run that in a SQL worksheet in SQL Developer. (Might be a menu somewhere to handle it though.)
Apr
28
revised LOAD DATA statement not working in Oracle SQL Developer
added 20 characters in body
Apr
25
comment When there is a composite index and those columns are in query, does it use index seek?
Are you sure you mean or there? That's a really funky selection filter.
Apr
24
revised Why is truncate DDL?
added 2 characters in body
Apr
24
comment How to select a column to compare two values in it with AND
How could reg be at the same time equal to two different things? You need or, not and.
Apr
23
comment I need the reason why we should not install SQL server on the domain controller
Migrating now to an OS version that's already out of mainstream support does not sound like a good idea.
Apr
22
comment Load file based on line number in sqlldr
Ah, I see. No idea if that's doable. You should edit those details into the question, that's rather important information.
Apr
22
comment Load file based on line number in sqlldr
You'll probably need two control files then, one for the header (I think there's a LINES option to limit number of lines processed), then Phil's SKIP option for the data load.
Apr
22
comment Load file based on line number in sqlldr
Do you actually need to do something with the header? Does the data load depend on what you did with the headeR?
Apr
21
comment ORA-01722 Error when running stored procedure
Well, what's the type of c.charges and c.payment?