389 reputation
210
bio website
location Milan, Italy
age 40
visits member for 3 years, 2 months
seen Oct 16 at 13:12

Jun
16
awarded  Notable Question
Mar
6
comment Oracle tsping.exe - where to get/download it
It's part of the client (not instant client) and database installations. In SQL Developer you may test a connection using jdbc (new connection -> <insert parameters> -> test.
Jan
14
comment How can I determine the maximum possible number of threads?
@Preston, good job! Thanks for sharing your analysis!
Jan
10
comment Replace MySQL table with data from csv
+1 for the truncate + load approach. I would do it this way: 1. Truncate. 2. Drop indexes. 3. Load (it should be faster without the indexes). 4. Recreate the indexes after the load.
Jan
10
comment How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?
I don't fully understand what you mean. What I mean is to separate schema owner and application user. These posts explain the concept: Schema Owners and Application Users and Grants to users.
Jan
10
comment How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?
Correct, but I thought that you wanted exactly that. I would do it in a different way: 1. Don't store application code in the sys schema, create another application user, let's say app_owner. 2. Grant app_owner the grants it needs to compile and run the code and then, if user0 is supposed to be able to execute app_owner's procedures, 3. grant execute on app_owner.procedure to user0.
Jan
10
answered How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?
Jan
10
revised How can I determine the maximum possible number of threads?
deleted 19 characters in body
Jan
10
comment How can I determine the maximum possible number of threads?
@Preston, I've updated my post. Thanks!
Jan
10
revised How can I determine the maximum possible number of threads?
added 5053 characters in body
Jan
9
answered How can I determine the maximum possible number of threads?
Jan
9
comment Delete data from huge InnoDB table from MySQL Master and Slaves
I suppose something like this:pt-archiver --source h=localhost,D=<db_name>,t=RTesAll,S=/path/to/socket_file --where "recordDate < current_date - interval 1 year" --limit=50000 --progress=50000 --purge --txn-size=50000 --statistics --bulk-delete --dry-run. You may also consider adding check-slave-lag etc. YOU SHOULD TEST THE COMMAND BEFORE USING IT IN PRODUCTION! Check this post also.
Jan
9
revised “Can't find file mysql/plugin.frm” when starting up MySQL
added 197 characters in body
Jan
9
comment Delete data from huge InnoDB table from MySQL Master and Slaves
Check pt-archiver.
Jan
9
answered “Can't find file mysql/plugin.frm” when starting up MySQL
Jan
9
comment Oracle ASM Failgroup
@user3134198, it means that you have a separate failure group for each asm disk. If, for example, your asm diskgroup contains 3 asm disks, you have 3 failure groups. Note that failure groups are relevant only when asm mirroring is used (i.e. for normal and high redundancy) and nowadays asm seems to be used mainly with external redundancy. For more detailed information check the official documentation.
Jan
9
comment Finding why an Oracle listener got automatically restarted
It seems that a service stopped responding service_died * fmm * 12537, and - a shot in the dark here - a connection from host EM-A (Enterprise Manager?) stopped and restarted the listener. Is this a RAC or it's a single instance?
Jan
8
answered Why is the System tablespace in manual segment space management mode?
Jan
8
revised MySQL:How to correct a corrupted MySQL binary log on Master server?
deleted 1 characters in body
Jan
8
comment Oracle 12c Enterprise Manager Database Express Subsequent Installation von Windows Server 2012
Glad to hear it. Check the actual https port with: select dbms_xdb_config.gethttpsport() from dual;.