1,991 reputation
2820
bio website arsanukaev.blogspot.com
location Grozny, Chechen Republic, Russia
age 28
visits member for 3 years, 9 months
seen 2 days ago

A programmer (loves Haskell, Erlang, Scheme)

A DBA (mostly Oracle)

Oracle Database Administrator Certified Associate

Passed Oracle Database OCP exam recently

One of my best answers: "Practical use of curried functions?"

On Twitter.


Oct
4
awarded  Famous Question
Sep
6
comment oracle tablespaces
Did you try to set quota to 0 on USER tablespace before importing data? For example, alter user YOURUSERNAME quota 0 on tablespace users. If the user doesn't have the necessary quota on the tablespace where the data should be imported from the dump file, then the data is imported in default tablespace set for the user, e. g. alter user YOURUSERNAME default tablespace newtbs. Check this out docs.oracle.com/cd/E11882_01/server.112/e22490/…
Sep
3
comment Mysql performance tunning
Better be asked on dba.se
Aug
28
comment Oracle Buffer Pool TARGET_SIZE is different from CURRENT_SIZE, but RESIZE_STATE is STATIC
Does querying v$memory_resize_ops and dba_hist_memory_resize_ops reveal anything interesting?
Aug
24
comment While altering tablespace shows error tablespace does not exist
Can you check if select name, dump(name) from v$tablespace where name = upper('example') gives the same name (EXAMPLE) as in your first query?
Aug
22
reviewed No Action Needed Copying datadir directory enough for backing up a database with InnoDB tables?
Aug
21
comment SQL Server Database is corrupted
Chances are that your database file was damaged too. I would try to perform complete database recovery (if possible) from backup.
Aug
21
answered Oracle sys password lost
Aug
21
reviewed No Action Needed How can I use parameters of type Int32 from an environment for an integration services package in a SQL Server 2008 job?
Aug
21
comment Delete all the data from all tables
The question obviously has "oracle" tag.
Aug
21
comment Delete all the data from all tables
Or better TRUNCATE instead of DELETE FROM – there's really no need to generate extra redo vectors in the redo log if all you want to do is just get rid of the data.
Aug
21
reviewed No Action Needed How to create a Postgres trigger to ensure field is non-updateable
Aug
21
reviewed No Action Needed Denormalization Strategies: When is it appropriate to create redundancy for faster querying?
Aug
21
answered oracle tablespaces
Aug
19
reviewed No Action Needed MySQL: What are the pros and cons of running with engine=Memory vs on a memory-mapped filesystem?
Aug
19
reviewed No Action Needed Convert yymmdd to datetime using ssis derived column
Aug
19
reviewed No Action Needed How to append value of column with double quotes (add quotes around string)
Aug
19
reviewed No Action Needed Oracle error 12154 while importing DMP file
Aug
19
reviewed No Action Needed How to move 200 materialized views without having to re-create in the new home
Aug
19
reviewed No Action Needed How do I ORDER BY typical software release versions like X.Y.Z?